Field Name, Field Description (SBA file name: ppp-data-dictionary.xlsx)

Full text

Text extracted from the spreadsheet file: one line per row, cells separated by tabs, each sheet headed by its name. Numbers appear as stored, without the workbook’s formatting.

Sheet: Sheet1
Field Name	Field Description
LoanNumber	Loan Number (unique identifier)
DateApproved	Loan Funded Date
SBAOfficeCode	SBA Origination Office Code
ProcessingMethod	Loan Delivery Method (PPP for first draw; PPS for second draw)
BorrowerName	Borrower Name
BorrowerAddress	Borrower Street Address
BorrowerCity	Borrower City
BorrowerState	Borrower State
BorrowerZip	Borrower Zip Code
LoanStatusDate	Loan Status Date - Loan Status Date is  blank when the loan is disbursed but not Paid In Full or Charged Off
LoanStatus	Loan Status Description - Loan Status is replaced by 'Exemption 4' when the loan is disbursed but not Paid in Full or Charged Off
Term	Loan Maturity in Months
SBAGuarantyPercentage	SBA Guaranty Percentage
InitialApprovalAmount	Loan Approval Amount(at origination)
CurrentApprovalAmount	Loan Approval Amount (current)
UndisbursedAmount	Undisbursed Amount
FranchiseName	Franchise Name
ServicingLenderLocationID	Lender Location ID (unique identifier)
ServicingLenderName	Servicing Lender Name
ServicingLenderAddress	Servicing Lender Street Address
ServicingLenderCity	Servicing Lender City
ServicingLenderState	Servicing Lender State
ServicingLenderZip	Servicing Lender Zip Code
RuralUrbanIndicator	Rural or Urban Indicator (R/U)
HubzoneIndicator	Hubzone Indicator (Y/N)
LMIIndicator	LMI Indicator (Y/N)
BusinessAgeDescription	Business Age Description
ProjectCity	Project City
ProjectCountyName	Project County Name
ProjectState	Project State
ProjectZip	Project Zip Code
CD	Project Congressional District
JobsReported	Number of Employees
NAICSCode	NAICS 6 digit code
Race	Borrower Race Description
Ethnicity	Borrower Ethnicity Description
UTILITIES_PROCEED	Note: Proceed data is lender reported at origination.  On the PPP application the proceeds fields were check boxes.
PAYROLL_PROCEED
MORTGAGE_INTEREST_PROCEED
RENT_PROCEED
REFINANCE_EIDL_PROCEED
HEALTH_CARE_PROCEED
DEBT_INTEREST_PROCEED
BusinessType	Business Type Description
OriginatingLenderLocationID	Originating Lender ID (unique identifier)
OriginatingLender	Originating Lender Name
OriginatingLenderCity	Originating Lender City
OriginatingLenderState	Originating Lender State
Gender	Gender Indicator
Veteran	Veteran Indicator
NonProfit	'Yes' if Business Type = Non-Profit Organization or Non-Profit Childcare Center or 501(c) Non Profit
ForgivenessAmount	Forgiveness Amount
ForgivenessDate	Forgiveness Paid Date

File and source

File

ppp-data-dictionary-xlsx_f362b330d954b51c.xlsx

Size

11,834 bytes

SHA-256

89b953547daac7571dd055c40021a14303b5a2dd8df7f9927b2d2981b83a837a

Our copy

ppp-data-dictionary-xlsx_f362b330d954b51c.xlsx

Original

data.sba.gov