RETURN TO BANNER EDW META DATA REPORTS LIST
Admissions Application Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_APPLICATION_SUPL_DATA

Description Application Supplemental Data dimension table provides information for the person as data captured specific to institution additional definition. This information includes a descriptive label and the data value captured for a person associated with an academic period and application number. The data may as desired have an institution defined set of cleansing values that may standardize or group data into ranges depending on the type of data defined at an institution.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
APPLICATION_SUPL_DATA_KEY Key for the application supplemental data dimension. NUMBER

ETL GENERATED

NA

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_01 Applicant Supl Data 01 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO1

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_01_LD Applicant Supl Data 01 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_01_SD Applicant Supl Data 01 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_01_TYPE Applicant Supl Data 01 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE1

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_02 Applicant Supl Data 02 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO2

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_02_LD Applicant Supl Data 02 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_02_SD Applicant Supl Data 02 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_02_TYPE Applicant Supl Data 02 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE2

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_03 Applicant Supl Data 03 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO3

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_03_LD Applicant Supl Data 03 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_03_SD Applicant Supl Data 03 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_03_TYPE Applicant Supl Data 03 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE3

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_04 Applicant Supl Data 04 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO2

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_04_LD Applicant Supl Data 04 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_04_SD Applicant Supl Data 04 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_04_TYPE Applicant Supl Data 04 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE4

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_05 Applicant Supl Data 05 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO5

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_05_LD Applicant Supl Data 05 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_05_SD Applicant Supl Data 05 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_05_TYPE Applicant Supl Data 05 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE5

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_06 Applicant Supl Data 06 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO6

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_06_LD Applicant Supl Data 06 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_06_SD Applicant Supl Data 06 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_06_TYPE Applicant Supl Data 06 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE6

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_07 Applicant Supl Data 07 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO7

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_07_LD Applicant Supl Data 07 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_07_SD Applicant Supl Data 07 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_07_TYPE Applicant Supl Data 07 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE7

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_08 Applicant Supl Data 08 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO8

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_08_LD Applicant Supl Data 08 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_08_SD Applicant Supl Data 08 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_08_TYPE Applicant Supl Data 08 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE8

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_09 Applicant Supl Data 09 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO9

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_09_LD Applicant Supl Data 09 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_09_SD Applicant Supl Data 09 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_09_TYPE Applicant Supl Data 09 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE9

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_10 Applicant Supl Data 10 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO10

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_10_LD Applicant Supl Data 10 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_10_SD Applicant Supl Data 10 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_10_TYPE Applicant Supl Data 10 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE10

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_11 Applicant Supl Data 11 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO11

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_11_LD Applicant Supl Data 11 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_11_SD Applicant Supl Data 11 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_11_TYPE Applicant Supl Data 11 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE11

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_12 Applicant Supl Data 12 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO12

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_12_LD Applicant Supl Data 12 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_12_SD Applicant Supl Data 12 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_12_TYPE Applicant Supl Data 12 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE12

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_13 Applicant Supl Data 13 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO13

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_13_LD Applicant Supl Data 13 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_13_SD Applicant Supl Data 13 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_13_TYPE Applicant Supl Data 13 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE13

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_14 Applicant Supl Data 14 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO14

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_14_LD Applicant Supl Data 14 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_14_SD Applicant Supl Data 14 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_14_TYPE Applicant Supl Data 14 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE14

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_15 Applicant Supl Data 15 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO15

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_15_LD Applicant Supl Data 15 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_15_SD Applicant Supl Data 15 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_15_TYPE Applicant Supl Data 15 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE15

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_16 Applicant Supl Data 16 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO16

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_16_LD Applicant Supl Data 16 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_16_SD Applicant Supl Data 16 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_16_TYPE Applicant Supl Data 16 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE16

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_17 Applicant Supl Data 17 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO17

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_17_LD Applicant Supl Data 17 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_17_SD Applicant Supl Data 17 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_17_TYPE Applicant Supl Data 17 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE17

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_18 Applicant Supl Data 18 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO18

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_18_LD Applicant Supl Data 18 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_18_SD Applicant Supl Data 18 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_18_TYPE Applicant Supl Data 18 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE18

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_19 Applicant Supl Data 19 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO19

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_19_LD Applicant Supl Data 19 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_19_SD Applicant Supl Data 19 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_19_TYPE Applicant Supl Data 19 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE19

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_20 Applicant Supl Data 20 . VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO20

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_20_LD Applicant Supl Data 20 Long Description. Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_20_SD Applicant Supl Data 20 Short Description. VARCHAR2(255)

ETL GENERATED

CLEANSING_RULE

NO

NO ADMISSIONS APPLICATION
APPL_SUPL_DATA_20_TYPE Applicant Supl Data 20 Type. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPLICATION_INFO_TYPE20

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