SecurityStat Metrics

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.

FY 2023 employees by source unit label
Source unitFiscal yearEmployeesWorkbook cells
CT2023154Sheet1!Q7
Unit: C7
ME202370Sheet1!Q8
Unit: C8
MA2023281Sheet1!Q9
Unit: C9
NH202361Sheet1!Q10
Unit: C10
RI202374Sheet1!Q11
Unit: C11
VT202352Sheet1!Q12
Unit: C12
NJ2023354Sheet1!Q14
Unit: C14
NY2023922Sheet1!Q15
Unit: C15
PR2023122Sheet1!Q16
Unit: C16
DE202355Sheet1!Q18
Unit: C18
DC202369Sheet1!Q19
Unit: C19
MD2023232Sheet1!Q20
Unit: C20
PA2023682Sheet1!Q21
Unit: C21
VA2023427Sheet1!Q22
Unit: C22
WV2023187Sheet1!Q23
Unit: C23
VA EST202371Sheet1!Q24
Unit: C24
AL2023415Sheet1!Q26
Unit: C26
FL2023903Sheet1!Q27
Unit: C27
GA2023375Sheet1!Q28
Unit: C28
KY2023416Sheet1!Q29
Unit: C29
MS2023201Sheet1!Q30
Unit: C30
NC2023557Sheet1!Q31
Unit: C31
SC2023264Sheet1!Q32
Unit: C32
TN2023437Sheet1!Q33
Unit: C33
IL2023393Sheet1!Q35
Unit: C35
IN2023284Sheet1!Q36
Unit: C36
MI2023644Sheet1!Q37
Unit: C37
MN2023222Sheet1!Q38
Unit: C38
OH2023584Sheet1!Q39
Unit: C39
WI2023219Sheet1!Q40
Unit: C40
AR2023380Sheet1!Q42
Unit: C42
LA2023272Sheet1!Q43
Unit: C43
NM2023137Sheet1!Q44
Unit: C44
OK2023255Sheet1!Q45
Unit: C45
TX2023649Sheet1!Q46
Unit: C46
AR EST2023191Sheet1!Q47
Unit: C47
OK EST202365Sheet1!Q48
Unit: C48
IA2023203Sheet1!Q50
Unit: C50
KS202367Sheet1!Q51
Unit: C51
MO2023382Sheet1!Q52
Unit: C52
NE202389Sheet1!Q53
Unit: C53
CO2023203Sheet1!Q55
Unit: C55
MT202340Sheet1!Q56
Unit: C56
ND202328Sheet1!Q57
Unit: C57
SD202345Sheet1!Q58
Unit: C58
UT202394Sheet1!Q59
Unit: C59
WY202326Sheet1!Q60
Unit: C60
AZ2023319Sheet1!Q62
Unit: C62
CA20231289Sheet1!Q63
Unit: C63
HI202349Sheet1!Q64
Unit: C64
NV2023159Sheet1!Q65
Unit: C65
AK202331Sheet1!Q67
Unit: C67
ID202393Sheet1!Q68
Unit: C68
OR2023198Sheet1!Q69
Unit: C69
WA2023354Sheet1!Q70
Unit: 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.

ALL values by exact source report date
Report dateReported ALL valueWorkbook cells
2023-07-28205.7Data!B60
Report date: A60
2023-08-25202.7Data!B61
Report date: A61
2023-09-29205.7Data!B62
Report date: A62
2023-10-27205.7Data!B63
Report date: A63
2023-11-24207.1Data!B64
Report date: A64
2023-12-29208.9Data!B65
Report date: A65
2024-01-26212Data!B66
Report date: A66
2024-02-23213.6Data!B67
Report date: A67
2024-03-29211.4Data!B68
Report date: A68
2024-04-26211Data!B69
Report date: A69
2024-05-31211.7Data!B70
Report date: A70
2024-06-28217.3Data!B71
Report 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