Class Information (NCI) Database
| Seq | Field Name | Type | Length | Dec | Description |
|---|---|---|---|---|---|
|
1 |
ACTCOST |
N |
10 |
2 |
Total Actual Costs for Class |
|
2 |
AMPM |
C |
1 |
0 |
Start Time AM/PM Indicator |
|
3 |
AMPM2 |
C |
1 |
0 |
End Time AM/PM Indicator |
|
4 |
BUDCOST |
N |
10 |
2 |
Total Budgeted Costs for Class |
|
5 |
CAPACITY |
N |
5 |
0 |
Capacity |
|
6 |
CERTCODE |
C |
10 |
0 |
Certification Code |
|
7 |
CEU |
N |
7 |
2 |
CEU |
|
8 |
CHADATE |
T |
8 |
0 |
Last Change Date |
|
9 |
CLANOTES |
M |
10 |
0 |
Class Notes |
|
10 |
CLASSID |
C |
9 |
0 |
Class ID Number |
|
11 |
CLASSRATE |
C |
10 |
0 |
Class Rating Code |
|
12 |
CLASSSTAT |
C |
4 |
0 |
Class Status |
|
13 |
COMPANY |
C |
3 |
0 |
Company Code |
|
14 |
COURSE |
C |
10 |
0 |
Course Code |
|
15 |
COURSEFEE |
N |
10 |
2 |
Course Fee |
|
16 |
COURSETYPE |
C |
10 |
0 |
Course Type |
|
17 |
CREDITS |
N |
7 |
2 |
Credits |
|
18 |
DAYSOFWEEK |
C |
7 |
0 |
Days of Week for each Session |
|
19 |
DURATION |
N |
5 |
0 |
Duration (Min) of each Session |
|
20 |
ENDDATE |
D |
8 |
0 |
Date Class Ends |
|
21 |
ENDTIME |
C |
5 |
0 |
End Time for each Session |
|
22 |
ENROLLBY |
D |
8 |
0 |
Date Enrollment Period Ends |
|
23 |
FDESC |
C |
25 |
0 |
Class Description |
|
24 |
FIXCOST |
N |
10 |
2 |
Fixed Costs for Class |
|
25 |
HOURS |
N |
7 |
2 |
Total Hours of all Sessions |
|
26 |
INSTRATE |
C |
10 |
0 |
Instructor Rating Code |
|
27 |
INSTRCODE |
C |
10 |
0 |
Instructor Code |
|
28 |
LOCATION |
C |
10 |
0 |
Location Code |
|
29 |
MISC1 |
C |
25 |
0 |
Miscellaneous Field 1 |
|
30 |
MISC2 |
C |
25 |
0 |
Miscellaneous Field 2 |
|
31 |
MISC3 |
C |
25 |
0 |
Miscellaneous Field 3 |
|
32 |
MISC4 |
N |
12 |
2 |
Miscellaneous Field 4 |
|
33 |
OTHERFEES |
N |
10 |
2 |
Other Fees |
|
34 |
SESSIONS |
N |
5 |
0 |
Total Number of Sessions |
|
35 |
STARTDATE |
T |
8 |
0 |
Date Class Begins |
|
36 |
STARTTIME |
C |
5 |
0 |
Start Time for each Session |
|
37 |
_CERTDESC |
C |
25 |
0 |
Certification Description |
|
38 |
_COURDESC |
C |
25 |
0 |
Course Description |
|
39 |
_INSTNAME |
C |
25 |
0 |
Instructor Name |
|
40 |
_LOCADESC |
C |
25 |
0 |
Location Description |
|
41 |
_STATDESC |
C |
25 |
0 |
Class Status Description |
|
42 |
_TYPEDESC |
C |
25 |
0 |
Course Type Description |
|
43 |
_ZFILTER |
C |
25 |
0 |
Filter Function |