| RETURN TO BANNER EDW META DATA REPORTS LIST | |
| Admissions Application Star Admissions Recruitment Star Financial Aid Pre-Student Star Recruiting And Admission Star Student Star Student Progress Star |
Description
| Pre-Student Status Dimension table provides information on the processing steps completed for those applying to study at the institution. This information includes inquired, applied, admitted, accepted and enrolled. 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 |
|---|---|---|---|---|---|---|---|
| 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) |
NO | NO | ADMISSIONS APPLICATION, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS | ||
| ADMITTED_IND | Indicates whether or not a person was offered admission to the institution and should count as admitted. | VARCHAR2(63) |
NO | NO | ADMISSIONS APPLICATION, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS | ||
| 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) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ENROLLED_IND | Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount. | VARCHAR2(63) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| 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) |
NVL(MSKFUNC.F_GET_INQUIRER_IND(A.PERSON_UID, A.ACADEMIC_PERIOD),'N') |
NO | NO | STUDENT, STUDENT PROGRESS | |
| PRE_STUDENT_STATUS_KEY | Key for the pre-student status dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SYSTEM_LOAD_PROCESS | Name of the transformation that created the row during the load activity process. | VARCHAR2(30) |
NO NO | NO |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS STUDENT PROGRESS | ||
| SYSTEM_LOAD_TMSTMP | Most current date this record was created or updated. | DATE |
NO NO | NO |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS STUDENT PROGRESS | ||
| TUITION_DEPOSITED_IND | Indicates whether there has been a deposit for tuition. | VARCHAR2(63) |
NO | NO | STUDENT, STUDENT PROGRESS |