Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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	GOBINTL	GOBINTL_CHILD_NUMBER
CITIZENSHIP_DESC	Citizen type description.	VARCHAR2(255)	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 is 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(63)	SPBPERS	SPBPERS_CITZ_CODE
CONFIDENTIALITY_COMMENT	Specifies what information the person has requested be confidential.	VARCHAR2(255)	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_AGE	Age of the person as of today's date.	NUMBER	FUNCTION	MGKFUNC.F_CALCULATE_AGE(SYSDATE, BIRTH_DATE, DECEASED_DATE),
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
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(63)	GOREMAL	GOREMAL_EMAL_CODE
EMAIL_PREFERRED_ADDRESS	Preferred email address of the person.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAIL_ADDRESS
EMAIL_PREFERRED_DESC	Email address preferred description.	VARCHAR2(255)	GTVEMAL	GTVEMAL_DESC
EMPLOYMENT_TYPE	Type of employment recorded for the person.	VARCHAR2(63)	GOBINTL	GOBINTL_EMPT_CODE
EMPLOYMENT_TYPE_DESC	Person's type of employment description.	VARCHAR2(255)	STVEMPT	STVEMPT_DESC
ENTITY_ACTIVITY_DATE	Date record was inserted or updated.	DATE	SPRIDEN	SPRIDEN_ACTIVITY_DATE
ENTITY_CREATE_DATA_ORIGIN	Source process or system that created this record.	VARCHAR2(63)	SPRIDEN	SPRIDEN_DATA_ORIGIN
ENTITY_CREATE_DATE	Date that this record was created, either manually or through data load.	DATE	SPRIDEN	SPRIDEN_CREATE_DATE
ENTITY_CREATE_USER	ID of the person who created this record.	VARCHAR2(63)	SPRIDEN	SPRIDEN_CREATE_USER
ENTITY_ORIGIN	Source process or system that created or updated this record.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ORIGIN
ENTITY_UPDATE_USER	User who made the last updated to this record.	VARCHAR2(63)	SPRIDEN	SPRIDEN_USER
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_SSN	Unique identification number for tax purposes, such as a foreign tax identification number (SSN, TIN, etc.).	VARCHAR2(63)	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	Identifies the 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')
GENDER_DESIGNATION	This gender identity of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_GNDR_CODE
GENDER_DESIGNATION_DESC	The description of the gender identity.	VARCHAR2(255)	GTVGNDR	GTVGNDR_GNDR_DESC
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.This one ethnicity group was identified as a federal reporting group for ethnicity and race categories.	VARCHAR2(1)	SPBPERS	SPBPERS_ETHN_CDE
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
ID2	A second identification number assign to a person.	VARCHAR2(63)	NA	NA
ID3	A third identification number assign to a person.	VARCHAR2(63)	NA	NA
ID_SOURCE	Name of the source ERP system that provided the value in the ID field.	VARCHAR2(63)	CALCULATION	DECODE(SPRIDEN_ID,NULL,NULL,'BANNER')
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	Last name of the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME
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(63)	SPBPERS	SPBPERS_LGCY_CODE
LEGACY_DESC	Legacy code description.	VARCHAR2(255)	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)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_INFORMAL	Person's informal name using nickname if available.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_PREFERRED	Person's preferred mailing name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
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)	STVMRTL	STVMRTL_DESC
MEDICAL_INFORMATION_COUNT	Number of medical information records for the person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_MEDICAL_INFORMATION
MIDDLE_INITIAL	Person's current name middle initial.	VARCHAR2(15)	CALCULATION	SUBSTR(SPRIDEN_MI,1,1)
MIDDLE_NAME	Middle name of the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI
MILITARY_BRANCH	Branch of military service for the veteran information.	VARCHAR2(255)	NA	NA
MILITARY_SEPARATION_DATE	Date the person left active military service.	DATE	SPBPERS	SPBPERS_ACTIVE_DUTY_SEPR_DATE
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
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(63)	SPRIDEN	SPRIDEN_NTYP_CODE
NAME_TYPE_DESC	Name type, e.g., professional, married, maiden, etc.	VARCHAR2(255)	GTVNTYP	GTVNTYP_DESC
NATION_OF_BIRTH	Country code of the nation of the person's birth.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_BIRTH
NATION_OF_BIRTH_DESC	Nation/country of birth description for the person.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_OF_CITIZENSHIP	Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_LEGAL
NATION_OF_CITIZENSHIP2	Second country code of the nation where the person maintains citizenship.	VARCHAR2(63)	NA	NA
NATION_OF_CITIZENSHIP_DESC	Nation/country of citizenship description for the person.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_OF_CITIZENSHIP_DESC2	Country code description for the person's second nation of citizenship.	VARCHAR2(255)	NA	NA
NATIVE_LANGUAGE	Native language code of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_LANG_CODE
NATIVE_LANGUAGE_DESC	Person's native language code description.	VARCHAR2(255)	STVLANG	STVLANG_DESC
NICKNAME	Nickname used by the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_PREFERRED_DATA
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(63)	GOBINTL	GOBINTL_CELG_CODE
PASSPORT_CERTIF_ELIG_DESC	Passport certification eligibility code description.	VARCHAR2(255)	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(63)	GOBINTL	GOBINTL_PASSPORT_ID
PASSPORT_ISSUE_NATION	Nation code issuing the passport of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_ISSUE
PASSPORT_ISSUE_NATION_DESC	Nation issuing the passport description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
PASSPORT_REGISTRATION_NO	Passport registration number of the person.	VARCHAR2(11)	GOBINTL	GOBINTL_REG_NUMBER
PERSONAL_PRONOUN	The personal pronoun of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_PPRN_CODE
PERSONAL_PRONOUN_DESC	The description of the personal pronoun.	VARCHAR2(255)	GTVPPRN	GTVPPRN_PPRN_DESC
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SPRIDEN	SPRIDEN_PIDM
PREFERRED_FIRST_NAME	Person's preferred name.	VARCHAR2(63)	SPBPERS	SPBPERS_PREF_FIRST_NAME
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
PRIM_DISABILITY	Primary or first major disability for the person because of this handicap.	VARCHAR2(63)	SPRMEDI	SPRMEDI_DISA_CODE
PRIM_DISABILITY_DESC	Disability type description.	VARCHAR2(255)	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(63)	SPRMEDI	SPRMEDI_SPSR_CODE
PRIM_DISABILITY_SERVICE_DESC	Disability service description.	VARCHAR2(255)	STVSPSR	STVSPSR_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
PRIM_MEDICAL_CONDITION	Primary or first major medical condition associated with the person.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MEDI_CODE
PRIM_MEDICAL_CONDITION_DESC	Medical condition description.	VARCHAR2(255)	STVMEDI	STVMEDI_DESC
PRIM_MEDICAL_EQUIPMENT	Medical equipment required because of the person's medical problem.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MDEQ_CODE
PRIM_MEDICAL_EQUIPMENT_DESC	Medical equipment description.	VARCHAR2(255)	STVMDEQ	STVMDEQ_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
RELEASE_INFORMATION_COMMENT	Field specifies what information about them the person has requested that can be released.	VARCHAR2(2000)	NA	NA
RELIGION	Religious affiliation recorded for the person.	VARCHAR2(63)	SPBPERS	SPBPERS_RELG_CODE
RELIGION_DESC	Person's religious affiliation description.	VARCHAR2(255)	STVRELG	STVRELG_DESC
SALUTATIONS_COUNT	Count of the number of salutations recorded for the person that may be used in correspondence.	NUMBER	FUNCTION	MSKFUNC.F_GET_SALUTATIONS_COUNT
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(63)	GOBINTL	GOBINTL_SPON_CODE
SPONSOR_OF_PERSON_DESC	Person's sponsor code description.	VARCHAR2(255)	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(63)	SPBPERS	SPBPERS_SSN
VETERAN_CATEGORY	Veteran category as standardized by the federal government to track attendance of particular veteran types or groups.	VARCHAR2(1)	SPBPERS	SPBPERS_VERA_IND
VETERAN_CATEGORY_DESC	Person's veteran category description.	VARCHAR2(255)	CALCULATION	DECODE(SPBPERS_VERA_IND,NULL,NULL,'VETERAN')
VETERAN_FILE_NO	Veteran administration assigned identification number.	VARCHAR2(255)	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

Ver: 9.1