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

Ver: