About this Dataset

Payroll Based Journal Employee Detail Nursing Home Staffing

The Payroll Based Journal (PBJ) Employee Detail Nursing Home Staffing dataset provides information submitted by nursing homes including rehabilitation services on a quarterly basis. The data include a system generated employee identification number, work date, job type and employment status, and hours worked for each nursing home employee.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:24:15.818604
Tags: health-care-use-payments, hospitals-facilities, medicare, original-medicare, skilled-nursing

Tables

Payroll Based Journal Employee Detail Nursing Home Staffing : 2020-09-30

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_14e8733c

194.06 MB
62,546,983 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_14e8733c (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2023-03-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_1ee751fc

195.93 MB
59,753,276 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_1ee751fc (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "work_hrs_fn" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2022-06-30

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_1fcc298a

191.86 MB
58,433,653 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_1fcc298a (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2020-12-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_21e76313

192.02 MB
61,634,135 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_21e76313 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2023-09-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_22236239

202.35 MB
61,036,692 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_22236239 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "work_hrs_fn" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2021-03-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_26d1b740

186.89 MB
60,049,579 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_26d1b740 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2024-04-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_2a7ad134

200.46 MB
62,281,612 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_2a7ad134 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "work_hrs_fn" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2024-01-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_2b4614c9

199.99 MB
62,012,346 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_2b4614c9 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "work_hrs_fn" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2021-09-30

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_363f6234

188.42 MB
58,734,656 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_363f6234 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2021-12-31

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_54833c11

185.49 MB
57,576,077 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_54833c11 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "incomplete" BIGINT
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2022-12-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_5a9e0b79

195.96 MB
59,441,543 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_5a9e0b79 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2024-09-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_5b6c81e8

204.67 MB
63,260,729 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_5b6c81e8 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "work_hrs_fn" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2022-03-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_b4d734c3

185.75 MB
57,220,117 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_b4d734c3 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2025-01-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_b6189147

202.86 MB
63,067,823 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_b6189147 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "work_hrs_fn" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2024-12-31

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_bcf89bda

205.34 MB
64,167,198 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_bcf89bda (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "work_hrs_fn" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2022-09-30

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_d5b6b46c

195.76 MB
58,908,130 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_d5b6b46c (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2021-06-30

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_e2b8fb2c

187.25 MB
59,591,565 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_e2b8fb2c (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2020-06-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_ed8c93e8

195.13 MB
63,927,950 rows
8 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_ed8c93e8 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2023-06-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_f1700997

198.02 MB
60,397,055 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_f1700997 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "work_hrs_fn" DOUBLE
);

Payroll Based Journal Employee Detail Nursing Home Staffing : 2023-12-01

@usgov.hhs_gov_payroll_based_journal_employee_detail_nursing__e4cb8c53.payroll_based_journal_employee_detail_nursing_home_sta_f49087e6

200.98 MB
61,586,441 rows
9 columns

CREATE TABLE payroll_based_journal_employee_detail_nursing_home_sta_f49087e6 (
  "provnum" VARCHAR,
  "state" VARCHAR,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "sys_emplee_id" BIGINT,
  "emplee_job_cd_id" BIGINT,
  "emp_ctr" BIGINT,
  "work_hrs_num" DOUBLE,
  "work_hrs_fn" DOUBLE
);