Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ADMISSIONS_POPULATION	Type of admission this applicant is seeking or granted (e.g.. Early admit, regular admit, mature, special, etc.).	VARCHAR2(63)	ACADEMIC_STUDY	ADMISSIONS_POPULATION	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
ADMISSIONS_POPULATION_LD	Description for the admission type.	VARCHAR2(255)	ACADEMIC_STUDY	ADMISSIONS_POPULATION_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
ADMISSIONS_POPULATION_SD	Description for the admission type.	VARCHAR2(255)	ACADEMIC_STUDY	ADMISSIONS_POPULATION_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
EDUCATION_GOAL	Recorded education goal from the secondary or post secondary institution.	VARCHAR2(63)	STUDENT	EDUCATIONAL_GOAL	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
EDUCATION_GOAL_LD	Educational goal description.	VARCHAR2(255)	STUDENT	EDUCATIONAL_GOAL_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
EDUCATION_GOAL_SD	Educational goal description.	VARCHAR2(255)	STUDENT	EDUCATIONAL_GOAL_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
EDUCATION_LEVEL	Highest level of education completed by the applicant.	VARCHAR2(63)	STUDENT	EDUCATION_LEVEL	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
EDUCATION_LEVEL_LD	Description of the highest level of education recorded for the person.	VARCHAR2(255)	STUDENT	EDUCATION_LEVEL_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
EDUCATION_LEVEL_SD	Description of the highest level of education recorded for the person.	VARCHAR2(255)	STUDENT	EDUCATION_LEVEL_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
HOUSING_IND	Idicates if the student has an institution housing assignement.	VARCHAR2(63)	ENROLLMENT	HOUSING_IND	NO	NO	STUDENT, STUDENT PROGRESS
INTENDED_TIME_STATUS	Identifies if applicant intention is for full or part time enrollment.	VARCHAR2(63)	ACADEMIC_STUDY	INTENDED_TIME_STATUS	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
INTENDED_TIME_STATUS_LD	Long description for the student's intended time status.	VARCHAR2(255)	GOVERNMENT_STUDENT	INTENDED_TIME_STATUS_DESC	NO	NO	STUDENT, STUDENT PROGRESS
INTENDED_TIME_STATUS_SD	Short description for the student's intended time status.	VARCHAR2(255)	GOVERNMENT_STUDENT	INTENDED_TIME_STATUS_DESC	NO	NO	STUDENT, STUDENT PROGRESS
RATE	Specific tuition and fee assessment rate assigned to the student.	VARCHAR2(63)	ACADEMIC_STUDY	STUDENT_RATE	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
RATE_LD	Fee assessment rate code description.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_RATE_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
RATE_SD	Fee assessment rate code description.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_RATE_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
RESIDENCY	Residency code for the student identifying the type of charges the student will incur.	VARCHAR2(63)	STUDENT	RESIDENCY	NO	NO	ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
RESIDENCY_IND	Identifies whether the student is considered in or out of the district for enrollment charges. Typically this indicates in or out of state or province but may also be in or out of county or in or out of the European Union, etc.	VARCHAR2(63)	STUDENT	RESIDENCY_IND	NO	NO	ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
RESIDENCY_LD	Long description for the residency code.	VARCHAR2(255)	STUDENT	RESIDENCY_DESC	NO	NO	ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
RESIDENCY_SD	Short description for the residency code.	VARCHAR2(255)	STUDENT	RESIDENCY_DESC	NO	NO	ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
SITE	Site or location to which applicant is applying.	VARCHAR2(63)	ACADEMIC_STUDY	SITE	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
SITE_LD	Site or location name.	VARCHAR2(255)	ACADEMIC_STUDY	SITE_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
SITE_SD	Site or location name.	VARCHAR2(255)	ACADEMIC_STUDY	SITE_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
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	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
STUDENT_CLASSIFICATION_LD	Long description for the student classification.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_CLASSIFICATION_DESC	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
STUDENT_CLASSIFICATION_SD	Short description for the student classification.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_CLASSIFICATION_DESC	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
STUDENT_KEY	Key for the Student dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT PROGRESS
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	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
STUDENT_POPULATION_LD	Long description for student population code.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_POPULATION_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS
STUDENT_POPULATION_SD	Short description for student population code.	VARCHAR2(255)	ACADEMIC_STUDY	STUDENT_POPULATION_DESC	NO	NO	COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, 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	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS  STUDENT PROGRESS
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS  STUDENT PROGRESS

Ver: 9.0