Reporting View Target: VALIDATION

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: VALIDATION

Description This view contains a number of the source system's validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.
Key & Frequency Mulitple rows per table name, qualifier, value, status, effective date, and next change date.
Recommended Search Columns TABLE_NAME,VALUE
TABLE_NAME, QUALIFIER, VALUE

Target Column Business Definition Database Data Type Source Name Source Column

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

DATA_ENTRY_IND 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 Date at which this information is valid. Represents a start or effective date. DATE
MULTIPLE

MULTIPLE

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

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-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

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. VARCHAR2(2000)
MULTIPLE

MULTIPLE

STATUS Current status of the associated validation table record. VARCHAR2(100)
MULTIPLE

MULTIPLE

STATUS_DESCRIPTION Status description. VARCHAR2(2000)
MULTIPLE

MULTIPLE

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 of this particular code value. DATE
MULTIPLE

MULTIPLE

VALUE Database table value defined by the institution as a valid code entered for that table name. VARCHAR2(255)
MULTIPLE

MULTIPLE

VALUE_DESCRIPTION Database table description for the value. VARCHAR2(2000)
MULTIPLE

MULTIPLE

Ver: 8.5

Description	This view contains a number of the source system's validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.
Key & Frequency	Mulitple rows per table name, qualifier, value, status, effective date, and next change date.
Recommended Search Columns	TABLE_NAME,VALUE TABLE_NAME, QUALIFIER, VALUE

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
DATA_ENTRY_IND	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	Date at which this information is valid. Represents a start or effective date.	DATE	MULTIPLE	MULTIPLE
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
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-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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.	VARCHAR2(2000)	MULTIPLE	MULTIPLE
STATUS	Current status of the associated validation table record.	VARCHAR2(100)	MULTIPLE	MULTIPLE
STATUS_DESCRIPTION	Status description.	VARCHAR2(2000)	MULTIPLE	MULTIPLE
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 of this particular code value.	DATE	MULTIPLE	MULTIPLE
VALUE	Database table value defined by the institution as a valid code entered for that table name.	VARCHAR2(255)	MULTIPLE	MULTIPLE
VALUE_DESCRIPTION	Database table description for the value.	VARCHAR2(2000)	MULTIPLE	MULTIPLE