Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CONCENTRATION	Major concentration or study emphasis attached to this major within the student's academic program or study.	VARCHAR2(63)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	FIRST_CONCENTRATION FOURTH_MAJOR_CONC_1 FOURTH_MAJOR_CONC_2 FOURTH_MAJOR_CONC_3 SECOND_CONCENTRATION SECOND_MAJOR_CONC_1 SECOND_MAJOR_CONC_2 SECOND_MAJOR_CONC_3 THIRD_CONCENTRATION THIRD_MAJOR_CONC_1 THIRD_MAJOR_CONC_2 THIRD_MAJOR_CONC_3	NO NO NO NO NO NO NO NO NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
CONCENTRATION_KEY	Key for the concentration dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONCENTRATION_LD	Long description for the major concentration or study emphasis.	VARCHAR2(255)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	FIRST_CONCENTRATION_DESC FOURTH_MAJOR_CONC_1_DESC FOURTH_MAJOR_CONC_2_DESC FOURTH_MAJOR_CONC_3_DESC SECOND_CONCENTRATION_DESC SECOND_MAJOR_CONC_1_DESC SECOND_MAJOR_CONC_2_DESC SECOND_MAJOR_CONC_3_DESC THIRD_CONCENTRATION_DESC THIRD_MAJOR_CONC_1_DESC THIRD_MAJOR_CONC_2_DESC THIRD_MAJOR_CONC_3_DESC	NO NO NO NO NO NO NO NO NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
CONCENTRATION_MAJOR	Major subject area to which this concentration is attached.	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
CONCENTRATION_MAJOR_LD	Long name for the student's major concentration 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
CONCENTRATION_MAJOR_SD	Short name for the student's major concentration 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
CONCENTRATION_SD	Short description for the major concentration or study emphasis.	VARCHAR2(255)	ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY	FIRST_CONCENTRATION_DESC FOURTH_MAJOR_CONC_1_DESC FOURTH_MAJOR_CONC_2_DESC FOURTH_MAJOR_CONC_3_DESC SECOND_CONCENTRATION_DESC SECOND_MAJOR_CONC_1_DESC SECOND_MAJOR_CONC_2_DESC SECOND_MAJOR_CONC_3_DESC THIRD_CONCENTRATION_DESC THIRD_MAJOR_CONC_1_DESC THIRD_MAJOR_CONC_2_DESC THIRD_MAJOR_CONC_3_DESC	NO NO NO NO NO NO NO NO NO NO NO NO	NO	ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE
DEPARTMENT	Department responsible for the major subject area of a student course or associated with the major within the student academic study.	VARCHAR2(63)	NA	NA	NO	NO	ACADEMIC PROGRAM COURSE
DEPARTMENT_LD	Long name of the department.	VARCHAR2(255)	ACADEMIC_STUDY	DEPARTMENT_DESC	NO	NO	ACADEMIC PROGRAM COURSE
DEPARTMENT_SD	Short description for this department.	VARCHAR2(255)	NA	NA	NO	NO	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_OUTCOME	PROGRAM_CLASSIFICATION	NO	NO	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	PROGRAM_CLASSIFICATION	NO	NO	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	PROGRAM_CLASSIFICATION_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