Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AGE	Calculated Age (subtract the birth date from the current system date).	NUMBER	FUNCTION	F_CALCULATE_AGE	NO	NO
BIRTH_DATE	Date of birth for the person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE	NO	NO
ETHNICITY_EDI_EQUIV	EDI/SPEEDE ethnicity code that equates to the ethnic code.	VARCHAR2(63)	STVETHN	STVETHN_EDI_EQUIV	NO	NO
FIRST_NAME	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME	NO	NO
FOREIGN_TAX_ID	Unique identification number for tax purposes from a country outside the institution's home country.	VARCHAR2(63)	GOBINTL	GOBINTL_FOREIGN_SSN	NO	NO
FULL_NAME_LFMI	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME	NO	NO
GENDER	Identifies the gender of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_SEX	NO	NO
GENDER_DESC	Gender code description.	VARCHAR2(63)	CALCULATION	DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')	NO	NO
GENDER_DESIGNATION	This gender identity of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_GNDR_CODE	NO	NO
GENDER_DESIGNATION_DESC	The description of the gender identity.	VARCHAR2(255)	GTVGNDR	GTVGNDR_GNDR_DESC	NO	NO
GOVERNMENT_ID	Identification assigned by the institution's home government when the tax id is from a different government.	VARCHAR2(63)	NA	NA	NO	NO
HISPANIC_LATINO_ETHNICITY_IND	Indicates if person's ethnicity is Latino or Hispanic.This one ethnicity group was identified as a federal reporting group for ethnicity and race categories.	VARCHAR2(1)	SPBPERS	SPBPERS_ETHN_CDE	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
IMMIGRATION_STATUS	Indicates whether immigration information has been received by the institution.	VARCHAR2(63)	GOBINTL	GOBINTL_I94_STATUS	NO	NO
IMMIGRATION_STATUS_DATE	Date the person was admitted to or departed the country.	DATE	GOBINTL	GOBINTL_I94_DATE	NO	NO
LAST_NAME	Person's last name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
LEGACY	Legacy code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_LGCY_CODE	NO	NO
LEGACY_DESC	Legacy code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MARITAL_STATUS	Marital status code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_MRTL_CODE	NO	NO
MARITAL_STATUS_DESC	Marital status description associated with the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MEDICAL_INFORMATION_COUNT	Number of medical information records for the person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_MEDICAL_INFORMATION	NO	NO
MIDDLE_NAME	Person's middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PERSONAL_PRONOUN	The personal pronoun of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_PPRN_CODE	NO	NO
PERSONAL_PRONOUN_DESC	The description of the personal pronoun.	VARCHAR2(255)	GTVPPRN	GTVPPRN_PPRN_DESC	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SPBPERS	SPBPERS_PIDM	NO	NO
PRIMARY_DISABILITY	Disability recorded for the person that is identified as the primary disability.	VARCHAR2(63)	SPRMEDI	SPRMEDI_DISA_CODE	NO	NO
PRIMARY_DISABILITY_DESC	Disability type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
PRIMARY_ETHNICITY	Ethnicity used for institutional standard reporting.	VARCHAR2(63)	SPBPERS	SPBPERS_ETHN_CODE	NO	NO
PRIMARY_ETHNICITY_DESC	Ethnicity code description.	VARCHAR2(255)	STVETHN	STVETHN_DESC	NO	NO
PRIMARY_MEDICAL_CONDITION	Primary or first major medical condition associated with the person.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MEDI_CODE	NO	NO
PRIMARY_MEDICAL_CONDITION_DESC	Medical condition description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PRIMARY_MEDICAL_EQUIPMENT	Medical equipment required because of the person's medical problem.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MDEQ_CODE	NO	NO
PRIMARY_MEDICAL_EQUIPMENT_DESC	Medical equipment description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PRIM_DISABILITY_SERVICE_DESC	Disability service description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PRIM_ETHNICITY_CATEGORY	Ethnic category used for governmental and other standard types of reporting.	VARCHAR2(63)	STVETHN	STVETHN_ETCT_CODE	NO	NO
PRIM_ETHNICITY_CATEGORY_DESC	Ethnic category description.	VARCHAR2(255)	STVETCT	STVETCT_DESC	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
RACE_CATEGORY_COUNT	Number of unique regulatory races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE_CATEGORY	NO	NO
RACE_COUNT	Number of races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE	NO	NO
RACE_ETHNICITY_CONFIRM_DATE	Race and ethnicity self confirmed date.	DATE	SPBPERS	SPBPERS_CONFIRMED_RE_DATE	NO	NO
RACE_ETHNICITY_CONFIRM_IND	Indicates if the person's race and ethnicity have been self-identified.	VARCHAR2(1)	SPBPERS	SPBPERS_CONFIRMED_RE_CDE	NO	NO
RELIGION	Religious affiliation recorded for the person.	VARCHAR2(63)	SPBPERS	SPBPERS_RELG_CODE	NO	NO
RELIGION_DESC	Person's religious affiliation description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN	NO	NO

Ver: 9.2