Reporting View Target: PERSON_SENSITIVE_RACE

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_RACE_SLOT

Description Contains information pertaining to the race(s) of the person.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID
ACTIVITY_DATE

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name

ACTIVITY_DATE Last time the data was loaded for this slotted reporting view.
NA

SYSDATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determin access authorization to this insitution defined record.
NA

NA

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.
NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.
NA

NA

PERSON_UID System generated, unique, internal identification number assigned to this person.
GORPRAC

GORPRAC_PIDM

PROCESS_GROUP Process oriented identifier for the record used to determin access authorization to this institution defined record.
NA

NA

RACE1 Instittution defined race code.
GORPRAC

GORPRAC_RACE_CDE

RACE2 Instittution defined race code.
GORPRAC

GORPRAC_RACE_CDE

RACE3 Instittution defined race code.
GORPRAC

GORPRAC_RACE_CDE

RACE4 Instittution defined race code.
GORPRAC

GORPRAC_RACE_CDE

RACE5 Instittution defined race code.
GORPRAC

GORPRAC_RACE_CDE

RACE_CATEGORY1 Reporting required race code.
GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY2 Reporting required race code.
GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY3 Reporting required race code.
GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY4 Reporting required race code.
GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY5 Reporting required race code.
GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY_DESC1 Race category code description.
GTVRRAC

GTVRRAC_DESC

RACE_CATEGORY_DESC2 Race category code description.
GTVRRAC

GTVRRAC_DESC

RACE_CATEGORY_DESC3 Race category code description.
GTVRRAC

GTVRRAC_DESC

RACE_CATEGORY_DESC4 Race category code description.
GTVRRAC

GTVRRAC_DESC

RACE_CATEGORY_DESC5 Race category code description.
GTVRRAC

GTVRRAC_DESC

RACE_DESC1 Race code description.
GORRACE

GORRACE_DESC

RACE_DESC2 Race code description.
GORRACE

GORRACE_DESC

RACE_DESC3 Race code description.
GORRACE

GORRACE_DESC

RACE_DESC4 Race code description.
GORRACE

GORRACE_DESC

RACE_DESC5 Race code description.
GORRACE

GORRACE_DESC

Ver: 8.3

Description	Contains information pertaining to the race(s) of the person.
Key & Frequency	One row per person.
Recommended Search Columns	PERSON_UID ACTIVITY_DATE

ODS Column	ODS Business Definition	Banner Source Name	Banner Source Column
ACTIVITY_DATE	Last time the data was loaded for this slotted reporting view.	NA	SYSDATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determin access authorization to this insitution defined record.	NA	NA
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.	GORPRAC	GORPRAC_PIDM
PROCESS_GROUP	Process oriented identifier for the record used to determin access authorization to this institution defined record.	NA	NA
RACE1	Instittution defined race code.	GORPRAC	GORPRAC_RACE_CDE
RACE2	Instittution defined race code.	GORPRAC	GORPRAC_RACE_CDE
RACE3	Instittution defined race code.	GORPRAC	GORPRAC_RACE_CDE
RACE4	Instittution defined race code.	GORPRAC	GORPRAC_RACE_CDE
RACE5	Instittution defined race code.	GORPRAC	GORPRAC_RACE_CDE
RACE_CATEGORY1	Reporting required race code.	GORRACE	GORRACE_RRAC_CODE
RACE_CATEGORY2	Reporting required race code.	GORRACE	GORRACE_RRAC_CODE
RACE_CATEGORY3	Reporting required race code.	GORRACE	GORRACE_RRAC_CODE
RACE_CATEGORY4	Reporting required race code.	GORRACE	GORRACE_RRAC_CODE
RACE_CATEGORY5	Reporting required race code.	GORRACE	GORRACE_RRAC_CODE
RACE_CATEGORY_DESC1	Race category code description.	GTVRRAC	GTVRRAC_DESC
RACE_CATEGORY_DESC2	Race category code description.	GTVRRAC	GTVRRAC_DESC
RACE_CATEGORY_DESC3	Race category code description.	GTVRRAC	GTVRRAC_DESC
RACE_CATEGORY_DESC4	Race category code description.	GTVRRAC	GTVRRAC_DESC
RACE_CATEGORY_DESC5	Race category code description.	GTVRRAC	GTVRRAC_DESC
RACE_DESC1	Race code description.	GORRACE	GORRACE_DESC
RACE_DESC2	Race code description.	GORRACE	GORRACE_DESC
RACE_DESC3	Race code description.	GORRACE	GORRACE_DESC
RACE_DESC4	Race code description.	GORRACE	GORRACE_DESC
RACE_DESC5	Race code description.	GORRACE	GORRACE_DESC