Dimension Table Target: WDT

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Administrator Star Admissions Application Star Admissions Recruitment Star Application Attribute Star Application Cohort Star Application Decision Star Application Rating Star Application Requirement Star Combined Admissions Source Star Recruitment Attribute Star Recruitment Cohort Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_SEQUENCE

Description Sequence dimension table provides the set of sequence numbers.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name

SEQUENCE_KEY Key for the sequence dimension. NUMBER
ETL GENERATED

NA

NO
NO ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)
ETL GENERATED

NA

NO
NO ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE
ETL GENERATED

NA

NO
NO ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT

Ver: 9.0

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
SEQUENCE_KEY	Key for the sequence dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT