CDE QuickStart by BC9Wm7I

VIEWS: 4 PAGES: 14

									                                                                                                         717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                         Project or      Excel                                                                            Annual                                 Borrower/
                                         Financial     Worksheet:      New Field Mandatory     Field is Conditionally                     Update     Transaction                  Investee
CIIS TLR Data Field                      Note Field     Column          (CIIS 9.0) Field            Required If…             Compliance   Required      Type        Purpose         Type   QLICI Type   SPE                            Special Instructions
Project and Financial Note Identifiers
Submitter Transmission ID                                 Notes-
                                                      Investments: A
Project Number                               P          Projects: A                                                                                                                                           Use "Project Number" to link Financial Notes to a Project.
                                                                                                                                                                                                              "Project Number" must be consistent across report years.
                                                                                                                                                                                                               In the Excel Template, "Project Number" is required on multiple
                                                                                                                                                                                                              worksheets including, Notes-Investments: B and Addresses: A.
                                                                                                                                                                                                               Numeric field with a maximum of 8 digits.

Originator Transaction ID                   FN            Notes-
                                                      Investments: C
                                                                                                                                                                                                              "Originator Transaction ID" must be consistent across report
                                                                                                                                                                                                              years.
                                                                                                                                                                                                               In the Excel Template, "Originator Transaction ID" is required on
                                                                                                                                                                                                              multiple worksheets including Disbursements: A.

FINANCIAL NOTES DATA
Terms
Date Originated                             FN            Notes-
                                                      Investments: D
                                                                                    
Original Loan/Investment Amount             FN            Notes-
                                                      Investments: E
                                                                                                                                            
Refinancing                                 FN            Notes-
                                                      Investments: F
                                                                                                                                                       Debt

Purpose                                     FN            Notes-
                                                      Investments: G
                                                                                    
Construction or Permanent Financing         FN            Notes-
                                                      Investments: H
                                                                                              Purpose = Real Estate -                                             Real Estate
                                                                                             Construction/Permanent/Acq
                                                                                                 uisition w/o Rehab-
                                                                                                     Commercial

Take-out or Acquisition Financing           FN            Notes-
                                                      Investments: I
                                                                                                 Construction or                                                  Real Estate
                                                                                               Permanent Financing =
                                                                                                 Permanent or Both
                                                                                             Construction and Permanent

Acquisition or Rehabilitation               FN            Notes-
                                                      Investments: J
                                                                                              Purpose = Real Estate -                                             Real Estate
                                                                                             Rehabilitation - Commercial

Rehabilitation Amount                       FN            Notes-
                                                      Investments: K
                                                                                                  Acquisition or                                                  Real Estate                                wValidation: Reject if Rehabilitation Amount is > (is greater
                                                                                             Rehabilitation = Acquisition                                                                                     than) the Original Loan/Investment Amount,
                                                                                                 and Rehabilitation
Loan Origination Fees                       FN            Notes-
                                                      Investments: L
                                                                                              Transaction Type = Term                                  Debt
                                                                                             Loan, Line of Credit, or Debt
                                                                                                      with Equity
Use of Loan Origination Fees                FN            Notes-
                                                      Investments: M
                                                                                              Origination Fees > 0 and                                 Debt                                                   Options include:
                                                                                                  Date Originated >
                                                                                                     12/31/2005



Transaction Type                            FN            Notes-
                                                      Investments: N
                                                                                    
Interest Rate at Origination                FN            Notes-
                                                      Investments: O
                                                                                              Transaction Type = Term                                  Debt
                                                                                             Loan, Line of Credit, or Debt
                                                                                                with Equity and Date
                                                                                               Originated > 12/31/2005

Interest Rate                               FN            Notes-
                                                      Investments: P
                                                                                              Transaction Type = Term                                 Debt
                                                                                             Loan, Line of Credit, or Debt
                                                                                                      with Equity
Interest Type                               FN            Notes-
                                                      Investments: Q
                                                                                              Transaction Type = Term                                  Debt
                                                                                             Loan, Line of Credit, or Debt
                                                                                                      with Equity
Points                                      FN            Notes-
                                                      Investments: R
                                                                                              Transaction Type = Term                                  Debt
                                                                                               Loan or Debt with Equity

              11/15/2011                                                                                                            Page 1 of 14
                                                                                                              717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                            Project or       Excel                                                                              Annual                             Borrower/
                                            Financial     Worksheet:        New Field Mandatory     Field is Conditionally                      Update     Transaction              Investee
CIIS TLR Data Field                         Note Field      Column           (CIIS 9.0) Field            Required If…             Compliance    Required      Type       Purpose      Type   QLICI Type   SPE                          Special Instructions
Amortization Type                               FN           Notes-
                                                         Investments: S
                                                                                                   Transaction Type = Term                                    Debt
                                                                                                  Loan, Line of Credit, or Debt
                                                                                                           with Equity
Period of Interest Only Payments (in
months)
                                               FN            Notes-
                                                         Investments: T
                                                                                                   Transaction Type = Term                                   Debt                                               "Period of Interest Only Payments (in months)" is a numeric field
                                                                                                                                                                                                                with no decimals.
                                                                                                              Loan
Term (in months)                               FN            Notes-
                                                         Investments: U
                                                                                                   Transaction Type = Term                                  Debt
                                                                                                  Loan, Line of Credit, or Debt
                                                                                                           with Equity
Date First Payment Due                         FN             Notes-                                                                                          Debt
                                                          Investments: V
Guarantee                                      FN             Notes-
                                                         Investments: W
                                                                                                   Transaction Type = Term                                   Debt
                                                                                                  Loan, Line of Credit, or Debt
                                                                                                           with Equity
Lien Position                                  FN            Notes-
                                                         Investments: X
                                                                                                   Transaction Type = Term                                   Debt
                                                                                                  Loan, Line of Credit, or Debt
                                                                                                           with Equity
Collateral Type                                FN            Notes-
                                                         Investments: Y
                                                                                                   Transaction Type = Term                                   Debt
                                                                                                  Loan, Line of Credit, or Debt
                                                                                                           with Equity
Collateral Value at Origination                FN            Notes-
                                                         Investments: Z
                                                                                                   Transaction Type = Term                                   Debt
                                                                                                  Loan, Line of Credit, or Debt
                                                                                                           with Equity
Equity-Like Features                           FN             Notes-
                                                         Investments: AA
                                                                                                   Transaction Type = Debt                                 Debt with
                                                                                                                                                             Equity
                                                                                                           with Equity
Equity Injection Amount                        FN             Notes-
                                                         Investments: AB
Advance Purchase Commitment                    FN             Notes-
                                                         Investments: AC
                                                                                                    QLICI Type = QALICB                                                                     QALICB

Seller Organization                            FN             Notes-
                                                         Investments: AD
                                                                                                     Advance Purchase                                                                       QALICB
                                                                                                       Commitment = Yes
Better Rates & Terms (FN)
Equity Product                                 FN             Notes-
                                                         Investments: AE
                                                                                                                                     
Equity-Equivalent Terms & Conditions           FN             Notes-
                                                         Investments: AF
                                                                                                                                     
Debt with Equity Features                      FN             Notes-
                                                         Investments: AG
                                                                                                                                                                                                               Validation: If Debt with Equity Features = YES AND Transaction
                                                                                                                                                                                                                Type = Term Loan or Line of Credit , CIIS will reject the transaction.

Subordinated Debt                              FN             Notes-
                                                         Investments: AH
                                                                                                                                     
Below Market Interest Rate at Origination      FN             Notes-
                                                          Investments: AI
                                                                                                                                                                                                               wValidation: If Below Market Interest Rate at Origination = NA
                                                                                                                                                                                                                AND Transaction Type ≠ Equity Investment, CIIS will reject the
                                                                                                                                                                                                                transaction.
Comparable Interest Rate at Origination        FN            Notes-
                                                         Investments: AJ
                                                                                                    Below Market Interest
                                                                                                   Rate at Origination = Yes
                                                                                                    and Date Originated >
                                                                                                           12/31/2005
Below Market Interest Rates or Flexible
Terms Required under Allocation
                                               FN             Notes-
                                                         Investments: AK
                                                                                                                                                                                                                CIIS Values are "YES", "NO", and "NA"

Agreement (Financial Note)
Below Market Interest Rate (Financial
Note)
                                               FN            Notes-
                                                         Investments: AL
                                                                                                                                                                                                              wValidation: If Below Market Interest Rate (Financial Note) = NA
                                                                                                                                                                                                                AND Transaction Type ≠ Equity Investment, CIIS will reject the
                                                                                                                                                                                                                transaction.
What is Interest Rate Comparable?              FN             Notes-
                                                         Investments: AM
                                                                                                    Below Market Interest                                    Debt                                               Options include:
                                                                                                  Rate (Financial Note) = Yes
                                                                                                    and Date Originated >
                                                                                                           12/31/2005

Interest Rate Comparable Other                 FN             Notes-
                                                         Investments: AN
                                                                                                     What is Interest Rate                                   Debt                                               User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                                Comparable
                                                                                                  Interest Rate Comparable?
                                                                                                            = Other
Lower than Standard Origination Fees
(Financial Note)
                                               FN             Notes-
                                                         Investments: AO
                                                                                                                                     
             11/15/2011                                                                                                                   Page 2 of 14
                                                                                                         717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                           Project or        Excel                                                                        Annual                             Borrower/
                                           Financial      Worksheet:    New Field Mandatory     Field is Conditionally                    Update     Transaction              Investee
CIIS TLR Data Field                        Note Field       Column       (CIIS 9.0) Field            Required If…           Compliance    Required      Type       Purpose      Type   QLICI Type   SPE                          Special Instructions
What is Standard Origination Fees              FN            Notes-
                                                        Investments: AP
                                                                                                Lower than Standard                                     Debt                                              Options include:
(Financial Note) Comparable?                                                                  Origination Fees (Financial
                                                                                                Note) = Yes and Date
                                                                                               Originated > 12/31/2005

Standard Origination Fees (Financial          FN             Notes-
                                                        Investments: AQ
                                                                                                  What is Standard                                     Debt                                               User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                          Comparable
Note) Comparable Other                                                                        Origination Fees (Financial
                                                                                              Note) Comparable? = Other

Standard Origination Fees (Financial
Note)
                                              FN             Notes-
                                                        Investments: AR
                                                                                                Lower than Standard                                    Debt                                               Numeric field with no decimals.
                                                                                              Origination Fees (Financial
                                                                                                      Note) = Yes
Longer than Standard Period of Interest
Only Payments
                                              FN             Notes-
                                                        Investments: AS
                                                                                                                                                                                                        wValidation: If Longer than Standard Period of Interest Only
                                                                                                                                                                                                          Payments = NA AND Transaction Type ≠ Equity Investment, CIIS
                                                                                                                                                                                                          will reject the transaction.
Standard Period of Interest Only
Payments (in months)
                                              FN            Notes-
                                                        Investments: AT
                                                                                                Longer than Standard                                   Debt                                               Numeric field with no decimals.
                                                                                                Period of Interest Only
                                                                                                   Payments = Yes
What is Standard Period of Interest           FN             Notes-
                                                        Investments: AU
                                                                                                Longer than Standard                                   Debt                                               Options include:
Comparable?                                                                                    Period of Interest Only
                                                                                              Payments = Yes and Date
                                                                                               Originated > 12/31/2005

Standard Period of Interest                   FN             Notes-
                                                        Investments: AV
                                                                                               What is Standard Period                                 Debt                                               User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                          Comparable
Comparable Other                                                                              of Interest Comparable? =
                                                                                                          Other
Longer than Standard Amortization Period      FN             Notes-
                                                        Investments: AW
                                                                                                                                                                                                        wValidation: If Longer than Standard Period of Interest Only
                                                                                                                                                                                                          Payments = NA AND Transaction Type ≠ Equity Investment, CIIS
                                                                                                                                                                                                          will reject the transaction.
                                                                                                                                                                                                          wUser may enter up to 150 characters to describe the   "Other"
                                                                                                                                                                                                          Comparable
Standard Amortization Period (in months)      FN             Notes-
                                                        Investments: AX
                                                                                               If Longer than Standard                                 Debt                                               Numeric field with no decimals.
                                                                                               Amortization Period = Yes

What is Standard Amortization Period          FN             Notes-
                                                        Investments: AY
                                                                                                Longer than Standard                                   Debt                                               Options include: .
Comparable?                                                                                    Amortization Period = Yes
                                                                                                and Date Originated >
                                                                                                      12/31/2005

Standard Amortization Period                  FN            Notes-
                                                        Investments: AZ
                                                                                                  What is Standard                                     Debt                                               User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                          Comparable
Comparable Other                                                                                 Amortization Period
                                                                                                 Comparable? = Other
Nontraditional Forms of Collateral            FN             Notes-
                                                        Investments: BA
                                                                                                                               
Traditional Form of Collateral                FN             Notes-
                                                        Investments: BB
                                                                                               Nontraditional Forms of                                                                                    "Traditional Form of Collateral" has the same CIIS values as
                                                                                                                                                                                                          "Collateral Type" (see crosswalk).
                                                                                                    Collateral = Yes
What is Traditional Form of Collateral        FN             Notes-
                                                        Investments: BC
                                                                                               Nontraditional Forms of                                                                                    Options include: .
Comparable?                                                                                    Collateral = Yes and Date
                                                                                                Originated > 12/31/2005


Traditional Form of Collateral                FN             Notes-
                                                        Investments: BD
                                                                                               What is Traditional Form                                                                                   User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                          Comparable
Comparable Other                                                                              of Collateral Comparable? =
                                                                                                          Other
Reporting Period Activity
Loan Status                                   FN             Notes-
                                                        Investments: BE
                                                                                                                                            




             11/15/2011                                                                                                             Page 3 of 14
                                                                                                        717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                          Project or      Excel                                                                           Annual                             Borrower/
                                          Financial    Worksheet:     New Field Mandatory     Field is Conditionally                      Update     Transaction              Investee
CIIS TLR Data Field                       Note Field     Column        (CIIS 9.0) Field            Required If…             Compliance    Required      Type       Purpose      Type   QLICI Type   SPE                          Special Instructions
Not Yet Disbursed / Projected QEI             FN     Disbursements: B                          Disbursement fields                         
                                                                                                 (Disbursement ID,
                                                                                             Disbursement Date, Total
                                                                                              Disbursement Amount,
                                                                                               Disbursement Source,
                                                                                              Source Amount) are not
                                                                                                     populated
Disbursement ID                              FN     Disbursements: C                                Not Yet                                                                                             Users may enter multiple "Disbursement IDs" (one ID for each
                                                                                                                                                                                                          disbursement).
                                                                                            Disbursed/Projected QEI is
                                                                                                  not populated
Disbursement Date                            FN     Disbursements: D                                Not Yet                                                                                             Users may enter multiple "Disbursement Dates" (one date for
                                                                                                                                                                                                          each "Disbursement ID").
                                                                                            Disbursed/Projected QEI is
                                                                                                  not populated
Total Disbursement Amount                    FN     Disbursements: E                                Not Yet                                                                                             Users may enter multiple "Disbursement Amounts" (one amount
                                                                                                                                                                                                          for each "Disbursement ID").
                                                                                            Disbursed/Projected QEI is
                                                                                                  not populated
Disbursement Source                          FN     Disbursements: F                                Not Yet                                                                                             "Disbursement Sources" references the QEI(s) that sourced the
                                                                                                                                                                                                          disbursement. Users may enter multiple "Disbursement Sources"
                                                                                            Disbursed/Projected QEI is
                                                                                                                                                                                                          (one source for each QEI that sourced the "Disbursement ID.")
                                                                                                  not populated

Source Amount                                FN     Disbursements: G                                Not Yet                                                                                             "Disbursement Amount" references the amount of the QEI that
                                                                                                                                                                                                          sourced the disbursement. Users may enter multiple "Source
                                                                                            Disbursed/Projected QEI is
                                                                                                                                                                                                          Amounts" (one amount for each QEI that sourced the
                                                                                                  not populated
                                                                                                                                                                                                          "Disbursement ID.")
QLICI Level                                  FN           Notes-
                                                     Investments: BF
                                                                                                                                           
Principal Balance Outstanding                FN           Notes-
                                                     Investments: BG
                                                                                             Transaction Type = Term                                  Debt
                                                                                            Loan, Line of Credit, or Debt
                                                                                                     with Equity
Days Delinquent                              FN            Notes-
                                                     Investments: BH
                                                                                                                                                       Debt

Number of Time 60 Days or More
Delinquent
                                             FN            Notes-
                                                       Investments: BI
                                                                                                                                                       Debt

Number of Times Loan was Restructured        FN            Notes-
                                                      Investments: BJ
                                                                                                                                                       Debt

Amount Charged Off                           FN            Notes-
                                                     Investments: BK
                                                                                                                                                       Debt

Amount Recovered                             FN            Notes-
                                                      Investments: BL
                                                                                                                                                       Debt

Fair Value at End of Reporting Period        FN            Notes-
                                                     Investments: BM
                                                                                               Transaction Type =                                     Equity
                                                                                                 Equity Investment
Projected Internal Rate of Return            FN           Notes-
                                                     Investments: BN
                                                                                               Transaction Type =                                      Equity                                             Numeric field with 3 decimals.
                                                                                                                                                                                                           Validation: If Transaction Type = Term Loan or Line of Credit,
                                                                                            Equity Investment AND Date
                                                                                                                                                                                                          CIIS will reject any response to Projected Internal Rate of Return
                                                                                             Originated is > 12/31/2005

Projected Residual Value of the QLICI        FN           Notes-
                                                     Investments: BO
                                                                                              QLICI Type = QALICB                                                                      QALICB            Projected Grant to QALICB been changed to: Projected Residual
                                                                                                                                                                                                          Value of QLICI that may be obtained by the QALICB
that may be obtained by the QALICB                                                           AND Date Originated is >
                                                                                                                                                                                                           Numeric field with no decimals and “NA” [Not Applicable] options
                                                                                                  12/31/2010

PROJECTS DATA
Total Project Cost
Total Project Cost                            P        Projects: B                                                                                                                                        "Total Project Cost" includes the CDE's contribution.
Total Project Cost – Public Sources           P        Projects: C                              Date Originated >                                                                                         "Total Project Cost - Public Sources" is a subset of "Total
                                                                                                                                                                                                          Project Cost."
                                                                                                     12/31/2009
Total Project Cost – Other CDEs,
Affiliates & Related Program
                                              P        Projects: D                              Date Originated >                                                                                         "Total Project Cost – Other CDEs, Affiliates & Related Program"
                                                                                                                                                                                                          is a subset of "Total Project Cost."
                                                                                                     12/31/2009
Total Project Cost – Private Investment       P        Projects: E                              Date Originated >                                                                                         "Total Project Cost – Total Project Cost – Private Investment" is
                                                                                                                                                                                                          a subset of "Total Project Cost."
                                                                                                     12/31/2009
Underwriting Criteria
Loan-to-Value Ratio                           P         Projects: F                            Transaction Type =                                      Debt                                               Numeric field with 3 decimals.
                                                                                                     Term Loan
Projected Debt Service Coverage Ratio         P        Projects: G                             Transaction Type =                                      Debt                                               Numeric field with 3 decimals.
                                                                                                     Term Loan
              11/15/2011                                                                                                            Page 4 of 14
                                                                                            717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                 Project or     Excel                                                                     Annual                             Borrower/
                                 Financial    Worksheet:     New Field Mandatory   Field is Conditionally                 Update     Transaction              Investee
CIIS TLR Data Field              Note Field    Column         (CIIS 9.0) Field          Required If…         Compliance   Required      Type       Purpose      Type   QLICI Type     SPE                             Special Instructions
Loan Loss Reserve Requirement        P        Projects: H                           Transaction Type =                                  Debt                                                   Numeric field with no decimals.
                                                                                         Term Loan
Investee Profile
Client ID                            P         Projects: I
QLICI Type                           P         Projects: J                                                      
Investee Type                        P         Projects: K                
Investee TIN                         P         Projects: L                           QLICI Type = CDE                                                                     CDE                  Validation: If QLICI Type = QALICB, CIIS will reject any
                                                                                                                                                                                               response to "Investee TIN".
Date Business Established            P         Projects: M                                                                                                                           Parent
                                                                                                                                                                                    Company
Entity Structure                     P         Projects: N                           Date Originated >                                                      Business                Parent
                                                                                                                                                                                    Company
                                                                                         12/31/2010
Minority Owned or Controlled         P         Projects: O                                                                                                   Business                Parent
                                                                                                                                                                                    Company
Women Owned or Controlled            P         Projects: P                                                                                                   Business                Parent
                                                                                                                                                                                    Company
Low Income Owned or Controlled       P         Projects: Q                                                                                                   Business                Parent
                                                                                                                                                                                    Company
Gender                               P         Projects: R                                                                                                   Individual
Race                                 P         Projects: S                                                                                                   Individual
Hispanic Origin                      P         Projects: T                                                                                                   Individual
Credit Score                         P         Projects: U                                                                                                                           Parent
                                                                                                                                                                                    Company
Business Description Primary         P         Projects: V                          QLICI Type = QALICB                                                                 QALICB               wOptions include: .



                                                                                                                                                                                               other office space (OFFICE)

                                                                                                                                                                                               warehousing space (INDUSTRIAL)




                                                                                                                                                                                               entertainment, or other amenities (ARTS)



Business Description - Other         P        Projects: W                           QLICI Type = QALICB                                                                  QALICB              w User may enter up to 150 characters to describe the    "Other"
                                                                                    Business Description
                                                                                       Primary = Other
NAICS                                P         Projects: X                           Date Originated >                                                                              Parent
                                                                                                                                                                                    Company
                                                                                         12/31/2009
Addresses
Investee Street Address Line 1       P        Addresses: B                                                                                                                         Parent
                                                                                                                                                                                    Company
Investee Street Address Line 2       P        Addresses: C                                                                                                                           Parent
                                                                                                                                                                                    Company
Investee City                        P        Addresses: D                                                                                                                         Parent
                                                                                                                                                                                    Company
Investee State                       P        Addresses: E                                                                                                                         Parent
                                                                                                                                                                                    Company
Investee Zip Code 5                  P        Addresses: F                                                                                                                         Parent
                                                                                                                                                                                    Company
Investee Zip Code +4                 P        Addresses: G                                                                                                                           Parent
                                                                                                                                                                                    Company
Investee FIPS Code                   P                                              CIIS unable to verify                                                                          Parent  CIIS will allow users to enter an "Investee FIPS Code" if the
                                                                                                                                                                                    Company system is unable to verify the Investee Address.
                                                                                      Investee Address
Investee X, Y Coordinates            P                                              CIIS unable to verify                                                                          Parent
                                                                                                                                                                                    Company
                                                                                                                                                                                               wCIIS will allow users to enter "X, Y Coordinates" if the system is
                                                                                      Investee Address                                                                                         unable to verify a Project Address.
Project Street Address Line 1        P        Addresses: H                                                                                                                                    CIIS accepts multiple Project Addresses.
Project Street Address Line 2        P        Addresses: I                                                                                                                                      CIIS accepts multiple Project Addresses.
Project City                         P        Addresses: J                                                                                                                                    CIIS accepts multiple Project Addresses.
Project State
               11/15/2011
                                     P        Addresses: K                                                       Page 5 of 14                                                                 CIIS accepts multiple Project Addresses.
                                                                                                     717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                         Project or      Excel                                                                      Annual                                 Borrower/
                                         Financial    Worksheet:     New Field Mandatory    Field is Conditionally                  Update     Transaction                  Investee
CIIS TLR Data Field                      Note Field     Column        (CIIS 9.0) Field           Required If…         Compliance    Required      Type        Purpose         Type   QLICI Type     SPE                             Special Instructions
Project Zip Code 5                           P        Addresses: L                                                                                                                                          CIIS accepts multiple Project Addresses.
Project Zip Code +4                          P        Addresses: M                                                                                                                                            CIIS accepts multiple Project Addresses.
Project FIPS Code                            P                                               CIIS unable to verify                                                                                          CIIS will allow users to enter a "Project FIPS Code" if the system
                                                                                                                                                                                                             is unable to verify a Project Address.
                                                                                                Project Address
Project X, Y Coordinates                     P                                               CIIS unable to verify                                                                                          wCIIS will allow users to enter "X, Y Coordinates" if the system is
                                                                                                Project Address                                                                                              unable to verify a Project Address.
Outcomes
Annual Gross Revenue from Business           P         Projects: Y                                                                                            Business                             Parent
Operations At Time of Loan/Investment                                                                                                                                                             Company

Annual Gross Revenue from Business
Operations Reported During the
                                             P         Projects: Z                                                                                           Business                             Parent
                                                                                                                                                                                                  Company
Reporting Period
Type of Jobs Reported                                 Projects: AA                          Purpose = Business,                                                                                             wValidation: If Purpose <> [not equal] "Business",
                                                                                            Microenterprise or Real                                                                                          "Microenterprise" and "Real-Estate", CIIS will reject any response
                                                                                                    Estate                                                                                                   to "Type of Jobs Reported."
                                                                                                                                                                                                             wOptions include:


