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 associated with the degree related to this outcome.	VARCHAR2(255)	ACADEMIC_STUDY	AWARD_CATEGORY_DESC	NO	NO	ACADEMIC PROGRAM COURSE
AWARD_CATEGORY_SD	Short description for the award category associated with the degree related to this outcome.	VARCHAR2(255)	ACADEMIC_STUDY	AWARD_CATEGORY_DESC	NO	NO	ACADEMIC PROGRAM COURSE
CAMPUS	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	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 owns the student or the academic instruction for a student course.	VARCHAR2(63)	ACADEMIC_STUDY	COLLEGE	NO	NO	ACADEMIC PROGRAM COURSE
COLLEGE_LD	Long description for the college.	VARCHAR2(255)	ACADEMIC_STUDY	COLLEGE_DESC	NO	NO	ACADEMIC PROGRAM COURSE
COLLEGE_SD	Short description for the college.	VARCHAR2(255)	ACADEMIC_STUDY	COLLEGE_DESC	NO	NO	ACADEMIC PROGRAM COURSE
DEGREE	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.	VARCHAR2(63)	ACADEMIC_STUDY	DEGREE	NO	NO	ACADEMIC PROGRAM COURSE
DEGREE_LD	Long descriptive name for the Degree.	VARCHAR2(255)	ACADEMIC_STUDY	DEGREE_DESC	NO	NO	ACADEMIC PROGRAM COURSE
DEGREE_SD	Short description of the Degree.	VARCHAR2(255)	ACADEMIC_STUDY	DEGREE_DESC	NO	NO	ACADEMIC PROGRAM COURSE
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(63)	ACADEMIC_STUDY	PROGRAM	NO	NO	ACADEMIC PROGRAM COURSE
PROGRAM_LD	Long description of the student's program.	VARCHAR2(255)	ACADEMIC_STUDY	PROGRAM_DESC	NO	NO	ACADEMIC PROGRAM COURSE
PROGRAM_SD	Short description of 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 students program or course work. 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 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 code.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_POPULATION_DESC	NO	NO	ACADEMIC PROGRAM COURSE
STUDENT_POPULATION_SD	Short description for student population code.	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: 9.0