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

SGHE 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
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BIRTH_DATE Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

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

NA

NA

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

SPBPERS

SPBPERS_CONFID_IND

DECEASED_DATE Date the person died. DATE

SPBPERS

SPBPERS_DEAD_DATE

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

SPBPERS

SPBPERS_DEAD_IND

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

SPRIDEN

SPRIDEN_FIRST_NAME

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

GOBINTL

GOBINTL_FOREIGN_SSN

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

FUNCTION

F_FORMAT_NAME

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

NA

NA

LAST_NAME Person's last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

MIDDLE_NAME Person's middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

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

NA

NA

MILITARY_SEPARATION_DATE Date the person left active military service. DATE

SPBPERS

SPBPERS_ACTIVE_DUTY_SEPR_DATE

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

NA

NA

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

NA

NA

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

SPBPERS

SPBPERS_PIDM

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

NA

NA

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

SPBPERS

SPBPERS_SSN

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

SPBPERS

SPBPERS_VERA_IND

VETERAN_CATEGORY_DESC Person's veteran category description. VARCHAR2(63)

CALCULATION

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

VETERAN_FILE_NUMBER Veteran administration assigned identification number. VARCHAR2(255)

SPBPERS

SPBPERS_VETC_FILE_NUMBER

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

SPBPERS

SPBPERS_SDVET_IND



Ver: 8.5