定期給与のレポート

給与ベース周期に基づいて従業員の定期給与を計算します。この周期によって、従業員の給与と、従業員がマッピングされる給与の周期が管理されます。

給与詳細レコードで従業員の定期給与および支払周期を確認できます。

給与ベースを使用して給与を管理しながら、給与として指定した金額のみが定期値に変換されます。
組織の給与体系に複数の給与コンポーネントがある場合、給与ベース金額と定期給与額は給与全体を表さないことがあります。
使用される給与ベースの周期として、給与ベース金額の周期を考慮します。たとえば、年間給与ベースが使用される場合、給与ベース金額は年間値を保持します。時給ベースが使用されている場合、給与ベース金額は時間値を保持します。

次のステップを実行して、給与ベース金額の周期変換済値として定期給与を計算します。

「ホーム」ページで、「自分のクライアント・グループ」タブの「FastFormula」クイック処理をクリックします。
次の詳細を含むFastFormulaを作成します。
- Formula名:グローバル・ビュー給与換算ファクタ
- Formulaタイプ: 抽出ルール
- 摘要: 給与ベース金額を定期金額に変換するFormula
- 国別仕様データ・グループ: これは空白のままにします
「続行」をクリックします。

次に、一般的に使用される給与ベースおよび支払周期に基づいて変換を行うFormulaテキストの例を示します。実装要件に応じて、FastFormulaで変換ロジックを指定できます。

inputs are l_salary(text),
l_PaymentFrequency(text),
l_payroll_freq(text)

if(l_payroll_freq= 'Annually' or l_payroll_freq= 'Year') then
(
  if(l_PaymentFrequency ='ANNUAL' ) then
  (
    l_periodic_amount = to_number(l_salary)
  )
  else if(l_PaymentFrequency ='HOURLY') then
  (
    l_periodic_amount = to_number(l_salary)*365*8
  )
  else if(l_PaymentFrequency ='HOURLY2') then
  (
    l_periodic_amount = to_number(l_salary)*365
  )
  else if(l_PaymentFrequency ='PERIOD') then
  (
    l_periodic_amount = to_number(l_salary)
  )
  else if(l_PaymentFrequency ='WEEK') then
  (
    l_periodic_amount = to_number(l_salary)*52
  )
  else if(l_PaymentFrequency ='SEMI_MONTH') then
  (
    l_periodic_amount = to_number(l_salary)*24
  )
  else if(l_PaymentFrequency ='BIWEEKLY') then
  (
    l_periodic_amount = to_number(l_salary)*26
   )
  else if(l_PaymentFrequency ='MONTHLY') then
  (
    l_periodic_amount = to_number(l_salary)*12
   )
  else
  (
    l_periodic_amount = to_number(l_salary)
  )
)
else 
if(l_payroll_freq= 'Monthly Calendar' or l_payroll_freq= 'Calendar Month') then
(
 if(l_PaymentFrequency ='ANNUAL') then
  (
    l_periodic_amount = (to_number(l_salary))/12
   )
 else if(l_PaymentFrequency ='HOURLY') then
  (
    l_periodic_amount = (to_number(l_salary)*365*8)/12
   )
 else if(l_PaymentFrequency ='HOURLY2') then
  (
    l_periodic_amount = (to_number(l_salary)*365)/12
  )
 else if(l_PaymentFrequency ='PERIOD') then
  (
    l_periodic_amount = to_number(l_salary)
   )
 else if(l_PaymentFrequency ='WEEK') then
  (
    l_periodic_amount = ((to_number(l_salary)*52))/12
  )
 else if(l_PaymentFrequency ='SEMI_MONTH') then
  (
    l_periodic_amount = ((to_number(l_salary)*24))/12)
 else if(l_PaymentFrequency ='BIWEEKLY') then
  (
    l_periodic_amount = ((to_number(l_salary)*26))/12
  )
 else if(l_PaymentFrequency ='MONTHLY') then
  (
    l_periodic_amount = (to_number(l_salary)*12)/12
  )
 else
  (
    l_periodic_amount = to_number(l_salary)
  )
)else
if(l_payroll_freq= 'Semimonthly' or l_payroll_freq= 'Semi-Month') then
(
 if(l_PaymentFrequency ='ANNUAL') then
  (
    l_periodic_amount = to_number(l_salary)/24
   )
 else if(l_PaymentFrequency ='HOURLY') then
  (
    l_periodic_amount = (to_number(l_salary)*365*8)/24
   )
 else if(l_PaymentFrequency ='HOURLY2') then
  (
    l_periodic_amount = (to_number(l_salary)*365)/24
  )
 else if(l_PaymentFrequency ='PERIOD') then
  (
    l_periodic_amount = to_number(l_salary)
   )
 else if(l_PaymentFrequency ='WEEK') then
  (
    l_periodic_amount = ((to_number(l_salary)*52))/24
  )
 else if(l_PaymentFrequency ='SEMI_MONTH') then
  (
    l_periodic_amount = ((to_number(l_salary)*24))/24
  )
 else if(l_PaymentFrequency ='BIWEEKLY') then
  (
    l_periodic_amount = ((to_number(l_salary)*26))/24
  )
 else if(l_PaymentFrequency ='MONTHLY') then
  (
    l_periodic_amount = (to_number(l_salary)*12)/24
  )
 else
  (
    l_periodic_amount = to_number(l_salary)
  )
)
else
if( l_payroll_freq= 'Biweekly' or l_payroll_freq='Bi-Week') then
(
 if(l_PaymentFrequency ='ANNUAL') then
  (
    l_periodic_amount = to_number(l_salary)/26
  )
 else  if(l_PaymentFrequency ='HOURLY') then
  (
    l_periodic_amount = (to_number(l_salary)*365*8)/26
  )
 else if(l_PaymentFrequency ='HOURLY2') then
  (
    l_periodic_amount = (to_number(l_salary)*365)/26
  )
 else if(l_PaymentFrequency ='PERIOD') then
  (
    l_periodic_amount = to_number(l_salary)
   )
 else if(l_PaymentFrequency ='WEEK') then
  (
    l_periodic_amount = ((to_number(l_salary)*52))/26
  )
 else if(l_PaymentFrequency ='SEMI_MONTH') then
  (
   l_periodic_amount = ((to_number(l_salary)*24))/26
  )
 else if(l_PaymentFrequency ='BIWEEKLY') then
  (
    l_periodic_amount = ((to_number(l_salary)*26))/26
   )
 else if(l_PaymentFrequency ='MONTHLY') then
  (
   l_periodic_amount = (to_number(l_salary)*12)/26
  )
 else
  (
    l_periodic_amount = to_number(l_salary)
  )
)
else
if(l_payroll_freq= 'Weekly' or l_payroll_freq= 'Week') then
(
 if(l_PaymentFrequency ='ANNUAL') then
  (
    l_periodic_amount = to_number(l_salary)/52
  )
 else if(l_PaymentFrequency ='HOURLY') then
  (
    l_periodic_amount = (to_number(l_salary)*365*8)/52
  )
 else if(l_PaymentFrequency ='HOURLY2') then
  (
    l_periodic_amount = (to_number(l_salary)*365)/52
  )
 else if(l_PaymentFrequency ='PERIOD') then
  (
    l_periodic_amount = to_number(l_salary)
  )
 else if(l_PaymentFrequency ='WEEK') then
  (
    l_periodic_amount = ((to_number(l_salary)*52))/52
  )
 else if(l_PaymentFrequency ='SEMI_MONTH') then
  (
    l_periodic_amount = ((to_number(l_salary)*24))/52
  )
 else if(l_PaymentFrequency ='BIWEEKLY') then
  (
    l_periodic_amount = ((to_number(l_salary)*26))/52
   )
 else if(l_PaymentFrequency ='MONTHLY') then
  (
    l_periodic_amount = (to_number(l_salary)*12)/52
  )
 else
  (
    l_periodic_amount = to_number(l_salary)
   )
)
else
(
 if(l_PaymentFrequency ='ANNUAL') then
  (
    l_periodic_amount = to_number(l_salary)/12
  )
 else if(l_PaymentFrequency ='HOURLY') then
  (
    l_periodic_amount = (to_number(l_salary)*365*8)/12
  )
 else if(l_PaymentFrequency ='HOURLY2') then
  (
    l_periodic_amount = (to_number(l_salary)*365)/12
  )
 else if(l_PaymentFrequency ='PERIOD') then
  (
    l_periodic_amount = (to_number(l_salary))/12
  )
 else if(l_PaymentFrequency ='WEEK') then
  (
    l_periodic_amount = ((to_number(l_salary)*52))/12
  )
 else if(l_PaymentFrequency ='SEMI_MONTH') then
  (
    l_periodic_amount = ((to_number(l_salary)*24))/12
  )
 else if(l_PaymentFrequency ='BIWEEKLY') then
  (
    l_periodic_amount = ((to_number(l_salary)*26))/12
  )
 else if(l_PaymentFrequency ='MONTHLY') then
  (
    l_periodic_amount = (to_number(l_salary)*12)/12
  )
 else
  (
    l_periodic_amount = to_number(l_salary)
  )
)
return l_periodic_amount

変更を送信して、Formulaをコンパイルします。
前述のFormulaが正常にコンパイルされたら、次のFormulaを検索して再コンパイルします。これらのFormulaは、すでにコンパイル済ステータスであっても再コンパイルします。
- ORA_EXT_SALARY_ASG_RANGE_DETAILS
- ORA_EXT_GLOBAL_VIEW_PERIODIC_FREQUENCY_CALCULATOR