OPSTimekeepingAlertRules
Name: OPS Timekeeping Alert Rules
Type: Ancillary
Modules: OPS-SIT
Description: Contains user-defined alert rules.
| Field | Documentation |
|---|---|
| RuleId | Unique identifier for a rule. |
| DivisionList | List of division identifiers from MasterDivisions.DivisionId which the rule applies to. |
| EmployeeTypeList | List of employee type identifiers from EmployeeTypes.EmployeeTypeId which the rule applies to. |
| BidUnitList | List of bid unit identifiers from BidUnits.BidUnitName which the rule applies to. |
| AlertMessage | Alert message to display. |
| Colour | Text color for alert message. |
| PayAmountOnly | If true, only the pay amount is used when comparing values when validating pays. |
| PayCodeList | List of pay code identifiers from PayCodes.PayCode. |
| TimeFrame | Associated time frame to display the alert (1 = Each Regular Day Off, 2 = Each Regular Work Day, 3 = Each Holiday, 4 = All Regular Day Offs in the Pay Week, 5 = All Regular Day Offs in the Pay Period, 6 = All Regular Work Days in the Pay Week, 7 = All Regular Work Days In the Pay Period, 8 = First Day Off in the Pay Week, 9 = Second Day Off in the Pay Week, 10 = Third Day Off in the Pay Week, 11 = Fourth Day Off in the Pay Week, 12 = Fifth Day Off in the Pay Week, 13 = Sixth Day Off in the Pay Week, 14 = Seventh Day Off in the Pay Week, 15 = All Days in the Pay Week, 16 = All Days in the Pay Period, 17 = Each Holiday falling on a Regular Day Off, 18 = Each Holiday Falling on a Regular Work Day, 19 = All Non-Holiday Days in the Pay Week, 20 = All Non-Holiday Days in the Pay Period). |
| ConditionCode | Associated condition to generate the alert (1 = Hours Greater Than, 2 = Hours Less Than, 3 = Hours Equal, 4 = Hours Greater Than or Equal, 5 = Hours Less Than or Equal, 6 = None, 7 = Hours Not Equal, 11 = Dollars Greater Than, 12 = Dollars Less Than, 13 = Dollars Equal, 14 = Dollars Greater Than or Equal, 15 = Dollars Less Than or Equal, 17 = Dollars Not Equal). |
| PayTime | Total amount of payable time in seconds. |
| PayAmount | Total pay amount. |
| CalcMode | Calculation mode used to calculate timekeeping (1 = Designated, 2 = Bid, 3 = User Specified Value, 4 = ComparePayCodeList). |
| CalculationFormula | Base on sequence in the rule detail, use formula to link . New example formula can be describe as (1 && 2) ||(3 && 4) , system will auto generate it. |
| AgencyId | For future use. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. Value is in seconds from midnight. |
| ModAction | Last action performed on the record. |
| PreventPosting | Indicator to prevent posting timekeeping |