©LCPtracker, Inc. – All Rights Reserved Page 1 of 9 The information provided in this document is copyrighted by ©LCPtracker, Inc., and shall not be released or distributed in any way without the express written consent of LCPtracker, Inc.

LCPTRACKER DIR XML EXPORT The California – Senate Bill (SB) 854 is the driving force behind the creation of the LCPtracker XML Export feature. The Division of Industrial Relations (DIR) has created specific specifications. As well, the DIR has its own site for uploading of required documentation, specifically the uploading of certified payroll. We have included this link within LCPtracker that will take you directly to their site - http://www.dir.ca.gov/Public-

Works/PublicWorks.html

Four Major Items to remember:

1. The DIR Project ID must be entered in the Projects Screen

2. The Contractor PWCR Number must be entered in the Contractor Information Screen

3. The FEIN must be entered in the Contractor Information Screen

4. The state abbreviation in the Contractor Screen must be Uppercase (CA not Ca)

ACCOUNT OWNERS/ADMINISTRATORS/AWARDING BODIES - For Administrators in LCPtracker we have added a new field in the Add/Edit Projects screen – DIR Project ID. Once you choose the State as California for your Project this field will appear, along with the link as we show here. The link will take you to the Public Works Projects Registration (PWC-100) for all Awarding Agencies. From here you can sign in or if you have not yet signed up, select their First Time User button - https://www.dir.ca.gov/pwc100ext/

©LCPtracker, Inc. – All Rights Reserved Page 2 of 9 The information provided in this document is copyrighted by ©LCPtracker, Inc., and shall not be released or distributed in any way without the express written consent of LCPtracker, Inc.

Per the Department of Industrial Relations –

Depending on your Administrator Role, you may or may not be able to export your Subcontractors CPR out of LCPtracker. For those with the capability to do so, you will see the DIR XML button under the Certification navigation tab next to the PDF in the View CPR column.

If you filter by project and do not see the DIR XML option, as shown in the above screen capture, go to Set Up navigation tab and choose to Add/Edit Project. The State field must equal California.

©LCPtracker, Inc. – All Rights Reserved Page 3 of 9 The information provided in this document is copyrighted by ©LCPtracker, Inc., and shall not be released or distributed in any way without the express written consent of LCPtracker, Inc.

ALL USERS - LCPtracker has added an additional field to the Add/Edit Subcontractor screen, as well as the Company Information page, the PWCR Number field. NOTE that if the Agency/Account Owner does not allow Contractors/ Subcontractors to set up their own Subcontractors, this field as well as link will be accessible under the Set Up navigation tab under the Company Information screen.

CONTRACTORS /SUBCONTRACTORS - Contractors not yet registered, use the link in the Add/Edit Contractor screen, Company Information screen (above screen capture) or this direct link https://efiling.dir.ca.gov/PWCR/ActionServlet?action=displayPWCRegistrationForm Contractors also have the ability to export their CPRs. This option will be located under the Projects navigation tab, under the sub-tab Certifications. If the project is located in California and you do not see, please contact your “Show Info” link to discuss.

©LCPtracker, Inc. – All Rights Reserved Page 4 of 9 The information provided in this document is copyrighted by ©LCPtracker, Inc., and shall not be released or distributed in any way without the express written consent of LCPtracker, Inc.

ALL USERS EXPORT /UPLOAD DIRECTIONS - When it comes to using the DIR XML, regardless of exporting as the Administrator or as a Contractor, the process will be the same. Click on the DIR XML button for the project and week-end-date you need to upload. You will see this at the bottom of your screen. While you may open, we suggest clicking the down arrow next to save and choose to SAVE AS –

Decide where on your computer you will be saving. One suggestion is create a folder that your XML Exports or DIR Uploads. When you go to upload, you will know exactly where to retrieve the file.

While you may choose to save and open, or wish to open before saving to view; most may choose to SAVE AS and proceed to the DIR website to upload. Here is an example of what the DIR XML looks like –

©LCPtracker, Inc. – All Rights Reserved Page 5 of 9 The information provided in this document is copyrighted by ©LCPtracker, Inc., and shall not be released or distributed in any way without the express written consent of LCPtracker, Inc.

Here is the link to the upload page - https://efiling.dir.ca.gov/eCPR/pages/home.jsp Once here, “Browse” your computer and find the XML Export you SAVED AS out of LCPtracker.

Once you have found that document, you are ready to click the Upload button.

Once the DIR site has Validation Success, you are ready to follow steps necessary to complete the process.

©LCPtracker, Inc. – All Rights Reserved Page 6 of 9 The information provided in this document is copyrighted by ©LCPtracker, Inc., and shall not be released or distributed in any way without the express written consent of LCPtracker, Inc.

Click ‘load the xml into the OnLine eCPR form’. The Uploaded Data now appears in the online form for your review. Follow steps to complete the submission. Remember this is legal and binding and you should review all information for accuracy prior to electronically signing and accepting to submit.

©LCPtracker, Inc. – All Rights Reserved Page 7 of 9 The information provided in this document is copyrighted by ©LCPtracker, Inc., and shall not be released or distributed in any way without the express written consent of LCPtracker, Inc.

Example of DIR eCPR Online Form (SSN field blanked out on purpose).

©LCPtracker, Inc. – All Rights Reserved Page 8 of 9 The information provided in this document is copyrighted by ©LCPtracker, Inc., and shall not be released or distributed in any way without the express written consent of LCPtracker, Inc.

If you are a new Contractor, click the ‘Add New Contractor’ button to create your contractor record. Always check that your information is correct.

If a new project you have not yet submitted information on, click the ‘Add New Project’ button to create. Again, always check the information to be sure it is correct.

Final step review your payroll information.

©LCPtracker, Inc. – All Rights Reserved Page 9 of 9 The information provided in this document is copyrighted by ©LCPtracker, Inc., and shall not be released or distributed in any way without the express written consent of LCPtracker, Inc.

After reviewing for accuracy, you are ready to complete information. Enter your name, title (position in company) and company name. Click to Sign.

To Accept, click Accept (or Not Accept)

It has now accepted and now you are ready to Submit.

eCPR Online Form has been submitted.

<BE SURE TO PRINT THIS PAGE!