Fast formulas are generic expressions of calculations or comparisons that you want to
repeat with different input variables. You can use fast formula to calculate the seniority
dates of a worker.
Version 3 (V3) seniority dates support these fast formulas:
- Employment Seniority Date Adjustment
- Employment Seniority Hours to Days Conversion
This table lists the input parameters, return variables, and context for the fast
formulas:
Fast Formula Type |
Input Parameters |
Return Variables |
Context |
Employment Seniority Date Adjustment |
- EFFECTIVE_START_DATE (DATE)
- EFFECTIVE_END_DATE (DATE)
- SENIORITY_DATE_CODE (TEXT)
- SENIORITY_BASIS (TEXT)
- CUMULATIVE_FLAG (TEXT)
- BASE_SENIORITY_DATE (DATE)
- PREVIOUS_SENIORITY_EXIT_DATE (DATE)
- SENIORITY_LEVEL_OBJECT_ID (NUMBER)
- SENIORITY_TRIGGERING_FIELD_CODE (TEXT)
- ACTION_CODE (TEXT)
- CHANGED_VALUE_NEW (TEXT)
- CHANGED_VALUE_OLD (TEXT)
- SENIORITY_LEVEL_CODE (TEXT)
- TOTAL_SENIORITY_HOURS (NUMBER)
- PREVIOUS_TOTAL_SENIORITY_HOURS (NUMBER)
- SENIORITY_DATE (DATE)
- LEGAL_EMPLOYER_ID (NUMBER)
- LEGAL_EMPLOYER_NAME (TEXT)
- ENTERPRISE_ID (NUMBER)
- ENTERPRISE_NAME (TEXT)
- BARGAINING_UNIT_CODE (TEXT)
- BARGAINING_UNIT_NAME (TEXT)
- GRADE_ID (NUMBER)
- GRADE_NAME (TEXT)
- GRADE_STEP_ID (NUMBER)
- GRADE_STEP_NAME (TEXT)
- JOB_ID (NUMBER)
- JOB_NAME (TEXT)
- POSITION_ID (NUMBER)
- POSITION_NAME (TEXT)
- UNION_ID (NUMBER)
- UNION_NAME (TEXT)
- LOCATION_ID (NUMBER)
- LOCATION_NAME (TEXT)
- DEPARTMENT_ID (NUMBER)
- DEPARTMENT_NAME (TEXT)
- COLLECTIVE_AGREEMENT_ID (NUMBER)
- COLLECTIVE_AGREEMENT_NAME (TEXT)
- PAST_PERIOD_IN_DAYS (NUMBER)
- EFFECTIVE_SEQUENCE (NUMBER)
- EFFECTIVE_LATEST_CHANGE (TEXT)
|
- EFF_DATE (DATE)
- SENIORITY_ADJUST_COMMENT (TEXT)
- SENIORITY_ADJUST_IN_DAYS (NUMBER)
- SENIORITY_ADJUST_IN_HOURS (NUMBER)
|
- HR_RELATIONSHIP_ID
- HR_TERM_ID
- PAYROLL_RELATIONSHIP_ID
- PAYROLL_TERM_ID
- DATE_EARNED
- HR_ASSIGNMENT_ID
- PERSON_ID
- EFFECTIVE_DATE
- PAYROLL_ASSIGNMENT_ID
- LEGISLATIVE_DATA_GROUP_ID
- LEVEL_OBJECT_ID
- SENIORITY_DATE_CODE
- SENIORITY_FIELD_NUMBER
- UNIT_OF_MEASURE
|
Employment Seniority Hours to Days Conversion |
- EFFECTIVE_START_DATE (DATE)
- EFFECTIVE_END_DATE (DATE)
- DIRECTION (TEXT)
- HOURS (NUMBER)
- YEARS (NUMBER)
- MONTHS (NUMBER)
- DAYS (NUMBER)
|
- RETURN_HOURS (NUMBER)
- RETURN_YEARS (NUMBER)
- RETURN_MONTHS (NUMBER)
- RETURN_DAYS (NUMBER)
|
- HR_RELATIONSHIP_ID
- HR_TERM_ID
- PAYROLL_RELATIONSHIP_ID
- PAYROLL_TERM_ID
- DATE_EARNED
- HR_ASSIGNMENT_ID
- PERSON_ID
- EFFECTIVE_DATE
- PAYROLL_ASSIGNMENT_ID
- LEGISLATIVE_DATA_GROUP_ID
- LEVEL_OBJECT_ID
- SENIORITY_DATE_CODE
- SENIORITY_FIELD_NUMBER
- UNIT_OF_MEASURE
|