RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE 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

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Last time the data was loaded for this slotted reporting view. DATE

NA

SYSDATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determin access authorization to this insitution defined record. VARCHAR2(255)

NA

NA

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

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

GORPRAC

GORPRAC_PIDM

PROCESS_GROUP Process oriented identifier for the record used to determin access authorization to this institution defined record. VARCHAR2(255)

NA

NA

RACE1 Instittution defined race code. VARCHAR2(63)

GORPRAC

GORPRAC_RACE_CDE

RACE2 Instittution defined race code. VARCHAR2(63)

GORPRAC

GORPRAC_RACE_CDE

RACE3 Instittution defined race code. VARCHAR2(63)

GORPRAC

GORPRAC_RACE_CDE

RACE4 Instittution defined race code. VARCHAR2(63)

GORPRAC

GORPRAC_RACE_CDE

RACE5 Instittution defined race code. VARCHAR2(63)

GORPRAC

GORPRAC_RACE_CDE

RACE_CATEGORY1 Reporting required race code. VARCHAR2(63)

GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY2 Reporting required race code. VARCHAR2(63)

GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY3 Reporting required race code. VARCHAR2(63)

GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY4 Reporting required race code. VARCHAR2(63)

GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY5 Reporting required race code. VARCHAR2(63)

GORRACE

GORRACE_RRAC_CODE

RACE_CATEGORY_DESC1 Race category code description. VARCHAR2(255)

GTVRRAC

GTVRRAC_DESC

RACE_CATEGORY_DESC2 Race category code description. VARCHAR2(255)

GTVRRAC

GTVRRAC_DESC

RACE_CATEGORY_DESC3 Race category code description. VARCHAR2(255)

GTVRRAC

GTVRRAC_DESC

RACE_CATEGORY_DESC4 Race category code description. VARCHAR2(255)

GTVRRAC

GTVRRAC_DESC

RACE_CATEGORY_DESC5 Race category code description. VARCHAR2(255)

GTVRRAC

GTVRRAC_DESC

RACE_DESC1 Race code description. VARCHAR2(255)

GORRACE

GORRACE_DESC

RACE_DESC2 Race code description. VARCHAR2(255)

GORRACE

GORRACE_DESC

RACE_DESC3 Race code description. VARCHAR2(255)

GORRACE

GORRACE_DESC

RACE_DESC4 Race code description. VARCHAR2(255)

GORRACE

GORRACE_DESC

RACE_DESC5 Race code description. VARCHAR2(255)

GORRACE

GORRACE_DESC



Ver: 3.1