Contents

Placements Export File Layout

The placement export file contains new accounts to place with the agency or attorney. Delimited and fixed files contain a trailer record that indicates the total number of accounts placed and the dollar value of the accounts. If the number and value of accounts in the trailer file don't match the data in the placement file, the agency or attorney shouldn't process the file.

The following table lists the delimited and fixed file record types, and the Microsoft Excel file names. Microsoft Excel files contain a separate worksheet for each record type included. Excel formats all columns using the general format type.

Record Type	Excel File	Description
CACT	Master	Account record. Contains financial information for the account.
CAAA	AutoAuctionAppraisal	Auto auction appraisal record. Contains vehicle auction appraisal information for a debtor on the account.
CAAB	AutoAuctionBid	Auto auction bid record. Contains vehicle auction bid information for a debtor on the account.
CAAU	AutoAuction	Auto auction record. Contains vehicle auction information for a debtor on the account.
CACO	AutoCollateral	Auto collateral record. Contains vehicle collateral information for a debtor on the account.
CALS	AutoLease	Auto lease record. Contains vehicle lease information for a debtor on the account.
CARB	AutoAuctionRepairBid	Auto auction repair bid record. Contains vehicle auction repair bid information for a debtor on the account.
CARH	AutoRepossessionHistory	Auto repossession history record. Contains vehicle repossession history information for a debtor on the account.
CARP	AutoRepossession	Auto repossession record. Contains vehicle repossession information for a debtor on the account.
CAST	Assets	Assets record. Contains asset information for a debtor on the account.
CCPT	Complaint	Complaint record. Contains complaint information for the account.
CBKP	Bankruptcy	Debtor bankruptcy record. Contains bankruptcy information for a debtor on the account.
CD## (00-99)	Debtor	Debtor record. Contains the debtor records that exist for the account. AIM numbers each debtor record, starting with 00 for the primary debtor.
CDEC	Deceased	Debtor deceased record. Contains deceased information for a debtor on the account.
CDIS	Dispute	Dispute record. Contains dispute information for the account.
CEQP	Equipment	Equipment record. Contains equipment information for the account.
CINS	Insurance	Insurance record. Contains medical insurance information for a debtor on the account.
CJDG	Judgments	Judgment record. Contains judgment information for the account.
CMIS	MiscExtra	Miscellaneous extra data record. Contains user-defined data associated to the account. An unlimited number of these records can exist in the placement file.
CNOT	Notes	Note record. Contains notes associated to the account.
CPAT	PatientInfo	Patient record. Contains medical patient information for a debtor on the account.
CUPP	Phones	Phone record: Contains phone information for the account. An unlimited number of these records can exist in the placement file.
CEML	Email	Email reocrd: Contains email information for the account. An unlimited number of these records can exist in the placement file.
CTRL	No Excel or XML	Trailer record. Contains the total number of records in the file.

Placements Export File Layout

Related Topics