RETURN TO DIMENSION TABLE REPORTS LIST
Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_PRE_STUDENT

Description Pre-Student Dimension table provides information for the person who may be inquiring or applying to study at the institution. This information includes academic percentile (secondary school rank/size) and the test scores identified for the student level load of data. It uses the cleansing rules in the EDW for the short and long descriptions as well as the definition of the ranges for each particular test score and the academic percentile.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_PERCENTILE Identifies the person's class percentile as it related to their secondary school graduating class rank and size NUMBER

PRE_STUDENT

PS_SCHOOL_PERCENTILE

SECONDARY_SCHOOL_PERCENTILE

NO

NO

RECRUITING AND ADMISSION

ACADEMIC_PERCENTILE_RANGE Institution defined range for the academic percentile. This uses the PREVIOUS EDUCATION reporting view - SECONDARY SCHOOL REPORTED GPA. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

ACADEMIC_PERCENTILE_RANGE_LD Long description given to the academic percentile range during the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

ACADEMIC_PERCENTILE_RANGE_SD Short description given to the academic percentile range during the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

PRE_STUDENT_KEY Key for the pre-student dimension. NUMBER

ETL GENERATED

NA

NO

NO

RECRUITING AND ADMISSION

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

ETL GENERATED

NA

NO

NO

RECRUITING AND ADMISSION

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

ETL GENERATED

NA

NO

NO

RECRUITING AND ADMISSION

TEST1 Test type. VARCHAR2(63)

TEST

TEST

NO

NO

RECRUITING AND ADMISSION

TEST1_LD Long description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST1_SCORE Score for this test. VARCHAR2(63)

TEST

TEST_SCORE

NO

NO

RECRUITING AND ADMISSION

TEST1_SCORE_RANGE Range within that the pre_student test score fits. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST1_SCORE_RANGE_LD Long description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST1_SCORE_RANGE_SD Short description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST1_SD Short description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST2 Test type. VARCHAR2(63)

TEST

TEST

NO

NO

RECRUITING AND ADMISSION

TEST2_LD Long description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST2_SCORE Score for this test. VARCHAR2(63)

TEST

TEST_SCORE

NO

NO

RECRUITING AND ADMISSION

TEST2_SCORE_RANGE Range within that the pre_student test score fits. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST2_SCORE_RANGE_LD Long description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST2_SCORE_RANGE_SD Short description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST2_SD Short description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST3 Test type. VARCHAR2(63)

TEST

TEST

NO

NO

RECRUITING AND ADMISSION

TEST3_LD Long description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST3_SCORE Score for this test. VARCHAR2(63)

TEST

TEST_SCORE

NO

NO

RECRUITING AND ADMISSION

TEST3_SCORE_RANGE Range within that the pre_student test score fits. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST3_SCORE_RANGE_LD Long description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST3_SCORE_RANGE_SD Short description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST3_SD Short description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST4 Test type. VARCHAR2(63)

TEST

TEST

NO

NO

RECRUITING AND ADMISSION

TEST4_LD Long description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST4_SCORE Score for this test. VARCHAR2(63)

TEST

TEST_SCORE

NO

NO

RECRUITING AND ADMISSION

TEST4_SCORE_RANGE Range within that the pre_student test score fits. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST4_SCORE_RANGE_LD Long description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST4_SCORE_RANGE_SD Short description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST4_SD Short description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST5 Test type. VARCHAR2(63)

TEST

TEST

NO

NO

RECRUITING AND ADMISSION

TEST5_LD Long description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST5_SCORE Score for this test. VARCHAR2(63)

TEST

TEST_SCORE

NO

NO

RECRUITING AND ADMISSION

TEST5_SCORE_RANGE Range within that the pre_student test score fits. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST5_SCORE_RANGE_LD Long description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST5_SCORE_RANGE_SD Short description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST5_SD Short description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST6 Test type. VARCHAR2(63)

TEST

TEST

NO

NO

RECRUITING AND ADMISSION

TEST6_LD Long description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST6_SCORE Score for this test. VARCHAR2(63)

TEST

TEST_SCORE

NO

NO

RECRUITING AND ADMISSION

TEST6_SCORE_RANGE Range within that the pre_student test score fits. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST6_SCORE_RANGE_LD Long description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST6_SCORE_RANGE_SD Short description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST6_SD Short description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST7 Test type. VARCHAR2(63)

TEST

TEST

NO

NO

RECRUITING AND ADMISSION

TEST7_LD Long description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION

TEST7_SCORE Score for this test. VARCHAR2(63)

TEST

TEST_SCORE

NO

NO

RECRUITING AND ADMISSION

TEST7_SCORE_RANGE Range within that the pre_student test score fits. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST7_SCORE_RANGE_LD Long description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST7_SCORE_RANGE_SD Short description for the test score range. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

TEST7_SD Short description for the type of test. VARCHAR2(255)

TEST

TEST_DESC

NO

NO

RECRUITING AND ADMISSION



Ver: 3.1