NEMPPROG - Employee Training Programs (NEP) Database

NEMPPROG field information

 

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