NEMPCERT - Employee Certifications (NEC) Database

NEMPCERT field information

 

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