Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	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	Alternative ID Count	Count of the number of alternative IDs recorded for this person or organization entity.	NUMBER	GORADID	GORADID_ADDITIONAL_ID
BIRTH_DATE	Birth Date	Date of birth for the person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE
CHILDREN_NUMBER	Children Number	Number of children recorded for this person.	NUMBER	GOBINTL	GOBINTL_CHILD_NUMBER
CITIZENSHIP_DESC	Citizenship Description	Citizen type description.	VARCHAR2(255)	STVCITZ	STVCITZ_DESC
CITIZENSHIP_EDI_EQUIV	Citizenship Edi Equiv	Citizenship type used for the electronic data transfer.	VARCHAR2(2)	STVCITZ	STVCITZ_EDI_EQUIV
CITIZENSHIP_IND	Citizenship Indicator	Indicates whether the person is a citizen of the institution's home country.	VARCHAR2(1)	STVCITZ	STVCITZ_CITIZEN_IND
CITIZENSHIP_TYPE	Citizenship Type	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(63)	SPBPERS	SPBPERS_CITZ_CODE
CONFIDENTIALITY_COMMENT	Confidentiality Comment	Specifies what information the person has requested be confidential.	VARCHAR2(255)	NA	NA
CONFIDENTIALITY_IND	Confidentiality Indicator	Specifies whether the person has requested the institution keep some of their information confidential.	VARCHAR2(1)	SPBPERS	SPBPERS_CONFID_IND
CURRENT_AGE	Current Age	Age of the person as of today's date.	NUMBER	FUNCTION	MGKFUNC.F_CALCULATE_AGE(SYSDATE, BIRTH_DATE, DECEASED_DATE),
DECEASED_DATE	Deceased Date	Date the person died.	DATE	SPBPERS	SPBPERS_DEAD_DATE
DECEASED_STATUS	Deceased Status	Indicates whether a person is deceased.	VARCHAR2(1)	SPBPERS	SPBPERS_DEAD_IND
DURATION_OF_STAY	Duration Of Stay	Indicates whether the admission or departure is for the duration of the stay.	VARCHAR2(1)	GOBINTL	GOBINTL_DURATION
EMAIL_PREFERRED	Email Preferred	Type of mail address recorded as preferred.	VARCHAR2(63)	GOREMAL	GOREMAL_EMAL_CODE
EMAIL_PREFERRED_ADDRESS	Email Preferred Address	Preferred email address of the person.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAIL_ADDRESS
EMAIL_PREFERRED_DESC	Email Preferred Description	Email address preferred description.	VARCHAR2(255)	GTVEMAL	GTVEMAL_DESC
EMPLOYMENT_TYPE	Employment Type	Type of employment recorded for the person.	VARCHAR2(63)	GOBINTL	GOBINTL_EMPT_CODE
EMPLOYMENT_TYPE_DESC	Employment Type Description	Person's type of employment description.	VARCHAR2(255)	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(63)	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(63)	SPRIDEN	SPRIDEN_CREATE_USER
ENTITY_ORIGIN	Entity Origin	Source process or system that created or updated this record.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ORIGIN
ENTITY_UPDATE_USER	Entity Update User	User who made the last updated to this record.	VARCHAR2(63)	SPRIDEN	SPRIDEN_USER
ETHNICITY_EDI_EQUIV	Ethnicity Edi Equiv	EDI/SPEEDE ethnicity code that equates to the ethnic code.	VARCHAR2(63)	STVETHN	STVETHN_EDI_EQUIV
FIRST_NAME	First Name	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME
FOREIGN_SSN	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	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	Identifies the gender of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_SEX
GENDER_DESC	Gender Description	Gender code description.	VARCHAR2(63)	CALCULATION	DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')
GENDER_DESIGNATION	Gender Designation	This gender identity of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_GNDR_CODE
GENDER_DESIGNATION_DESC	Gender Designation Description	The description of the gender identity.	VARCHAR2(255)	GTVGNDR	GTVGNDR_GNDR_DESC
GOVERNMENT_ID	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	Hispanic Latino Ethinicity 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	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	ID 2	A second identification number assign to a person.	VARCHAR2(63)	NA	NA
ID3	ID 3	A third identification number assign to a person.	VARCHAR2(63)	NA	NA
ID_SOURCE	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	Immigration Status	Indicates whether immigration information has been received by the institution.	VARCHAR2(63)	GOBINTL	GOBINTL_I94_STATUS
IMMIGRATION_STATUS_DATE	Immigration Status Date	Date the person was admitted to or departed the country.	DATE	GOBINTL	GOBINTL_I94_DATE
LAST_NAME	Last Name	Last name of the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME
LAST_NAME_PREFIX	Last Name Prefix	Last name prefix of the person.	VARCHAR2(60)	SPRIDEN	SPRIDEN_SURNAME_PREFIX
LEGACY	Legacy	Code that identifies if the person has a legacy relationship.	VARCHAR2(63)	SPBPERS	SPBPERS_LGCY_CODE
LEGACY_DESC	Legacy Description	Legacy code description.	VARCHAR2(255)	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)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_INFORMAL	Mailing Name Informal	Person's informal name using nickname if available.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_PREFERRED	Mailing Name Preferred	Person's preferred mailing name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MARITAL_STATUS	Marital Status	Marital status code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_MRTL_CODE
MARITAL_STATUS_DESC	Marital Status Description	Marital status description associated with the person.	VARCHAR2(255)	STVMRTL	STVMRTL_DESC
MEDICAL_INFORMATION_COUNT	Medical Information Count	Number of medical information records for the person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_MEDICAL_INFORMATION
MIDDLE_INITIAL	Middle Initial	Person's current name middle initial.	VARCHAR2(15)	CALCULATION	SUBSTR(SPRIDEN_MI,1,1)
MIDDLE_NAME	Middle Name	Middle name of the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI
MILITARY_BRANCH	Military Branch	Branch of military service for the veteran information.	VARCHAR2(255)	NA	NA
MILITARY_SEPARATION_DATE	Military Separation Date	Date the person left active military service.	DATE	SPBPERS	SPBPERS_ACTIVE_DUTY_SEPR_DATE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME_PREFIX	Name Prefix	Prefix associated with the person's name.	VARCHAR2(20)	SPBPERS	SPBPERS_NAME_PREFIX
NAME_SUFFIX	Name Suffix	Suffix for the person's name.	VARCHAR2(20)	SPBPERS	SPBPERS_NAME_SUFFIX
NAME_TYPE	Name Type	Category of the name specified.	VARCHAR2(63)	SPRIDEN	SPRIDEN_NTYP_CODE
NAME_TYPE_DESC	Name Type Description	Name type, e.g., professional, married, maiden, etc.	VARCHAR2(255)	GTVNTYP	GTVNTYP_DESC
NATION_OF_BIRTH	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 Of Birth Description	Nation/country of birth description for the person.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_OF_CITIZENSHIP	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	Nation Of Citizenship 2	Second country code of the nation where the person maintains citizenship.	VARCHAR2(63)	NA	NA
NATION_OF_CITIZENSHIP_DESC	Nation Of Citizenship Description	Nation/country of citizenship description for the person.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_OF_CITIZENSHIP_DESC2	Nation Of Citizenship Description 2	Country code description for the person's second nation of citizenship.	VARCHAR2(255)	NA	NA
NATIVE_LANGUAGE	Native Language	Native language code of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_LANG_CODE
NATIVE_LANGUAGE_DESC	Native Language Description	Person's native language code description.	VARCHAR2(255)	STVLANG	STVLANG_DESC
NICKNAME	Nickname	Nickname used by the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_PREFERRED_DATA
PASSPORT_CERTIF_DATE_ISSUE	Passport Certif Date Issue	Date the passport certification was issued.	DATE	GOBINTL	GOBINTL_CERT_DATE_ISSUE
PASSPORT_CERTIF_DATE_RECVD	Passport Certif Date Received	Date the passport certification was received.	DATE	GOBINTL	GOBINTL_CERT_DATE_RECEIPT
PASSPORT_CERTIF_ELIG	Passport Certif Elig	Passport certification eligibility code.	VARCHAR2(63)	GOBINTL	GOBINTL_CELG_CODE
PASSPORT_CERTIF_ELIG_DESC	Passport Certif Elig Description	Passport certification eligibility code description.	VARCHAR2(255)	GTVCELG	GTVCELG_DESC
PASSPORT_CERTIF_NUMBER	Passport Certif Number	Passport certification number.	VARCHAR2(11)	GOBINTL	GOBINTL_CERT_NUMBER
PASSPORT_EXPIRE_DATE	Passport Expire Date	Date the person's passport expires.	DATE	GOBINTL	GOBINTL_PASSPORT_EXP_DATE
PASSPORT_ID	Passport ID	Passport identification number.	VARCHAR2(63)	GOBINTL	GOBINTL_PASSPORT_ID
PASSPORT_ISSUE_NATION	Passport Issue Nation	Nation code issuing the passport of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_ISSUE
PASSPORT_ISSUE_NATION_DESC	Passport Issue Nation Description	Nation issuing the passport description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
PASSPORT_REGISTRATION_NO	Passport Registration Number	Passport registration number of the person.	VARCHAR2(11)	GOBINTL	GOBINTL_REG_NUMBER
PERSONAL_PRONOUN	Personal Pronoun	The personal pronoun of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_PPRN_CODE
PERSONAL_PRONOUN_DESC	Personal Pronoun Desc	The description of the personal pronoun.	VARCHAR2(255)	GTVPPRN	GTVPPRN_PPRN_DESC
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SPRIDEN	SPRIDEN_PIDM
PREFERRED_FIRST_NAME	Preferred First Name	Person's preferred name.	VARCHAR2(63)	SPBPERS	SPBPERS_PREF_FIRST_NAME
PRIMARY_ETHNICITY	Primary Ethnicity	Ethnicity used for institutional standard reporting.	VARCHAR2(63)	SPBPERS	SPBPERS_ETHN_CODE
PRIMARY_ETHNICITY_DESC	Primary Ethnicity Description	Ethnicity code description.	VARCHAR2(255)	STVETHN	STVETHN_DESC
PRIM_DISABILITY	Prim Disability	Primary or first major disability for the person because of this handicap.	VARCHAR2(63)	SPRMEDI	SPRMEDI_DISA_CODE
PRIM_DISABILITY_DESC	Prim Disability Description	Disability type description.	VARCHAR2(255)	STVDISA	STVDISA_DESC
PRIM_DISABILITY_SERVICE	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	Prim Disability Service Description	Disability service description.	VARCHAR2(255)	STVSPSR	STVSPSR_DESC
PRIM_ETHNICITY_CATEGORY	Primary Ethnicity Category	Ethnic category used for governmental and other standard types of reporting.	VARCHAR2(63)	STVETHN	STVETHN_ETCT_CODE
PRIM_ETHNICITY_CATEGORY_DESC	Primary Ethnicity Category Description	Ethnic category description.	VARCHAR2(255)	STVETCT	STVETCT_DESC
PRIM_MEDICAL_CONDITION	Prim Medical Condition	Primary or first major medical condition associated with the person.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MEDI_CODE
PRIM_MEDICAL_CONDITION_DESC	Prim Medical Condition Description	Medical condition description.	VARCHAR2(255)	STVMEDI	STVMEDI_DESC
PRIM_MEDICAL_EQUIPMENT	Prim Medical Equipment	Medical equipment required because of the person's medical problem.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MDEQ_CODE
PRIM_MEDICAL_EQUIPMENT_DESC	Prim Medical Equipment Description	Medical equipment description.	VARCHAR2(255)	STVMDEQ	STVMDEQ_DESC
PROCESS_GROUP	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	Race Category Count	Number of unique regulatory races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE_CATEGORY
RACE_COUNT	Race Count	Number of races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE
RACE_ETHNICITY_CONFIRM_DATE	Race Ethnicity Confirm Date	Race and ethnicity self confirmed date.	DATE	SPBPERS	SPBPERS_CONFIRMED_RE_DATE
RACE_ETHNICITY_CONFIRM_IND	Race Ethnicity Confirm Indicator	Indicates if the person's race and ethnicity have been self-identified.	VARCHAR2(1)	SPBPERS	SPBPERS_CONFIRMED_RE_CDE
RELEASE_INFORMATION_COMMENT	Release Information Comment	Field specifies what information about them the person has requested that can be released.	VARCHAR2(2000)	NA	NA
RELIGION	Religion	Religious affiliation recorded for the person.	VARCHAR2(63)	SPBPERS	SPBPERS_RELG_CODE
RELIGION_DESC	Religion Description	Person's religious affiliation description.	VARCHAR2(255)	STVRELG	STVRELG_DESC
SALUTATIONS_COUNT	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	Signature Indicator	Indicates whether a signature is on file to release of funds for the international student.	VARCHAR2(1)	GOBINTL	GOBINTL_SIGNATURE_IND
SPONSOR_OF_PERSON	Sponsor Of Person	Identifies the sponsor for an international student or staff member.	VARCHAR2(63)	GOBINTL	GOBINTL_SPON_CODE
SPONSOR_OF_PERSON_DESC	Sponsor Of Person Description	Person's sponsor code description.	VARCHAR2(255)	STVSPON	STVSPON_DESC
SPOUSE_ACCOMPANIED_IND	Spouse Accompanied Indicator	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(63)	SPBPERS	SPBPERS_SSN
VETERAN_CATEGORY	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	Veteran Category Description	Person's veteran category description.	VARCHAR2(255)	CALCULATION	DECODE(SPBPERS_VERA_IND,NULL,NULL,'VETERAN')
VETERAN_FILE_NO	Veteran File Number	Veteran administration assigned identification number.	VARCHAR2(255)	SPBPERS	SPBPERS_VETC_FILE_NUMBER
VETERAN_SPECIAL_DISABLED_IND	Veteran Special Disabled Indicator	Indicates whether the person has been qualified as a disabled veteran.	VARCHAR2(1)	SPBPERS	SPBPERS_SDVET_IND

Ver: 9.2