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

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

CHILDREN_NUMBER Number of children recorded for this person. NUMBER

GOBINTL

GOBINTL_CHILD_NUMBER

CITIZENSHIP_DESC Citizen type description. VARCHAR2(255)

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

SPBPERS

SPBPERS_CITZ_CODE

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

CURRENT_AGE Age of the person as of today's date. NUMBER

FUNCTION

MGKFUNC.F_CALCULATE_AGE(SYSDATE, BIRTH_DATE, DECEASED_DATE),

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

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

GOREMAL

GOREMAL_EMAL_CODE

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

GOREMAL

GOREMAL_EMAIL_ADDRESS

EMAIL_PREFERRED_DESC Email address preferred description. VARCHAR2(255)

GTVEMAL

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

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

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

STVETHN

STVETHN_EDI_EQUIV

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

SPRIDEN

SPRIDEN_FIRST_NAME

FOREIGN_SSN Unique identification number for tax purposes, such as a foreign tax identification number (SSN, TIN, etc.). 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')

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

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

SPBPERS

SPBPERS_LGCY_CODE

LEGACY_DESC Legacy code description. VARCHAR2(255)

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)

FUNCTION

GOKODSF.F_FORMAT_PREFERRED_NAME

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

FUNCTION

GOKODSF.F_FORMAT_PREFERRED_NAME

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

STVMRTL

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

GTVNTYP

GTVNTYP_DESC

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)

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

STVNATN

STVNATN_NATION

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)

STVLANG

STVLANG_DESC

NICKNAME Nickname used by the person. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_PREFERRED_DATA

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

GOBINTL

GOBINTL_CELG_CODE

PASSPORT_CERTIF_ELIG_DESC Passport certification eligibility code description. VARCHAR2(255)

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

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

SPRIDEN

SPRIDEN_PIDM

PREFERRED_FIRST_NAME Person's preferred name. VARCHAR2(63)

SPBPERS

SPBPERS_PREF_FIRST_NAME

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

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

SPRMEDI

SPRMEDI_DISA_CODE

PRIM_DISABILITY_DESC Disability type description. VARCHAR2(255)

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

SPRMEDI

SPRMEDI_SPSR_CODE

PRIM_DISABILITY_SERVICE_DESC Disability service description. VARCHAR2(255)

STVSPSR

STVSPSR_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

PRIM_MEDICAL_CONDITION Primary or first major medical condition associated with the person. VARCHAR2(63)

SPRMEDI

SPRMEDI_MEDI_CODE

PRIM_MEDICAL_CONDITION_DESC Medical condition description. VARCHAR2(255)

STVMEDI

STVMEDI_DESC

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

SPRMEDI

SPRMEDI_MDEQ_CODE

PRIM_MEDICAL_EQUIPMENT_DESC Medical equipment description. VARCHAR2(255)

STVMDEQ

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

STVRELG

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

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

CALCULATION

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

VETERAN_FILE_NO 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



Ver: 8.5