Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
COLLEGE_PREP_IND	Indicates whether the prospect/applicant's secondary school program was college preparatory.	VARCHAR2(63)	PREVIOUS_EDUCATION	COLLEGE_PREP	NO	NO	EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_DIPLOMA	Type of diploma received on completion of secondary school study.	VARCHAR2(63)	PREVIOUS_EDUCATION	SECONDARY_DIPLOMA	NO	NO	PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_DIPLOMA_LD	Long description for the diploma type.	VARCHAR2(255)	PREVIOUS_EDUCATION	SECONDARY_DIPLOMA_DESC	NO	NO	PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_DIPLOMA_SD	Short description for the diploma type.	VARCHAR2(255)	PREVIOUS_EDUCATION	SECONDARY_DIPLOMA_DESC	NO	NO	PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_GPA_RANGE	Secondary GPA - Grade Point Average or Average Range	VARCHAR2(63)	PREVIOUS_EDUCATION	SCHOOL_GPA	NO	NO	EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_GPA_RANGE_LD	Long description defined in the cleansing process.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_GPA_RANGE_SD	Short description defined in the cleansing process.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_PERCENTILE_RANGE	Institution defined range for the academic percentile. This uses the PREVIOUS EDUCATION reporting view - SECONDARY SCHOOL REPORTED GPA.	VARCHAR2(63)	PREVIOUS_EDUCATION	PERCENTILE	NO	NO	EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_PERCENTILE_RANGE_LD	Long description given to the academic percentile range during the cleansing process.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_PERCENTILE_RANGE_SD	Short description given to the academic percentile range during the cleansing process.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	STUDENT ENGAGEMENT, STUDENT PROGRESS
SECONDARY_SCHOOL_KEY	Key for the secondary school dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT ENGAGEMENT, STUDENT PROGRESS
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL_GENERATED	NA	NO	NO	STUDENT ENGAGEMENT, STUDENT PROGRESS
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	STUDENT ENGAGEMENT, STUDENT PROGRESS

Ver: 9.0