← 返回教程首页 | 视频图文笔记 第 9 / 14 期

Workday HCM 薪酬计划与奖金计划实操

Compensation Plans and Bonus Plan in Workday HCM | ZaranTech

频道:Workday Learner Community(ZaranTech) 时长 1:41:39 发布于 2024-08-15 34 帧对照 · 全片覆盖 原视频 ↗
⏱ 每节的 时间点 对应视频画面,点开原视频拖到该时间即可对照。
本片字幕为 YouTube 自动生成,存在术语误听(如把 payroll 打成 Peril、basis 打成 baces、HCM 类词打错等);正文统一用画面上的正确术语,quote_en 一律保持字幕原样不改。标题与实际内容相符:全片就是 Workday HCM 薪酬计划与奖金计划——薪酬基准(Compensation Basis)与津贴计划配置、奖金计划与资格规则(Profile Rules)、发起奖金流程、积分卡、EIP 上传目标涨幅、网格(Grid)自定义字段。所有金额/百分比/basis/等级/区间一律以画面显示为准;口播与画面不一致时以画面为准并在要点里写明差异。看不清的信息标注(待核对)。
1:45

员工薪酬页计划全表

员工薪酬页计划全表
  • 员工 ManjuThe Employee(Senior Systems Engineer)的 Compensation 页 Totals:Total Salary & Allowances 3,360,000.00 / 46,989.60,Total Base Pay 1,680,000.00 / 23,494.60,On Target Compensation 4,200,000.00 / 58,737.00,币种 INR/USD 双列,Frequency Annual
  • Plan Assignments 共 5 项:Salary Plan 1,680,000.00 INR Annual;India-Allowances 88% Annual: Individual Target;India-Provident Fund 12% Annual: Individual Target;New Hire Equity Plan 2,000 Annual: Individual Target;WW Sales Commission Plan 840,000.00 INR Annual: Individual Target
  • Grade P3 - SE - Pre & Post Sales,Grade Profile P3 - SE - Pre & Post Sales - INDIA,公司 Sample Networks India Private Limited,Compensation Package 为 Sample Networks Compensation Package;Total Base Pay Range 显示 0.00 - 0.00 - 0.00 INR Annual(该等级未配区间)
  • 讲师说明:按法律全部津贴之和应等于基本工资的 88%,所以有公司把住房、教育等津贴并成一个计划好维护;做成百分比计划后,工资一动津贴/公积金金额自动跟着调

"but by law the sum of all the allowances should equal 88% of the uh base salary and so some companies May combine all of the allowances into just one plan which would be 88% of the base salary"— 但按法律规定,所有津贴之和应等于基本工资的 88%,所以有些公司会把全部津贴并进一个计划,也就是基本工资的 88%。

4:15

USD估算的汇率口径

USD估算的汇率口径
  • 鼠标悬停 Totals 列弹出换算说明(画面原文):This is an estimate in your preferred currency using the exchange rate 1.00 INR = 0.013985 USD,Rate Date 02/01/2020,Rate Type: Current——USD 数只是当日汇率估算,不是算薪结果
  • 讲师讲了一个常见实施坑:美国员工没有津贴,Total Salary and Allowances 与 Total Base Pay 两列显示同一个数看似正常;换成有津贴的国际员工,第二列仍只显示基本工资、数字就不对——根因是公司没配含津贴的 compensation basis
  • 修复办法(口播):建一个 Salary and Allowance 基准,或直接改用把两者合在一起的交付基准

"the reason it's not going to be showing you the correct data is the company has not set up a compensation basis which includes base salary and allowance so they're only using base salary"— 这一列数据不对的原因是公司没有设置包含基本工资加津贴的薪酬基准,所以它算的就只是基本工资。

5:15

打开薪酬基准明细页

打开薪酬基准明细页
  • 入口(口播):员工页 Actions > Compensation > Compensation Basis Details;页面抬头 102968 Senior Systems Engineer / ManjuThe Employee
  • 左侧 Position:Organization India Systems Engineering (Anand Meshram),Job Profile S1413 - Applications/Systems Engineer,Time Type Full time,Scheduled Weekly Hours 40,FTE 100.00%
  • 交付基准 Total Base Pay 的 Basis Amount ₹1,680,000.00($23,494.80),右侧拆解只有 1 项:Salary ₹1,680,000.00;Target Currency INR、Target Frequency Annual
  • Total Salary & Allowances 基准 ₹3,360,000.00,拆解 3 项:Allowance India-Provident Fund ₹201,600.00、Allowance India-Allowances ₹1,478,400.00、Salary Plan ₹1,680,000.00
  • 讲师给的基准定义(口播):Compensation Basis 就是 Workday 计算某对象/某场景总薪酬所用的公式

