Composite View Target: AG

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AG_VALIDATION

Description Source composite view contains a number of the source systems' 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.

Target Column Business Definition Database Data Type Source Name Source Column

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(1)
NA

NA

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)
NA

NA

EFFECTIVE_DATE Date at which this information is valid. Represents a start or effective date. DATE
GTVCURR

GTVCURR_RATE_EFF_DATE

MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)
NA

NA

MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(1)
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
GTVCURR

GTVCURR_RATE_NCHG_DATE

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(30)
NA

NA

QUALIFIER_DESCRIPTION Qualifier description. VARCHAR2(30)
NA

NA

STATUS Current status of the associated validation table record. VARCHAR2(30)
GTVCURR

GTVCURR_STATUS_IND

STATUS_DESCRIPTION Status description. VARCHAR2(30)
NA

NA

TABLE_NAME Database table source name from the ERP system where the data was retrieved for the validation reporting view. VARCHAR2(14)
MULTIPLE

MULTIPLE

TERMINATION_DATE Termination date of this particular code value. DATE
GTVCURR

GTVCURR_RATE_TERM_DATE

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

MULTIPLE

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

MULTIPLE

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)
NA

NA

Ver: 8.1

Target Column	Business Definition	Database Data Type	Source Name	Source Column
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(1)	NA	NA
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
EFFECTIVE_DATE	Date at which this information is valid. Represents a start or effective date.	DATE	GTVCURR	GTVCURR_RATE_EFF_DATE
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(1)	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	GTVCURR	GTVCURR_RATE_NCHG_DATE
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(30)	NA	NA
QUALIFIER_DESCRIPTION	Qualifier description.	VARCHAR2(30)	NA	NA
STATUS	Current status of the associated validation table record.	VARCHAR2(30)	GTVCURR	GTVCURR_STATUS_IND
STATUS_DESCRIPTION	Status description.	VARCHAR2(30)	NA	NA
TABLE_NAME	Database table source name from the ERP system where the data was retrieved for the validation reporting view.	VARCHAR2(14)	MULTIPLE	MULTIPLE
TERMINATION_DATE	Termination date of this particular code value.	DATE	GTVCURR	GTVCURR_RATE_TERM_DATE
VALUE	Database table value defined by the institution as a valid code entered for that table name.	VARCHAR2(200)	MULTIPLE	MULTIPLE
VALUE_DESCRIPTION	Database table description for the value.	VARCHAR2(80)	MULTIPLE	MULTIPLE
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA