Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

Banner Operational Data Store
Reporting View Target: PERSON_DETAIL

Description Contains demographic data common to a person across the ODS data model and the institution enterprise. The data is specific to a person independent of whether that person is a student, faculty member, or employee, alumnus, etc. Data reflects only the most current information; changes are not tracked in the ODS.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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
CHILDREN_NUMBER Number of children recorded for this person. NUMBER

GOBINTL

GOBINTL_CHILD_NUMBER

NO

NO
CITIZENSHIP_DESC Citizen type description. VARCHAR2(255)

STVCITZ

STVCITZ_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
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
CURRENT_AGE Age of the person as of today's date. NUMBER

FUNCTION

MGKFUNC.F_CALCULATE_AGE(SYSDATE, BIRTH_DATE, DECEASED_DATE),

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
DURATION_OF_STAY Indicates whether the admission or departure is for the duration of the stay. VARCHAR2(1)

GOBINTL

GOBINTL_DURATION

NO

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

GOREMAL

GOREMAL_EMAL_CODE

NO

NO
EMAIL_PREFERRED_ADDRESS Preferred email address of the person. VARCHAR2(255)

GOREMAL

GOREMAL_EMAIL_ADDRESS

NO

NO
EMAIL_PREFERRED_DESC Email address preferred description. VARCHAR2(255)

GTVEMAL

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

STVEMPT

STVEMPT_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
ETHNICITY_EDI_EQUIV EDI/SPEEDE ethnicity code that equates to the ethnic code. VARCHAR2(63)

STVETHN

STVETHN_EDI_EQUIV

NO

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

SPRIDEN

SPRIDEN_FIRST_NAME

NO

NO
FOREIGN_SSN Unique identification number for tax purposes, such as a foreign tax identification number (SSN, TIN, etc.). 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
GOVERNMENT_ID Identification assigned by the institution's home government when the tax id is from a different government. VARCHAR2(63)

NA

NA

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 ethnicity and race categories. VARCHAR2(1)

SPBPERS

SPBPERS_ETHN_CDE

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 Code that identifies if the person has a legacy relationship. VARCHAR2(63)

SPBPERS

SPBPERS_LGCY_CODE

NO

NO
LEGACY_DESC Legacy code description. VARCHAR2(255)

STVLGCY

STVLGCY_DESC

NO

NO
LEGAL_NAME Legal name associated with person. VARCHAR2(500)

SPBPERS

SPBPERS_LEGAL_NAME

NO

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

FUNCTION

GOKODSF.F_FORMAT_PREFERRED_NAME

NO

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

FUNCTION

GOKODSF.F_FORMAT_PREFERRED_NAME

NO

NO
MAILING_NAME_PREFERRED Person's preferred mailing name. 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)

STVMRTL

STVMRTL_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 Middle name of the person. 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, e.g., professional, married, maiden, etc. VARCHAR2(255)

GTVNTYP

GTVNTYP_DESC

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)

STVNATN

STVNATN_NATION

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)

STVNATN

STVNATN_NATION

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)

STVLANG

STVLANG_DESC

NO

NO
NICKNAME Nickname used by the person. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_PREFERRED_DATA

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

GOBINTL

GOBINTL_CERT_DATE_RECEIPT

NO

NO
PASSPORT_CERTIF_ELIG Passport certification eligibility code. VARCHAR2(63)

GOBINTL

GOBINTL_CELG_CODE

NO

NO
PASSPORT_CERTIF_ELIG_DESC Passport certification eligibility code description. VARCHAR2(255)

GTVCELG

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

STVNATN

STVNATN_NATION

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

SPRIDEN

SPRIDEN_PIDM

NO

NO
PREFERRED_FIRST_NAME Person's preferred name. VARCHAR2(63)

SPBPERS

SPBPERS_PREF_FIRST_NAME

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
PRIM_DISABILITY Primary or first major disability for the person because of this handicap. VARCHAR2(63)

SPRMEDI

SPRMEDI_DISA_CODE

NO

NO
PRIM_DISABILITY_DESC Disability type description. VARCHAR2(255)

STVDISA

STVDISA_DESC

NO

NO
PRIM_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
PRIM_DISABILITY_SERVICE_DESC Disability service description. VARCHAR2(255)

STVSPSR

STVSPSR_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
PRIM_MEDICAL_CONDITION Primary or first major medical condition associated with the person. VARCHAR2(63)

SPRMEDI

SPRMEDI_MEDI_CODE

NO

NO
PRIM_MEDICAL_CONDITION_DESC Medical condition description. VARCHAR2(255)

STVMEDI

STVMEDI_DESC

NO

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

SPRMEDI

SPRMEDI_MDEQ_CODE

NO

NO
PRIM_MEDICAL_EQUIPMENT_DESC Medical equipment description. VARCHAR2(255)

STVMDEQ

STVMDEQ_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 Person's religious affiliation description. VARCHAR2(255)

STVRELG

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

STVSPON

STVSPON_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
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 veteran category description. VARCHAR2(255)

CALCULATION

DECODE(SPBPERS_VERA_IND,NULL,NULL,'VETERAN')

NO

NO
VETERAN_FILE_NO 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


Ver: 9.2