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.	VARCHAR2(63)	PRE_STUDENT	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: 9.0