"remember I gave you guys the definition of what does it mean by compensation basis and it means the formula that's being used by workday to determine how to calculate the total salary for a particular object or for a particular situation"— 还记得我讲过 compensation basis 的定义:它是 Workday 用来计算特定对象、特定情形下总薪酬的公式。

6:45

On Target与印度基准分项

On Target与印度基准分项
  • 画面滚动后看到更多基准块:On Target Compensation(Ranking 1)Basis Amount ₹4,200,000.00 / $58,737.00,4 项构成——Salary ₹1,680,000.00 + India-Allowances ₹1,478,400.00 + India-Provident Fund ₹201,600.00 + Commission WW Sales Commission Plan ₹840,000.00($11,747.40)
  • 自建基准 India Salary and Allowances(Ranking 2)₹3,360,000.00:Salary 1,680,000 + India-Allowances 1,478,400 + India-Provident Fund 201,600,不含奖金和股权
  • 口播:交付的 Total Salary and Allowances 假设每个国家工资都加津贴,不适配所有国家;印度的做法是照抄交付基准、只把津贴计划换成 India 的那两个

"so for example in India the salary and allowance are supposed to be combined so you may combine you may make this one um you just look at this one how this one is done and then just build it exactly like the delivered one but only select the India allowance plans"— 比如印度的工资和津贴是要合并的,你就照交付基准的做法原样建一个,只是津贴计划只选 India 的那几个。

7:45

本课剩余议程表

本课剩余议程表
  • 画面是讲师的 Excel 议程表 Remaining Agenda For Advanced Comp:Employee Comp Data and History、Allowance Plan against Delivered Basis、Compensation Basis→create Configurable compensation basis、Comp Plans、Comp Package
  • Bonus Plan 段落:Profile Rules Example、Launch Bonus Only Comp Process、scorecard Example、Proposing Target Percent in Excel and Uploading to Grid、Using Earnings Overrides when plan does not have target profiles
  • BREAK 之后:View In Progress Grid、Creating Grid from Delivered、Adding Columns in Summary or Panel、Add Common Custom Fields;再往后 Stock Plan、Finalizing the Process(其中 BIRT 信函模板一项备注 Highly Valuable but need to tradeoff 2 hours from elsewhere)
  • 本节视频实际只讲到网格自定义字段,Stock/BIRT 部分留给后续课

"the menu name the to create a compensation basis is simply create configurable compensation basis um in this case it's already created I'm just going to take it into edit"— 创建薪酬基准的菜单名就叫 Create Configurable Compensation Basis;这里已经建好了,我直接进编辑模式。

8:15

编辑印度薪资津贴基准

编辑印度薪资津贴基准
  • Details:Name India Salary and Allowances,Eligibility Rule Country - India INR,Functional Areas 挂了 Benefits 和 Compensation 两个,Use to View Compensation 勾选,Ranking 2
  • 每类计划的三选一里,只选了 Salary Plans→Salary Plan、Allowance Plans→India-Allowances 与 India-Provident Fund;Bonus/Equity/Commission Plans 一律不选——这就是该基准 ₹3,360,000.00 的来源
  • 右侧 Usage:Compensation Plans 0、Compensation Plan Profiles 10、Retirement Savings Plans 0;Manage Basis Total 里 Salary Plans Maximum 100
  • 口播把 India-Provident Fund 说成了 India 401k plan,画面名称以 India-Provident Fund 为准

"so for India salary and allowances you can see that it's made up of India allowance plan and India 401k plan so it's just like the delivered total comp basis but you're filtering it on Just for India"— 这个 India Salary and Allowances 由 India allowance 计划和 India 401k 计划(画面里是 India-Provident Fund)组成,跟交付总基准一样,只是限定给印度。

16:15

配津贴计划88%封顶

配津贴计划88%封顶
  • Edit Allowance Plan India-Allowances:Compensation Basis=Base Salary、Compensation Element=Allowance、Percent 输入框 88;Plan Description 写着 88%
  • 口播:Compensation Element 里的 delivered element Allowance 只有对接 Workday Payroll 才用,但界面上是必填项,不填过不了
  • Plan Eligibility 用补偿规则 Country - India INR,只对工作地点印度的员工生效;Process Eligibility 的 Exclude from Merit 没勾——讲师说这按钮多余,启动 Merit 时本来就要勾选参与计划
  • Allowance Plan Profiles 表 0 条(列:Percent / Ceiling Amount / Ceiling Currency / Eligibility Rule / Compensation Basis),封顶全靠默认 88%

"since this is a percent based what per um we we're going to use for this so I had selected 88% uh because by rule um all of the allowance plans they have to equal 88% of the base pay"— 既然选了百分比型,就要定用多少百分比——我选了 88%,因为规则要求所有津贴计划加起来必须等于基本工资的 88%。

17:15

津贴计划生效结果

津贴计划生效结果
  • View Allowance Plan 查看态确认配置:Allowance Defaults——Compensation Basis Base Salary、Compensation Element Allowance、Percent 88.00%、Frequency (empty)
  • Ceiling Amount 0、Ceiling Currency (empty):没有另设金额封顶,88% 本身就是上限
  • Plan Eligibility: Eligibility Rules Country - India INR;Process Eligibility: Exclude from Merit No
  • 员工页上 India-Allowances 显示的 88% Annual: Individual Target 就是这里的 Percent 值

"since this is applicable to only employees who are in India so we say we create a compensation rule just that says um you know just for India work location"— 因为它只适用于在印度的员工,就建一条补偿规则,限定工作地在 India。

18:00

补偿计划报表一览

补偿计划报表一览
  • 菜单搜 comp plans 打开 Compensation Plans 报表(按生效日期列出全部有效/失效计划),本页签为 Bonus Plans,12 items,列含 Compensation Element、Default Percent / Default Amount、Default Currency、Default Frequency、Eligibility Rules、Used by Compensation Package
  • Engineering Incentive:元素 Engineering Incentive,Default Currency USD,Default Frequency Semi-Annual,资格规则 Engineering Job Families,被 Sample Networks Compensation Package 使用
  • 同屏对比:Executive Sales Incentive Plan 的 Default Percent 100.00%;Federal Security Clearance 用固定 Default Amount 5,000.00 USD、Quarterly;Corporate Incentive 用 KinPro Eligibility 规则、Semi-Annual
  • 口播:资格怎么划定是各公司最头疼的点,按地点、按 job profile 都行,最省事的是按 Job Family 成组划进来

"I think the easiest way to do is Define it by job families so you take all of the job families in a particular group and then you say okay anybody who's in those job families is going to be part of this bonus plan"— 我觉得最简单的方式是按 Job Family 定义:把某个组的 Job Family 都拿过来,凡在这些 Job Family 里的人就是这个奖金计划的成员。

19:15

奖金计划全字段解读

奖金计划全字段解读
  • View Bonus Plan Engineering Incentive——Details:Plan Name Engineering Incentive,Compensation Element Engineering Incentive;Award Calculation:Compensation Basis Total Base Pay,Allow Target Override Yes,Hide Target No,Target % 0.00%
  • Reference Currency USD,Reference Frequency Semi-Annual,Company Funding Scorecard Engineering Incentive,Plan Modifier Scorecard (empty),Time Proration Rule Bonus Incentive Proration,Rounding Rule (empty)
  • Plan Eligibility:Eligibility Rules Engineering Job Families,Waiting Period (empty);Process Eligibility:Include Active Employees Assigned Plan During Process Period Yes,Include Active Employees in Waiting Period No
  • 口播:目标百分比是乘在 Compensation Basis 指定的公式上的——这里就是 Total Base Pay × 目标%,得出该人的目标奖金额度;Allow Target Override 选 Yes 是因为有人超额有人不达标

"the target percent just like we said the Merit Target percent they're going to be multiplied against the compensation formula that's mentioned here so the formula that's mentioned here is just total base pay"— 这个目标百分比(跟 Merit 一样)会乘在这里指定的薪酬公式上——这里的公式就是 Total Base Pay。

20:15

36条Profile目标表

36条Profile目标表
  • 奖金计划本身 Target % 为 0.00%,真正的目标百分比在 Bonus Plan Profiles 表逐条挂资格规则——该计划共 36 items
  • 画面可见前几行:15.00% Engineering Incentive =15% Tech - Non-India、6.00% =6% Tech - Non-India、10.00% =10% Tech - Non-India(下沿还有 50% 行截断),Compensation Basis 均为 Total Base Pay
  • 计划下有 Bonus Plan Profiles / Performance Factors / Bonus and Merit Review Events 三个页签
  • 口播:半财年计划的 process period 是 7/1–12/31 或 1/1–6/30;Include Active Employees Assigned Plan During Process Period 一般选 Yes

"now process period is going to be based on the the frequency so this is a six-month plan so that means it's going to be from July 1st through December 31st or January 1st through June 30th"— 流程周期跟着频次走,这是个六个月计划,也就是 7 月 1 日到 12 月 31 日,或者 1 月 1 日到 6 月 30 日。

22:45

小时工行用收入覆盖基准

