Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_PROGRAM_KEY	Key for the academic program dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
ADMISSIONS_POPULATION	Identifies the type of admission the applicant is seeking or granted (e.g. early admit, regular admit, mature admit, special admit, etc.).	VARCHAR2(63)	ACADEMIC_STUDY	ADMISSIONS_POPULATION	NO	NO	ACADEMIC PROGRAM COURSE
ADMISSIONS_POPULATION_LD	Long description for the admission population.	VARCHAR2(255)	ACADEMIC_STUDY	ADMISSIONS_POPULATION_DESC	NO	NO	ACADEMIC PROGRAM COURSE
ADMISSIONS_POPULATION_SD	Short description for the admission population.	VARCHAR2(255)	ACADEMIC_STUDY	ADMISSIONS_POPULATION_DESC	NO	NO	ACADEMIC PROGRAM COURSE
AWARD_CATEGORY	Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc..	VARCHAR2(63)	ACADEMIC_STUDY	AWARD_CATEGORY	NO	NO	ACADEMIC PROGRAM COURSE
AWARD_CATEGORY_LD	Long description for the award category.	VARCHAR2(255)	ACADEMIC_STUDY	AWARD_CATEGORY_DESC	NO	NO	ACADEMIC PROGRAM COURSE
AWARD_CATEGORY_SD	Short description for the award category.	VARCHAR2(255)	ACADEMIC_STUDY	AWARD_CATEGORY_DESC	NO	NO	ACADEMIC PROGRAM COURSE
CAMPUS	Identifies the campus that the student is assigned as their home campus.	VARCHAR2(63)	ACADEMIC_STUDY	CAMPUS	NO	NO	ACADEMIC PROGRAM COURSE
CAMPUS_LD	Long description for the student's campus.	VARCHAR2(255)	ACADEMIC_STUDY	CAMPUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE
CAMPUS_SD	Short description for the student's campus.	VARCHAR2(255)	ACADEMIC_STUDY	CAMPUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE
COLLEGE	First level of the institution organization structure that is responsible for the academic instruction responsibility for this academic program or study.	VARCHAR2(63)	ACADEMIC_STUDY	COLLEGE	NO	NO	ACADEMIC PROGRAM COURSE
COLLEGE_LD	Long description for the student's college.	VARCHAR2(255)	ACADEMIC_STUDY	COLLEGE_DESC	NO	NO	ACADEMIC PROGRAM COURSE
COLLEGE_SD	Short description for the student's college.	VARCHAR2(255)	ACADEMIC_STUDY	COLLEGE_DESC	NO	NO	ACADEMIC PROGRAM COURSE
DEGREE	Outcome upon completion of all the requirements for a particular academic program. For example, Bachelor of Science, Associate of Arts, Vocational Certificate.	VARCHAR2(63)	ACADEMIC_STUDY	DEGREE	NO	NO	ACADEMIC PROGRAM COURSE
DEGREE_LD	Long description for the student's degree.	VARCHAR2(255)	ACADEMIC_STUDY	DEGREE_DESC	NO	NO	ACADEMIC PROGRAM COURSE
DEGREE_SD	Short description for the student's degree.	VARCHAR2(255)	ACADEMIC_STUDY	DEGREE_DESC	NO	NO	ACADEMIC PROGRAM COURSE
PROGRAM	Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.	VARCHAR2(63)	ACADEMIC_STUDY	PROGRAM	NO	NO	ACADEMIC PROGRAM COURSE
PROGRAM_LD	Long description for the student's program.	VARCHAR2(255)	ACADEMIC_STUDY	PROGRAM_DESC	NO	NO	ACADEMIC PROGRAM COURSE
PROGRAM_SD	Short description for the student's program.	VARCHAR2(255)	ACADEMIC_STUDY	PROGRAM_DESC	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_CLASSIFICATION	Identifies the student's current class at the institution. The typical values are first year, second year, or freshman, sophomore, etc..	VARCHAR2(63)	ACADEMIC_STUDY	STUDENT_CLASSIFICATION	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_CLASSIFICATION_LD	Long description for the student classification.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_CLASSIFICATION_DESC	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_CLASSIFICATION_SD	Short description for the student classification.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_CLASSIFICATION_DESC	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_LEVEL	Level of study for the student's academic program. For example, Undergraduate, Graduate, Credit, Continuing Education, etc..	VARCHAR2(63)	ACADEMIC_STUDY	STUDENT_LEVEL	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_LEVEL_LD	Long description for the student level.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_LEVEL_DESC	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_LEVEL_SD	Short description for the student level.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_LEVEL_DESC	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_POPULATION	Identifies the category this student that will be used for governmental reporting. The typical values are new first time, transfer, continuing, etc.	VARCHAR2(63)	ACADEMIC_STUDY	STUDENT_POPULATION	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_POPULATION_LD	Long description for student population.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_POPULATION_DESC	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_POPULATION_SD	Short description for student population.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_POPULATION_DESC	NO	NO	ACADEMIC PROGRAM COURSE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE

Ver: 8.1