Pay Policy Grid should be effective based on EWT Date

Content was last updated in 06.23.11-00

Revision History

When this script (PayPolicyUpdate.bat) is executed after creating the Pay Policy Grid definitions with newer rates and newer effective dates, it would consider the Pay Policy Grid as per the Booking Line EWT Date(s).

About the script:

This script will update the booking line Total cost as per the following conditions.

If the cost from the crew position is updated, or If the Grid pricing had been applied.

This script accepts the date in 'MM/DD/YYYY' format as a parameter.

With this date, the script will filter the booking lines with overlap, and only those booking lines will get updated as per the new crew position cost or the Grid pricing definition.

 Make sure NO users are connected to the application before starting the script. 

When you run the script PayPolicyUpdate.bat you need to provide the following details.

1. R2 schema name.

2. R2 schema password.

3. Service name.

4. Effective date

A Log file PayPolicyUpdateScriptLog.log will be generated in the same folder.

Pre-requisite for this feature to work

1. An Order in R2 with a few Labor Positions added.

2. Same Order opened in R2Labor and EWT defined for some/all of the Crew.

3. Paypolicy defined for the labor type which has been added.

4. Labor Grid Pricing define in Maintenance Module.