Load Work Accident Risk Codes and Rates

The first step is to load the CRM 34 file to the UCM server.

To load the CRM 34 file:

1. Connect to the UCM server for your environment and click New Check-In.
2. Enter a title of your choice. e.g. WorkAccidentLoader
3. Click Primary File – Browse.
4. Select the CRM 34 file from file system and click Check In at the bottom of page. The UCM content ID will be displayed.
5. Go to MyClientGRoups > Payroll > Submit a flow
6. Submit the Load Inbound Work Accident Rates flow with the UCM Content IDunder the Flow Parameters section.

The Load Inbound Work Accident Rates flow has the following tasks:

Task	Type
Upload Work Accident File to Interface Table	Standard process
Validate TRU Work Accident Data	Standard process
Generate TRU Work Accident Anomalies Report	Report
Review TRU Work Accident Anomalies Report	Manual
Create and Process TRU Calculation Card HDL File	Standard process
Transfer TRU Calculation Card HDL File	Data Loader
Validate TRU Primary Risk Code	Manual task
Validate TRU Primary Risk Code	Standard process
Generate TRU Primary Risk Code Anomalies Report	Report
Review TRU Primary Risk Code Anomalies Report	Manual

During the Upload Work Accident File to Interface Table task, the CRM 34 file is fetched from UCM, parsed and the content is stored in some internal interfacing tables. The data is then validated during the Validate TRU Work Accident Rate task (e.g. check that the SIRET is correct and corresponds to the SIRET of one TRU/Establishment in the database). This validation generates TRU work accident anomalies that can be reviewed manually in the Review TRU Work Accident Anomalies Report task. Please note that this a manual task so the user has to mark the task as complete after the review of the anomalies is performed.

TRU Statutory Card Updates

The flow carries on and automatically generates an HDL input file and loads it into the TRU Calculation card. At that point a manual task has to be performed to Designate a Primary risk code. The primary risk code cannot be designated as per TRU/Establishment in the CRM 34 file, if there are several risk codes for this given TRU/establishment.

Then, a report is produced to flag any anomalies (e.g. if several risk codes have been flagged as Primary for the same TRU/Reporting Establishment). The user can then perform the task Review the TRU Primary Risk Code Anomalies.

Person Statutory Card Updates

The flow carries on and automatically generates an HDL input file for updating the work accident component on the person statutory cards. The rate displayed is used as of that date to compute the work accident employer contribution, and the work accident rate component is updated on the employee's personal statutory card.

Note: When a person is hired into an establishment, assuming the reporting establishment has up-to-date work accident risk codes and rates, a work accident component is automatically created with the Primary Risk Code and associated work accident rate active as of that hire date. This is part of the hire flow and does not require an upload of work accident rates.

The existing exceptions to the primary risk code are preserved. So, if an employee has a nonprimary risk code and if the CRM 34 file contains a code update, then this employee’s Statutory Deductions card will be updated with the new rate for this risk code.