NEMPREQU - Required Courses (NER) Database

NEMPREQU field information

 

Seq Field Name Type Length Dec Description

1

APPRDATE

T

8

0

Date Course was Approved

2

CERTCODE

C

10

0

Certification Code

3

CEU

N

7

2

CEU

4

CHADATE

T

8

0

Last Change Date

5

COMPANY

C

3

0

Company Code

6

COMPBY

T

8

0

Required Completion Date

7

COURSE

C

10

0

Course Code

8

COURSEFEE

N

10

2

Course Fee

9

COURSETYPE

C

10

0

Course Type Code

10

CREDITS

N

7

2

Credits

11

DURATION

N

5

0

Duration (Min) of each Session

12

EMPNO

C

9

0

Employee ID

13

ENRSTAT

C

6

0

Enrollment Status Code

14

HOURS

N

7

2

Total Hours of All Sessions

15

JOBREL

C

1

0

Job Related Course (Y/N)

16

JOBRELCODE

C

10

0

Job Requirement Code

17

MISC1

C

25

0

Miscellaneous Field 1

18

MISC2

C

25

0

Miscellaneous Field 2

19

MISC3

C

25

0

Miscellaneous Field 3

20

MISC4

N

12

2

Miscellaneous Field 4

21

OTHERFEES

N

10

2

Other Fees

22

PRIORITY

C

5

0

Priority Assigned to Course

23

REQUIRED

C

1

0

Course Required (Y/N)

24

SESSIONS

N

5

0

Total Number of Sessions

25

_CERTDESC

C

25

0

Certification Description

26

_COURDESC

C

25

0

Course Description

27

_ENRDESC

C

25

0

Enrollment Status Description

28

_PRIDESC

C

25

0

Priority Description

29

_TYPEDESC

C

25

0

Course Type Description

30

_ZFILTER

C

25

0

Filter Function