Difference between revisions of "PBJ Export"

From sbv.wiki
Jump to: navigation, search
(Frequently Asked Questions)
(Frequently Asked Questions)
Line 157: Line 157:
 
'''Answer:''' SBV is providing access to the PBJ module to all current clients without requiring the license to the PBJ module for submissions up until January 15th, 2017. From January 15th, 2017, clients will need to purchase a license to continue to submit to PBJ.
 
'''Answer:''' SBV is providing access to the PBJ module to all current clients without requiring the license to the PBJ module for submissions up until January 15th, 2017. From January 15th, 2017, clients will need to purchase a license to continue to submit to PBJ.
  
'''Question:''' I want to look at the contents of the zip / xml file. What program should I use?
 
  
'''Answer:'''  
+
'''Question:''' I want to look at the contents of the zip / xml file. What program should I use?
  
[https://www.microsoft.com/en-us/download/details.aspx?id=7973 XML Notepad]
+
'''Answer:''' You can right click on the zip file and choose Extract All which will allow you to save the XML file. You can then open the XML file in notepad or a web browser. You can slo try the following free programs which handle XML well:
 +
 
 +
* [https://www.microsoft.com/en-us/download/details.aspx?id=7973 XML Notepad]
 +
* [https://notepad-plus-plus.org Notepad++]

Revision as of 00:27, 9 November 2016

Overview

The Payroll Based Journal is a system for facilities to submit staffing and census information to the Centers for Medicare and Medicaid Services (CMS). CMS started collecting staffing and census data through the PBJ system on a voluntary basis on October 1, 2015, and now collects it on a mandatory basis since July 1, 2016. Each calendar quarter needs to be submitted within 45 days after the end of each quarter. For example, July - September will need to be submitted by November 14th.

CMS provides a website where the data is submitted. The data can be manually entered, and/or imported from one or more files. The SBV software creates the file from your time card data so as to eliminate manual entry. Please note that the SBV software only creates PBJ data from the time card data in the SBV software. The PBJ file is essentially a payroll export. It functions similar to the file that you create for exporting the employee's time card data to your payroll system. The PBJ file has to be created to the correct specifications and contain the correct data. SBV is creating the file to the correct specifications. The file will contain the correct data if the correct mappings between the SBV data and the PBJ data are completed correctly. The instructions below show you how to specify all the required mappings between SBV and PBJ so that once the mappings are completed, you can create the file ready for submission to PBJ, and it will contain the correct data.

For information on PBJ, please refer to the following websites:

PBJ Module

To see if your software has the PBJ module, go to the Help tab and click on About and look for PBJ in the list of modules. At the same time you can note your software version which displays in the format such as 3.5.6001.12345. The third number (6001) is your version number. Certain features may not be in your software if your version number is less than the version number in which a new feature was added.

Requirements

In order to submit the data in the Time and Attendance software to CMS using the SBV software you need to know the following:

  • Your PBJ Facility ID and the state that the facility is in
  • The employees that you will submit as exempt (i.e. salaried)
  • The companies that contain employees that you pay directly (payroll) as opposed to agency or 1099 contractors that are considered contracted staff, or alternatively, the departments that contain the contract staff
  • The PBJ Job Title Code for each employee (that you want to submit)
  • The pay types that you consider are worked hours for PBJ purposes

The data required by CMS is organized into 4 sections; header, employees, hours and census. Within each section, the Time and Attendance software requires you to provide the necessary CMS/PBJ mapping information so that we can convert the Time and Attendance data into CMS/PBJ compliant data. The items that you must complete are indicated below as Required.

Header

The header contains information to identify your facility and the state that your facility is in.

Required: You need to enter your PBJ facility identifier and state into the software. For a single facility software the PBJ Facility ID is entered in Configuration / Setup / System / Payroll. The state is entered in Configuration / Setup / System / Defaults. In a multi-facility software both the PBJ Facility ID and the state are entered in Configuration / Setup / Labor Levels / Facility in the Optional tab.

Employees

Employee information that PBJ requires are hire and termination dates, and whether you consider the employee to be exempt, non-exempt or contract.

Hire and Termination Dates

EmployeeStatusPBJStatusType.png

The PBJ Status Type column in the Employee / Status tab gives you complete control over the Hire Dates and Termination Dates submitted to PBJ. If an active date is not a hire date but a return to active status after a medical or long term leave, you can tell the software to ignore this status for PBJ.

Hire dates are required for all staff. There are 2 methods that the software will use to determine the Hire Date:

  1. The latest employee status (Employee / Status tab) with the PBJ Status Type of Hire Date.
  2. The first day that the employee worked and has hours.

Note: There is the requirement that a rehired employee that has had a termination date previously submitted to PBJ can only be submitted with a hire date that is later than the previously submitted termination date. If an employees has a PBJ Status Type of Hire Date after a PBJ Status Type of Termination Date then we will include only the PBJ Hire Date in the file. We will also not assume any Termination date because no punch or hours information exists. As such, unless the employee has a PBJ Status Type entry of Termination Date in their Status tab, we will assume that they are still currently active.

Exempt, Non-Exempt, Contract

PBJ requires a Pay Type Code which is used to distinguish Exempt, Non-Exempt and Contract staff. For PBJ purposes, Exempt is what you usually refer to as Salaried in payroll. It does not mean that you want to exclude this employee from PBJ. Contract means any staff that you do not pay directly, e.g. from an agency, or a 1099 vendor.

If you have a company labor level, there is a setting named Is In House that will distinguish contract staff from your payroll employees. If you do not have a company labor level, there is a setting on each department named Is Contract. We recommend that you use either the company level or the department level to distinguish your employees (payroll) for outside employees / contractors.

Required: Decide if you will use the Company or the Department labor level to distinguish contract staff from your payroll employees. If using Company then go to Configuration / Setup / Labor Levels / Company, and in the Optional tab select Is In House for your payroll companies. If using Department then go to Configuration / Setup / Labor Levels / Department, and in the Optional tab select Is Contract for your contract departments.

To distinguish your exempt (salaried) from your non-exempt (hourly) staff we are providing three ways that you can do this; on the pay rule, on the base schedule group level, or on the employee.

Required: Determine how you will identify your exempt staff. This is done by using the Is PBJ Exempt setting in either the pay rule (Configuration / Calculation / Pay Rules / Misc tab), the base schedule group (Configuration / Schedules / Base Schedules), or on a per employee basis on the Employee / Misc tab. For example, if you have a pay rule that is used with Salaried staff then by using the Is PBJ Exempt setting on this pay rule, all employees using this pay rule will be identified as exempt.

IsPBJExemptCheckbox.png

Hours

CMS states that only the employee's paid hours for time worked are to be submitted. You should not submit hours that were worked and were not paid, nor submit hours that were paid and were not worked.

Note: If you wish to include Agency and contract staff in your PBJ file, then the minimum requirement will be to have the employee entered into the software and their worked hours entered on the time cards.

Required: Specify the PBJ Job Title Code for each department. You can also choose Exclude From Report for departments that are not considered to be direct care. This is done is Configuration / Setup / Labor Levels / Department in the Optional tab. If you have some employees that need to be reported with a PBJ Job Title Code that does not match their department, contact SBV and they will add a new PBJ labor level which will allow you to specify the PBJ Job Title Code on an individual employee basis.

PBJJobTitleCodeDropdown.png

Required: Select the pay types that are considered worked making sure not to include matching pay types such as differentials. This is done in Configuration / Schedules / Pay Types in the Rates and Payroll tab. The setting is named Is PBJ Pay Type.

IsPBJPayTypeCheckbox.png

Note: The following hours are included in the file:

  • All time calculated from punches that occurs between midnight to midnight from the the start date at 12:00am until the end date at 11:59pm.
  • All hours not from punches with an actual date between the start date and end date. Example of these hours may be owed time or salaried non punching employees.
  • The maximum number of hours that can be submitted in a single date is 24 so if you are entering salaried or owed time on one date, it cannot exceed 24 hours.

Census

The census can be included in the PBJ file or can be manually entered on the PBJ website after submitting the file.

For each month of the PBJ report there are 3 census numbers; Medicaid, Medicare and Other.

Note: the PBJ monthly census is entered from Tools / PBJ Census. The census should be based on the last day of the month, and needs to be split between Medicaid, Medicare and Other. The census does not have to be submitted in the file and can be entered manually on the PBJ website.

PBJCensusForm.png

Creating the File

*** Do not forget to include inactive employees in your report ***

The Time and Attendance software creates the ZIP file(s) as required by CMS. Each ZIP file contains a single XML file. If your software contains a single facility then the zip file will be named pbj.zip and the xml file in the zip file will be named pbj.xml. In a multi-facility software, the zip and xml file will both be named using the facility description.

The PBJ Export is run from Reports / File Export / PBJ (Payroll Based Journal).

ReportsFileExportMenu.png

You can only include data from the same fiscal quarter in the file. The minimum date range is one day and the maximum date range is the three calendar months from the same fiscal quarter.

Important: When running the PBJ Export do NOT exclude any employees except in a multi-facility setup when you want to run the export for just a single facility. As such, do NOT filter any employees and be sure to include all statuses under Current Status.

After you run the export, the folder where the PBJ files are created will open automatically. In case you close this folder, you can access it from Tools / Folders / PBJ Folder. Please note that users connecting to the software using remote deployment software such as Citrix or RemoteApp should email the files to themselves from the Options tab.

The same data that is placed into the PBJ file can be viewed in Excel format by running the PBJ Hours Detail (Excel) report also from the Reports / File Export menu.

ToolsFoldersPBJFolder.png

Important: The software will create a log file in the PBJ folder that will point out any issues with the PBJ file that have been handled but may indicate that some of your information is incorrect or is missing from the PBJ file. It will include information about the data causing the issue for troubleshooting. For example, if you have hours after a termination date. The file is named pbj.log in a single facility software and in a multi-facility software it will be named after the facility.

Software Revisions

6075: Merge is now the default submission method which allows you to submit the quarter in multiple files. Prior versions need to submit the complete quarter in one file.

6136: The PBJ files are now placed on your local computer rather than on your network. When using the CMSNet Secure Access Service, the following resources are unavailable; public networks, local networks, network printers, file servers, database servers, mail servers and remote connectivity software. For clients connecting to remote servers, the PBJ files should be emailed and then saved to the local computer before connecting securely to CMS.

6147: Improvements to the allocation of hours from midnight to midnight have been added. This improves the allocation for salaried employees that were punching through midnight and had a cap on their calculated hours.

6156: The XML file is now indented which will now provide an informative line number from PBJ if you your file is rejected.

Frequently Asked Questions

Question: Do you know my PBJ Facility ID or can you get it for me?

Answer: SBV has no access to the PBJ system so you need to get your PBJ Facility ID directly from CMS directly. Here is a link to get access to the PBJ system


Question: Does the SBV software submit the PBJ file?

Answer: No, our software creates the file but you submit the file to the CMS system. Our software does not "talk" directly to the CMS system.


Question: Should this employee, department or pay type be included in the submission to PBJ?

Answer: SBV cannot advise you on what information should be submitted to PBJ. CMS states "reporting should be based on the employee’s primary role and their official categorical title. It is understood that most roles have a variety of non-primary duties that are conducted throughout the day (e.g., helping out others when needed). Facilities should still report just the total (worked) hours of that employee based on their primary role."


Question: Is this position (i.e. DNS, ADNS, RN Office, Dietary) considered "direct care"?

Answer: CMS provides a list of PBJ Job Title Codes and you can assign a Job Title Code to any department that matches to one of these Job Title Codes. Job Title Codes that CMS considers are not direct care can be selected and CMS will ignore this data, e.g. Housekeeping. Some departments such as Food Service Workers do not have a corresponding Job Title Code to choose which infers that Food Service Workers are not considered direct care.


Question: How does CMS define "direct care"?

Answer: CMS defines direct care as "direct care staff are those individuals who, through interpersonal contact with residents or resident care management, provide care and services to allow residents to attain or maintain the highest practicable physical, mental, and psychosocial well-being. Direct care staff does not include individuals whose primary duty is maintaining the physical environment of the long term care facility (for example, housekeeping)."


Question: If I have the PBJ module, does this mean that I have the license to the PBJ module?

Answer: SBV is providing access to the PBJ module to all current clients without requiring the license to the PBJ module for submissions up until January 15th, 2017. From January 15th, 2017, clients will need to purchase a license to continue to submit to PBJ.


Question: I want to look at the contents of the zip / xml file. What program should I use?

Answer: You can right click on the zip file and choose Extract All which will allow you to save the XML file. You can then open the XML file in notepad or a web browser. You can slo try the following free programs which handle XML well: