| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
|
ACTIVITY_DATE
|
Last time the data was loaded for this slotted reporting view.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
GORPRAC
|
GORPRAC_PIDM
|
NO
|
NO
|
|
PROCESS_GROUP
|
Process oriented identifier for the record used to determin access authorization to this institution defined record.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
|
PROFILE_CODE
|
This BUSNIESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria.
|
VARCHAR2(63)
|
MGRSDAX
|
MGRSDAX_PROFILE_CODE
|
NO
|
NO
|
|
RACE1
|
Instittution defined race code.
|
VARCHAR2(63)
|
GORPRAC
|
GORPRAC_RACE_CDE
|
NO
|
NO
|
|
RACE2
|
Instittution defined race code.
|
VARCHAR2(63)
|
GORPRAC
|
GORPRAC_RACE_CDE
|
NO
|
NO
|
|
RACE3
|
Instittution defined race code.
|
VARCHAR2(63)
|
GORPRAC
|
GORPRAC_RACE_CDE
|
NO
|
NO
|
|
RACE4
|
Instittution defined race code.
|
VARCHAR2(63)
|
GORPRAC
|
GORPRAC_RACE_CDE
|
NO
|
NO
|
|
RACE5
|
Instittution defined race code.
|
VARCHAR2(63)
|
GORPRAC
|
GORPRAC_RACE_CDE
|
NO
|
NO
|
|
RACE_CATEGORY1
|
Reporting required race code.
|
VARCHAR2(63)
|
GORRACE
|
GORRACE_RRAC_CODE
|
NO
|
NO
|
|
RACE_CATEGORY2
|
Reporting required race code.
|
VARCHAR2(63)
|
GORRACE
|
GORRACE_RRAC_CODE
|
NO
|
NO
|
|
RACE_CATEGORY3
|
Reporting required race code.
|
VARCHAR2(63)
|
GORRACE
|
GORRACE_RRAC_CODE
|
NO
|
NO
|
|
RACE_CATEGORY4
|
Reporting required race code.
|
VARCHAR2(63)
|
GORRACE
|
GORRACE_RRAC_CODE
|
NO
|
NO
|
|
RACE_CATEGORY5
|
Reporting required race code.
|
VARCHAR2(63)
|
GORRACE
|
GORRACE_RRAC_CODE
|
NO
|
NO
|
|
RACE_CATEGORY_DESC1
|
Race category code description.
|
VARCHAR2(255)
|
GTVRRAC
|
GTVRRAC_DESC
|
NO
|
NO
|
|
RACE_CATEGORY_DESC2
|
Race category code description.
|
VARCHAR2(255)
|
GTVRRAC
|
GTVRRAC_DESC
|
NO
|
NO
|
|
RACE_CATEGORY_DESC3
|
Race category code description.
|
VARCHAR2(255)
|
GTVRRAC
|
GTVRRAC_DESC
|
NO
|
NO
|
|
RACE_CATEGORY_DESC4
|
Race category code description.
|
VARCHAR2(255)
|
GTVRRAC
|
GTVRRAC_DESC
|
NO
|
NO
|
|
RACE_CATEGORY_DESC5
|
Race category code description.
|
VARCHAR2(255)
|
GTVRRAC
|
GTVRRAC_DESC
|
NO
|
NO
|
|
RACE_DESC1
|
Race code description.
|
VARCHAR2(255)
|
GORRACE
|
GORRACE_DESC
|
NO
|
NO
|
|
RACE_DESC2
|
Race code description.
|
VARCHAR2(255)
|
GORRACE
|
GORRACE_DESC
|
NO
|
NO
|
|
RACE_DESC3
|
Race code description.
|
VARCHAR2(255)
|
GORRACE
|
GORRACE_DESC
|
NO
|
NO
|
|
RACE_DESC4
|
Race code description.
|
VARCHAR2(255)
|
GORRACE
|
GORRACE_DESC
|
NO
|
NO
|
|
RACE_DESC5
|
Race code description.
|
VARCHAR2(255)
|
GORRACE
|
GORRACE_DESC
|
NO
|
NO
|
|
RACE_RULE
|
Rule defined in MGRSDAX to populate records into the MST_RACE_SLOT table.
|
VARCHAR2(63)
|
MGRSDAX
|
MGRSDAX_INTERNAL_CODE
|
NO
|
NO
|