Placement Export File Complaints Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = ACPT

File Number

5-13

2

file_number

Integer (9)

Unique number assigned to each account placed. Use this value for all data sent to AIM.

Debtor Number

14-22

3

debtor_number

Integer (9)

Unique number assigned to each debtor record.

ID

4

id

Integer (9)

Against Code

5

against_code

String (10)

Category for who or what the complaint is against, such as third party, branch, department, or user.

Against

6

against

String (50)

Who or what the complaint is against.

Against Entity

7

against_entity

String (255)

User who specified who or what the complaint is against.

Category

8

category

String (20)

Complaint category, such as branch or department.

Compensation Amount

9

compensation_amount

Decimal (12)

Amount of compensation the debtor received.

Conclusion

10

conclusion

String (500)

Based on the investigation, the conclusion regarding the complaint.

Date Closed

11

date_closed

DateTime (CCYYMMDD)

Date your organization closed the complaint.

Date in Admin

12

date_in_admin

DateTime (CCYYMMDD)

Date Received

13

date_received

DateTime (CCYYMMDD)

Date your organization received the complaint.

Deleted

14

deleted

String (1)

Indicates whether a user deleted the complaint.

Details

15

details

String (500)

Details regarding the complaint.

Dissatisfaction

16

dissatisfaction

String (1)

Indicates whether the debtor is dissatisfied.

Dissatisfaction Date

17

dissatisfaction_date

DateTime (CCYYMMDD)

Date the debtor indicated dissatisfaction.

Grievances

18

grievances

String (500)

List of the debtor's grievances.

Investigation Comments to Date

19

investigation_comments_to_date

String (500)

Details regarding the complaint investigation.

Justified Code

20

justified_code

String (10)

Code that identifies the complaint justification type.

Justified

21

justified

String (50)

Indicates whether the complaint is justified.

Outcome Code

22

outcome_code

String (10)

Code that identifies the complaint outcome type.

Outcome

23

outcome

String (50)

Outcome of the complaint, such as training required or disciplinary action. Selecting an outcome closes the complaint.

Owner

24

owner

String (10)

Recourse Date

25

recourse_date

DateTime (CCYYMMDD)

Recourse approval date.

Referred by

26

referred_by

String (10)

Person who referred the complaint, such as third party, customer, or user.

Root Cause Code

27

root_cause_code

String (10)

Code that identifies the root cause type.

Root Cause

28

root_cause

String (50)

Root cause of the complaint.

SLA Days

29

sla_days

Integer (9)

Number of days after receiving the complaint that you have to resolve it before breaching the SLA.

Status Code

30

status_code

String (10)

Code that identifies the complaint status type.

Status

31

status

String (50)

Status of the complaint.

Type Code

32

type_code

String (10)

Code that identifies the complaint type.

Type

33

type

String (50)

Type of complaint, such as human or system error.

Filler

34

filler

String (1)

Filler for fixed file layout.