小时工行用收入覆盖基准
  • Profiles 表下半屏:35.00%/30.00%/25.00%/20.00% 的 Tech - Non-India 行 Compensation Basis 仍是 Total Base Pay;所有带 (HOURLY NON-EXEMPT) 的行——如 50.00% Engineering Incentive = 50% Tech - Non-India (HOURLY NON-EXEMPT)、= 50% - India (HOURLY NON-EXEMPT)、35/40/30/25% 各小时工行——basis 全部换成 Eligible Earnings Override
  • 口播解释:Workday 不跟踪加班,计时(非豁免)员工的收入要走员工档案里的 earnings override 组件手工录入或 EIP 批量载入,所以那些行用 Override 基准
  • 口播还说印度工程师的行用 salary and allowance 基准乘 50%,但本屏可见的两条 50% India 行都是 HOURLY NON-EXEMPT(用 Override);非时薪的 India 50% 行不在本屏——待核对

"for anything that's hourly we're using the eligible earnings override and then for anybody who's not hourly and they're not in these Target you know in these rules which would mean all of the engineers in India they would be on these percent targets and they're going to use the composition basis called salary and allowance"— 凡时薪员工都用 Eligible Earnings Override;不按时薪、落在这些规则里的印度工程师,则用叫 salary and allowance 的薪酬基准来乘目标百分比。

26:15

拆解15%资格规则

拆解15%资格规则
  • View Compensation Rule Engineering Incentive =15% Tech - Non-India,Rule Conditions 共 5 行(And/Or 组合):( CF SS Grade Only - Comp Rule starts with P3 / Or starts with M2 ) / And CF TF Technical Job Family - Comp Rule equal to Yes / And Country of Location – Primary (Compensation) none in the selection list India / And Non-Exempt Hourly (Bonus) equal to No
  • Derived Logic 原文:(CF SS Grade Only - Comp Rule starts with P3 Or CF SS Grade Only - Comp Rule starts with M2) And CF TF Technical Job Family - Comp Rule equal to Y And Country of Location – Primary (Compensation) none in the selection list India And Non-Exempt Hourly (Bonus) equal to No
  • 等级判断用 starts with 前缀匹配:P3 开头(专业序列 3 级)或 M2 开头(管理序列 2 级),配合技术 Job Family、排除印度、排除非豁免时薪,四条与起来框住这群工程师

"here we're seeing that from you know from the list of grades get all the grades that start with P3 or M2 and they're in a tech technical job family and the country is not India"— 从等级清单里取所有以 P3 或 M2 开头的等级,再加上技术 Job Family、国家不是 India 这些条件。

29:20

等级前缀计算字段

等级前缀计算字段
  • 规则里 CF SS Grade Only - Comp Rule 的本体:Calculations 类型是 Substring Text,Business Object Compensation Rule Targetable
  • 计算配置(画面原文):Text Field=Compensation Grade (Compensation);Substring Type=Before a Delimiter;Delimiter=-;Direction=Forward;Remove Leading and Trailing Spaces=Yes
  • 作用:等级名统一是 P3-xxx、M8-xxx 这种带连字符的格式,取 - 之前的前缀,供资格规则做 starts with 判断
  • 口播(本窗口内):India 的 50% 规则是等级 M8 + 地点 India + 非豁免;完整的该规则页面未截到——待核对

"you actually have to have the um the person's grade and then um as part of the name of that grade is is going to be MH Dash so on or uh M7 or M2 so this one is a P5 and M4 and it techical"— 你得拿到这个人的等级——等级名里带着前缀,比如 M8 横杠什么的,或者 M7、M2;这一条是 P5 和 M4、技术序列。(字幕把 M8 听成了 MH)

32:15

计划的下发与移除入口

计划的下发与移除入口
  • 在 View Bonus Plan 页面 Actions > Compensation Plan 子菜单(画面原文):Remove Compensation Plan from Employees、Rollout Compensation Plan to Employees——从计划维度下发/移除员工
  • 口播:发起奖金流程的前提是计划已经 roll out 给员工;要收回也用同一套规则
  • 口播(同窗口):发起时选 Effective Date;这个流程只发奖金、不含 Merit

"this is assuming that it's been already rolled out um to the employees using that roll out function we learned if we need to correct it we could also remove it but the same rules applied um rolling out or removing"— 这假设计划已经用我们学过的 roll out 功能下发给员工了;要纠正也可以移除,下发和移除适用同样的规则。

33:45

发起奖金流程模板页

