| 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
|
|
|
AGE
|
Calculated Age (subtract the birth date from the current system date).
|
|
|
FUNCTION
|
F_CALCULATE_AGE
|
|
|
BIRTH_DATE
|
Date of birth for the person.
|
|
|
SPBPERS
|
SPBPERS_BIRTH_DATE
|
|
|
ETHNICITY_EDI_EQUIV
|
EDI/SPEEDE ethnicity code that equates to the ethnic code.
|
|
|
STVETHN
|
STVETHN_EDI_EQUIV
|
|
|
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
|
|
|
GENDER
|
Gender of the person.
|
|
|
SPBPERS
|
SPBPERS_SEX
|
|
|
GENDER_DESC
|
Gender code description.
|
|
|
CALCULATION
|
DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')
|
|
|
GOVERNMENT_ID
|
Identification assigned by the institution's home government when the tax id is from a different government.
|
|
|
NA
|
NA
|
|
|
HISPANIC_LATINO_ETHNICITY_IND
|
Indicates if person's ethnicity is Latino or Hispanic. Due to mandated changes to the collection of race and ethnicity, these classifications were changed to separate Race and Ethnicity. Ethnicity can now be defined as either Hispanic or Latino, or Not Hispanic or Latino.
|
|
|
SPBPERS
|
SPBPERS_ETHN_CODE
|
|
|
ID
|
Person's identification number used to access the records associated with the person.
|
|
|
SPRIDEN
|
SPRIDEN_ID
|
|
|
IMMIGRATION_STATUS
|
Indicates whether immigration information has been received by the institution.
|
|
|
GOBINTL
|
GOBINTL_I94_STATUS
|
|
|
IMMIGRATION_STATUS_DATE
|
Date the person was admitted to or departed the country.
|
|
|
GOBINTL
|
GOBINTL_I94_DATE
|
|
|
LAST_NAME
|
Person's last name.
|
|
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
|
LEGACY
|
Legacy code of the person.
|
|
|
SPBPERS
|
SPBPERS_LGCY_CODE
|
|
|
LEGACY_DESC
|
Legacy code description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
MARITAL_STATUS
|
Marital status code of the person.
|
|
|
SPBPERS
|
SPBPERS_MRTL_CODE
|
|
|
MARITAL_STATUS_DESC
|
Marital status description associated with the person.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
MEDICAL_INFORMATION_COUNT
|
Number of medical information records for the person.
|
|
|
FUNCTION
|
MSKFUNC.F_COUNT_MEDICAL_INFORMATION
|
|
|
MIDDLE_NAME
|
Person's middle name.
|
|
|
SPRIDEN
|
SPRIDEN_MI
|
|
|
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
|
|
|
PRIMARY_DISABILITY
|
Primary or first major disability for the person because of this handicap.
|
|
|
SPRMEDI
|
SPRMEDI_DISA_CODE
|
|
|
PRIMARY_DISABILITY_DESC
|
Disability type description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
PRIMARY_DISABILITY_SERVICE
|
Type of disability service available to the person from the institution because of the disability noted.
|
|
|
SPRMEDI
|
SPRMEDI_SPSR_CODE
|
|
|
PRIMARY_ETHNICITY
|
Ethnicity used for institutional standard reporting.
|
|
|
SPBPERS
|
SPBPERS_ETHN_CODE
|
|
|
PRIMARY_ETHNICITY_DESC
|
Ethnicity code description.
|
|
|
STVETHN
|
STVETHN_DESC
|
|
|
PRIMARY_MEDICAL_CONDITION
|
Primary or first major medical condition associated with the person.
|
|
|
SPRMEDI
|
SPRMEDI_MEDI_CODE
|
|
|
PRIMARY_MEDICAL_CONDITION_DESC
|
Medical condition description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
PRIMARY_MEDICAL_EQUIPMENT
|
Medical equipment required because of the person's medical problem.
|
|
|
SPRMEDI
|
SPRMEDI_MDEQ_CODE
|
|
|
PRIMARY_MEDICAL_EQUIPMENT_DESC
|
Medical equipment description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
PRIM_DISABILITY_SERVICE_DESC
|
Disability service description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
PRIM_ETHNICITY_CATEGORY
|
Ethnic category used for governmental and other standard types of reporting.
|
|
|
STVETHN
|
STVETHN_ETCT_CODE
|
|
|
PRIM_ETHNICITY_CATEGORY_DESC
|
Ethnic category description.
|
|
|
STVETCT
|
STVETCT_DESC
|
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
|
|
NA
|
NA
|
|
|
RACE_CATEGORY_COUNT
|
Number of unique regulatory races selected by this person.
|
|
|
FUNCTION
|
MGKFUNC.F_COUNT_RACE_CATEGORY
|
|
|
RACE_COUNT
|
Number of races selected by this person.
|
|
|
FUNCTION
|
MGKFUNC.F_COUNT_RACE
|
|
|
RACE_ETHNICITY_CONFIRM_DATE
|
Race and ethnicity self confirmed date.
|
|
|
SPBPERS
|
SPBPERS_CONFIRMED_RE_DATE
|
|
|
RACE_ETHNICITY_CONFIRM_IND
|
Indicates if the person's race and ethnicity have been self-identified.
|
|
|
SPBPERS
|
SPBPERS_CONFIRMED_RE_CDE
|
|
|
RELIGION
|
Religious affiliation recorded for the person.
|
|
|
SPBPERS
|
SPBPERS_RELG_CODE
|
|
|
RELIGION_DESC
|
Person's religious affiliation description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
TAX_ID
|
Person's tax identification number assigned by their home federal government.
|
|
|
SPBPERS
|
SPBPERS_SSN
|
|