Affordable Housing Program (AHP)

FEDERAL HOUSING FINANCE BOARD
Affordable Housing Program/Community
Investment Cash Advance (AHP/CICA)
Data Reporting Instructions

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

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