发起奖金流程模板页
  • 菜单搜 init 打开 Initiate Merit Process:Merit Process Template=2H 2019 Engineering Bonus;Configuration 必填 Effective Date、Employee Visibility Date、Process Period End Date、Organization Snapshot Date;Grid Configuration=Merit - Bonus Grid
  • Award Types 只出现在 Bonus Plans 里选 Engineering Incentive——只发奖金不动 merit,还可以再勾选 corporate plan 等多个奖计划
  • 口播:3 月 1 日生效的那次 Workday 版本发布后,Initiate Merit / Initiate Bonus 两个任务合并改名 Compensation Review;在那之前仍要单独搜 Initiate Merit Process(字幕打成 compens Station review)

"um there's not a separate name for initiate Merit or initiate bonus it's just going to be called compens Station review but right now I had to I had to type the menu name separately initiate M process"— 以后 Initiate Merit 和 Initiate Bonus 不再有单独名字,统一叫 Compensation Review;但现在我还得单独去搜 Initiate Merit Process。

34:45

流程确认页日期币种

流程确认页日期币种
  • 套模板后的 Process Details(画面原文):Template 2H 2019 Engineering Bonus、Grid Configuration Merit - Bonus Grid、Default Effective as of 09/01/2020
  • Currency Rate Type=Current (Default),Reference Currency=USD,Shared Participation Options=Shared Participation Option;Reviews and Ratings 下 Employee Review Templates 挂了 2019 占位模板
  • Employee Visibility Date / Process Period End Date / Organization Snapshot Date 处被下拉残影遮挡,只见数字 0/1/1——具体含义(待核对)
  • 口播:半财年计划只需给结束日 12/31,Workday 自动倒推周期起点为 7/1

"we're saying that for this semi plan the last the end date is going to be December 31st and because it's a semiannual plan workday will automatically calculate the uh The Period start date so it should be from July 1st through uh December 31st"— 这个半年计划我们给到结束日期 12 月 31 日,因为是半财年频次,Workday 会自动算出周期起始,正好是 7 月 1 日到 12 月 31 日。

37:15

积分卡达成率录入演示

积分卡达成率录入演示
  • Create Compensation Scorecard Results:Scorecard=Engineering Incentive Plan;Default Scorecard Goals Results 页签下 Company Performance Scores 1 条——Engineering Performance Factor,Weight 100.00%,Achievement 输入框正在录入
  • 画面此刻 Weighted Results Percent 显示 110.00%:这是讲师演示公司业绩很好时的情形(口播说 might be 11[0]%,字幕掉位显示 11%),以画面 110.00% 为准
  • 口播:达成率是总预算的折扣——92% 就意味着全公司按目标算出的池子只放 92% 出来;这个数一般由 HR/薪酬伙伴给定,也可以拆成业务单元 + 公司两张积分卡
  • 最终讲师把达成率改成 91%(见下一帧 00:38:15 画面 Weighted Result 91.00%)

"here we get to change the engineering performance Factor so it weight is 100% but what if the achievement level was only 92% for example"— 这里可以改 Engineering Performance Factor——权重是 100%,但如果达成度只有 92% 呢?

38:15

流程里的积分卡91%

流程里的积分卡91%
  • Initiate 页下半段(画面原文):Include Employees Terminated During Process Period 未勾选;Allow Bonus Award Autofill 已勾选
  • Bonus Plan 表 1 item:Engineering Incentive,Frequency Semi-annual,Days in Period 184,Plan Targets No
  • Tranche and Eligible Earnings Override Period:Engineering Incentive 选 Eligible Earnings Period = 2H 2019 (07/01/2019...)——计时工的收入期要先建好再在这里选用
  • Compensation Scorecard Results:Engineering Incentive | Engineering Incentive Plan - Evaluation Date... | Weighted Result 91.00%;下方还有 Exceptions by Rule 折叠区
  • 口播:计时非豁免员工的总薪酬=工时×时薪+加班,Workday 不自动算,其收入是载入档案的,这里指定取哪个 eligible earnings 期间

"El earnings going to be um you know if someone is on a salary right they get a a fixed salary per year right so what they have earned is um you know their base pay is going to be what their salary is but if someone is on uh their non-exempt and they're hourly then their total salary is going to be based on the number of hours they have worked"— 拿固定年薪的人,所得就是基本工资;但非豁免的时薪员工,总薪酬是按实际工作小时算出来的。

43:45

离职与并行事件规则

离职与并行事件规则
  • Manage Impacted Employees(Bonus Process: Engineering Bonus 2H 2019):Manage In Progress Processes 按钮;Bonus Participation 区有 Termination、Parallel Events、Eligible Earnings Override 三行,外加 Save/Cancel
  • 展开的规则下拉里可见长文本 …Keep Employee and Pool Amount if Transfer… 以及 Bonus - After Compensation Snapshot Date through Compensation Review Effective Date;水印遮挡、且分不清各选项归属 Termination 还是 Parallel Events——待核对;口播说 Termination 选的是 remove terminated employee and keep employee pool 这一类
  • 口播解释 Termination 规则:周期 12/31 已过、现在 2 月,周期后离职的人要移除,但其奖金池预算保留在总额里
  • 口播对 Parallel Events 的建议:奖金额按 12/31 快照日算,周期结束后的调薪本就不影响结果,别配并行流程;真要回溯改周期内的薪酬,把人移出流程、改完再加回来,比养一套规则更干净

