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 Key for the application supplemental indicator dimension. NUMBER
ETL GENERATED

NA

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_01 Applicant Supl Indicator 01. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND1

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_01_LD Applicant Supl Indicator 01 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_01_SD Applicant Supl Indicator 01 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_01_TYPE Applicant Supl Indicator 01 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE1

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_02 Applicant Supl Indicator 02. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND2

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_02_LD Applicant Supl Indicator 02 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_02_SD Applicant Supl Indicator 02 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_02_TYPE Applicant Supl Indicator 02 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE2

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_03 Applicant Supl Indicator 03. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND3

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_03_LD Applicant Supl Indicator 03 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_03_SD Applicant Supl Indicator 03 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_03_TYPE Applicant Supl Indicator 03 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE3

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_04 Applicant Supl Indicator 04. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND4

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_04_LD Applicant Supl Indicator 04 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_04_SD Applicant Supl Indicator 04 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_04_TYPE Applicant Supl Indicator 04 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE4

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_05 Applicant Supl Indicator 05. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND5

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_05_LD Applicant Supl Indicator 05 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_05_SD Applicant Supl Indicator 05 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_05_TYPE Applicant Supl Indicator 05 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE5

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_06 Applicant Supl Indicator 06. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND6

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_06_LD Applicant Supl Indicator 06 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_06_SD Applicant Supl Indicator 06 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_06_TYPE Applicant Supl Indicator 06 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE6

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_07 Applicant Supl Indicator 07. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND7

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_07_LD Applicant Supl Indicator 07 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_07_SD Applicant Supl Indicator 07 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_07_TYPE Applicant Supl Indicator 07 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE7

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_08 Applicant Supl Indicator 08. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND8

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_08_LD Applicant Supl Indicator 08 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_08_SD Applicant Supl Indicator 08 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_08_TYPE Applicant Supl Indicator 08 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE8

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_09 Applicant Supl Indicator 09. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND9

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_09_LD Applicant Supl Indicator 09 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_09_SD Applicant Supl Indicator 09 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_09_TYPE Applicant Supl Indicator 09 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE9

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_10 Applicant Supl Indicator 10. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND10

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_10_LD Applicant Supl Indicator 10 Long Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_10_SD Applicant Supl Indicator 10 Short Description. Description. VARCHAR2(255)
ETL GENERATED

CLEANSING_RULE

NO
NO ADMISSIONS APPLICATION

APPL_SUPL_IND_10_TYPE Applicant Supl Indicator 10 Type. VARCHAR2(63)
ADMISSIONS_APPLICATION

APPLICATION_IND_TYPE10

NO
NO ADMISSIONS APPLICATION

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

NA

NO
NO ADMISSIONS APPLICATION

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

NA

NO
NO ADMISSIONS APPLICATION

Ver: 9.0

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
APPLICATION_SUPL_IND_KEY	Key for the application supplemental indicator dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_01	Applicant Supl Indicator 01.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND1	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_01_LD	Applicant Supl Indicator 01 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_01_SD	Applicant Supl Indicator 01 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_01_TYPE	Applicant Supl Indicator 01 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE1	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_02	Applicant Supl Indicator 02.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND2	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_02_LD	Applicant Supl Indicator 02 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_02_SD	Applicant Supl Indicator 02 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_02_TYPE	Applicant Supl Indicator 02 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE2	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_03	Applicant Supl Indicator 03.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND3	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_03_LD	Applicant Supl Indicator 03 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_03_SD	Applicant Supl Indicator 03 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_03_TYPE	Applicant Supl Indicator 03 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE3	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_04	Applicant Supl Indicator 04.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND4	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_04_LD	Applicant Supl Indicator 04 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_04_SD	Applicant Supl Indicator 04 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_04_TYPE	Applicant Supl Indicator 04 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE4	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_05	Applicant Supl Indicator 05.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND5	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_05_LD	Applicant Supl Indicator 05 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_05_SD	Applicant Supl Indicator 05 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_05_TYPE	Applicant Supl Indicator 05 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE5	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_06	Applicant Supl Indicator 06.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND6	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_06_LD	Applicant Supl Indicator 06 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_06_SD	Applicant Supl Indicator 06 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_06_TYPE	Applicant Supl Indicator 06 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE6	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_07	Applicant Supl Indicator 07.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND7	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_07_LD	Applicant Supl Indicator 07 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_07_SD	Applicant Supl Indicator 07 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_07_TYPE	Applicant Supl Indicator 07 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE7	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_08	Applicant Supl Indicator 08.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND8	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_08_LD	Applicant Supl Indicator 08 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_08_SD	Applicant Supl Indicator 08 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_08_TYPE	Applicant Supl Indicator 08 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE8	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_09	Applicant Supl Indicator 09.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND9	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_09_LD	Applicant Supl Indicator 09 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_09_SD	Applicant Supl Indicator 09 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_09_TYPE	Applicant Supl Indicator 09 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE9	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_10	Applicant Supl Indicator 10.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND10	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_10_LD	Applicant Supl Indicator 10 Long Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_10_SD	Applicant Supl Indicator 10 Short Description. Description.	VARCHAR2(255)	ETL GENERATED	CLEANSING_RULE	NO	NO	ADMISSIONS APPLICATION
APPL_SUPL_IND_10_TYPE	Applicant Supl Indicator 10 Type.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_IND_TYPE10	NO	NO	ADMISSIONS APPLICATION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION