NEMPREQU - Required Courses (NER) Database
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
APPRDATE |
T |
8 |
0 |
Date Course was Approved |
2 |
CERTCODE |
C |
10 |
0 |
Certification Code |
3 |
CEU |
N |
7 |
2 |
CEU |
4 |
CHADATE |
T |
8 |
0 |
Last Change Date |
5 |
COMPANY |
C |
3 |
0 |
Company Code |
6 |
COMPBY |
T |
8 |
0 |
Required Completion Date |
7 |
COURSE |
C |
10 |
0 |
Course Code |
8 |
COURSEFEE |
N |
10 |
2 |
Course Fee |
9 |
COURSETYPE |
C |
10 |
0 |
Course Type Code |
10 |
CREDITS |
N |
7 |
2 |
Credits |
11 |
DURATION |
N |
5 |
0 |
Duration (Min) of each Session |
12 |
EMPNO |
C |
9 |
0 |
Employee ID |
13 |
ENRSTAT |
C |
6 |
0 |
Enrollment Status Code |
14 |
HOURS |
N |
7 |
2 |
Total Hours of All Sessions |
15 |
JOBREL |
C |
1 |
0 |
Job Related Course (Y/N) |
16 |
JOBRELCODE |
C |
10 |
0 |
Job Requirement Code |
17 |
MISC1 |
C |
25 |
0 |
Miscellaneous Field 1 |
18 |
MISC2 |
C |
25 |
0 |
Miscellaneous Field 2 |
19 |
MISC3 |
C |
25 |
0 |
Miscellaneous Field 3 |
20 |
MISC4 |
N |
12 |
2 |
Miscellaneous Field 4 |
21 |
OTHERFEES |
N |
10 |
2 |
Other Fees |
22 |
PRIORITY |
C |
5 |
0 |
Priority Assigned to Course |
23 |
REQUIRED |
C |
1 |
0 |
Course Required (Y/N) |
24 |
SESSIONS |
N |
5 |
0 |
Total Number of Sessions |
25 |
_CERTDESC |
C |
25 |
0 |
Certification Description |
26 |
_COURDESC |
C |
25 |
0 |
Course Description |
27 |
_ENRDESC |
C |
25 |
0 |
Enrollment Status Description |
28 |
_PRIDESC |
C |
25 |
0 |
Priority Description |
29 |
_TYPEDESC |
C |
25 |
0 |
Course Type Description |
30 |
_ZFILTER |
C |
25 |
0 |
Filter Function |