If we cannot meet the June 30, 2003, requested date for providing the expanded loan/share download, will AIRES still accept the current layout?
Yes. AIRES will accept loan/share downloads created in accordance with either the current or expanded layout specifications.Close and return to top
Should the loan/share download include closed or charged-off accounts?
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 top
Does a “critical” field mean a “required” field?
No. Critical fields are those fields with information considered most valuable to the examiner.Close and return to top
What should be entered in a field if no data is available?
Please leave the field blank.Close and return to top
Is the credit union still allowed to use current standard NCUA codes to map data for share type, loan type, etc, or are they strictly prohibited?
Using former NCUA standard codes is not prohibited, but not as helpful to the examiner as using the credit union’s own codes.Close and return to top
Are fields fixed in length?
No. You do not have to add leading zeros to meet the maximum number of characters for each field.Close and return to top
Since we should provide the examiner with a list of the credit union’s loan and share codes, is there a required format (paper vs. electronic)?
No. The goal is to provide the examiner with enough information to properly read and understand the loan/share data.Close and return to top
What does the “A” under field type and length mean?
“A” indicates alphanumeric characters. “N” indicates numeric characters.Close and return to top
All records are tab delimited with a carriage return/line feed at the end of every record. Do we need a tab after the last field before the carriage return/line feed?
Share Record Layout
Does the share certificate account number need to be unique (field 2)?
Yes. You could simply append a sequence number to each certificate account number.Close and return to top
If a member has a foreign address, do you want it reported?
Yes. 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 top
In the case of a rollover share certificate, what should be included in field 12, Certificate Date Granted?
The most recent rollover or renewal date.Close and return to top
For tiered rate share certificates, what should we include in field 14, Dividend Rate?
Report the highest dividend rate and explain data to the examiner.Close and return to top
Should we include minimum balances or check holds in field 16, Share Amount Frozen?
No. 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 top
What is the difference between Last Activity Code, field 17, and Last File Maintenance Date, field 19?
Last 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 top
Loan Record Layout
In the past, we included the member’s entire middle name rather than just the middle initial (field 3). Will this cause a problem?
No, but the Member’s Name field is limited to 41 characters.Close and return to top
Do you want field 12, Loan Term, expressed in a certain segment as in always number of months or should we convert the term to the number of payments per year?
We typically see the number of months in this field. It should correspond with field 13, Payment Frequency Code.Close and return to top
If our client credit union obtains credit scores from more than one credit bureau, how do we determine the “most dominant” score (field 32)?
Your client credit union should determine which credit score to use in the loan download.Close and return to top
How should we calculate the number of remaining payments, field 35?
For 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 top
For field 33, Charge Off Amount, the layout specifications table indicates a numerical field length of 15 with no decimal places. However, the narrative field description indicates two decimal places. Which format is correct?
AIRES will accept field 33 data with or without two decimal places.Close and return to top
Please keep in mind the following:
- 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.
Close and return to top