Jobs at Time of Loan/Investment              P        Projects: AB                          Purpose = Business or                                            Business                             Parent
                                                                                                                                                                                                  Company
                                                                                                                                                                                                          ***The Don't Know Option has been removed. ***
                                                                                                Microenterprise
Jobs at Reporting Period End                 P        Projects: AC                          Purpose = Business or                                           Business                             Parent
                                                                                                                                                                                                  Company
                                                                                                                                                                                                          ***The Don't Know Option has been removed. ***
                                                                                                Microenterprise
Projected Jobs to be Created at
Businesses Financed
                                             P        Projects: AD                          Purpose = Business or                                            Business                             Parent
                                                                                                                                                                                                  Company
                                                                                                                                                                                                             ***The Don't Know Option has been removed. ***
                                                                                                Microenterprise                                                                                              w    Numeric field with 2 decimals and “NA” [Not Applicable]
                                                                                                                                                                                                             options.
                                                                                                                                                                                                             w   Validation: If Purpose <> [not equal] "Business" or
                                                                                                                                                                                                             "Microenterprise", CIIS will reject any response to "Projected Jobs
                                                                                                                                                                                                             to be Created at Businesses Financed".
Projected Jobs to be Created –
Construction
                                             P        Projects: AE                          Purpose = Real Estate                                           Real Estate                           Parent ***The Don't Know Option has been removed. ***
                                                                                                                                                                                                  Company  Numeric field with 2 decimals and “NA” [Not Applicable] options.
                                                                                                                                                                                                           Validation: If Purpose <> [not equal] "Real Estate", CIIS will
                                                                                                                                                                                                          reject any response to "Projected Jobs to be Created
                                                                                                                                                                                                          Construction".

Projected Jobs to be Created at Tenant       P        Projects: AF                                                                                           Real Estate                                     ***The Don't Know Option has been removed. ***
Businesses                                                                                                                                                                                                    Numeric field with 2 decimals and “NA” [Not Applicable] options.
                                                                                                                                                                                                              Validation: If Purpose <> [not equal] "Real Estate", CIIS will
                                                                                                                                                                                                             reject any response to "Projected Jobs to be Created at Tenant
                                                                                                                                                                                                             Businesses".

Source of Job Estimates                               Projects: AG                          Purpose = Business,                                                                                             wValidation: If Purpose <> [not equal] "Business",
                                                                                            Microenterprise or Real                                                                                          "Microenterprise" and "Real-Estate", CIIS will reject any response
                                                                                                    Estate                                                                                                   to "Type of Jobs Reported."
                                                                                                                                                                                                             wOptions include:
                                                                                                                                                                                                             as a result of the new financing. (NEWFINANCING)

                                                                                                                                                                                                             wage and salary expenditures attributable to project financing.
                                                                                                                                                                                                             (WAGEDATA)

                                                                                                                                                                                                             as IMPLAN, RIMSII, or REMI. (ECONOMICIMPACT)

                                                                                                                                                                                                             created by type of business and square-footage built.
                                                                                                                                                                                                             (RULEOFTHUMB)




Source of Job Estimates - Other                       Projects: AH
                                                                                                                                                                                                             w User may enter up to 150 characters to describe the     "Other"




            11/15/2011                                                                                                        Page 6 of 14
                                                                                                         717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                            Project or     Excel                                                                         Annual                                 Borrower/
                                            Financial    Worksheet:     New Field Mandatory     Field is Conditionally                   Update     Transaction                  Investee
CIIS TLR Data Field                         Note Field    Column         (CIIS 9.0) Field            Required If…           Compliance   Required      Type        Purpose         Type   QLICI Type   SPE                          Special Instructions
Square Feet of Real Estate - Total              P        Projects: AI                           Purpose = Real Estate                                            Real Estate                                ***The Don't Know Option has been removed. ***
                                                                                                                                                                                                              "Square Feet of Real Estate - Total" is the total square footage
                                                                                                                                                                                                             developed for the project funded.
                                                                                                                                                                                                              Numeric field with no decimals.
Square Feet of Real Estate -                    P        Projects: AJ                           Purpose = Real Estate                                            Real Estate                                ***The Don't Know Option has been removed. ***
Manufacturing                                                                                                                                                                                                 "Square Feet of Real Estate - Manufacturing" is a subset of
                                                                                                                                                                                                             "Square Feet of Real Estate - Total."
                                                                                                                                                                                                              Numeric field with no decimals and Don’t Know and Not
                                                                                                                                                                                                             Applicable options.
Square Feet of Real Estate - Office             P        Projects: AK                           Purpose = Real Estate                                            Real Estate                                ***The Don't Know Option has been removed. ***
                                                                                                                                                                                                              "Square Feet of Real Estate - Office" is a subset of "Square
                                                                                                                                                                                                             Feet of Real Estate - Total."
                                                                                                                                                                                                              Numeric field with no decimals and Don’t Know and Not
                                                                                                                                                                                                             Applicable options.
Square Feet of Real Estate – Retail             P        Projects: AL                           Purpose = Real Estate                                            Real Estate                                ***The Don't Know Option has been removed. ***
                                                                                                                                                                                                              "Square Feet of Real Estate - Retail" is a subset of "Square
                                                                                                                                                                                                             Feet of Real Estate - Total."
                                                                                                                                                                                                              Numeric field with no decimals and Don’t Know and Not
                                                                                                                                                                                                             Applicable options.
Housing Units – Sale                            P        Projects: AM                           Purpose = Real Estate                                            Real Estate                                ***The Don't Know Option has been removed. ***
Housing Units – Rental                          P        Projects: AN                           Purpose = Real Estate                                            Real Estate                                ***The Don't Know Option has been removed. ***
Affordable Housing Units – Sale                 P        Projects: AO                           Purpose = Real Estate                                            Real Estate                                ***The Don't Know Option has been removed. ***
                                                                                                                                                                                                              "Affordable Housing Units - Sale" is a subset of "Housing Units -
                                                                                                                                                                                                             Sale."
Affordable Housing Units – Rental               P        Projects: AP                           Purpose = Real Estate                                            Real Estate                                ***The Don't Know Option has been removed. ***
                                                                                                                                                                                                              "Affordable Housing Units - Rental" is a subset of "Housing
                                                                                                                                                                                                             Units - Rental."
