Download:
pdf |
pdfFY 2006
CDFI Transaction Level Report: Data Point
Guidance
CIIS 4.1
February 7, 2007
TABLE OF CONTENTS
FY 2006 CDFI TRANSACTION LEVEL REPORT: DATA POINT GUIDANCE .......................................... 3
WHICH LOANS AND INVESTMENTS TO INCLUDE IN THE TLR............................................................. 3
QUICKSTART INSTRUCTIONS .................................................................................................................. 3
TLR “PROJECT” GUIDANCE ..................................................................................................................... 3
ADDITIONAL CIIS 4.0 CHANGES ............................................................................................................... 4
UNDERSTANDING THE DATA POINTS..................................................................................................... 4
TRANSACTION IDENTIFIER.................................................................................................................... 7
TRANSACTION PROFILE ........................................................................................................................ 8
ADDRESSES .......................................................................................................................................... 14
INVESTEE ADDRESS ............................................................................................................................ 15
PROJECT ADDRESS ............................................................................................................................. 16
BORROWER INVESTEE PROFILE........................................................................................................ 17
TRANSACTION STATUS........................................................................................................................ 19
IMPACT PROFILE................................................................................................................................... 22
PROJECTED IMPACTS.......................................................................................................................... 27
FY 2006 CDFI Transaction Level Report: Data Point Guidance
FY 2006 CDFI Transaction Level Report: Data Point Guidance
This document provides guidance for the Fiscal Year (FY) 2006 CDFI Transaction Level Report
(TLR) data points.
The FY 2006 version of CIIS is CIIS 4.1.
In previous versions of CIIS, loans and investments were referred to as “transactions.” In CIIS
4.0, individual loans and investments are also referred to as “Financial Notes.”
Which Loans and Investments to Include in the TLR
Include all loans and investments that were outstanding at any time during the reporting period.
Exclude any New Markets Tax Credit (NMTC) activity that was funded by Qualified Equity
Investments (QEIs). The reporting period for the FY 2006 TLR is the Organization's fiscal
year ending in 2006.
All data must be reported as of the reporting period end date unless otherwise noted. The data
identified as “Annual Update Required” (Principal Balance Outstanding, Days Delinquent,
etc.) is not static. Please respond “as of” the reporting period end date. For example, for each
loan, report the principal balance outstanding and number of days delinquent on the last day of
the reporting period.
QuickStart Instructions
The new “QuickStart” Instructions include basic information about CIIS 4.0 in an Excel spreadsheet. The
QuickStart contains summary information that users can sort by topic. Definitions for the columns can be
found on the second worksheet. The QuickStart identifies the following for all CIIS 4.0 data points:
New CIIS 4.0 data points;
Mandatory data points;
Conditionally required data points (including conditional requirements);
Compliance data points;
Data points that are specific to Transaction Type, Purpose, and Borrower/Investee Type; and
Special Instructions.
The QuickStart is a supplement to this guidance and are available at
www.cdfifund.gov/what_we_do/ciis.asp.
TLR “Project” Guidance
Many CDFIs are financing single Projects with more than one Financial Note (e.g., loan, line of credit, or
equity investment). CDFIs will now be able to report which Financial Notes belong to a single Project.
The Fund requires that each Financial Note that finances a single project have the same:
Borrower (indicated by Client ID);
Investee Address;
02/072007
CIIS 4.1
3 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
Project Address or set of Project Addresses; and
Total Project Cost.
Additional CIIS 4.0 Changes
New CONDITIONALLY REQUIRED data points
The following data points are Conditionally Required for the entire FY 2006 TLR, including transactions
that were previously reported.
Projected Impacts – Additional Clarification:
Projected Jobs to be Created at Businesses Financed
Projected Jobs to be Created - Construction
Square Feet of Real Estate - Total
New OPTIONAL data points
The following data points are Optional for the entire FY 2006 TLR, including transactions that were
previously reported.
Project Number – Allows users that provide more than one loan or investment to a single Project
to link multiple Originator Transaction IDs to that Project.
Total Project Cost – Affiliates & Related Programs
Projected Jobs to be Created at Tenant Businesses
Community Facilities
Changes to Existing Data Points
The PURPOSE options have changed:
"Business - Fixed Assets" and "Business - Working Capital" have been removed.
"Business" and "Microenterprise" have been added.
The AMORTIZATION TYPE options have changed:
"Balloon" has been removed.
"Non-amortizing" has been added.
The GUARANTEE options have changed:
"Personal Guarantee" has been added.
The COLLATERAL TYPE options have changed:
"Personal Guarantee" has been removed.
Understanding the Data Points
Example 1
C
Originator Transaction ID
Assign a unique identifier to each Financial Note. The Originator Transaction ID is typically a loan
number or tracking number. The Originator Transaction ID is used to track Financial Notes across
reporting periods.
MANDATORY DATA FIELD
Validations:
Excel Data Format
02/072007
Each Originator Transaction ID may only be used for one
Financial Note per reporting period.
CDFIs MUST use the same Originator Transaction ID for each
reporting period that a particular Financial Note is submitted.
Text (20 characters)
CIIS 4.1
4 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
Example 2:
AT
Principal Balance Outstanding
For each loan and line of credit, report the principal balance outstanding at the end of the reporting
period.
Transaction Type =
CONDITIONALLY REQUIRED
• Term Loan
IF:
• Line of Credit OR
• Debt with Equity
Reject If:
Transaction Type = Equity Investment
COMPLIANCE
Annual Update Required
Excel Data Format
Numeric
Example 3:
K
Interest Type
For each loan and line of credit, report the type of interest.
Reject If:
Transaction Type = Equity Investment
Crosswalk Values / Definitions
FIXED
ADJ
Fixed
Adjustable
Excel Column
The Excel Column is found in the first row to the left of the Data Point Box. The Excel Column refers to
the column where a data point is located in the Excel Template. The Excel Column is provided for
referring, searching, and ordering data points.
Example 1: “Originator Transaction ID” data point is located in Column C.
NEW
“NEW” appears below the Excel column for any data points that are new in CIIS 4.0.
Data Point Name
The Data Point Name is indicated in Bold in the first row of the data point box.
Example 1: Data Point Name is “Originator Transaction ID.”
Guidance
Guidance for each data point is provided directly below the Data Point Name.
Mandatory, Conditionally Required, and Optional Data Fields
Mandatory data points must be reported for every transaction. CIIS will not validate transactions that do
not include the Mandatory data points.
Mandatory data points are indicated by “MANDATORY DATA FIELD” and double bold borders
around the Data Point Box (as in the Example 1).
The Online entry system displays
next to Mandatory fields.
Conditionally Required data points must be reported for a transaction if the noted conditions apply.
Conditionally Required If data points are indicated by “CONDITIONALLY REQUIRED IF” and a
single bold border around the Data Point Box (as in Example 2).
Example 2: If the Transaction Type for the Financial Note is Term Loan, Line of Credit, or Debt with
Equity, the user must provide a valid response to Principal Balance Outstanding.
02/072007
CIIS 4.1
5 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
Users are not required to provide responses for Optional data points. Optional data points are indicated
by a single border around the data box (as in Example 3).
Compliance Data Points
Compliance data points may be used to measure a CDFI’s compliance with their Assistance Agreement.
Any field that may be used for compliance purposes for any CDFI is identified as a Compliance data
point. Awardees must refer to their specific Assistance Agreement(s) to determine if the data point is
relevant to their organization’s compliance.
Compliance data points are indicated by “COMPLIANCE” and blue shading (as in Example 2).
The Online entry system displays a
next to Compliance fields.
Reject If
CIIS will generate an error if a response is provided when a “Reject If” condition applies. “Reject If” is
intended to eliminate responses that do not make sense: for example, providing an interest rate for an
equity investment. When a “Reject If” condition applies, the user should leave the response blank.
Example 2: If the transaction is an Equity Investment, CIIS will not accept Principal Balance
Outstanding entry.
Validations
In order to certify and submit the TLR, the data must pass a number of validation rules. Validation rules
are provided in the data boxes.
Example 1: CIIS will not accept the same Originator Transaction ID for more than one Financial Note
per reporting period.
Annual Update Required
CIIS requires users to update certain data points each year if they have changed since the previous
reporting period. These data points are noted with “Annual Update Required” in a yellow box.
Example 2: Users are expected to update the Principal Balance Outstanding annually.
Excel Data Formats
The Excel Data Format describes the required format to upload the Excel Template. In general, users
should refer to the Excel Data Format to determine the type of data CIIS requires.
Example 1: CIIS will accept text entries.
Crosswalk Values/ Definitions
The Crosswalk Values / Definitions provides the valid CIIS responses for data points that are not numeric
or open-ended text.
Example 3: “Fixed” and “Adjustable” are valid responses to Interest Type in CIIS. CIIS will accept
the values crosswalked to “FIXED” and “ADJ” in an Excel or XML upload.
XML and Excel uploads: Values will be indicated in the Crosswalk.
Manual Entry: Values appear in the dropdown menus.
02/072007
CIIS 4.1
6 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
Transaction Identifier
A
Submitter Transmission ID
XML and Excel Template users may use the Submitter Transmission ID to distinguish multiple data
files uploaded to CIIS.
XML Interface - Include a value for the SubmitterTransmissionId attribute in the Transmission
element.
Excel Template - Report the SubmitterTransmissionID in A2 cell of the Excel template.
Manual data entry - Submitter Transmission ID is not relevant.
Excel Data Format
MM/DD/YYYY#
B
Project Number
Assign a unique identifier to each Project. Project Number is used to link a Financial Note(s) to a
distinct Project and to track Projects across reporting periods.
• Each Project Number may only be used for one Project per
Validations:
reporting period.
• CDFIs MUST use the same Project Number for each
reporting period that a particular Project is submitted.
NEW
Excel Data Format
C
Originator Transaction ID
Assign a unique identifier to each Financial Note. The Originator Transaction ID is typically a loan
number or tracking number. The Originator Transaction ID is used to track Financial Notes across
reporting periods.
MANDATORY DATA FIELD
Validations:
Excel Data Format
D
• Each Originator Transaction ID may only be used for one
Financial Note per reporting period.
• CDFIs MUST use the same Originator Transaction ID for
each reporting period that a particular Financial Note is
submitted.
Text (20 characters)
Client ID
Report a unique identifier to each client (investee/borrower). The Client ID is used to track the
investee/borrower across reporting periods.
Excel Data Format
E
Numeric (8 digits)
Text (20 character limit)
Investee Type
• Report whether the Project is an investment in an individual, a business or another CDFI.
• Loans/investments in nonprofit entities, other than CDFIs, should be reported as “Business.”
• Exclude loan purchases from the TLR.
MANDATORY DATA FIELD
Crosswalk Values
02/072007
IND
BUS
CDFI
CIIS 4.1
Individual
Business
CDFI
7 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
Transaction Profile
F
Date Originated
Report the date that a legally binding note was signed by the borrower/investee in favor of the
lender/investor.
MANDATORY DATA FIELD
G
Reject If:
• Date Originated > Current Date
Excel Data Format
MM/DD/YYYY
Original Loan/Investment Amount
Report the amount of the loan/investment.
• For equity investments, if an upward adjuster is used during the reporting period, update the
Original Loan/Investment Amount.
MANDATORY DATA FIELD
Reject If:
Purpose = Microenterprise, and Original Loan/Investment
Amount > $35,000
Annual Update Required
Excel Data Format
H
Numeric
Purpose
Identify the primary purpose of the Financial Note. If there are multiple purposes (for example, a
loan funding both the purchase of a fixed asset and a facility improvement), select the purpose
with the largest percent of the transaction. Classify loans/investments in CDFIs as “Other”.
MANDATORY DATA FIELD
Validations:
Crosswalk Values / Definitions
02/072007
If: Purpose = Home Purchase or Home Improvement
Then: Investee Type = Individual
CONSUMER
Consumer
• Loan is a personal (secured or
unsecured) loan to one or more
individuals for health, education,
emergency, credit repair, debt
consolidation, or other consumer
purposes. Personal loans for business
purposes should be identified as
Business loans and personal loans for
home improvement or repair should be
identified as Housing loans.
BUSINESS
Business
• Financing to for-profit and nonprofit
businesses with more than five
employees or in an amount greater
than $35,000 for the purpose of
expansion, working capital, equipment
purchase or rental, or commercial real
estate development or improvement.
MICRO
Microenterprise
• Financing to for-profit or non-profit
enterprise that has five or fewer
CIIS 4.1
8 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
employees (including the proprietor)
and in an amount no more than
$35,000 for the purpose of expansion,
working capital, equipment purchase or
rental, or commercial real estate
development or improvement.
HOMEPURCH
Home Purchase
• Loan is for the purchase of a primary
residence.
HOMEIMP
Home Improvement
• Loan is for the renovation or other
improvement of an owner-occupied
home.
RECOCOM
RECOMULTI
RECOSINGLE
RERHCOM
RERHMULTI
RERHSINGLE
02/072007
CIIS 4.1
Real Estate –
Construction/Permanent/Acquisition
w/o Rehab – Commercial
• Financial Note is for 1)
predevelopment financing; 2)
construction or permanent financing; or
3) acquisition without rehabilitation of
office, retail, manufacturing, or
community facility space.
• Include mixed-use real estate that
combines both commercial and
residential use.
Real Estate – Construction–
Housing-Multi Family
• Financial Note is for predevelopment
financing, or construction of multifamily
housing.
Real Estate – Construction–
Housing-Single Family
• Financial Note is for predevelopment
financing, or construction of single
family housing.
Real Estate–Rehabilitation–
Commercial
• Financial Note is to rehabilitate office,
retail, manufacturing, or community
facility space. Financial Note may
include acquisition costs.
• Include mixed-use real estate that
combines both commercial and
residential uses.
• Exclude acquisitions without
rehabilitation.
Real Estate – Rehabilitation–
Housing - Multi Family
• Financial Note is to rehabilitate or
acquire multifamily housing.
Real Estate – Rehabilitation –
Housing -Single Family
9 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
• Financial Note is to rehabilitate or
acquire single family housing.
OTHER
I
Other
• Financial Note purpose does not
match any of the purposes defined
above.
Transaction Type
Report the type of transaction.
MANDATORY DATA FIELD
Crosswalk Values / Definitions
J
K
L
M
TERM
EQTYINV
LOC
DEBTEQTY
OTHER
Term Loan
Equity Investment
Line of Credit
Debt with Equity
Other
Interest Rate
For each loan and line of credit, report the interest rate in effect at the reporting period end. If the
Financial Note was paid off during the reporting period, report the interest rate at the time of the
pay off.
Reject If:
Annual Update Required
Transaction Type = Equity Investment
Excel Data Format
Numeric (3 decimal places)
Interest Type
For each loan and line of credit, report the type of interest.
Reject If:
Transaction Type = Equity Investment
Crosswalk Values / Definitions
FIXED
ADJ
Fixed
Adjustable
Points
If applicable, report the points charged to the borrower at origination. (Points are upfront fees,
separate from interest, but designed to increase the overall yield to the lender.) One point is one
percent of the total principal amount of the loan. Report the points as a percentage of the original
loan amount.
Reject If:
Transaction Type = Equity Investment
Excel Data Format
Numeric (3 decimal places)
Origination Fees
Report the total origination fees, including processing, credit report, and other fees.
Exclude Points
Reject If:
Origination Fees > Original Loan/Investment Amount
Excel Data Format
02/072007
Numeric (2 decimal places)
CIIS 4.1
10 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
N
Amortization Type
For each loan and line of credit, report how the Financial Note is amortized.
Reject If:
Crosswalk Values / Definitions
O
Transaction Type = Equity Investment
FULLAMORT
Fully Amortized
• Amortization schedule
includes both interest and
principal payments throughout
the life of the loan.
PARTAMORT
Partially Amortized
• Amortization schedule
includes some principal
payments throughout the life
of the loan, with a larger
principal payment at maturity.
NONAMORT
Non-amortizing
• Amortization schedule
includes interest only
payments with a single
principal payment at maturity.
OTHER
Other
Equity-Like Features
For debt with equity, report the type of equity-like feature. Equity-like features offer some upside
potential above the return of principal and interest. The equity-like feature, or “kicker,” can be tied
either to future revenues (royalties or participation agreements) or to equity (convertible debt or
debt with warrants), or may include an interest rate that adjusts based on the borrower's
performance. If the loan has more than one equity-like feature, choose the one appearing first in
the loan agreement.
Crosswalk Values / Definitions
02/072007
NONE
CONVDEBT
None
PERFINT
Performance–Based Interest
Rate
• Loan's interest rate adjusts
based on the borrower's
performance.
ROYALTIES
Royalties
• Loan has a royalty
participation that gives the
investor the right to a
percentage of the borrower’s
sales or profits.
WARRANTS
Warrants
• Loan agreement gives the
investor the right to purchase
the portfolio company's stock
at a later date at a prenegotiated price.
CIIS 4.1
Convertible Debt
• Loan agreement specifies an
option to convert all or part of
the loan amount to equity.
11 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
OTHER
P
Term
For each loan and line of credit, report the full term in months. Report the full term, not the
remaining term. If the loan was restructured during the reporting period and the loan term
changed, update the new loan term.
Annual Update Required
Excel Data Format
Q
Numeric
Date First Payment Due
If applicable, report the date the first loan payment is due.
• Include interest only payments.
Excel Data Format
R
MM/DD/YYYY
Guarantee
For each loan and line of credit, if any portion of the loan is guaranteed, report the source.
• “Personal Guarantee” option was added in CIIS 4.0.
• Exclude performance guarantees.
Reject If:
Crosswalk Values / Definitions
Transaction Type = Equity Investment
SBA
Small Business Administration (SBA)
USDA
OTHERGOV
PERSONAL
OTHER
NONE
S
Other
• Loan agreement specifies an
equity-like feature not
described above.
US Dept of Agriculture (USDA)
Other Federal Government Source
Personal Guarantee
Other
None
Lien Position
For each loan and line of credit, report the CDFI’s lien position.
• If no other lender has priority over the CDFI in the case of default, the lien position is first. Report
a loan with a shared first position as first.
• If another lender receives priority in the case of a default, the lien position is second.
• If more than one other lender receives priority, the lien position is "Other.”
Reject If:
Transaction Type = Equity Investment
Crosswalk Values / Definitions
FIRST
SECOND
UNSECURED
OTHER
02/072007
CIIS 4.1
First
Second
Unsecured Debt
Other
12 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
T
Collateral Type
For each loan and line of credit, report the type of collateral pledged for the loan/investment.
Collateral is an asset pledged to a lender until a loan is repaid. If more than one type of collateral
was pledged, choose the option with the highest estimated value. Rents or leases pledged as
collateral should be included as "Receivables.”
• The “Personal Guarantee” option was removed from Collateral Type in CIIS 4.0. Personal
Guarantees are now reported under the Guarantee (R) data point.
Crosswalk Values / Definitions
U
Numeric
Equity Injection Amount
If applicable, report the equity injection amount provided by the investee/borrower. Equity injection
is an underwriting mechanism used to help borrowers who lack collateral to qualify for a loan. The
equity injection measures the amount of the borrower's own assets invested in the business.
• Include both cash and non-cash injections.
Example 1: Down payment for a purchase mortgage.
Example 2: Value of machinery the borrower purchased for the financed project.
Purpose =
Reject If:
• Consumer
• Home Improvement
Excel Data Format
W
Real Estate
Other Real Estate
Vehicle
Equipment
Inventory
Receivables
Home Equity
Other
None
Collateral Value at Origination
For each loan and line of credit, estimate the fair value of the collateral at the time of origination.
Excel Data Format
V
RE
REOTHER
VEH
EQUIP
INVENTORY
REC
HOMEEQTY
OTHER
NONE
Numeric
Forgivable Loan
For each loan, report whether the loan agreement stipulates that some or all of the outstanding
balance of the loan may be converted to a grant upon meeting specified conditions.
Example: Some CDFI mortgages state that if the borrower resides in the purchased home for a
given number of years and then sells it back to a nonprofit organization, the loan will be forgiven.
Crosswalk Values / Definitions
02/072007
YES
NO
CIIS 4.1
Yes
No
13 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
Addresses
Address Guidance
Users must report one Investee Address (or FIPS Code) and one or more Project Addresses (or FIPS
Codes). Users may provide the same address for the Investee Address and Project Address, if
appropriate.
Investee Address/FIPS Code refers to the investee’s/borrower’s address. Investee Address is the
home address when the borrower is an individual and the business address when the borrower is a
business.
Project Address/FIPS Code refers to the location of the business or other real estate for which the
loan or investment is being used. For business investees/borrowers, if the Project Address is
different from the Investee Address please provide the Project address. If the loan or investment is
funding multiple projects at different locations please provide the address of each location.
FIPS Code refers to the 11-digit Federal Information Processing Standards codes that indicate state
(first 2 digits), county (next 3 digits), and census tract (last 6 digits). FIPS codes must be provided if
CIIS is unable to geocode an address. For additional information about FIPS codes, visit
www.census.gov/geo/www/fips/fips.html.
During the TLR address verification process, CIIS will attempt to geocode each address (identify the
location on a digital map). CIIS will notify the user of each transaction address that the system was not
able to geocode, if any.
CIIS cannot geocode rural or “new” addresses that are not available in the geocoding
database.
The Fund recommends that organizations confirm that all addresses are geocodable in CIMS (the
Fund’s CDFI Information and Mapping System) prior to reporting in CIIS.
This extra step will save the organization time and effort in the reporting process. CIMS is available
through the “Mapping” link in your organization’s myCDFIFund account. For more information about
CIMS, please visit www.cdfi.treas.gov/mapping.
The 11-Digit FIPS
CIIS collects an 11-digit FIPS:
State: The first two digits of the FIPS represent the state.
- A list of state codes is available at: www.census.gov/geo/www/cenpop/statecenters.txt
County: The next three digits of the FIPS represent the county.
- A list of county codes available at: www.census.gov/geo/www/cenpop/county/ctyctrpg.html
Tract: The last six digits of the FIPS represent the census tract.
- The directions below provide one option for identifying the census tract using the U.S. Census
Bureau’s website.
- If only four digits are provided for the census tract code, add two zeros before the tract number.
- If only two digits are provided for the census tract code, add two zeros before the tract number
and two zeros after the tract number.
How to Obtain a Census Tract for the FIPS Code
The Fund offers the following suggestion for obtaining a FIPS for addresses that cannot be geocoded in
CIIS:
Visit the U.S. Census Bureau’s website at www.census.gov.
Select “American Fact Finder” from the left column of the Census Bureau’s Homepage.
Select the “street address” hyperlink from the left column under “Address Search…”
02/072007
CIIS 4.1
14 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
Enter the specific address and click the “Go” button.
- If the census is unable to geocode the address, you will need to enter the address of a nearby
site.
- Continue to enter nearby addresses until the Census website is able to geocode the address.
Select “Census Tract” from the list of geographic options and click the “Map It” button.
Use the map provided to “eyeball” the desired location and census tract.
Please print out a copy of the map for future reference.
Investee Address
X
Investee Street Address Line 1
Report the first line of the investee’s street address.
MANDATORY DATA FIELD
COMPLIANCE
Excel Data Format
Y
Text
Investee Street Address Line 2
Report the second line of the investee’s street address, if necessary.
Excel Data Format
02/072007
Text
CIIS 4.1
15 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
Z
Investee City
Report the investee’s city.
MANDATORY DATA FIELD
COMPLIANCE
Excel Data Format
AA
Text
Investee State
Report the investee’s state.
MANDATORY DATA FIELD
COMPLIANCE
Excel Data Format
AB
Text
Investee Zip Code 5
Report the investee’s five digit zip code.
MANDATORY DATA FIELD
COMPLIANCE
Excel Data Format
AC
Numeric
Investee Zip Code+4
Report the investee’s four digit zip code extension. To look up the four digit extension for any
United States address, see the "Zip Code Lookup" function at www.usps.gov.
Excel Data Format
AD
Numeric
Investee FIPS Code
Report the investee’s 11-digit FIPS code.
MANDATORY DATA FIELD (or Investee Address)
COMPLIANCE
Excel Data Format
Numeric
Project Address
AE
Project Street Address Line 1
Report the first line of the project’s street address.
MANDATORY DATA FIELD
COMPLIANCE
Excel Data Format
AF
Text
Project Street Address Line 2
Report the second line of the project’s street address, if necessary.
Excel Data Format
02/072007
Text
CIIS 4.1
16 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
AG
Project City
Report the project’s city.
MANDATORY DATA FIELD
COMPLIANCE
Excel Data Format
AH
Text
Project State
Report the project’s state.
MANDATORY DATA FIELD
COMPLIANCE
Excel Data Format
AI
Text
Project Zip Code 5
Report the project’s five digit zip code.
MANDATORY DATA FIELD
COMPLIANCE
Excel Data Format
AJ
Project Zip Code+4
Report the project’s four digit zip code extension. To look up the four digit extension for any
United States address, see the "Zip Code Lookup" function at www.usps.gov.
Excel Data Format
AK
Numeric
Numeric
Project FIPS Code
Report the project’s 11-digit FIPS code.
MANDATORY DATA FIELD (or Project Address)
COMPLIANCE
Excel Data Format
Numeric
Borrower Investee Profile
AL
NAICS
If applicable, report the 6-digit North American Industry Classifications (NAICS) Code. The NAICS
code replaced the former Standard Industrial Classification (SIC) system and is used to report
business revenue on the federal tax return. For additional information, see IRS Schedule C Form,
question B or www.census.gov/epcd/www/naics.html.
Excel Data Format
AM
Numeric
SIC Code
If applicable, report the 4-digit Standard Industrial Classification (SIC) code. The SIC system was
developed in the 1930s as a way for the Federal government to classify business industries.
Excel Data Format
02/072007
Numeric
CIIS 4.1
17 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
AN
AO
Date Business Established
If applicable, report the date formal papers were filed to establish the investee’s/borrower’s
business or the date the first sales occurred.
Reject If:
Date Business Established >= Date Originated
Excel Data Format
MM/DD/YYYY
Entity Structure
If applicable, report the borrower/investee’s business or government structure.
Reject If:
Crosswalk Values / Definitions
Investee Type = Individual
NONPROFIT
Non-Profit or Not-for-Profit
Based on the IRS categorization
for tax purposes.
FORPROFIT
For-Profit
Based on the IRS categorization
for tax purposes.
TRIBAL
Tribal or Village Government
Entity is a tribal or village
government, whether or not it has
been federally recognized.
OTHER
Other
All other structures that do not fit
the descriptions above, such as a
government or quasi-government
entity (i.e., a water authority).
AP
Minority Owned or Controlled
Report whether the investee/borrower is more than 50% owned or controlled by one or more
minorities.
If the business is a for-profit entity, report whether more than 50% of the owners are
minorities.
If the business is a nonprofit entity, report whether more than 50% of its Board of Directors
are minorities (or, if the Chief Executive Officer, Executive Director, General Partner, or
Managing Member is a minority).
Crosswalk Values / Definitions
YES
Yes
NO
No
AQ
Women Owned or Controlled
Report whether if the investee/borrower is more than 50% owned or controlled by women.
If the business is a for-profit entity, report whether more than 50% of its owners are women.
If the business is a nonprofit entity, report whether more than 50% of its Board of Directors
are women (or, if the Chief Executive Officer, Executive Director, General Partner, or
Managing Member is a woman).
Crosswalk Values / Definitions
YES
Yes
NO
No
02/072007
CIIS 4.1
18 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
AR
Low-Income Owned or Controlled
Report whether the investee/borrower is more than 50% owned or controlled be low-income
persons.
If the business is a for-profit entity, report whether more than 50% of its owners are lowincome persons.
If the business is a nonprofit entity, report whether more than 50% of its Board of Directors
are low income persons (or, if the Chief Executive Officer, Executive Director, General
Partner, or Managing Member is a low income person).
Crosswalk Values / Definitions
YES
Yes
NO
No
AS
Jobs at Time of Loan/Investment
For business Projects, report the number of full-time equivalent (FTE) jobs in the business at the
time the Project was originated. One FTE is a 35-hour or more work week. In calculating FTEs,
part-time employees should be combined.
Example: 2 part-time employees that each work 17.5 hours equals one FTE (2 employees x 17.5
hours = 35 hours).
Exclude construction jobs.
Purpose = Business or Microenterprise
CONDITIONALLY REQUIRED IF:
Excel Data Format
Number, "Don't Know", or "Not Applicable"
Transaction Status
AT
Principal Balance Outstanding
For each loan and line of credit, report the principal balance outstanding at the end of the reporting
period.
Transaction Type =
CONDITIONALLY REQUIRED IF:
• Term Loan
• Line of Credit OR
• Debt with Equity
Reject If:
Transaction Type = Equity Investment
COMPLIANCE
Annual Update Required
Excel Data Format
AU
Numeric
Loan Status
For each Financial Note, report the status of the loan/investment at the reporting period end.
“Active” refers to a Financial Note that is on-the-books or open.
“Closed in Good Standing” refers a loan or line of credit that is paid in full or an equity
investment that has been exited.
“Sold,” “Charged Off,” and “Refinanced” refers to a loan or line of credit that is off-the-books,
but not paid in full.
MANDATORY DATA FIELD
Annual Update Required
Crosswalk Values / Definitions
02/072007
ACTIVE
CLOSED
CIIS 4.1
Active
Closed in Good Standing
19 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
SOLD
CHARGEDOFF
REFIN
AV
Sold
Charged Off
Refinanced
Days Delinquent
For each loan and line of credit, report the number of days that a required loan payment is past
due at the reporting period end. If a borrower made a partial payment on the due date but still
owes any part of the payment, report that payment as past due.
Transaction Type =
CONDITIONALLY REQUIRED IF:
• Term Loan
• Line of Credit OR
• Other
COMPLIANCE
Reject If:
Transaction Type = Equity Investment
Annual Update Required
Excel Data Format
AW
Numeric
Number of Times 60 Days or More Delinquent
For each loan and line of credit, report the number of times the loan has been 60 days or more
delinquent during the life of the loan.
Reject If:
Transaction Type = Equity Investment
Annual Update Required
Excel Data Format
AX
Numeric
Number of Times the Loan was Restructured
For each loan and line of credit, report the number of times the loan was restructured during the
life of the loan. Restructured refers to a change to the original terms of the loan (i.e., amount,
interest rate or type, term, or payment schedule). Restructuring amends the original loan
agreement, but does not pay it off.
Reject If:
Transaction Type = Equity Investment
Annual Update Required
Excel Data Format
AY
Numeric
Number of Times the Loan was Refinanced
For each loan and line of credit, report the number of times the loan was refinanced during the life
of the debt. Refinanced refers to origination a new loan that pays of an existing loan.
Reject If:
Transaction Type = Equity Investment
Annual Update Required
Excel Data Format
02/072007
Numeric
CIIS 4.1
20 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
AZ
BA
Refinanced-Original Transaction ID
If the loan or line of credit was refinanced, report the Originator Transaction ID for the refinanced
loan or line of credit.
Reject If:
Transaction Type = Equity Investment
Excel Data Format
Text
Amount Charged Off
If applicable, report the amount charged off during the reporting period.
Transaction Type = Equity Investment
Reject If:
OR
Loan Status = Active
Annual Update Required
Excel Data Format
BB
Numeric
Amount Recovered
If applicable, report the amount recovered during the reporting period.
Transaction Type = Equity Investment
Reject If:
OR
Loan Status = Active
Annual Update Required
Excel Data Format
BC
Fair Value at Origination
For equity investments, report the estimated fair value of the investment at the time origination.
Transaction Type = Equity Investment
CONDITIONALLY REQUIRED IF:
Reject If:
Excel Data Format
BD
Numeric
Transaction Type =
• Term Loan
• Line of Credit
Numeric, "Don't Know", or "Not Applicable"
Fair Value at End of Reporting Period
For equity investments, report the estimated fair value of the Financial Note at the reporting period
end.
Transaction Type = Equity Investment
CONDITIONALLY REQUIRED IF:
COMPLIANCE
Reject If:
Transaction Type =
• Term Loan
• Line of Credit
Annual Update Required
Excel Data Format
02/072007
Numeric, "Don't Know", or "Not Applicable"
CIIS 4.1
21 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
BE
Annual Gross Revenue from Business Operations Reported During the Reporting Period
For business transactions, report the investee’s/borrower’s annual gross business revenue during
the most recent 12-month period for which the information is available.
Annual Update Required
Excel Data Format
BF
Numeric
Jobs at Reporting Period End
For business transactions, report the number of full-time equivalent (FTE) jobs in the business at
the reporting period end. One FTE is a 35-hour or more work week. In calculating FTEs, part-time
employees should be combined.
Example: 2 part-time employees that each work 17.5 hours equals one FTE (2 employees x 17.5
hours = 35 hours).
• Exclude construction jobs.
Purpose =
CONDITIONALLY REQUIRED IF:
• Business
• Microenterprise
Annual Update Required
Numeric, "Don't Know", or Not Applicable
Excel Data Format
BG
DS/FCOS Hours of Assistance Provided During Reporting Period
Report the total number of hours of Development Services (DS) that the CDFI provided to the
investee/borrower during the reporting period.
Annual Update Required
Excel Data Format
Numeric
Impact Profile
BH
Low-Income Status
Report the income status of the investee/borrower. See the CIIS Glossary for detailed definitions
of “Low-Income and “Very Low-Income.”
If there is more than one investee/borrower, respond for the primary investee/borrower.
If there is more than one primary investee/borrower, select the income status of the highest
income primary investee/borrower.
COMPLIANCE
Reject If:
Investee Type = CDFI
Crosswalk Values / Definitions
LOW
OTHER
Low-income
investee/borrower
Very low-income
investee/borrower
Other
NA
Not Applicable
VERYLOW
02/072007
CIIS 4.1
22 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
BI
Other Targeted Populations
Report whether the transaction serves an Other Targeted Population (OTP) as defined in the
CDFI’s Certification or Assistance Agreement. See the CIIS glossary for a detailed definition of
“Other Targeted Population.”
COMPLIANCE
Crosswalk Values / Definitions
BJ
YES
Yes
NO
No
LITP End Users
Report whether the transaction serves Low-Income Targeted Population (LITP) End Users. LITP
End Users are low-income and very low-income persons that benefit from a loan/investment made
to another investee/borrower.
Example: Residents of housing for which the CDFI made a construction or rehabilitation loan
may qualify as LITP End Users.
COMPLIANCE
YES
Yes
Crosswalk Values / Definitions
NO
BK
No
OTP End users
Report whether the transaction serves Other Targeted Population (OTP) End Users. OTP End
Users are persons of OTPs that benefit from a loan/investment made to another
investee/borrower.
Example: Residents of housing for which the CDFI made a construction or rehabilitation loan
may qualify as LITP End Users.
COMPLIANCE
YES
Yes
Crosswalk Values / Definitions
NO
BL
No
IA End users
Report whether the transaction serves Investment Area (IA) End Users. IA End Users are
residents of an IA that benefit from a loan/investment made to another investee/borrower for a
service or facility.
Example: Employees of a business or users of a community facility located in the IA may
qualify as IA End Users.
COMPLIANCE
YES
Yes
Crosswalk Values / Definitions
NO
BM
No
HZ End users
Report whether the transaction serves Hot Zone (HZ) End Users. HZ End Users are residents of
a HZ that benefit from a loan/investment made to another investee/borrower for a service or
facility.
Example: Employees of a business or users of a community facility located in the HZ may
qualify as HZ End Users.
COMPLIANCE
YES
Yes
Crosswalk Values / Definitions
NO
02/072007
No
CIIS 4.1
23 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
BN
Credit Score
If applicable, report the most recently collected credit score of the primary investee(s)/borrower(s).
If there is more than one investee/borrower, use the credit score of the primary
investee/borrower.
If there is more than one primary investee/borrower, report the highest credit score.
Credit Score is not applicable if the borrower is a corporation.
Investee Type =
Validations:
• Individual
• Business
Excel Data Format
Numeric
BO
Gender
If applicable, report the gender of the primary investee(s)/borrower(s).
If there is more than one investee/borrower, select the gender of the primary
investee/borrower.
If there is more than one primary investee/borrower, and at least one is male and one is
female, report "Both.”
If the investee/borrower is a corporation, report “Not Applicable.”
MALE
Male
Crosswalk Values / Definitions
FEMALE
Female
BOTH
Both
NA
Not Applicable
BP
Race
Report the race of the primary investee/borrower.
If there is more than one investee/borrower, select the race of the primary investee/borrower.
If there is more than one primary investee/borrower, select the race of one of them.
If the investee/borrower is of mixed race, report one of the races.
If the investee/borrower did not provide their race, report "Not Given.”
If the investee/borrower is a corporation, report “Not Applicable.”
AMIND
American Indian
Crosswalk Values / Definitions
ALASKAN
ASIAN
BLACK
HAWAIIAN
PACIFIC
WHITE
OTHER
NG
NA
02/072007
CIIS 4.1
Alaska Native
Asian
Black or African American
Native Hawaiian
Other Pacific Islander
White
Other
Not Given
Not Applicable
24 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
BQ
Hispanic Origin
Report whether the primary investee/borrower is Hispanic or Latino.
If there is more than one investee/investee, respond for the primary investee/borrower.
If there is more than one primary investee/borrower, report whether any of the
investee’s/borrower’s are Hispanic or Latino.
If the investee/borrower did not provide whether they are of Hispanic origin, report "Not
Given.”
If the investee/borrower is a corporation, report “Not Applicable.”
Crosswalk Values / Definitions
YES
Yes
NO
No
NG
Not Given
NA
Not Applicable
BR
Female Headed Household
Report whether the homebuyer is a single or separated woman who will be the primary support for
a household that includes at least one dependent or other qualifying individual as allowed by IRS
regulations. A single woman with no dependents does not qualify.
Crosswalk Values / Definitions
BS
Yes
No
First-Time Homebuyer
Report whether the homebuyer is a first-time homebuyer (has not owned a home during the threeyear period preceding the CDFI-assisted purchase of a principal residence).
If there is more than one borrower, respond for the primary borrower.
If there is more than one primary borrower, report whether at least one borrower qualifies as a
first-time homebuyer.
Purpose = Home Purchase
CONDITIONALLY REQUIRED IF:
Crosswalk Values / Definitions
BT
YES
NO
YES
Yes
NO
No
DK
Don't Know
NA
Not Applicable
Banked at Time of Intake
Report whether the investee/borrower had a bank or credit union account at the time of intake.
If there is more than one investee/borrower, respond for the primary investee/borrower.
If there is more than one primary investee/borrower, report whether at least one
investee/borrower was banked at the time of intake.
YES
Yes
Crosswalk Values / Definitions
NO
02/072007
No
CIIS 4.1
25 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
BU
Rejected by Bank or Credit Union
Report whether the investee/borrower was rejected by a bank or credit union for a similar
loan/investment within the 12 months prior to applying for this loan/investment. “Similar
loan/investment request” is defined as a loan/investment for the same or similar purpose and
amount.
If there is more than one investee/borrower, respond for the primary investee/borrower.
If there is more than one primary investee/borrower, report whether at least one
investee/borrower was rejected by a bank or credit union.
YES
Yes
Crosswalk Values / Definitions
NO
BV
BW
No
DS/FCOS Hours of Assistance at Time of Investment
Report the total cumulative hours of Development Services (DS) that the CDFI provided to the
investee/borrower from time of the initial intake until the origination of the Project.
Numeric
Excel Data Format
DS/FCOS Hours of Assistance – Post Loan/Investment
Report the total number of hours of Development Services (DS) that the CDFI provided to the
investee/borrower from origination to the end of the first reporting period which the loan/investment
is reported to the Fund. This is a one-time entry point per transaction.
Numeric
Excel Data Format
BX
Annual Gross Revenue from Business Operations At Time of Loan/Investment
For business transactions, report the investee's/borrower’s annual gross revenue during the most
recent 12-month period prior to Project origination for which the information is available.
Numeric
Excel Data Format
BY
Total Project Cost
Report the total cost of the Project being financed.
Include all sources of financing
Include the CDFI's portion of the financing.
Purpose = Consumer
Reject If:
Total Project Cost >= Original Loan/Investment Amount
Validations:
Total Project Cost >= Total Project Cost - Public Sources
Total Project Cost >= Total Project Cost – Affiliates &
Related Programs + Original Loan/Investment Amount
Total Project Cost < (Total Project Cost – Public
Sources) + (Total Project Cost - Affiliates & Related
Programs) + Original Loan/Investment Amount
Numeric
Excel Data Format
BZ
Total Project Cost – Public Sources
Report the portion (in dollars) of the Total Project Cost provided by public sources.
Include federal, state, and local government funds.
Exclude foundation grants.
Exclude CDFI funds.
Purpose = Consumer
Reject If:
02/072007
CIIS 4.1
26 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
Excel Data Format
CA
NEW
Numeric
Total Project Cost – Affiliates & Related Programs
Report the portion (in dollars) of the Total Project Cost provided by the CDFI’s affiliates and
related programs.
Numeric
Excel Data Format
Projected Impacts
CB
NEW
Projected Jobs to Be Created at Businesses Financed
For business Projects, report the number of full-time equivalent (FTE) jobs projected to be
created in the business due to this financing. One FTE is a 35-hour or more work week. In
calculating FTEs, part-time employees should be combined.
Example: 2 part-time employees that each work 17.5 hours equals one FTE (2 employees x 17.5
hours = 35 hours).
Exclude construction jobs.
Purpose =
CONDITIONALLY REQUIRED IF:
• Business
• Microenterprise
Purpose = Real Estate
Reject If:
Excel Data Format
CC
NEW
Projected Jobs to Be Created - Construction
For real estate Projects, report the number of construction jobs projected to be created in the due
to this financing.
Purpose = Real Estate
CONDITIONALLY REQUIRED IF:
Reject If:
Excel Data Format
CD
NEW
NEW
Purpose =
• Business
• Microenterprise
Number, “Don’t Know”, or Not Applicable
Projected Jobs to Be Created at Tenant Businesses
For business Projects, report the number of full-time equivalent (FTE) jobs projected to be created
in business located at the property financed. One FTE is a 35-hour or more work week. In
calculating FTEs, part-time employees should be combined.
Example: 2 part-time employees that each work 17.5 hours equals one FTE (2 employees x 17.5
hours = 35 hours).
Exclude construction jobs.
Purpose NOT = Real Estate
Reject If:
Excel Data Format
CE
Number, “Don’t Know”, or Not Applicable
Number, “Don’t Know”, or Not Applicable
Community Facility
Report whether the project financed is a community facility. If the project is a community facility,
CIIS requires the user to provide a numeric response greater than zero or “Don’t Know” to at least
one of the Community Facility Capacity data points that follow.
Crosswalk Values
02/072007
YES
Yes
CIIS 4.1
27 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
NO
Excel Data Format
CF
NEW
CG
NEW
CH
NEW
CI
NEW
CJ
NEW
No
Don’t Know
Capacity of Educational Community Facility
If the project financed includes an educational facility, report the number of student seats
available in the school.
• Community Facility = YES AND
CONDITIONALLY REQUIRED IF:
• All other Capacity of Community Facility data points are
blank or “Not Applicable.”
Number, “Don’t Know”, or Not Applicable
Excel Data Format
Capacity of Childcare Community Facility
If the project financed includes a childcare facility, report the number of childcare slots available
in the facility.
• Community Facility = YES AND
CONDITIONALLY REQUIRED IF:
• All other Capacity of Community Facility data points are
blank or “Not Applicable.”
Number, “Don’t Know”, or Not Applicable
Excel Data Format
Capacity of Healthcare Community Facility
If the project financed includes a healthcare facility, report the projected number of patients
served per year.
• Community Facility = YES AND
CONDITIONALLY REQUIRED IF:
• All other Capacity of Community Facility data points are
blank or “Not Applicable.”
Number, “Don’t Know”, or Not Applicable
Excel Data Format
Capacity of Arts Center Community Facility
If the project financed includes an arts center, report the capacity of the arts center.
Example: If the project is a theater, report the seating capacity
• Community Facility = YES AND
CONDITIONALLY REQUIRED IF:
• All other Capacity of Community Facility data points are
blank or “Not Applicable.”
Number, “Don’t Know”, or Not Applicable
Excel Data Format
Capacity of Other Community Facility
If the project financed is a community facility that serves a purpose other than education,
childcare, healthcare, or arts, report the capacity related to that other purpose.
• Community Facility = YES AND
CONDITIONALLY REQUIRED IF:
• All other Capacity of Community Facility data points are
blank or “Not Applicable.”
Number, “Don’t Know”, or Not Applicable
Excel Data Format
02/072007
CIIS 4.1
28 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
CK
NEW
Square Feet of Real Estate - Total
For real estate Projects, report the total number of square feet that are expected to be
constructed, rehabilitated, or acquired with funding from the transaction.
Purpose = Real Estate
CONDITIONALLY REQUIRED IF:
Validations:
Reject If:
Excel Data Format
Square Feet of Real Estate – Total >= (Square Feet of
Real Estate – Manufacturing) + (Square Feet of Real
Estate – Office) + (Square Feet of Real Estate – Retail)
Purpose =
• Business
• Microenterprise
Number, “Don’t Know”, or Not Applicable
CL
Square Feet of Real Estate - Manufacturing
For real estate Projects, report the number of square feet of manufacturing space that are
expected to be constructed, rehabilitated, or acquired with funding from the transaction.
• Purpose = Real Estate
CONDITIONALLY REQUIRED IF:
• XML / Excel – “Not Applicable” option in Crosswalk NOT
selected.
Purpose =
Reject If:
• Business
• Microenterprise
Number or “Don’t Know”
Excel Data Format
CM
Square Feet of Real Estate - Office
For real estate Projects, report the number of square feet of office space that are expected to be
constructed, rehabilitated, or acquired with funding from the transaction.
• Purpose = Real Estate
CONDITIONALLY REQUIRED IF:
• XML / Excel – “Not Applicable” option in Crosswalk NOT
selected.
Purpose =
Reject If:
• Business
• Microenterprise
Number or “Don’t Know”
Excel Data Format
CN
Square Feet of Real Estate – Retail
For real estate Projects, report the number of square feet of retail space that are expected to be
constructed, rehabilitated, or acquired with funding from the transaction.
• Purpose = Real Estate
CONDITIONALLY REQUIRED IF:
• XML / Excel – “Not Applicable” option in Crosswalk NOT
selected.
Purpose =
Reject If:
• Business
• Microenterprise
Number or “Don’t Know”
Excel Data Format
02/072007
CIIS 4.1
29 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
CO
Asking Rent per Square Foot
For real estate Projects, report the proposed average asking rent per square foot per month for
any commercial space funded by the CDFI.
Purpose = Real Estate
Validations:
Excel Data Format
CP
Housing Units - Sale
For real estate Projects, report the number of for-sale housing units to be constructed,
rehabilitated, or acquired with funding from the transaction.
• Purpose = Real Estate
CONDITIONALLY REQUIRED IF:
• XML / Excel – “Not Applicable” option in Crosswalk NOT
selected.
• Housing Units – Sale < Affordable Housing Units – Sale
Reject If:
Excel Data Format
CQ
CR
Number or “Don’t Know”
Housing Units - Rental
For real estate projects, report the number of rental housing units to be constructed, rehabilitated,
or acquired with funding from the transaction.
• Purpose = Real Estate
CONDITIONALLY REQUIRED IF:
• XML / Excel – “Not Applicable” option in Crosswalk NOT
selected.
• Housing Units – Rental < Affordable Housing Units –
Reject If:
Rental
Number or “Don’t Know”
Excel Data Format
Affordable Housing Units – Sale
Of the total Housing Units – Sale to be rehabilitated, constructed, or acquired with funding from
this transaction, report the number that are projected to be affordable housing units.
• Purpose = Real Estate
CONDITIONALLY REQUIRED IF:
• XML / Excel – “Not Applicable” option in Crosswalk NOT
selected.
Purpose = Real Estate
Validations:
Excel Data Format
CS
Number
Number or “Don’t Know”
Affordable Housing Units - Rental
Of the total Housing Units – Rental to be rehabilitated, constructed, or acquired with funding from
this transaction, report the number that are projected to be affordable housing units.
• Purpose = Real Estate
CONDITIONALLY REQUIRED IF:
• XML / Excel – “Not Applicable” option in Crosswalk NOT
selected.
Purpose = Real Estate
Validations:
Excel Data Format
02/072007
Number or “Don’t Know”
CIIS 4.1
30 of 31
FY 2006 CDFI Transaction Level Report: Data Point Guidance
CT
Other Impact (1) Explain
If the Organization measures a community development impact(s) that is not covered above,
Users may report this as an “Other Impact.” Include only quantitative impacts that the CDFI has
measured during the reporting period.
Excel Data Format
CU
Text
Other Impact (1) Number of Units
If the Organization reported an Other Impact (1) Explain, report the number of units accomplished
for this impact during the reporting period.
Other Impact (1) Explain reported.
CONDITIONALLY REQUIRED IF:
Excel Data Format
Numeric
CV
Other Impact (2) Explain
If the Organization measures a community development impact(s) that is not covered above,
Users may report this as an “Other Impact.” Include only quantitative impacts that the CDFI has
measured during the reporting period.
Text
Excel Data Format
CW
Other Impact (2) Number of Units
If the Organization reported an Other Impact (2) Explain, report the number of units accomplished
for this impact during the reporting period.
Other Impact (2) Explain reported.
CONDITIONALLY REQUIRED IF:
Excel Data Format
02/072007
Numeric
CIIS 4.1
31 of 31
| File Type | application/pdf |
| Author | kaltobello |
| File Modified | 2007-02-07 |
| File Created | 2006-10-26 |