Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
DEPARTMENT	Department responsible for the major subject area of a student course or associated with the major within the student academic study.	VARCHAR2(63)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	DEPARTMENT FOURTH_DEPARTMENT SECOND_DEPARTMENT THIRD_DEPARTMENT	NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
DEPARTMENT_LD	Long name of the department.	VARCHAR2(255)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC	NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
DEPARTMENT_SD	Short description name for this department.	VARCHAR2(255)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC	NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
MAJOR	Major subject area of the person's academic study.	VARCHAR2(63)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	FOURTH_MAJOR MAJOR SECOND_MAJOR THIRD_MAJOR	NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
MAJOR_KEY	Key for the major dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MAJOR_LD	Long name of the student's major subject area.	VARCHAR2(255)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	FOURTH_MAJOR_DESC MAJOR_DESC SECOND_MAJOR_DESC THIRD_MAJOR_DESC	NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
MAJOR_SD	Short description name of the student's major subject area.	VARCHAR2(255)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	FOURTH_MAJOR_DESC MAJOR_DESC SECOND_MAJOR_DESC THIRD_MAJOR_DESC	NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	FOURTH_PROGRAM_CLASSIFICATION PROGRAM_CLASSIFICATION SECOND_PROGRAM_CLASSIFICATION THIRD_PROGRAM_CLASSIFICATION	NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
PROGRAM_CLASSIFICATION_LD	Long text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US.	VARCHAR2(255)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	FOURTH_PROGRAM_CLASSIF_DESC PROGRAM_CLASSIFICATION_DESC SECOND_PROGRAM_CLASSIF_DESC THIRD_PROGRAM_CLASSIF_DESC	NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
PROGRAM_CLASSIFICATION_SD	Short text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US.	VARCHAR2(255)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	FOURTH_PROGRAM_CLASSIF_DESC PROGRAM_CLASSIFICATION_DESC SECOND_PROGRAM_CLASSIF_DESC THIRD_PROGRAM_CLASSIF_DESC	NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  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