Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

Banner Operational Data Store
Reporting View Target: PERSON_VETERAN

Description Contains information on persons who are veterans as indicated in the ERP system.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
BIRTH_DATE Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

NO

NO
CONFIDENTIALITY_COMMENT Specifies what information the person has requested be confidential. VARCHAR2(255)

NA

NA

NO

NO
CONFIDENTIALITY_IND Specifies whether the person has requested the institution keep some of their information confidential. VARCHAR2(1)

SPBPERS

SPBPERS_CONFID_IND

NO

NO
DECEASED_DATE Date the person died. DATE

SPBPERS

SPBPERS_DEAD_DATE

NO

NO
DECEASED_STATUS Indicates whether a person is deceased. VARCHAR2(1)

SPBPERS

SPBPERS_DEAD_IND

NO

NO
FIRST_NAME Person's first or given name. VARCHAR2(63)

SPRIDEN

SPRIDEN_FIRST_NAME

NO

NO
FOREIGN_TAX_ID Unique identification number for tax purposes from a country outside the institution's home country. VARCHAR2(63)

GOBINTL

GOBINTL_FOREIGN_SSN

NO

NO
FULL_NAME_LFMI Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

F_FORMAT_NAME

NO

NO
GOVERNMENT_ID Identification assigned by the institution's home government when the tax id is from a different government. VARCHAR2(63)

NA

NA

NO

NO
LAST_NAME Person's last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

NO

NO
MIDDLE_NAME Person's middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

NO

NO
MILITARY_BRANCH Branch of military service for the veteran information. VARCHAR2(255)

NA

NA

NO

NO
MILITARY_SEPARATION_DATE Date the person left active military service. DATE

SPBPERS

SPBPERS_ACTIVE_DUTY_SEPR_DATE

NO

NO
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SPBPERS

SPBPERS_PIDM

NO

NO
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
TAX_ID Person's tax identification number assigned by their home federal government. VARCHAR2(63)

SPBPERS

SPBPERS_SSN

NO

NO
VETERAN_CATEGORY Category of veteran. Standardized by the federal government to track attendance of particular groups. VARCHAR2(1)

SPBPERS

SPBPERS_VERA_IND

NO

NO
VETERAN_CATEGORY_DESC Person's veteran category description. VARCHAR2(255)

CALCULATION

DECODE(SPBPERS_VERA_IND, NULL, NULL, O, OTHER PROTECTED VETERAN ONLY, V, VIETNAM VETERAN ONLY, B, BOTH - VIETNAM AND OTHER ELIGIBLE VETERAN)

NO

NO
VETERAN_FILE_NUMBER Veteran administration assigned identification number. VARCHAR2(255)

SPBPERS

SPBPERS_VETC_FILE_NUMBER

NO

NO
VETERAN_SPECIAL_DISABLED_IND Indicates whether the person has been qualified as a disabled veteran. VARCHAR2(1)

SPBPERS

SPBPERS_SDVET_IND

NO

NO


Ver: 9.2