Reporting View Target: PERSON

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

SGHE Banner Operational Data Store
Reporting View Target: PERSON_SENSITIVE

Description Contains person data that is considered sensitive information that can be secured and accessed only by authorized staff.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

AGE Age Calculated Age (subtract the birth date from the current system date). NUMBER
FUNCTION

F_CALCULATE_AGE

BIRTH_DATE Birth Date Date of birth for the person. DATE
SPBPERS

SPBPERS_BIRTH_DATE

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

STVETHN_EDI_EQUIV

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

GOVERNMENT_ID 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 Hispanic Latino Ethinicity Indicator 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 ID Person's identification number used to access the records associated with the person. VARCHAR2(63)
SPRIDEN

SPRIDEN_ID

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 Person's last name. VARCHAR2(63)
SPRIDEN

SPRIDEN_LAST_NAME

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

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_NAME Middle Name Person's middle name. VARCHAR2(63)
SPRIDEN

SPRIDEN_MI

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

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
SPBPERS

SPBPERS_PIDM

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

SPRMEDI_DISA_CODE

PRIMARY_DISABILITY_DESC Primary Disability Description Disability type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

PRIMARY_DISABILITY_SERVICE Primary Disability Service 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_CONDITION Primary Medical Condition Primary or first major medical condition associated with the person. VARCHAR2(63)
SPRMEDI

SPRMEDI_MEDI_CODE

PRIMARY_MEDICAL_CONDITION_DESC Primary Medical Condition 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 Disability service description. 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

RELIGION Religion Religious affiliation recorded for the person. VARCHAR2(63)
SPBPERS

SPBPERS_RELG_CODE

RELIGION_DESC Religion Description Person's religious affiliation description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

TAX_ID Tax ID Person's tax identification number assigned by their home federal government. VARCHAR2(63)
SPBPERS

SPBPERS_SSN

Ver: 9.0

Description	Contains person data that is considered sensitive information that can be secured and accessed only by authorized staff.
Key & Frequency	One row per person.
Recommended Search Columns	PERSON_UID

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AGE	Age	Calculated Age (subtract the birth date from the current system date).	NUMBER	FUNCTION	F_CALCULATE_AGE
BIRTH_DATE	Birth Date	Date of birth for the person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE
ETHNICITY_EDI_EQUIV	Ethnicity Edi Equiv	EDI/SPEEDE ethnicity code that equates to the ethnic code.	VARCHAR2(63)	STVETHN	STVETHN_EDI_EQUIV
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_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	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')
GOVERNMENT_ID	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	Hispanic Latino Ethinicity Indicator	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	ID	Person's identification number used to access the records associated with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
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	Person's last name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME
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
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_NAME	Middle Name	Person's middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI
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
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SPBPERS	SPBPERS_PIDM
PRIMARY_DISABILITY	Primary Disability	Primary or first major disability for the person because of this handicap.	VARCHAR2(63)	SPRMEDI	SPRMEDI_DISA_CODE
PRIMARY_DISABILITY_DESC	Primary Disability Description	Disability type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_DISABILITY_SERVICE	Primary Disability Service	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_CONDITION	Primary Medical Condition	Primary or first major medical condition associated with the person.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MEDI_CODE
PRIMARY_MEDICAL_CONDITION_DESC	Primary Medical Condition 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	Disability service description.	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
RELIGION	Religion	Religious affiliation recorded for the person.	VARCHAR2(63)	SPBPERS	SPBPERS_RELG_CODE
RELIGION_DESC	Religion Description	Person's religious affiliation description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TAX_ID	Tax ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN