OPSTimekeepingAlertRuleDetail

Name: OPS Timekeeping Alert Rule Detail

Type: Ancillary

Modules: OPS-SIT

Description: Contains details for user-defined alert rules.

Field Documentation
RuleId Unique identifier for a rule.
Sequence Priority number used for ordering data query records.
PayCodeList List of pay code identifiers from PayCodes.PayCode.
ListName List of pay codes used to retrieve data.
CalcMode Calculation mode used to generate alerts (1 = Designated, 2 = Bid, 3 = User Specified Value, 4 = ComparePayCodeList).
ConditionCode Associated condition for generating alerts (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.
ComparePayCodeList List of pay code identifiers from PayCodes.PayCode if the rule Calcmode=ComparePayCodeList.
CompareListName List of pay codes used for comparison.
TypeId Identifies an ancillary type. If the Condition Code is TA, this field will reference OPSTimekeepingAttributeTypes.AttributeTypeId.
DayType Identifies an ancillary type. If the Condition Code is EDT, this field will reference OPSEmployeeDayType. DayType
AssignTypeGroup Internal use only.
RequiredField Specifies the required field for a payroll transaction. The timekeeping alert rule will trigger when a payroll transaction does not have the specified required field. ('PayTime', 'PayRate', 'PayAmount', 'Shift', 'ActivityTypeId', 'WorkId,SchId', 'ExtraPayTypeId', 'AbsenceId').