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 Name Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BIRTH_DATE Birth Date Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

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

NA

NA

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

SPBPERS

SPBPERS_CONFID_IND

DECEASED_DATE Deceased Date Date the person died. DATE

SPBPERS

SPBPERS_DEAD_DATE

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

SPBPERS

SPBPERS_DEAD_IND

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

SPRIDEN

SPRIDEN_FIRST_NAME

FOREIGN_TAX_ID 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 Full Name Last, First, Middle Initial Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

F_FORMAT_NAME

GOVERNMENT_ID 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 Last Name Person's last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

MIDDLE_NAME Middle Name Person's middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

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

NA

NA

MILITARY_SEPARATION_DATE Military Separation Date Date the person left active military service. DATE

SPBPERS

SPBPERS_ACTIVE_DUTY_SEPR_DATE

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

NA

NA

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

NA

NA

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

SPBPERS

SPBPERS_PIDM

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

NA

NA

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

SPBPERS

SPBPERS_SSN

VETERAN_CATEGORY 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 Veteran Category Description 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)

VETERAN_FILE_NUMBER Veteran File Number Veteran administration assigned identification number. VARCHAR2(255)

SPBPERS

SPBPERS_VETC_FILE_NUMBER

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

SPBPERS

SPBPERS_SDVET_IND



Ver: 9.2