"and then we also have to enter any termination rules so I'm going to click on edit and I'm going to select the termination rule saying remove Terminator employee and keep employee pool for bonus and termination"— 还得录入离职规则:点编辑,选那条「移除离职员工、但为其保留奖金池」的规则。

47:45

配置奖金池与Bottom-Up

配置奖金池与Bottom-Up
  • Inbox 任务 Configure Pools(Bonus Process: Engineering Bonus 2H 2019,Due 03/03/2020,Effective 03/01/2020,Reference Currency USD)
  • Pool Controls 三个复选框全部勾上(画面原文):Allow Pool Holdbacks、Allow Pool Overages、Display Remaining Pools
  • Default Bonus Calculation:Calculation 选中 Bottom-Up(Top-Down 未选);下面留 Pool Amount、Percent of Eligible Earnings、Total Eligible Earnings、Estimated Cost、Prefill Employee Bonus Awards(未勾)、Hide Pool/Spend;按钮 Finalize / Review Plan Funding / Cancel
  • 口播:Allow Pool Overages 建议常开,不然后端超一点预算流程就卡死;Holdback 争议大,不如透明分配;Bottom-Up=让 Workday 按每人目标汇总总池,Top-Down=上面填总额或百分比再逐级下分

"by default the bonus calculation Bottoms Up is being selected that means we have allowed workday to come up with the total pulled amount"— 默认选的是 Bottom-Up,也就是让 Workday 自己算出总池金额。

49:15

上传奖金的EIP配置

上传奖金的EIP配置
  • 集成(EIP)配置页(画面原文):General Settings——Name=Import Employee Award EIB,ID=ImportEmployeeMeritAwardEIB
  • Get Data / Data Source——Retrieval Method=Attach File at Launch,Retrieval Details=(Attachment) Import Employee Awards (WS Background Process),File Name 在下方
  • 口播:这个 EIP 的关键是 Web Service 操作要选 Import Employee Awards,不选它就只是个普通 EIP;生成模板后下载下来填写

"you have to select the um the web service operation which which is the import employee Awards so if you select this um otherwise it's just a normal e there's nothing particular special about it uh besides the web service"— 必须选 Web Service 操作 Import Employee Awards;否则它就是个普通 EIP,除了 web service 没别的特殊之处。

50:15

EIP模板关键列

EIP模板关键列
  • 模板第二个工作表 Employee Award Data 的列(画面原文):A Header Key、B Line Key、C Employee*(Required,示例 192320)、D Position、E Merit Increase Percent、F Merit Increase Weighted P…、G Merit New Pay Amount、H Merit Amount、I Merit Adjustment Comme…、J Promote(Y/N)、K Promotion Amount、L Promotion New Pa…
  • 列分组标注为 Employee Award Identification / Employee Award Merit Data / Employee Award Promotion Data(Employee Award Data),表头三行是 Areas / Restrictions(Required、Optional)/ Format(Text、Number (19,6)、Y/N)
  • 口播:模板两个页签,第一页填 Compensation Review 名称(即流程 ID);这页按行 ID + 计划名 + 百分比填 merit/bonus,Promote 列填 Y/N;manager 不愿进 Workday 逐条改时,收 Excel 从这里灌进去

"the template has two tabs you would enter the award um you know the compensation review name uh this is the ID of the U the process and you have to enter that on first Tab"— 模板有两个页签,第一页要填 compensation review 的名字——那就是流程的 ID。

52:15

排程运行集成上传

排程运行集成上传
  • 菜单搜 intsys: award 打开 Schedule an Integration(画面原文):Request Name=Import Employee Award EIB,Integration System=Import Employee Award EIB,Run Frequency=Run Now
  • Integration Criteria 2 items:(Attachment) Import Employee Awards (WS Background Process) 行勾 Integration Attachment、Value Type Specify Value 挑文件;Import Employee Awards 行的 Errors and Warnings Spreadsheet 与 Validate Only Load 都是 Use System Default
  • 口播:预算池、员工新奖金目标、merit+bonus 一起发时的加薪额,都可以通过这类 Excel EIP 上传——可按全公司或几个顶级组织分别灌

