EP_WF_CLASS_V1 Field List
This is the Class Enrollment table representing student enrollment in classes for a term. There is 1 row per class enrollment. Dropped classes after the retain date for the term are also present.
| FIELD NAME | TITLE | DESCRIPTION | FORMAT | EXPLANATION |
|---|---|---|---|---|
| EMPLID | ID | EmplID | A11 | Student NUID |
| INSTITUTION | Institution | Academic Institution | A5 | University Institution Code (NEUNL) |
| STRM | Term | Term Value | A4 | Term Code |
| SRC_SYS_ID | Source ID | Source System Identification | A5 | NU Production System (PRDNU) |
| SESSION_CODE | Session | Session | A3 | Term session code |
| CLASS_SECTION | Section | Class Section | A4 | Class section of the course |
| CRSE_ID | Course ID | Course ID | A6 | Sequential number assigned by the system to courses in the course catalog |
| LAST_NAME | LastName | Last Name | A30 | Student Last Name |
| FIRST_NAME | FirstName | First Name | A30 | Student First Name |
| MIDDLE_NAME | Middle Name | Middle Name | A30 | Student Middle Name |
| NAME_SUFFIX | Suffix | Name Suffix | A15 | Student Name Suffix |
| PREF_EMAIL | Pref Email Addr | Preferred Email Address | A70 | Email Address marked preferred by Student |
| PERS_EMAIL | Pers Emial | Personal Email Address | A70 | Personal Email Address – Admission Application will update this address |
| UNK_CAMPUS_EMAIL | UNK Campus Emai | UNK Campus Email Address | A70 | UNK’s assigned email address |
| UNMC_CAMPUS_EMAIL | UNMC Campus Ema | UNMC Campus Email Address | A70 | UNMC’s assigned email address |
| UNO_CAMPUS_EMAIL | UNO Campus Emai | UNO Campus Email Address | A70 | UNO’s assigned email address |
| WORK_EMAIL | Work Email | Work Email Address | A70 | Email address obtained from SAP |
| PHONE | Phone | Telephone | A24 | Phone Number marked as preferred by student |
| LOCL_ADDRESS1 | Local Address 1 | Local Address 1 | A55 | Local Street 1 |
| LOCL_ADDRESS2 | Locl Address 2 | Local Address Line 2 | A55 | Local Street 2 |
| LOCL_CITY | Local City | Local City | A30 | Local City |
| LOCL_STATE | Local State | Local State | A6 | Local State |
| LOCL_POSTAL | Local Postal | Local Postal Code | A12 | Local Zip Code |
| LOCL_COUNTRY | Local Country | Local Country | A3 | Local Country Code |
| PERM_ADDRESS1 | Perm Address 1 | Permanent Address 1 | A55 | Permanent Street 1 |
| PERM_ADDRESS2 | Perm Address 2 | Permanent Address 2 | A55 | Permanent Street 2 |
| PERM_CITY | Perm City | Permanent City | A30 | Permanent City |
| PERM_STATE | Perm State | Permanent State | A6 | Permanent state |
| PERM_POSTAL | Perm Postal | Permanent Postal Code | A12 | Permanent zip code |
| PERM_COUNTRY | Perm Country | Permanent Country | A3 | Permanent country code |
| CATALOG_NBR | Ctlg Nbr | Catalog Number | A18 | Course number (ACCT – 201) |
| ACAD_GROUP | Acad Group | Academic Group | A5 | College |
| SUBJECT | Subject | Subject | A25 | Subject of the course (ACCT – 201) |
| SSR_COMPONENT | Component | Course Component | A3 | Activity type of the section |
| DESCR | Descr | Description | A30 | Course title |
| CLASS_STAT | Class Stat | Class Status | A1 | Indicates whether the section is open or closed |
| CLASS_TYPE | Class Type | Class Type | A1 | Indicates whether section is enrollment or non-enrollment |
| ACAD_ORG | Acad Org | Academic Organization | A10 | Academic department of the course |
| LOCATION | Location | Location Code | A10 | Campus location the section will be taught on |
| CAMPUS | Campus | Campus | A5 | NEUNL |
| INSTRUCTION_MODE | Mode | Instruction Mode | A2 | Course delivery type |
| START_DT | Start Date | Start Date | YYMD | Section start date |
| END_DT | End Date | End Date | YY MD | Section end date |
| COMBINED_SECTION | Comb Sect | Combined Section | A1 | Flag indicating section is combined with others (C, blank) |
| ACAD_CAREER | Career | Academic Career | A4 | Career the student registered for the course under (also indicates which transcript course will appear on) |
| STDNT_ENRL_STATUS | Status | Student Enrollment Status | A2 | Indicates enrolled or dropped (E, D) |
| ENRL_STATUS_REASON | Status Rsn | Enrollment Status Reason | A4 | Reason associated with the enrollment status |
| GRADING_BASIS_ENRL | Grade Base | Grading Basis | A3 | The grading type that the student enrolled in section |
| REPEAT_CODE | Repeat | Repeat Code | A4 | Indicates the course was repeated or included in academic bankruptcy |
| CRSE_GRADE_INPUT | Grade In | Grade Input | A3 | Grade reported by the instructor |
| CRSE_GRADE_OFF | Grade | Official Grade | A3 | Official grade on the student’s record |
| UNITS_ATTEMPTED | Units Att | Units Attempted | A1 | Indicates valid attempt (Y, N) |
| EARN_CREDIT | EarnCredit | Earn Credit | A1 | Indicates if credit was earned (Y, N) |
| ENRL_ADD_DT | Add Dt | Enrollment Add Date | YYMD | Date student enrolled in the course |
| ENRL_DROP_DT | Drop Dt | Enrollment Drop Date | YYMD | Date student dropped the course |
| GRADE_DT | Grade Dt | Grade Date | YYMD | Date the grade was posted |
| INSTR_ID_1 | Instr ID 1 | Instructor ID 1 | A11 | NUID of the 1st instructor |
| INSTR_NAME_1 | Instr Name 1 | Instructor Name 1 | A50 | Name of the 1st instructor |
| GRAD_RSTR_ACCESS_1 | Access 1 | Grade Roster Access 1 | A1 | Instructor 1st grade roster access flag |
| INSTR_ID_2 | Instr ID 2 | Instructor ID 2 | A11 | NUID of the 2nd instructor |
| INSTR_NAME_2 | Instr Name 2 | Instructor Name 2 | A50 | Name of the 2nd instructor |
| GRAD_RSTR_ACCESS_2 | Access 2 | Grade Roster Access 2 | A1 | Instructor 2nd grade roster access flag |
| INSTR_ID_3 | Instr ID 3 | Instructor ID 3 | A11 | NUID of the 3rd instructor |
| INSTR_NAME_3 | Instr Name 3 | Instructor Name 3 | A50 | Name of the 3rd instructor |
| GRAD_RSTR_ACCESS_3 | Access 3 | Grade Roster Access 3 | A1 | Instructor 3rd grade roster access flag |
| INSTR_ID_4 | Instr ID 4 | Instructor ID 4 | A11 | NUID of the 4th instructor |
| INSTR_NAME_4 | Instr Name 4 | Instructor Name 4 | A50 | Name of the 4th instructor |
| GRAD_RSTR_ACCESS_4 | Access 4 | Grade Roster Access 4 | A1 | Instructor 4th grade roster access flag |
| INSTR_ID_5 | Instr ID 5 | Instructor ID 5 | A11 | NUID of the 5th instructor |
| INSTR_NAME_5 | Instr Name 5 | Instructor Name 5 | A50 | Name of the 5th instructor |
| GRAD_RSTR_ACCESS_5 | Access 5 | Grade Roster Access 5 | A1 | Instructor 5th grade roster access flag |
| INSTR_ID_6 | Instr ID 6 | Instructor ID 6 | A11 | NUID of the 6th instructor |
| INSTR_NAME_6 | Instr Name 6 | Instructor Name 6 | A50 | Name of the 6th instructor |
| GRAD_RSTR_ACCESS_6 | Access 6 | Grade Roster Access 6 | A1 | Instructor 6th grade roster access flag |
| INSTR_ID_7 | Instr ID 7 | Instructor ID 7 | A11 | NUID of the 7th instructor |
| INSTR_NAME_7 | Instr Name 7 | Instructor Name 7 | A50 | Name of the 7th instructor |
| GRAD_RSTR_ACCESS_7 | Access 7 | Grade Roster Access 7 | A1 | Instructor 7th grade roster access flag |
| INSTR_ID_8 | Instr ID 8 | Instructor ID 8 | A11 | NUID of the 8th instructor |
| INSTR_NAME_8 | Instr Name 8 | Instructor Name 8 | A50 | Name of the 8th instructor |
| GRAD_RSTR_ACCESS_8 | Access 8 | Grade Roster Access 8 | A1 | Instructor 8th grade roster access flag |
| CREATED_EW_DTTM | EW Insert Dttm | Datetime row inserted in EW | HYYMDS | Date and time table was populated |
| OPRID | User | User ID | A30 | NUID of person running the report |
| INSTITUTION_CD | INSTITUTION_CD | INSTITUTION_CD | A5 | NEUNL |
| CLASS_NBR | Class Nbr | Class Nbr | I5 | Section call number used when registering |
| CRSE_OFFER_NBR | Offer Nbr | Course Offering Nbr | I2 | Course catalog offering number |
| ASSOCIATED_CLASS | Assoc | Associated Class | I2 | Number used to tie lecture, lab, recitation, and quiz sections together |
| UNT_TAKEN | Unit Taken | Units Taken | D7.2 | Registered credit hours |
| UNT_PRGRSS | Progress | Units Taken-Academic Progress | D7.2 | Hours taken toward academic progress |
| UNT_BILLING | Bill Units | Billing Units | D7.2 | Hours the student is being billed for |
| UNT_EARNED | Units | Units Earned | D7.2 | Credit hours the student earned for the course |
| GRADE_POINTS | Grd Points | Grade Points | D11.3 | Quality points |
| GRD_PTS_PER_UNIT | Grd Pt/Unt | Grade Points Per Unit | D11.3 | Quality points per hour |
| CRSE_COUNT | Crse Count | Course Count | D6.2 | 1 |
| INSTITUTION_SID | INSTITUTION_SID | INSTITUTION_SID | I11 | do not use |
| INSTITUTION_SID | INSTITUTION_SID | INSTITUTION_SID | I11 | do not use |