FDIC Allowable Values in Version 1.3.3 NSF Files
File Type File Field # Field Description Allowable Values
Non-Single Family (NSF)
AL = Alabama; AK = Alaska; AP =
Army Post Office; AS = American
Samoa; AZ = Arizona; AR =
Arkansas; CA = California; CN =
Canada; CO = Colorado; CT =
Connecticut; DC = District of
Columbia; DE Delaware; FC =
Foreign Country; FL = Florida; GA =
Georgia; GU = Guam; HI = Hawaii; IA
= Iowa; ID= Idaho; IL = Illinois; IN =
Indiana; KS = Kansas; KY =
Kentucky; LA = Louisiana; MA =
Massachusetts; MD = Maryland; ME =
Maine; MI = Michigan; MN =
Post Office state code in which the Minnesota; MO = Missouri; MP =
NSF Active Loans 8 State primary borrower has its main or head Marianas; MS = Mississippi; MT =
office. Montana; MX = Mexico; NC = North
Carolina; ND = North Dakota; NE =
Nebraska; NH = New Hampshire; NJ
= New Jersey; NM = New Mexico; NV
= Nevada; NY = New York; OH =
Ohio; OK = Oklahoma; OR = Oregon;
PA = Pennsylvania; PR = Puerto
Rico; RI = Rhode Island; SC = South
Carolina; SD = South Dakota; TN =
Tennessee; TX = Texas; U =
Unknown; UT = Utah; VA = Virginia;
VI = Virgin Islands; VT = Vermont;
WA = Washington; WI = Wisconsin;
WV = West Virginia; WY = Wyoming;
YY = All States
Indicator denotes if the borrower's
NSF Active Loans 16 Out of Territory address or location is outside of the Y = Yes; N = No; U = Unknown
institution's market area.
If the data supports, report Regulation O
defined insiders using "O" for executive
officer, "D" for director, and "P" for
principal shareholders. Additionally, if O = Executive Office; D = Director; P
NSF Active Loans 17 Insiders and Employees the data supports designate employees = Principal; E = Employees or Y =
(those that are not executive officers) Yes; N = No; U = Unknown
with "E". If the user or vendor data does
not support this scheme, simply identify
insider status with Y/N.
1 = Purchase Collateral; 2 =
Refinance; 3 = Acquisition and
Development; 4 = Major Rehab; 5 =
Construction; 6 = Working Capital; 7 =
Description of what the proceeds will be
NSF Active Loans 31 Note purpose Seasonal Line of Credit; 8 = Purchase
used for.
Stock/Securities; 9 = Home
Improvement; 10 = HELOC; 11 =
Personal & Misc Expenses; 12 = SBA
Financing; 13 = Other; U = Unknown
Retail; Industrial/Warehouse;
The code associated with the collateral Hotel/Hospitality/Gaming/Resorts;
type (e.g. commercial real estate, 1-4 Multi-Family for Rent; Homebuilders
NSF Active Loans 32 Collateral Code
family mortgages, UCC filings, Except for Condo; Condo; Office;
marketable securities, etc.). Mixed; Land and Lot Development;
Other; U = Unknown
1
FDIC Allowable Values in Version 1.3.3 NSF Files
File Type File Field # Field Description Allowable Values
Prime Rate = Bank Prime Loan, CODI
= Certificate Of Deposit Index, CMT =
Constant Maturity Treasury, COSI =
Cost Of Savings Index, COFI =
Interest rate base index used when the Eleventh District Cost Of Funds Index,
NSF Active Loans 34 Interest Rate Index
note's rate varies with an index. LIBOR = London Inter Bank Offering
Rates, T-Bill = Treasury Bill, MTA =
Twelve Month Treasury Average;
Other; F = Fixed Rate Mortgage; U =
Unknown
1 = Prime-Minimal Risk; 2 = High
Pass-High Quality; 3 = Average; 4 =
The overall rating assigned to the
Low Pass-Acceptable; 5 = Watch-
NSF Active Loans 37 Borrower's internal rating borrower. If borrower ratings are not
Special Mention; 6 = Substandard; 7
assigned, provide the note rating here.
= Doubtful; 8 = Loss; 9 = No Rating; U
= Unknown
1 = Prime-Minimal Risk; 2 = High
Pass-High Quality; 3 = Average; 4 =
Bank's internal risk rating of the note's Low Pass-Acceptable; 5 = Watch-
NSF Active Loans 39 Note risk rating
total outstanding balance. Special Mention; 6 = Substandard; 7
= Doubtful; 8 = Loss; 9 = No Rating; U
= Unknown
Indicator if this note has been identified
NSF Active Loans 46 Shared National Credit Y = Yes; N = No; U = Unknown
as qualifying for the SNC program.
Indicator if the note has been placed on
NSF Active Loans 50 Nonaccrual Y = Yes; N = No; U = Unknown
nonaccrual.
RCONF158; RCONF159; RCON1460;
RCONF160; RCONF161; RCON1763;
RCON1764; RCONB538;
RCONB539; RCONK137;
RCONK207; RCON1420;
The code or Call Report line number RCONB531; RCONB534; RCON535;
used by the vendor or user to categorize RCON1590; RCON2081; RCON2107;
NSF Active Loans 55 FFIEC Code
loans for the Report of Condition RCONJ454; RCON1545; RCONJ451;
Schedule RC-C. RCON5508; RCON5509; RCON5511;
RCON5512; RCONC979;
RCON5513; SC230; SC235; SC240;
SC265; SC256; SC260; SC32; SC35;
SC405; SC425; SC428; SC430;
SC45; U = Unknown
Indicator signifies whether if the loan
was purchased or sold. Enter a 'P' if it P = Purchased; S = Sold; U =
NSF Active Loans 56 Participation indicator
was purchased, 'S' if all or a portion is Unknown; X = Not Applicable
sold.
Indicates that the note is accounted for
NSF Active Loans 60 Loan for sale Y = Yes; N = No; U = Unknown
under the held-for-sale category.
M = Monthly; Q = Quarterly; S = Semi-
How often payments are contractually
Annually; A = Annually; V = Variable,
NSF Active Loans 62 Payment frequency required (monthly, quarterly, semi-
P = Payable at Maturity, I = Irregular;
annually, annually, etc.).
N=None; Other; U = Unknown
Indicator if note's interest rate is
NSF Active Loans 63 Variable Rate Y = Yes; N = No; U = Unknown
adjustable, floating, or variable.
Indicator designates if the note is
Troubled Debt
NSF Active Loans 67 considered to be a troubled debt Y = Yes; N = No; U = Unknown
Restructured
restructure.
Indicates if the note is amortizing with a
Amortizing/Non-
NSF Active Loans 68 'Y'. Indicator should be an "N" for notes Y = Yes; N = No; U = Unknown
amortizing status
where payments have been suspended.
2
FDIC Allowable Values in Version 1.3.3 NSF Files
File Type File Field # Field Description Allowable Values
1 = first lien; 2 = second lien; 3 = lien
The priority lien held by this bank (e.g.,
NSF Active Loans 75 Lien Status position greater than 2nd; UNS =
1st lien, 2nd lien, etc.).
Unsecured; 9 = Unknown
C&D = Construction & Development,
FDIC Asset Type used to populate Other CRE = Other Commercial Real
Section 2 of the Commercial Loss Share Estate (CRE), C&I = Commercial and
NSF Active Loans 84 FDIC Asset Type
Certificate. Field must adhere strictly to Industrial, Consumer = Consumer
the allowable values. Loans, OTH = Other Loans, SUB =
Investment in Subsidiary
AL = Alabama; AK = Alaska; AP =
Army Post Office; AS = American
Samoa; AZ = Arizona; AR =
Arkansas; CA = California; CN =
Canada; CO = Colorado; CT =
Connecticut; DC = District of
Columbia; DE Delaware; FC =
Foreign Country; FL = Florida; GA =
Georgia; GU = Guam; HI = Hawaii; IA
= Iowa; ID= Idaho; IL = Illinois; IN =
Indiana; KS = Kansas; KY =
Kentucky; LA = Louisiana; MA =
Massachusetts; MD = Maryland; ME =
Maine; MI = Michigan; MN =
Minnesota; MO = Missouri; MP =
NSF Active Loans 88 Collateral Property state Property state. Marianas; MS = Mississippi; MT =
Montana; MX = Mexico; NC = North
Carolina; ND = North Dakota; NE =
Nebraska; NH = New Hampshire; NJ
= New Jersey; NM = New Mexico; NV
= Nevada; NY = New York; OH =
Ohio; OK = Oklahoma; OR = Oregon;
PA = Pennsylvania; PR = Puerto
Rico; RI = Rhode Island; SC = South
Carolina; SD = South Dakota; TN =
Tennessee; TX = Texas; U =
Unknown; UT = Utah; VA = Virginia;
VI = Virgin Islands; VT = Vermont;
WA = Washington; WI = Wisconsin;
WV = West Virginia; WY = Wyoming;
YY = All States
B = Bankruptcy; F = Foreclosure; 9 =
Bankruptcy and Foreclosure; N = Not
NSF Active Loans 97 Exceptional Loan Status Indicates bankruptcy or foreclosure.
in bankruptcy and/or foreclosure; U =
Unknown
INT = Interior; EXT = Exterior; AVM =
Automated Valuation Model; BPO =
Broker price Opinion; DA = Desktop
NSF Active Loans 98 Valuation Type Indicates valuation type. Appraisal; DB = Drive By; FA = Full
Appraisal; PAU = Prior Appraisal
Used; TV = Tax Valuation; None;
Other; U = Unknown
Indicator signifying if a loan has been
modified outside the original terms of
NSF Active Loans 100 Modification Y = Yes; N = No; U = Unknown
the contract agreed to by the lender and
borrower during Loss Share.
DQ ADV - Disqualified: Advance Too
Large; DQ MAT - Disqualified:
Maturity Extended Too Far; SOLD -
NSF Inactive Loans 4 Inactivity Reason Flag indicating reason for inactivity.
Disqualified: Sold Without Receiver
Consent; CO - Fully Charged-Off;
ORE SOLD - ORE Sold; Other
Indicator signifying if loan sale qualifies
NSF Asset Sales 5 Loss Share Y = Yes; N = No; X = Not Applicable
for Loss Share.
3
FDIC Allowable Values in Version 1.3.3 NSF Files
File Type File Field # Field Description Allowable Values
C&D = Construction & Development,
Other CRE = Other Commercial Real
FDIC Asset Type used to populate Estate (CRE), C&I = Commercial and
Section 2 of the Commercial Loss Share Industrial, ORE = ORE & Other
NSF Loss and Recoveries 4 FDIC Asset Type
Certificate. Field must adhere strictly to Repossessed Assets, Consumer =
the allowable values. Consumer Loans, OTH = Other
Loans, SUB = Investment in
Subsidiary
INT = Interior; EXT = Exterior; AVM =
Automated Valuation Model; BPO =
Broker price Opinion; DA = Desktop
NSF Loss and Recoveries 14 Appraisal Type Indicates valuation type. Appraisal; DB = Drive By; FA = Full
Appraisal; PAU = Prior Appraisal
Used; TV = Tax Valuation; None;
Other
Indicates if charge-off resulted from a
NSF Loss and Recoveries 19 Modification loan modification or restructure during Y = Yes; N = No; X = Not Applicable
reporting period.
1=Accrued Interest; 2=Additional Sale
Proceeds; 3=Appraisal Refund;
4=Closing Refund; 5=Condo or
Homeowners Association Refund;
6=Customer PaymentDeficiency;
7=Note Payment; 8=Escrow Refund;
9=Flood Insurance Refund;
10=Hazard Insurance Proceeds;
11=Insurance Refund; 12=Legal
NSF Loss and Recoveries 20 Recovery reason Type of recovery payment. Refund; 13=Maintenance Refund;
14=Management Fee Refund;
15=Mortgage Insurance Proceeds;
16=Payment from Attorney;
17=Property Tax Refund;
18=Recovery on Loan Charged Off
Prior To Bank Failure; 19=Rental
Income; 20=Tax Overages; 21=Utility
Refund; 22=Expense Reversal; 98 =
Not Applicable; 99=Other
1=Appraisal Expense; 2=Attorney and
Legal Fees/Costs; 3=Condo or
Homeowners Association Payment;
4=Construction Expense; 5=County
Ordinance Expense; 6=Eviction Cost;
7=Foreclosure Costs and Fees;
8=Hazard Insurance Expense;
9=Incentive Paid to Borrower; 10=Lien
NSF Loss and Recoveries 21 Expense reason Type of expense payment.
Search Expense; 11=Maintenance
Expense; 12=Mortgage Insurance
Expense; 14=Property Inspections
Expense; 15=Property Insurance
Expense; 16=Property Preservation
Expense; 17=Tax Expense; 18=Utility
Payment; 19=Recovery Reversal; 98
= Not Applicable; 99=Other
Retail; Industrial/Warehouse;
Hotel/Hospitality/Gaming/Resorts;
Multi-Family for Rent; Homebuilders
NSF ORE Listing 6 Property type Type of property
Except for Condo; Condo; Office;
Mixed; Land and Lot Development;
Other; U = Unknown
4
FDIC Allowable Values in Version 1.3.3 NSF Files
File Type File Field # Field Description Allowable Values
INT = Interior; EXT = Exterior; AVM =
Automated Valuation Model; BPO =
Broker price Opinion; DA = Desktop
NSF ORE Listing 11 Appraisal Type Indicates valuation type. Appraisal; DB = Drive By; FA = Full
Appraisal; PAU = Prior Appraisal
Used; TV = Tax Valuation; None;
Other; U = Unknown
Field populated with either A (Single-
Family) or B (Non-Single Family) or C
NSF Related Loan 4 FDIC Schedule (4.15) (Securities) or D (Investment in A or B or C or D
Subsidiaries) showing which Schedule
4.15 the loan in on.
1=Accrued Interest/Non-Accrual
Status, 2=Audit Compliance,
3=Certificates, 4=Charge-offs,
5=Delinquency Management,
6=Liquidation Events - Asset
Disposition, 7=Loan Modification /
Loss Mitigation - Documentation,
Issue category indicating why the 8=Notifications, 9=Participation
NSF FDIC Adjustment 7 Compliance Issue
adjustment is required. Loans, 10=Permitted Amendments,
11=Policies and Procedures,
12=Record Keeping/Systems,
13=Recoveries, 14=Reimbursable
Expenses, 15=Related
Loans/Affiliated Relations, 16=REO,
17=Staffing; 18=Permitted Advance;
99=Other
AI=Acquiring Institution;
CMC=Compliance Monitoring
Adjustment Requested This fields indicates the group that
NSF FDIC Adjustment 9 Contractor; FDIC=FDIC Loss Share
By requested the adjustment.
Specialist; PAAI=Post Audit AI Due
Diligence
5
(Fund ID) - (Failed Institution)
(YYYYMMDD) Please provide mapping of AI Provided Values to FDIC's Allowable Values for all NSF files.
(Record Count) Please ensure that both the file and field names correspond to the names in the FDIC Loss Share Data Specification
FDIC File FDIC Field AI Provided Value AI Description FDIC Allowable Value FDIC Description
SF files.
ecification.
Template Example
FDIC File FDIC Field AI Provided Value AI Description FDIC Allowable Value FDIC Description
Active Loans Payment frequency 1 = Monthly M = Monthly
Active Loans Payment frequency 2 = Quarterly Q = Quarterly
Active Loans Payment frequency 3 = Semi-annually S = Semi-annually
Active Loans Payment frequency 4 = Annually A = Annually
Active Loans Payment frequency V = Variable
Active Loans Payment frequency 5 = At Maturity P = Payable at Maturity
Active Loans Payment frequency I = Irregular
Active Loans Payment frequency N = None
Active Loans Payment frequency Other = Other
Active Loans Payment frequency U = Unknown