Workbook observations and measurement limits
Check the cells behind 55 DDS staffing observations and 12 SSDI processing-time observations. All 67 selected values and periods match their preserved workbooks. The 397 existing observations and their original definitions remain unchanged.
This is a review of preserved historical files. It is not a fresh publisher capture. Cell agreement does not establish the unit, averaging method, processing clock, or current staffing.
DDS staffing in FY 2023
55 source unit labels, reported total 15,345 employees. The selected rows sum to the workbook regional totals and grand total. Unit labels, including extended teams, remain separate.
FY 2023 unit labels remain separate, including extended teams. 55 unit rows are not 55 states. Source title says employees and the measure header says Total Staff. This does not establish monthly staffing, FTE, workyears, payroll method, or service capacity.
Publisher workbook. Preserved source SHA-256:
48bb78b38f1513959ee9653dc3309ea95716ec17d95243b2db654563201dce9c
Show 55 staffing values and source cells
Period header: Sheet1!Q3, FY 2023. Measure header: Q4, Total Staff. Grand total: Q5, 15,345. Blank source values remain missing, never zero.
| Source unit | Fiscal year | Employees | Workbook cells |
|---|---|---|---|
| CT | 2023 | 154 | Sheet1!Q7Unit: C7 |
| ME | 2023 | 70 | Sheet1!Q8Unit: C8 |
| MA | 2023 | 281 | Sheet1!Q9Unit: C9 |
| NH | 2023 | 61 | Sheet1!Q10Unit: C10 |
| RI | 2023 | 74 | Sheet1!Q11Unit: C11 |
| VT | 2023 | 52 | Sheet1!Q12Unit: C12 |
| NJ | 2023 | 354 | Sheet1!Q14Unit: C14 |
| NY | 2023 | 922 | Sheet1!Q15Unit: C15 |
| PR | 2023 | 122 | Sheet1!Q16Unit: C16 |
| DE | 2023 | 55 | Sheet1!Q18Unit: C18 |
| DC | 2023 | 69 | Sheet1!Q19Unit: C19 |
| MD | 2023 | 232 | Sheet1!Q20Unit: C20 |
| PA | 2023 | 682 | Sheet1!Q21Unit: C21 |
| VA | 2023 | 427 | Sheet1!Q22Unit: C22 |
| WV | 2023 | 187 | Sheet1!Q23Unit: C23 |
| VA EST | 2023 | 71 | Sheet1!Q24Unit: C24 |
| AL | 2023 | 415 | Sheet1!Q26Unit: C26 |
| FL | 2023 | 903 | Sheet1!Q27Unit: C27 |
| GA | 2023 | 375 | Sheet1!Q28Unit: C28 |
| KY | 2023 | 416 | Sheet1!Q29Unit: C29 |
| MS | 2023 | 201 | Sheet1!Q30Unit: C30 |
| NC | 2023 | 557 | Sheet1!Q31Unit: C31 |
| SC | 2023 | 264 | Sheet1!Q32Unit: C32 |
| TN | 2023 | 437 | Sheet1!Q33Unit: C33 |
| IL | 2023 | 393 | Sheet1!Q35Unit: C35 |
| IN | 2023 | 284 | Sheet1!Q36Unit: C36 |
| MI | 2023 | 644 | Sheet1!Q37Unit: C37 |
| MN | 2023 | 222 | Sheet1!Q38Unit: C38 |
| OH | 2023 | 584 | Sheet1!Q39Unit: C39 |
| WI | 2023 | 219 | Sheet1!Q40Unit: C40 |
| AR | 2023 | 380 | Sheet1!Q42Unit: C42 |
| LA | 2023 | 272 | Sheet1!Q43Unit: C43 |
| NM | 2023 | 137 | Sheet1!Q44Unit: C44 |
| OK | 2023 | 255 | Sheet1!Q45Unit: C45 |
| TX | 2023 | 649 | Sheet1!Q46Unit: C46 |
| AR EST | 2023 | 191 | Sheet1!Q47Unit: C47 |
| OK EST | 2023 | 65 | Sheet1!Q48Unit: C48 |
| IA | 2023 | 203 | Sheet1!Q50Unit: C50 |
| KS | 2023 | 67 | Sheet1!Q51Unit: C51 |
| MO | 2023 | 382 | Sheet1!Q52Unit: C52 |
| NE | 2023 | 89 | Sheet1!Q53Unit: C53 |
| CO | 2023 | 203 | Sheet1!Q55Unit: C55 |
| MT | 2023 | 40 | Sheet1!Q56Unit: C56 |
| ND | 2023 | 28 | Sheet1!Q57Unit: C57 |
| SD | 2023 | 45 | Sheet1!Q58Unit: C58 |
| UT | 2023 | 94 | Sheet1!Q59Unit: C59 |
| WY | 2023 | 26 | Sheet1!Q60Unit: C60 |
| AZ | 2023 | 319 | Sheet1!Q62Unit: C62 |
| CA | 2023 | 1289 | Sheet1!Q63Unit: C63 |
| HI | 2023 | 49 | Sheet1!Q64Unit: C64 |
| NV | 2023 | 159 | Sheet1!Q65Unit: C65 |
| AK | 2023 | 31 | Sheet1!Q67Unit: C67 |
| ID | 2023 | 93 | Sheet1!Q68Unit: C68 |
| OR | 2023 | 198 | Sheet1!Q69Unit: C69 |
| WA | 2023 | 354 | Sheet1!Q70Unit: C70 |
National SSDI reported ALL series
The selected 12 report dates run from July 28, 2023 through June 28, 2024. Values are reproduced from the ALL column, separate from Awards and Denials.
Unit and processing-method hold. The worksheet does not explicitly state days as the unit, mean or median, or processing start/end clock boundaries. The existing catalog days label and metric ID are retained as historical metadata; this replay does not establish those semantics.
ALL is reproduced as reported, not averaged from Awards and Denials. The title says SSDI but does not establish combined SSDI/SSI population or DDS-only handling time. The last populated report date is2024-06-28. The 09-30-24 filename does not establish later observations.
Publisher workbook. Preserved source SHA-256:
f26d1493cf0011335dd173a91b33c09351ab2c0fbc4f666deca74cd5bffedcf9
12 SSDI values with source cells and measurement limits (CSV). Each row retains the historical catalog unit separately; the workbook does not establish the unit, averaging method or processing clock. This is a historical export, not a publisher refresh.
Show 12 reported values and source cells
Worksheet title: “Monthy SSDI Processing Time | FY 2019 - Current”. Report Date is column A and ALL is column B. This table labels values as reported rather than newly confirming days.
| Report date | Reported ALL value | Workbook cells |
|---|---|---|
| 2023-07-28 | 205.7 | Data!B60Report date: A60 |
| 2023-08-25 | 202.7 | Data!B61Report date: A61 |
| 2023-09-29 | 205.7 | Data!B62Report date: A62 |
| 2023-10-27 | 205.7 | Data!B63Report date: A63 |
| 2023-11-24 | 207.1 | Data!B64Report date: A64 |
| 2023-12-29 | 208.9 | Data!B65Report date: A65 |
| 2024-01-26 | 212 | Data!B66Report date: A66 |
| 2024-02-23 | 213.6 | Data!B67Report date: A67 |
| 2024-03-29 | 211.4 | Data!B68Report date: A68 |
| 2024-04-26 | 211 | Data!B69Report date: A69 |
| 2024-05-31 | 211.7 | Data!B70Report date: A70 |
| 2024-06-28 | 217.3 | Data!B71Report date: A71 |
What this review establishes
Two read-only workbook readers agreed on the selected values and dates. This review supplies cell lineage without changing the source records, observation values, metric IDs, units, statuses, or earlier warnings.
The 30 OIG observations have a separate reviewed replay of the historical tables. That review does not resolve the SSDI workbook's unit or processing clock. The prior 300 named-count checks remain separately scoped. Publisher CSV schema, 14 unnamed columns, March 2025 payload and Medical CDR reconciliation holds remain unchanged.
Read the original two catalog definitions
These are retained historical definitions, including the existing days unit. Read them with the SSDI qualification above.
[
{
"id": "disability.dds.total_staff.annual",
"label": "Total state DDS employees",
"unit": "people",
"frequency": "federal fiscal year",
"population": "DDS staff in 55 source unit labels; not federal SSA employees",
"geography": "Source DDS/state and extended-team rows retained separately",
"definition": "Source total staff; exclude regional/grand totals before summing unit rows.",
"source_id": "ssa_dds_annual_staff",
"cautions": [
"Annual observations cannot be interpolated into monthly staff.",
"Some source unit-years are blank; blanks are not zero.",
"Headcount is not workyears or FTE."
]
},
{
"id": "disability.ssdi.processing_days.national_monthly",
"label": "SSDI processing time, national ALL series",
"unit": "days",
"frequency": "source monthly report date",
"population": "SSDI as titled by workbook; combined SSDI/SSI population not established",
"geography": "National; no state column",
"definition": "Source workbook ALL series; DDS-only handling-time scope is not established by workbook alone.",
"source_id": "ssa_ssdi_monthly_time",
"cautions": [
"Filename contains09-30-24 but the final populated observation is2024-06-28; no later values inferred.",
"Keep separate from OIG annual and DDS-only state averages."
]
}
]Cell lineage, original records and review limits (JSON)
Existing catalog definitions and observations (JSON) · Disability intake metrics · Medical CDR workload and its separate warnings
Rate definition holds
Three rate fields with unresolved program labels and formula references. No rate values are adopted.