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 |