Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_COUNT	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES
ADDRESS_TYPE	Type of address that should be used to identify the preferred address when a specific preferred address type has not been specified for the person or entity. Examples, may be address types of mailing, temporary summer, billing and permanent. Only active addresses can be selected as preferred.	VARCHAR2(63)	FUNCTION	MSKFUNC.F_GET_PREF_ADDRESS_ROWID
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
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
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE
CHILDREN_NUMBER	Number of children recorded for this person.	NUMBER	GOBINTL	GOBINTL_CHILD_NUMBER
CITIZENSHIP_DESC	Citizen type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_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
CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
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
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT
COUNTY	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
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
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT
DURATION_OF_STAY	Indicates whether the admission or departure is for the duration of the stay.	VARCHAR2(1)	GOBINTL	GOBINTL_DURATION
EDI_EQUIVALENT	EDI equivalent code used for electronic transfer of state or province or nation information. This might be used on transcripts for the person, vendor invoice, etc.	VARCHAR2(2)	STVSTAT	STVSTAT_EDI_EQUIV
EMAIL_ADDRESS	Preferred email address.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAIL_ADDRESS
EMAIL_TYPE	Type of email address recorded.	VARCHAR2(63)	GOREMAL	GOREMAL_EMAL_CODE
EMAIL_TYPE_DESC	Email address type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_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)	FUNCTION	GOKODSF.F_GET_DESC
ENRL_PLANNING_SERVICE	Enrollment planning service code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research.	VARCHAR2(63)	FUNCTION	F_EPSCCODE
ENRL_PLANNING_SERVICE_DESC	Enrollment planning service description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_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
ENTRY_IND	Indicates whether the visa authorizes the person to enter the institution's home country.	VARCHAR2(1)	GORVISA	GORVISA_ENTRY_IND
ETHNICITY_EDI_EQUIV	EDI/SPEEDE ethnicity code that equates to the ethnic code.	VARCHAR2(63)	STVETHN	STVETHN_EDI_EQUIV
FEDERAL_REPORTING_CODE	Government determined code for the reporting state/province codes.	VARCHAR2(5)	STVSTAT	STVSTAT_IPEDS_CDE
FIRST_NAME	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME
FOREIGN_TAX_ID	Unique identification number for tax purposes from a country outside the institution's home country.	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')
GEOGRAPHIC_REGION_COUNT	Count of geographic regions associated with an address record.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS
GOVERNMENT_ID	Identification assigned by the institution's home government when the tax id is from a different government.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
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 new ethnicity and race categories.	VARCHAR2(1)	SPBPERS	SPBPERS_ETHN_CDE
HOUSE_NUMBER	House number associated with the persons address.	VARCHAR2(63)	SPRADDR	SPRADDR_HOUSE_NUMBER
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	Legacy code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_LGCY_CODE
LEGACY_DESC	Legacy code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
LEGAL_NAME	Code that identifies if the person has a legacy relationship.	VARCHAR2(500)	SPBPERS	SPBPERS_LEGAL_NAME
MAILING_NAME_FORMAL	Person's formal current full name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_INFORMAL	Person's current informal name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_PREFERRED	Person's preferred name for a mailing address label.	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)	FUNCTION	GOKODSF.F_GET_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	Person's middle name.	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 description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_DESC	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_EDI_EQUIVALENT	EDI equivalent code used for electronic transfer of country information. This might be used on transcripts for the person, vendor invoice, etc.	VARCHAR2(2)	STVNATN	STVNATN_EDI_EQUIV
NATION_ISO_CODE	Three character International Standards Organization (ISO) Code associated with the nation code.	VARCHAR2(3)	STVNATN	STVNATN_SCOD_CODE_ISO
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)	FUNCTION	GOKODSF.F_GET_DESC
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)	FUNCTION	GOKODSF.F_GET_DESC
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)	FUNCTION	GOKODSF.F_GET_DESC
NICKNAME	Nickname used by the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_PREFERRED_DATA
NUMBER_OF_ENTRIES	Number of entries into the country for the person.	VARCHAR2(2)	GORVISA	GORVISA_NO_ENTRIES
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 by the person.	DATE	GOBINTL	GOBINTL_CERT_DATE_RECEIPT
PASSPORT_CERTIF_ELIG	Passport certification eligibility code of the person.	VARCHAR2(255)	GOBINTL	GOBINTL_CELG_CODE
PASSPORT_CERTIF_ELIG_DESC	Description associated with the person's passport certification eligibility code.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_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)	FUNCTION	GOKODSF.F_GET_DESC
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	SPBPERS SPRIDEN	SPBPERS_PIDM SPRIDEN_PIDM
PHONE_COUNT	Count of phone records.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES
PHONE_DESC	Telephone number type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PHONE_NUMBER_COMBINED	All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.	VARCHAR2(63)	CALCULATION	SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT
PHONE_TYPE	Type of telephone information such as home phone, emergency contact.	VARCHAR2(63)	SPRTELE	SPRTELE_TELE_CODE
PHONE_UNLIST_IND	Specifies whether the phone number is to be unlisted.	VARCHAR2(1)	SPRTELE	SPRTELE_UNLIST_IND
POINT_OF_ENTRY	Point of entry code of the person.	VARCHAR2(63)	GORVISA	GORVISA_PENT_CODE
POINT_OF_ENTRY_DESC	International student's port of entry into the country of the institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
PREFERRED_FIRST_NAME	Person's preferred name.	VARCHAR2(63)	SPBPERS	SPBPERS_PREF_FIRST_NAME
PRIMARY_DISABILITY	Disability recorded for the person that is identified as the primary disability.	VARCHAR2(63)	SPRMEDI	SPRMEDI_DISA_CODE
PRIMARY_DISABILITY_DESC	Disability type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_DISABILITY_IND	Indicates whether this disability is the primary disability.	VARCHAR2(63)	SPRMEDI	SPRMEDI_DISB_IND
PRIMARY_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
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
PRIMARY_MEDICAL_DESC	Medical condition description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_MEDICAL_EQUIPMENT	Medical equipment required because of the person's medical problem.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MDEQ_CODE
PRIMARY_MEDICAL_EQUIPMENT_DESC	Medical equipment description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIM_DISABILITY_SERVICE_DESC	Description of the disability service provided.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_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
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	Description of the person's religious affiliation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_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)	FUNCTION	GOKODSF.F_GET_DESC
SPOUSE_ACCOMPANIED_IND	Indicates whether the spouse accompanied this person entering the institution home country.	VARCHAR2(1)	GOBINTL	GOBINTL_SPOUSE_IND
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
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 specific veteran category description.	VARCHAR2(63)	CALCULATION	DECODE(SPBPERS_VERA_IND)
VETERAN_FILE_NUMBER	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
VISA_EXPIRE_DATE	Current date this person's visa expires.	DATE	GORVISA	GORVISA_VISA_EXPIRE_DATE
VISA_ISSUE_DATE	Most recent date this person's visa was issued.	DATE	GORVISA	GORVISA_VISA_ISSUE_DATE
VISA_ISSUING_AUTHORITY	Agency location or other identifier for the authorization for this visa.	VARCHAR2(63)	GORVISA	GORVISA_VISS_CODE
VISA_ISSUING_AUTHORITY_DESC	Authorizing agency description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
VISA_ISSUING_NATION	Nation or country issuing the visa to this person.	VARCHAR2(63)	GORVISA	GORVISA_NATN_CODE_ISSUE
VISA_ISSUING_NATION_DESC	Name of the nation or country issuing the visa.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
VISA_NUMBER	Government issued unique identification number assigned to this visa.	VARCHAR2(18)	GORVISA	GORVISA_VISA_NUMBER
VISA_REQ_DATE	Date the visa was requested by the person.	DATE	GORVISA	GORVISA_VISA_REQ_DATE
VISA_START_DATE	Current visa initial valid or begin date for this person.	DATE	GORVISA	GORVISA_VISA_START_DATE
VISA_TYPE	Type of visa issued to this person. For example, student, employment, visitor, etc.	VARCHAR2(63)	GORVISA	GORVISA_VTYP_CODE
VISA_TYPE_DESC	Description for the type of visa for this person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC

Ver: 8.5