Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_PERSON

Description Source composite view contains demographic data that is common to persons across administrative models and products. It reflects only the most current data - it does not track changes.

Target Column Business Definition Database Data Type Source Name Source Column
BIRTH_DATE Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

CHILDREN_NUMBER Number of children recorded for this person. NUMBER(2)

GOBINTL

GOBINTL_CHILD_NUMBER

CITIZENSHIP_DESC Citizen type description. VARCHAR2(30)

STVCITZ

STVCITZ_DESC

CITIZENSHIP_EDI_EQUIV Citizenship type used for the electronic data transfer. VARCHAR2(2)

STVCITZ

STVCITZ_EDI_EQUIV

CITIZENSHIP_IND Indicates whether the person has been identified as 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(2)

SPBPERS

SPBPERS_CITZ_CODE

CONFIDENTIALITY_COMMENT Specifies what information the person has requested be confidential. VARCHAR2(0)

NA

NA

CONFIDENTIALITY_IND Specifies whether the person has requested the institution keep some of their information confidential. VARCHAR2(1)

SPBPERS

SPBPERS_CONFID_IND

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

DURATION_OF_STAY Indicates whether the admission or departure is for the duration of the stay. VARCHAR2(1)

GOBINTL

GOBINTL_DURATION

EMAIL_PREFERRED Type of mail address recorded as preferred. VARCHAR2(4)

GOREMAL

GOREMAL_EMAL_CODE

EMAIL_PREFERRED_ADDRESS Preferred email address of the person. VARCHAR2(128)

GOREMAL

GOREMAL_EMAIL_ADDRESS

EMAIL_PREFERRED_DESC Email address preferred description. VARCHAR2(60)

GTVEMAL

GTVEMAL_DESC

EMPLOYMENT_TYPE Type of employment recorded for the person. VARCHAR2(3)

GOBINTL

GOBINTL_EMPT_CODE

EMPLOYMENT_TYPE_DESC Person's type of employment description. VARCHAR2(30)

STVEMPT

STVEMPT_DESC

ETHNICITY_EDI_EQUIV EDI/SPEEDE ethnicity code that equates to the ethnic code. VARCHAR2(1)

STVETHN

STVETHN_EDI_EQUIV

FIRST_NAME Person's first or given name. VARCHAR2(60)

SPRIDEN

SPRIDEN_FIRST_NAME

FOREIGN_SSN Unique identification number for tax purposes, such as a foreign tax identification number (SSN, TIN, etc.). VARCHAR2(15)

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 Gender of the person. VARCHAR2(1)

SPBPERS

SPBPERS_SEX

GENDER_DESC Gender code description. VARCHAR2(12)

CALCULATION

DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')

GOVERNMENT_ID Identification assigned by the institution's home government when the tax id is from a different government. VARCHAR2(9)

NA

NA

HISPANIC_LATINO_ETHNICITY_IND Indicates if person's ethnicity is Latino or Hispanic. Due to mandated changes to the collection of race and ethnicity, these classifications were changed to separate Race and Ethnicity. Ethnicity can now be defined as either Hispanic or Latino, or Not Hispanic or Latino. VARCHAR2(1)

SPBPERS

SPBPERS_ETHN_CODE

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

ID_NUMBER2 A second identification number assign to a person. VARCHAR2(9)

NA

NA

ID_NUMBER3 A third identification number assign to a person. VARCHAR2(9)

NA

NA

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

IMMIGRATION_STATUS Indicates whether immigration information has been received by the institution. VARCHAR2(3)

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(60)

SPRIDEN

SPRIDEN_LAST_NAME

LAST_NAME_PREFIX Last name prefix of the person. VARCHAR2(60)

SPRIDEN

SPRIDEN_SURNAME_PREFIX

LEGACY Code that identifies if the person has a legacy relationship. VARCHAR2(1)

SPBPERS

SPBPERS_LGCY_CODE

LEGACY_DESC Legacy code description. VARCHAR2(30)

STVLGCY

STVLGCY_DESC

LEGAL_NAME Legal name associated with person. VARCHAR2(500)

SPBPERS

SPBPERS_LEGAL_NAME

MAILING_NAME_FORMAL Person's formalized name including prefix and suffix. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

MAILING_NAME_INFORMAL Person's informal name using nickname if available. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

MAILING_NAME_PREFERRED Person's preferred mailing name. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

MARITAL_STATUS Marital status code of the person. VARCHAR2(1)

SPBPERS

SPBPERS_MRTL_CODE

MARITAL_STATUS_DESC Marital status description associated with the person. VARCHAR2(30)

STVMRTL

STVMRTL_DESC

MIDDLE_INITIAL Person's current name middle initial. VARCHAR2(1)

CALCULATION

SUBSTR(SPRIDEN_MI,1,1)

MIDDLE_NAME Middle name of the person. VARCHAR2(60)

SPRIDEN

SPRIDEN_MI

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

MILITARY_BRANCH Branch of military service for the veteran information. VARCHAR2(0)

NA

NA

MILITARY_SEPARATION_DATE Date the person left active military service. DATE

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(4)

SPRIDEN

SPRIDEN_NTYP_CODE

NAME_TYPE_DESC Name type, e.g., professional, married, maiden, etc. VARCHAR2(30)

GTVNTYP

GTVNTYP_DESC

