1. グローバル人事管理の実装
  2. V3年功起算日のFastFormula

V3年功起算日のFastFormula

FastFormulaは、様々な入力変数を使用して繰り返す計算または比較の汎用的な式です。FastFormulaを使用して、就業者の年功起算日を計算できます。

バージョン3 (V3)年功起算日は、次のFastFormulaをサポートしています。
  • 雇用年功起算日調整
  • 雇用年功時間数から日数への変換

次の表に、FastFormulaの入力パラメータ、戻り変数およびコンテキストを示します。

FastFormulaタイプ 入力パラメータ 戻り変数 コンテキスト
雇用年功起算日調整
  • 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
雇用年功時間数から日数への変換
  • 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