METHODOLOGY · TECHNICAL APPENDIX
Sources and scoring models.
The full catalogue of federal files we hold, what we take from each, and the scoring models we maintain. The methodology page explains how a question is answered; this appendix is the reference behind it.
Standard reports compare raw federal records against named groups and do not depend on these scores. Scores appear in a deliverable only when a commission asks for them, always labelled as AuditPoint analysis with their government inputs listed. Each report states the vintage of every source it uses.
Contents
- A · Source catalogue — care, freight, banking, credit unions, employers, contractors, retirement plans, higher education, other sectors
- B · Scoring models — banks, credit unions, carriers, employers, federal contractors, retirement plans, colleges
- C · Principles
- D · What this appendix leaves out
A · Source catalogue
Post-acute care
| Source | What we take from it | Coverage |
|---|---|---|
| CMS Provider Data Catalog | Star ratings (overall, health inspection, staffing, quality); Special Focus Facility status; ownership type and chain affiliation; abuse icon; penalty counts and dollars | Monthly releases |
| CMS health deficiencies | Every citation: tag, scope and severity, survey type (routine, complaint), harm and immediate-jeopardy flags, correction dates | Survey dates from 2017, densest from 2023; citations kept after CMS drops them |
| CMS penalties | Fines and payment denials, with dates and amounts | The last three years, as CMS publishes them |
| Payroll-Based Journal (PBJ) | Daily worked hours by staff type: RN, LPN, aide, administrative nurses and director of nursing; employee and contract hours; resident census; days with no RN on site | Quarterly from Q1 2022 |
| CMS change-of-ownership and owner files | Every recorded sale: buyer and seller enrollment, effective date, and the owners behind each, with role codes and ownership percentages | Quarterly releases from Q1 2022 |
| HCRIS cost reports | Revenue, operating costs and derived operating margin; Medicare, Medicaid and private-pay days; case mix | Annual, latest filing per provider |
| CMS Home Health Value-Based Purchasing | Total performance score, payment adjustment, participation status | Annual |
| CMS hospice quality reporting, CAHPS Hospice and the Hospice Care Index | Admission assessment and visits-in-last-days measures; family caregiver survey results; claims-based utilization indicators such as late live discharges | As CMS publishes them |
| Census American Community Survey | Population 65+, density and rural-urban classification by county | Five-year estimates |
Commercial freight
| Source | What we take from it | Coverage |
|---|---|---|
| FMCSA carrier records | Operating authority and its history; safety rating; crash records; out-of-service rates; insurance filings and cancellations; SMS BASIC measures | Census and history files |
Banking
| Source | What we take from it | Coverage |
|---|---|---|
| FDIC Call Reports (BankFind) | Tier 1 leverage capital (FDIC field RBC1AAJ); noncurrent loans and net charge-offs; return on assets and net interest margin; loan-to-deposit ratio; uninsured deposits; real-estate loans against equity | Quarterly from 1992 |
| FFIEC Call Report schedule RC-N | Loans 30–89 days past due, 90+ days past due and nonaccrual (RCFD/RCON 1403, 1406, 1407); noncurrent total = nonaccrual + 90+ days, the primary asset-quality input. RCFD takes precedence, RCON as fallback | Current quarter |
| FFIEC Call Report schedule RC-B | Held-to-maturity and available-for-sale securities at amortized cost and fair value; held-to-maturity unrealized loss as a share of equity | Current quarter |
| FFIEC Call Report schedule RC-O | Self-reported estimate of uninsured deposits (RCON5597), filed by banks above $1 billion in assets | Current quarter |
| FDIC enforcement actions | Formal actions against institutions: type, effective and termination dates | As FDIC publishes them |
| FFIEC Community Reinvestment Act ratings | Overall rating and examination date | Historical, from 1990 |
| FDIC Summary of Deposits | Branch-level deposits and geographic footprint | Annual |
| FDIC failures and structure events | Failures, mergers and charter changes | Historical |
| CFPB Home Mortgage Disclosure Act | Lender-level applications, originations and denial rates (denied ÷ originated + denied). Market context only; not a score input | Annual |
Credit unions
| Source | What we take from it | Coverage |
|---|---|---|
| NCUA Call Reports (Form 5300) | Net worth and net worth ratio; noncurrent loans (2+ months) and net charge-offs; net income and total assets; loans and shares. Account codes mapped from NCUA's own data dictionary | Quarterly from December 2024 |
| NCUA credit union registry | Charter type, peer group, field of membership, location, low-income designation; joined to financials by charter number | Quarterly |
Employers
| Source | What we take from it | Coverage |
|---|---|---|
| OSHA enforcement data | Inspections; violations by type (willful, repeat, serious); penalties; abatement; fatality flags; severe injury reports | Inspections from 1970; severe injury reports from 2015 |
| Department of Labor Wage and Hour Division | Investigations with findings: back wages, violation counts, repeat-violator flags, civil money penalties | Historical |
Federal contractors
| Source | What we take from it | Coverage |
|---|---|---|
| USASpending award archives | Transaction-level obligations by recipient (UEI), awarding agency, contract type, NAICS and place of performance | Fiscal years 2021–2025 |
| SAM.gov exclusions | Active debarments, suspensions and proposed debarments, with the excluding agency and dates | Current extract |
| SAM.gov responsibility and qualification records (FAPIIS) | Terminations for default or cause, administrative agreements, nonresponsibility determinations, defective pricing, indictments and convictions | Static extract, September 2025 |
Retirement plans
| Source | What we take from it | Coverage |
|---|---|---|
| Form 5500 and 5500-SF | Plan identity (sponsor EIN and plan number), plan type, participant counts; for small plans, delinquent contributions and reported losses | Latest filing year |
| Schedule SB (single-employer) | Adjusted funding target attainment percentage (AFTAP), the measure behind ERISA §436 benefit restrictions | Latest filing year |
| Schedule MB (multiemployer) | Certified funded percentage (line 4a) and PPA zone status (line 4b) | Latest filing year |
| Schedule H (large plans) | Auditor's opinion and delinquent participant contributions (line 4a), with limited-scope elections separated from adverse and disclaimer opinions | Latest filing year |
| PBGC Special Financial Assistance roster | Application status, matched to plans by EIN and plan number | Weekly |
Higher education
| Source | What we take from it | Coverage |
|---|---|---|
| IPEDS Finance | Revenues, expenses, net assets, endowment and debt, read separately for public (GASB), private nonprofit (FASB) and for-profit filers | Annual |
| Department of Education Financial Responsibility composite | The federal solvency score (−1.0 to +3.0) for private institutions | Annual |
| IPEDS Enrollment | Fall enrollment across four collection years; absence from the current file | 2021–2024 |
| Department of Education closed-school record (PEPS) | Closures with dates, matched by OPEID | Periodic |
| IPEDS directory | The UnitID–OPEID crosswalk that joins the files above | Annual |
Other sectors, available on scoping
| Source | What we take from it | Coverage |
|---|---|---|
| IRS Form 990 and Business Master File | Nonprofit revenue, expenses, net assets, program spending and executive compensation; classification and 501(c) subsection | Tax years 2022–2025 |
| USDA FSIS establishments and recalls | Inspected establishments; recalls by class, reason and pounds | As FSIS publishes them |
| U.S. Coast Guard vessel inspections (PSIX) | Inspections, deficiencies and detentions by vessel | FOIA release |
| Army Corps Waterborne Commerce and fleet registry | Cargo tonnage by commodity and waterway; vessel-to-operator registry | Annual |
| STB freight commodity statistics, FRA accident reports, PHMSA hazmat incident reports | Rail commodity flows; accidents and incidents; hazardous-materials releases | As each agency publishes them |
B · Scoring models
Every score below is an AuditPoint analytical output built from government inputs. None is an official designation of the FDIC, NCUA, FMCSA, OSHA, the Department of Labor, PBGC, the Department of Education or any other agency.
Bank Health Score
A 0–100 composite of five components: capital adequacy 25%, asset quality 25%, earnings 20%, liquidity 15%, regulatory standing 15%.
- Capital: Tier 1 leverage ratio, scored in bands from 15% and above down to below 4%.
- Asset quality: noncurrent loans (RC-N basis), net charge-offs and real-estate concentration against equity.
- Earnings: return on assets and net interest margin.
- Liquidity: loan-to-deposit ratio and uninsured deposit share.
- Regulatory standing: formal enforcement and CRA rating.
- Overrides: return on assets below −3% caps the score at 39; uninsured deposits above 75% cap it at 79.
- Tiers: STRONG 80–100, ADEQUATE 70–79, WATCH 40–69, STRESSED 0–39. Since September 2026, banks insured for under three years are shown as DE NOVO rather than scored, because early losses are normal for new banks.
Note on the June 2026 run. The June 2026 scores (December 2025 Call Reports) used a noncurrent-loan input that was misassigned for many banks. It was corrected before the July run. Re-scoring the June run with the corrected input, everything else unchanged, left the STRESSED tier exactly as it was: the same 15 banks.
Credit Union Health Score
A 0–100 composite on the same structure: capital 25% (net worth ratio against NCUA prompt corrective action thresholds: well capitalized at 7%, adequately at 6%), asset quality 25% (noncurrent loans and net charge-offs), earnings 20% (return on assets against a fixed reference of 0.94%), liquidity 15% (loan-to-share ratio against a reference of 70%), regulatory standing 15% (NCUA capital classification).
- Tiers: STRONG 80–100, ADEQUATE 65–79, WATCH 40–64, STRESSED 0–39.
- Net income: for large credit unions that report zero net income because of a mid-year transfer, it is rebuilt from the income statement.
- Data gap: NCUA does not publish institution-level enforcement orders in bulk, so enforcement is not scored. This is a documented gap, not a scored zero.
WeighStation Score (commercial carriers)
A 0–100 carrier risk score from four components: safety record, crash risk over 24 months, insurance stability (cancellation history) and authority integrity (revocation history). Tiers: GREEN, YELLOW, RED.
WorkRecord Score (employers)
A 0–100 employer compliance score: OSHA citation severity 35%, wage-hour violations 25%, OSHA penalty scale 20%, recency 20%. Tiers: CLEAN 80–100, MONITORED 60–79, CITED 40–59, CRITICAL 0–39.
Contractor Risk Score
A 0–100 vendor risk score for federal contractors: federal dependency 35% (obligation volume and trend, adjusted for large commercial firms), agency concentration 30% (Herfindahl index across awarding agencies), contract-type mix 20%, exclusion and integrity 15%.
- Integrity penalties: an active exclusion caps the score. FAPIIS records subtract points by type: terminations for default or cause 20–25, administrative agreements 20, nonresponsibility 15, defective pricing 10, indictments and convictions 30–35. Lookback windows run three to five years, with no limit for criminal findings.
- Tiers: STABLE 70–100, WATCH 50–69, EXPOSED 30–49, CRITICAL 0–29 for the population model; vendors with FAPIIS records use 65 / 45 / 25 so the integrity penalty is not counted twice.
PensionGuard (retirement plans)
Four models, each scored on its own statutory or fiduciary basis rather than one blended composite, on a STRONG / ADEQUATE / WATCH / STRESSED scale:
- Single-employer defined benefit: the ERISA §436 AFTAP bands: 80% and above, 60% to under 80%, and under 60%, where benefit accruals must freeze.
- Multiemployer defined benefit: PPA zone status, cross-checked against the PBGC Special Financial Assistance roster.
- Large-plan fiduciary: auditor's opinion and delinquent contributions, with limited-scope audit elections never scored as distress.
- Small-plan fiduciary: three tiers from the 5500-SF signals, since small plans have no auditor's opinion.
Limits: withdrawal liability is not reported at plan level and is not estimated; delinquent contributions are gross as filed.
CampusIndex (colleges and universities)
A closure-risk tier that reads solvency against enrollment trajectory.
- Solvency: where the Department of Education publishes its Financial Responsibility composite, that number is used unchanged. Where it publishes none, chiefly public institutions, a Composite Financial Index is derived from IPEDS audited financials on the four standard strength factors: primary reserve, viability, return on net assets and net operating revenue.
- Tiers: STRONG 2.0 and above, ADEQUATE 1.5–1.99, WATCH 1.0–1.49, STRESSED below 1.0, and CRITICAL where distressed solvency meets collapsing enrollment. The 1.5 and 1.0 lines are Department of Education thresholds; the 2.0 line is our own analytical split.
- Calibration: of institutions we scored that later closed, 71 of 90 in a clean holdout (78.9%) had been flagged WATCH, STRESSED or CRITICAL first.
- Limits: institutions often leave the IPEDS files the year they close, so the claim is "of institutions we scored that later closed," never "of all closures." Solvency comes from audited statements one to two years old, so this is an annual structural signal, not a real-time one.
C · Principles
- Primary sources only. Every input traces to a named federal file. No third-party aggregators, surveys or estimates.
- Derived figures are labelled. Any score, tier or composite is identified as AuditPoint analysis, with its government inputs listed.
- Vintage on every figure. Each report states the vintage of every source it uses.
- Field definitions from the source. Field meanings are read from each agency's own data dictionary or form instructions, not inferred from column names.
- No editorial verdicts. We report what the federal record shows. Conclusions stay with the reader.
D · What this appendix leaves out
We also maintain scoring models for care providers, hospices, nonprofits, food-safety establishments, vessels and railroads. They are not described here while they are under review, and none is used in a deliverable until that review is complete. The underlying federal records for those sectors remain available on scoping.