Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ALTERNATIVE_ID_COUNT	Alternative ID Count	Count of the number of alternative IDs recorded for this person or organization entity.	NUMBER		GORADID	GORADID_ADDITIONAL_ID
BIRTH_DATE		Date of birth for the person.	DATE		SPBPERS	SPBPERS_BIRTH_DATE
CHILDREN_NUMBER		Number of children recorded for this person.	NUMBER(2)		GOBINTL	GOBINTL_CHILD_NUMBER
CITIZENSHIP_DESC		Citizen type description.	VARCHAR2(30)		STVCITZ	STVCITZ_DESC
CITIZENSHIP_EDI_EQUIV		Citizenship type used for the electronic data transfer.	VARCHAR2(2)		STVCITZ	STVCITZ_EDI_EQUIV
CITIZENSHIP_IND		Indicates whether the person has been identified as a citizen of the institution's home country.	VARCHAR2(1)		STVCITZ	STVCITZ_CITIZEN_IND
CITIZENSHIP_TYPE		Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(2)		SPBPERS	SPBPERS_CITZ_CODE
CONFIDENTIALITY_COMMENT		Specifies what information the person has requested be confidential.	VARCHAR2(0)		NA	NA
CONFIDENTIALITY_IND		Specifies whether the person has requested the institution keep some of their information confidential.	VARCHAR2(1)		SPBPERS	SPBPERS_CONFID_IND
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DECEASED_DATE		Date the person died.	DATE		SPBPERS	SPBPERS_DEAD_DATE
DECEASED_STATUS		Indicates whether a person is deceased.	VARCHAR2(1)		SPBPERS	SPBPERS_DEAD_IND
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
DURATION_OF_STAY		Indicates whether the admission or departure is for the duration of the stay.	VARCHAR2(1)		GOBINTL	GOBINTL_DURATION
EMAIL_PREFERRED		Type of mail address recorded as preferred.	VARCHAR2(4)		GOREMAL	GOREMAL_EMAL_CODE
EMAIL_PREFERRED_ADDRESS	Email Preferred Address	Preferred email address of the person.	VARCHAR2(128)		GOREMAL	GOREMAL_EMAIL_ADDRESS
EMAIL_PREFERRED_DESC	Email Preferred Description	Email address preferred description.	VARCHAR2(60)		GTVEMAL	GTVEMAL_DESC
EMPLOYMENT_TYPE		Type of employment recorded for the person.	VARCHAR2(3)		GOBINTL	GOBINTL_EMPT_CODE
EMPLOYMENT_TYPE_DESC		Person's type of employment description.	VARCHAR2(30)		STVEMPT	STVEMPT_DESC
ENTITY_ACTIVITY_DATE	Entity Activity Date	Date record was inserted or updated.	DATE		SPRIDEN	SPRIDEN_ACTIVITY_DATE
ENTITY_CREATE_DATA_ORIGIN	Entity Create Data Origin	Source process or system that created this record.	VARCHAR2(30)		SPRIDEN	SPRIDEN_DATA_ORIGIN
ENTITY_CREATE_DATE	Entity Create Date	Date that this record was created, either manually or through data load.	DATE		SPRIDEN	SPRIDEN_CREATE_DATE
ENTITY_CREATE_USER	Entity Create User	ID of the person who created this record.	VARCHAR2(30)		SPRIDEN	SPRIDEN_CREATE_USER
ENTITY_ORIGIN	Entity Origin	Source process or system that created or updated this record.	VARCHAR2(30)		SPRIDEN	SPRIDEN_ORIGIN
ENTITY_UPDATE_USER	Entity Update User	User who made the last updated to this record.	VARCHAR2(30)		SPRIDEN	SPRIDEN_USER
ETHNICITY_EDI_EQUIV		EDI/SPEEDE ethnicity code that equates to the ethnic code.	VARCHAR2(1)		STVETHN	STVETHN_EDI_EQUIV
FIRST_NAME		Person's first or given name.	VARCHAR2(60)		SPRIDEN	SPRIDEN_FIRST_NAME
FOREIGN_SSN	Foreign Tax ID	Unique identification number for tax purposes, such as a foreign tax identification number (SSN, TIN, etc.).	VARCHAR2(15)		GOBINTL	GOBINTL_FOREIGN_SSN
FULL_NAME_FMIL	Full Name First, Middle Initial, Last	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)		FUNCTION	F_FORMAT_NAME
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
GENDER		Gender of the person.	VARCHAR2(1)		SPBPERS	SPBPERS_SEX
GENDER_DESC		Gender code description.	VARCHAR2(12)		CALCULATION	DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')
GOVERNMENT_ID	Government ID	Identification assigned by the institution's home government when the tax id is from a different government.	VARCHAR2(9)		NA	NA
HISPANIC_LATINO_ETHNICITY_IND	Hispanic Latino Ethnicity Indicator	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
ID_NUMBER		Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(9)		SPRIDEN	SPRIDEN_ID
ID_NUMBER2	ID Number 2	A second identification number assign to a person.	VARCHAR2(9)		NA	NA
ID_NUMBER3	ID Number 3	A third identification number assign to a person.	VARCHAR2(9)		NA	NA
ID_NUMBER_SOURCE		Name of the source ERP system that provided the value in the ID field.	VARCHAR2(6)		CALCULATION	DECODE(SPRIDEN_ID,NULL,NULL,'BANNER')
IMMIGRATION_STATUS		Indicates whether immigration information has been received by the institution.	VARCHAR2(3)		GOBINTL	GOBINTL_I94_STATUS
IMMIGRATION_STATUS_DATE		Date the person was admitted to or departed the country.	DATE		GOBINTL	GOBINTL_I94_DATE
LAST_NAME		Last name of the person.	VARCHAR2(60)		SPRIDEN	SPRIDEN_LAST_NAME
LAST_NAME_PREFIX	Last Name Prefix	Last name prefix of the person.	VARCHAR2(60)		SPRIDEN	SPRIDEN_SURNAME_PREFIX
LEGACY		Code that identifies if the person has a legacy relationship.	VARCHAR2(1)		SPBPERS	SPBPERS_LGCY_CODE
LEGACY_DESC		Legacy code description.	VARCHAR2(30)		STVLGCY	STVLGCY_DESC
LEGAL_NAME	Legal Name	Legal name associated with person.	VARCHAR2(500)		SPBPERS	SPBPERS_LEGAL_NAME
MAILING_NAME_FORMAL	Mailing Name Formal	Person's formalized name including prefix and suffix.	VARCHAR2(255)		SPRIDEN	SPRIDEN_LAST_NAME
MAILING_NAME_INFORMAL	Mailing Name Informal	Person's informal name using nickname if available.	VARCHAR2(255)		SPRIDEN	SPRIDEN_LAST_NAME
MAILING_NAME_PREFERRED	Mailing Name Preferred	Person's preferred mailing name.	VARCHAR2(255)		SPRIDEN	SPRIDEN_LAST_NAME
MARITAL_STATUS		Marital status code of the person.	VARCHAR2(1)		SPBPERS	SPBPERS_MRTL_CODE
MARITAL_STATUS_DESC		Marital status description associated with the person.	VARCHAR2(30)		STVMRTL	STVMRTL_DESC
MIDDLE_INITIAL		Person's current name middle initial.	VARCHAR2(1)		CALCULATION	SUBSTR(SPRIDEN_MI,1,1)
MIDDLE_NAME	Middle Name	Middle name of the person.	VARCHAR2(60)		SPRIDEN	SPRIDEN_MI
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
MILITARY_BRANCH		Branch of military service for the veteran information.	VARCHAR2(0)		NA	NA
MILITARY_SEPARATION_DATE		Date the person left active military service.	DATE		NA	NA
NAME_PREFIX	Name Prefix	Prefix associated with the person's name.	VARCHAR2(20)		SPBPERS	SPBPERS_NAME_PREFIX
NAME_SUFFIX		Suffix for the person's name.	VARCHAR2(20)		SPBPERS	SPBPERS_NAME_SUFFIX
NAME_TYPE		Category of the name specified.	VARCHAR2(4)		SPRIDEN	SPRIDEN_NTYP_CODE
NAME_TYPE_DESC		Name type, e.g., professional, married, maiden, etc.	VARCHAR2(30)		GTVNTYP	GTVNTYP_DESC
NATION_OF_BIRTH		Country code of the nation of the person's birth.	VARCHAR2(5)		GOBINTL	GOBINTL_NATN_CODE_BIRTH
NATION_OF_BIRTH_DESC		Nation/country of birth description for the person.	VARCHAR2(30)		STVNATN	STVNATN_NATION
NATION_OF_CITIZENSHIP		First country code of the nation where the person maintains citizenship.	VARCHAR2(5)		GOBINTL	GOBINTL_NATN_CODE_LEGAL
NATION_OF_CITIZENSHIP2		Second country code of the nation where the person maintains citizenship.	VARCHAR2(0)		NA	NA
NATION_OF_CITIZENSHIP_DESC		Nation/country of citizenship description for the person.	VARCHAR2(30)		STVNATN	STVNATN_NATION
NATION_OF_CITIZENSHIP_DESC2		Country code description for the person's second nation of citizenship.	VARCHAR2(0)		NA	NA
NATIVE_LANGUAGE		Native language code of the person.	VARCHAR2(3)		GOBINTL	GOBINTL_LANG_CODE
NATIVE_LANGUAGE_DESC		Person's native language code description.	VARCHAR2(30)		STVLANG	STVLANG_DESC
NICKNAME		Nickname used by the person.	VARCHAR2(40)		SPRIDEN	SPRIDEN_LAST_NAME
PASSPORT_CERTIF_DATE_ISSUE		Date the passport certification was issued.	DATE		GOBINTL	GOBINTL_CERT_DATE_ISSUE
PASSPORT_CERTIF_DATE_RECVD		Date the passport certification was received.	DATE		GOBINTL	GOBINTL_CERT_DATE_RECEIPT
PASSPORT_CERTIF_ELIG		Passport certification eligibility code.	VARCHAR2(6)		GOBINTL	GOBINTL_CELG_CODE
PASSPORT_CERTIF_ELIG_DESC		Passport certification eligibility code description.	VARCHAR2(30)		GTVCELG	GTVCELG_DESC
PASSPORT_CERTIF_NUMBER		Passport certification number.	VARCHAR2(11)		GOBINTL	GOBINTL_CERT_NUMBER
PASSPORT_EXPIRE_DATE		Date the person's passport expires.	DATE		GOBINTL	GOBINTL_PASSPORT_EXP_DATE
PASSPORT_ID	Passport ID	Passport identification number.	VARCHAR2(25)		GOBINTL	GOBINTL_PASSPORT_ID
PASSPORT_ISSUE_NATION		Nation code issuing the passport of the person.	VARCHAR2(5)		GOBINTL	GOBINTL_NATN_CODE_ISSUE
PASSPORT_ISSUE_NATION_DESC		Nation issuing the passport description.	VARCHAR2(30)		STVNATN	STVNATN_NATION
PASSPORT_REGISTRATION_NO		Passport registration number of the person.	VARCHAR2(11)		GOBINTL	GOBINTL_REG_NUMBER
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		SPRIDEN	SPRIDEN_PIDM
PREFERRED_FIRST_NAME	Preferred First Name	Person's preferred name.	VARCHAR2(60)		SPBPERS	SPBPERS_PREF_FIRST_NAME
PRIMARY_ETHNCITY_CATEGORY		Ethnic category used for governmental and other standard types of reporting.	VARCHAR2(1)		STVETHN	STVETHN_ETCT_CODE
PRIMARY_ETHNCITY_CATEGORY_DESC		Ethnic category description.	VARCHAR2(30)		STVETCT	STVETCT_DESC
PRIMARY_ETHNICITY		Ethnicity used for institutional standard reporting.	VARCHAR2(2)		SPBPERS	SPBPERS_ETHN_CODE
PRIMARY_ETHNICITY_DESC		Ethnicity code description.	VARCHAR2(30)		STVETHN	STVETHN_DESC
PRIM_DISABILITY		Primary or first major disability for the person because of this handicap.	VARCHAR2(2)		SPRMEDI	SPRMEDI_DISA_CODE
PRIM_DISABILITY_DESC		Disability type description.	VARCHAR2(30)		STVDISA	STVDISA_DESC
PRIM_DISABILITY_SERVICE		Identifies a type of disability service available to the person from the institution because of the disability noted.	VARCHAR2(2)		SPRMEDI	SPRMEDI_SPSR_CODE
PRIM_DISABILITY_SERVICE_DESC		Description of the disability service provided.	VARCHAR2(30)		STVSPSR	STVSPSR_DESC
PRIM_MEDICAL_CONDITION		This field identifies the medical code associated with the person.	VARCHAR2(10)		SPRMEDI	SPRMEDI_MEDI_CODE
PRIM_MEDICAL_CONDITION_DESC		Medical condition description.	VARCHAR2(30)		STVMEDI	STVMEDI_DESC
PRIM_MEDICAL_EQUIPMENT		Medical equipment required because of the person's medical problem.	VARCHAR2(3)		SPRMEDI	SPRMEDI_MDEQ_CODE
PRIM_MEDICAL_EQUIPMENT_DESC		Medical equipment description.	VARCHAR2(30)		STVMDEQ	STVMDEQ_DESC
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
RELEASE_INFORMATION_COMMENT		What requested information about that person can be released.	VARCHAR2(0)		NA	NA
RELIGION		Religious affiliation recorded for the person.	VARCHAR2(2)		SPBPERS	SPBPERS_RELG_CODE
RELIGION_DESC		Person's religious affiliation description.	VARCHAR2(30)		STVRELG	STVRELG_DESC
SIGNATURE_IND		Indicates whether a signature is on file to release of funds for the international student.	VARCHAR2(1)		GOBINTL	GOBINTL_SIGNATURE_IND
SPONSOR_OF_PERSON		Identifies the sponsor for an international student or staff member.	VARCHAR2(3)		GOBINTL	GOBINTL_SPON_CODE
SPONSOR_OF_PERSON_DESC		Description associated with the person's sponsor code.	VARCHAR2(30)		STVSPON	STVSPON_DESC
SPOUSE_ACCOMPANIED_IND		Indicates whether the spouse accompanied this person entering the institution home country.	VARCHAR2(1)		GOBINTL	GOBINTL_SPOUSE_IND
TAX_ID	Tax ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(15)		SPBPERS	SPBPERS_SSN
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		The description of the Veteran Category column.	VARCHAR2(255)		CALCULATION	DECODE(SPBPERS_VERA_IND)
VETERAN_FILE_NO		Veteran administration assigned identification number.	VARCHAR2(10)		SPBPERS	SPBPERS_VETC_FILE_NUMBER
VETERAN_SPECIAL_DISABLED_IND		Indicates whether the person has been qualified as a disabled veteran.	VARCHAR2(1)		SPBPERS	SPBPERS_SDVET_IND
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: