Hearings and Appeals Public Data Files Data Dictionary
| Data Field | Type, Length, Nullability | English Translation | Data Dictionary Definition | Values | ARPS MI or CPMS MI Table Source | Category | Report |
|---|---|---|---|---|---|---|---|
| AC_GRANT _REVIEW |
INTEGER NOT NULL | Appeals Council Grant Review Actions | AC actions taken on RRs categorized as grant review actions. Grant review actions include remand orders and new decisions issued by the AC. | COUNT | FPAR, FPDSAR | COUNT | AC Grant Review Actions as a Percentage of all AC Dispositions |
| AC_REMANDS | INTEGER NOT NULL | Appeals Council Remands | AC actions taken on RRs categorized as remand orders sent back to the hearing level for further action. | COUNT | FPAR, FPDSAR | COUNT | AC Remands as a Percentage of All AC Dispositions |
| ADJ_RCVD_CNT | INTEGER NOT NULL | Received Count | The number of adjusted receipts during the respective summary period. | COUNT | FPAR, FPALT, FPASDOH | COUNT | AC Requests for Review; NCC and Court Remands; Hearing Office Workload Data |
| ALL_AC_RR_ DISPOSITIONS |
INTEGER NOT NULL | All Appeals Council Request for Review Dispositions | The total of all types of dispositions issued by the AC on requests for review of hearing level actions. | COUNT | FPAR, FPDSAR | COUNT | AC Grant Review Actions as a Percentage of all AC Dispositions and AC Remands as a Percentage of All AC Dispositions |
| ALJ_NM25 | CHAR(25) NOT NULL | Administrative Law Judge Name | The name of the Administrative Law Judge. | MALJDOH | ALJ Disposition Data | ||
| APPEALABLE _AC_RR_ DISPOSITIONS |
INTEGER NOT NULL | Appealable Appeals Council Request for Review Dispositions | AC RR dispositions issued and considered appealable to federal court. For this report, appealable AC RR dispositions include denials of the RR and partially favorable or unfavorable AC decisions. | COUNT | FPAR, FPALT | COUNT | Appeals to Court as a Percentage of Appealable AC Dispositions |
| APPEALABLE _HO_ DISPOSITIONS |
INTEGER NOT NULL | Appealable Hearing Level Dispositions | For this report, unfavorable decisions, partially favorable decisions and dismissals issued at the hearing level are considered appealable. | COUNT | FPAR, MALJDOH | COUNT | Appeals to the AC as a Percentage of Appealable Hearing Level Dispositions |
| COURT_ REMANDS |
INTEGER NOT NULL | Court Remands | Cases returned by federal courts to the Social Security Administration for further action. | COUNT | FPALT | COUNT | Court Remands as a Percentage of New Court Cases Filed |
| DCN_CNT | INTEGER NOT NULL | Decision Count | The number of decision dispositions issued during the reporting period (i.e., the sum of the Fully Favorable, Partially Favorable, and Unfavorable decisions with a Disposition Date within the reporting period). | COUNT | FPASDOH | COUNT | ALJ Disposition Data |
| DLY_DSPN_ ALJ_ACNT |
DECIMAL (5, 2)NOT NULL | Daily Disposition Administrative Law Judge Average Count | The average number of dispositions released per day per available Administrative Law Judge during the reporting period. | AVERAGE COUNT | FPASDOH | AVERAGE COUNT | Hearing Office Dispositions Per ALJ Per Day Rate Ranking Report |
| DSPN_AVGPT | SMALLINT NOT NULL | Disposition Average Processing Time | For all dispositions in a report period, the average number of calendar days from the Hearing Request Date to the Disposition Date. | AVERAGE PROCESS- ING TIME |
FPASDOH | AVERAGE PROCESS- ING TIME |
Hearing Office Workload Data, Hearing Office Average Processing Time Ranking Report |
| DSPN_CNT | INTEGER NOT NULL | Disposition Count | The number of actions completed during the reporting period. | COUNT | FPAR, FPALT, FPASDOH | COUNT | AC Requests for Review; NCC and Court Remands; Hearing Office Workload Data |
| EFCASES | INTEGER NOT NULL | Electronic Cases Count | The number of electronic format cases pending at the end of the respective summary period. | COUNT | FPASEF | COUNT | Pending by Format |
| EF_PERCENT _CASES |
DECIMAL NOT NULL | Percent of Electronic Cases | The percentage of electronic format cases pending at the end of the respective summary period as compared to all cases pending. | SUM | CALCULATED FIELD | COUNT | Pending by Format |
| FFVRBL_DCN _CNT |
INTEGER NOT NULL | Fully Favorable Decision Count | The number of fully favorable decisions issued during the reporting period. For Concurrent Split decisions, this count includes Title 16 decisions that meet the same criteria. | COUNT | MALJDOH | COUNT | ALJ Disposition Data |
| FISCALYEAR | DATE NOT NULL | Fiscal Year Name | The name of fiscal year that the data represents. All counts shown are as of the end of the named fiscal year. | DATE | CALCULATED FIELD | DATE | All reports in the Annual category. |
| HO_CODE | CHAR(4) NOT NULL | Hearing Site Unique Identifier | The unique system-generated identifier of a given Hearing Office. | UNIQUE IDENTIFIER | UNIQUE IDENTIFIER | Average Wait Time Until Hearing Held Report | |
| HO_TIMES | INTEGER NOT NULL | Hearing Office Time in Months | The number days from the hearing request date to the hearing held date divided by 30. | SUM | CALCULATED FIELD | COUNT | Average Wait Time Until Hearing Held Report |
| HRG_HLD_CNT | INTEGER NOT NULL | Hearing Held Count | The total number of hearings held during the reporting period. | COUNT | FPASDOH | COUNT | Hearings Held In-Person or Via Video Conferencing |
| HEARINGS_HELD | INTEGER NOT NULL | Hearings Held In-Person | The number of hearings held without video teleconferencing equipment. | COUNT | MVIDHEAR | COUNT | Hearings Held In-Person or Via Video Conferencing |
| MONTH | DATE NOT NULL | Name of Month | The name of the month of the respective reporting period. | DATE | FPASDOH | DATE | Average Wait Time Until Hearing Held Report, Video Hearing (VH) Opt-Out Numbers and Rates for Hearing Requests Received |
| NEW_COURT_ CASES_FILED |
INTEGER NOT NULL | New Court Cases Filed | Receipts by the AC of new court actions filed with the federal courts after an appealable AC disposition is issued. | COUNT | FPALT, FPDSAR | COUNT | Appeals to Court as a Percentage of Appealable AC Dispositions and Court Remands as a Percentage of New Court Cases Filed |
| OFFICE | CHAR(25) NOT NULL | Office Name | The owning hearing office of the case. | HROFFICE | Hearing Office Workload Data, ALJ Disposition Data, Hearings Held In-Person or Via Video Conferencing, Average Wait Time Until Hearing Held Report | ||
| PAPERCASES | INTEGER NOT NULL | Paper Cases Count | The number of paper format cases pending at the end of the respective summary period. | COUNT | FPASEF, FPASDOH | COUNT | Pending by Format |
| PAPER_PERCENT _CASES |
DECIMAL NOT NULL | Percent of Paper Cases | The percentage of paper format cases pending at the end of the respective summary period as compared to all cases pending. | SUM | CALCULATED FIELD | COUNT | Pending by Format |
| PEND_END_CNT | INTEGER NOT NULL | Pending End Count | The number of cases pending (i.e., in a status other than "CLSD") at the end of the reporting period. | COUNT | FPAR, FPALT, FPASDOH | COUNT | AC Requests for Review; NCC and Court Remands; Hearing Office Workload Data |
| PERCENT_OPT-OUT | DECIMAL NOT NULL | Percent of VH Opt-Outs | The percent of objections to appearing by video teleconferencing filed by claimants/representatives in connection with request for hearing compared to all requests for hearing received in the same period. | SUM | CALCULATED FIELD | COUNT | Video Hearing (VH) Opt-Out Numbers and Rates for Hearing Requests Received |
| PERCENTAGE | DECIMAL NOT NULL | Percentage | The percentage of the top number as compared to the bottom number under each fiscal year. | SUM | CALCULATED FIELD | COUNT | All reports in the Annual category. |
| PERCENTALL | DECIMAL NOT NULL | Percentage of All | The percentage of the cited remand reason compared to the total of all remand reasons during the fiscal year. | SUM | CALCULATED FIELD | COUNT | Top 10 Remand Reasons Cited by the AC on Remands of RRs or Own Motion Reviews and Top 10 Remand Reasons Cited by the Court on Remands to SSA |
| PFVRBL_DCN _CNT |
INTEGER NOT NULL | Partially Favorable Decision Count | The number of partially favorable decisions issued during the reporting period. For Concurrent Split decisions, this count includes Title 16 decisions that meet the same criteria. | COUNT | MALJDOH | COUNT | ALJ Disposition Data |
| RANK | INTEGER NOT NULL | Rank | The rank of the office among the other hearing offices. | Hearing Office Dispositions Per ALJ Per Day Rate Ranking Report, Hearing Office Average Processing Time Ranking Report | |||
| RECEIPTS | INTEGER NOT NULL | Receipts | The count of adjusted receipts of requests for hearing or requests for review during the defined period. | SUM | FPAR, FPALT, FPASDOH | COUNT | Hearing Office Workload Data, Appeals Council Requests for Review, National New Court Cases and Court Remand Activity, Video Hearing (VH) Opt-Out Numbers and Rates for Hearing Requests Received |
| REGION | CHAR(3) NOT NULL | Regional Office Identification | The owning OHO Region name or number. | UNIQUE IDENTIFIER | FPASDOH | UNIQUE IDENTIFIER | Pending by Format |
| REMAND_ REASON |
CHAR (MULTIPLE) NOT NULL | Remand Reason | A reason for returning or remanding the case to either the HO or SSA. | UNIQUE REASON | PACAR, RMDRSN | UNIQUE REASON | Top 10 Remand Reasons Cited by the AC on Remands of RRs or Own Motion Reviews and Top 10 Remand Reasons Cited by the Court on Remands to SSA |
| RONUM | CHAR(2) NOT NULL | Regional Office Number | The Region for which the information is reported. | FPASDOH | Hearing Office Dispositions Per ALJ Per Day Rate Ranking Report, Hearing Office Average Processing Time Ranking Report | ||
| RPTG_PRD _ENDT |
DATE NOT NULL | Reporting Period End Date | The name of the month or quarter or the date of the last day in the respective reporting period. | DATE | FPAR, FPALT, FPASDOH | DATE | AC Requests for Review; NCC and Court Remands; Hearing Office Workload Data; ALJ Disposition Data; Hearing Office Dispositions Per ALJ Per Day Ranking Report; Hearing Office Average Processing Time Ranking Report; Hearings Held In-Person or Via Video Conferencing; Pending by Format |
| RR_RECEIPTS | INTEGER NOT NULL | Requests for Review Received | Requests for review of hearing level dispositions received. | COUNT | FPAR, MALJDOH | COUNT | Appeals to the AC as a Percentage of Appealable Hearing Level Dispositions |
| SITE_CODE | CHAR(3) NOT NULL | Hearing Site Office Code | The site code of the Hearing Office. | UNIQUE IDENTIFIER | UNIQUE IDENTIFIER | Average Wait Time Until Hearing Held Report | |
| TOTAL_ALJ_ DISPOSITIONS_ ACROSS_ALL_ OFFICES |
INTEGER NOT NULL | Total Administrative Law Judge Dispositions across all hearing offices | The sum of an Administrative Law Judge’s dispositions while working in any hearing office. This number will differ from that shown in the Disposition column when the Administrative Law Judge issued dispositions in multiple offices during the reporting period. | COUNT | FPASDOH | COUNT | ALJ Disposition Data |
| TOTALCASES | INTEGER NOT NULL | Total Cases Count | The number of all cases pending at the end of the respective summary period. | COUNT | FPASDOH | COUNT | Pending by Format |
| TOTAW | INTEGER NOT NULL | Total Awards | Total Awards equals the sum of the fully favorable and partially favorable decision counts. | SUM | CALCULATED FIELD | COUNT | ALJ Disposition Data |
| UFDCN_CNT | INTEGER NOT NULL | Unfavorable Decision Count | The number of unfavorable decisions issued during the reporting period. | COUNT | MALJDOH | COUNT | ALJ Disposition Data |
| VH_OPT-OUTS | INTEGER NOT NULL | Video Hearing Opt-Outs | The count of objections to appearing by video teleconferencing filed by claimants/representatives in connection with request for hearing. | COUNT | WRKUNH | COUNT | Video Hearing (VH) Opt-Out Numbers and Rates for Hearing Requests Received |
| VIDEO_ HEARINGS |
INTEGER NOT NULL | Video Teleconference Hearing Held Count | The number of video teleconference hearings held during the reporting period. | COUNT | MVIDYEAR | COUNT | Hearings Held In-Person or Via Video Conferencing |
| WRKDAYS | SMALLINT NOT NULL | Work Days | The number of the work days in the reporting period. | FPASDOH | COUNT | Hearing Office Dispositions Per ALJ Per Day Rate Ranking Report, Hearing Office Average Processing Time Ranking Report |