RETURN TO BANNER EDW META DATA REPORTS LIST | |
Admissions Application Star |
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 |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_01 | Applicant Supl Data 01 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_01_LD | Applicant Supl Data 01 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_01_SD | Applicant Supl Data 01 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_01_TYPE | Applicant Supl Data 01 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_02 | Applicant Supl Data 02 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_02_LD | Applicant Supl Data 02 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_02_SD | Applicant Supl Data 02 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_02_TYPE | Applicant Supl Data 02 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_03 | Applicant Supl Data 03 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_03_LD | Applicant Supl Data 03 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_03_SD | Applicant Supl Data 03 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_03_TYPE | Applicant Supl Data 03 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_04 | Applicant Supl Data 04 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_04_LD | Applicant Supl Data 04 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_04_SD | Applicant Supl Data 04 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_04_TYPE | Applicant Supl Data 04 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_05 | Applicant Supl Data 05 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_05_LD | Applicant Supl Data 05 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_05_SD | Applicant Supl Data 05 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_05_TYPE | Applicant Supl Data 05 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_06 | Applicant Supl Data 06 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_06_LD | Applicant Supl Data 06 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_06_SD | Applicant Supl Data 06 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_06_TYPE | Applicant Supl Data 06 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_07 | Applicant Supl Data 07 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_07_LD | Applicant Supl Data 07 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_07_SD | Applicant Supl Data 07 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_07_TYPE | Applicant Supl Data 07 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_08 | Applicant Supl Data 08 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_08_LD | Applicant Supl Data 08 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_08_SD | Applicant Supl Data 08 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_08_TYPE | Applicant Supl Data 08 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_09 | Applicant Supl Data 09 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_09_LD | Applicant Supl Data 09 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_09_SD | Applicant Supl Data 09 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_09_TYPE | Applicant Supl Data 09 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_10 | Applicant Supl Data 10 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_10_LD | Applicant Supl Data 10 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_10_SD | Applicant Supl Data 10 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_10_TYPE | Applicant Supl Data 10 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_11 | Applicant Supl Data 11 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_11_LD | Applicant Supl Data 11 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_11_SD | Applicant Supl Data 11 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_11_TYPE | Applicant Supl Data 11 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_12 | Applicant Supl Data 12 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_12_LD | Applicant Supl Data 12 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_12_SD | Applicant Supl Data 12 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_12_TYPE | Applicant Supl Data 12 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_13 | Applicant Supl Data 13 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_13_LD | Applicant Supl Data 13 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_13_SD | Applicant Supl Data 13 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_13_TYPE | Applicant Supl Data 13 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_14 | Applicant Supl Data 14 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_14_LD | Applicant Supl Data 14 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_14_SD | Applicant Supl Data 14 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_14_TYPE | Applicant Supl Data 14 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_15 | Applicant Supl Data 15 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_15_LD | Applicant Supl Data 15 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_15_SD | Applicant Supl Data 15 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_15_TYPE | Applicant Supl Data 15 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_16 | Applicant Supl Data 16 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_16_LD | Applicant Supl Data 16 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_16_SD | Applicant Supl Data 16 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_16_TYPE | Applicant Supl Data 16 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_17 | Applicant Supl Data 17 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_17_LD | Applicant Supl Data 17 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_17_SD | Applicant Supl Data 17 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_17_TYPE | Applicant Supl Data 17 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_18 | Applicant Supl Data 18 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_18_LD | Applicant Supl Data 18 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_18_SD | Applicant Supl Data 18 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_18_TYPE | Applicant Supl Data 18 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_19 | Applicant Supl Data 19 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_19_LD | Applicant Supl Data 19 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_19_SD | Applicant Supl Data 19 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_19_TYPE | Applicant Supl Data 19 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_20 | Applicant Supl Data 20 . | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_20_LD | Applicant Supl Data 20 Long Description. Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_20_SD | Applicant Supl Data 20 Short Description. | VARCHAR2(255) |
NO | NO | ADMISSIONS APPLICATION | ||
APPL_SUPL_DATA_20_TYPE | Applicant Supl Data 20 Type. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION | ||
SYSTEM_LOAD_PROCESS | Name of the transformation that created the row during the load activity process. | VARCHAR2(30) |
NO | NO | ADMISSIONS APPLICATION | ||
SYSTEM_LOAD_TMSTMP | Most current date this record was created or updated. | DATE |
NO | NO | ADMISSIONS APPLICATION |