NEMPHIST - Courses Taken (NEH) Database
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
AMPM |
C |
1 |
0 |
Start Time AM/PM Indicator (A/P) |
2 |
AMPM2 |
C |
1 |
0 |
End Time AM/PM Indicator (A/P) |
3 |
APPROVED |
C |
1 |
0 |
Reimbursement Approved (Y/N) |
4 |
CERTCODE |
C |
10 |
0 |
Certification Code |
5 |
CEU |
N |
7 |
2 |
CEU |
6 |
CHADATE |
T |
8 |
0 |
Last Change Date |
7 |
CLASSID |
C |
9 |
0 |
Class ID Number |
8 |
COMPANY |
C |
3 |
0 |
Company Code |
9 |
COURSE |
C |
10 |
0 |
Course Code |
10 |
COURSEFEE |
N |
10 |
2 |
Course Fee |
11 |
COURSETYPE |
C |
10 |
0 |
Course Type |
12 |
CREDITS |
N |
7 |
2 |
Credits |
13 |
DAYSOFWEEK |
C |
7 |
0 |
Days of Week for each Session |
14 |
DURATION |
N |
5 |
0 |
Duration (Min) of each Session |
15 |
EMPNO |
C |
9 |
0 |
Employee ID |
16 |
ENDDATE |
T |
8 |
0 |
Date Course Ends |
17 |
ENDTIME |
C |
5 |
0 |
End Time for each Session |
18 |
ENRSTAT |
C |
6 |
0 |
Employee Enrollment Status |
19 |
FIRSTNAME |
C |
14 |
0 |
Employee First Name |
20 |
GRADE |
C |
5 |
0 |
Grade Received |
21 |
HOURS |
N |
7 |
2 |
Total Hours of All Sessions |
22 |
INSTRCODE |
C |
10 |
0 |
Instructor Code |
23 |
JOBREL |
C |
1 |
0 |
Job Related Course (Y/N) |
24 |
JOBRELCODE |
C |
10 |
0 |
Job Requirement Code |
25 |
LASTNAME |
C |
25 |
0 |
Employee Last Name |
26 |
LOCATION |
C |
10 |
0 |
Location Code |
27 |
MIDNAME |
C |
14 |
0 |
Employee Middle Name |
28 |
MISC1 |
C |
25 |
0 |
User Defined 1 |
29 |
MISC2 |
C |
25 |
0 |
User Defined 2 |
30 |
MISC3 |
C |
25 |
0 |
User Defined 3 |
31 |
MISC4 |
N |
12 |
2 |
User Defined 4 |
32 |
OTHERFEES |
N |
10 |
2 |
Other Fees |
33 |
P_EECLASS |
C |
6 |
0 |
EE Classification Clode |
34 |
P_EEOCLASS |
C |
6 |
0 |
EEO Classification Code |
35 |
P_EMPLOY |
C |
3 |
0 |
Employment Status Code |
36 |
P_JOBCODE |
C |
8 |
0 |
Job Code |
37 |
P_JOBGROUP |
C |
6 |
0 |
Job Group |
38 |
P_JOBTITLE |
C |
25 |
0 |
Employee Job Title |
39 |
P_LEVEL1 |
C |
12 |
0 |
Division Code |
40 |
P_LEVEL2 |
C |
12 |
0 |
Department Code |
41 |
P_LEVEL3 |
C |
12 |
0 |
Location Code |
42 |
P_LEVEL4 |
C |
12 |
0 |
Not Defined |
43 |
P_LEVEL5 |
C |
12 |
0 |
Not Defined |
44 |
REIMBAMT |
N |
10 |
2 |
Reimbursement Amount |
45 |
REQDATE |
T |
8 |
0 |
Date Reimbursement Requested |
46 |
REQUIRED |
C |
1 |
0 |
Course Required (Y/N) |
47 |
SESSIONS |
N |
5 |
0 |
Total Number of Sessions |
48 |
STARTDATE |
T |
8 |
0 |
Date Course Begins |
49 |
STARTTIME |
C |
5 |
0 |
Start Time for Each Session |
50 |
_CERTDESC |
C |
25 |
0 |
Certification Description |
51 |
_COURDESC |
C |
25 |
0 |
Course Description |
52 |
_ENRDESC |
C |
25 |
0 |
Enrollment Status Description |
53 |
_INSTNAME |
C |
25 |
0 |
Instructor Name |
54 |
_LOCADESC |
C |
25 |
0 |
Course Location Description |
55 |
_TYPEDESC |
C |
25 |
0 |
Course Type Description |
56 |
_ZFILTER |
C |
25 |
0 |
Filter Function |