NEMPPROG - 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 |