Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AGE	Calculated Age (subtract the birth date from the current system date).	NUMBER	FUNCTION	F_CALCULATE_AGE
BIRTH_DATE	Date of birth for the person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE
ETHNICITY_EDI_EQUIV	EDI/SPEEDE ethnicity code that equates to the ethnic code.	VARCHAR2(63)	STVETHN	STVETHN_EDI_EQUIV
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
GENDER	Gender of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_SEX
GENDER_DESC	Gender code description.	VARCHAR2(63)	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.	VARCHAR2(63)	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.	VARCHAR2(1)	SPBPERS	SPBPERS_ETHN_CODE
ID	Person's identification number used to access the records associated with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
IMMIGRATION_STATUS	Indicates whether immigration information has been received by the institution.	VARCHAR2(63)	GOBINTL	GOBINTL_I94_STATUS
IMMIGRATION_STATUS_DATE	Date the person was admitted to or departed the country.	DATE	GOBINTL	GOBINTL_I94_DATE
LAST_NAME	Person's last name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME
LEGACY	Legacy code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_LGCY_CODE
LEGACY_DESC	Legacy code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MARITAL_STATUS	Marital status code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_MRTL_CODE
MARITAL_STATUS_DESC	Marital status description associated with the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MEDICAL_INFORMATION_COUNT	Number of medical information records for the person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_MEDICAL_INFORMATION
MIDDLE_NAME	Person's middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI
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
PRIMARY_DISABILITY	Primary or first major disability for the person because of this handicap.	VARCHAR2(63)	SPRMEDI	SPRMEDI_DISA_CODE
PRIMARY_DISABILITY_DESC	Disability type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_DISABILITY_SERVICE	Type of disability service available to the person from the institution because of the disability noted.	VARCHAR2(63)	SPRMEDI	SPRMEDI_SPSR_CODE
PRIMARY_ETHNICITY	Ethnicity used for institutional standard reporting.	VARCHAR2(63)	SPBPERS	SPBPERS_ETHN_CODE
PRIMARY_ETHNICITY_DESC	Ethnicity code description.	VARCHAR2(255)	STVETHN	STVETHN_DESC
PRIMARY_MEDICAL_CONDITION	Primary or first major medical condition associated with the person.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MEDI_CODE
PRIMARY_MEDICAL_CONDITION_DESC	Medical condition description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_MEDICAL_EQUIPMENT	Medical equipment required because of the person's medical problem.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MDEQ_CODE
PRIMARY_MEDICAL_EQUIPMENT_DESC	Medical equipment description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIM_DISABILITY_SERVICE_DESC	Disability service description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIM_ETHNICITY_CATEGORY	Ethnic category used for governmental and other standard types of reporting.	VARCHAR2(63)	STVETHN	STVETHN_ETCT_CODE
PRIM_ETHNICITY_CATEGORY_DESC	Ethnic category description.	VARCHAR2(255)	STVETCT	STVETCT_DESC
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RACE_CATEGORY_COUNT	Number of unique regulatory races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE_CATEGORY
RACE_COUNT	Number of races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE
RACE_ETHNICITY_CONFIRM_DATE	Race and ethnicity self confirmed date.	DATE	SPBPERS	SPBPERS_CONFIRMED_RE_DATE
RACE_ETHNICITY_CONFIRM_IND	Indicates if the person's race and ethnicity have been self-identified.	VARCHAR2(1)	SPBPERS	SPBPERS_CONFIRMED_RE_CDE
RELIGION	Religious affiliation recorded for the person.	VARCHAR2(63)	SPBPERS	SPBPERS_RELG_CODE
RELIGION_DESC	Person's religious affiliation description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN

Ver: 8.1