NCLAINFO - Class Information (NCI) Database

NCLAINFO field information

 

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