General Questions
No. Ideally, the loan/share download includes only open, active loan and share data. We added field 33, Charge Off Amount, to accommodate files with charge off data or partial loan charge offs.
Close and return to topPlease leave the field blank.
Close and return to topNo. You do not have to add leading zeros to meet the maximum number of characters for each field.
Close and return to topNo. The goal is to provide the examiner with enough information to properly read and understand the loan/share data.
Close and return to topShare Record Layout
Yes. You could simply append a sequence number to each certificate account number.
Close and return to topYes. You could use the “Other” Street Address (field 8) with up to 30 alphanumeric characters to fit the foreign address information.
Close and return to topThe most recent rollover or renewal date.
Close and return to topReport the highest dividend rate and explain data to the examiner.
Close and return to topNo. Only include the dollar amount of shares pledged as collateral for a loan or frozen due to a tax levy, deceased member, etc.
Close and return to topLast activity code identifies the most recent financial transaction (e.g. Withdrawal) and last file maintenance date identifies the most recent date of a non-financial account transaction (eg. Change of address).
Close and return to topLoan Record Layout
No, but the Member’s Name field is limited to 41 characters.
Close and return to topWe typically see the number of months in this field. It should correspond with field 13, Payment Frequency Code.
Close and return to topYour client credit union should determine which credit score to use in the loan download.
Close and return to topFor closed end loans, you can calculate the data based on the time since the loan date and the number of payments that should have been made. We can accept a reasonable estimate for the number of payments remaining. For open end loans, leave field 35 blank.
Close and return to topAIRES will accept field 33 data with or without two decimal places.
Close and return to topTips
- All files should be tab delimited with a carriage return/line feed at the end of every record.
- Do not mix share and loan records within the same download file.
- Each file must contain only share or loan records. The download files may be split into multiple share and multiple loan files.