Table 28. Territory File Schema
Field
|
Type
|
Length
|
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
|