Community Facility                              P        Projects: AQ                                                                                                                                         CIIS Values are "YES", "NO", and "DK" [Don't Know].
                                                                                                                                                                                                              Validation: If "Community Facility" = "YES", user must provide a
                                                                                                                                                                                                             numeric response > 0 or DK for at least one of the Community
                                                                                                                                                                                                             Facility Capacity data points that follow.
Capacity of Educational Community
Facility
                                                P        Projects: AR                          Community Facility = Yes                                                                                      Numeric field with 2 decimals points and “DK” [Don’t Know”] and
                                                                                                                                                                                                             “NA” [Not Applicable] options.
                                                                                               (For a community facility,
                                                                                                CIIS requires a capacity
                                                                                              number (>0) or "Don't Know"
                                                                                                for one or more capacity
                                                                                                         fields.)
Capacity of Childcare Community Facility        P        Projects: AS                          Community Facility = Yes                                                                                      Numeric field with 2 decimals points and “DK” [Don’t Know”] and
                                                                                                                                                                                                             “NA” [Not Applicable] options.
                                                                                               (For a community facility,
                                                                                                CIIS requires a capacity
                                                                                              number (>0) or "Don't Know"
                                                                                                for one or more capacity
                                                                                                         fields.)
Capacity of Healthcare Community Facility       P        Projects: AT                          Community Facility = Yes                                                                                      Numeric field with 2 decimals points and “DK” [Don’t Know”] and
                                                                                                                                                                                                             “NA” [Not Applicable] options.
                                                                                               (For a community facility,
                                                                                                CIIS requires a capacity
                                                                                              number (>0) or "Don't Know"
                                                                                                for one or more capacity
                                                                                                         fields.)
Capacity of Arts Center Community
Facility
                                                P        Projects: AU                          Community Facility = Yes                                                                                      Numeric field with 2 decimals points and “DK” [Don’t Know”] and
                                                                                                                                                                                                             “NA” [Not Applicable] options.
                                                                                               (For a community facility,
                                                                                                CIIS requires a capacity
                                                                                              number (>0) or "Don't Know"
                                                                                                for one or more capacity
                                                                                                         fields.)
Capacity of Other Community Facility            P        Projects: AV                          Community Facility = Yes                                                                                      Numeric field with 2 decimals points and “DK” [Don’t Know”] and
                                                                                                                                                                                                             “NA” [Not Applicable] options.
                                                                                               (For a community facility,
                                                                                                CIIS requires a capacity
                                                                                              number (>0) or "Don't Know"
                                                                                                for one or more capacity
                                                                                                         fields.)
Other Impacts (1) Explain
            11/15/2011                          P        Projects: AW                                                              Page 7 of 14
                                                                                                      717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                         Project or      Excel                                                                         Annual                             Borrower/
                                         Financial    Worksheet:     New Field Mandatory     Field is Conditionally                    Update     Transaction              Investee
CIIS TLR Data Field                      Note Field     Column        (CIIS 9.0) Field            Required If…           Compliance    Required      Type       Purpose      Type   QLICI Type   SPE                         Special Instructions
Other Impacts (1) Number of Units            P        Projects: AX                            Other Impact (1) -
                                                                                              Explain is populated.
Other Impacts (2) Explain                    P        Projects: AY
Other Impacts (2) Number of Units            P        Projects: AZ                            Other Impact (2) -
                                                                                              Explain is populated.
NMTC Program Criteria
Investor TIN                                 P        Projects: BA                                                          
QALICB Type                                  P        Projects: BB                           QLICI Type = QALICB                                                                   QALICB
NMTC Eligibility Criteria                    P        Projects: BC                                                          
1990 FIPS Code                               P        Projects: BD                          NMTC Eligibility Criteria       
                                                                                                 = 1990 Census
Related Entity                               P        Projects: BE                                                          
Total QEI Proceeds Retained by the CDE       P        Projects: BF                           Date Originated >                                                                                       This is the total amount of the QEI proceeds retained by the CDE
                                                                                                                                                                                                       expressed in basis points.
                                                                                                   12/31/2010
Front End Sources of Compensation and
Profits Charged to Investors
                                             P        Projects: BG                           Date Originated >                                                                                       The amount (expressed in basis points) of front-end sources of
                                                                                                                                                                                                       compensation and profits charged to investors.
                                                                                                   12/31/2010
Front End Sources of Compensation and
Profits Charged to Borrowers/Investees
                                             P        Projects: BH                           Date Originated >                                                                                       The amount (expressed in basis points) of front-end sources of
                                                                                                                                                                                                       compensation and profits charged to borrowers/investees.
                                                                                                   12/31/2010

Front End Sources of Compensation and
Profits Charged to Other Entities
                                             P        Projects: BI                           Date Originated >                                                                                       The amount (expressed in basis points) of front-end sources of
                                                                                                                                                                                                       compensation and profits charged to other entities besides
                                                                                                   12/31/2010
                                                                                                                                                                                                       investors or borrowers/investees.
On-going Sources of Compensation and
Profits Charged to Investors
                                             P        Projects: BJ                           Date Originated >                                                                                       The amount (expressed in basis points) of on-going sources of
                                                                                                                                                                                                       compensation and profits charged to investors.
                                                                                                   12/31/2010
On-going Sources of Compensation and
Profits Charged to Borrowers/Investees
                                             P        Projects: BK                           Date Originated >                                                                                       The amount (expressed in basis points) of on-going sources of
                                                                                                                                                                                                       compensation and profits charged to borrowers/investees.
                                                                                                   12/31/2010

On-going Sources of Compensation and
Profits Charged to Other Entities
                                             P        Projects: BL                           Date Originated >                                                                                       The amount (expressed in basis points) of on-going sources of
                                                                                                                                                                                                       compensation and profits charged to other entities besides
                                                                                                   12/31/2010
                                                                                                                                                                                                       investors or borrowers/investees.
Back-end Sources of Compensation and
Profits Charged to Investors
                                             P        Projects: BM                           Date Originated >                                                                                       The amount (expressed in basis points) of back-end sources of
                                                                                                                                                                                                       compensation and profits charged to investors.
                                                                                                   12/31/2010
Back-end Sources of Compensation and
Profits Charged to Borrowers/Investees
                                             P        Projects: BN                           Date Originated >                                                                                       The amount (expressed in basis points) of back-end sources of
                                                                                                                                                                                                       compensation and profits charged to borrowers/investees.
                                                                                                   12/31/2010

Back-end Sources of Compensation and
Profits Charged to Other Entities
                                             P        Projects: BO                           Date Originated >                                                                                       The amount (expressed in basis points) of back-end sources of
                                                                                                                                                                                                       compensation and profits charged to other entities besides
                                                                                                   12/31/2010
                                                                                                                                                                                                       investors or borrowers/investees.

Other Sources of Compensation and
Profits Charged to Investors
                                             P        Projects: BP                           Date Originated >                                                                                       The amount (expressed in basis points) other sources of
                                                                                                                                                                                                       compensation and profits charged to investors that has not been
                                                                                                   12/31/2010
                                                                                                                                                                                                       disclosed as front-end, on-going, or back-end sources of
                                                                                                                                                                                                       compensation and profit.

Other Sources of Compensation and
Profits Charged to Borrowers/Investees
                                             P        Projects: BQ                           Date Originated >                                                                                       The amount (expressed in basis points) of other sources of
                                                                                                                                                                                                       compensation and profits charged to borrowers/investees that has
                                                                                                   12/31/2010
                                                                                                                                                                                                       not been disclosed as front-end, on-going, or back-end sources of
                                                                                                                                                                                                       compensation and profit.

Other Sources of Compensation and
Profits Charged to Other Entities
                                             P        Projects: BR                           Date Originated >                                                                                       The amount (expressed in basis points) of other sources of
                                                                                                                                                                                                       compensation and profits charged to other entities besides
                                                                                                   12/31/2010
                                                                                                                                                                                                       investors or borrowers/investees that has not been disclosed as
                                                                                                                                                                                                       front-end, on-going, or back-end sources of compensation and
                                                                                                                                                                                                       profit. Other entities may include subsidiary CDEs, etc.

Better Rates & Terms (P)
Below Market Interest Rate (Project)         P        Projects: BS                                                          
Blended Interest Rate                        P        Projects: BT                          Below Market Interest                                  Debt                                               Numeric field with 3 decimals.
                                                                                              Rate (Project) = Yes
Comparable Blended Interest Rate             P        Projects: BU                          Below Market Interest                                  Debt                                               Numeric field with 3 decimals.
                                                                                              Rate (Project) = Yes




             11/15/2011                                                                                                          Page 8 of 14
                                                                                                         717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                           Project or      Excel                                                                          Annual                             Borrower/
                                           Financial    Worksheet:     New Field Mandatory     Field is Conditionally                     Update     Transaction              Investee
CIIS TLR Data Field                        Note Field     Column        (CIIS 9.0) Field            Required If…            Compliance    Required      Type       Purpose      Type   QLICI Type   SPE                          Special Instructions
What is Blended Interest Rate                  P        Projects: BV                           Below Market Interest                                    Debt                                              Options include: .
Comparable?                                                                                   Rate (Project) = Yes and
                                                                                                 Date Originated >
                                                                                                     12/31/2005

Blended Interest Rate Comparable               P        Projects: BW                          What is Blended Interest                                 Debt                                               User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                          Comparable
Other                                                                                        Rate Comparable? = Other

Lower than Standard Origination Fees
(Project)
                                               P        Projects: BX                                                                                                                                     CIIS Values are "YES" and "NO".

Standard Origination Fees (Project)            P        Projects: BY                           Lower than Standard                                     Debt                                               Numeric field with no decimals.
                                                                                             Origination Fees (Project) =
                                                                                                          Yes
What is Standard Origination Fees              P        Projects: BZ                           Lower than Standard                                     Debt                                               Options include: .
(Project) Comparable?                                                                        Origination Fees (Project) =
                                                                                             Yes and Date Originated >
                                                                                                      12/31/2005

Standard Origination Fees (Project)            P        Projects: CA                             What is Standard                                      Debt                                               User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                          Comparable
Comparable Other                                                                              Origination Fees (Project)
                                                                                                Comparable? = Other
Higher than Standard Loan to Value Ratio       P        Projects: CB                                                           
Standard Loan-to-Value Ratio                   P        Projects: CC                          If Higher than Standard                                  Debt                                               Numeric field with 3 decimals.
                                                                                              Loan-to-Value Ratio = Yes

What is Standard Loan-to-Value Ratio           P        Projects: CD                          If Higher than Standard                                  Debt                                               Options include: .
Comparable?                                                                                  Loan-to-Value Ratio = Yes
                                                                                               and Date Originated >
                                                                                                    12/31/2005

Standard Loan-to-Value Ratio                   P        Projects: CE                           What is Standard Loan-                                  Debt                                               User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                          Comparable
Comparable Other                                                                             to-Value Ratio Comparable?
                                                                                                       = Other
More Flexible Borrower Credit Standards        P        Projects: CF                                                           
Lower than Standard Debt Service
Coverage Ratio
                                               P        Projects: CG                                                           
Standard Debt Service Coverage Ratio           P        Projects: CH                           Lower than Standard                                     Debt                                               Numeric field with 3 decimals.
                                                                                               Debt Service Coverage
                                                                                                     Ratio = Yes
What is Standard Debt Service                  P        Projects: CI                           Lower than Standard                                     Debt                                               Options include: .
Coverage Ratio Comparable?                                                                     Debt Service Coverage
                                                                                                Ratio = Yes and Date
                                                                                               Originated > 12/31/2005

Standard Debt Service Coverage                 P        Projects: CJ                          What is Standard Debt                                    Debt                                               User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                          Comparable
Ratio Comparable Other                                                                        Service Coverage Ratio
                                                                                               Comparable? = Other

Lower than Standard Loan Loss Reserve
Requirement
                                               P        Projects: CK                                                           
Standard Loan Loss Reserve
Requirement
                                               P        Projects: CL                           Lower than Standard                                     Debt                                               Numeric field with no decimals.
                                                                                                 Loan Loss Reserve
                                                                                                 Requirement = Yes
What is Standard Loan Loss Reserve             P        Projects: CM                           Lower than Standard                                     Debt                                               Options include: .
Requirement Comparable?                                                                         Loan Loss Reserve
                                                                                               Requirement = Yes and
                                                                                                 Date Originated >
                                                                                                     12/31/2005
Standard Loan Loss Reserve                     P        Projects: CN                          What is Standard Loan                                    Debt                                               User may enter up to 150 characters to describe the "Other"
                                                                                                                                                                                                          Comparable
Requirement Comparable Other                                                                 Loss Reserve Requirement
                                                                                                Comparable? = Other

Areas of Higher Distress
            11/15/2011                                                                                                              Page 9 of 14
                                                                                                        717aca04-85a9-4026-9da2-f57168917ba2.xls - CDE QuickStart
                                             Project or      Excel                                                                    Annual                             Borrower/
                                             Financial    Worksheet:     New Field Mandatory   Field is Conditionally                 Update     Transaction              Investee
CIIS TLR Data Field                          Note Field     Column        (CIIS 9.0) Field          Required If…        Compliance    Required      Type       Purpose      Type   QLICI Type   SPE                        Special Instructions
Poverty Rates Greater than 25% but less
than or equal to 30%
                                                 P        Projects: CN                                                                                                                               CIIS Values are "YES", "NO", and "NA"

Poverty Rates Greater than 30%                   P        Projects: CO                                                                                                                               CIIS Values are "YES", "NO", and "NA"
Median Income Less than 60% of Area
Median Income
                                                 P        Projects: CP                                                                                                                               CIIS Values are "YES", "NO", and "NA"

If located within a non-Metropolitan Area,
median family income greater than 60
                                                 P        Projects: CQ                                                                                                                               CIIS Values are "YES", "NO", and "NA"

percent but less than or equal to 70
percent of statewide median family
income or if located within a Metropolitan
Area, median family income greater than
60 percent but less than or equal to 70
percent of the greater of statewide
median family income or the Metropolitan
Area median family income

Unemployment Rates equal to or greater
than 1.25 but less than 1.50 Times the
                                                 P        Projects: CR                                                                                                                               CIIS Values are "YES", "NO", and "NA"

National Average
Unemployment at Least 1.5 Times the
National Average
                                                 P        Projects: CW                                                                                                                               CIIS Values are "YES", "NO", and "NA"

Designated for Redevelopment                     P        Projects: CT                                                                                                                               CIIS Values are "YES", "NO", and "NA"
Designated EZ, EC, or RC                         P        Projects: CU                                                                                                                               CIIS Values are "YES", "NO", and "NA"
SBA Designated HUB Zone                          P        Projects: CV                                                                                                                               CIIS Values are "YES", "NO", and "NA"
Designated Native American or Alaska
Native Area, Hawaiian Homeland, or
                                                 P        Projects: CW                                                                                                                               CIIS Values are "YES", "NO", and "NA"

Redevelopment Area by Tribe or Other
Authority
Brownfield Redevelopment Area                    P        Projects: CX                                                                                                                               CIIS Values are "YES", "NO", and "NA"
Encompassed by HOPE VI
Redevelopment Plan
                                                 P        Projects: CY                                                                                                                               CIIS Values are "YES", "NO", and "NA"

Located in a Hot Zone                            P        Projects: DA                                                                                                                               CIIS Values are "YES", "NO", and "NA"
Appalachian Regional Commission or
Delta Regional Authority
                                                 P        Projects: DB                                                                                                                               CIIS Values are "YES", "NO", and "NA"

Colonias                                         P        Projects: DC                                                                                                                               CIIS Values are "YES", "NO", and "NA"
Medically Underserved Area                       P        Projects: DD                                                                                                                               CIIS Values are "YES", "NO", and "NA"
TIF District or Enterprise Zone Program          P        Projects: DE                                                                                                                               CIIS Values are "YES", "NO", and "NA"
High Migration Rural County                      P        Projects: DF                                                                                                                               CIIS Values are "YES", "NO", and "NA"




             11/15/2011                                                                                                         Page 10 of 14
QuickStart Definitions

Project or Financial Note Field - This field indicates whether the data field is collected on the Financial Note (FN) or Project (P) level. For
Excel Worksheet: Column - The names in this column indicate the worksheet in the Excel Template for each data field. The letters in this c
New Field (CIIS 9.0) - A  in this column indicates that the field is new in CIIS Version 9.0 (FY 2011). NOTE: Three fields were removed in
Mandatory - A  in this column indicates that users must provide valid data in this field for every transaction in order to complete the Trans
Conditionally Required if... - A  in this column indicates that users must provide valid data in this field for every transaction that meets th
Compliance - A  in this column indicates that the field may be used to test the organization's compliance with their allocation agreement.
Annual Update Required - A       in this column indicates that users must provide an annual update to the data field if the data has change
Transaction Type - Users may use this column to organize the data fields by Transaction Type. "Debt" indicates that the data field is relev
Purpose - Users may use this column to organize the data fields by Purpose. "Business" indicates that the data field is relevant for Busines
Borrower/Investee Type - Users may use this column to organize the data fields by Investee Type. "Business" indicates that the data field
QLICI Type - Users may use this column to organize the data fields by QLICI Type (CDE and QALICB).
SPE - User may use this column to organize the data fields for a Special Purpose Entity (SPE) borrower. "Parent Business" indicates that if
Special Instructions - This column provides additional information including, but not limited to, changes to data field in CIIS 7.0 and comm
FN) or Project (P) level. For additional information about Financial Notes and Projects, see the "Allocatee - TLR - Instructions at http://www.cdfifund.gov/wh
 ata field. The letters in this column indicate the column on the worksheet in the Excel Template.
Three fields were removed in CIIS 9.0.
 order to complete the Transaction Level Report (TLR).
ery transaction that meets the noted condition in order to complete the Transaction Level Report (TLR).
h their allocation agreement.
 field if the data has changed since the previous reporting period.
es that the data field is relevant for Term Loans, Lines of Credit, Debt with Equity transactions. "Equity" indicates that the data field is relevant for Equity In
 field is relevant for Business and Microenterprise transactions. "Real Estate" indicates that the field is relevant for any Real Estate transactions.
 indicates that the data field is relevant for transactions to businesses. "Individual" indicates that the field is relevant for transactions to individuals.


nt Business" indicates that if the borrower is an SPE, the user should enter data for the parent business. For additional information about SPEs, see the "
 field in CIIS 7.0 and common user errors.
nstructions at http://www.cdfifund.gov/what_we_do/ciis.asp




hat the data field is relevant for Equity Investments and Debt with Equity transactions. "Debt with Equity" indicates that the data field is relevant for Debt w
r any Real Estate transactions.
nt for transactions to individuals.


tional information about SPEs, see the "Allocatee - TLR - Instructions at http://www.cdfifund.gov/what_we_do/ciis.asp
that the data field is relevant for Debt with Equity transactions.

								
To top