RETURN TO BANNER EDW META DATA REPORTS LIST
Student Star  Student Progress Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_STUDENT_STATUS

Description Student Status Dimension table provides as set of indicators based on the student satisfying or not satisfying a number of criteria that may be used to divide and classify students into various common attributes for reporting. This information includes enrolled, new student, academic outcome awarded, cooperative education, developmental, continuing education, 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
ACAD_HISTORY_EXISTS_IND Indicates this student has courses in academic history for this academic period. NUMBER

ENROLLMENT

ACADEMIC_HISTORY_EXISTS_IND

NO

NO STUDENT, STUDENT PROGRESS
ACAD_HISTORY_EXISTS_IND_LD Long description for the academic history indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
ACAD_HISTORY_EXISTS_IND_SD Short description for the academic history indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
ACAD_OUTCOME_ENROLLED_IND Indicates that there is an academic outcome tied to the student record for this enrollment academic period. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
ACAD_OUTCOME_ENROLLED_IND_LD Long description for the academic outcome enrolled indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
ACAD_OUTCOME_ENROLLED_IND_SD Short description for the academic outcome enrolled indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
COOP_ED_PARTICIPANT_IND Indicates the student is in in a program that has a cooperative education experience in this academic period. NUMBER

ACADEMIC_STUDY

COOPERATIVE_EDUCATION_IND

NO

NO STUDENT, STUDENT PROGRESS
COOP_ED_PARTICIPANT_IND_LD Long description for participant in cooperative education indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
COOP_ED_PARTICIPANT_IND_SD Short description for participant in cooperative education indicator. VARCHAR2(255)

ETL GENERATED

NA

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. NUMBER

ENROLLMENT

ENROLLED_IND

NO

NO STUDENT, STUDENT PROGRESS
ENROLLED_IND_LD Long description for the enrolled indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
ENROLLED_IND_SD Short description for the enrolled indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
ENROLL_BY_CENSUS_DATE1_IND Identifies this student was enrolled in at least one course as of the first census date. This means the initial section add date is prior to the census date and any new course registration status does take the student out of the include in section count prior to the census date. NUMBER

ENROLLMENT

ENROLL_CENSUS_DATE1_IND

NO

NO STUDENT, STUDENT PROGRESS
ENROLL_BY_CENSUS_DATE1_IND_LD Long description for enrolled by census date 1 indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
ENROLL_BY_CENSUS_DATE1_IND_SD Short description for enrolled by census date 1 indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
ENROLL_BY_CENSUS_DATE2_IND Identifies this student was enrolled in at least one course as of the second census date. This means the initial section add date is prior to the census date and any new course registration status does take the student out of the include in section count prior to the census date. NUMBER

ENROLLMENT

ENROLL_CENSUS_DATE2_IND

NO

NO STUDENT, STUDENT PROGRESS
ENROLL_BY_CENSUS_DATE2_IND_LD Long description for enrolled by census date 2 indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
ENROLL_BY_CENSUS_DATE2_IND_SD Short description for enrolled by census date 2 indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
GRADUATE_CREDIT_ELIG_IND Indicates the student has permission to take graduate credit courses in this academic period. NUMBER

STUDENT

GRADUATE_CREDIT_ELIG_IND

NO

NO STUDENT, STUDENT PROGRESS
GRADUATE_CREDIT_ELIG_IND_LD Long description for graduate credit eligible indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
GRADUATE_CREDIT_ELIG_IND_SD Short description for graduate credit eligible indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
MATRICULATED_IND Indicates the student is matriculated in a degree seeking program at the institution. NUMBER

ACADEMIC_STUDY

MATRICULATED_IND

NO

NO STUDENT, STUDENT PROGRESS
MATRICULATED_IND_LD Long description for the matriculation indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
MATRICULATED_IND_SD Short description for the matriculation indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NEW_STUDENT_IND Indicates this is the academic period admit when the student is new to the institution. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NEW_STUDENT_IND_LD Long description for the new student indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NEW_STUDENT_IND_SD Short description for the new student indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
PERMIT_REGISTRATION_IND Indicates the student status for this academic period permits the student to register. NUMBER

ACADEMIC_STUDY

PERMIT_REGISTRATION

NO

NO STUDENT, STUDENT PROGRESS
PERMIT_REGISTRATION_IND_LD Long description for the permit registration indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
PERMIT_REGISTRATION_IND_SD Short description for the permit registration indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
REGISTERED_IND Indicates that the student is considered registered because the have at least one course section with a registration course status assigned for this academic period where the status has a yes in the include in section enrollment indicator is yes. NUMBER

ACADEMIC_STUDY

REGISTERED_IND

NO

NO STUDENT, STUDENT PROGRESS
REGISTERED_IND_LD Long description for the registered indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
REGISTERED_IND_SD Short description for the registered indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
STUDENT_STATUS_KEY Key for the student status dimension. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT PROGRESS
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL_GENERATED

NA

NO

NO STUDENT PROGRESS
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO STUDENT PROGRESS
WITHDRAWN_IND Indicates the student has an enrollment status that identifies the student as withdrawn from the institution in this academic period. NUMBER

ENROLLMENT

WITHDRAWN_IND

NO

NO STUDENT, STUDENT PROGRESS
WITHDRAWN_IND_LD Long description for the withdrawn indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
WITHDRAWN_IND_SD Short description for the withdrawn indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS


Ver: 9.0