> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.2cloudnine.com/llms.txt
> Use this file to discover all available pages before exploring further.

# QRG Update Rates Automation - Minimum Pay Rates

export const InlineImage = ({src, alt = "", height = "1.6em"}) => {
  return <img noZoom src={src} alt={alt} style={{
    display: "inline",
    verticalAlign: "start",
    height: height,
    margin: "0"
  }} />;
};

## Purpose

The purpose of this quick reference guide is to step through the process of updating Minimum Pay Rates (MPRs) using the Update Rates User Interface (UI). The intended audience for this document is System Administrators / Standard Users.

## Steps

### Update Minimum Pay Rates

The Update Rates UI enables the automatic update of Minimum Pay Rates and related Assignment Rate records to be completed in bulk.

Pay Rates may be updated using percentages, dollar figures, or as individual values for each record selected when the UI is launched. Once rates have been calculated, reviewed and confirmed, automation will expire the existing records and create new MPRs, enabling new Assignment Rates to be generated. Existing MPRs and related Assignment Rates will be set to expire one day before the Effective Date entered for the new rates.

* For Parent MPR records, Rate updates will also trigger record expiry/recreation for Child MPRs using inherited Rate values. Child records with defined Rates will however require manual update to enable Rates Automation. This may be completed either by selecting both Parent and Child MPR records when launching the UI, or by creating separate batches to update Rates defined in Child MPRs, following the completion of all Parent MPRs updates.

Use the Update Rates UI to modify MPR records by following the steps below:

1. <Columns cols={2}>
     <Column>
       Click on the **App Launcher** icon (see Figure 1).
     </Column>

     <Column>
       <Frame>
         <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-0-figure-1.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=40e579bb8fbb8d534210e91e74910934" alt="Figure 1" width="471" height="226" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-0-figure-1.png" />
       </Frame>
     </Column>
   </Columns>

2. <Columns cols={2}>
     <Column>
       Go to the **Minimum Pay Rate** object by using the Search function (see Figure 2).
     </Column>

     <Column>
       <Frame>
         <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-0-figure-2.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=ca8c72bf6e4dceccf3e18dacac5f0666" alt="Figure 2" width="471" height="389" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-0-figure-2.png" />
       </Frame>
     </Column>
   </Columns>

3. Select the MPR records to be updated:
   1. Click the checkbox next to each Minimum Pay Rate record that you would like to update (see Figure 3).

      <Frame>
        <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-1-figure-3.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=70e08dfd78a7a5bfd06d5bb2a6f46e11" alt="Figure 3" width="1008" height="336" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-1-figure-3.png" />
      </Frame>

      **OR**
   2. Select the checkbox in the heading row to select all the Minimum Pay Rate records displayed in the current List View (see Figure 4).

      <Frame>
        <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-1-figure-4.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=26ccc2ce24ca4ff2e970e9032a5c7cc5" alt="Figure 4" width="1008" height="345" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-1-figure-4.png" />
      </Frame>

<Warning>
  **Important Notes**\
  (Review records before processing)

  All Users are required to optimise processing by updating the Archiving Status = Archived for all Expired Assignment Rates before initiating any rate updates. This will remove outdated records from being reviewed for possible updates to be applied. Before initiating updates to Rate records, please be mindful of any existing MPR Parent/Child relationships, along with the downstream effects for associated data. Parent MPRs cannot be updated with an Expiry Date exceeding that of related Child records.
</Warning>

4. Once your selection is made, click the **Update Rates** button in the top right corner to launch the Updates Rates UI (see Figure 5).

   <Frame>
     <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-2-figure-5.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=71387bdc3de2c3b42d2b893ef81b8579" alt="Figure 5" width="1008" height="334" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-2-figure-5.png" />
   </Frame>

<Columns cols={2}>
  <Column>
    5) Populate the **Effective Date** for the Rate changes (see Figure 6).
    6) In **Update Rates By** , choose one of the options shown to define how the rates will be updated:
       1. **Increase Rates by %**
       2. **Increase Rates by \$**
       3. **Enter Rate Changes Individually**
    7) Click the **OK** button.
  </Column>

  <Column>
    <Frame>
      <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-2-figure-6.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=41a6132b5ce3bdc13c28b24413609ab2" alt="Figure 6" width="471" height="386" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-2-figure-6.png" />
    </Frame>
  </Column>
</Columns>

