Document
Affordable Housing Program (AHP)
ICR 201611-2590-001 · OMB 2590-0007 · Object 69708201.
⚠️ Notice: This form may be outdated. More recent filings and information on OMB 2590-0007 can be found here:
Document [pdf]
Download: pdf | txt
FEDERAL HOUSING FINANCE BOARD Affordable Housing Program/Community Investment Cash Advance (AHP/CICA) Data Reporting Instructions OMB Approval Number 2590-0007 Expires 2-28-2013 Data Reporting Manual AHP/CICA Chapter Table of Contents GENERAL INSTRUCTIONS ............................................................................................ 3 Who Must Report............................................................................................................ 3 Preparation of the Information........................................................................................ 3 Accuracy of the Information Submission ....................................................................... 4 Submission of the Information........................................................................................ 4 Amending Prior Submission ....................................................................................... 4 Retention of Data Submission .................................................................................... 4 Release of FHLBank Data Submission........................................................................... 4 Miscellaneous General Instructions................................................................................ 5 Rounding..................................................................................................................... 5 Negative Entries.......................................................................................................... 5 Verification ................................................................................................................. 5 FINAL COLLECTION/SPECIFICATION INFORMATION ........................................... 6 INITIAL REPORTING PERIOD INFORMATION .......................................................... 6 Aggregate AHP Reporting.............................................................................................. 6 Aggregate CICA Reporting ............................................................................................ 6 Competitive Project Level Reporting ............................................................................. 6 Approved Application/Project Reporting ................................................................... 6 Progress/Delta Reporting ............................................................................................ 7 Grandfathering Information ........................................................................................ 7 Phase In Information................................................................................................... 7 Future Reporting Information ..................................................................................... 8 Set-Aside Reporting........................................................................................................ 8 Calendar Year 2006 Reporting Information ............................................................... 8 Future Reporting Information ..................................................................................... 8 CICA Member Level Project Reporting ......................................................................... 8 Calendar Year 2006 Reporting Information ............................................................... 8 Future Reporting Information ..................................................................................... 8 LINE ITEM INSTRUCTIONS FOR THE AHP DATA SUBMISSION........................... 9 Project Level Competitive Data Elements, Definitions, and Attributes ......................... 9 Competitive Application/Project File Submission...................................................... 9 Competitive Progress/Delta File Submission ............................................................. 9 Competitive Completion/Withdrawal File Submission .............................................. 9 Competitive Recapture/Retention File Submission .................................................... 9 Household Level Set-Aside Data Elements, Definitions, and Attributes ..................... 10 Set-Aside Disbursement File Submission................................................................. 10 Set-Aside Recapture/Retention File Submission ...................................................... 10 Aggregate AHP Information......................................................................................... 10 LINE ITEM INSTRUCTIONS FOR THE CICA DATA SUBMISSION ....................... 10 Member Level CICA Data Elements, Definitions, and Attributes ............................... 10 CICA Disbursement File Submission....................................................................... 11 Aggregate CICA Information ....................................................................................... 11 APPENDIX A. HISTORIC MAPPING ..................................................................... 12 APPENDIX B. COMPETITIVE MAPPING............................................................. 13 Page 1 of 25 Data Reporting Manual AHP/CICA Chapter APPENDIX C. APPENDIX D. APPENDIX E. APPENDIX F. APPENDIX G. APPENDIX H. APPENDIX I. APPENDIX J. APPENDIX K. APPENDIX L. APPENDIX M. APPENDIX N. SET-ASIDE MAPPING ................................................................... 14 COMPETITIVE APPLICATION/PROJECT FILE SUBMISSION15 COMPETITIVE PROGRESS/DELTA FILE SUBMISSION.......... 16 COMPETITIVE COMPLETION/WITHDRAWAL FILE SUBMISSION ................................................................................. 17 COMPETITIVE RECAPTURE/RETENTION/POST COMPLETION FILE SUBMISSION ............................................. 18 SET-ASIDE DISBURSEMENT FILE SUBMISSION .................... 19 SET-ASIDE RECAPTURE/RETENTION/POST COMPLETION FILE SUBMISSION........................................................................ 20 AGGREGATE AHP MAPPING ...................................................... 21 CICA MAPPING .............................................................................. 22 CICA DISBURSEMENT FILE SUBMISSION............................... 23 AGGREGATE CICA MAPPING..................................................... 24 GLOSSARY ..................................................................................... 25 Paperwork Reduction Act Statement: Notwithstanding any other provision of the law, no person is required to respond to, nor shall any person be subject to a penalty for failure to comply with, a collection of information subject to the requirements of the Paperwork Reduction Act, unless that collection of information displays a currently valid OMB Control Number. Public reporting burden for this collection of information is estimated to average 5 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspects of this collection of information, including suggestions for reducing this burden to FHFA at: Chief Information Officer, FHFA, 1700 G Street NW., Washington, DC 20552. Page 2 of 25 Data Reporting Manual AHP/CICA Chapter GENERAL INSTRUCTIONS Who Must Report Each Federal Home Loan Bank (FHLBank) shall submit the following reports of the Affordable Housing Program (AHP) and Community Investment Cash Advance (CICA) program to the Federal Housing Finance Board (Finance Board) according to the submission date designated for each report. 1. Aggregate AHP information quarterly via the Federal Housing Finance Board’s Call Report System (CRS). This report shall be submitted on or before twenty (20) calendar days after the preceding quarterly period ending (March 31; June 30; September 30; and December 31). 2. Aggregate CICA information quarterly via the Federal Housing Finance Board’s Call Report System (CRS). This report shall be submitted on or before twenty (20) calendar days after the preceding quarterly period ending (March 31; June 30; September 30; and December 31). 3. Competitive Project Level information semi-annually via the Federal Housing Finance Board’s AHP/CICA data submission (AHP/CICA). This report on or before: a. July 31 for the preceding six month period January 1 to June 30; b. January 31 for the preceding six month period July 1 to December 31. 4. Non-Competitive (Set-Aside) Household Level information annually via the Federal Housing Finance Board’s AHP/CICA data submission (AHP/CICA). This report shall be submitted on or before January 31 for the prior calendar year’s data. 5. CICA Member Level Project information annually via the Federal Housing Finance Board’s AHP/CICA data submission (AHP/CICA). This report shall be submitted on or before January 31 for the prior calendar year’s data. Preparation of the Information Each FHLBank is required to prepare and file information in accordance with these instructions. All information shall be prepared in a consistent manner. Each FHLBank's records shall be maintained in such a manner and scope so as to ensure that the information can be prepared and filed in accordance with these instructions and reflect a fair presentation of the FHLBank's results of AHP and CICA. Questions and requests for interpretations of matters appearing in any part of these instructions should be addressed to the Finance Board. Regardless of whether a FHLBank requests an interpretation of a matter appearing in these instructions, when the Page 3 of 25 Data Reporting Manual AHP/CICA Chapter Finance Board’s interpretation of the instructions differs from the FHLBank’s interpretation, the Finance Board may require the FHLBank to prepare the information submission in accordance with the Finance Board’s interpretation and to amend previously submitted reports. Accuracy of the Information Submission FHLB Senior Management and the FHLB Board of Directors attest to the accuracy of the information by submitting the information to the FHFB. Submission of the Information Information must be submitted via the Finance Board Standard in the prescribed formats detailed in these instructions, the CRS chapters of the Data Reporting Manual (DRM), and as augmented or updated in the DRM. The current submission standard is the Finance Board’s Extranet. Amending Prior Submission The Finance Board may require an FHLBank to amend prior submission information if the information contained significant errors, as determined by the Finance Board, in how the reporting FHLBank classified, categorized, or reported items in the submission. When dealing with the recognition and measurement of events and transactions in a data submission, amended reporting may be required if the Finance Board determines that the information as previously submitted contain errors that are material for the reporting FHLBank. Retention of Data Submission In general, a FHLBank should maintain in its files a record of its completed data submission,including any amended reports, and the related work papers and supporting documentation for five (5) years after the report date. Release of FHLBank Data Submission All information reported will be available to each FHLBank. The Finance Board will use the information submitted to create aggregate reports available to the public and for other uses the Finance Board deems appropriate. Page 4 of 25 Data Reporting Manual AHP/CICA Chapter Miscellaneous General Instructions Rounding All dollar figures will be rounded to the nearest dollar. Percentage precision is to the fourth decimal place, unless noted otherwise. Negative Entries With the exception of the Competitive AHP data element “Cumulative Dollar Amount of Subsidy Modification”, negative entries are not appropriate and shall not be reported. Verification All addition and subtraction should be double-checked before information is submitted. Totals and aggregate information should be cross-checked to corresponding items reported elsewhere (CRS, etc). Before any information is submitted, all amounts should be compared with the corresponding amounts in the previous submission. If there are any unusual changes from the previous submission, a brief explanation of the changes should be attached to the work papers. Each FHLBank should retain work papers and other records used in the preparation of these submissions. Additionally, these instructions contain information regarding validations and edit checks. For data to be successfully accepted, the data must meet each validation and edit check. A single item failure results in the rejection of the entire submission. As such, data should also be cross-checked to ensure that each validation and edit check is met. Page 5 of 25 Data Reporting Manual AHP/CICA Chapter FINAL COLLECTION/SPECIFICATION INFORMATION The Finance Board has historically collected AHP and CICA information via various venues including the AHP web. On April 26, 2005, the FHFB published Notice No. 2005-N-02 in the Federal Register as “Proposed Collection; Comment Requested”. This notice detailed proposed changes to the information collection in the AHP and a proposed data specification for collecting AHP Competitive, Non-Competitive (Set-Aside), and Aggregate AHP information. Since the April 2005 notice was published, Finance Board staff have had extensive consultations with the FHLBanks regarding refinements of the changes announced in April 2005. Appendix A of this document provides a translation from the elements detailed in the Federal Register Proposed Collection Notice to the final data collection and specification. Elements are noted as REMOVED (proposed elements no longer required) or ADDED (new elements now required). For detailed data element definitions for the final elements, refer to “LINE ITEM INSTRUCTIONS FOR THE AHP DATA SUBMISSION”. INITIAL REPORTING PERIOD INFORMATION Each FHLBank will continue to report AHP and CICA information to the Finance Board. Aggregate AHP Reporting Aggregate AHP reporting in CRS will commence in 2007. The FHLBanks will report first quarter 2007 information during April 2007. This quarterly reporting will continue until further notice. Aggregate CICA Reporting Aggregate CICA reporting in CRS will commence in 2007. The FHLBanks will report first quarter 2007 information during April 2007. This quarterly reporting will continue until further notice. Competitive Project Level Reporting Competitive Project Level reporting in AHP/CICA will commence in 2007. For the first reporting period, FHLBanks will report calendar year 2006 approved applications/projects and any previously unreported approved project progress/delta information. Approved Application/Project Reporting Applications/Projects approved by each FHLBank’s board during calendar year 2006 will be reported during January 2007. After this initial reporting period, semi-annual Page 6 of 25 Data Reporting Manual AHP/CICA Chapter reporting detailed in the “Submission of Information” section of this document will begin. Progress/Delta Reporting Progress or deltas of board approved projects not previously reported during 2006 will be reported during January 2007. After this initial reporting period, semi-annual reporting detailed in the “Submission of Information” section of this document will begin. Grandfathering Information Projects approved in calendar years 2005 and prior years will not be required to report all elements defined in the new data collection. Instead, only a subset of these elements will be required. They are: FHLB District ID FHLB Project ID Report Begin Date Report End Date Sponsor Name Proposed Units Completed Units Direct Subsidy Awarded Cumulative Direct Subsidy Disbursed Advance Subsidy Awarded Cumulative Advance Subsidy Disbursed Amount of Subsidized Advance Completion Date Withdrawal Date Completed Home Owner Units LTE 50AMI Completed Rental Housing Units LTE 50AMI Project City Project State This project information should be submitted as part of the Progress/Delta and Completion/Withdrawal file submissions. As grandfathered projects require reporting of only a subset of elements, nulls should be reported for the data elements not required. Phase In Information Projects approved by the board during calendar year 2006 are subject to deferred or “phase in” reporting of certain elements. The “phase in” period ends on June 30, 2007, meaning that all phase in elements on these 2006 projects must be reported no later than July 31, 2007. Page 7 of 25 Data Reporting Manual AHP/CICA Chapter For the initial reporting, which must be reported no later than January 31, 2007, nulls should be reported for those phase in elements that are not currently available but must be reported as noted below. To collect the phase in elements, a one time only application submission file for all 2006 projects must be submitted in July 2007. The file must contain all 2006 projects that lacked complete reporting of phase in elements. Additionally, all elements (both phase in and previously reported) must be included in the file. The data reported will be validated and replace previously submitted 2006 project data. Future Reporting Information Projects approved by the board beginning in calendar year 2007 and beyond are subject to full reporting of all elements. This semi-annual reporting will continue until further notice. Set-Aside Reporting Calendar Year 2006 Reporting Information Aggregate set-aside information for calendar year 2006 will continue to be collected by the Finance Board via separate worksheet. Future Reporting Information Calendar year 2007 set-aside household level information and beyond will be reported in AHP/CICA. This annual reporting will continue until further notice. CICA Member Level Project Reporting Calendar Year 2006 Reporting Information Aggregate CICA information for calendar year 2006 will continue to be collected by the Finance Board via separate worksheet. Future Reporting Information Calendar year 2007 CICA member-level project information and beyond will be reported in AHP/CICA. This annual reporting will continue until further notice. Page 8 of 25 Data Reporting Manual AHP/CICA Chapter LINE ITEM INSTRUCTIONS FOR THE AHP DATA SUBMISSION Appendix B of this document provides a complete mapping of Project Level Competitive Information. Appendix C of this document provides a complete mapping of Household Level SetAside Information. Project Level Competitive Data Elements, Definitions, and Attributes Each FHLBank shall report only board approved projects and the on-going information related to those projects that transpired during the reporting period (except as noted otherwise in the definition, i.e. cumulative, etc). Unfunded alternates will no longer be initially reported to the Finance Board. At such point in time when an unfunded alternate becomes a board approved project, its information will then be required to be reported to the Finance Board. Competitive Application/Project File Submission Appendix D of this document provides a mapping of the Competitive Application/Project Submission file by Ordinal Position. Competitive Progress/Delta File Submission Appendix E of this document provides a mapping of the Competitive Progress/Delta Submission file by Ordinal Position. Competitive Completion/Withdrawal File Submission Appendix F of this document provides a mapping of the Competitive Completion/Withdrawal Submission file by Ordinal Position. Competitive Recapture/Retention File Submission Appendix G of this document provides a mapping of the Competitive Recapture/Retention Submission file by Ordinal Position. Page 9 of 25 Data Reporting Manual AHP/CICA Chapter Household Level Set-Aside Data Elements, Definitions, and Attributes Each FHLBank shall report each household that received a set-aside grant disbursement during the reporting period. Also, each FHLBank shall report on-going information that transpired during the reporting period related to those households. Set-Aside Disbursement File Submission Appendix H of this document provides a mapping of the Disbursement Submission file by Ordinal Position. Set-Aside Recapture/Retention File Submission Appendix I of this document provides a mapping of the Set-Aside Recapture/Retention Submission file by Ordinal Position. Aggregate AHP Information Refer to CRS Chapters of the DRM. Appendix J of this document provides a complete mapping of Aggregate AHP Information. LINE ITEM INSTRUCTIONS FOR THE CICA DATA SUBMISSION Appendix K of this document provides a complete mapping of Member Level CICA Project Information. Member Level CICA Data Elements, Definitions, and Attributes Each FHLBank shall report approved member applications that have received an initial disbursement during the reporting period. Page 10 of 25 Data Reporting Manual AHP/CICA Chapter CICA Disbursement File Submission Appendix L of this document provides a mapping of the CICA Disbursement Submission file by Ordinal Position. Aggregate CICA Information Refer to CRS Chapters of the DRM. Appendix M of this document provides a complete mapping of Aggregate CICA Information. Page 11 of 25 Data Reporting Manual AHP/CICA Chapter APPENDIX A. HISTORIC MAPPING Appendix A of this document provides a translation from the elements detailed in the Federal Register Proposed Collection Notice to the final data collection and specification. This master list cross references the following information: Status represents the element’s status in the new database as it relates to previous actual or proposed reporting (i.e. converted, added, deleted, etc) Notice Number represents the Federal Register Proposed Data Element List Number Notice Name represents the Federal Register Proposed Data Element List Name Final Name represents the final data collection name Reporting Location represents where the information is reported (i.e. CRS or AHP/CICA) Page 12 of 25 DRM AHP CICA Chapter Appendix A Status Notice Number Notice Name Project Information 1 Federal Home Loan Bank Number Competitive - End Date of this reporting period (calendar year; dd/mm/year) 2 Set-Aside - Beginning and end date of reporting period (dd/mm/year) Added Added Added Added Removed Removed Removed Removed Removed 3 AHP project ID number 4 Date of AHP round (dd/mm/year) Competitive - Date of AHP commitment (by FHLBank) to applicant 5 Set-Aside - Date of AHP fund commitment to applicant 6 Member's FHFB ID number Competitive - Project Sponsor's Name 7.1 Set-Aside Competitive - Project Sponsor's Address 7.2 Set-Aside 7.3 7.4 Competitive - Project Sponsor's State 7.5 Set-Aside Competitive - Project Sponsor's Zip Code 7.6 Set-Aside Competitive - Project Name 8.1 Set-Aside Competitive - Project Address 8.2 Set-Aside 8.3 8.4 Competitive - Project State 8.5 Set-Aside Competitive - Project County 8.6 Set-Aside Competitive - Project MSA 8.7 Set-Aside Competitive - Project Zip Code 8.8 Set-Aside Competitive - Project Census Tract 8.9 Set-Aside AHP Funding Stream 9 AHP Homeownership competitive application program Competitive - AHP Homeownership non-competitive application program 10 Set-Aside 11 AHP Rental housing Building Type 12 Single-Family (1-4 units) 13 MultiFamily (5 units or more) 14 Mixed use Tenure Competitive - Owner-occupied 15 Set-Aside 16 Rental 17 Number of years in retention agreement Project Status Competitive - Project start date (date of first disbursement) 18 Set-Aside 19 Project not started 20 Completion Date 21 Withdrawal Date (if applicable) AHP Funds Per Project 22 Dollar amount of AHP Direct Subsidy Committed Final Name Project Information FHLB Number/District Reporting Period Beg Date Reporting Period End Date Reporting Location AHP/CICA AHP/CICA AHP/CICA Competitive Program Application Identifier (Competitive) Set-Aside Program Household Identifier (Set-Aside) Year of Round AHP/CICA AHP/CICA Enrollment Date Member FHFB ID AHP/CICA AHP/CICA Sponsor Name AHP/CICA Sponsor Address 1 Sponsor Address 2 Sponsor City AHP/CICA AHP/CICA AHP/CICA Sponsor State AHP/CICA Sponsor Zip Code (+4) AHP/CICA Project Name AHP/CICA Project Address 1 Project Address 2 (Competitive) Project City AHP/CICA AHP/CICA AHP/CICA Project State AHP/CICA Project County AHP/CICA Project MSA AHP/CICA Project Zip Code Project Census Tract (Competitive) Household Census Tract (Set-Aside) AHP Funding Stream AHP Homeownership competitive application program AHP Homeownership non-competitive application program AHP Rental housing Building Type Single Family Multi Family Mixed Use Tenure AHP/CICA Owner Occupied Rental Retention Period Project Status Project Approval Date (Competitive) Date of Disbursement (Set-Aside) Project Not Started Completion Date Withdrawal Date AHP Funds Per Project Dollar Amount of Direct Subsidy Awarded Page 1 of 5 AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA DRM AHP CICA Chapter Appendix A Status Notice Number Notice Name Final Name Competitive - Dollar amount of AHP Direct Subsidy Disbursed 23 Set-Aside 24 Dollar amount of AHP Advance Subsidy Committed 25 Dollar amount of AHP Advance Subsidy Disbursed 26 Dollar amount of advance on AHP subsidized advance Competitive - Dollar amount of project funds de-obligated (if applicable) 27 Set-Aside - Competitive - Dollar amount of project funds re-captured (if applicable) 28 Set-Aside Project Development Activity 29 Construction 30 Rehabilitation 31 Acquisition Member Applicant(s) Participation 32 Member Financing 33 FHLBank Advance 34 Mortgage 35 Reduced Closing Costs 36 Other Priorities in AHP Statute 37 Federal Government Property 38 39 40 41 HUD Owned Property Non-Profit Sponsor State or Local Agency Sponsor Housing Authority Sponsor Federal Program 42 Home Investment Partnership Program 43 44 45 46 Community Development Block Grants Federal Housing Administration Low-Income Housing Tax Credits Other Federal Housing Program Special Needs 47 Disabled 48 Elderly 49 Recently Homeless 50.1 Households at or below 30 area median income 50.2 Special Purpose Housing Rural Native American Land Accessible Design of Units SRO Housing Family Housing: 3 bedrooms or more Special Needs and Service-Enriched Housing Community Development or Revitalization Project Units and Costs 58 Number of units in project as proposed in AHP application 59 Number of project units after completion 51 52 53 54 55 56 57 60 Total development cost of housing project as proposed in AHP application 61 Total development cost of housing project at completion Reporting Location Cumulative Dollar Amount of Direct Subsidy Disbursed (Competitive) Dollar Amount of Set-aside Subsidy Disbursed (Set-Aside) AHP/CICA Dollar Amount of Advance Subsidy Awarded AHP/CICA Cumulative Dollar Amount of Advance Subsidy Disbursed AHP/CICA Dollar Amount of Subsidized Advance AHP/CICA Cumulative Dollar Amount of Project Funds De-Obligated Cumulative Dollar Amount of Project Funds Recaptured or Repaid (Competitive) Dollar Amount of Set-aside Funds Re-paid (Set-Aside) Retention Use of AHP Funds Construction Rehabilitation Acquisition Member Financial Participation Member Non-Permanent Financing FHLBank Advance Member Mortgage Loan Reduced Closing Costs Other Member Financial Participation Priorities in AHP Statute Federal Government Property AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA Housing and Urban Development (HUD) Owned Property Non-Profit 501 (c)(3) Sponsor State or Local Agency Sponsor Housing Authority Sponsor Federal Programs Home Investment Partnership (HOME) Program AHP/CICA AHP/CICA AHP/CICA AHP/CICA Community Development Block Grants (CDBG) Program Federal Housing Administration (FHA) Low-Income Housing Tax Credits (LIHTCs) Other Federal Housing Programs Special Needs Disabled Persons Elderly Persons Homeless Persons Number of Units Reserved for Households at or below 30% of A.M.I. at application Number of Units Reserved for Households at or below 30% of A.M.I. at completion Special Purpose Housing Rural Tribal Sponsorship Accessible Design of Units Single Room Occupancy (SRO) Housing Large Units: 3 Bedrooms or more Service-Enriched Housing Community Development Project Units and Costs Proposed Units Completed Units Total Estimated Costs of Project as Proposed in Application Total Actual Costs of Project at Completion AHP/CICA AHP/CICA AHP/CICA AHP/CICA Page 2 of 5 AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA DRM AHP CICA Chapter Appendix A Status Removed Removed Notice Number Notice Name Final Name For mixed use projects: total project development cost (housing plus other uses) at time of project 62 completion Additional Sources of Subsidy 63 State 64 Local 65 Charitable 66 Other Program Beneficiaries in AHP Competitive Program Homeownership Projects Only Number of units affordable to households at or below 80% of area median income as projected in the 67 application 68 Number of units affordable to households at or below 80% of area median income at completion 69 Number of units affordable to households at or below 50% of area median income at completion 70 Number of units for first time homebuyers AHP Competitive Program Homeownership Program Use of Funds 71 Interst rate write-down on home mortgage Removed 72 73 74 75 76 77 78 79 80 81 82 83 84 Removed Removed Removed Removed For Mixed Use Projects, Total Project Development Cost (housing plus other uses) at completion of the project Additional Sources of Subsidy State Subsidy Local Government Subsidy Non-Governmental Donated Funds Other Program Beneficiaries in AHP Competitive Program Homeownership Projects Only Proposed Number of Units Reserved for Occupancy by Homeownership Households At or Below 80% of A.M.I. as Proposed in the Application Number of Units Reserved for Occupancy by Homeownership Households At or Below 80% of A.M.I. at Project Completion Reporting Location AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA Number of Units Reserved for Occupancy by Households At or Below 50% of A.M.I. at Project Completion AHP/CICA First-Time Homebuyer Units AHP/CICA AHP Competitive Program Homeownership Projects Use of Funds Interest Rate Writedown on Home Mortgage AHP/CICA Principal reduction on home mortgage (down payment) Homeowner Closing Costs Homeowner Counseling Costs Second Mortgage Principal Reduction on Home Mortgage (Down Payment) Homeowners' Closing Costs Homebuyers' Counseling Costs Second Mortgage AHP Rental Housing Program Use of Funds: Entry For AHP Rental Housing Program Homeownership Program Use of Funds: Entry For Each Project Each Project TakeOut/Permanent Loan Permanent Loan Bridge Loan Bridge Loan Construction Loan Construction Loan Principal reduction on mortgage Principal Reduction on Mortgage Second Mortgage Second Mortgage Closing Costs Closing Costs Refinance Refinance Data for AHP Rental Housing Projects Only Data for AHP Rental Housing Projects Only Proposed Number of Rental Units Reserved for Number of units affordable to households at or below 50% of area median income as proposed in the AHP Households At or Below 50% of A.M.I. as Proposed in the Application application Number of Rental Units Reserved for Households At or Number of units affordable to households at or below 50% of area median income after project completion Below 50% of A.M.I. at Project Completion AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA 85 Number of units affordable to households between 51% and 60% of area median income after completion Actual Units between 51-60 AMI Change - Actual Units Affordable to households Units between 61-80 AMI To - Actual Units Reserved for households Units between 86 Number of units affordable to households between 61% and 80% of area median income after completion 51-80 AMI Number of units affordable to households at or below 100 percent of area median income after project Number of Rental Units Reserved for Households Above 80% of A.M.I. at Project Completion AHP/CICA 87 completion Dollar Amount of Non-AHP Subsidies at Project Completion 88 Dollar amount of additional subsidies after completion AHP/CICA First Mortgage APR 89 Interest rate (stated as APR) on first mortgage loan Second Mortgage APR 90 Interest rate (stated as APR) on second mortgage Data Elements for Each AHP Unit in the Set-Aside Data Elements for Each AHP Unit in the Set-Aside Program Program Dollar Amount of First Mortgage Loan 91 Set-Aside - Dollar amount of first mortgage AHP/CICA 92 Set-Aside - Dollar amount of second mortgage 93 Set-Aside - Interest rate (APR) on first mortgage Dollar Amount of Second Mortgage Loan (if applicable) First Mortgage Loan Annual Percentage Rate (APR) Page 3 of 5 AHP/CICA AHP/CICA DRM AHP CICA Chapter Appendix A Status Notice Number Notice Name 94 Set-Aside - Interest rate (APR) on second mortgage 95 HOEPA covered loan 96 Set-Aside - Homeowner Closing Costs Aggregated FHLBank Data: Competititve and Non-Competititve Programs 97 Number of competitive program applications received by the FHLBank 98 99 100 101 102 103 104 105 106 107 108 109 Removed Removed Removed Removed Added Added Added Added Added Added NDE NDE NDE NDE10 NDE11 NDE12 Added Added Added NDE13 NDE14 NDE16 Added NDE17 Added NDE18 Added NDE19 Added NDE20 Added Added Added Added Added Added Added NDE21 NDE22 NDE23 NDE24 NDE25 NDE26 NDE27 Number of competitive program applications awarded AHP commitments Dollar amount of required annual AHP allocation Dollar amount of AHP funds carried forward Dollar amount of AHPaccelerated funds Dollar amount of AHP de-obligated funds Dollar amount of AHP recaptured funds Total dollar amount of AHP funds obligated Total dollar amount of AHP funds disbursed Total dollar amount of AHP competitive funds allocated Total dollar amount of AHP competitive program funds disbursed Total dollar amount of AHP non-competitive program (homeownership set-aside) funds allocated Total dollar amount of AHP non-competitive homeownership funds disbursed Final Name Second Mortgage Loan Annual Percentage Rate (if applicable) HOEPA Covered Loan Household's Closing Costs Aggregated FHLBank Data: Competititve and NonCompetititve Programs Reporting Location AHP/CICA AHP/CICA AHP/CICA Competitive program - Number of applications received Competitive program - Number of applications approved for award Required Annual AHP Statutory Contribution Dollar Amount of AHP Funds Carried Forward Amount of AHP Funds Accelerated Funds de-obligated Funds recaptured and repaid Competitive program - Amount awarded Total Dollar Amount of AHP Funds Disbursed Competitive program - Statutory Allocation Competitive funds disbursed Set-aside - Statutory Allocation Set-aside funds disbursed CRS Round Letter (Competitive) Final Disbursement Date Other AHP funding adjustments Persons Recovering from Physical Abuse (Y/N) Persons Recovering from Substance Abuse (Y/N) Persons with HIV/AIDS If the project has been modified, indicate how it has been modified: Note - Can enter more than one (1) Number of Units (2) Targeting (3) Amount of Subsidy (4) Services & Activites (5) Other Number of Cumulative Extensions Cumulative Dollar Amount of Subsidy Modification Proposed Number of Units Reserved for Occupancy by Homeownership Households At or Below 50% of A.M.I. as Proposed in the Application Proposed Number of Rental Units Reserved for Occupancy by Households At or Below 80% of A.M.I. as Proposed in the Application Number of Rental Units Reserved for Occupancy by Households At or Below 80% of A.M.I. at Project Completion Dollar Amount of Non-AHP Subsidies as Proposed in the Application (Rental) Downpayment, closing cost assistance (subsidy is used for) Rehabilitation First-Time Homebuyer Household's Income Household's Income as a Percentage of A.M.I. Term of First Mortgage Loan Scattered Site Project AHP/CICA AHP/CICA CRS AHP/CICA AHP/CICA AHP/CICA Page 4 of 5 CRS CRS CRS CRS CRS CRS CRS CRS CRS AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA DRM AHP CICA Chapter Appendix A Status Notice Number Added NA_CICA3 Added NA_CICA4 Added Added Added Added NA_CICA5 NA_CICA7 NA_CICA8 NA_CICA10 Added NA_CICA11 Added Added Added Added Added Notice Name Final Name Reporting Location CIP Advances - Number of new commitments - Housing CIP Advances - Number of new commitments - Non housing Non CIP Advances - Number of new commitments - Non Housing CICA letters of credit - Number of new commitments CIP letters of credit - Number of new commitments CIP Advances - New commitments amount - Housing CRS CRS NA_CICA12 NA_CICA14 NA_CICA15 NA_CICA17 NA_CICA18 CIP Advances - New commitments amount - Non housing Non CIP Advances - New commitments amount - Non housing CICA letters of credit - New commitments amount CIP letters of credit - New commitments amount CIP Advances - Commitments amount - Housing CIP Advances - Commitments amount - Non housing Added Added Added Added Added Added Added Added NA_CICA19 NA_CICA21 NA_CICA22 NA_CICA24 NA_CICA25 NA_CICA26 NA_CICA28 NA_CICA29 Non CIP Advances - Commitments amount - Non housing CIP letters of credit - Commitments amount CICA letters of credit - Commitments amount CIP Advances - Disbursed amount - Housing CIP Advances - Disbursed amount - Non housing Non CIP Advances - Disbursed amount - Non housing CIP Advances - Outstanding amount - Housing CIP Advances - Outstanding amount - Non housing CRS CRS CRS CRS CRS CRS CRS CRS Added NA_CICA30 Non CIP Advances - Outstanding amount - Non housing CRS Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added Added NM_CICA4 NM_CICA5 NM_CICA6 Project Number Term of Advance or Letter of Credit (LOC) State - Projected Location of Project CICA Use of Funds Per Project: Dollar Amount of Advance, Grant or Letter of Credit Non-CIP Advance Non-CIP Grant Non-CIP Letter of Credit (LOC) CIP Advance CIP Letter of Credit (LOC) CICA Project Information: Urban Rural Housing Project Economic Development Project Mixed Use Project Housing and Economic Development Indicators: Projected Total Rental Housing Units Projected Total Owner-Occupied Housing Units Projected Total Number of Jobs Created or Retained Targeted Beneficiaries: Geographically Defined Beneficiaries Individual Beneficiaries Activity Beneficiaries Other Targeted Beneficiaries AHP/CICA AHP/CICA AHP/CICA NM_CICA7 NM_CICA8 NM_CICA9 NM_CICA10 NM_CICA11 NM_CICA12 NM_CICA13 NM_CICA14 NM_CICA15 NM_CICA16 NM_CICA17 NM_CICA18 NM_CICA19 NM_CICA20 NM_CICA21 NM_CICA22 NM_CICA23 NM_CICA24 Page 5 of 5 CRS CRS CRS CRS CRS CRS CRS CRS CRS CRS AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA AHP/CICA Data Reporting Manual AHP/CICA Chapter APPENDIX B. COMPETITIVE MAPPING Appendix B of this document provides a complete mapping of Project Level Competitive Information. This master list cross references the following information: Status represents the element’s status in the new database as it relates to previous actual or proposed reporting (i.e. converted, added, deleted, etc) Notice Number represents the Federal Register Proposed Data Element List Number Notice Name represents the Federal Register Proposed Data Element List Name Final Name represents the final data collection name Definition represents the final element definition and includes examples as needed AHP Web Screen Name represents the AHP Web application screen name Previous Column Name represents the old AHP database column name Previous Column Attribute represents the old AHP database column attribute Previous Submission File represents the old AHP submission file name Previous Ordinal Position represents the old AHP submission file position number Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Ordinal Position Competitive TYPE File represents the new AHP/CICA submission file position number where TYPE is the type of submission file (Application/Project, Complete, Delta/Progress, and Post Completion/Recapture/Retention) Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Grandfathered represents whether the new AHP/CICA element is not required for ongoing projects approved by the board in calendar years 2005 and prior (i.e. Y or N) Phase In represents whether the new AHP/CICA element’s reporting can be deferred until June 30, 2007 for projects approved by the board in calendar year 2006. Phase In elements can be reported initially but will not be required to be reported until the phase in period ends on June 30, 2007 (i.e. Y or N). Page 13 of 25 DRM AHP CICA Chapter Appendix B Status Notice Number Notice Name Final Name Project Information 1 Federal Home Loan Bank Number Added Definition FHLB Number/District Reporting Period Beg Date Reporting Period End Date 4 Date of AHP round (dd/mm/year) Year of Round Round Letter (Competitive) 6 Member's FHFB ID number Member FHFB ID Sponsor Address 1 Added 7.3 Sponsor Address 2 Added 7.4 Sponsor City Competitive - Project Sponsor's State 7.5 Set-Aside - Sponsor State Competitive - Project Sponsor's Zip Code 7.6 Set-Aside Competitive - Project Name 8.1 Set-Aside NDE27 Competitive - Project Address 8.2 Set-Aside - The reporting period end date is defined as the last day in the reporting period. If the reporting period is 1/1 - 6/30, then the reporting end date is 6/30/YYYY. If the reporting period is 7/1 - 12/31, then the reporting end date is 12/31/YYYY. (competitive) If the reporting period is 1/1 - 12/31, then the reporting end date is 12/31/YYYY.( set-aside) Report the Year of the Round. The year that the Board of Directors approved the project for an award. Report the round letter (i.e., A, B, C or D) for the round in which the project was approved for an award by the FHLBank's Board of Directors. Report the FHFB assigned Member number. Report the FHLBank's Competitive program's application identifier. The program's application identifier (e.g., project number or application number) is the identifier assigned to each competitive application received by the FHLBank. (Competitive) Report the FHLBank's program household identifier. The program identifier is the identifier assigned to Competitive Program Application Identifier (Competitive) each household application approved for Set-Aside Program Household Identifier (Set-Aside) a FHLBank set-aside grant. (Set-Aside) FHLBank Project Number 3 AHP project ID number Competitive - Project Sponsor's Name 7.1 Set-Aside Competitive - Project Sponsor's Address 7.2 Set-Aside - Added FHLBank District Number Competitive - End Date of this reporting period (calendar year; dd/mm/year) 2 Set-Aside - Beginning and end date of reporting period (dd/mm/year) NDE AHP Web Screen Name Project Information Sponsor Name Report the name of the primary sponsor. Name Primary Sponsor Report the address of the primary sponsor as listed on the application. Report line two (as applicable) of the address of the primary sponsor as listed on the application. Report the city location of the primary sponsor as listed on the application. Report the state location of the primary sponsor as listed on the application. Scattered Site Project Report the zip code of the primary sponsor as listed on the application. Report the name of the project as listed on the application. Is the project a scattered site. Report if the project has multiple locations. Project Address 1 For non-scattered site projects, report on line one the address of the project as listed on the application. For scattered site units, at project completion, report on line one the address of the last completed AHP assisted unit. Sponsor Zip Code (+4) Project Name Page 1 of 18 Previous Column Name PNUMBER Previous Column Attribute Char (9) Previous Submission File DISTRICT Char (2) APPDATA YEAR Number APPDATA ROUND Char (1) APPDATA PROGRESSDATA DOCKET Char (5) APPDATA BANKPNUMBER SNAME QSNAME Char (12) Char (45) APPDATA APPDATA PROGRESSDATA SADDR Char (45) APPDATA SCITY Char (25) APPDATA SSTATE Char (2) APPDATA SZIP Char (10) APPDATA PROJNAME Char (45) APPDATA SCATTER Boolean APPDATA DRM AHP CICA Chapter Appendix B Status Added Added Notice Number Notice Name 8.3 8.4 Competitive - Project State 8.5 Set-Aside - Competitive - Project Zip Code 8.8 Set-Aside - Competitive - Project County 8.6 Set-Aside Competitive - Project MSA 8.7 Set-Aside - Removed Removed Removed Competitive - Project Census Tract 8.9 Set-Aside 9 AHP Homeownership competitive application program Competitive - AHP Homeownership non-competitive application program 10 Set-Aside 11 AHP Rental housing Building Type Final Name Previous Column Name Previous Column Attribute Previous Submission File Project Address 2 (Competitive) Definition AHP Web Screen Name For non-scattered site projects, report on line two the address (as applicable) of the project as listed on the application. For scattered site units, at project completion, report on line two the address of the last completed AHP assisted unit. Project City For non-scattered site projects, report the project's city location as listed on the application. For scattered site units, at application, report the sponsor's city location for this data field. For scattered site units, at project completion, report the city location of the last completed AHP asisted unit. PCITY Char (25) APPDATA Project State For non-scattered site projects, report the project's state location as listed on the application. For scattered site units, at application, report the sponsor's state location for this data field. For scattered site units, at project completion, report the state location of the last completed AHP assisted unit. PSTATE Char (2) APPDATA Project Zip Code For non-scattered site projects, report the project's zip code as listed on the application. For scattered site units, at project completion, report the zip code of the last completed AHP assisted unit. Project County For non-scattered site projects, report the project's county location as listed on the application. For scattered site units, at project completion, report the county location of the last completed AHP assisted unit. Project MSA For non-scattered site projects, report the project's MSA location as listed on the application. For scattered site units, at project completion, report the MSA location of the last completed AHP assisted unit. Project Census Tract (Competitive) Household Census Tract (Set-Aside) AHP Homeownership competitive application program AHP Homeownership non-competitive application program AHP Rental housing Building Type Page 2 of 18 For non-scattered sites projects, report the project's census tract location as listed on the application using the above address (data element 8.2). For scattered site units, at project completion, report the census tract location of the last completed AHP assisted unit.(Competitive) Report the census tract location of the property being purchased by the household using the address as reported on the Housing and Urban Development (HUD) - 1 Settlement Statement or equivalent document. (Set-aside) DRM AHP CICA Chapter Appendix B Status Notice Number Notice Name Final Name SFOWNER SFRENTAL Long Int (9) APPDATA Long Int (9) APPDATA MFOWNER MFRENTAL Long Int (9) APPDATA Long Int (9) APPDATA Previous Submission File 12 Single-Family (1-4 units) Single Family 13 MultiFamily (5 units or more) Multi Family Mixed Use Is the project a mixed use project, i.e., a project that includes both residential housing units and commercial space that generates income. For example, a project that contains residential housing units and non-housing space that generates revenue (such as a retail or office space leased to another entity). COMSPACE Boolean APPDATA Is the project an owner-occupied project, defined as one or more owner-occupied units in a single-family or multifamily building, including condominiums and cooperative housing. OWNER Boolean APPDATA Is the project a rental project, defined as one or more dwelling units for occupancy by tenants or households that are not owner-occupants, including overnight and emergency shelters, transitional housing for homeless households, mutual housing, single room occupancy housing and multi family buildings. RENTAL Boolean APPDATA COMPDATE Char (6) YYYYMM PROGRESSDATA Tenure Competitive - Owner-occupied 15 Set-Aside - Tenure Owner Occupied 16 Rental 17 Number of years in retention agreement Rental Retention Period Project Status Removed AHP Web Screen Name Previous Column Attribute Is the project a single-family structure with one to four dwelling units. (competitive) Is the set-aside grant for household occupancy in a single-family structure. See definition of single-family structure in the glossary. (set-aside) Is the project a rental or owner-occupied multi-family structure with five or more dwelling units. 14 Mixed use Removed Definition Previous Column Name Competitive - Project start date (date of first disbursement) 18 Set-Aside 19 Project not started Project Status Project Approval Date (Competitive) Date of Disbursement (Set-Aside) Project Not Started Report the project's approval date. The project's approval date is the date when the FHLBank's Board of Directors has approved the competitive program application for an award. For alternates, the project's approval date is the date when the project has gone from an alternate project to an awarded project. (Competitive) Report the date of the set-aside grant disbursement to the household. The date of the disbursement is the closing date shown on the homeowner's Housing and Urban Development (HUD) - 1 Settlement Statement or equivalent document. (Set-Aside) Report the project's date of completion. For rental projects and owner-occupied rehabilitation projects, the completion date is the date as determined by the FHLBank. For non-rehabilitation owneroccupied projects, the completion date is the date of the "closing" (do not consider the 3 day rescission period). For nonrehabilitation owner-occupied scattered site units, completion is defined as the closing date of the last completed AHP assisted unit. 20 Completion Date Completion Date Completion Date Page 3 of 18 DRM AHP CICA Chapter Appendix B Status Notice Number Notice Name Final Name 21 Withdrawal Date (if applicable) Added Definition AHP Web Screen Name Report the project's date of withdrawal. The withdrawal date is the date when the FHLBank formally determines that the project is withdrawn. Withdrawal Date NDE Project Development Activity Final Disbursement Date Use of AHP Funds 29 Construction Construction 30 Rehabilitation Rehabilitation 31 Acquisition Member Non-Permanent Financing 33 FHLBank Advance FHLBank Advance 34 Mortgage Member Mortgage Loan 35 Reduced Closing Costs Reduced Closing Costs Priorities in AHP Statute 37 Federal Government Property Other Member Financial Participation Priorities in AHP Statute 38 HUD Owned Property Federal Government Property Housing and Urban Development (HUD) Owned Property 39 Non-Profit Sponsor Non-Profit 501 (c)(3) Sponsor 40 State or Local Agency Sponsor State or Local Agency Sponsor 41 Housing Authority Sponsor Federal Program 42 Home Investment Partnership Program Housing Authority Sponsor Federal Programs 43 Community Development Block Grants Home Investment Partnership (HOME) Program Community Development Block Grants (CDBG) Program 44 Federal Housing Administration Federal Housing Administration (FHA) 45 Low-Income Housing Tax Credits Low-Income Housing Tax Credits (LIHTCs) 46 Other Federal Housing Program Special Needs 47 Disabled Previous Submission File NEWCON Boolean APPDATA REHAB Boolean APPDATA PURCHASE Boolean APPDATA MEMFINAN Float (15.3) APPDATA PERM Boolean Member Financial Participation 32 Member Financing 36 Other Previous Column Attribute Report the date of the final disbursement of AHP subsidy to the project. Are the awarded funds for the project being used for construction. Are the awarded funds for the project being used for rehabilitation. Are the awarded funds for the project being used for acquisition. Acquisition Member Applicant(s) Participation Previous Column Name Other Federal Housing Programs Special Needs Excluding the pass through of AHP subsidy, is non-permanent financing being provided by the member. Excluding the pass through of AHP subsidy, is an advance being provided by the FHLBank, e.g., a CIP advance. Excluding the pass through of AHP subsidy, is a mortgage loan being provided by the member. Excluding the pass through of AHP subsidy, are reduced closing costs being provided by the member. Excluding the pass through of AHP subsidy, are grant(s) or in-kind contributions or services being provided by the member. Does the project use any Federal Government Property, excluding Housing and Urban Development (HUD) owned property. Does the project use any HUD owned property. Is the primary sponsor of the project a not-for-profit organization. Is the primary sponsor of the project a state or local agency excluding local housing authorities. Is the primary sponsor of the project a local housing authority. Is the HOME program a permanent source of funds for the project. Is the CDBG program a permanent source of funds for the project. Is the FHA a permanent source of funds for the project. Are LIHTCs a permanent source of funds for the project. Are any other Federal housing programs a permanent source of funds for the project, excluding Federal housing programs already reported. Report a "Yes" for this data element if 20% or more of the total units (data element (58)) are reserved for occupancy by mentally or physically disabled persons, and the FHLBank awards scoring points for this population. Disabled Persons Page 4 of 18 APPDATA FEDPROP Boolean APPDATA HUDPROP Boolean APPDATA NONPROF Boolean APPDATA HOME Float (15.3) APPDATA CDBG Float (15.3) APPDATA LIHTC Float (15.3) APPDATA PRESERVE MCKINNEY OTHERHUD Float (15.3) Float (15.3) Float (15.3) APPDATA HANDUNIT Long Int APPDATA DRM AHP CICA Chapter Appendix B Status Notice Number Notice Name Final Name 48 Elderly Added NDE10 Added NDE11 Added NDE12 Elderly Persons Definition Report a "Yes" for this data element if 20% or more of the total units (data element (58)) are reserved for occupancy by elderly persons, and the FHLBank awards scoring points for this population. Persons Recovering from Physical Abuse (Y/N) Report a "Yes" for this data element if 20% or more of the total units (data element (58)) are reserved for occupancy by persons recovering from physical abuse, and the FHLBank awards scoring points for this population. Persons Recovering from Substance Abuse (Y/N) Special Purpose Housing 49 Recently Homeless Persons with HIV/AIDS Special Purpose Housing Homeless Persons 50.1 Households at or below 30 area median income Number of Units Reserved for Households at or below 30% of A.M.I. at application 50.2 Number of Units Reserved for Households at or below 30% of A.M.I. at completion 51 Rural Rural 52 Native American Land Tribal Sponsorship 53 Accessible Design of Units Accessible Design of Units 54 SRO Housing Single Room Occupancy (SRO) Housing 55 Family Housing: 3 bedrooms or more Large Units: 3 Bedrooms or more Page 5 of 18 AHP Web Screen Name Previous Column Name Previous Column Attribute Previous Submission File ELDERLY Long Int APPDATA HOMELESS Number APPDATA RURAL Boolean APPDATA SROUNIT Long Int (9) APPDATA Report a "Yes" for this data element if 20% or more of the total units (data element (58)) are reserved for occupancy by persons recovering from substance abuse, and the FHLBank awards scoring points for this population. Report a "Yes" for this data element if 20% or more of the total units (data element (58)) are reserved for occupancy by persons with HIV/AIDS, and the FHLBank awards scoring points for this population. Report a "Yes" for this data element if 20% or more of the total units (data element (58)) are reserved for occupancy by homeless persons, or transitional housing for the homeless, and the FHLBank awards scoring points for this population. Report the number of units reserved for occupancy for households with incomes at or below 30% of A.M.I. as proposed in the application Report the number of units reserved for occupancy for households with incomes at or below 30% of A.M.I. at completion of the project. Is the project located in a rural area as defined by the FHLBank, and the FHLBank awards scoring points for such projects. Is the project sponsored by a Native American Tribe, an Alaskan Native Village, or the Department of Hawaiian Homelands, and the FHLBank awards scoring points for such projects. Will the project have "Accessible Design of Units" available for occupancy, and the FHLBank awards scoring points for such projects. See definition of accessible design of units in the glossary. Will the project have "SRO" units available for occupancy. See the definition of SRO in the glossary. Will the project have units with three (3) or more bedrooms available for occupancy, and the FHLBank awards scoring points for such projects. DRM AHP CICA Chapter Appendix B Status Notice Number Notice Name Final Name 56 Special Needs and Service-Enriched Housing Service-Enriched Housing 57 Community Development or Revitalization Community Development 70 Number of units for first time homebuyers Additional Sources of Subsidy Removed 63 State State Subsidy 64 Local Local Government Subsidy 65 Charitable 66 Other Project Units and Costs Removed First-Time Homebuyer Units Additional Sources of Subsidy Non-Governmental Donated Funds Other Project Units and Costs 58 Number of units in project as proposed in AHP application Proposed Units 59 Number of project units after completion Completed Units 60 Total development cost of housing project as proposed in AHP application Total Estimated Costs of Project as Proposed in Application 61 Total development cost of housing project at completion Total Actual Costs of Project at Completion For mixed use projects: total project development cost (housing plus other uses) at time of project 62 completion For Mixed Use Projects, Total Project Development Cost (housing plus other uses) at completion of the project Program Beneficiaries in AHP Competitive Program Homeownership Projects Only Program Beneficiaries in AHP Competitive Program Homeownership Projects Only Number of units affordable to households at or below 80% of area median income as projected in the 67 application Proposed Number of Units Reserved for Occupancy by Homeownership Households At or Below 80% of A.M.I. as Proposed in the Application. 68 Number of units affordable to households at or below 80% of area median income at completion Number of Units Reserved for Occupancy by Homeownership Households At or Below 80% of A.M.I. at Project Completion Page 6 of 18 Definition AHP Web Screen Name Will the project provide service-enriched housing for occupants, and the FHLBank awards scoring points for such housing. See definition of service-enriched housing in the glossary. Will the project meet housing needs documented as part of a community revitalization or economic development strategy approved by a unit of a state or local government, and the FHLBank awards scoring points for this project. Previous Column Name Previous Column Attribute Previous Submission File DP1DEVEL DP2DEVEL Boolean APPDATA TOTUNIT QUAPPROVED Long Int (9) APPDATA Long Int (9) PROGRESSDATA Report the number of AHP assisted homeownership units for first-time homebuyers at completion of the project. The definition of first-time homebuyer is determined by the FHLBank. Are state funds a projected source of funds for the project. Exclude Federal government program funds such as HOME and CDBG. Are local government funds a projected source of funds for the project. Exclude Federal government program funds such as HOME and CDBG. Are donated funds from nongovernmental sources a projected source of funds for the project. Report the total number of units proposed by the awarded project, including all non-AHP and AHP assisted units. Report the total number of completed units. For rental projects and owneroccupied rehabilitation projects, completion is defined by the FHLBank. For non-rehabilitation owner-occupied projects, the completion date is the date of the "closing" (do not consider the 3 day rescission period). For nonrehabilitation owner-occupied scattered site units, completion is defined as the closing date of the last completed AHP assisted unit. Report the total estimated development costs of the project as proposed in the application. Report the total actual development costs of the project as of the completion date. Report the number of AHP assisted units reserved for occupancy by homeownership households with incomes at or below 80% of A.M.I. as Owner Units 0-50AMI proposed in the application. Report the number of AHP assisted units for homeownership households with incomes at or below 80% of A.M.I. at completion of the project. timeseries where AHPPROGRESS.QUCO MPLETE = element Long Int (9) PROGRESSDATA DEVCOST Float (15.3) APPDATA OWNLE50 OWNER5180 Long Int (9) APPDATA Long Int (9) APPDATA DRM AHP CICA Chapter Appendix B Status Notice Number Added NDE17 Notice Name Final Name Proposed Number of Units Reserved for Occupancy by Homeownership Households At or Below 50% of A.M.I. as Proposed in the Application 69 Number of units affordable to households at or below 50% of area median income at completion AHP Competitive Program Homeownership Program Use of Funds 71 Interst rate write-down on home mortgage 72 Principal reduction on home mortgage (down payment) 73 Homeowner Closing Costs 74 Homeowner Counseling Costs 75 Second Mortgage Data for AHP Rental Housing Projects Only Removed Added NDE18 Added NDE19 Number of units affordable to households at or below 50% of area median income as proposed in the 83 AHP application Number of Units Reserved for Occupancy by Households At or Below 50% of A.M.I. at Project Completion AHP Competitive Program Homeownership Projects Use of Funds Definition AHP Web Screen Name Report the number of AHP assisted units reserved for occupancy by homeownership households with incomes at or below 50% of A.M.I. as proposed in the application. Owner Units 0-50AMI Previous Column Name Previous Column Attribute OWNLE50 Long Int (9) APPDATA Report the number of AHP assisted units for homeownership households with incomes at or below 50% of A.M.I. at completion of the project. QOWNLE50 Long Int (9) PROGRESSDATA COUNFEES Boolean Rental Units 0-50AMI RENTLE50 RENT5160 RENT6180 LongInt (9) APPDATA LongInt (9) APPDATA LongInt (9) APPDATA Rental Units 0-51 RENTLE50 Long Int (9) APPDATA QRENTLE50 Long Int (9) PROGRESSDATA Are funds from the award used for interest rate writedown on the home mortgage. Are funds from the award used for principal reduction (down payment) on Principal Reduction on Home Mortgage (Down Payment) the homebuyers' home mortgage. Are funds from the award used for homeowners' closing costs. Homeowners' Closing Costs Are funds from the award used for homebuyers' counseling costs. Homebuyers' Counseling Costs Second Mortgage Data for AHP Rental Housing Projects Only Report the number of AHP assisted rental units reserved for occupancy by Proposed Number of Rental Units Reserved for households with incomes at or below Occupancy by Households At or Below 80% of A.M.I. as 80% of A.M.I. as proposed in the Proposed in the Application application. Report the number of AHP assisted rental units reserved for occupancy by Number of Rental Units Reserved for Occupancy by households with incomes at or below 80% of A.M.I. at completion of the Households At or Below 80% of A.M.I. at Project project. Completion Report the number of AHP assisted rental units reserved for occupancy by Proposed Number of Rental Units Reserved for households with incomes at or below 50% of A.M.I. as proposed in the Households At or Below 50% of A.M.I. as Proposed in the Application application. Report the number of AHP assisted rental units reserved for occupancy by households with incomes at or below Number of Rental Units Reserved for Households At or 50% of A.M.I. at completion of the Below 50% of A.M.I. at Project Completion project. Interest Rate Writedown on Home Mortgage Removed Number of units affordable to households at or below 50% of area median income after project 84 completion Number of units affordable to households between 51% and 60% of area median income after 85 completion Removed Number of units affordable to households between 61% and 80% of area median income after 86 completion Actual Units between 51-60 AMI Change - Actual Units Affordable to households Units between 61-80 AMI To - Actual Units Reserved for households Units between 51-80 AMI Number of units affordable to households at or below 100 percent of area median income after project 87 completion Report the number of rental units reserved for occupancy by households Number of Rental Units Reserved for Households Above with incomes above 80% of A.M.I. at 80% of A.M.I. at Project Completion completion of the project. Added Removed Removed Report the dollar amount of non-AHP subsidies as proposed in the application, Dollar Amount of Non-AHP Subsidies as Proposed in the including grants, below-market loans, Application (Rental) LIHTCs, CDBG and tax credit equity. NDE20 88 Dollar amount of additional subsidies after completion 89 Interest rate (stated as APR) on first mortgage loan 90 Interest rate (stated as APR) on second mortgage AHP Rental Housing Program Homeownership Program Use of Funds: Entry For Each Project Previous Submission File Report the dollar amount of non-AHP subsidies, including grants, below-market Dollar Amount of Non-AHP Subsidies at Project loans, LIHTCs, CDBG and tax credit Completion equity, at completion of the project First Mortgage APR Second Mortgage APR AHP Rental Housing Program Use of Funds: Entry For Each Project Page 7 of 18 APPDATA DRM AHP CICA Chapter Appendix B Status Notice Number Notice Name Final Name 79 Principal reduction on mortgage Principal Reduction on Mortgage 80 Second Mortgage Second Mortgage 81 Closing Costs Closing Costs Definition Are funds from the award used for a permanent loan for the rental project. Are any bridge loans being provided for the rental project by the member. Are any construction loans being provided for the rental project by the member. Are funds from the award used for principal reduction on the mortgage for the rental project. Are funds from the award used for a second mortgage for the rental project. Are funds from the award used for closing costs for the rental project. Refinance Are funds from the award used to refinance a mortgage loan, in conjunction with the purchase, construction or rehabilitation of the rental project. 76 TakeOut/Permanent Loan Permanent Loan 77 Bridge Loan Bridge Loan 78 Construction Loan Construction Loan 82 Refinance AHP Funds Per Project Previous Column Name Previous Column Attribute Previous Submission File BRIDGE Boolean APPDATA CONLOAN Boolean APPDATA REFI Boolean APPDATA Direct Subsidy Approved DIRSUB QDIRSUBAPPROVED Float (15) Float (15) APPDATA PROGRESSDATA Direct Subsidy Drawn QDIRSUBDRAWN AHP Web Screen Name AHP Funds Per Project 26 Dollar amount of advance on AHP subsidized advance Dollar Amount of Subsidized Advance Report the dollar amount of the direct subsidy that the FHLBank has awarded to the project. Report the cumulative dollar amount of direct subsidy funds disbursed, without netting out recaptures or repayments, to the project since its approval date. (Competitive) Report the dollar amount of the set-aside grant disbursed to the household. (SetAside) Report the dollar amount of the advance subsidy that the FHLBank has awarded to the project. Report the cumulative dollar amount of advance subsidy funds disbursed, without netting out recaptures and repayments, to the project since its approval date. Report the dollar amount of the subsidized advance approved to the project. Competitive - Dollar amount of project funds de-obligated (if applicable) 27 Set-Aside - Cumulative Dollar Amount of Project Funds DeObligated Report the cumulative dollar amount of funds de-obligated from the project since its approval date. 22 Dollar amount of AHP Direct Subsidy Committed Dollar Amount of Direct Subsidy Awarded Competitive - Dollar amount of AHP Direct Subsidy Disbursed 23 Set-Aside - Cumulative Dollar Amount of Direct Subsidy Disbursed (Competitive) Dollar Amount of Set-aside Subsidy Disbursed (SetAside) 24 Dollar amount of AHP Advance Subsidy Committed Dollar Amount of Advance Subsidy Awarded 25 Dollar amount of AHP Advance Subsidy Disbursed Cumulative Dollar Amount of Advance Subsidy Disbursed Page 8 of 18 Float (15) PROGRESSDATA PVAS Float (15) Advance Subsidy Approved QADVSUBAPPROVED Float (15) APPDATA PROGRESSDATA Advance Subsidy Drawn QADVSUBDRAWN Float (15) PROGRESSDATA Advance Approved SUBADV QADVAPPROVED Float (15) Float (15) APPDATA PROGRESSDATA DRM AHP CICA Chapter Appendix B Status Notice Number Notice Name Competitive - Dollar amount of project funds re-captured (if applicable) 28 Set-Aside - Added NDE13 Final Name Definition Report the cumulative dollar amount of funds recaptured and repaid from the project since its approval date. (Competitive) Cumulative Dollar Amount of Project Funds Recaptured Report the dollar amount of set-aside or Repaid (Competitive) funds re-paid by the household to the Dollar Amount of Set-aside Funds Re-paid (Set-Aside) - FHLBank due to refinancing or sale. (SetRetention aside) If the project has been modified, indicate how it has been modified: Note - Can enter more than one (1) Number of Units (2) Targeting (3) Amount of Subsidy (4) Services & Activites (5) Other Added NDE16 Cumulative Dollar Amount of Subsidy Modification Added NDE14 Number of Cumulative Extensions Page 9 of 18 If the project has been modified pursuant to the AHP regulation since its approval date, enter the reason(s) for the project modification(s). You may enter more than one reason for the project modification. Indicate a "Yes" if the project has been modified because (1) the number of units available have changed from what was reported at the time the application was approved; (2) the approved income targeting of units has changed; (3) the approved subsidy amount has changed; (4) the services and activities as approved in the application have changed; and (5) other project characteristics not listed above have changed the scoring. Report the cumulative dollar amount of the subsidy modification since the project's approval date. This data field is the difference between the project's approved subsidy amount at application and the project's current approved subsidy amount. The cumulative dollar amount of subsidy modification could be a negative or positive number. For example, at application the project is approved for a direct subsidy of $300,000, at progress the dollar amount of subsidy has decreased to $200,000. The difference between the direct subsidy amount at application and the current approved direct subsidy amount is a negative $100,000. Report a negative $100,000 for this data field. Report the number of cumulative extensions approved for the project since its approval date. This data field is the sum of extensions approved during the reporting period plus all previous approved extensions. AHP Web Screen Name Previous Column Name Previous Column Attribute Previous Submission File DRM AHP CICA Chapter Appendix B Previous Ordinal Position Notice Number Column Name FHFBProjID Format Rules 5 3 3 1 2 1 2 DistrictID 2 RptBegDte RptEndDte MM/DD/YYYY MM/DD/YYYY Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date Beg date must not be > Currrent date 1 2 41 RndYr Integer (YYYY) Valid YYYY 3 RndLetter Char (1) A-D FHFBID Integer 6 11 Ordinal Position Competitive Post Completion File Valid formats are 01 - 12 Match district to loginID and content 13 2 2 Ordinal Position Competitive Progress File Column Attribute Char (2) Zerofilled NDE Ordinal Position Competitive Complete File Ordinal Position Competitive Application File FHLBProjID (Competitive) Char (15) FHLBHoushldID (SetAside) Char (15) As with Legacy system, suggested format is YYYYR########## Where YYYY = Year R = Round Letter ########## = project identifier Edit Checks Grandfathered Phase In 3 Y N 1 2 Y Y N N N N 4 7 Valid FHFB ID in Membership Database 6 Competitive - for application data, ID must be unique for progress or post completion/retention data and must have a parent in application data Competitive - Must match previous submissions' ID Set Aside - for disbursement data, ID must be unique for post completion/retention data and must have a parent in disbursement data Set Aside - Must match previous submissions' ID N 36 75 7.1 10 SponName Char (100) 8 7.2 76 SponAddr1 Char (100) 9 7.3 SponAddr2 Char (100) 10 7.4 77 SponCity Char (100) 11 Valid City in the State N 7.5 78 SponState Char (2) 12 Valid State Code/Abbreviation N 13 Valid City, State, Zip Code Combination N 7.6 79 SponZip Char (10) 8.1 12 ProjName Char (100) ScttrdSte Char (1) 46 NDE27 8.2 ProjAddr1 Char (100) Minimum 5 char Zerofilled Include "-" Y or N 4 4 4 5 Y N Y N N N 14 N 15 N 16 If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion 7 Page 10 of 18 N N DRM AHP CICA Chapter Appendix B Previous Ordinal Position Notice Number 8.3 8.4 13 Column Name Column Attribute ProjAddr2 Char (100) ProjCity Format Rules Char (100) ProjState Char (2) 8.8 ProjZip Char (10) Minimum 5 char Zerofilled Include "-" 8.6 ProjCntyCde Char (3) Zerofilled 8.7 ProjMSA Char (5) Zerofilled ProjTract HoushldTract Char (7) Ordinal Position Competitive Complete File 17 8 18 8.5 14 8.9 9 Ordinal Position Competitive Application File Edit Checks Valid City in the State; If NDE27 is N, element is required; If NDE27 is Y, element must = Sponsor City (element 7.4) at application AND then required at completion 12 Valid State; If NDE27 is N, element is required; If NDE27 is Y, element must = Sponsor State (element 7.5) at application AND then required at completion Vaild City, State, Zip Code Combination; If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion Valid County Code; Valid County in the State; If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion Valid MSA; Valid MSA given the zip code; If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion 14 Valid Census Tract; Competitve: If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion 10 22 13 20 Zerofilled Tract Numbers are ####.## (include ".") 23 Ordinal Position Competitive Post Completion File 9 19 21 Ordinal Position Competitive Progress File 11 10 11 Page 11 of 18 Grandfathered Phase In N N Y N Y N N N N N N N N Y DRM AHP CICA Chapter Appendix B Ordinal Position Competitive Complete File Ordinal Position Competitive Progress File Ordinal Position Competitive Post Completion File Column Name Column Attribute Format Rules Ordinal Position Competitive Application File 50 12 51 SingleFmly Char (1) Y or N 24 52 13 53 MultiFmly Char (1) Y or N 25 If elements 13 and 14 are N, this element must be Y (at least one of elements 12, 13, or 14 must be Y) If elements 12 and 14 are N, this element must be Y (at least one of 12, 13, or 14 must be Y) 14 43 MixedUse Char (1) Y or N 26 If elements 12 and 13 are N, this element must be Y (at least one of elements 12, 13, or 14 must be Y) N 27 If Y then element 67 or NDE17 > 0; If element 16 is N, this element must be Y (at least 15 or 16 must be Y) N 28 If Y then element 83 or NDE18 > 0; If element 15 is N, this element must be Y (at least 15 or 16 must be Y) N 29 Competitive: YYYY of this element must = YYYY of element 4 N Previous Ordinal Position Notice Number 15 66 16 67 17 18 19 20 26 Owner Char (1) Y or N Rental Char (1) ProjApprDte (Competitive) DisbDte (Set-Aside) Valid MM/DD/YYYY Date (mm/dd/yyyy) Valid MM/DD/YYYY CmpltDte Y or N Date (mm/dd/yyyy) Valid MM/DD/YYYY Edit Checks Competitive: Must be > element 18; If element 21 not null then value not permitted 5 Page 12 of 18 Grandfathered Phase In N N Y N DRM AHP CICA Chapter Appendix B Previous Ordinal Position Notice Number 21 Column Name Column Attribute Format Rules WthdrwDte Date (mm/dd/yyyy) Valid MM/DD/YYYY Ordinal Position Competitive Application File Ordinal Position Competitive Complete File Ordinal Position Competitive Progress File Ordinal Position Competitive Post Completion File 6 Edit Checks Competitive: Must be > element 18; If element 20 not null then value not permitted Must be > element 18; Must be <= Current Date Grandfathered Phase In Y N N Y FinalDisbDte Date (mmddyyyy) Valid MM/DD/YYYY 29 39 Const Char (1) Y or N 30 30 40 Rehab Char (1) Y or N 31 31 38 Acqt Char (1) Y or N 32 32 16 MbrNonPermFin Char (1) Y or N 33 N 33 FHLBAdv Char (1) Y or N 34 Y 34 31 MbrMtgeLn Char (1) Y or N 35 N 35 ReducClsCst Char (1) Y or N 36 Y 36 OthMbrFinPrtp Char (1) Y or N 37 Y 37 70 FedGovtPrpty Char (1) Y or N 38 N 38 69 HudPrpty Char (1) Y or N 39 N 39 74 NonPrftSpon Char (1) Y or N 40 N 40 StateLclSpon Char (1) Y or N 41 Y 41 HousAuthSpon Char (1) Y or N 42 Y 42 23 HOMEIPProg Char (1) Y or N 43 N 43 22 CDBGProg Char (1) Y or N 44 N 44 FHAProg Char (1) Y or N 45 Y 45 17 LIHTC Char (1) Y or N 46 N 21 24 46 25 OthFedHousProg Char (1) Y or N 47 N 47 62 Disabled Char (1) Y or N 48 Y NDE 6 Must be Y if elements 30 and 31 are N Must be Y if elements 29 and 31 are N Must be Y if elements 29 and 30 are N Page 13 of 18 N N N DRM AHP CICA Chapter Appendix B Ordinal Position Competitive Complete File Ordinal Position Competitive Progress File Ordinal Position Competitive Post Completion File Column Name Column Attribute Format Rules Ordinal Position Competitive Application File Elderly Char (1) Y or N 49 Y NDE10 PhyAbuse Char (1) Y or N 51 Y NDE11 SubstnceAbuse Char (1) Y or N 52 Y NDE12 HIVAIDS Char (1) Y or N 53 Y Hmless Char (1) Y or N 50 N 50.1 PrpsdUnitLTE30AMI Integer 50.2 CmpltUnitLTE30AMI Integer 51 47 Rural Char (1) Y or N 54 N 52 TribalSponshp Char (1) Y or N 55 Y 53 AccDsgnUnit Char (1) Y or N 56 Y 54 61 SROHous Char (1) Y or N 57 N 55 LrgBdrm Char (1) Y or N 58 Y Previous Ordinal Position Notice Number 48 64 49 84 82 23 Page 14 of 18 Edit Checks Grandfathered Phase In Must be <= element 58 N Y Must be <= element 59 N Y DRM AHP CICA Chapter Appendix B Ordinal Position Competitive Complete File Ordinal Position Competitive Progress File Ordinal Position Competitive Post Completion File Column Name Column Attribute Format Rules Ordinal Position Competitive Application File 56 SrvEnrichHous Char (1) Y or N 59 Y 93 57 106 CommDev Char (1) Y or N 60 Y Previous Ordinal Position Notice Number Edit Checks If element 15 = Y then must be > 0; Must be <= element 58; If element 15 = N then report 0 Grandfathered 70 NumFTHBUnit Integer 63 StateSubsdy Char (1) Y or N 61 Y 64 LclGovtSubsdy Char (1) Y or N 62 Y 65 66 NonGovtDonatedFnd Char (1) Y or N 63 Y 49 58 17 PrpsdUnit Integer 59 24 CmpltUnit Integer 60 36 PrpsdDevCost Integer Whole $ 61 CmpltDevCost Integer Whole $ 21 81 7 Must be >= to prior submission's value AND <= element 58 8 N Phase In Y N Y N At application, this element must be >= element (22 + 24) 80 N N 22 Y N 62 58 67 59 PrpsdHOUnitLTE80AMI Integer 68 CmpltHOUnitLTE80AMI Integer If element 15 = Y then must be > 0; Must be <= element 58; If element 15 = N then report 0 If element 15 = Y then must be > 0; Must be <= element 58; If element 15 = N then report 0 76 16 Page 15 of 18 N N N DRM AHP CICA Chapter Appendix B Notice Number Previous Ordinal Position Column Name Column Attribute NDE17 58 PrpsdHOUnitLTE50AMI Integer 69 22 CmpltHOUnitLTE50AMI Integer 71 HmOwnIntRteWrteDwn Char (1) Format Rules Ordinal Position Competitive Application File Ordinal Position Competitive Complete File Ordinal Position Competitive Progress File Ordinal Position Competitive Post Completion File 75 15 Y or N Edit Checks If element 15 = Y then must be > 0; Must be <= element 67 and <= element 58; If element 15 = N then report 0 If element 15 = Y then must be > 0; Must be <= element 68 and <= element 59; If element 15 = N then report 0 72 HmOwnDwnPymt Char (1) Y or N 64 73 HmOwnClsCst Char (1) Y or N 65 74 45 75 HmOwnCounslCst Char (1) Y or N 66 78 If element 16 = Y then must be > 0; Must be <= element 58; If element 16 = N then report 0 NDE18 PrpsdRHUnitLTE80AMI Integer CmpltRHUnitLTE80AMI Integer 83 54 PrpsdRHUnitLTE50AMI Integer 84 23 CmpltRHUnitLTE50AMI Integer NDE19 17 If element 16 = Y then must be > 0; Must be <= element 59; If element 16 = N then report 0 If element 16 = Y then must be > 0; Must be <= element 58; Must be <= NDE18 If element 16 = N then report 0 If element 16 = Y then must be > 0; Must be <= element 59; Must be <= NDE19 If element 16 = N then report 0 19 If element 16 = Y then must be > 0; Must be <= element 59; If element 16 = N then report 0 18 77 Phase In N Y if element 15 = Y then this element can = Y 67 if element 15 = Y then this element can = Y if element 15 = Y then this element can = Y if element 15 = Y then this element can = Y 54 55 56 Grandfathered N Y Y Y N N N Y N Y N N Y 85 86 87 CmpltRHUnitGT80AMI PrpsdRHNonAHPSubsdy NDE20 88 89 90 CmpltRHNonAHPSubsdy Integer Integer Integer Whole $ If element 16 = Y then must be > 0; Must be <= (60 - (22 + 24)); If element 16 = N then report 0 79 If element 16 = Y then must be > 0; Must be <= (61 - (22 + 24)); If element 16 = N then report 0 20 Page 16 of 18 Y N Y DRM AHP CICA Chapter Appendix B Ordinal Position Competitive Complete File Ordinal Position Competitive Progress File Ordinal Position Competitive Post Completion File Column Name Column Attribute Format Rules Ordinal Position Competitive Application File 76 RntlHousPermLn Char (1) Y or N 68 77 33 RntlHousBrdgeLn Char (1) Y or N 69 Edit Checks if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y Previous Ordinal Position Notice Number 78 32 RntlHousConstLn Char (1) Y or N 70 79 RntlHousDwnPymt Char (1) Y or N 71 80 RntlHousSecndMtge Char (1) Y or N 72 81 RntlHousClsCst Char (1) Y or N 73 if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y 82 41 RntlHousRefin Char (1) Y or N 74 if element 16 = Y then this element can = Y 140 22 15 DirectSubsdyAward Integer Whole $ 83 138 24 13 Integer Whole $ AdvSubsdyAward Integer Whole $ 25 14 CumAdvSubsdyDisb Integer Whole $ 133 26 11 AmtSubsdzAdv Integer Whole $ 27 CumDeObFunds Integer Whole $ 84 85 Phase In N N N Y Y Y N 16 Must be <= element 60 (at application only) Y N 17 Competitive: If element 22 > 0 then this element must be <= element 22 Y N 18 Must be <= element 60 (at application only) Y N 19 If element 24 > 0 then this element must be <= element 24 Y N Y N N Y CumDirectSubsdyDisb (Competitive) SubsdyDisb (SetAside) 23 16 Grandfathered 20 21 6 Page 17 of 18 Must be > element 24 Must be >= last progress reported for this element; If element 15 (owner occupied) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 5 years; If element 16 (rental) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 15 years DRM AHP CICA Chapter Appendix B Previous Ordinal Position Column Name Column Attribute CumReCapFunds Integer Whole $ NDE13 ModNumUnit ModTrgtng ModAmtSubsdy ModSvcAct ModOth Char (1) Char (1) Char (1) Char (1) Char (1) NDE16 CumModSubsdyAmt Integer Negatives allowed NDE14 NumProjExt Notice Number 28 Format Rules Y or N Y or N Y or N Y or N Y or N Ordinal Position Competitive Application File Ordinal Position Competitive Complete File Ordinal Position Competitive Progress File Ordinal Position Competitive Post Completion File 22 5 Edit Checks Competitive: Must be >= last progress reported for this element; If element 15 (owner occupied) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 5 years; If element 16 (rental) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 15 years Set Aside: Leave this element open for updating for a time period = 15 years If ModNumUn = Y then element 58 must change from prior submission. If ModAmtSub = Y then elements 22 or 24 must change from prior submission 9 10 11 12 13 15 Must be >= to the number reported for this element in the last progress submission 14 Page 18 of 18 Grandfathered Phase In N Y N Y N Y N Y Data Reporting Manual AHP/CICA Chapter APPENDIX C. SET-ASIDE MAPPING Appendix C of this document provides a complete mapping of Household Level SetAside Information. This master list cross references the following information: Status represents the element’s status in the new database as it relates to previous actual or proposed reporting (i.e. converted, added, deleted, etc) Notice Number represents the Federal Register Proposed Data Element List Number Notice Name represents the Federal Register Proposed Data Element List Name Final Name represents the final data collection name Definition represents the final element definition and includes examples as needed Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Ordinal Position Set-Aside TYPE File represents the new AHP/CICA submission file position number where TYPE is the type of submission file (Disbursement and Post Completion/Recapture/Retention) Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Page 14 of 25 DRM AHP CICA Chapter Appendix C Status Notice Number Notice Name 1 Federal Home Loan Bank Number Final Name Definition Column Name FHLB Number/District FHLBank District Number DistrictID The reporting period end date is defined as the last day in the reporting period. If the reporting period is 1/1 - 6/30, then the reporting end date is 6/30/YYYY. If the reporting period is 7/1 - 12/31, then the reporting end date is 12/31/YYYY. (competitive) If the reporting period is 1/1 - 12/31, then the reporting end date is RptBegDte 12/31/YYYY.( set-aside) RptEndDte Report the FHFB assigned Member number. FHFBID Column Attribute Char (2) Zerofilled Competitive - End Date of this reporting period (calendar year; dd/mm/year) 2 Set-Aside - Beginning and end date of reporting period (dd/mm/year) Reporting Period Beg Date Reporting Period End Date 6 Member's FHFB ID number Member FHFB ID 3 AHP project ID number Report the FHLBank's Competitive program's application identifier. The program's application identifier (e.g., project number or application number) is the identifier assigned to each competitive application received by the FHLBank. (Competitive) Report the FHLBank's program household identifier. The program identifier is the identifier assigned to Competitive Program Application Identifier (Competitive) each household application approved for FHLBProjID (Competitive) Char (15) Set-Aside Program Household Identifier (Set-Aside) a FHLBank set-aside grant. (Set-Aside) FHLBHoushldID (SetAside) Char (15) Competitive - Project Census Tract 8.9 Set-Aside - 12 Single-Family (1-4 units) Competitive - Date of AHP commitment (by FHLBank) to applicant 5 Set-Aside - Date of AHP fund commitment to applicant Competitive - Project start date (date of first disbursement) 18 Set-Aside - Project Census Tract (Competitive) Household Census Tract (Set-Aside) Single Family Enrollment Date Project Approval Date (Competitive) Date of Disbursement (Set-Aside) Page 1 of 4 For non-scattered sites projects, report the project's census tract location as listed on the application using the above address (data element 8.2). For scattered site units, at project completion, report the census tract location of the last completed AHP assisted unit.(Competitive) Report the census tract location of the property being purchased by the household using the address as reported on the Housing and Urban Development (HUD) - 1 Settlement Statement or ProjTract equivalent document. (Set-aside) HoushldTract Is the project a single-family structure with one to four dwelling units. (competitive) Is the set-aside grant for household occupancy in a single-family structure. See definition of single-family structure in the glossary. (set-aside) Enter the date on which the FHLBank or member has enrolled the household into the set-aside program. Report the project's approval date. The project's approval date is the date when the FHLBank's Board of Directors has approved the competitive program application for an award. For alternates, the project's approval date is the date when the project has gone from an alternate project to an awarded project. (Competitive) Report the date of the set-aside grant disbursement to the household. The date of the disbursement is the closing date shown on the homeowner's Housing and Urban Development (HUD) - 1 Settlement Statement or equivalent document. (Set-Aside) MM/DD/YYYY MM/DD/YYYY Integer Char (7) SingleFmly Char (1) EnrollDte Date (MM/DD/YYYY ProjApprDte (Competitive) DisbDte (Set-Aside) Date (mm/dd/yyyy) DRM AHP CICA Chapter Appendix C Status Added Notice Number Notice Name Final Name Competitive - Dollar amount of AHP Direct Subsidy Disbursed 23 Set-Aside - Cumulative Dollar Amount of Direct Subsidy Disbursed (Competitive) Dollar Amount of Set-aside Subsidy Disbursed (SetAside) 91 Set-Aside - Dollar amount of first mortgage Dollar Amount of First Mortgage Loan 93 Set-Aside - Interest rate (APR) on first mortgage First Mortgage Loan Annual Percentage Rate (APR) Term of First Mortgage Loan NDE26 92 Set-Aside - Dollar amount of second mortgage Dollar Amount of Second Mortgage Loan (if applicable) 94 Set-Aside - Interest rate (APR) on second mortgage Second Mortgage Loan Annual Percentage Rate (if applicable) 95 HOEPA covered loan HOEPA Covered Loan 96 Set-Aside - Homeowner Closing Costs Household's Closing Costs Definition Report the cumulative dollar amount of direct subsidy funds disbursed, without netting out recaptures or repayments, to the project since its approval date. (Competitive) Report the dollar amount of the set-aside grant disbursed to the household. (SetAside) Report the dollar amount of the household's first mortgage loan. Obtain the dollar amount of the first mortgage loan from the Housing and Urban Development (HUD) - 1 Settlement Statement or equivalent document. Report the annual percentage interest rate (APR) that the household is paying on the first mortgage loan (data element 91). Report the term of the household's first mortgage loan (data element 91) in months. If applicable, report the dollar amount, excluding forgivable loans, of the household's second mortgage loan. Obtain the dollar amount of the second mortgage loan from the Housing and Urban Development (HUD) - 1 Settlement Statement or equivalent document. If applicable, report the annual percentage interest rate (APR) that the household is paying on the second mortgage loan (data element 92). Column Name CumDirectSubsdyDisb (Competitive) SubsdyDisb (SetAside) Integer Whole $ AmtFirstMtge Integer Whole $ FirstMtgeAPR Decimal (3.4) FirstMtgeTerm Integer AmtSecndMtge Integer Whole $ SecndMtgeAPR Decimal (3.4) Is the household's mortgage loan subject to HOEPA. See the definition of HOEPA covered loan in the glossary. HOEPALn Report the dollar amount of the household's closing costs as they appear on the Housing and Urban Development (HUD) - 1 Settlement Statement or equivalent document. HoushldClsCst Added NDE21 Added NDE22 Downpayment, closing cost assistance (subsidy is used Is the set-aside grant used for for) downpayment, or closing cost assistance. DwnPymtClsCst Is the set-aside grant used for Rehabilitation rehabilitation. Rehab Added NDE23 First-Time Homebuyer Added NDE24 Household's Income Is the household a first-time homebuyer as defined by the FHLBank. Report the dollar amount of the household's income that was used to qualify the household for the set-aside program. Household's Income as a Percentage of A.M.I. Report the household's income as a percentage of A.M.I. Added NDE25 Competitive - Dollar amount of project funds re-captured (if applicable) 28 Set-Aside - Char (1) Integer Whole $ Char (1) Char (1) FTHB Char (1) HoushldIncm Integer Whole $ HoushldIncmToAMI Decimal (3.4) Report the cumulative dollar amount of funds recaptured and repaid from the project since its approval date. (Competitive) Cumulative Dollar Amount of Project Funds Recaptured Report the dollar amount of set-aside or Repaid (Competitive) funds re-paid by the household to the Dollar Amount of Set-aside Funds Re-paid (Set-Aside) - FHLBank due to refinancing or sale. (SetRetention aside) CumReCapFunds Page 2 of 4 Column Attribute Integer Whole $ DRM AHP CICA Chapter Appendix C Notice Number Ordinal Position Set Aside Disburse File Ordinal Position Set Aside Post Completion File Edit Checks 5 3 Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date 2 Beg date must not be > Currrent date 1 2 1 2 6 6 Valid FHFB ID in Membership Database 3 Competitive - for application data, ID must be unique for progress or post completion/retention data and must have a parent in application data Competitive - Must match previous submissions' ID Set Aside - for disbursement data, ID must be unique for post completion/retention data and must have a parent in disbursement data Set Aside - Must match previous submissions' ID Format Rules Valid formats are 01 - 12 1 Match district to loginID and content As with Legacy system, suggested format is YYYYR########## Where YYYY = Year R = Round Letter 3 ########## = project identifier 4 Zerofilled 8.9 Tract Numbers are ####.## (include ".") 7 Valid Census Tract; Competitve: If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion 12 Y or N If elements 13 and 14 are N, this element must be Y (at least one of elements 12, 13, or 14 must be Y) 8 5 Valid MM/DD/YYYY 4 Valid MM/DD/YYYY 18 Valid MM/DD/YYYY 9 Competitive: YYYY of this element must = YYYY of element 4 Page 3 of 4 DRM AHP CICA Chapter Appendix C Format Rules Notice Number Ordinal Position Set Aside Disburse File 23 10 91 11 Ordinal Position Set Aside Post Completion File Edit Checks Competitive: If element 22 > 0 then this element must be <= element 22 valid 3.4 decimal 93 9.75 % is reported as 9.7500 Not .0975 13 NDE26 If element 91 > 0 then this element must be > 0 22 12 92 valid 3.4 decimal 94 9.75 % is reported as 9.7500 Not .0975 14 95 Y or N 15 96 16 NDE21 Y or N 17 NDE22 Y or N 18 NDE23 Y or N 19 NDE24 If element 92 > 0 then this element must be > 0 If NDE22 = N then this element must = Y If NDE21 = N then this element must = Y 20 valid 3.4 decimal 89.75 % is reported as 89.7500 Not .8975 NDE25 28 21 5 Competitive: Must be >= last progress reported for this element; If element 15 (owner occupied) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 5 years; If element 16 (rental) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 15 years Set Aside: Leave this element open for updating for a time period = 15 years Page 4 of 4 Data Reporting Manual AHP/CICA Chapter APPENDIX D. COMPETITIVE APPLICATION/PROJECT FILE SUBMISSION This master list cross references the following information: Ordinal Position Competitive Application File represents the new AHP/CICA submission file position number Notice Number represents the Federal Register Proposed Data Element List Number Final Name represents the final data collection name Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Grandfathered represents whether the new AHP/CICA element is not required for ongoing projects approved by the board in calendar years 2005 and prior (i.e. Y or N) Phase In represents whether the new AHP/CICA element’s reporting can be deferred until June 30, 2007 for projects approved by the board in calendar year 2006. Phase In elements can be reported initially but will not be required to be reported until the phase in period ends on June 30, 2007 (i.e. Y or N). Page 15 of 25 DRM AHP CICA Chapter Appendix D Ordinal Position Competitive Application File Notice Number 1 2 3 4 NDE 5 Final Name Column Name Column Attribute Reporting Period Beg Date 2 Reporting Period End Date 4 Year of Round Round Letter (Competitive) RptBegDte RptEndDte RndYr RndLetter 1 FHLB Number/District DistrictID MM/DD/YYYY MM/DD/YYYY Integer (YYYY) Char (1) Char (2) Zerofilled Competitive Program Application Identifier (Competitive) FHLBProjID (Competitive) Char (15) FHLBHoushldID (SetAside) Char (15) 3 Set-Aside Program Household Identifier (Set-Aside) 6 7 8 9 10 11 12 6 7.1 7.2 7.3 7.4 7.5 13 14 15 NDE27 Member FHFB ID Sponsor Name Sponsor Address 1 Sponsor Address 2 Sponsor City Sponsor State 7.6 Sponsor Zip Code (+4) 8.1 Project Name Scattered Site Project 8.2 Project Address 1 8.3 Project Address 2 (Competitive) 16 17 FHFBID SponName SponAddr1 SponAddr2 SponCity SponState SponZip ProjName ScttrdSte ProjAddr1 ProjAddr2 As with Legacy system, suggested format is YYYYR########## Where YYYY = Year R = Round Letter ########## = project identifier Integer Char (100) Char (100) Char (100) Char (100) Char (2) Char (10) Char (100) Char (1) 8.4 Project City ProjCity Char (100) 19 8.5 Project State ProjState Char (2) 8.6 Project County ProjCntyCde Char (3) Edit Checks Competitive - for application data, ID must be unique for progress or post completion/retention data and must have a parent in application data Competitive - Must match previous submissions' ID Set Aside - for disbursement data, ID must be unique for post completion/retention data and must have a parent in disbursement data Set Aside - Must match previous submissions' ID Valid FHFB ID in Membership Database Grandfathered Phase In Y Y N N N N Y N Y N Y Valid City in the State Valid State Code/Abbreviation Minimum 5 char Zerofilled Include "-" Valid City, State, Zip Code Combination If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion Zerofilled Page 1 of 4 Valid City in the State; If NDE27 is N, element is required; If NDE27 is Y, element must = Sponsor City (element 7.4) at application AND then required at completion Valid State; If NDE27 is N, element is required; If NDE27 is Y, element must = Sponsor State (element 7.5) at application AND then required at completion Valid County Code; Valid County in the State; If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion N N N N N N N N N Y or N Char (100) Char (100) 18 20 Format Rules Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date Beg date must not be > Currrent date Valid YYYY A-D Valid formats are 01 - 12 Match district to loginID and content N N N N Y N Y N N N DRM AHP CICA Chapter Appendix D Ordinal Position Competitive Application File Notice Number Final Name Column Name Column Attribute 21 8.7 Project MSA ProjMSA Char (5) 22 8.8 Project Zip Code ProjZip Char (10) 23 Project Census Tract (Competitive) 8.9 Household Census Tract (Set-Aside) ProjTract HoushldTract Char (7) Format Rules Edit Checks Valid MSA; Valid MSA given the zip code; If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then Zerofilled required at completion Vaild City, State, Zip Code Combination; If NDE27 is N, element is required; Minimum 5 char If NDE27 is Y, element must be Zerofilled null at application AND then Include "-" required at completion Valid Census Tract; Competitve: If NDE27 is N, element is required; If NDE27 is Y, element must be Zerofilled null at application AND then Tract Numbers are ####.## (include ".") required at completion 24 12 Single Family SingleFmly Char (1) Y or N 25 13 Multi Family MultiFmly Char (1) Y or N If elements 13 and 14 are N, this element must be Y (at least one of elements 12, 13, or 14 must be Y) If elements 12 and 14 are N, this element must be Y (at least one of 12, 13, or 14 must be Y) If elements 12 and 13 are N, this element must be Y (at least one of elements 12, 13, or 14 must be Y) If Y then element 67 or NDE17 > 0; If element 16 is N, this element must be Y (at least 15 or 16 must be Y) If Y then element 83 or NDE18 > 0; If element 15 is N, this element must be Y (at least 15 or 16 must be Y) Competitive: YYYY of this element must = YYYY of element 4 Must be Y if elements 30 and 31 are N Must be Y if elements 29 and 31 are N Must be Y if elements 29 and 30 are N Grandfathered Phase In N N N N N Y N N 26 14 Mixed Use MixedUse Char (1) Y or N 27 15 Owner Occupied Owner Char (1) Y or N 28 16 Rental Rental Char (1) Y or N 29 Project Approval Date (Competitive) 18 Date of Disbursement (Set-Aside) ProjApprDte (Competitive) DisbDte (Set-Aside) Valid MM/DD/YYYY Date (mm/dd/yyyy) Valid MM/DD/YYYY 30 29 Construction Const Char (1) Y or N 31 30 Rehabilitation Rehab Char (1) Y or N 32 33 34 35 36 37 38 31 32 33 34 35 36 37 Acqt MbrNonPermFin FHLBAdv MbrMtgeLn ReducClsCst OthMbrFinPrtp FedGovtPrpty Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Y or N Y or N Y or N Y or N Y or N Y or N Y or N 39 40 41 42 43 38 39 40 41 42 HudPrpty NonPrftSpon StateLclSpon HousAuthSpon HOMEIPProg Char (1) Char (1) Char (1) Char (1) Char (1) Y or N Y or N Y or N Y or N Y or N N N Y Y N 44 45 46 47 43 44 45 46 CDBGProg FHAProg LIHTC OthFedHousProg Char (1) Char (1) Char (1) Char (1) Y or N Y or N Y or N Y or N N Y N N Acquisition Member Non-Permanent Financing FHLBank Advance Member Mortgage Loan Reduced Closing Costs Other Member Financial Participation Federal Government Property Housing and Urban Development (HUD) Owned Property Non-Profit 501 (c)(3) Sponsor State or Local Agency Sponsor Housing Authority Sponsor Home Investment Partnership (HOME) Program Community Development Block Grants (CDBG) Program Federal Housing Administration (FHA) Low-Income Housing Tax Credits (LIHTCs) Other Federal Housing Programs Page 2 of 4 N N N N N N N N Y N Y Y N DRM AHP CICA Chapter Appendix D Ordinal Position Competitive Application File 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 Notice Number NDE10 NDE11 NDE12 Final Name 47 Disabled Persons 48 Elderly Persons 49 Homeless Persons Persons Recovering from Physical Abuse (Y/N) Persons Recovering from Substance Abuse (Y/N) Persons with HIV/AIDS 51 Rural 52 Tribal Sponsorship 53 Accessible Design of Units 54 Single Room Occupancy (SRO) Housing 55 Large Units: 3 Bedrooms or more 56 Service-Enriched Housing 57 Community Development 63 State Subsidy 64 Local Government Subsidy 65 Non-Governmental Donated Funds Column Name Disabled Elderly Hmless PhyAbuse SubstnceAbuse HIVAIDS Rural TribalSponshp AccDsgnUnit SROHous LrgBdrm SrvEnrichHous CommDev StateSubsdy LclGovtSubsdy NonGovtDonatedFnd Column Attribute Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Char (1) Format Rules Y or N Y or N Y or N Y or N Y or N Y or N Y or N Y or N Y or N Y or N Y or N Y or N Y or N Y or N Y or N Y or N 64 72 Principal Reduction on Home Mortgage (Down Payment) HmOwnDwnPymt Char (1) Y or N 65 73 Homeowners' Closing Costs HmOwnClsCst Char (1) Y or N 66 74 Homebuyers' Counseling Costs HmOwnCounslCst Char (1) Y or N 67 71 Interest Rate Writedown on Home Mortgage HmOwnIntRteWrteDwn Char (1) Y or N 68 76 Permanent Loan RntlHousPermLn Char (1) Y or N 69 77 Bridge Loan RntlHousBrdgeLn Char (1) Y or N 70 78 Construction Loan RntlHousConstLn Char (1) Y or N 71 79 Principal Reduction on Mortgage RntlHousDwnPymt Char (1) Y or N 72 80 Second Mortgage RntlHousSecndMtge Char (1) Y or N 73 81 Closing Costs RntlHousClsCst Char (1) Y or N 74 82 Refinance RntlHousRefin Char (1) Y or N Proposed Number of Units Reserved for Occupancy by Homeownership Households At or Below 50% of A.M.I. as Proposed in the Application PrpsdHOUnitLTE50AMI Integer 76 Proposed Number of Units Reserved for Occupancy by Homeownership Households At or Below 80% of A.M.I. 67 as Proposed in the Application. PrpsdHOUnitLTE80AMI Integer 77 Proposed Number of Rental Units Reserved for Households At or Below 50% of A.M.I. as Proposed in 83 the Application PrpsdRHUnitLTE50AMI Integer Proposed Number of Rental Units Reserved for Occupancy by Households At or Below 80% of A.M.I. as Proposed in the Application PrpsdRHUnitLTE80AMI Integer 75 NDE17 78 NDE18 79 NDE20 80 81 Dollar Amount of Non-AHP Subsidies as Proposed in the Application (Rental) PrpsdRHNonAHPSubsdy Total Estimated Costs of Project as Proposed in PrpsdDevCost 60 Application PrpsdUnit 58 Proposed Units Integer Whole $ Integer 82 22 Dollar Amount of Direct Subsidy Awarded DirectSubsdyAward Integer Whole $ 83 84 24 Dollar Amount of Advance Subsidy Awarded 26 Dollar Amount of Subsidized Advance AdvSubsdyAward AmtSubsdzAdv Integer Whole $ Integer Whole $ Integer Edit Checks if element 15 = Y then this element can = Y if element 15 = Y then this element can = Y if element 15 = Y then this element can = Y if element 15 = Y then this element can = Y if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y if element 16 = Y then this element can = Y If element 15 = Y then must be > 0; Must be <= element 67 and <= element 58; If element 15 = N then report 0 If element 15 = Y then must be > 0; Must be <= element 58; If element 15 = N then report 0 If element 16 = Y then must be > 0; Must be <= element 58; Must be <= NDE18 If element 16 = N then report 0 If element 16 = Y then must be > 0; Must be <= element 58; If element 16 = N then report 0 If element 16 = Y then must be > 0; Must be <= (60 - (22 + 24)); If element 16 = N then report 0 At application, this element must be >= element (22 + 24) Must be <= element 60 (at application only) Must be <= element 60 (at application only) Must be > element 24 Page 3 of 4 Grandfathered Phase In Y Y N Y Y Y N Y Y N Y Y Y Y Y Y Y Y N Y N N N Y Y Y N N N N N Y Y N N Y N Y Y N N DRM AHP CICA Chapter Appendix D Ordinal Position Competitive Application File Notice Number Column Name Column Attribute 85 CmpltUnitLTE30AMI Integer Final Name Number of Units Reserved for Households at or below 50.2 30% of A.M.I. at application Format Rules Edit Checks Must be <= element 59 Page 4 of 4 Grandfathered Phase In N Y Data Reporting Manual AHP/CICA Chapter APPENDIX E. COMPETITIVE PROGRESS/DELTA FILE SUBMISSION This master list cross references the following information: Ordinal Position Competitive Progress File represents the new AHP/CICA submission file position number Notice Number represents the Federal Register Proposed Data Element List Number Final Name represents the final data collection name Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Grandfathered represents whether the new AHP/CICA element is not required for ongoing projects approved by the board in calendar years 2005 and prior (i.e. Y or N) Phase In represents whether the new AHP/CICA element’s reporting can be deferred until June 30, 2007 for projects approved by the board in calendar year 2006. Phase In elements can be reported initially but will not be required to be reported until the phase in period ends on June 30, 2007 (i.e. Y or N). Page 16 of 25 DRM AHP CICA Chapter Appendix E Ordinal Position Competitive Progress File Notice Number Final Name Column Name Column Attribute MM/DD/YYYY MM/DD/YYYY Char (2) Zerofilled 1 2 Reporting Period Beg Date 2 Reporting Period End Date RptBegDte RptEndDte 3 1 FHLB Number/District DistrictID Competitive Program Application Identifier (Competitive) FHLBProjID (Competitive) Char (15) FHLBHoushldID (SetAside) Char (15) 3 Set-Aside Program Household Identifier (Set-Aside) SponName Char (100) 7.1 Sponsor Name 4 5 6 7 NDE 8 Final Disbursement Date 58 Proposed Units 59 Completed Units If the project has been modified, indicate how it has been modified: Note - Can enter more than one (1) Number of Units (2) Targeting (3) Amount of Subsidy (4) Services & Activites (5) Other FinalDisbDte PrpsdUnit Date (mmddyyyy) Integer CmpltUnit Integer ModNumUnit ModTrgtng ModAmtSubsdy ModSvcAct ModOth Char (1) Char (1) Char (1) Char (1) Char (1) 9 10 11 12 13 NDE13 14 NDE14 Number of Cumulative Extensions NumProjExt 15 NDE16 Cumulative Dollar Amount of Subsidy Modification CumModSubsdyAmt Integer Negatives allowed Integer Whole $ 16 22 Dollar Amount of Direct Subsidy Awarded DirectSubsdyAward CumDirectSubsdyDisb (Competitive) SubsdyDisb (SetAside) 17 Cumulative Dollar Amount of Direct Subsidy Disbursed (Competitive) Dollar Amount of Set-aside Subsidy Disbursed (Set23 Aside) 18 24 Dollar Amount of Advance Subsidy Awarded AdvSubsdyAward Integer Whole $ 19 20 Cumulative Dollar Amount of Advance Subsidy 25 Disbursed 26 Dollar Amount of Subsidized Advance CumAdvSubsdyDisb AmtSubsdzAdv Integer Whole $ Integer Whole $ 21 Cumulative Dollar Amount of Project Funds De27 Obligated CumDeObFunds Integer Whole $ Format Rules Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date Beg date must not be > Currrent date Valid formats are 01 - 12 Match district to loginID and content Edit Checks As with Legacy system, suggested format is YYYYR########## Where YYYY = Year R = Round Letter ########## = project identifier Competitive - for application data, ID must be unique for progress or post completion/retention data and must have a parent in application data Competitive - Must match previous submissions' ID Set Aside - for disbursement data, ID must be unique for post completion/retention data and must have a parent in disbursement data Set Aside - Must match previous submissions' ID Valid MM/DD/YYYY Must be > element 18; Must be <= Current Date Must be >= to prior submission's value AND <= element 58 Y or N Y or N Y or N Y or N Y or N If ModNumUn = Y then element 58 must change from prior submission. If ModAmtSub = Y then elements 22 or 24 must change from prior submission Must be >= to the number reported for this element in the last progress submission Must be <= element 60 (at application only) Competitive: If element 22 > 0 then this element must be <= element 22 Must be <= element 60 (at application only) If element 24 > 0 then this element must be <= element 24 Must be > element 24 Must be >= last progress reported for this element; If element 15 (owner occupied) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 5 years; If element 16 (rental) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 15 years Integer Whole $ Page 1 of 2 Grandfathered Phase In Y Y N N Y N Y Y N N N Y Y N Y N N Y N Y N Y Y N Y N Y N Y Y N N N Y DRM AHP CICA Chapter Appendix E Ordinal Position Competitive Progress File Notice Number 22 Final Name Column Name Cumulative Dollar Amount of Project Funds Recaptured or Repaid (Competitive) Dollar Amount of Set-aside Funds Re-paid (Set-Aside) CumReCapFunds 28 Retention Column Attribute Format Rules Integer Whole $ Page 2 of 2 Edit Checks Competitive: Must be >= last progress reported for this element; If element 15 (owner occupied) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 5 years; If element 16 (rental) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 15 years Set Aside: Leave this element open for updating for a time period = 15 years Grandfathered Phase In N Y Data Reporting Manual AHP/CICA Chapter APPENDIX F. COMPETITIVE COMPLETION/WITHDRAWAL FILE SUBMISSION This master list cross references the following information: Ordinal Position Competitive Complete File represents the new AHP/CICA submission file position number Notice Number represents the Federal Register Proposed Data Element List Number Final Name represents the final data collection name Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Grandfathered represents whether the new AHP/CICA element is not required for ongoing projects approved by the board in calendar years 2005 and prior (i.e. Y or N) Phase In represents whether the new AHP/CICA element’s reporting can be deferred until June 30, 2007 for projects approved by the board in calendar year 2006. Phase In elements can be reported initially but will not be required to be reported until the phase in period ends on June 30, 2007 (i.e. Y or N). Page 17 of 25 DRM AHP CICA Chapter Appendix F Ordinal Position Competitive Complete File Notice Number Final Name Column Name Column Attribute MM/DD/YYYY MM/DD/YYYY Char (2) Zerofilled 1 2 Reporting Period Beg Date 2 Reporting Period End Date RptBegDte RptEndDte 3 1 FHLB Number/District DistrictID Competitive Program Application Identifier (Competitive) FHLBProjID (Competitive) Char (15) FHLBHoushldID (SetAside) Char (15) 3 Set-Aside Program Household Identifier (Set-Aside) 4 Format Rules Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date Beg date must not be > Currrent date Valid formats are 01 - 12 Match district to loginID and content As with Legacy system, suggested format is YYYYR########## Where YYYY = Year R = Round Letter ########## = project identifier 5 20 Completion Date CmpltDte Date (mm/dd/yyyy) Valid MM/DD/YYYY 6 21 Withdrawal Date WthdrwDte Date (mm/dd/yyyy) Valid MM/DD/YYYY 7 8 8.2 Project Address 1 8.3 Project Address 2 (Competitive) ProjAddr1 ProjAddr2 Char (100) Char (100) 9 8.4 Project City ProjCity Char (100) 10 8.5 Project State ProjState Char (2) 8.6 Project County ProjCntyCde Char (3) Zerofilled 8.7 Project MSA ProjMSA Char (5) Zerofilled 11 12 Page 1 of 2 Edit Checks Competitive - for application data, ID must be unique for progress or post completion/retention data and must have a parent in application data Competitive - Must match previous submissions' ID Set Aside - for disbursement data, ID must be unique for post completion/retention data and must have a parent in disbursement data Set Aside - Must match previous submissions' ID Competitive: Must be > element 18; If element 21 not null then value not permitted Competitive: Must be > element 18; If element 20 not null then value not permitted If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion Valid City in the State; If NDE27 is N, element is required; If NDE27 is Y, element must = Sponsor City (element 7.4) at application AND then required at completion Valid State; If NDE27 is N, element is required; If NDE27 is Y, element must = Sponsor State (element 7.5) at application AND then required at completion Valid County Code; Valid County in the State; If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion Valid MSA; Valid MSA given the zip code; If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then required at completion Grandfathered Phase In Y Y N N Y N Y N Y N Y N N N N N Y N Y N N N N N DRM AHP CICA Chapter Appendix F Ordinal Position Competitive Complete File Notice Number Final Name Column Name Column Attribute 13 8.8 Project Zip Code ProjZip Char (10) 14 Project Census Tract (Competitive) 8.9 Household Census Tract (Set-Aside) ProjTract HoushldTract Char (7) 15 Number of Units Reserved for Occupancy by Households At or Below 50% of A.M.I. at Project 69 Completion CmpltHOUnitLTE50AMI Integer 16 Number of Units Reserved for Occupancy by Homeownership Households At or Below 80% of A.M.I. 68 at Project Completion CmpltHOUnitLTE80AMI Integer 17 Number of Rental Units Reserved for Households At or 84 Below 50% of A.M.I. at Project Completion CmpltRHUnitLTE50AMI Integer 18 Number of Rental Units Reserved for Occupancy by Households At or Below 80% of A.M.I. at Project Completion CmpltRHUnitLTE80AMI Integer NDE19 19 Number of Rental Units Reserved for Households Above CmpltRHUnitGT80AMI 87 80% of A.M.I. at Project Completion Integer 20 Dollar Amount of Non-AHP Subsidies at Project 88 Completion CmpltRHNonAHPSubsdy Integer Whole $ NumFTHBUnit CmpltDevCost Integer Integer Whole $ CmpltUnitLTE30AMI Integer 21 22 23 70 First-Time Homebuyer Units 61 Total Actual Costs of Project at Completion Number of Units Reserved for Households at or below 50.2 30% of A.M.I. at completion Format Rules Edit Checks Vaild City, State, Zip Code Combination; If NDE27 is N, element is required; Minimum 5 char If NDE27 is Y, element must be Zerofilled null at application AND then Include "-" required at completion Valid Census Tract; Competitve: If NDE27 is N, element is required; If NDE27 is Y, element must be Zerofilled null at application AND then Tract Numbers are ####.## (include ".") required at completion If element 15 = Y then must be > 0; Must be <= element 68 and <= element 59; If element 15 = N then report 0 If element 15 = Y then must be > 0; Must be <= element 58; If element 15 = N then report 0 If element 16 = Y then must be > 0; Must be <= element 59; Must be <= NDE19 If element 16 = N then report 0 If element 16 = Y then must be > 0; Must be <= element 59; If element 16 = N then report 0 If element 16 = Y then must be > 0; Must be <= element 59; If element 16 = N then report 0 If element 16 = Y then must be > 0; Must be <= (61 - (22 + 24)); If element 16 = N then report 0 If element 15 = Y then must be > 0; Must be <= element 58; If element 15 = N then report 0 Must be <= element 59 Page 2 of 2 Grandfathered Phase In N N N Y Y N N N Y N N Y N Y N Y N N Y N N Y Data Reporting Manual AHP/CICA Chapter APPENDIX G. COMPETITIVE RECAPTURE/RETENTION/POST COMPLETION FILE SUBMISSION This master list cross references the following information: Ordinal Position Competitive Post Completion File represents the new AHP/CICA submission file position number Notice Number represents the Federal Register Proposed Data Element List Number Final Name represents the final data collection name Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Grandfathered represents whether the new AHP/CICA element is not required for ongoing projects approved by the board in calendar years 2005 and prior (i.e. Y or N) Phase In represents whether the new AHP/CICA element’s reporting can be deferred until June 30, 2007 for projects approved by the board in calendar year 2006. Phase In elements can be reported initially but will not be required to be reported until the phase in period ends on June 30, 2007 (i.e. Y or N). Page 18 of 25 DRM AHP CICA Chapter Appendix G Ordinal Position Competitive Post Completion File Notice Number Final Name Column Name Column Attribute MM/DD/YYYY MM/DD/YYYY Char (2) Zerofilled 1 2 Reporting Period Beg Date 2 Reporting Period End Date RptBegDte RptEndDte 3 1 FHLB Number/District DistrictID 4 Competitive Program Application Identifier (Competitive) FHLBProjID (Competitive) Char (15) FHLBHoushldID (SetAside) Char (15) 3 Set-Aside Program Household Identifier (Set-Aside) 5 Cumulative Dollar Amount of Project Funds Recaptured or Repaid (Competitive) Dollar Amount of Set-aside Funds Re-paid (Set-Aside) CumReCapFunds 28 Retention Integer Whole $ 6 Cumulative Dollar Amount of Project Funds De27 Obligated Integer Whole $ CumDeObFunds Format Rules Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date Beg date must not be > Currrent date Valid formats are 01 - 12 Match district to loginID and content As with Legacy system, suggested format is YYYYR########## Where YYYY = Year R = Round Letter ########## = project identifier Page 1 of 1 Edit Checks Competitive - for application data, ID must be unique for progress or post completion/retention data and must have a parent in application data Competitive - Must match previous submissions' ID Set Aside - for disbursement data, ID must be unique for post completion/retention data and must have a parent in disbursement data Set Aside - Must match previous submissions' ID Competitive: Must be >= last progress reported for this element; If element 15 (owner occupied) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 5 years; If element 16 (rental) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 15 years Set Aside: Leave this element open for updating for a time period = 15 years Must be >= last progress reported for this element; If element 15 (owner occupied) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 5 years; If element 16 (rental) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 15 years Grandfathered Phase In Y Y N N Y N Y N N Y N Y Data Reporting Manual AHP/CICA Chapter APPENDIX H. SET-ASIDE DISBURSEMENT FILE SUBMISSION This master list cross references the following information: Ordinal Position Set-Aside Disbursement File represents the new AHP/CICA submission file position number Notice Number represents the Federal Register Proposed Data Element List Number Final Name represents the final data collection name Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Page 19 of 25 DRM AHP CICA Chapter Appendix H Ordinal Position Set Aside Disburse Notice Number File 1 2 Final Name Reporting Period Beg Date 2 Reporting Period End Date Column Name Column Attribute RptBegDte RptEndDte MM/DD/YYYY MM/DD/YYYY Format Rules Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date Beg date must not be > Currrent date 5 As with Legacy system, suggested format is YYYYR########## Where YYYY = Year R = Round Letter Competitive Program Application Identifier (Competitive) FHLBProjID (Competitive) Char (15) ########## = project identifier FHLBHoushldID (SetAside) Char (15) 3 Set-Aside Program Household Identifier (Set-Aside) EnrollDte 5 Enrollment Date Date (MM/DD/YYYY Valid MM/DD/YYYY Char (2) Valid formats are 01 - 12 Zerofilled Match district to loginID and content DistrictID 1 FHLB Number/District 6 6 Member FHFB ID 3 4 Edit Checks Competitive - for application data, ID must be unique for progress or post completion/retention data and must have a parent in application data Competitive - Must match previous submissions' ID Set Aside - for disbursement data, ID must be unique for post completion/retention data and must have a parent in disbursement data Set Aside - Must match previous submissions' ID 7 Project Census Tract (Competitive) 8.9 Household Census Tract (Set-Aside) ProjTract HoushldTract Char (7) Valid FHFB ID in Membership Database Valid Census Tract; Competitve: If NDE27 is N, element is required; If NDE27 is Y, element must be null at application AND then Zerofilled Tract Numbers are ####.## (include ".") required at completion 8 12 Single Family SingleFmly Char (1) Y or N 9 Project Approval Date (Competitive) 18 Date of Disbursement (Set-Aside) ProjApprDte (Competitive) DisbDte (Set-Aside) Valid MM/DD/YYYY Date (mm/dd/yyyy) Valid MM/DD/YYYY CumDirectSubsdyDisb (Competitive) SubsdyDisb (SetAside) 10 11 Cumulative Dollar Amount of Direct Subsidy Disbursed (Competitive) Dollar Amount of Set-aside Subsidy Disbursed (Set23 Aside) 91 Dollar Amount of First Mortgage Loan AmtFirstMtge Integer Whole $ Integer Whole $ 12 92 Dollar Amount of Second Mortgage Loan (if applicable) AmtSecndMtge Integer Whole $ 13 93 First Mortgage Loan Annual Percentage Rate (APR) FirstMtgeAPR Decimal (3.4) SecndMtgeAPR HOEPALn HoushldClsCst Decimal (3.4) Char (1) Integer Whole $ DwnPymtClsCst Char (1) Y or N Y or N Y or N 14 15 16 Second Mortgage Loan Annual Percentage Rate (if 94 applicable) 95 HOEPA Covered Loan 96 Household's Closing Costs Downpayment, closing cost assistance (subsidy is used for) FHFBID Integer 17 NDE21 18 19 20 NDE22 NDE23 NDE24 Rehabilitation First-Time Homebuyer Household's Income Rehab FTHB HoushldIncm Char (1) Char (1) Integer Whole $ 21 22 NDE25 NDE26 Household's Income as a Percentage of A.M.I. Term of First Mortgage Loan HoushldIncmToAMI FirstMtgeTerm Decimal (3.4) Integer If elements 13 and 14 are N, this element must be Y (at least one of elements 12, 13, or 14 must be Y) Competitive: YYYY of this element must = YYYY of element 4 Competitive: If element 22 > 0 then this element must be <= element 22 valid 3.4 decimal If element 91 > 0 then this 9.75 % is reported as 9.7500 Not .0975 element must be > 0 valid 3.4 decimal If element 92 > 0 then this 9.75 % is reported as 9.7500 Not .0975 element must be > 0 Y or N If NDE22 = N then this element must = Y If NDE21 = N then this element must = Y valid 3.4 decimal 89.75 % is reported as 89.7500 Not .8975 Page 1 of 1 Data Reporting Manual AHP/CICA Chapter APPENDIX I. SET-ASIDE RECAPTURE/RETENTION/POST COMPLETION FILE SUBMISSION This master list cross references the following information: Ordinal Position Set-Aside Post Completion File represents the new AHP/CICA submission file position number Notice Number represents the Federal Register Proposed Data Element List Number Final Name represents the final data collection name Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Page 20 of 25 DRM AHP CICA Chapter Appendix I Ordinal Position Set Aside Post Completion Notice Number File Final Name Column Name Column Attribute MM/DD/YYYY MM/DD/YYYY Char (2) Zerofilled 1 2 Reporting Period Beg Date 2 Reporting Period End Date RptBegDte RptEndDte 3 1 FHLB Number/District DistrictID 4 5 Competitive Program Application Identifier (Competitive) FHLBProjID (Competitive) Char (15) FHLBHoushldID (SetAside) Char (15) 3 Set-Aside Program Household Identifier (Set-Aside) Cumulative Dollar Amount of Project Funds Recaptured or Repaid (Competitive) Dollar Amount of Set-aside Funds Re-paid (Set-Aside) CumReCapFunds 28 Retention Format Rules Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date Beg date must not be > Currrent date Valid formats are 01 - 12 Match district to loginID and content As with Legacy system, suggested format is YYYYR########## Where YYYY = Year R = Round Letter ########## = project identifier Integer Whole $ Page 1 of 1 Edit Checks Competitive - for application data, ID must be unique for progress or post completion/retention data and must have a parent in application data Competitive - Must match previous submissions' ID Set Aside - for disbursement data, ID must be unique for post completion/retention data and must have a parent in disbursement data Set Aside - Must match previous submissions' ID Competitive: Must be >= last progress reported for this element; If element 15 (owner occupied) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 5 years; If element 16 (rental) = Y then leave this element open for updating for a time period = element 20 or 21 (completion or withdraw date) + 15 years Set Aside: Leave this element open for updating for a time period = 15 years Data Reporting Manual AHP/CICA Chapter APPENDIX J. AGGREGATE AHP MAPPING Appendix J of this document provides a complete mapping of Aggregate AHP Information. This master list cross references the following information: Status represents the element’s status in the new database as it relates to previous actual or proposed reporting (i.e. converted, added, deleted, etc) Notice Number represents the Federal Register Proposed Data Element List Number Notice Name represents the Federal Register Proposed Data Element List Name CRS Description represents the final data collection name Definition represents the final element definition and includes examples as needed CRS Column Name represents the new CRS database column name Page 21 of 25 DRM AHP CICA Chapter Appendix J Status Notice Name Notice Number Aggregated FHLBank Data: Competititve and Non-Competititve Programs 97 Number of competitive program applications received by the FHLBank 98 99 100 101 Removed Removed Removed Number of competitive program applications awarded AHP commitments Dollar amount of required annual AHP allocation Dollar amount of AHP funds carried forward Dollar amount of AHPaccelerated funds 102 Dollar amount of AHP de-obligated funds 103 Dollar amount of AHP recaptured funds 104 Total dollar amount of AHP funds obligated 105 Total dollar amount of AHP funds disbursed Removed NDE Competitive program - Amount awarded Total Dollar Amount of AHP Funds Disbursed 106 Total dollar amount of AHP competitive funds allocated Competitive program - Statutory Allocation 107 Total dollar amount of AHP competitive program funds disbursed Competitive funds disbursed 108 Total dollar amount of AHP non-competitive program (homeownership set-aside) funds allocated Set-aside - Statutory Allocation 109 Total dollar amount of AHP non-competitive homeownership funds disbursed Added CRS Description Definition Aggregated FHLBank Data: Competititve and NonCompetititve Programs Report the total number of Competitive program applications received by the Competitive program - Number of applications received FHLBank during the reporting period. Report the total number of Competitive program applications that have been approved for an award by the FHLBank's Board of Directors during the reporting period. This data element includes primary projects, and any approved Competitive program - Number of applications approved competitive applications that are no longer alternates. for award Required Annual AHP Statutory Contribution Dollar Amount of AHP Funds Carried Forward Amount of AHP Funds Accelerated Report the dollar amount of funds that have been de-obligated from both the competitive and set-aside programs during the reporting period. De-obligated funds are defined as funds that were committed to a competitive project, household, or member that are returned to the Banks' AHP fund because of withdrawals, cancellations or Funds de-obligated modifications. Report the dollar amount of AHP funds from both the competitive and set-aside programs that have been recaptured or re-paid during the reporting period. Recaptured funds are funds that have been disbursed to the project and then returned to the FHLBank as a result of non-compliance, per section 951.12 of the AHP regulation. Repayments are funds returned to the FHLBank due to the sale or refinancing of the unit or project prior to the end of the retention Funds recaptured and repaid period. Set-aside funds disbursed Other AHP funding adjustments Page 1 of 1 CRS Column Name AHP1500 AHP1600 AHP2100 AHP2200 Report the dollar amount of funds awarded competitive projects during the reporting period. This data field is a gross amount, and includes primary projects as well as approved competitive applications that are no longer alternates. AHP1700 Report the dollar amount of the AHP 10% Statutory Contribution, allocated to the competitive program during the reporting period. AHP1200 Report the gross dollar amount of competitive program funds disbursed for competitive projects during the reporting period. Include competitive program disbursements from all program years. Do not net out recaptured or repaid funds. AHP1800 Report the dollar amount of the AHP 10% Statutory Contribution, allocated to the set-aside program during the reporting period. AHP1300 Report the gross dollar amount of setaside program funds disbursed for the reporting period. Include set-aside program disbursements from all program years. Do no net out repaid funds. AHP1900 Report other adjustments to AHP funds not captured in the above items (including member reservations for the set-aside program and subsidy modifications). AHP2300 Data Reporting Manual AHP/CICA Chapter APPENDIX K. CICA MAPPING Appendix K of this document provides a complete mapping of Member Level CICA Information. This master list cross references the following information: Status represents the element’s status in the new database as it relates to previous actual or proposed reporting (i.e. converted, added, deleted, etc) Notice Number represents the Federal Register Proposed Data Element List Number Final Name represents the final data collection name Definition represents the final element definition and includes examples as needed Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Ordinal Position CICA Disbursement File represents the new AHP/CICA submission file position number Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Page 22 of 25 DRM AHP CICA Chapter Appendix K Status Notice Name Final Name 1 FHLB Number/District Reporting Period Beg Date 2 Reporting Period End Date 6 Member FHFB ID Added NM_CICA4 Project Number Added NM_CICA6 State - Projected Location of Project Added Added NM_CICA5 NM_CICA7 Definition Column Name FHLBank District Number DistrictID The reporting period end date is defined as the last day in the reporting period. If the reporting period is 1/1 - 6/30, then the reporting end date is 6/30/YYYY. If the reporting period is 7/1 - 12/31, then the reporting end date is 12/31/YYYY. (competitive) If the reporting period is 1/1 - 12/31, then the reporting end date is RptBegDte 12/31/YYYY.( set-aside) RptEndDte Report the FHFB assigned Member number. FHFBID Report the FHLBank's CICA assigned project or member application identifier. Report the state where the project is projected to be located. For scattered site units, choose the state where the preponderance of the subsidy will be used. Column Attribute Char (2) Zerofilled Format Rules Valid formats are 01 - 12 Match district to loginID and content MM/DD/YYYY MM/DD/YYYY Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date Beg date must not be > Currrent date Char (15) State Char (2) Suggested format is YYYYR########## Where YYYY = Year R = Round Letter ########## = project identifier 1 2 7 Valid State Code/Abbreviation If NM_CICA8, NM_CICA 10, NM_CICA 11, or NM_CICA 12 is Y, then this element must be > 0; If only NM_CICA 9 = Y, then this element must be 0 Report the term of the advance or LOC in months. Integer 6 Dollar Amount of Advance, Grant or Letter of Credit Report the dollar amount of the CICA advance or grant commitment, if a portion of the commitment has been disbursed or advanced to the member during the reporting period. For example, the FHLBank has approved a member's application for a $10 million advance and the FHLBank has disbursed a portion ($5 million) to the member, then report the $10 million for this data field. For letter of credit, report the dollar amount of the letter of credit committment made by the FHLBank to the member. AmtAdvGrntLOC Integer 8 NonCIPAdv Char (1) Y or N 9 Added NM_CICA8 Non-CIP Advance Does the project have a Non-CIP advance. Added NM_CICA9 Non-CIP Grant Does the project have a Non-CIP grant. NonCIPGrnt Char (1) Y or N 10 Added NM_CICA10 Non-CIP Letter of Credit (LOC) Does the project have a Non-CIP LOC. NonCIPLOC Char (1) Y or N 11 Added NM_CICA11 CIP Advance Does the project have a CIP advance. CIPAdv Char (1) Y or N 12 Added NM_CICA12 CIP Letter of Credit (LOC) Does the project have a CIP LOC. CIPLOC Char (1) Y or N 13 Char (1) Y or N 14 Char (1) Y or N 15 Char (1) Y or N 16 Added NM_CICA13 Urban Added NM_CICA14 Rural Added NM_CICA15 Housing Project Is the projected location of the project in an urban area. Urban Is the projected location of the project in a rural area, as defined in the CICA regulation, 12 CFR part 952. Rural Are CIP funds used for a housing project, as defined in the CICA regulation, 12 CFR part 952. HousProj Page 1 of 2 Valid FHFB ID in Membership Database 5 Term of Advance or Letter of Credit (LOC) AdvLOCTerm Edit Checks 3 4 Integer FHLBCIPCICAID Ordinal Position CIPCICA Disburse File This element must be > 0 At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA13 or NM_CICA14 must be Y At least one of the data fields NM_CICA13 or NM_CICA14 must be Y At least one of the data fields NM_CICA15 - NM_CICA17 must be Y DRM AHP CICA Chapter Appendix K Status Notice Name Final Name Added NM_CICA16 Economic Development Project Added NM_CICA17 Mixed Use Project Added NM_CICA18 Projected Total Rental Housing Units Added NM_CICA19 Projected Total Owner-Occupied Housing Units Added NM_CICA20 Projected Total Number of Jobs Created or Retained Added NM_CICA21 Geographically Defined Beneficiaries Added NM_CICA22 Individual Beneficiaries Added NM_CICA23 Activity Beneficiaries Added NM_CICA24 Other Targeted Beneficiaries Definition Are CICA funds used to provide financing for economic development projects, as defined in the CICA regulation, 12 CFR part 952. Are CICA funds used to provide financing for mixed use projects. See definition of mixed use in the glossary. Report the projected total number of rental units for the housing project as proposed in the member's application. Report the projected total number of owner-occupied units for the housing project as proposed in the member's application. Report the projected total number of jobs created or retained as proposed in the member's application. Does the project serve Geographically Defined Beneficiaries as defined in the CICA regulation, 12 CFR part 952. Does the project serve Individual Beneficiaries as defined in the CICA regulation, 12 CFR part 952. Does the project serve Activity Beneficiaries as defined in the CICA regulation, 12 CFR part 952. Does the project serve Other Targeted Beneficiaries pursuant to the CICA regulation, 12 CFR part 952. Column Name Column Attribute Format Rules Ordinal Position CIPCICA Disburse File Edit Checks EconDevProj Char (1) Y or N 17 MixedUseProj Char (1) Y or N 18 PrpsdRntlUnit Integer 19 At least one of the data fields NM_CICA15 - NM_CICA17 must be Y At least one of the data fields NM_CICA15 - NM_CICA17 must be Y If NM_CICA15 or NM_CICA17 = Y then this element or NM_CICA19 >0 PrpsdOwnUnit Integer 20 If NM_CICA15 or NM_CICA17 = Y then NM_CICA18 or this element >0 PrpsdNumJobsCreatRetnd Integer 21 GeogDefBenfc Char (1) Y or N 22 IndivBenfc Char (1) Y or N 23 ActyBenfc Char (1) Y or N 24 OthTrgtdBenfc Char (1) Y or N 25 Page 2 of 2 If NM_CICA16 = Y then this element > 0 At least one of the data fields NM_CICA21 - NM_CICA24 must be Y At least one of the data fields NM_CICA21 - NM_CICA24 must be Y At least one of the data fields NM_CICA21 - NM_CICA24 must be Y At least one of the data fields NM_CICA21 - NM_CICA24 must be Y Data Reporting Manual AHP/CICA Chapter APPENDIX L. CICA DISBURSEMENT FILE SUBMISSION This master list cross references the following information: Ordinal Position CICA Disbursement File represents the new AHP/CICA submission file position number Notice Number represents the Federal Register Proposed Data Element List Number Final Name represents the final data collection name Column Name represents the new AHP/CICA database column name Column Attribute represents the new AHP/CICA database column attribute Format Rules represents the new AHP/CICA database column format rules Edit Checks represents the new AHP/CICA edit check(s) that must be met before the data will be accepted Page 23 of 25 DRM AHP CICA Chapter Appendix L Ordinal Position CIPCICA Disburse File Notice Name Final Name 1 2 2 Column Attribute RptBegDte RptEndDte 3 1 FHLB Number/District DistrictID MM/DD/YYYY MM/DD/YYYY Char (2) Zerofilled 4 6 Member FHFB ID FHFBID Integer 5 NM_CICA4 Reporting Period Beg Date Reporting Period End Date Column Name Project Number FHLBCIPCICAID Char (15) Format Rules Valid MM/DD/YYYY Valid MM/DD/YYYY Beg date must be < End date Beg date must not be > Currrent date Valid formats are 01 - 12 Match district to loginID and content Valid FHFB ID in Membership Database Suggested format is YYYYR########## Where YYYY = Year R = Round Letter ########## = project identifier 6 7 8 NM_CICA5 NM_CICA6 NM_CICA7 Term of Advance or Letter of Credit (LOC) State - Projected Location of Project Dollar Amount of Advance, Grant or Letter of Credit AdvLOCTerm State AmtAdvGrntLOC Integer Char (2) Integer 9 NM_CICA8 Non-CIP Advance NonCIPAdv Char (1) Y or N 10 NM_CICA9 Non-CIP Grant NonCIPGrnt Char (1) Y or N 11 NM_CICA10 Non-CIP Letter of Credit (LOC) NonCIPLOC Char (1) Y or N 12 NM_CICA11 CIP Advance CIPAdv Char (1) Y or N 13 NM_CICA12 CIP Letter of Credit (LOC) CIPLOC Char (1) Y or N 14 NM_CICA13 Urban Urban Char (1) Y or N 15 NM_CICA14 Rural Rural Char (1) Y or N 16 NM_CICA15 Housing Project HousProj Char (1) Y or N 17 NM_CICA16 Economic Development Project EconDevProj Char (1) Y or N 18 NM_CICA17 Mixed Use Project MixedUseProj Char (1) Y or N 19 NM_CICA18 Projected Total Rental Housing Units PrpsdRntlUnit Integer 20 NM_CICA19 Projected Total Owner-Occupied Housing Units PrpsdOwnUnit Integer 21 NM_CICA20 Projected Total Number of Jobs Created or Retained PrpsdNumJobsCreatRetnd Integer 22 NM_CICA21 Geographically Defined Beneficiaries GeogDefBenfc Char (1) Y or N 23 NM_CICA22 Individual Beneficiaries IndivBenfc Char (1) Y or N 24 NM_CICA23 Activity Beneficiaries ActyBenfc Char (1) Y or N 25 NM_CICA24 Other Targeted Beneficiaries OthTrgtdBenfc Char (1) Y or N Page 1 of 1 Edit Checks If NM_CICA8, NM_CICA 10, NM_CICA 11, or NM_CICA 12 is Y, then this element must be > 0; If only NM_CICA 9 = Y, then this element must be 0 Valid State Code/Abbreviation This element must be > 0 At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA8 - NM_CICA12 must be Y At least one of the data fields NM_CICA13 or NM_CICA14 must be Y At least one of the data fields NM_CICA13 or NM_CICA14 must be Y At least one of the data fields NM_CICA15 - NM_CICA17 must be Y At least one of the data fields NM_CICA15 - NM_CICA17 must be Y At least one of the data fields NM_CICA15 - NM_CICA17 must be Y If NM_CICA15 or NM_CICA17 = Y then this element or NM_CICA19 >0 If NM_CICA15 or NM_CICA17 = Y then NM_CICA18 or this element >0 If NM_CICA16 = Y then this element > 0 At least one of the data fields NM_CICA21 - NM_CICA24 must be Y At least one of the data fields NM_CICA21 - NM_CICA24 must be Y At least one of the data fields NM_CICA21 - NM_CICA24 must be Y At least one of the data fields NM_CICA21 - NM_CICA24 must be Y Data Reporting Manual AHP/CICA Chapter APPENDIX M. AGGREGATE CICA MAPPING Appendix F of this document provides a complete mapping of Aggregate CICA Information. This master list cross references the following information: Status represents the element’s status in the new database as it relates to previous actual or proposed reporting (i.e. converted, added, deleted, etc) CRS Description represents the final data collection name Definition represents the final element definition and includes examples as needed CRS Column Name represents the new CRS database column name Page 24 of 25 DRM AHP CICA Chapter Appendix M Status CRS Description Definition CRS Column Name CIP Advances - Number of new commitments - Housing Report the number of new CIP housing advance commitments made during the quarter. Commitment is defined as an approved member advance application. For example, if the FHLBank approves three (3) new member advance applications during the quarter, then report (3) for this data field. AHA11000 Added CIP Advances - Number of new commitments - Non housing Report the number of new CIP NonHousing advance commitments made during the quarter. Commitment is defined as an approved member advance application. For example, if the FHLBank approves three (3) new member advance applications during the quarter, then report (3) for this data field. AHA11100 Added Report the number of new Non-CIP, NonHousing advance commitments made during the quarter. Commitment is defined as an approved member advance application. For example, if the FHLBank approves three (3) new member advance Non CIP Advances - Number of new commitments - Non applications during the quarter, then Housing report (3) for this data field. AHA11200 Added Report the number of new CICA Letters of Credit (LOC) commitments made during the quarter. Commitment is defined as an approved member application. For example, if the FHLBank approves three (3) new member LOC applications during the quarter, then report (3) for this data field. AHA11400 Added CICA letters of credit - Number of new commitments Added CIP letters of credit - Number of new commitments Added CIP Advances - New commitments amount - Housing Added CIP Advances - New commitments amount - Non housing Report the number of new CIP Letters of Credit (LOC) commitments made during the quarter. Commitment is defined as an approved member application. For example, if the FHLBank approves three (3) new member LOC applications during the quarter, then report (3) for this data field. AHA11500 Report the dollar amount of new CIP housing advance commitments made during the quarter. Commitment is defined as an approved member advance application. For example, if the FHLBank approves three (3) new member advance applications totaling $10 million during the quarter, then report $10 million for this data field. AHA21000 Report the dollar amount of new CIP NonHousing advance commitments made during the quarter. Commitment is defined as an approved member advance application. For example, if the FHLBank approves three (3) new member advance applications totaling $10 million during the quarter, then report $10 million for this data field. AHA21100 Page 1 of 3 DRM AHP CICA Chapter Appendix M Status CRS Description Added Non CIP Advances - New commitments amount - Non housing Added CICA letters of credit - New commitments amount Added CIP letters of credit - New commitments amount Definition CRS Column Name Report the dollar amount of new NonCIP, Non-Housing advance commitments made during the quarter. Commitment is defined as an approved member advance application. For example, if the FHLBank approves three (3) new member advance applications totaling $10 million during the quarter, then report $10 million for this data field. AHA21200 Report the dollar amount of new CICA letters of credit (LOC) commitments made at quarter end. Commitment is defined as an approved member application. For example, if the FHLBank approves three (3) new member LOC applications totaling $10 million during the quarter, then report $10 million for this data field. AHA21400 Report the dollar amount of new CIP letters of credit (LOC) commitments made at quarter end. Commitment is defined as an approved member application. For example, if the FHLBank approves three (3) new member LOC applications totaling $10 million during the quarter, then report $10 million for this data field. AHA21500 Added CIP Advances - Commitments amount - Housing Added CIP Advances - Commitments amount - Non housing Added Non CIP Advances - Commitments amount - Non housing Added CIP letters of credit - Commitments amount Added CICA letters of credit - Commitments amount Report the balance of the dollar amount of CIP Housing advance commitments at quarter end. For example, if the FHLBank has approved $3 million of advances and has disbursed $1 million, then report $2 million for this data field ($3 million minus $1 million = $2 million). Report the balance of the dollar amount of CIP, Non-Housing advance commitments at quarter end. For example, if the FHLBank has approved $3 million of advances and has disbursed $1 million, then report $2 million for this data field ($3 million minus $1 million = $2 million). Report the balance of the dollar amount of Non-CIP, Non-Housing advance commitments at quarter end. For example, if the FHLBank has approved $3 million of advances and has disbursed $1 million, then report $2 million for this data field ($3 million minus $1 million = $2 million). Report the balance of CIP Letters of Credit (LOC) at quarter end. Report the balance of CICA Letters of Credit (LOC) at quarter end. CIP Advances - Disbursed amount - Housing Report the dollar amount of CIP housing funds disbursed (i.e., advanced) to members during the quarter. For this data field, include all funds disbursed for all approved commitments and for all program years. For example, if the FHLBank has disbursed (i.e., advanced) $3 million to members during the quarter, then report $3 million for this data field. AHA41000 Added Page 2 of 3 AHA31000 AHA31100 AHA31200 AHA31500 AHA31400 DRM AHP CICA Chapter Appendix M Status CRS Description Definition CRS Column Name Added CIP Advances - Disbursed amount - Non housing Added Non CIP Advances - Disbursed amount - Non housing Report the dollar amount of CIP NonHousing funds disbursed (i.e., advanced) to members during the quarter. For this data field, include all funds disbursed for all approved commitments and for all program years. For example, if the FHLBank has disbursed (i.e., advanced) $3 million to members during the quarter, then report $3 million for this data field. AHA41100 Report the dollar amount of Non-CIP, Non-Housing funds disbursed (i.e., advanced) to members during the quarter. For this data field, include all funds disbursed for all approved commitments and for all program years. For example, if the FHLBank has disbursed (i.e., advanced) $3 million to members during the quarter, then report $3 million for this data field. AHA41200 CIP Advances - Outstanding amount - Housing Report the dollar amount of outstanding CIP Housing disbursements (i.e., advances) at quarter end. For example, if the FHLBank has disbursed (i.e., advanced) a total of $30 million to members since the beginning of the CICA program, and this amount has not been repaid by the members, then report $30 million for this data field. AHA51000 CIP Advances - Outstanding amount - Non housing Report the dollar amount of outstanding CIP Non-Housing disbursements (i.e., advances) at quarter end. For example, if the FHLBank has disbursed (i.e., advanced) a total of $30 million to members since the beginning of the CICA program, and this amount has not been repaid by the members, then report $30 million for this data field. AHA51100 Non CIP Advances - Outstanding amount - Non housing Report the dollar amount of outstanding Non-CIP, Non-Housing disbursements (i.e., advances) at quarter end. For example, if the FHLBank has disbursed (i.e., advanced) a total of $30 million to members since the beginning of the CICA program, and this amount has not been repaid by the members, then report $30 million for this data field. AHA51200 Added Added Added Page 3 of 3 Data Reporting Manual AHP/CICA Chapter APPENDIX N. GLOSSARY A.M.I. is defined as Area Median Income. Accessible Design of Units is defined as units that are designed and accessible to and usable by people with disabilities particularly those individuals who use wheelchairs. HOEPA is defined as the Home Ownership and Equity Protection Act of 1994 (HOEPA). For purposes of the AHP set-aside program data collection and reporting, the term “HOEPA-covered loan” or “HOEPA loan” generally refers only to mortgages covered by §226.32 of Regulation Z that meet HOEPA’s rate or fee-based triggers. A loan is covered by the law if it meets the following tests: 1) for a first-lien loan, that is, the original mortgage on the property, the annual percentage rate (APR) exceeds by more than eight percentage points the rates on Treasury securities of comparable maturity; 2) for a second-lien loan, that is, a second mortgage, the APR exceeds by more than 10 percentage points the rates in Treasury securities of comparable maturity; or 3) the total fees and points payable by the consumer at or before closing exceed the larger of $528 or eight percent of the total loan amount. (The $528 figure is for 2006. This amount is adjusted annually by the Federal Reserve Board, based on changes in the Consumer Price Index.) Credit insurance premiums for insurance written in connection with credit transaction are counted as fees. Mixed Use is defined as a project that includes both residential housing units and commercial space that generates income. For example, a project that contains residential housing units and non-housing space that generates revenue (such as retail or office space leased to another entity). Service Enriched Housing is defined as housing which incorporates economic empowerment features (as defined in the AHP regulation) and may also include on-site quality of life social services, programs or activities. Single Family is defined as a structure with one to four dwelling units. Single Room Occupancy (SRO) Housing is defined as a residential property that includes multiple single room dwelling units. Each unit is designed for occupancy by a single individual. The unit need not, but may, contain food preparation or sanitary facilities, or both. Page 25 of 25
| File Type | application/pdf |
| File Title | Data Reporting Manual |
| File Modified | 2010-03-15 |
| File Created | 2006-08-02 |