- Contents
AIM Help
Work Effort Import File Record
Delimited/fixed record type = AWEF
Excel worksheet name = WorkEffortRecord
Latitude |
Position |
Col |
Column Name |
Format |
Comment |
Record Type |
1-4 |
1 |
record_type |
String (4) |
Value = AWEF |
File Number |
5-14 |
2 |
file_number |
Integer (10) |
Unique number assigned to each account placed. Use this value for all data sent to AIM. |
Action Date |
15-28 |
3 |
action_date |
DateTime (CCYYMMDDhhmmss) |
Work effort creation date and time. For Excel file, use date/time format (for example, 6/20/2008 10:30:00 AM). |
Action Category |
29-31 |
4 |
action_category |
String (3) |
Category that your outsourcing partner assigned to group the letter action. |
Action Code |
32-41 |
5 |
action_code |
String (10) |
Code that the outside collection agency or attorney assigned to identify the letter action. |
Action Text |
42-241 |
6 |
action_text |
String (200) |
Description that the outside collection agency or attorney associated to the letter action. |