Target Column	Business Definition	Database Data Type	Source Name	Source Column
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	Preferred email address of the person.	VARCHAR2(128)	GOREMAL	GOREMAL_EMAIL_ADDRESS
EMAIL_PREFERRED_DESC	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
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	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	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME
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(1)	SPBPERS	SPBPERS_SEX
GENDER_DESC	Gender code description.	VARCHAR2(12)	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(9)	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_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	A second identification number assign to a person.	VARCHAR2(9)	NA	NA
ID_NUMBER3	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
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 associated with person.	VARCHAR2(500)	SPBPERS	SPBPERS_LEGAL_NAME
MAILING_NAME_FORMAL	Person's formalized name including prefix and suffix.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME
MAILING_NAME_INFORMAL	Person's informal name using nickname if available.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME
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 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	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 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	Person's preferred name.	VARCHAR2(63)	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	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(60)	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: 8.1