Table 52. Territory File Schema
|
|
|
Record Length |
Alphanumeric |
8 |
Territory Number |
Alphanumeric |
10 |
ME Number |
Alphanumeric |
10 |
Check Digit |
Alphanumeric |
1 |
Last Name |
Alphanumeric |
25 |
First Name |
Alphanumeric |
25 |
Middle Initial |
Alphanumeric |
1 |
Suffix |
Alphanumeric |
4 |
Title |
Alphanumeric |
5 |
Address 1 |
Alphanumeric |
30 |
Address 2 |
Alphanumeric |
30 |
Address 3 |
Alphanumeric |
30 |
Address Indicator |
Alphanumeric |
1 |
City |
Alphanumeric |
28 |
State |
Alphanumeric |
2 |
Zip Code + 4 |
Number |
9 |
Specialty |
Alphanumeric |
3 |
Called On Code |
Alphanumeric |
1 |
No Contact Indicator |
Alphanumeric |
1 |
Project Start Date |
Alphanumeric |
10 |
Current Week Date |
Alphanumeric |
10 |
Prior-To Date |
Alphanumeric |
10 |
Client Data |
Alphanumeric |
49 |
Programming Info |
Alphanumeric |
11 |
PRODUCT A |
Alphanumeric |
30 |
Week 9 Beg. Date |
Alphanumeric |
10 |
Week 9 End Date |
Alphanumeric |
10 |
Week 9 Activity Indicator |
Alphanumeric |
3 |
Week 9 Activity Indicator Name |
Alphanumeric |
10 |
Week 8 Beg. Date |
Alphanumeric |
10 |
Week 8 End Date |
Alphanumeric |
10 |
Week 8 Activity Indicator |
Alphanumeric |
3 |
Week 8 Activity Indicator Name |
Alphanumeric |
10 |
Week 7 Beg. Date |
Alphanumeric |
10 |
Week 7 End Date |
Alphanumeric |
10 |
Week 7 Activity Indicator |
Alphanumeric |
3 |
Week 7 Activity Indicator Name |
Alphanumeric |
10 |
Week 6 Beg. Date |
Alphanumeric |
10 |
Week 6 End Date |
Alphanumeric |
10 |
Week 6 Activity Indicator |
Alphanumeric |
3 |
Week 6 Activity Indicator Name |
Alphanumeric |
10 |
Week 5 Beg. Date |
Alphanumeric |
10 |
Week 5 End Date |
Alphanumeric |
10 |
Week 5 Activity Indicator |
Alphanumeric |
3 |
Week 5 Activity Indicator Name |
Alphanumeric |
10 |
Week 4 Beg. Date |
Alphanumeric |
10 |
Week 4 End Date |
Alphanumeric |
10 |
Week 4 Activity Indicator |
Alphanumeric |
3 |
Week 4 Activity Indicator Name |
Alphanumeric |
10 |
Week 3 Beg. Date |
Alphanumeric |
10 |
Week 3 End Date |
Alphanumeric |
10 |
Week 3 Activity Indicator |
Alphanumeric |
3 |
Week 3 Activity Indicator Name |
Alphanumeric |
10 |
Week 2 Beg. Date |
Alphanumeric |
10 |
Week 2 End Date |
Alphanumeric |
10 |
Week 2 Activity Indicator |
Alphanumeric |
3 |
Week 2 Activity Indicator Name |
Alphanumeric |
10 |
Week 1 Beg. Date |
Alphanumeric |
10 |
Week 1 End Date |
Alphanumeric |
10 |
Week 1 Activity Indicator |
Alphanumeric |
3 |
Week 1 Activity Indicator Name |
Alphanumeric |
10 |
PRODUCT B |
Alphanumeric |
30 |
Week 9 Beg. Date |
Alphanumeric |
10 |
Week 9 End Date |
Alphanumeric |
10 |
Week 9 Activity Indicator |
Alphanumeric |
3 |
Week 9 Activity Indicator Name |
Alphanumeric |
10 |
Week 8 Beg. Date |
Alphanumeric |
10 |
Week 8 End Date |
Alphanumeric |
10 |
Week 8 Activity Indicator |
Alphanumeric |
3 |
Week 8 Activity Indicator Name |
Alphanumeric |
10 |
Week 7 Beg. Date |
Alphanumeric |
10 |
Week 7 End Date |
Alphanumeric |
10 |
Week 7 Activity Indicator |
Alphanumeric |
3 |
Week 7 Activity Indicator Name |
Alphanumeric |
10 |
Week 6 Beg. Date |
Alphanumeric |
10 |
Week 6 End Date |
Alphanumeric |
10 |
Week 6 Activity Indicator |
Alphanumeric |
3 |
Week 6 Activity Indicator Name |
Alphanumeric |
10 |
Week 5 Beg. Date |
Alphanumeric |
10 |
Week 5 End Date |
Alphanumeric |
10 |
Week 5 Activity Indicator |
Alphanumeric |
3 |
Week 5 Activity Indicator Name |
Alphanumeric |
10 |
Week 4 Beg. Date |
Alphanumeric |
10 |
Week 4 End Date |
Alphanumeric |
10 |
Week 4 Activity Indicator |
Alphanumeric |
3 |
Week 4 Activity Indicator Name |
Alphanumeric |
10 |
Week 3 Beg. Date |
Alphanumeric |
10 |
Week 3 End Date |
Alphanumeric |
10 |
Week 3 Activity Indicator |
Alphanumeric |
3 |
Week 3 Activity Indicator Name |
Alphanumeric |
10 |
Week 2 Beg. Date |
Alphanumeric |
10 |
Week 2 End Date |
Alphanumeric |
10 |
Week 2 Activity Indicator |
Alphanumeric |
3 |
Week 2 Activity Indicator Name |
Alphanumeric |
10 |
Week 1 Beg. Date |
Alphanumeric |
10 |
Week 1 End Date |
Alphanumeric |
10 |
Week 1 Activity Indicator |
Alphanumeric |
3 |
Week 1 Activity Indicator Name |
Alphanumeric |
10 |