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 |