8. The Update Rates UI will now display the details for each selected MPR in the **Increase Rates By** tab, along with a count of the total records that may be updated (see Figure 7).

   1. To change the rate update method selected, or update the Effective Date populated, simply click the **+** icon in the top right corner of the window.
   2. Modify the sort order by clicking the desired column heading (i.e. Interpretation Rule, Pay Code, etc.) to re-order listed records.
   3. If Parent MPRs have been selected for update, click the <InlineImage src="/images/icons/qrg-update-rates-automation-minimum-pay-rates-inline-2-1.png" /> icon to review the related Child records.
   4. If Child MPRs have been selected for update, the related Parent will be displayed in the **Parent Minimum Pay Rate** column.

<Frame>
  <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-2-figure-7.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=70851ae821a4b25441cfae9f2bc312fe" alt="Figure 7" width="1008" height="319" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-2-figure-7.png" />
</Frame>

<Warning>
  **Important Notes**\
  (Child MPRs)

  Child MPRs without defined Pay Rates (i.e where Rates are inherited from the Parent) will not be displayed in the UI, however they will still be expired/re-created alongside any Rate changes made to the related Parent record.
</Warning>

9. If you selected Increase Rates by %, follow the sub-steps below, otherwise skip to step 10:
   1. Populate the **Increase %** field with the value of the percentage increase to be calculated for all Minimum Pay Rates records listed (see Figure 8).

      <Frame>
        <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-3-figure-8.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=3e208b3def0d52fa77e6cc1cdd46daab" alt="Figure 8" width="1008" height="306" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-3-figure-8.png" />
      </Frame>
   2. Click **Calculate** to update **New Pay Rate** values for all MPR records displayed (see Figure 9).

      <Frame>
        <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-3-figure-9.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=58b314b931b77ecdf80364627da93580" alt="Figure 9" width="1008" height="298" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-3-figure-9.png" />
      </Frame>

10. If you selected Increase Rates by \$, follow the sub-steps below, otherwise skip to step 12:
    1. Populate the **Increase \$** field with the value of the amount increase to be added to all Minimum Pay Rates records listed (see Figure 10).

       <Frame>
         <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-3-figure-10.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=46dc09fec715206a29b165d718ab18b2" alt="Figure 10" width="1008" height="300" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-3-figure-10.png" />
       </Frame>

11. Click **Calculate** to calculate new Pay Rates for all MPR records displayed (see Figure 11).

<Frame>
  <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-4-figure-11.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=04e7f42b606e60027b452940cb5a1790" alt="Figure 11" width="1008" height="296" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-4-figure-11.png" />
</Frame>

12. If you selected Enter Rate Changes Individually, follow the sub-steps below:

    1. Click the pencil icon that appears next to the **New Pay Rate** value (see Figure 12).

       <Frame>
         <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-4-figure-12.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=4fea01fc4696d6dcd8b8f655531362f0" alt="Figure 12" width="1008" height="291" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-4-figure-12.png" />
       </Frame>

    <Columns cols={2}>
      <Column>
        2) From the Edit Rates window, enter the new amount in the **New Pay Rate** field and click **Save** (see Figure 13).
        3) Repeat the above steps for each row that requires updates.
      </Column>

      <Column>
        <Frame>
          <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-4-figure-13.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=018afd25d2e174e88fe9e190d3c2c283" alt="Figure 13" width="471" height="245" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-4-figure-13.png" />
        </Frame>
      </Column>
    </Columns>

13. Once changes have been successfully Calculated, review the updated values displayed in the **New Pay Rate** column (see Figure 14).

<Frame>
  <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-4-figure-14.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=d394ca9e6ddfbf782a7728800618cc2a" alt="Figure 14" width="1008" height="305" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-4-figure-14.png" />
</Frame>

14. To create new records for the Effective Date entered with the new rate detailed, and update existing records to expire one day prior, click the **Confirm New Rates** button, or select **Return** to cancel updates (see Figure 15).

<Frame>
  <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-5-figure-15.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=45117a2fc6bc6e2dcbccf8f9fd93f189" alt="Figure 15" width="1008" height="307" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-5-figure-15.png" />
</Frame>

<Warning>
  **Important Notes**\
  (Confirm New Rates)

  Please note, any changes made to Minimum Pay Rates cannot be reversed after this point. If the error ‘The Effective Date cannot be greater than the Expiry Date’ is encountered, please ensure the new effective period defined for selected Child MPRs align with the related Parent MPR. Update Rates UI will not allow updates causing new Child MPRs to be orphaned from the related Parent MPR.
</Warning>

15. If Update Rate automation is successful, the following message will be displayed once processing is completed (see Figure 16).
    1. To go back to the Minimum Pay Rate Object and review the changes made, click the **Return** button.
       <Frame>
         <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-5-figure-16.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=f6c4b758247cc08f368fdfd87be1048d" alt="Figure 16" width="1008" height="352" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-5-figure-16.png" />
       </Frame>

