| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ACCEPTED_IND
|
Indicates whether or not a person has accepted the institution's offer of admission and an application decision has been recorded to indicate the applicant accepts admission.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION CONSTANT
|
APPL_ACCEPT_ANY_TIME_IND 'N'
|
NO NO
|
NO
|
ADMISSIONS APPLICATION, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION ADMISSIONS RECRUITMENT
|
|
ADMITTED_IND
|
Indicates whether or not a person was offered admission to the institution and should count as admitted.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION CONSTANT
|
INST_ADMIT_ANY_TIME_IND 'N'
|
NO NO
|
NO
|
ADMISSIONS APPLICATION, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION ADMISSIONS RECRUITMENT
|
|
APPLIED_IND
|
Indicates whether or not a person should count as an applicant and is set to Yes when there is an entry for the person in the ADMISSIONS_APPLICATION ODS reporting view for the time dimension.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION CONSTANT CONSTANT
|
FUNCTION 'N' 'Y'
|
NO NO NO
|
NO
|
FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION ADMISSIONS RECRUITMENT ADMISSIONS APPLICATION
|
|
ENROLLED_IND
|
Indicates whether or not the student has a 'Y' on their ENROLLMENT ODS reporting view. The enrolled indicator was determined by the logic in the ERP system and based on the specific course status within the academic period or sub-academic period.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION CONSTANT
|
ENROLLED_IND INST_ADMIT_ANY_TIME_IND 'N'
|
NO NO NO
|
NO
|
FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION ADMISSIONS APPLICATION ADMISSIONS RECRUITMENT
|
|
INQUIRED_IND
|
Indicates whether or not a person should count as a prospect and is set to Yes when there is an entry for the person in the RECRUITMENT_INFORMATION ODS reporting view for the time dimension.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION CONSTANT RECRUITMENT_INFORMATION
|
FUNCTION 'Y' FUNCTION
|
NO NO NO
|
NO
|
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS RECRUITMENT FINANCIAL AID PRE STUDENT
|
|
PRE_STUDENT_STATUS_KEY
|
Key for the pre-student status dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
|
|
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, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
|
|
TUITION_DEPOSITED_IND
|
Indicates whether or not a person should count as a prospect and is set to Yes when there is an entry for the person in the RECRUITMENT_INFORMATION ODS reporting view for the time dimension.
|
VARCHAR2(63)
|
DEPOSIT ETL GENERATED
|
FUNCTION NA
|
NO NO
|
NO
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT RECRUITING AND ADMISSION
|