ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
BIRTH_DATE	Date of birth for the person.			SPBPERS	SPBPERS_BIRTH_DATE
CONFIDENTIALITY_COMMENT	Specifies what information the person has requested be confidential.			NA	NA
CONFIDENTIALITY_IND	Specifies whether the person has requested the institution keep some of their information confidential.			SPBPERS	SPBPERS_CONFID_IND
DECEASED_DATE	Date the person died.			SPBPERS	SPBPERS_DEAD_DATE
DECEASED_STATUS	Indicates whether a person is deceased.			SPBPERS	SPBPERS_DEAD_IND
FIRST_NAME	Person's first or given name.			SPRIDEN	SPRIDEN_FIRST_NAME
FOREIGN_TAX_ID	Unique identification number for tax purposes from a country outside the institution's home country.			GOBINTL	GOBINTL_FOREIGN_SSN
FULL_NAME_LFMI	Combination of the person's last, first, and middle initial into one value.			FUNCTION	F_FORMAT_NAME
GOVERNMENT_ID	Identification assigned by the institution's home government when the tax id is from a different government.			NA	NA
LAST_NAME	Person's last name.			SPRIDEN	SPRIDEN_LAST_NAME
MIDDLE_NAME	Person's middle name.			SPRIDEN	SPRIDEN_MI
MILITARY_BRANCH	Branch of military service for the veteran information.			NA	NA
MILITARY_SEPARATION_DATE	Date the person left active military service.			SPBPERS	SPBPERS_ACTIVE_DUTY_SEPR_DATE
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.			SPBPERS	SPBPERS_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
TAX_ID	Person's tax identification number assigned by their home federal government.			SPBPERS	SPBPERS_SSN
VETERAN_CATEGORY	Category of veteran. Standardized by the federal government to track attendance of particular groups.			SPBPERS	SPBPERS_VERA_IND
VETERAN_CATEGORY_DESC	Person's veteran category description.			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.			SPBPERS	SPBPERS_VETC_FILE_NUMBER
VETERAN_SPECIAL_DISABLED_IND	Indicates whether the person has been qualified as a disabled veteran.			SPBPERS	SPBPERS_SDVET_IND

Ver: 8.3