EP_WF_CLASS_V1 List of Fields
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) |
|
Term |
Term Value |
A4 |
Term Code |
|
|
SRC_SYS_ID |
Source ID |
Source System Identification |
A5 |
NU Production System (PRDNU) |
|
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 |
|
Local State |
Local State |
A6 |
Local State |
|
|
LOCL_POSTAL |
Local Postal |
Local Postal Code |
A12 |
Local Zip Code |
|
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 |
Permanent State |
A6 |
Permanent state |
|
|
PERM_POSTAL |
Perm Postal |
Permanent Postal Code |
A12 |
Permanent zip code |
|
Perm Country |
Permanent Country |
A3 |
Permanent country code |
|
|
CATALOG_NBR |
Ctlg Nbr |
Catalog Number |
A18 |
Course number (ACCT – 201) |
|
Acad Group |
Academic Group |
A5 |
College |
|
|
Subject |
Subject |
A25 |
Subject of the course (ACCT – 201) |
|
|
Component |
Course Component |
A3 |
Activity type of the section |
|
|
DESCR |
Descr |
Description |
A30 |
Course title |
|
Class Stat |
Class Status |
A1 |
Indicates whether the section is open or closed |
|
|
Class Type |
Class Type |
A1 |
Indicates whether section is enrollment or non-enrollment |
|
|
Acad Org |
Academic Organization |
A10 |
Academic department of the course |
|
|
Location |
Location Code |
A10 |
Campus location the section will be taught on |
|
|
CAMPUS |
Campus |
Campus |
A5 |
NEUNL |
|
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) |
|
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) |
|
Status Rsn |
Enrollment Status Reason |
A4 |
Reason associated with the enrollment status |
|
|
Grade Base |
Grading Basis |
A3 |
The grading type that the student enrolled in section |
|
|
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 |