"you take that Excel file and add it to the add it to this EIP and and then load it by running that uh you know by launching this uh integration system"— 把那份 Excel 挂到这个 EIP 上,再运行、启动这个集成系统就能把数据灌进去。

58:00

逐人下发计划任务页

逐人下发计划任务页
  • 任务 Rollout Compensation Plans to Employees(画面原文):必填 Process Name、Effective Date、Reason、Compensation Plans;另有 Expected End Date、Actual End Date;Select Employees 区提供 By Compensation Eligibility Rule(或逐个选人)
  • 页顶说明原文要点:此任务用于给员工分配新计划;已在进行中薪酬流程的员工不会通过该任务收到计划;Expected End Date 会写进所选 allowance 计划的分配期
  • 口播:漏掉的人(等待期、错 job profile、下发时在休假)不能整规则批量补,要先跑报表找出休假名单,再在这里一个一个手动指定

"you have to type in type out roll out Compensation Plan to employees and you have to select the employees manually one by one in this section so you cannot use a particular rule"— 得手动搜 Rollout Compensation Plan to Employees 这个任务,在这个区域里一个一个挑人,不能用规则批量。

1:00:45

创建网格第一步

创建网格第一步
  • Create Grid Configuration(画面原文):两个方式单选 Create Blank Configurable Grid / Copy Details from Existing Configurable Grid,另有 What type of grid do you want to create?、Name、Comment
  • 口播:通常不建空白网格,选第一项能看到交付网格按类别分组:Compensation Review、Recruiting、Shared Participation Compensation Review
  • 口播:Shared Participation Compensation Review 是 Workday 前些年合并进来的,讲师已不用旧的 Compensation Review 网格

"we to typically start with a existing grid because work there provides you a grid to start with and you can see what those uh delivered grids are by selecting the First Choice which says delivered grid configurations by category"— 我们一般从现成网格开始,因为 Workday 提供了交付网格;选第一项 Delivered Grid Configurations by Category 就能看到都有哪些。

1:01:45

复制共享参与网格

复制共享参与网格
  • 画面:Copy Details from Existing Configurable Grid 选中,下拉里选了 Shared Participation Merit Bonus and Stock Grid v1.0,What type of grid 自动变为 Shared Participation Merit Review Process
  • 口播:这张交付网格自带 Merit、bonus、stock 字段,非常实用;新网格命名惯例是加自己姓名缩写,演示里叫 …2020 test…
  • 口播:网格就是上次看到的那张——列出每个员工的现薪、新薪、新奖金目标、新 merit 百分比

"the one we use is actually called shared participation composition review and here is a fantastic grid that already has Merit bonus and stock uh uh fields on it"— 我们真正用的是 Shared Participation Compensation Review——这张网格特别好用,Merit、奖金、股票的字段都是现成的。

1:03:15

网格员工组合列

网格员工组合列
  • Grid 编辑器(画面原文):Composite Column 标签 ~Employee~,4 行字段——Title=Employee、First Subtitle=Supervisory Organization、Second Subtitle、Image=Photo(Business Object 为 Adjustment For / Employee)
  • Individual Columns 1 item:Advanced 类型列 Previous Proposal(上一轮提案)
  • 口播:不想显示照片就删掉 Image 那行;Merit 段默认带的 primary compensation basis 字段单独看没大用,很多公司直接去掉——留哪些列要问业务需求

"by default it has these columns like previous proposal and then there is a mer section um which has their primary compensation bases usually this field by itself um is not very useful"— 默认就有 Previous Proposal 这类列;Merit 段里那个 primary compensation basis 字段单放没什么用。

1:06:15

Merit分组默认列

Merit分组默认列
  • Grouped Columns 20 items,Merit 组(画面原文):Read Only 列 Field=Primary Compensation Basis Current - Amount as of Bonus Compensation Snapshot Date(Business Object Adjustment For,Label Override Primary Compensation Basis,Display Options Show Currency Symbol)
  • 同组还有 Read Only 列 Merit Target Percent、Editable 列 Merit Increase %;上方 Advanced 列 Previous Proposal
  • 口播点出的交付网格大缺口:没有「某个历史日期的工资」这一列——2020 年启动评的是 2019 年的绩效,管理者需要看员工 2019/12/31 当天的薪资,Workday 不交付该字段,几乎每家公司都要自己加(后面几帧演示建法)

"workday does not deliver that field at all you know there's all these fields but you know this has your current salary but it doesn't have your salary as up that particular dat in the past so that is something you know that's a very common field that you have to actually add"— Workday 根本不交付这个字段——它有当前工资,但没有过去某个日期的工资。这是非常常见的、要自己加的列。

1:09:45

造去年12月31日字段

