NCATINST - Instructor Catalog (NIN) Database

NCATINST field information

 
Seq Field Name Type Length Dec Description

1

CHADATE

T

8

0

Last Change Date

2

CITY

C

20

0

City

3

COMPANY

C

3

0

Company Code

4

COUNTRY

C

12

0

Country

5

FIRSTNAME

C

14

0

First Name

6

HOURRATE

N

6

2

Hourly Rate

7

INSTCOMP

C

28

0

Name of Instructor's Company

8

INSTEXT

C

4

0

Phone Extension

9

INSTNOTES

M

10

0

Instructor Notes

10

INSTPHONE

C

13

0

Phone Number

11

INSTRATE

C

10

0

Overall Instructor Rating

12

INSTRCODE

C

10

0

Instructor Code

13

LASTNAME

C

25

0

Last Name

14

MIDNAME

C

14

0

Middle Name

15

MISC1

C

25

0

Miscellaneous Field 1

16

MISC2

C

25

0

Miscellaneous Field 2

17

MISC3

C

25

0

Miscellaneous Field 3

18

MISC4

N

12

2

Miscellaneous Field 4

19

NICKNAME

C

14

0

Nickname

20

PROFESSION

C

28

0

Instructor's Professional Title

21

PROV

C

3

0

Province Code

22

P_COMPANY

C

3

0

Employer Code of Employee Record

23

P_EMPNO

C

9

0

Employee ID of Employee Record

24

STATE

C

3

0

State/Province Code

25

STREET1

C

28

0

Street Address Line 1

26

STREET2

C

28

0

Street Address Line 2

27

ZIP

C

10

0

ZIP Code

28

_ZFILTER

C

25

0

Filter Function