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 |