| 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_APPLICATION RECRUITMENT_INFORMATION
|
ADMISSIONS_POPULATION ADMISSIONS_POPULATION ADMISSION_POPULATION
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
ADMISSIONS_POPULATION_LD
|
Description for the admission type.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
ADMISSIONS_POPULATION_DESC ADMISSIONS_POPULATION_DESC ADMISSION_POPULATION_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
ADMISSIONS_POPULATION_SD
|
Description for the admission type.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
ADMISSIONS_POPULATION_DESC ADMISSIONS_POPULATION_DESC ADMISSION_POPULATION_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
EDUCATION_GOAL
|
Recorded education goal from the secondary or post secondary institution.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION STUDENT
|
EDUCATION_GOAL EDUCATION_GOAL EDUCATION_GOAL
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
EDUCATION_GOAL_LD
|
Educational goal description.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION STUDENT
|
EDUCATION_GOAL_DESC EDUCATION_GOAL_DESC EDUCATION_GOAL_DESC
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
EDUCATION_GOAL_SD
|
Educational goal description.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION STUDENT
|
EDUCATION_GOAL_DESC EDUCATION_GOAL_DESC EDUCATION_GOAL_DESC
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
EDUCATION_LEVEL
|
Highest level of education completed by the applicant.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION STUDENT
|
EDUCATION_LEVEL EDUCATION_LEVEL EDUCATION_LEVEL
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
EDUCATION_LEVEL_LD
|
Description of the highest level of education recorded for the person.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION STUDENT
|
EDUCATION_LEVEL_DESC EDUCATION_LEVEL_DESC EDUCATION_LEVEL_DESC
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
EDUCATION_LEVEL_SD
|
Description of the highest level of education recorded for the person.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION STUDENT
|
EDUCATION_LEVEL_DESC EDUCATION_LEVEL_DESC EDUCATION_LEVEL_DESC
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
HOUSING_IND
|
Identifies whether the student has been placed in institutional housing.
|
VARCHAR2(63)
|
ETL GENERATED STUDENT
|
NA HOUSING_IND
|
NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
INTENDED_TIME_STATUS
|
Identifies if applicant intention is for full or part time enrollment.
|
VARCHAR2(63)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
INTENDED_TIME_STATUS INTENDED_TIME_STATUS FULL_PART_TIME_IND
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
INTENDED_TIME_STATUS_LD
|
Long description for the student's intended time status.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS ETL GENERATED
|
NA NA
|
NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT
|
|
INTENDED_TIME_STATUS_SD
|
Short description for the student's intended time status.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS ETL GENERATED
|
NA NA
|
NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT
|
|
RATE
|
Specific tuition and fee assessment rate assigned to the student.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION NA RECRUITMENT_INFORMATION
|
RATE NA RATE
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS RECRUITMENT
|
|
RATE_LD
|
Fee assessment rate code description.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION NA RECRUITMENT_INFORMATION
|
RATE_DESC NA RATE_DESC
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS RECRUITMENT
|
|
RATE_SD
|
Fee assessment rate code description.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION NA RECRUITMENT_INFORMATION
|
RATE_DESC NA RATE_DESC
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS RECRUITMENT
|
|
RESIDENCY
|
Residency code for the student identifying the type of charges the student will incur.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION STUDENT
|
RESIDENCY RESIDENCY
|
NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
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)
|
ADMISSIONS_APPLICATION STUDENT
|
RESIDENCY_IND RESIDENCY_IND
|
NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
RESIDENCY_LD
|
Long description for the residency code.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION STUDENT
|
RESIDENCY_DESC RESIDENCY_DESC
|
NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
RESIDENCY_SD
|
Short description for the residency code.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION STUDENT
|
RESIDENCY_DESC RESIDENCY_DESC
|
NO NO
|
NO
|
ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
SITE
|
Site or location to which applicant is applying.
|
VARCHAR2(63)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
SITE SITE SITE
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
SITE_LD
|
Site or location name.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
SITE_DESC SITE_DESC SITE_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
SITE_SD
|
Site or location name.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
SITE_DESC SITE_DESC SITE_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
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_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_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_KEY
|
Key for the student dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
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 ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
STUDENT_POPULATION STUDENT_POPULATION STUDENT_POPULATION
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
STUDENT_POPULATION_LD
|
Long description for student population code.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
STUDENT_POPULATION_DESC STUDENT_POPULATION_DESC STUDENT_POPULATION_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
STUDENT_POPULATION_SD
|
Short description for student population code.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
STUDENT_POPULATION_DESC STUDENT_POPULATION_DESC STUDENT_POPULATION_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION
|