Field Name | Field Descr |
ENRL_REQUEST_ID | Enrollment Request ID, can have multiple requests (sequences) |
ENRL_REQ_DETL_SEQ | Sequence Number of an enrollment request (one request ID can have multiple requests) |
EMPLID | Student/Person ID number |
ACAD_CAREER | Code for Academic Career. Value attached to the student. |
STRM | Term |
CLASS_NBR | Class Number, a unique value within each term for a class section. |
ENRL_REQ_ACTION | Enrollment Request Action |
ENRL_ACTION_REASON | Enrollment Request Action Reason |
CLASS_NBR_CHG_TO | For a swap enrollment request, this represents into which class section a student swapped |
ENRL_REQ_DETL_STAT | Resulting status of an enrollment request ID/sequence |
OPRID | ID of administrative user who performed this action |
DTTM_STAMP_SEC | Date/Time stamp of enrollment request |
If joining to CLASS_TBL then join by STRM and CLASS_NBR |
If joining to STDNT_ENRL then join by EMPLID, STRM, and CLASS_NBR |
Set field ENRL_REQ_DETL_STAT in ('M','S') to pull successful requests |
OPRID field is the user who performed the action. If it equals EMPLID then the student did so via self-service |
Fields that begin with OVRD will show if an admin user employed an override to complete the request. |
Field ENRL_REQ_ACTION will denote if a add, drop or swap. Or grade change. |
Field CLASS_NBR_CHG_TO will have the class number for the "swap to" class section. |
Field DTTM_STAMP_SEC shows the date/time of request. |