Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_COUNT	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES	NO	NO
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	NO	NO
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ALTERNATIVE_ID_COUNT	Count of the number of alternative IDs recorded for this person or organization entity.	NUMBER	GORADID	GORADID_ADDITIONAL_ID	NO	NO
BIRTH_DATE	Date of birth for the person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE	NO	NO
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
CHILDREN_NUMBER	Number of children recorded for this person.	NUMBER	GOBINTL	GOBINTL_CHILD_NUMBER	NO	NO
CITIZENSHIP_DESC	Citizen type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_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(63)	SPBPERS	SPBPERS_CITZ_CODE	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
CONFIDENTIALITY_COMMENT	Specifies what information the person has requested be confidential.	VARCHAR2(255)	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
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
COUNTY	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC	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
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT	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
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	NO	NO
EMAIL_ADDRESS	Preferred email address.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAIL_ADDRESS	NO	NO
EMAIL_TYPE	Type of email address recorded.	VARCHAR2(63)	GOREMAL	GOREMAL_EMAL_CODE	NO	NO
EMAIL_TYPE_DESC	Email address type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EMPLOYMENT_TYPE	Type of employment recorded for the person.	VARCHAR2(63)	GOBINTL	GOBINTL_EMPT_CODE	NO	NO
EMPLOYMENT_TYPE_DESC	Person's type of employment description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
ENRL_PLANNING_SERVICE_DESC	Enrollment planning service description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_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(63)	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(63)	SPRIDEN	SPRIDEN_CREATE_USER	NO	NO
ENTITY_ORIGIN	Source process or system that created or updated this record.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ORIGIN	NO	NO
ENTITY_UPDATE_USER	User who made the last updated to this record.	VARCHAR2(63)	SPRIDEN	SPRIDEN_USER	NO	NO
ENTRY_IND	Indicates whether the visa authorizes the person to enter the institution's home country.	VARCHAR2(1)	GORVISA	GORVISA_ENTRY_IND	NO	NO
ETHNICITY_EDI_EQUIV	EDI/SPEEDE ethnicity code that equates to the ethnic code.	VARCHAR2(63)	STVETHN	STVETHN_EDI_EQUIV	NO	NO
FEDERAL_REPORTING_CODE	Government determined code for the reporting state/province codes.	VARCHAR2(5)	STVSTAT	STVSTAT_IPEDS_CDE	NO	NO
FIRST_NAME	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME	NO	NO
FOREIGN_TAX_ID	Unique identification number for tax purposes from a country outside the institution's home country.	VARCHAR2(63)	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(63)	SPBPERS	SPBPERS_SEX	NO	NO
GENDER_DESC	Gender code description.	VARCHAR2(63)	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
GEOGRAPHIC_REGION_COUNT	Count of geographic regions associated with an address record.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS	NO	NO
GOVERNMENT_ID	Identification assigned by the institution's home government when the tax id is from a different government.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	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 new ethnicity and race categories.	VARCHAR2(1)	SPBPERS	SPBPERS_ETHN_CDE	NO	NO
HOUSE_NUMBER	House number associated with the persons address.	VARCHAR2(63)	SPRADDR	SPRADDR_HOUSE_NUMBER	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
ID2	A second identification number assign to a person.	VARCHAR2(63)	NA	NA	NO	NO
ID3	A third identification number assign to a person.	VARCHAR2(63)	NA	NA	NO	NO
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')	NO	NO
IMMIGRATION_STATUS	Indicates whether immigration information has been received by the institution.	VARCHAR2(63)	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(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
LAST_NAME_PREFIX	Last name prefix of the person.	VARCHAR2(60)	SPRIDEN	SPRIDEN_SURNAME_PREFIX	NO	NO
LEGACY	Legacy code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_LGCY_CODE	NO	NO
LEGACY_DESC	Legacy code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
LEGAL_NAME	Code that identifies if the person has a legacy relationship.	VARCHAR2(500)	SPBPERS	SPBPERS_LEGAL_NAME	NO	NO
MAILING_NAME_FORMAL	Person's formal current full name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME	NO	NO
MAILING_NAME_INFORMAL	Person's current informal name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME	NO	NO
MAILING_NAME_PREFERRED	Person's preferred name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME	NO	NO
MARITAL_STATUS	Marital status code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_MRTL_CODE	NO	NO
MARITAL_STATUS_DESC	Marital status description associated with the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MEDICAL_INFORMATION_COUNT	Number of medical information records for the person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_MEDICAL_INFORMATION	NO	NO
MIDDLE_INITIAL	Person's current name middle initial.	VARCHAR2(15)	CALCULATION	SUBSTR(SPRIDEN_MI,1,1)	NO	NO
MIDDLE_NAME	Person's middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI	NO	NO
MILITARY_BRANCH	Branch of military service for the veteran information.	VARCHAR2(255)	NA	NA	NO	NO
MILITARY_SEPARATION_DATE	Date the person left active military service.	DATE	SPBPERS	SPBPERS_ACTIVE_DUTY_SEPR_DATE	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	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(63)	SPRIDEN	SPRIDEN_NTYP_CODE	NO	NO
NAME_TYPE_DESC	Name type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
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	NO	NO
NATION_ISO_CODE	Three character International Standards Organization (ISO) Code associated with the nation code.	VARCHAR2(3)	STVNATN	STVNATN_SCOD_CODE_ISO	NO	NO
NATION_OF_BIRTH	Country code of the nation of the person's birth.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_BIRTH	NO	NO
NATION_OF_BIRTH_DESC	Nation/country of birth description for the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
NATION_OF_CITIZENSHIP2	Second country code of the nation where the person maintains citizenship.	VARCHAR2(63)	NA	NA	NO	NO
NATION_OF_CITIZENSHIP_DESC	Nation/country of citizenship description for the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
NATION_OF_CITIZENSHIP_DESC2	Country code description for the person's second nation of citizenship.	VARCHAR2(255)	NA	NA	NO	NO
NATIVE_LANGUAGE	Native language code of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_LANG_CODE	NO	NO
NATIVE_LANGUAGE_DESC	Person's native language code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
NICKNAME	Nickname used by the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_PREFERRED_DATA	NO	NO
NUMBER_OF_ENTRIES	Number of entries into the country for the person.	VARCHAR2(2)	GORVISA	GORVISA_NO_ENTRIES	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 by the person.	DATE	GOBINTL	GOBINTL_CERT_DATE_RECEIPT	NO	NO
PASSPORT_CERTIF_ELIG	Passport certification eligibility code of the person.	VARCHAR2(255)	GOBINTL	GOBINTL_CELG_CODE	NO	NO
PASSPORT_CERTIF_ELIG_DESC	Description associated with the person's passport certification eligibility code.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_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(63)	GOBINTL	GOBINTL_PASSPORT_ID	NO	NO
PASSPORT_ISSUE_NATION	Nation code issuing the passport of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_ISSUE	NO	NO
PASSPORT_ISSUE_NATION_DESC	Nation issuing the passport description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	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	SPBPERS SPRIDEN	SPBPERS_PIDM SPRIDEN_PIDM	NO NO	NO
PHONE_COUNT	Count of phone records.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES	NO	NO
PHONE_DESC	Telephone number type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
PHONE_TYPE	Type of telephone information such as home phone, emergency contact.	VARCHAR2(63)	SPRTELE	SPRTELE_TELE_CODE	NO	NO
PHONE_UNLIST_IND	Specifies whether the phone number is to be unlisted.	VARCHAR2(1)	SPRTELE	SPRTELE_UNLIST_IND	NO	NO
POINT_OF_ENTRY	Point of entry code of the person.	VARCHAR2(63)	GORVISA	GORVISA_PENT_CODE	NO	NO
POINT_OF_ENTRY_DESC	International student's port of entry into the country of the institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
PREFERRED_FIRST_NAME	Person's preferred name.	VARCHAR2(63)	SPBPERS	SPBPERS_PREF_FIRST_NAME	NO	NO
PRIMARY_DISABILITY	Disability recorded for the person that is identified as the primary disability.	VARCHAR2(63)	SPRMEDI	SPRMEDI_DISA_CODE	NO	NO
PRIMARY_DISABILITY_DESC	Disability type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PRIMARY_DISABILITY_IND	Indicates whether this disability is the primary disability.	VARCHAR2(63)	SPRMEDI	SPRMEDI_DISB_IND	NO	NO
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	NO	NO
PRIMARY_ETHNICITY	Ethnicity used for institutional standard reporting.	VARCHAR2(63)	SPBPERS	SPBPERS_ETHN_CODE	NO	NO
PRIMARY_ETHNICITY_DESC	Ethnicity code description.	VARCHAR2(255)	STVETHN	STVETHN_DESC	NO	NO
PRIMARY_MEDICAL_DESC	Medical condition description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PRIMARY_MEDICAL_EQUIPMENT	Medical equipment required because of the person's medical problem.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MDEQ_CODE	NO	NO
PRIMARY_MEDICAL_EQUIPMENT_DESC	Medical equipment description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PRIM_DISABILITY_SERVICE_DESC	Description of the disability service provided.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PRIM_ETHNICITY_CATEGORY	Ethnic category used for governmental and other standard types of reporting.	VARCHAR2(63)	STVETHN	STVETHN_ETCT_CODE	NO	NO
PRIM_ETHNICITY_CATEGORY_DESC	Ethnic category description.	VARCHAR2(255)	STVETCT	STVETCT_DESC	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
RACE_CATEGORY_COUNT	Number of unique regulatory races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE_CATEGORY	NO	NO
RACE_COUNT	Number of races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE	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	Field specifies what information about them the person has requested that can be released.	VARCHAR2(2000)	NA	NA	NO	NO
RELIGION	Religious affiliation recorded for the person.	VARCHAR2(63)	SPBPERS	SPBPERS_RELG_CODE	NO	NO
RELIGION_DESC	Description of the person's religious affiliation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	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(63)	GOBINTL	GOBINTL_SPON_CODE	NO	NO
SPONSOR_OF_PERSON_DESC	Person's sponsor code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_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
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN	NO	NO
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	NO	NO
VETERAN_CATEGORY_DESC	Person's specific veteran category description.	VARCHAR2(255)	CALCULATION	DECODE(SPBPERS_VERA_IND)	NO	NO
VETERAN_FILE_NUMBER	Veteran administration assigned identification number.	VARCHAR2(255)	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
VISA_EXPIRE_DATE	Current date this person's visa expires.	DATE	GORVISA	GORVISA_VISA_EXPIRE_DATE	NO	NO
VISA_ISSUE_DATE	Most recent date this person's visa was issued.	DATE	GORVISA	GORVISA_VISA_ISSUE_DATE	NO	NO
VISA_ISSUING_AUTHORITY	Agency location or other identifier for the authorization for this visa.	VARCHAR2(63)	GORVISA	GORVISA_VISS_CODE	NO	NO
VISA_ISSUING_AUTHORITY_DESC	Authorizing agency description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
VISA_ISSUING_NATION	Nation or country issuing the visa to this person.	VARCHAR2(63)	GORVISA	GORVISA_NATN_CODE_ISSUE	NO	NO
VISA_ISSUING_NATION_DESC	Name of the nation or country issuing the visa.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
VISA_NUMBER	Government issued unique identification number assigned to this visa.	VARCHAR2(18)	GORVISA	GORVISA_VISA_NUMBER	NO	NO
VISA_REQ_DATE	Date the visa was requested by the person.	DATE	GORVISA	GORVISA_VISA_REQ_DATE	NO	NO
VISA_START_DATE	Current visa initial valid or begin date for this person.	DATE	GORVISA	GORVISA_VISA_START_DATE	NO	NO
VISA_TYPE	Type of visa issued to this person. For example, student, employment, visitor, etc.	VARCHAR2(63)	GORVISA	GORVISA_VTYP_CODE	NO	NO
VISA_TYPE_DESC	Description for the type of visa for this person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO

Ver: 9.2