造去年12月31日字段
  • 计算字段 RM CF Date 12/31(画面原文):Business Object Global;Calculation 页说明 Builds a date or time field from the date/time components;Field Type Date
  • Year=Extract Year from Date Field 选 Last Day of Last Calendar Year (System);Month=Specific Month 12;Day=Specific Day 31;出错返回空白(…rror: Yes)
  • 这样每年自动得到上年 12 月 31 日,不用改配置;讲师自嘲这个多层嵌套他看了两年才看懂
  • 这个日期字段是后面 Lookup Value As Of Date 的 Effective Date 输入

"the value I chose was select the Year from the last day of the last calendar year so it will get the value like we're in 2020 so the last day of last calendar year would be the year would be 2019 and the month will be 12 and the day should be uh 31st"— 年份我选「取上一个日历年最后一天的年」——现在是 2020 年,它就取 2019,月填 12、日填 31。

1:15:45

印度薪资加津贴算式

印度薪资加津贴算式
  • 计算字段 RM KOG_Total Base Pay + Allowances(画面原文):Business Object Worker,Field Type Currency,Currency Code Field=Total Base Pay - Currency,Return Zero on Error Yes
  • Arithmetic Expression 共 5 行:( Total Base Pay - Amount * .83 ) + ( Total Base Pay - Amount * .25 ) + Total Base Pay——即「工资×83% + 工资×25% + 工资」
  • 口播与画面的系数差异要点明:法律口径是津贴 88%、公积金 12%(口播另说 demo 里写成 83/25 只是沿用租户里现成的数字字段,in real life this supposed to say 88)——画面系数以 .83/.25 为准
  • 口播还给了类似场景:销售 60/40 薪酬结构,要按佣金比例反推显示 base pay

"I used 83% and 25% because I didn't want to create additional you know number U Fields so we're just going to use 83% but the idea is the same"— 我用 83% 和 25% 是懒得再建数字字段,思路是一样的(真实应按津贴 88% 口径)。

1:23:40

条件计算字段框架

条件计算字段框架
  • 在新网格里重建同款列:Create Calculated Field - Evaluate Expression 页(画面原文)——Field Name=RM Salary as of Dec 31 Prev Year,Business Object=Worker
  • 页顶说明:Evaluates a series of conditions…first condition that is true…if no conditions are true, returns the default value;表结构为 Order / *Condition / *Return Value If Condition is True 加一个必填 Default Value
  • 设计思路(口播):默认值=非印度员工的 Total Base Pay;条件分支=India 员工返回「工资+津贴」的计算值
  • 口播还提到强制项:选了 conditional calculator 就必须把条件配完才能保存(讲师本想 7:31 收工,被系统逼着继续)

"since we're going to evaluate a bunch of conditions to come up with the with our final value is going to be uh evaluate conditions is the calcul field type"— 因为要靠一组条件算出最终值,计算字段类型就选 Evaluate Conditions(Evaluate Expression)。

1:24:45

按日期查值字段

按日期查值字段
  • Create Calculated Field(画面原文):Field Name=RM Total Base as of 12/31 non-India,Business Object=Worker,Function 下拉选中 Lookup Value As Of Date
  • 口播:要查的值选 Total Base Pay Amount,Effective Date 引用刚建的 RM CF Date 12/31——这就是「取历史某日数值」的标准搭法
  • 该字段将作为上一个条件字段的 Default Value(非印度员工分支)
  • 口播建议:这种多层嵌套的字段一层一层剥着建,先建日期、再建查值、最后拼条件

"so in that case the the value that we want to put pull up is total base pay okay total BP amount and then effective date um we could create this as another calculat field and this is the one that says December 31st"— 要查的值是 Total Base Pay Amount,生效日期就用另一个计算字段——那个算出 12 月 31 日的字段。

1:29:00

真假条件判断地区

真假条件判断地区
  • Create Calculated Field(画面原文):Field Name=RM Worker is in India,Business Object=Worker,Function=True/False Condition——条件分支的判断位
  • 口播比较两个字段定义:Primary Work Address Country 是员工工作地点地址的国家;Work Address Country 取 work address 的国家、为空时回落到主地址国家——所以用后者更稳
  • 演示租户里没有单独的 India region 可用,讲师凑用了现成 region 值;真实项目应建 region 并挂到地点层级;也可直接用工作国家=India 判断
  • 条件命中时返回的就是前面那条 Total Base Pay + Allowances 算术字段(01:15:45)按 12/31 取值的组合

"primary work address country is the country of the workers's location address and work address country is a country from the work address for the worker if the work address is blank then use the country of the primary address"— Primary Work Address Country 是工作地点地址的国家;Work Address Country 取工作地址的国家,工作地址为空时回落用主地址国家——所以最好用后者。