...
For each class, a student will have one of these records. This does not mean that the student is enrolled. For that, the field STDNT_ENRL_STATUS must be checked. If a student is enrolled, the status will be 'E'; if a student is waitlisted for a class, the status will be 'W'; if the student was enrolled and subsequently dropped the class, the status would be 'D'. Therefore, you must check the STDNT_ENRL_STATUS for 'E' to determine in which classes a student is enrolled or even if this is an enrolled student for the term.
| Info |
|---|
| STDNT_ENRL is missing some class information, such as subject, catalog number and description. For this detail, you must join STDNT_ENRL to CLASS_TBL, which contains that class information. Or, instead of using STDNT_ENRL, use the |
...
| view CLASS_TBL_SE_VW, which joins STDNT_ENRL to CLASS_TBL for you. |
STDNT_ENRL Record/Table
| Field Name | Description/Notes |
|---|---|
| EMPLID | Empl ID (key) |
| ACAD_CAREER | Academic Career (key) |
| INSTITUTION | Academic Institution (key) |
| STRM | Term (key) |
| CLASS_NBR | Class Nbr (key) |
| CRSE_CAREER | Course Career |
| SESSION_CODE | Session |
| SESSN_ENRL_CNTL | Enrollment Control Session |
| STDNT_ENRL_STATUS | Student Enrollment Status |
| ENRL_STATUS_REASON | Enrollment Status Reason ('E' for enrolled, 'W' for waitlisted, 'D' for dropped.) |
| ENRL_ACTION_LAST | Last Enrollment Action |
| ENRL_ACTN_RSN_LAST | Last Enrl Action Reason |
| ENRL_ACTN_PRC_LAST | Last Enrollment Action Process |
| STATUS_DT | Status Date |
| ENRL_ADD_DT | Enrollment Add Date |
| ENRL_DROP_DT | Enrollment Drop Date |
| UNT_TAKEN | Units Taken |
| UNT_PRGRSS | Units Taken - Academic Progress |
| UNT_PRGRSS_FA | Units Taken - Fin Aid Progress |
| UNT_BILLING | Billing Units |
| CRSE_COUNT | Course Count |
| GRADING_BASIS_ENRL | Grading Basis |
| GRADING_BASIS_DT | Grading Basis Date |
| OVRD_GRADING_BASIS | Override Grading Basis |
| CRSE_GRADE_OFF | Official Grade |
| CRSE_GRADE_INPUT | Grade Input |
| GRADE_DT | Grade Date |
| REPEAT_CODE | Repeat Code |
| REPEAT_DT | Repeat Date |
| CLASS_PRMSN_NBR | Class Permission Nbr |
| ASSOCIATED_CLASS | Associated Class |
| STDNT_POSITIN | Student Position |
| AUDIT_GRADE_BASIS | Audit Grading Basis |
| EARN_CREDIT | Earn Credit |
| INCLUDE_IN_GPA | Include in GPA |
| UNITS_ATTEMPTED | Units Attempted |
| GRADE_POINTS | Grade Points |
| GRADE_POINTS_FA | Financial Aid Grade Points |
| GRD_PTS_PER_UNIT | Grade Points Per Unit |
| MANDATORY_GRD_BAS | Mandatory Grading Basis |
| RSRV_CAP_NBR | Reserve Capacity Sequence |
| RQMNT_DESIGNTN | Requirement Designation |
| RQMNT_DESIGNTN_OPT | Requirement Designation Option |
| RQMNT_DESIGNTN_GRD | Requirement Designation Grade |
| INSTRUCTOR_ID | Instructor ID |
| DROP_CLASS_IF_ENRL | Drop This Class if Enrolled |
| ASSOCIATION_99 | Association 99 |
| OPRID | User ID |
| TSCRPT_NOTE_ID | Transcript Note ID |
| TSCRPT_NOTE_EXISTS | Transcript Note Exists Flag |
| NOTIFY_STDNT_CHNG | Notify Student of Change |
| REPEAT_CANDIDATE | Repeat Candidate Flag |
| VALID_ATTEMPT | Valid Attempted Grade |
| GRADE_CATEGORY | Grade Category |
| SEL_GROUP | Tuition Group |
| DYN_CLASS_NBR | Dynamic Class Nbr |
| UNT_EARNED | Units Earned |
| LAST_UPD_DT_STMP | Last Update Date Stamp |
| LAST_UPD_TM_STMP | Last Update Time Stamp |
| LAST_ENRL_DT_STMP | Last Enrollment Date Stamp |
| LAST_ENRL_TM_STMP | Last Enrollment Time Stamp |
| LAST_DROP_DT_STMP | Last Drop Date Stamp |
| LAST_DROP_TM_STMP | Last Drop Time Stamp |
| ENRL_REQ_SOURCE | Enrollment Request Source |
| LAST_UPD_ENREQ_SRC | Enrollment Request Source |
| GRADING_SCHEME_ENR | Field is not active yet |
| RELATE_CLASS_NBR_1 | Field is not active yet |
| RELATE_CLASS_NBR_2 | Field is not active yet |
| ACAD_PROG | Academic Program |
...