NCATINST - Instructor Catalog (NIN) Database
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 |