Dimension Table Target: WDT_ACADEMIC

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Academic Outcome Star Admissions Application Star Admissions Recruitment Star Course Registration Star Enrollment Star Financial Aid Student Star Graduation Completion Star Receivable Customer Star Recruiting And Admission Star Student Star Student Progress Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ACADEMIC_STUDY

Description Academic Study Dimension table provides information for the program of study for the individual. This may be the data on the admission application or the academic outcome record that identifies the major subject area and sought award or degree, etc.. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name

ACADEMIC_STUDY_KEY Key for the academic study dimension. NUMBER
ETL GENERATED

NA

NO
NO ACADEMIC OUTCOME, ACADEMIC OUTCOME, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

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 COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

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 COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

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 COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

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 COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

CAMPUS_LD Long description for the institution campus. VARCHAR2(255)
ACADEMIC_STUDY

CAMPUS_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

CAMPUS_SD Short description for the institution campus. VARCHAR2(255)
ACADEMIC_STUDY

CAMPUS_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

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 COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

COLLEGE_LD Long description for the college. VARCHAR2(255)
ACADEMIC_STUDY

COLLEGE_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

COLLEGE_SD Short description for the college. VARCHAR2(255)
ACADEMIC_STUDY

COLLEGE_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

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 COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

DEGREE_LD Long descriptive name for the Degree. VARCHAR2(255)
ACADEMIC_STUDY

DEGREE_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

DEGREE_SD Short description of the Degree. VARCHAR2(255)
ACADEMIC_STUDY

DEGREE_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

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

DEPARTMENT

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

DEPARTMENT_LD Long name of the department. VARCHAR2(255)
ACADEMIC_STUDY

DEPARTMENT_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

DEPARTMENT_SD Short name of the department responsible for the major subject area. VARCHAR2(255)
ACADEMIC_STUDY

DEPARTMENT_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

MAJOR Major subject area of the person's academic study. VARCHAR2(63)
ACADEMIC_STUDY

MAJOR

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

MAJOR_LD Long name of the student's major subject area. VARCHAR2(255)
ACADEMIC_STUDY

MAJOR_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

MAJOR_SD Short name of the student's major subject area. VARCHAR2(255)
ACADEMIC_STUDY

MAJOR_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

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 COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

PROGRAM_CLASSIFICATION Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. VARCHAR2(63)
ACADEMIC_STUDY

PROGRAM_CLASSIFICATION

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

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_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

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 COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

PROGRAM_LD Long description of the student's program. VARCHAR2(255)
ACADEMIC_STUDY

PROGRAM_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

PROGRAM_SD Short description of the student's program. VARCHAR2(255)
ACADEMIC_STUDY

PROGRAM_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

SECOND_DEPARTMENT Department responsible for the major subject area of academic study. VARCHAR2(63)
ACADEMIC_STUDY

SECOND_DEPARTMENT

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

SECOND_DEPARTMENT_LD Long description for the department. VARCHAR2(255)
ACADEMIC_STUDY

SECOND_DEPARTMENT_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

SECOND_DEPARTMENT_SD Short description for the department. VARCHAR2(255)
ACADEMIC_STUDY

SECOND_DEPARTMENT_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

SECOND_MAJOR Major subject area of the person's academic study. VARCHAR2(63)
ACADEMIC_STUDY

SECOND_MAJOR

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

SECOND_MAJOR_LD Long name of the student's major subject area. VARCHAR2(255)
ACADEMIC_STUDY

SECOND_MAJOR_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

SECOND_MAJOR_SD Short name of the student's major subject area. VARCHAR2(255)
ACADEMIC_STUDY

SECOND_MAJOR_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

SECOND_PROG_CLASSIFICATION Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. For example CIP codes used in the Integrated Postsecondary Education Data System (IPEDS) reporting in the US. VARCHAR2(63)
ACADEMIC_STUDY

SECOND_PROGRAM_CLASSIFICATION

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

SECOND_PROG_CLASSIFICATION_LD Long text describing the area of study. VARCHAR2(255)
ACADEMIC_STUDY

SECOND_PROGRAM_CLASSIF_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

SECOND_PROG_CLASSIFICATION_SD Short text describing the area of study. VARCHAR2(255)
ACADEMIC_STUDY

SECOND_PROGRAM_CLASSIF_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

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 COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

STUDENT_LEVEL_LD Long description for the Level. VARCHAR2(255)
ACADEMIC_STUDY

STUDENT_LEVEL_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

