Employee Training Programs (NEP) Database
| Seq | Field Name | Type | Length | Dec | Description |
|---|---|---|---|---|---|
|
1 |
CHADATE |
T |
8 |
0 |
Last Change Date |
|
2 |
COMCEU |
N |
7 |
2 |
Total CEU Completed |
|
3 |
COMCOUR |
N |
3 |
0 |
Total Courses Completed |
|
4 |
COMCREDITS |
N |
7 |
2 |
Total Credits Completed |
|
5 |
COMHOUR |
N |
9 |
2 |
Total Hours Completed |
|
6 |
COMPANY |
C |
3 |
0 |
Company Code |
|
7 |
EMPNO |
C |
9 |
0 |
Employee ID |
|
8 |
ENDDATE |
T |
8 |
0 |
Date Program Ends |
|
9 |
GRADE |
C |
5 |
0 |
Grade Received |
|
10 |
JOBREL |
C |
1 |
0 |
Job Related (Y/N) |
|
11 |
JOBRELCODE |
C |
10 |
0 |
Job Requirement Code |
|
12 |
MISC1 |
C |
25 |
0 |
User Defined 1 |
|
13 |
MISC2 |
C |
25 |
0 |
User Defined 2 |
|
14 |
MISC3 |
C |
25 |
0 |
User Defined 3 |
|
15 |
MISC4 |
N |
12 |
2 |
User Defined 4 |
|
16 |
PROGRAM |
C |
10 |
0 |
Program Status Code |
|
17 |
PROGSTAT |
C |
4 |
0 |
Employee Status in Program Code |
|
18 |
REMCEU |
N |
7 |
2 |
Total CEU Remaining |
|
19 |
REMCOUR |
N |
3 |
0 |
Number of Courses Remaining |
|
20 |
REMCREDITS |
N |
7 |
2 |
Total Credits Remaining |
|
21 |
REMHOUR |
N |
9 |
2 |
Total Hours Remaining |
|
22 |
STARTDATE |
T |
8 |
0 |
Date Program Begins |
|
23 |
_PROGDESC |
C |
25 |
0 |
Program Status Description |
|
24 |
_STATDESC |
C |
25 |
0 |
Employee Status in Program Descript |
|
25 |
_ZFILTER |
C |
25 |
0 |
Filter Function |