| 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
|
|
DATA_ENTRY_IND
|
Data Entry Indicator
|
Indicates if the code is to be used for financial data entry -(Y), budget entry only -(B), or if it will be used for hierarchical reporting - (N).
|
VARCHAR2(100)
|
|
FTVACCT FTVFUND FTVORGN FTVPROG
|
FTVACCT_DATA_ENTRY_IND FTVFUND_DATA_ENTRY_IND FTVORGN_DATA_ENTRY_IND FTVPROG_DATA_ENTRY_IND
|
|
EFFECTIVE_DATE
|
Effective Date
|
Date at which this information is valid. Represents a start or effective date.
|
DATE
|
|
MULTIPLE
|
MULTIPLE
|
|
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
|
|
NEXT_CHANGE_DATE
|
Next Change Date
|
Date at which this information changes. For example, if the record included a termination date, the next change date would reflect the date that the termination date was entered. Requires a future change record.
|
DATE
|
|
MULTIPLE
|
MULTIPLE
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
QUALIFIER
|
Qualifier
|
This field typcically is used for validation tables that have more than one column that makes a record unique. For instance, many of the Finance validation tables have a Chart of Accounts column which is part of the key to make a record unique. The Chart of Accounts value is stored in this column for such records. Additionally, the course term is stored here to further qualify course and course reference or the UID is stored here with name and ID.
|
VARCHAR2(100)
|
|
MULTIPLE
|
MULTIPLE
|
|
QUALIFIER_DESCRIPTION
|
Qualifier Description
|
Qualifier description.
|
VARCHAR2(2000)
|
|
MULTIPLE
|
MULTIPLE
|
|
STATUS
|
Status
|
Current status of the associated validation table record.
|
VARCHAR2(100)
|
|
MULTIPLE
|
MULTIPLE
|
|
STATUS_DESCRIPTION
|
Status Description
|
Status description.
|
VARCHAR2(2000)
|
|
MULTIPLE
|
MULTIPLE
|
|
TABLE_NAME
|
Table Name
|
Database table source name from the ERP system where the data was retrieved for the validation reporting view.
|
VARCHAR2(63)
|
|
MULTIPLE
|
MULTIPLE
|
|
TERMINATION_DATE
|
Termination Date
|
Termination date of this particular code value.
|
DATE
|
|
MULTIPLE
|
MULTIPLE
|
|
VALUE
|
Value
|
Database table value defined by the institution as a valid code entered for that table name.
|
VARCHAR2(255)
|
|
MULTIPLE
|
MULTIPLE
|
|
VALUE_DESCRIPTION
|
Value Description
|
Database table description for the value.
|
VARCHAR2(2000)
|
|
MULTIPLE
|
MULTIPLE
|