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')
|
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
|
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
|
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
|
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(255)
|
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
|