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