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.

Note: This full dataset contains more records than most spreadsheet programs can handle, which will result in an incomplete load of data. Use of a database or statistical software is required.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-07-31T18:55:58.854594
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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_14e8733c

185.07 MB
62546983 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_1ee751fc

122.11 MB
59753276 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_1fcc298a

182.97 MB
58433653 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_21e76313

183.12 MB
61634135 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_22236239

121.3 MB
61036692 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_26d1b740

178.23 MB
60049579 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_2a7ad134

113.49 MB
62281612 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_2b4614c9

114.9 MB
62012346 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_363f6234

179.69 MB
58734656 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_54833c11

176.9 MB
57576077 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_5a9e0b79

186.88 MB
59441543 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_5b6c81e8

115.55 MB
63260729 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_b4d734c3

177.15 MB
57220117 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_b6189147

113.34 MB
63067823 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_bcf89bda

115.17 MB
64167198 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_d5b6b46c

186.69 MB
58908130 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_e2b8fb2c

178.57 MB
59591565 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_ed8c93e8

186.09 MB
63927950 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_f1700997

119.19 MB
60397055 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__7aa6c963.payroll_based_journal_employee_detail_nursing_home_sta_f49087e6

118.5 MB
61586441 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
);