Employee Certifications (NEC) Database
| Seq | Field Name | Type | Length | Dec | Description |
|---|---|---|---|---|---|
|
1 |
AUTOUPDT |
C |
1 |
0 |
Automatically Update Certification |
|
2 |
CERTCODE |
C |
10 |
0 |
Certification Code |
|
3 |
CHADATE |
T |
8 |
0 |
Last Change Date |
|
4 |
COMCEU |
N |
7 |
2 |
Number of CEU Completed |
|
5 |
COMCOUR |
N |
3 |
0 |
Number of Courses Completed |
|
6 |
COMCREDITS |
N |
7 |
2 |
Number of Credits Completed |
|
7 |
COMPANY |
C |
3 |
0 |
Company Code |
|
8 |
DURATION |
N |
3 |
0 |
Renewal Period in Months |
|
9 |
EMPNO |
C |
9 |
0 |
Employee ID |
|
10 |
EXPDATE |
T |
8 |
0 |
Date Certification Expires |
|
11 |
JOBREL |
C |
1 |
0 |
Job Related (Y/N) |
|
12 |
JOBRELCODE |
C |
10 |
0 |
Job Requirement Code |
|
13 |
LASTDATE |
T |
8 |
0 |
Date Most Recently Certified |
|
14 |
MISC1 |
C |
25 |
0 |
User Defined 1 |
|
15 |
MISC2 |
C |
25 |
0 |
User Defined 2 |
|
16 |
MISC3 |
C |
25 |
0 |
User Defined 3 |
|
17 |
MISC4 |
N |
12 |
2 |
User Defined 4 |
|
18 |
ORIGDATE |
T |
8 |
0 |
Date Originally Certified |
|
19 |
RENCEU |
N |
7 |
2 |
Number of CEU for Renewal |
|
20 |
RENCOUR |
N |
3 |
0 |
Number of Courses for Renewal |
|
21 |
RENCREDITS |
N |
7 |
2 |
Number of Credits for Renewal |
|
22 |
REQCEU |
N |
7 |
2 |
Initial Number of CEU Required |
|
23 |
REQCOUR |
N |
3 |
0 |
Initial Number of Courses Required |
|
24 |
REQCREDITS |
N |
7 |
2 |
Initial Number of Credits Required |
|
25 |
REQDATE |
T |
8 |
0 |
Date Certification is Required |
|
26 |
REQUIRED |
C |
1 |
0 |
Certification Required (Y/N) |
|
27 |
_CERTDESC |
C |
25 |
0 |
Certification Description |
|
28 |
_ZFILTER |
C |
25 |
0 |
Filter Function |