Download:
pdf |
pdfFEDERAL 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 |