NATION_OF_BIRTH Country code of the nation of the person's birth. VARCHAR2(5)

GOBINTL

GOBINTL_NATN_CODE_BIRTH

NATION_OF_BIRTH_DESC Nation/country of birth description for the person. VARCHAR2(30)

STVNATN

STVNATN_NATION

NATION_OF_CITIZENSHIP First country code of the nation where the person maintains citizenship. VARCHAR2(5)

GOBINTL

GOBINTL_NATN_CODE_LEGAL

NATION_OF_CITIZENSHIP2 Second country code of the nation where the person maintains citizenship. VARCHAR2(0)

NA

NA

NATION_OF_CITIZENSHIP_DESC Nation/country of citizenship description for the person. VARCHAR2(30)

STVNATN

STVNATN_NATION

NATION_OF_CITIZENSHIP_DESC2 Country code description for the person's second nation of citizenship. VARCHAR2(0)

NA

NA

NATIVE_LANGUAGE Native language code of the person. VARCHAR2(3)

GOBINTL

GOBINTL_LANG_CODE

NATIVE_LANGUAGE_DESC Person's native language code description. VARCHAR2(30)

STVLANG

STVLANG_DESC

NICKNAME Nickname used by the person. VARCHAR2(40)

SPRIDEN

SPRIDEN_LAST_NAME

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. DATE

GOBINTL

GOBINTL_CERT_DATE_RECEIPT

PASSPORT_CERTIF_ELIG Passport certification eligibility code. VARCHAR2(6)

GOBINTL

GOBINTL_CELG_CODE

PASSPORT_CERTIF_ELIG_DESC Passport certification eligibility code description. VARCHAR2(30)

GTVCELG

GTVCELG_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(25)

GOBINTL

GOBINTL_PASSPORT_ID

PASSPORT_ISSUE_NATION Nation code issuing the passport of the person. VARCHAR2(5)

GOBINTL

GOBINTL_NATN_CODE_ISSUE

PASSPORT_ISSUE_NATION_DESC Nation issuing the passport description. VARCHAR2(30)

STVNATN

STVNATN_NATION

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(8)

SPRIDEN

SPRIDEN_PIDM

PREFERRED_FIRST_NAME Person's preferred name. VARCHAR2(60)

SPBPERS

SPBPERS_PREF_FIRST_NAME

PRIMARY_ETHNCITY_CATEGORY Ethnic category used for governmental and other standard types of reporting. VARCHAR2(1)

STVETHN

STVETHN_ETCT_CODE

PRIMARY_ETHNCITY_CATEGORY_DESC Ethnic category description. VARCHAR2(30)

STVETCT

STVETCT_DESC

PRIMARY_ETHNICITY Ethnicity used for institutional standard reporting. VARCHAR2(2)

SPBPERS

SPBPERS_ETHN_CODE

PRIMARY_ETHNICITY_DESC Ethnicity code description. VARCHAR2(30)

STVETHN

STVETHN_DESC

PRIM_DISABILITY Primary or first major disability for the person because of this handicap. VARCHAR2(2)

SPRMEDI

SPRMEDI_DISA_CODE

PRIM_DISABILITY_DESC Disability type description. VARCHAR2(30)

STVDISA

STVDISA_DESC

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

PRIM_DISABILITY_SERVICE_DESC Description of the disability service provided. VARCHAR2(30)

STVSPSR

STVSPSR_DESC

PRIM_MEDICAL_CONDITION This field identifies the medical code associated with the person. VARCHAR2(10)

SPRMEDI

SPRMEDI_MEDI_CODE

PRIM_MEDICAL_CONDITION_DESC Medical condition description. VARCHAR2(30)

STVMEDI

STVMEDI_DESC

PRIM_MEDICAL_EQUIPMENT Medical equipment required because of the person's medical problem. VARCHAR2(3)

SPRMEDI

SPRMEDI_MDEQ_CODE

PRIM_MEDICAL_EQUIPMENT_DESC Medical equipment description. VARCHAR2(30)

STVMDEQ

STVMDEQ_DESC

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 What requested information about that person can be released. VARCHAR2(0)

NA

NA

RELIGION Religious affiliation recorded for the person. VARCHAR2(2)

SPBPERS

SPBPERS_RELG_CODE

RELIGION_DESC Person's religious affiliation description. VARCHAR2(30)

STVRELG

STVRELG_DESC

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(3)

GOBINTL

GOBINTL_SPON_CODE

SPONSOR_OF_PERSON_DESC Description associated with the person's sponsor code. VARCHAR2(30)

STVSPON

STVSPON_DESC

SPOUSE_ACCOMPANIED_IND Indicates whether the spouse accompanied this person entering the institution home country. VARCHAR2(1)

GOBINTL

GOBINTL_SPOUSE_IND

TAX_ID Person's tax identification number assigned by their home federal government. VARCHAR2(15)

SPBPERS

SPBPERS_SSN

VETERAN_CATEGORY Category of veteran. Standardized by the federal government to track attendance of particular groups. VARCHAR2(1)

SPBPERS

SPBPERS_VERA_IND

VETERAN_CATEGORY_DESC The description of the Veteran Category column. VARCHAR2(60)

CALCULATION

DECODE(SPBPERS_VERA_IND)

VETERAN_FILE_NO Veteran administration assigned identification number. VARCHAR2(10)

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

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 8.2