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

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

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

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

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

SPRIDEN

SPRIDEN_CREATE_USER

ENTITY_ORIGIN Source process or system that created or updated this record. VARCHAR2(30)

SPRIDEN

SPRIDEN_ORIGIN

ENTITY_UPDATE_USER User who made the last updated to this record. VARCHAR2(30)

SPRIDEN

SPRIDEN_USER

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

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

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.This one ethnicity group was identified as a federal reporting group for ethnicity and race categories. VARCHAR2(1)

SPBPERS

SPBPERS_ETHN_CDE

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 Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting. 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

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

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

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: