Office of Disability Adjudication and Review 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
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
ALJ_NM25 CHAR(25) NOT NULL Administrative Law Judge Name The name of the Administrative Law Judge.   MALJDOH   ALJ Disposition Data
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 PROCESSING TIME FPASDOH AVERAGE PROCESSING 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
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
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
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
REGION CHAR(3) NOT NULL Regional Office Identification The owning ODAR Region name or number. UNIQUE IDENTIFIER FPASDOH UNIQUE IDENTIFIER Pending by Format
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
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
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