STUDENT_LEVEL_SD Short description for the Level. VARCHAR2(255)
ACADEMIC_STUDY

STUDENT_LEVEL_DESC

NO
NO COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)
ETL GENERATED
ETL_GENERATED

NA
NA

NO
NO
NO ACADEMIC OUTCOME, ACADEMIC OUTCOME, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
STUDENT, STUDENT PROGRESS

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE
ETL GENERATED

NA

NO
NO ACADEMIC OUTCOME, ACADEMIC OUTCOME, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS

Ver: 9.0

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_STUDY_KEY	Key for the academic study dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC OUTCOME, ACADEMIC OUTCOME, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
CAMPUS_LD	Long description for the institution campus.	VARCHAR2(255)	ACADEMIC_STUDY	CAMPUS_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
CAMPUS_SD	Short description for the institution campus.	VARCHAR2(255)	ACADEMIC_STUDY	CAMPUS_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
COLLEGE_LD	Long description for the college.	VARCHAR2(255)	ACADEMIC_STUDY	COLLEGE_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
COLLEGE_SD	Short description for the college.	VARCHAR2(255)	ACADEMIC_STUDY	COLLEGE_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
DEGREE_LD	Long descriptive name for the Degree.	VARCHAR2(255)	ACADEMIC_STUDY	DEGREE_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
DEGREE_SD	Short description of the Degree.	VARCHAR2(255)	ACADEMIC_STUDY	DEGREE_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
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	DEPARTMENT	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
DEPARTMENT_LD	Long name of the department.	VARCHAR2(255)	ACADEMIC_STUDY	DEPARTMENT_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
DEPARTMENT_SD	Short name of the department responsible for the major subject area.	VARCHAR2(255)	ACADEMIC_STUDY	DEPARTMENT_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
MAJOR	Major subject area of the person's academic study.	VARCHAR2(63)	ACADEMIC_STUDY	MAJOR	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
MAJOR_LD	Long name of the student's major subject area.	VARCHAR2(255)	ACADEMIC_STUDY	MAJOR_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
MAJOR_SD	Short name of the student's major subject area.	VARCHAR2(255)	ACADEMIC_STUDY	MAJOR_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	ACADEMIC_STUDY	PROGRAM_CLASSIFICATION	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
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_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
PROGRAM_LD	Long description of the student's program.	VARCHAR2(255)	ACADEMIC_STUDY	PROGRAM_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
PROGRAM_SD	Short description of the student's program.	VARCHAR2(255)	ACADEMIC_STUDY	PROGRAM_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
SECOND_DEPARTMENT	Department responsible for the major subject area of academic study.	VARCHAR2(63)	ACADEMIC_STUDY	SECOND_DEPARTMENT	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
SECOND_DEPARTMENT_LD	Long description for the department.	VARCHAR2(255)	ACADEMIC_STUDY	SECOND_DEPARTMENT_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
SECOND_DEPARTMENT_SD	Short description for the department.	VARCHAR2(255)	ACADEMIC_STUDY	SECOND_DEPARTMENT_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
SECOND_MAJOR	Major subject area of the person's academic study.	VARCHAR2(63)	ACADEMIC_STUDY	SECOND_MAJOR	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
SECOND_MAJOR_LD	Long name of the student's major subject area.	VARCHAR2(255)	ACADEMIC_STUDY	SECOND_MAJOR_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
SECOND_MAJOR_SD	Short name of the student's major subject area.	VARCHAR2(255)	ACADEMIC_STUDY	SECOND_MAJOR_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
SECOND_PROG_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. For example CIP codes used in the Integrated Postsecondary Education Data System (IPEDS) reporting in the US.	VARCHAR2(63)	ACADEMIC_STUDY	SECOND_PROGRAM_CLASSIFICATION	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
SECOND_PROG_CLASSIFICATION_LD	Long text describing the area of study.	VARCHAR2(255)	ACADEMIC_STUDY	SECOND_PROGRAM_CLASSIF_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
SECOND_PROG_CLASSIFICATION_SD	Short text describing the area of study.	VARCHAR2(255)	ACADEMIC_STUDY	SECOND_PROGRAM_CLASSIF_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
STUDENT_LEVEL_LD	Long description for the Level.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_LEVEL_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
STUDENT_LEVEL_SD	Short description for the Level.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_LEVEL_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ACADEMIC OUTCOME, ACADEMIC OUTCOME, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ACADEMIC OUTCOME, ACADEMIC OUTCOME, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS