<CDFITRANSACTION> - Sub Element of <LOAN>

NLS 5.0.1

Contact must be associated with a CDFI record.


Attribute Type Size REQ Default Comments
ProjectNumber String 8 No    
Purpose Numeric 2 No 0 0 = Consumer
1 = Business
2 = Microenterprise
3 = Home Purchase
4 = Home Improvement
5 = Const/Permanent/ACQ w-o Rehab - Commercial
6 = Const - Housing - Multi Family
7 = Const - Housing - Single Family
8 = Const - Rehab - Commercial
9 = Const - Rehab - Multi Family
10 = Const - Rehab - Single Family
11 = Other
AmortizationType Numeric 1 No 0 0 = Fully Amortized
1 = Partially Amortized
2 = Non Amortizing
3 = Other
InterestType5.35.7-
Numeric 1 No 0 0 = Fixed
1 = Variable
InterestType5.35.8+
Numeric 1 No 0 0 = Fixed
1 = ADJ
EquityLikeFeatures Numeric 1 No 0 0 = None
1 = Convertible Debt
2 = Performance-based Interest Rate
3 = Royalties
4 = Warrants
5 = Other
LienPosition Numeric 1 No 0 0 = FIrst
1 = Second
2 = Unsecured Debt
3 = Other
Guarantee Numeric 1 No 0 0 = None
1 = SBA
2 = USDA
3 = Other Federal Government
4 = Personal Guarantee
5 = Other
TransactionType Numeric 1 No 0 0 = Term Loan
1 = Equity Investment
2 = Line of Credit
3 = Debt with Equity
4 = Other
CollateralType Numeric 1 No 0 0 = None
1 = Real Estate
2 = Other Real Estate
3 = Vehicle
4 = Equipment
5 = Inventory
6 = Receivables
7 = Home Equity
8 = Other
OriginalCollateralValue Numeric 16,2 No 0  
OriginalInvestmentAmt Numeric 16,2 No 0  
EquityInjectionAmt Numeric 16,2 No 0  
OriginationDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
FirstPaymentDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
Term Numeric 3 No 0 Term in months
InterestRate Numeric 12,8 No 0  
Points Numeric 16,2 No 0  
OriginationFees Numeric 16,2 No 0  
LoanStatus Numeric 1 No 0 0 = Active
1 = Closed in Good Standing
2 = Sold
3 = Charged Off
4 = Refinanced
FairValue Numeric 16,2 No 0 Fair value at origination
FairValueEndOfPeriod Numeric 16,2 No 0 Fair value at period end
NumberTimesRefinanced Numeric 2 No 0  
RefinancedOrigTransID String 50 No    
NumberTimesRestructured Numeric 2 No 0  
AnnualGrossRevenue Numeric 16,2 No 0 -1.00 = Controlled by Contact
JobsAtPeriodEnd Numeric 7,2 No 0 -1.00 = Controlled by Contact
StreetAddress1 String 50 No    
StreetAddress2 String 50 No    
City String 50 No    
State String 3 No    
ZIP String 10 No    
FIPSCode String 11 No    
JobType Numeric 1 No 0 0 = Not Applicable
1 = Direct Jobs
2 = Direct and Indirect Jobs
JobsCreated Numeric 9,2 No 0 -1.00 = Not Applicable
JobsCreatedConst Numeric 9,2 No 0 -1.00 = Not Applicable
JobsCreatedTenant Numeric 9,2 No 0 -1.00 = Not Applicable
TotalRealEstateArea Numeric 9 No 0 -1 = Not Applicable
AreaManufacturing Numeric 9 No 0 -1 = Not Applicable
AreaOffice Numeric 9 No 0 -1 = Not Applicable
AreaRetail Numeric 9 No 0 -1 = Not Applicable
AskingRentSQFT Numeric 16,2 No 0  
HousingUnitsSale Numeric 5 No 0 -1 = Not Applicable
HousingUnitsRental Numeric 5 No 0 -1 = Not Applicable
AffHousingUnitsSale Numeric 5 No 0 -1 = Not Applicable
AffHousingUnitsRental Numeric 5 No 0 -1 = Not Applicable
OtherImpact1Expl String 50 No    
OtherImpact1Units Numeric 5 No 0  
OtherImpact2Expl String 50 No    
OtherImpact2Units Numeric 5 No 0  
TotalProjectCost Numeric 16,2 No 0  
CommunityFacilityCap Numeric 1 No 0 0 = No
1 = Yes
2 = Don’t Know
EducationalFacilityCap Numeric 9,2 No 0 -1.00 = Not Applicable
ChildcareFacilityCap Numeric 9,2 No 0 -1.00 = Not Applicable
HealthcareFacilityCap Numeric 9,2 No 0 -1.00 = Not Applicable
ArtsCenterFacilityCap Numeric 9,2 No 0 -1.00 = Not Applicable
OtherFacilityCap Numeric 9,2 No 0 -1.00 = Not Applicable
IncludeInReportFlag Numeric 1 No 0 0 = No
1 = Yes
ForgivableLoan Numeric 1 No 0 0 = No
1 = Yes
FAProgramType5.13+
Numeric 1 No 0 0 = PPC-FA – Persistent Poverty Counties
1 = HFFI-FA – Healthy Food Financing Initiative
2 = DF-FA – Disability Funds
3 = FA – Other Financial Assistance
4 = RRP-FA – Rapid Response Program5.35.8
SourceOfJobsEstimate Numeric 1 No 0 0 = Not Applicable
1 = New Financing
2 = Wage Data
3 = Economic Impact
4 = Rule of Thumb
5 = Other
SourceOfJobsOther String 25 No   Jobs Estimate Other
LITPEndUsers Numeric 1 No -1 -1 = Controlled by Contact
0 = No
1 = Yes
2 = Not Applicable
OTPEndUsers Numeric 1 No -1 -1 = Controlled by Contact
0 = No
1 = Yes
2 = Not Applicable
IAEndUsers Numeric 1 No -1 -1 = Controlled by Contact
0 = No
1 = Yes
2 = Not Applicable
GrossRevAtTimeOfInv Numeric 16,2 No 0 -1.00 = Controlled by Contact
JobsTimeOfInvestment Numeric 7,2 No 0 -1.00 = Controlled by Contact
DPC Numeric 3 No 0 Delivery Point Code
DPType String 1 No   Address Type
DPVDatestamp Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
DP Verification Date
DPLatitude Numeric 9,6 No 0  
DPLongitude Numeric 9,6 No 0  
HffiFaTransaction Numeric 1 No 0 All Hffi* attributes are applicable only if HffiFaTransaction = 1
0 = No
1 = Yes
HffiAwardYear Numeric 4 No 0  
HffiType Numeric 1 No   HFFI_FA Activity
0 = Retail
1 = Nonretail
HffiOutletActivity Numeric 2 No   Applicable only if HffiType = 0:
0 = GROCERYSTORE
1 = MOBILEFOODMKT
2 = FARMERSMKT
3 = COOPERATIVE
4 = CORNERSTORE
5 = BODEGA
10 = OTHER

Applicable only if HffiType = 1:
6 = PRODUCTION
7 = DISTRIBUTION
8 = SALE
9 = CONSUMPTION
10 = Other
HffiOutletActivityOther String 50 No   Applicable only if HffiOutletActivity = 10
HffiIdentifierSource Numeric 1 No   0 = ERS
1 = TRF
2 = Other
HffiIdentifierSourceOther String 50 No   Applicable only if HffiIdentifierSource = 2
HffiTotalRetail Numeric 10 No 0 Total number of new retail healthy food outlets
-1 = Not Applicable
HffiTotalNonRetail Numeric 10 No 0 Total number of new non-retail healthy food lending activities
-1 = Not Applicable
HffiSquareFeetRetail Numeric 10 No 0 Square footage of new retail healthy food outlets
-1 = Not Applicable
HffiSquareFeetNonRetail Numeric 10 No 0 Square footage of new non-retail healthy food outlets
-1 = Not Applicable
HffiTargetMarket Numeric 1 No   0 = INVESTMENTAREAS
1 = TARGETEDPOP
HffiDescription String 50 No