| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADDRESS_COUNT
|
Address Count
|
Count of current active addresses for this person or entity.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADDRESSES
|
|
ADDRESS_TYPE
|
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
|
Address type description.
|
VARCHAR2(255)
|
STVATYP
|
STVATYP_DESC
|
|
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
|
|
CARRIER_ROUTE
|
Carrier Route
|
Address carrier route.
|
VARCHAR2(4)
|
SPRADDR
|
SPRADDR_CARRIER_ROUTE
|
|
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)
|
FUNCTION
|
GOKODSF.F_GET_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
|
|
CITY
|
City
|
Address city, town or municipality.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
|
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
|
|
CORRECTION_DIGIT
|
Correction Digit
|
Correction digit associated with the address for bar code mailing.
|
NUMBER
|
SPRADDR
|
SPRADDR_CORRECTION_DIGIT
|
|
COUNTY
|
County
|
County for this address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CNTY_CODE
|
|
COUNTY_DESC
|
County Description
|
County name for the address.
|
VARCHAR2(255)
|
STVCNTY
|
STVCNTY_DESC
|
|
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
|
|
DELIVERY_POINT
|
Delivery Point
|
Delivery point associated with the address for barcode mailings.
|
NUMBER
|
SPRADDR
|
SPRADDR_DELIVERY_POINT
|
|
DURATION_OF_STAY
|
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
|
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
|
Email Address
|
Preferred email address.
|
VARCHAR2(255)
|
GOREMAL
|
GOREMAL_EMAIL_ADDRESS
|
|
EMAIL_TYPE
|
Email Type
|
Type of email address recorded.
|
VARCHAR2(63)
|
GOREMAL
|
GOREMAL_EMAL_CODE
|
|
EMAIL_TYPE_DESC
|
Email Type Description
|
Email address type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ENRL_PLANNING_SERVICE
|
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
|
Enrl Planning Service Description
|
Enrollment planning service description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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
|
|
ENTRY_IND
|
Entry Indicator
|
Indicates whether the visa authorizes the person to enter the institution's home country.
|
VARCHAR2(1)
|
GORVISA
|
GORVISA_ENTRY_IND
|
|
ETHNICITY_EDI_EQUIV
|
Ethnicity Edi Equiv
|
EDI/SPEEDE ethnicity code that equates to the ethnic code.
|
VARCHAR2(63)
|
STVETHN
|
STVETHN_EDI_EQUIV
|
|
FEDERAL_REPORTING_CODE
|
Federal Reporting Code
|
Government determined code for the reporting state/province codes.
|
VARCHAR2(5)
|
STVSTAT
|
STVSTAT_IPEDS_CDE
|
|
FIRST_NAME
|
First Name
|
Person's first or given name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
|
FOREIGN_TAX_ID
|
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
|
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
|
|
GEOGRAPHIC_REGION_COUNT
|
Geographic Region Count
|
Count of geographic regions associated with an address record.
|
NUMBER
|
FUNCTION
|
MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS
|
|
GOVERNMENT_ID
|
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
|
Hispanic Latino Ethnicity Indicator
|
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
|
House number associated with the persons address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_HOUSE_NUMBER
|
|
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
|
Legacy code of the person.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_LGCY_CODE
|
|
LEGACY_DESC
|
Legacy Description
|
Legacy code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
LEGAL_NAME
|
Legal Name
|
Code that identifies if the person has a legacy relationship.
|
VARCHAR2(500)
|
SPBPERS
|
SPBPERS_LEGAL_NAME
|
|
MAILING_NAME_FORMAL
|
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
|
Mailing Name Informal
|
Person's current informal name for a mailing address label.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_FORMAT_PREFERRED_NAME
|
|
MAILING_NAME_PREFERRED
|
Mailing Name Preferred
|
Person's preferred name for a mailing address label.
|
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)
|
FUNCTION
|
GOKODSF.F_GET_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
|
Person's middle name.
|
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 description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
NATION
|
Nation
|
Nation/country code associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_NATN_CODE
|
|
NATION_DESC
|
Nation Description
|
Address nation/country description.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
|
NATION_EDI_EQUIVALENT
|
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
|
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
|
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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
NICKNAME
|
Nickname
|
Nickname used by the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_PREFERRED_DATA
|
|
NUMBER_OF_ENTRIES
|
Number Of Entries
|
Number of entries into the country for the person.
|
VARCHAR2(2)
|
GORVISA
|
GORVISA_NO_ENTRIES
|
|
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 by the person.
|
DATE
|
GOBINTL
|
GOBINTL_CERT_DATE_RECEIPT
|
|
PASSPORT_CERTIF_ELIG
|
Passport Certif Elig
|
Passport certification eligibility code of the person.
|
VARCHAR2(255)
|
GOBINTL
|
GOBINTL_CELG_CODE
|
|
PASSPORT_CERTIF_ELIG_DESC
|
Passport Certif Elig Description
|
Description associated with the person's passport certification eligibility code.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
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
|
SPBPERS SPRIDEN
|
SPBPERS_PIDM SPRIDEN_PIDM
|
|
PHONE_COUNT
|
Phone Count
|
Count of phone records.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_TELEPHONES
|
|
PHONE_DESC
|
Phone Description
|
Telephone number type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PHONE_NUMBER_COMBINED
|
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
|
Phone Type
|
Type of telephone information such as home phone, emergency contact.
|
VARCHAR2(63)
|
SPRTELE
|
SPRTELE_TELE_CODE
|
|
PHONE_UNLIST_IND
|
Phone Unlist Indicator
|
Specifies whether the phone number is to be unlisted.
|
VARCHAR2(1)
|
SPRTELE
|
SPRTELE_UNLIST_IND
|
|
POINT_OF_ENTRY
|
Point Of Entry
|
Point of entry code of the person.
|
VARCHAR2(63)
|
GORVISA
|
GORVISA_PENT_CODE
|
|
POINT_OF_ENTRY_DESC
|
Point Of Entry Description
|
International student's port of entry into the country of the institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
POSTAL_CODE
|
Postal Code
|
Address postal code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
|
PREFERRED_FIRST_NAME
|
Preferred First Name
|
Person's preferred name.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_PREF_FIRST_NAME
|
|
PRIMARY_DISABILITY
|
Primary Disability
|
Disability recorded for the person that is identified as the primary disability.
|
VARCHAR2(63)
|
SPRMEDI
|
SPRMEDI_DISA_CODE
|
|
PRIMARY_DISABILITY_DESC
|
Primary Disability Description
|
Disability type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PRIMARY_DISABILITY_IND
|
Primary Disability Indicator
|
Indicates whether this disability is the primary disability.
|
VARCHAR2(63)
|
SPRMEDI
|
SPRMEDI_DISB_IND
|
|
PRIMARY_DISABILITY_SERVICE
|
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
|
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
|
|
PRIMARY_MEDICAL_DESC
|
Primary Medical Description
|
Medical condition description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PRIMARY_MEDICAL_EQUIPMENT
|
Primary Medical Equipment
|
Medical equipment required because of the person's medical problem.
|
VARCHAR2(63)
|
SPRMEDI
|
SPRMEDI_MDEQ_CODE
|
|
PRIMARY_MEDICAL_EQUIPMENT_DESC
|
Primary Medical Equipment Description
|
Medical equipment description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PRIM_DISABILITY_SERVICE_DESC
|
Prim Disability Service Description
|
Description of the disability service provided.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PRIM_ETHNICITY_CATEGORY
|
Prim Ethnicity Category
|
Ethnic category used for governmental and other standard types of reporting.
|
VARCHAR2(63)
|
STVETHN
|
STVETHN_ETCT_CODE
|
|
PRIM_ETHNICITY_CATEGORY_DESC
|
Prim Ethnicity Category Description
|
Ethnic category description.
|
VARCHAR2(255)
|
STVETCT
|
STVETCT_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
|
Description of the person's religious affiliation.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_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
|
|
STATE_PROVINCE
|
State Province
|
State or province associated with this address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_STAT_CODE
|
|
STATE_PROVINCE_DESC
|
State Province Description
|
State/province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
|
STREET_LINE1
|
Street Line 1
|
First line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE1
|
|
STREET_LINE2
|
Street Line 2
|
Second line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE2
|
|
STREET_LINE3
|
Street Line 3
|
Third line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE3
|
|
STREET_LINE4
|
Street Line 4
|
Fourth line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE4
|
|
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 specific veteran category description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(SPBPERS_VERA_IND)
|
|
VETERAN_FILE_NUMBER
|
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
|
|
VISA_EXPIRE_DATE
|
Visa Expire Date
|
Current date this person's visa expires.
|
DATE
|
GORVISA
|
GORVISA_VISA_EXPIRE_DATE
|
|
VISA_ISSUE_DATE
|
Visa Issue Date
|
Most recent date this person's visa was issued.
|
DATE
|
GORVISA
|
GORVISA_VISA_ISSUE_DATE
|
|
VISA_ISSUING_AUTHORITY
|
Visa Issuing Authority
|
Agency location or other identifier for the authorization for this visa.
|
VARCHAR2(63)
|
GORVISA
|
GORVISA_VISS_CODE
|
|
VISA_ISSUING_AUTHORITY_DESC
|
Visa Issuing Authority Description
|
Authorizing agency description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
VISA_ISSUING_NATION
|
Visa Issuing Nation
|
Nation or country issuing the visa to this person.
|
VARCHAR2(63)
|
GORVISA
|
GORVISA_NATN_CODE_ISSUE
|
|
VISA_ISSUING_NATION_DESC
|
Visa Issuing Nation Description
|
Name of the nation or country issuing the visa.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
VISA_NUMBER
|
Visa Number
|
Government issued unique identification number assigned to this visa.
|
VARCHAR2(18)
|
GORVISA
|
GORVISA_VISA_NUMBER
|
|
VISA_REQ_DATE
|
Visa Req Date
|
Date the visa was requested by the person.
|
DATE
|
GORVISA
|
GORVISA_VISA_REQ_DATE
|
|
VISA_START_DATE
|
Visa Start Date
|
Current visa initial valid or begin date for this person.
|
DATE
|
GORVISA
|
GORVISA_VISA_START_DATE
|
|
VISA_TYPE
|
Visa Type
|
Type of visa issued to this person. For example, student, employment, visitor, etc.
|
VARCHAR2(63)
|
GORVISA
|
GORVISA_VTYP_CODE
|
|
VISA_TYPE_DESC
|
Visa Type Description
|
Description for the type of visa for this person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|