Dimension Table Target: WDT_APPLICATION_SUPL

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Admissions Application Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_APPLICATION_SUPL_IND

Description Application Supplemental Indicator dimension table provides information for the person as data captured specific to institution additional definition. This information includes a descriptive label and either a yes or a no value for a person associated with an academic period and application number. Cleansing rules can define a specific label associated with the yes value and a different label for the no value to be used on reports.

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

APPLICATION_SUPL_IND_KEY NUMBER
ETL GENERATED

NA

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_01 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND1

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_01_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_01_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_01_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE1

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_02 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND2

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_02_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_02_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_02_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE2

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_03 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND3

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_03_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_03_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_03_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE3

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_04 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND4

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_04_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_04_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_04_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE4

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_05 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND5

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_05_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_05_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_05_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE5

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_06 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND6

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_06_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_06_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_06_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE6

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_07 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND7

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_07_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_07_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_07_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE7

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_08 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND8

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_08_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_08_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_08_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE8

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_09 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND9

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_09_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_09_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_09_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE9

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_10 VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND10

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_10_LD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_10_SD VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_10_TYPE VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE10

NO
NO ADMISSIONS APPLICATION

SYSTEM_LOAD_PROCESS VARCHAR2(30)
ETL GENERATED

NA

NO
NO ADMISSIONS APPLICATION

SYSTEM_LOAD_TMSTMP DATE
ETL GENERATED

NA

NO
NO ADMISSIONS APPLICATION

Ver: 8.2

Target Column	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
APPLICATION_SUPL_IND_KEY	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_01	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND1	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_01_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_01_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_01_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE1	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_02	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND2	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_02_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_02_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_02_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE2	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_03	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND3	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_03_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_03_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_03_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE3	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_04	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND4	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_04_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_04_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_04_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE4	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_05	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND5	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_05_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_05_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_05_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE5	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_06	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND6	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_06_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_06_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_06_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE6	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_07	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND7	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_07_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_07_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_07_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE7	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_08	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND8	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_08_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_08_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_08_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE8	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_09	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND9	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_09_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_09_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_09_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE9	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_10	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND10	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_10_LD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_10_SD	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_10_TYPE	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE10	NO	NO	ADMISSIONS APPLICATION
SYSTEM_LOAD_PROCESS	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
SYSTEM_LOAD_TMSTMP	DATE	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION