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