### Disable Assignment Rate Creation

Once updates for the selected MPR records have been created, the existing MPRs and related Assignment Rates will be set to expire, to be replaced by new Assignment Rates containing the updated MPR rates.

If active Assignments are related to the new MPRs, the creation of new Assignment Rates will be updated by the scheduled automation.

If new Assignment Rates should not be created, this feature must be manually overridden promptly, as the resulting automation is extremely difficult to reverse once processed.

To pause or prevent the creation of new Assignment Rates, follow the steps below.

16. Identify the new MPR record created via Update Rates automation.

17. <Columns cols={2}>
      <Column>
        Click the **pencil icon** <InlineImage src="/images/icons/pencil-icon.png" alt="Inline icon" /> that appears within the **Has Pending Assignment to be processed** field (see Figure 17).
      </Column>

      <Column>
        <Frame>
          <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-6-figure-17.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=6bd895cec3bac54203de92d5f4c332e5" alt="Figure 17" width="471" height="619" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-6-figure-17.png" />
        </Frame>
      </Column>
    </Columns>

18. <Columns cols={2}>
      <Column>
        Unselect the checkbox field and click **Save** to update the record (see Figure 18).
      </Column>

      <Column>
        <Frame>
          <img src="https://mintcdn.com/2cloudnine-2edf05eb/V_lXIIlovE1j8Szu/images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-6-figure-18.png?fit=max&auto=format&n=V_lXIIlovE1j8Szu&q=85&s=a581864ecd4ce666f140725b4e61cfba" alt="Figure 18" width="471" height="410" data-path="images/generated/reference-guides/rates-automation/qrg-update-rates-automation-minimum-pay-rates/qrg-update-rates-automation-minimum-pay-rates-pdf-6-figure-18.png" />
        </Frame>
      </Column>
    </Columns>

## Field descriptions

| Field Name                  | Description                                                                                                                                                                                                                                                                                                                                                                                                                                |
| --------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Award Classification**    | The Award Classification defined for the Minimum Pay Rate record.                                                                                                                                                                                                                                                                                                                                                                          |
| **Award Level**             | The Award Level defined for the Minimum Pay Rate record.                                                                                                                                                                                                                                                                                                                                                                                   |
| **Effective Date**          | The date from which this Minimum Pay Rate record is effective.                                                                                                                                                                                                                                                                                                                                                                             |
| **New Pay Rate**            | The Pay Rate that will be applied to the new Minimum Pay Rate records and the associated Assignment Rates when the automation is completed.                                                                                                                                                                                                                                                                                                |
| **Parent Minimum Pay Rate** | The Parent Minimum Pay Rate for a Child record.                                                                                                                                                                                                                                                                                                                                                                                            |
| **Pay Code**                | The Pay Code defined for the Minimum Pay Rate record.                                                                                                                                                                                                                                                                                                                                                                                      |
| **Pay Rate**                | The hourly pay rate applicable for the Minimum Pay Rate record.                                                                                                                                                                                                                                                                                                                                                                            |
| **Project Code**            | The Project Code defined for the Minimum Pay Rate record.                                                                                                                                                                                                                                                                                                                                                                                  |
| **Timesheet Activity**      | The Timesheet Activity defined for the Minimum Pay Rate record.                                                                                                                                                                                                                                                                                                                                                                            |
| **Update Rates by**         | Allows users to choose how the calculations of updates are to be made from the following three options: <ul><li>Increase % applies a percentage increase to all the selected Minimum Pay Rate records.</li><li>Increase $applies a fxed$ increase to all the selected Minimum Pay Rate records.</li><li>Enter Rate Changes Individually allows individual rates to be entered which aren't a global increase across all records.</li></ul> |

## Further information

| Document                                             | Document Type               | Description                                                                                                                                                            |
| ---------------------------------------------------- | --------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| QRG Rates Automation Key Information                 | Information Quick Reference | Outlines useful information relevant to the Rates Automation functionality. The document includes definitions, prerequisites, and other non-instructional information. |
| QRG Create a Pay Rate Loading Record                 | Task Instructions           | How to create a Pay Rate Loading record                                                                                                                                |
| QRG Create an Award Classification and Levels Record | Task Instructions           | How to create an Award Classification and an Award Level record                                                                                                        |
| QRG Create an Assignment (Temp)                      | Task Instructions           | How to create an Employee Assignment for Timesheets                                                                                                                    |
| QRG Create an Assignment Rate record (Timesheet)     | Task Instructions           | How to create an Assignment Rate record for Timesheet Assignment Rates                                                                                                 |
