About this Dataset

Payroll Based Journal Daily Non-Nurse Staffing

The Payroll Based Journal (PBJ) Nurse Staffing and Non-Nurse Staffing datasets provide information submitted by nursing homes including rehabilitation services on a quarterly basis. The data include the hours staff are paid to work each day, for each facility. Examples of reporting categories include Director of Nursing, Administrative Registered Nurses, Registered Nursing, Administrative Licensed Practice Nurses, Licensed Practice Nurses, Certified Nurse Aides, Certified Medication Aides, and Nurse Aides in Training. There are also other non-nurse staff categories provided in the data such as Respiratory Therapist, Occupational Therapist, and Social Worker. The datasets also include a facility’s daily census calculated using the Minimum Data Set (MDS) submission.

The Payroll Based Journal (PBJ) Employee Detail Nursing Home Staffing datasets and technical information have been moved to a new location.

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: 2022-01-25T02:04:03.217415
Tags: health-care-use-payments, hospitals-facilities, medicare, original-medicare, skilled-nursing

Tables

Payroll Based Journal Daily Non-Nurse Staffing : 2017-03-31

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_022f2.payroll_based_journal_daily_non_nurse_staffing_2017_03_31

36.52 MB
1,253,610 rows
81 columns

CREATE TABLE payroll_based_journal_daily_non_nurse_staffing_2017_03_31 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

Payroll Based Journal Daily Non-Nurse Staffing : 2017-06-30

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_022f2.payroll_based_journal_daily_non_nurse_staffing_2017_06_30

36.69 MB
1,272,544 rows
81 columns

CREATE TABLE payroll_based_journal_daily_non_nurse_staffing_2017_06_30 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

Payroll Based Journal Daily Non-Nurse Staffing : 2017-12-31

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_022f2.payroll_based_journal_daily_non_nurse_staffing_2017_12_31

37.11 MB
1,301,064 rows
81 columns

CREATE TABLE payroll_based_journal_daily_non_nurse_staffing_2017_12_31 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

Payroll Based Journal Daily Non-Nurse Staffing : 2018-12-31

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_022f2.payroll_based_journal_daily_non_nurse_staffing_2018_12_31

39.89 MB
1,372,272 rows
81 columns

CREATE TABLE payroll_based_journal_daily_non_nurse_staffing_2018_12_31 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);

Payroll Based Journal Daily Non-Nurse Staffing : 2019-03-31

@usgov.hhs_gov_payroll_based_journal_daily_non_nurse_staffing_022f2.payroll_based_journal_daily_non_nurse_staffing_2019_03_31

39.38 MB
1,355,220 rows
81 columns

CREATE TABLE payroll_based_journal_daily_non_nurse_staffing_2019_03_31 (
  "provnum" VARCHAR,
  "provname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "county_name" VARCHAR,
  "county_fips" BIGINT,
  "cy_qtr" VARCHAR,
  "workdate" BIGINT,
  "mdscensus" BIGINT,
  "hrs_admin" DOUBLE,
  "hrs_admin_emp" DOUBLE,
  "hrs_admin_ctr" DOUBLE,
  "hrs_meddir" DOUBLE,
  "hrs_meddir_emp" DOUBLE,
  "hrs_meddir_ctr" DOUBLE,
  "hrs_othmd" DOUBLE,
  "hrs_othmd_emp" DOUBLE,
  "hrs_othmd_ctr" DOUBLE,
  "hrs_pa" DOUBLE,
  "hrs_pa_emp" DOUBLE,
  "hrs_pa_ctr" DOUBLE,
  "hrs_np" DOUBLE,
  "hrs_np_emp" DOUBLE,
  "hrs_np_ctr" DOUBLE,
  "hrs_clinnrsspec" DOUBLE,
  "hrs_clinnrsspec_emp" DOUBLE,
  "hrs_clinnrsspec_ctr" DOUBLE,
  "hrs_pharmacist" DOUBLE,
  "hrs_pharmacist_emp" DOUBLE,
  "hrs_pharmacist_ctr" DOUBLE,
  "hrs_dietician" DOUBLE,
  "hrs_dietician_emp" DOUBLE,
  "hrs_dietician_ctr" DOUBLE,
  "hrs_feedasst" DOUBLE,
  "hrs_feedasst_emp" DOUBLE,
  "hrs_feedasst_ctr" DOUBLE,
  "hrs_ot" DOUBLE,
  "hrs_ot_emp" DOUBLE,
  "hrs_ot_ctr" DOUBLE,
  "hrs_otasst" DOUBLE,
  "hrs_otasst_emp" DOUBLE,
  "hrs_otasst_ctr" DOUBLE,
  "hrs_otaide" DOUBLE,
  "hrs_otaide_emp" DOUBLE,
  "hrs_otaide_ctr" DOUBLE,
  "hrs_pt" DOUBLE,
  "hrs_pt_emp" DOUBLE,
  "hrs_pt_ctr" DOUBLE,
  "hrs_ptasst" DOUBLE,
  "hrs_ptasst_emp" DOUBLE,
  "hrs_ptasst_ctr" DOUBLE,
  "hrs_ptaide" DOUBLE,
  "hrs_ptaide_emp" DOUBLE,
  "hrs_ptaide_ctr" DOUBLE,
  "hrs_respther" DOUBLE,
  "hrs_respther_emp" DOUBLE,
  "hrs_respther_ctr" DOUBLE,
  "hrs_resptech" DOUBLE,
  "hrs_resptech_emp" DOUBLE,
  "hrs_resptech_ctr" DOUBLE,
  "hrs_spclangpath" DOUBLE,
  "hrs_spclangpath_emp" DOUBLE,
  "hrs_spclangpath_ctr" DOUBLE,
  "hrs_therrecspec" DOUBLE,
  "hrs_therrecspec_emp" DOUBLE,
  "hrs_therrecspec_ctr" DOUBLE,
  "hrs_qualactvprof" DOUBLE,
  "hrs_qualactvprof_emp" DOUBLE,
  "hrs_qualactvprof_ctr" DOUBLE,
  "hrs_othactv" DOUBLE,
  "hrs_othactv_emp" DOUBLE,
  "hrs_othactv_ctr" DOUBLE,
  "hrs_qualsocwrk" DOUBLE,
  "hrs_qualsocwrk_emp" DOUBLE,
  "hrs_qualsocwrk_ctr" DOUBLE,
  "hrs_othsocwrk" DOUBLE,
  "hrs_othsocwrk_emp" DOUBLE,
  "hrs_othsocwrk_ctr" DOUBLE,
  "hrs_mhsvc" DOUBLE,
  "hrs_mhsvc_emp" DOUBLE,
  "hrs_mhsvc_ctr" DOUBLE
);