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

Workday 薪酬业务进程与自定义报表入门:四类专业进程的差异 + Simple / Advanced 报表实操

Calculated Fields Design and Configuration in Workday HCM | ZaranTech

频道:Workday Learner Community(ZaranTech) 时长 1:13:56 发布于 2024-09-18 32 帧对照 · 全片覆盖 原视频 ↗
⏱ 每节的 时间点 对应视频画面,点开原视频拖到该时间即可对照。
这一集的标题写的是 Calculated Fields Design and Configuration,但正片其实没讲计算字段的设计与配置:前 26 分钟讲的是四个薪酬业务进程(Request One-Time Payment、Request Compensation Change、Proposed Compensation Hire、Proposed Compensation Change)的区别与实操,之后转到 Workday 报表——站点地图、标准报表、Create Custom Report 的 Simple / Advanced 两种类型、索引与非索引数据源、字段与业务对象、排序、Filter、Prompts、Output(图表)与 Share。计算字段只在约 00:48:50、00:51:30~00:52:30 和 00:54:30 被顺带提到(讲师说:交付字段不够用时你得自己配 calculated field,甚至要配嵌套的计算字段,还要考虑 Security)。所以本页按实际内容拟标题,作为教程站第 15 章报表与第 14 章薪酬两处的实战补充。画面是黑底手写板 + Workday 租户实操的直播录屏,手写板字迹潦草,涉及字段类型名、功能类型和参数值时一律以画面文字为准,画面读不清的地方标(待核对),没有用常识补。字幕是 YouTube 自动生成的,术语误识别很多:hire 常被转成 higher、compensation 转成 compens / com、allowance 转成 Elance、Hourly 被转成 early 或 arly(例如 00:21:10 口播的“total pay early”画面实为 Total Pay (Hourly)、“early non-union compensation grade”画面实为 Hourly Non Union (No Steps))、eligibility 偶尔转成 EMP。正文统一用正确术语,quote_en 保持字幕原样不改。抽帧 49 张,目视去重后保留 32 张。
3:10

四类进程分成两组

四类进程分成两组
  • 白板右上把 Propose Compensation Hire 与 Propose Compensation Change 用大括号并成一组,标注 sub process(子进程)。
  • 下半块把 Request One-Time Payment 缩写成 OTP,下面一行写 standalone → (Task),意思是独立进程可以由任务直接发起。
  • 同期口播补齐父进程归属:Proposed Compensation Hire 的父进程是 Hire Employee,Proposed Compensation Change 的父进程是 Change Job,两者只能通过父进程触发。
  • 口播另说明 Request Compensation Change 也有同名任务可以直接发起,不作为任何进程的子步骤。
  • 黑底手写板字迹潦草,专有名词以口播为准;字幕把 hire 转成 higher、compensation 转成 compens / com。

"so proposed compensation higher uh is used as a part of higher business process so whenever you are hiring an employee whenever you are hiring an employee you will be initiating proposed compensation higher and proposed compensation change is when when you will be initiating a change of transaction"— Proposed Compensation Hire 是用在 Hire 业务进程里的:每次雇员工时你发起的就是它;Proposed Compensation Change 则是当你发起一次变动交易(change of transaction)时才会用到。

8:20

改了资格规则不会自动删

改了资格规则不会自动删
  • 白板左上一个小人代表示例员工,箭头指向方括号里的 Salary Plan 与 Allowance Plan,右侧标 (Comp);Allowance Plan 再用箭头指到 (Location),表示这条补贴的资格按地点判定。
  • 左下单独画框写 event driven,另有一条线指向缩写 RCC(对应 Request Compensation Change)。
  • 口播:改了 allowance plan 的资格规则,Workday 不会自动把它从员工薪酬里去掉,必须发起一个事件,多数就是 change of transaction,也就是触发 Proposed Compensation Change。
  • 口播同时点明 Request Compensation Change 不评估员工补偿资格,所以它也不会去删那些已经不合格的计划。
  • 白板上方还留有 LOC → 表格与 Default 两处旧笔迹,是前一段讲资格过滤只显示合格计划的板书。

"now if you change the compensation it will not automatically remove so because it is not an event driven action now even though you initiate a request compensation change workday will not remove any compensation plan that the employee is not eligible for the reason being request compensation change will not evaluate the compensation eligibility"— 你改了补偿,它不会自动移除,因为这不是事件驱动的动作。即使你发起了 Request Compensation Change,Workday 也不会移除员工已经不合格的那个补偿计划——因为这个进程根本不评估补偿资格。

12:10

雇佣时的资格检查链

雇佣时的资格检查链
  • 白板左侧三行金额:Salary Plan = 15000 USD 打勾、Allow 1 = 1000 USD 打勾、Allow 2 = 2000(原数字被划掉)先叉后勾,旁边写 reconfigure 并带箭头,讲的是资格规则改过之后没有事件就维持原样。
  • 竖线右侧是 Proposed Compensation Hire 分支,往下写 Eligibility → Compensation Package → Gr(ade)。
  • 口播给出这条链的准确顺序:先查员工符合哪个 compensation package,再查 eligible 的 grade、compensation plans,以及有没有 custom compensation bases。
  • 关键限制:哪怕配了五个 compensation package,员工也只能命中唯一一个,只有唯一命中时值才会 default 出来。
  • 三项资格规则都通过后,Workday 会在雇佣时把值自动 default 到 compensation 屏上,操作人不必自己判断该挂哪个 grade 或 package。

"what workday does is workday will check okay if the employee is eligible for a compensation package it will first check the compensation package the employee is eligible for if the employee is eligible for a compensation package it will see if they are eligible for a unique compensation package let's say there are five compensation packages that are configured the employees should only be eligible for one of the compensation package they should not be eligible for more than one only then the value will default"— Workday 会先查员工符合哪个 compensation package,再看他是不是只符合唯一一个。假设一共配了五个 package,员工应当只符合其中一个,不能同时符合两个以上,只有唯一命中时值才会自动带出来。

15:45

变动时的双向评估

变动时的双向评估
  • 白板顶部写 Propose Comp Change,向下箭头指小人(员工),右侧三行:Allowance1 → 2000 USD 打勾、Allowance 2 → 打叉并被红框圈住、Allowance 3 = 1000 USD 打勾,左下另写 Evaluate Compensation。
  • 红叉那一行表达的就是口播规则:现有组件仍合格就留、不合格就移除,同时把这次变动后新合格的计划一并 default 进来。
  • 口播给结论:Request Compensation Change 与 Request One-Time Payment 这两个 standalone 进程不会触发任何补偿资格评估;Proposed Compensation Hire 与 Proposed Compensation Change 才会评估并带值。
  • 带值时如果资格变了,就自动加或自动减员工身上挂的补偿组件。
  • 讲师提醒这是补偿顾问面试的常见考点,要答出资格在哪个时点被评估。

"three business processes the request compensation change and request onetime payment these two business processes will not these are Standalone business processes these will not trigger any kind of compensation eligibility whereas proposed compensation higher and proposed compensation change these both will evaluate the comp eligibility and it will default the value for the person"— Request Compensation Change 和 Request One-Time Payment 这两个是独立进程,不会触发任何形式的补偿资格评估;Proposed Compensation Hire 和 Proposed Compensation Change 两个都会评估资格,并替操作人把值自动带出来。

17:10

业务进程定义里看清审批步

业务进程定义里看清审批步
  • 页面标题 View Business Process Definition,对象名 Request Compensation Change;Effective Date 04/15/2024、Time Zone GMT-08:00 Pacific Time (Los Angeles)、Due Date 1 Week,并有 View Diagram 按钮。
  • 页签共四个:Business Process Steps、Notifications、Allowed Actions by Role、Allowed Services;Business Process Steps 表显示 5 items。
  • 步骤 a 的 Type 是 Initiation;步骤 b 是 Action,Specify 填 Review Compensation Change,Group 为 Compensation Partner,If 条件是 No Current Assignee was Initiator or Prior Approver?,Due Date 2 Days。
  • 步骤 c 是 Approval,Group 为 Manager,Additional Information 写 Restriction: Subject、Alternate: Alternate Approver,Due Date 2 Days。
  • 中间搜索框的 Recent Searches 里能看到 BP: REQUEST COMPENSATION CHANGE、Maintain Compensation Basis、create allowance plan 等历史词。

"so this is the request compens Deion change business process so whenever you want to request a com change it will trigger this particular business process and this is how you can initiate it so let me go to any employee so let's say I want to initiate a compensation change for this particular employee I can directly go to their actions here and say compensation request compensation change"— 这就是 Request Compensation Change 业务进程:你要发起补偿变更时触发的就是它。发起方法是进到任意员工,直接点他的 Actions,选 Compensation > Request Compensation Change。

17:50

这张屏只让你改值

这张屏只让你改值
  • 变更屏按类别分组:Grade 为 Hourly、Grade Profile 为 Canada;Salary 组只有一个 Add 按钮;Hourly 组已有一条 Assignment Details 显示 16.00 CAD Hourly。
  • 每条计划带 Plan Name(Hourly)与 Effective Date(04/01/2018)两栏,行右侧是 X(删除)与铅笔(编辑)两个图标,组底部是 Add。
  • 口播明确:这个屏不会去检查员工是否还符合这个 grade、grade profile 或 hourly plan,只想改值就直接改,例如把 16 改成 36。
  • 口播同期说明这条进程的权限:一般只授给 Compensation Administrator 或 Compensation Partner,经理没有发起权限。
  • 画面上的 16.00 CAD Hourly 正是 00:19:50 那帧里 Total Base Pay Range 下限(16.00 - 26.00 - 36.00 CAD Hourly)。

"now in this particular screen work is not going to check if the employee is still eligible for this grade or this grade profile or it is going to check if the employee has you know the same hourly plan is he is he still eligible for an hourly plan it will not check all those details it will just let you change the values here so if you want to change the value from 16 to 36 it to let you change it"— 在这个屏上 Workday 不会检查员工是否还符合这个 grade 或 grade profile,也不会检查他是不是还符合 hourly plan——这些都不查,它只让你把值改掉,比如从 16 改成 36。

19:50

员工薪酬页的分组

员工薪酬页的分组
  • 左侧员工卡:Tom Kerr,副标题 Shipping & Receiving Associate;页签依次为 Total Rewards、Compensation(当前)、Pay Change History、Employee Compensation Analysis、Reimbursable Allowance Plan Activity。
  • Totals 表 1 item,列头是 Total Base Pay / Market Position (Base Pay) / Total Pay (Hourly) / Currency / Frequency,值分两行 16.00 与 11.85,Market Position (Base Pay) 显示 Below Market,Currency 列 CAD 与 USD,Frequency 为 Hourly。
  • Compensation 区字段:Compensation Package Hourly、Grade Hourly、Grade Profile Canada、Total Base Pay Range 16.00 - 26.00 - 36.00 CAD Hourly、Company Global Modern Services, Ltd (Canada)。
  • Plan Assignments 表 2 items:04/01/2018 Plan Type Hourly / Compensation Plan Hourly / Assignment 16.00 CAD Hourly;01/01/2016 Plan Type Merit / Compensation Plan Merit - Hourly / Assignment 3.00% Annual。
  • 口播同期演示 Request One-Time Payment:Actions > Compensation 里能看到该进程,任何一天都能发起,从员工有资格的计划列表里挑一条提交,例如给 5,000 的 spot bonus,属一次性、非经常性支付。

"even similarly the request one time payment is also similar you go to the actions you go to compensation and you can see request onetime payment business process so you can initiate a onetime payment on any day so let's say I want to make a onetime payment as of today I can select today's date here and I can uh select add the onetime payment here and I can initiate so I can select the list from the list of plans which plans are eligible for the worker"— Request One-Time Payment 也一样:进 Actions、选 Compensation 就能看到它,任何一天都能发起。想今天就付就选当天日期、加一条一次性付款,从员工有资格的那些计划里选一个再提交。

20:40

雇佣历史里的进程步骤

雇佣历史里的进程步骤
  • 页签 Details / Process(当前)/ Related Links;Process History 共 44 items,列 Process、Step、Status、Completed On、Due Date、Person (Up to 5)、All Persons、Comment。
  • 高亮行:Process 与 Step 都是 Propose Compensation Hire,Status Submitted,Completed On 10/27/2012 02:54:25 PM,Due Date 11/03/2012,Person 是 Logan McNeil (Compensation Partner)。
  • 同一进程的后续步 Review Compensation Hire、Approval by Controller 都是 Not Required;上面的 Background Check 那步由 Logan McNeil (HR Partner) Submitted,Approval by HR Partner Not Required。
  • 下面还有 Hire 进程的 To Do: Enable Workday Account、Remove Retiree Status、Maintain Employee Contract、Edit Service Dates 等步,状态都是 Not Required。
  • 这张表正好证明 Propose Compensation Hire 是作为 Hire 进程内的一步被提交过的,而审批步可以按配置整段跳过。

"so you will see propose compensation higher initiated as a part of higher business process if I take any employee for example let's let me see if I can check out the worker history for um Tom so let me go to worker history here and let us see if this person was hired directly using an eiv or uh using an actual proper higher transaction"— 你会看到 Propose Compensation Hire 是作为 Hire 业务进程的一部分发起的。这里拿 Tom 举例,打开 worker history,看看这个人是直接用 EIV 进系统的,还是真做过一次完整的 hire 交易。

21:10

系统自动带出的三类变更

系统自动带出的三类变更
  • 只读页头:Job Profile Shipping & Receiving Associate、Time Type Full time、Location Calgary。
  • Compensation Basis Amount Changes 共 2 items:Total Base Pay 与 Total Pay (Hourly) 的 Current Total 都是 0.00,Amount Change 与 Proposed Total 都是 15.00 / 11.11,Currency 同时列 CAD 与 USD,Frequency Hourly。
  • Guideline Changes 共 3 items,Effective Date 都是 03/05/2012:Plan Type Compensation Package 的 Proposed Changes 是 Hourly;Plan Type Grade 是 Hourly Non Union (No Steps);Plan Type Grade Profile 是 CAN - Hourly。
  • 页面底部还有 Plan Assignment Changes(1 item),列 Effective Date / Plan Type / Plan Name / Proposed Change。
  • 术语校正:口播(自动字幕)说的 total pay early 画面实为 Total Pay (Hourly)、early non-union compensation grade 画面实为 Hourly Non Union (No Steps),以画面文字为准。

"it will automatically assign early compensation package it would automatically assign early non-union compensation grade and the grade profile even when it comes to the compensation basis you can see there is a custom comp basis the employee has been assigned which is total pay early and depending upon the configuration these these all details are automatically assigned"— 它会自动挂上 Hourly 的 compensation package、Hourly Non Union 的 compensation grade 和 grade profile;compensation basis 这里也一样,员工被分配了一个自定义补偿基准。按配置不同,这些细节全部自动赋值。

22:10

Change Job 起始步字段

Change Job 起始步字段
  • 页头 Change Job,被操作员工 Tom Kerr;Start 分组下 Start Details 的必填项 When do you want this change to take effect? * 已填 04/15/2024,Why are you making this change? * 尚空。
  • 往下两项:Who will be the manager after this change? 为 Enrique Vasquez;Which team will this person be on after this change? 为 Property Management - CAN Group。
  • 右侧帮助组件 Need help with the Job Change process? 的 Help Topic 是 Job Change Video Guide,页面正文另有链接 How to Initiate a Job Change Video。
  • Employee Employment History 组件对 Tom Kerr 给出 Length of Service 10 - 15 Years、Time in Position Range 10+ Years、Promote in Last 3 Years 显示红叉。
  • 口播同期说明这是一张合并式(consolidated)模板,要一步步填,讲师直接跳到 compensation 那一步演示。

"here let's say I'm making a change um let's say I'm doing a data change so I'll just change the location so right now he is in Calgary I'll just change this to let's say Toronto or maybe let's say I'm going to change this to New York so so let's start this process so as a part of change of business process you can see if I scroll down here so this is like a Consolidated template where you will be like filling out a form step by step"— 这里做一次 data change,只改地点:他现在在 Calgary,我改成 Toronto 或者 New York,然后启动流程。Change Job 是个合并式模板,你得一步步把表填下去。

24:10

加与删用圆点和叉标出

加与删用圆点和叉标出
  • Basis 为 Total Pay (Hourly),Basis Details 一行写 11.847024 USD Hourly,后面灰色小字 was 16.00 CAD Hourly,改前值直接留在同一行。
  • Guidelines 分组里 Total Base Pay Range 两行:蓝点行 8.00 - 16.50 - 25.00 USD Hourly 后标 added,红叉行 16.00 - 26.00 - 36.00 CAD Hourly 后标 removed。
  • Compensation Package 为 Hourly、Grade 为 Hourly,都没有变化标记;Grade Profile 显示红叉 Canada removed,且没有新的 grade profile 补进来。
  • Salary 分组底部只剩 Add 按钮,说明这次系统没有自动新增 salary 计划。
  • 口播解释:看到 X 就是被移除了;因为 New York 这个场景下没有匹配的 grade profile 可 default,币种则随 compensation grade 从 CAD 变成 USD。

"so let us look at the compensation over here you can see that you can see some of these if you see an x mark that means it has removed so you see that the the pay range has been changed so the there is a compensation package there's a compensation grade but the grade profile got removed but there was no other compensation grade profile added here so probably there is no other grade profile either they are not eligible"— 看这里的 compensation:带 X 的就代表已被移除。pay range 变了,compensation package 和 compensation grade 都还在,但 grade profile 被去掉了,也没有新的 grade profile 补上来,说明在这种情况下他确实不再合格。

26:45

一张报表看全补偿计划

一张报表看全补偿计划
  • 报表标题 Compensation Plans,顶部有 View As Of 日期框;页签按计划类型排开:Salary Plans、Hourly Plans、Unit Salary Plans、Period Salary Plans、Allowance Plans、Unit Allowance Plans、Merit Plans、Bonus Plans、Commission Plans、Stock Plans、Future Payment Plans、One-Time Payment Plans、More。
  • 当前 Salary Plans 共 4 items,列 Salary Plan / Plan Description / Compensation Element / Eligibility Rules / Used by Compensation Package。
  • 例:Salary(Plan Description 为 General Salary Plan)的 Compensation Element 是 Base Pay,Eligibility Rules 是 Salaried Compensation Group (with Exceptions),被 Executive、Management、Sales、Team Member (except India)、Team Member (India) 五个 package 使用。
  • 例:International Assignment Salary 对应 International Pay、规则 On International Assignment、用于 Management 与 Team Member (except India);GMS Salary Plan 对应 Base Pay 与规则 GMS Salaried;Salary - Ongoing Severance 对应 Severance Ongoing,后两栏为空。

"the compensation plans report will give you the list of all the compensation plans available in work day so you can directly run this particular report and see okay these are the these are the salary plan these are the hourly plans so it will give you a comprehensive view of all the compensation plans available in workday so whichever are configured you will be able to view all those compensation plans along with the eligibility rule comp element and uh the packages whatever is configured"— Compensation Plans 报表会列出 Workday 里所有可用的补偿计划,直接跑一下就能分好类看到 salary plan、hourly plan;凡配置过的计划,连同它的资格规则、comp element 和所属 package 都会一起呈现。

27:20

分配审计弹窗只有三个入参

分配审计弹窗只有三个入参
  • 弹窗标题 Compensation Plan Assignment Audit,只有三个字段:Compensation Plans(带红星,必填)、Start Date、End Date,右下角橙色 OK。
  • 画面里 Compensation Plans 框中输入了 salary,选择列表尚未展开;背景是被遮住的 Compensation Plans 报表页。
  • 口播交代用法:这张审计报表用来查某个具体日期上谁被挂到了哪个 compensation plan,日期给错就什么都查不到。
  • 同期还演示了先查某条计划(字幕转成 11's holiday)结果为无人分配,需要给正确的 start date 再查。

"Compensation Plan assignment audit is usually used when you want to check um Which comp who has been assigned which Compensation Plan as of a specific date so if you you have to provide the right date uh the assignment date and as of that date how many employees are added that particular Compensation Plan you can check those compensation plans"— Compensation Plan Assignment Audit 一般用来查“谁在某个具体日期被挂到了哪个 compensation plan”,所以要给对日期,也就是那个分配生效日;以那天为准就能看到有多少人被加进了这个计划。

28:45

站点地图按域列报表和任务

站点地图按域列报表和任务
  • 页面标题 Available Reports and Tasks,说明行原文:To view a report, click the report name. To start a task, click the task name.
  • 左侧是按业务域排的树:Business Assets、Business Process、Calendar、Campaign、Career Hub、Cash、Committees、Company Property、Compensation(当前选中)、Compensation Survey Job Matches、Consolidation Data Capture、Content Development、Corporate Directory、Customer Accounts、Customer Central、Customer Configurations、Document Generation。
  • 右侧分 Reports / Tasks 两栏,Reports 可见条目含 Allowance Plan、Approve Compensation Award Proposals (DO NOT USE)、Audit Compensation Grade、Average Base Pay、Average Compa-Ratio by Job Profile and Quarter、Base Pay、Benchmark Jobs Audit、Bonus Plan、Calculated Plan、Calculated Plan Calculation Category Audit、Commission Plan、Compare Workers,并有 More (95) 展开剩余。
  • Tasks 栏可见 Add Compensation Survey Jobs、Add Employee To Compensation Review Process、Add Stock Grant、Assign Future Payment Plans、Compensation Review Manage Employee Processes。
  • 口播给出的结论:站点地图会按当前登录用户(这里是 Logan McNeil)列出他能用的全部报表和任务,是自查权限范围的入口。

"these are all the reports that are available for Logan McNeil and these are all the task that are available so sitemap will give you like a comprehensive view of reports and tasks that are available for the employee"— 这些就是 Logan McNeil 这个用户能看到的报表和能做的任务。站点地图会给你一份全景视图:这个员工手里到底有哪些报表、哪些任务可用。

29:20

grade 里维护的 pay range

grade 里维护的 pay range
  • Default 区四个字段逐字:Base Pay Elements = Standard Base Pay、Eligibility Rules = Hourly - NOT Union、Currency = USD、Frequency = Hourly。
  • 下方两个页签:Compensation Pay Range(当前)与 Compensation Grade Profiles。
  • Compensation Pay Range 共 4 items,列 Pay Range / Compensation Basis / Minimum / Segment 1 Top / Segment 2 Top / Segment 3 Top / Segment 4 Top / Midpoint,四行都基于同一区间 8.00 - 25.00 USD Hourly。
  • 四条区间分别挂不同 compensation basis:Total Base Pay、Total Pay (Hourly)、On Target Earnings、Total Compensation,数值都是 Minimum 8.00、Segment 1 Top 12.25、Segment 2 Top 16.50、Segment 3 Top 20.75、Segment 4 Top 25.00、Midpoint 16.50。
  • 口播补充:这份 Compensation Grade 报表里一共有 17 个 grade profile;Compensation 域可探索的标准报表约 149 张。

"so you can see for this particular compensation grade we have this is the pay range that is maintained and these are the grade profiles that are maintained there are 17 grade profiles within that particular uh report of compensation grade"— 可以看到这个 compensation grade 上维护了哪些 pay range、又维护了哪些 grade profile——这份 Compensation Grade 报表里一共有 17 个 grade profile。

32:00

报表分两大类

报表分两大类
  • 白板左上写 SAP → ABAP 并向下画箭头,右上写 Reports → Standard Rep(orts),是报表章节的开场分组。
  • 口播对照:在 SAP 里做报表要写 ABAP 程序、耗时长;Workday 里创建 custom report 几乎是即时的,配好就能在租户里用。
  • 两大类:Workday 已交付、在站点地图 reports 区能看到的 standard reports,以及自己配的 custom reports;自定义报表能自己定字段、列、过滤和提示。
  • 口播列出 custom report 的类型:simple、advanced、matrix、nbox、trended、search、composite。
  • 本场只讲 simple 与 advanced 两类,其余归到单独的 advanced reporting 专题。

"so in workday we have uh two types of reports one is the standard reports one is the standard reports standard reports are the reports that are already available delivered by workday so when you go into the site map you see there's a section called as reports so these are the delivered reports by workday"— Workday 里报表分两类:一类是 standard reports,也就是 Workday 已经交付好的,进站点地图会看到一个 reports 区,那些就是交付报表;第二类叫 custom reports。

34:50

临时报表与性能勾选

临时报表与性能勾选
  • Create Custom Report 表单:Report Name 已填 Simple Test Report,Report Details 下 Report Type 选 Simple。
  • Temporary Report 勾选框被勾上,浮层提示原文:Mark the report to expire after a certain number of days.
  • 口播说明有效期约 30 天,30 天后这张报表会被 inactivated,可以删掉;讲师随即表示不要做成临时报表。
  • Data Source 分组里 Optimized for Performance 未勾选,下方红字 Alert 原文:Alert: Clearing this check box enables you to select a non-indexed data source and non-indexed fields, which might cause your report to run slower.
  • 也就是说这个勾决定你能不能选非索引数据源和非索引字段,代价是报表跑得慢;Data Source 本身是必填项(红星)。

"here you can choose if you want a temporary report you can select it as a temporary report if you select it as a temporary report workday is going to expire this after for after like 30 days so you have this validity for 30 days after 30 days this particular report will get inactivated and you can delete that report so I don't want it as a temporary report"— 这里可以选要不要做成 temporary report。一旦勾上,Workday 会在大约 30 天后让它过期,也就是只有 30 天有效期,到期这张报表就被停用,你可以把它删掉。这个我不想做成临时的。

38:40

勾性能后只剩两个数据源

勾性能后只剩两个数据源
  • Create Custom Report 页:Report Name Simple Test Report、Report Type Simple、Temporary Report 未勾。
  • Optimized for Performance 已勾选,其下提示 Showing only Indexed Data So… 至 …Performance' to show all data sources.(中段被下拉框遮住,完整文案在 00:34:10/00:40:00 帧可见)。
  • Data Source 框里输入 all workers,Search Results (2) 只给两条单选:EWF All Workers 与 Indexed All Workers。
  • 口播同期解释那个小标记:像闪电(bolt)的符号代表该数据源已被索引,取值相对更快。
  • 口播另一句限制:Workday 里 indexed 数据源数量非常有限,不能每次建报表都用索引源,很多场景必须退回非索引。

"so whenever you are creating a report if you're going to say optimized for performance so if I select optimize for performance and then search for all workers you can see that all the data sources that are going to be displayed to me will have this uh this particular sign you see there is a um like a bolt there's there's a small symbol over here it it seems like electricity bolt okay"— 建报表时如果你选了 Optimize for Performance,再去搜 all workers,你会发现列出来的数据源都带同一个标记——像一个小闪电符号,看着就像电击的 bolt。

39:40

报表字段与数据源分类树

报表字段与数据源分类树
  • 页面已变成 Edit Custom Report,页眉对象名 Simple Test Report,右上另有 Report Tags 输入框。
  • 表单字段比初次进入时更全:Report Type Simple、Data Source、Data Source Filter(多出一个必填项)、Data Source Type(画面显示 Indexe…)、Primary Business Object(Worker),下方 Additional Info 折叠区。
  • 弹出的数据源选择器是 By Category 分类树,可见条目含 Public Profile Preferences、Purchase Order、Recruiting、Reference、Reference Letter、Referral、Reports、Report Writer、Request、Requisition、Resume、Retirement。
  • 下半页的 Columns 表已可编辑,1 item,列 Order / Field / Column Heading Override / Format / Options,行首有 +/- 按钮。
  • 口播同期强调索引源的坑:只有当这张报表要用的字段全都带索引值时才用 indexed 数据源,否则就别用。

"and so if I want to add any of these details you can only add you only have a very limited number of details over here so usually you only use indexed data source when you are absolutely sure that all the data all the fields in that particular report has an indexed value that you can use otherwise you will not be using it"— 如果你想加的是这里头这些字段,你会发现可选项非常有限。所以通常只有当你非常确定这张报表里所有数据、所有字段都有可用的索引值时,才去用 indexed 数据源,否则就别用它。

40:50

非索引源建 simple 报表

非索引源建 simple 报表
  • 头部只读信息逐字:Report Type Simple、Data Source 为芯片 All Workers、Data Source Type Standard、Primary Business Object Worker。
  • 对照上一帧的 Showing only Indexed Data Sources 提示:取消勾选后 Standard(非索引)数据源就能选出来。
  • Additional Info 下有三个页签 Columns(当前)/ Sort / Filter,Columns 表 3 items,列 Order / Field / Column Heading Override / Format / Options。
  • Field 选择器给出 By Category、All、Global Fields、Other 与 Search 五种取字段方式。
  • 口播同期只挂了三个字段:Employee ID、Legal Name、Position——simple report 的用法就是字段本来就知道,只是把值取出来。

"so choose an all workers so this is a non-index data data source you can see the data source type is standard here I'm going to click okay this is a simple report and let's say I want to just uh return few values like I want the employee ID I want the employee name I'll say uh uh legal name and let's say um position and again click okay"— 选 All Workers,这是一个非索引数据源,你可以看到这里 Data Source Type 是 Standard。点 OK,这是一张 simple report,假设只要返回几个值:Employee ID、员工姓名我用 Legal Name,再加一个 Position。

42:00

换 Advanced 多出的勾选

换 Advanced 多出的勾选
  • Report Name 填成 CUSTOM TEST REPORT,Report Type 下拉选 Advanced。
  • Report Details 分组在 Temporary Report 之下多出一行 Enable As Web Service 复选框,Simple 类型时画面没有这一项。
  • Data Source 分组仍是 Optimize for Performance(此时未勾)加必填的 Data Source 搜索框,Alert 文案与前面一致:Clearing this check box enables you to select a non-indexed data source and non-indexed fields, which might cause your report to run slower.
  • 口播给出的用量判断:simple report 很少被创建,97% 的情况下做的是 advanced report,差别在于 advanced 额外提供指定 business object 的选项。

"now most of the times you will not be using simple reports so simple reports are rarely created 97% of the time you'll be creating something called as an advanced report in workday so let us discuss how the advanced report look like so I'm going to say again uh custom test report now when it comes to Advanced report you have an additional option to provide the business object"— 大多数时候你不会用 simple report,simple 很少被建,97% 的情况下做的是 advanced report。我们再建一张 custom test report:轮到 advanced report 时,它多给了一个指定 business object 的选项。

42:50

Advanced 报表的八个页签

Advanced 报表的八个页签
  • 头部字段:Report Name CUSTOM TEST REPORT、Report Tags、Report Type Advanced、Data Source 芯片 All Workers、Data Source Type Standard、Primary Business Object Worker、Additional Info。
  • 页签完整一排八个:Columns、Sort、Filter、Subfilter、Prompts、Output、Share、Advanced——Simple 类型时画面只有 Columns / Sort / Filter 三个。
  • Columns 表 2 items,多出一列 *Business Object,值以芯片形式挂在行内(当前为 Worker,芯片右上带小箭头图标),后面依次 Field、Column Heading Override、Format、Options。
  • 每行左侧有 +/- 增删按钮和上下箭头调序,Order 列可点排序,说明同一张报表里不同行可以挂不同业务对象。
  • 口播同期举例:数据源仍是 All Workers,但字段可以从 Worker 对象换成 Position 对象去取,以此取到 Position 的 Reference ID。

"so in an advanced report you have the feasibility to provide different types of business objects for an example I am using workers here I can also put position over here so instead of just extracting all the values from a single primary business object I have the option to change the business object and extract"— 在 advanced report 里,你可以为字段指定不同类型的 business object:这里我用 Workers,也可以改成 Position。这样就不只是从单一 primary business object 取值,而是能按字段换对象去提取。

44:50

Filter 运算符清单

Filter 运算符清单
  • Filter 页签下分两张表:Filter on Instances(副标题 Filter conditions for filtering on instances,1 item)与 Filter on Aggregations(0 items,列头含 *Aggregation Function、Field、*Operator、Comparison Type、Comparison Value)。
  • 条件行的列序为 Order / And/Or / 左括号 / *Field / *Operator / Comparison Type / Comparison Value / 右括号,图中 *Field 已选芯片 Hire Date。
  • *Operator 下拉打开,Frequently Used 组逐字给出八项:is blank、is not blank、equal to、not equal to、greater than、greater than or equal to、less than、less than or equal to,列表底部另有一行 Search。
  • Condition as Text 此时显示 (empty),即条件尚未填完,Workday 会把过滤条件回显成一句自然语言。
  • 口播同期先讲排序:选中 Legal Name 按升序排,整张报表就按员工姓名升序输出。

"now what additional details what additional changes that you can do or additional options that you have over here is if you want to sort the entire report so let's say you want to sort it based on the name of the employees if I go here if I select legal name and if I want it to be sorted in Ascend uh ascending order you can sort the entire report in ascending order"— advanced 还额外给了这些选项,比如整张报表排序:想按员工姓名排,就选中 Legal Name、选升序,整张报表就按升序输出。

48:50

搜 base pay 出 126 个字段

搜 base pay 出 126 个字段
  • Columns 的 Field 选择器里搜 base pay,标题写 Search Results (126)——“给我 base pay”这种需求必须先定位到具体字段。
  • 结果逐字含 Base Pay Change 4、Base Pay Increase Amount this Year Annualized for Hourly Workers、Base Pay Increase Amount this Year in User's Preferred Currency、Base Pay Issue、Base Pay Proposed Annualized Amount、Base Pay Proposed Monthly Amount、Base Pay Proposed Unprorated Annualized Amount、Base Pay Quintile、Base Pay Range Segment、Base Pay Range Segment Effective(末条被截断)。
  • 字段名前的类型小图标有两种样式(灰底与蓝底,分别像 S 与 Z 的字母标),画面没给图例说明,具体含义(待核对)。
  • 左侧 Columns 表 6 items:前五行 Business Object 都是 Worker,第六行换成 Position,其 Field 已选 Reference ID,正是跨对象取值的落地样子。

"let's say base pay so you can see that there are a lot of details over here base pay so you need to also uh understand um if I if I go to the related actions over here you can see some of these are calculated Fields but some of these fields are uh delivered so you can see total base pay based on schedule vly hours so there are different uh base pay amount"— 比方说 base pay,你会看到这儿有一大堆条目,所以你得先搞清楚。打开相关操作,你会看到其中一些是 calculated field(计算字段),另一些是 Workday 交付的 delivered field;base pay 相关的金额字段也分好几种。

54:30

字段相关操作里有 Security

字段相关操作里有 Security
  • 报表定义查看页:Data Source All Workers、Data Source Type Standard、Primary Business Object Worker;页签 Columns(6 items)/ Sort / Filter / Prompts / Output / Share / Advanced。
  • 列出的字段依次是 Worker|Employee ID、Worker|Legal Name、Worker|Position、Worker|Hire Date、Worker|Total Base Pay - Amount、Position|Reference ID,前两列分别是 Business Object 与 Field。
  • 在 Total Base Pay - Amount 行点开相关操作,弹出菜单项逐字为:Report Field、Audits、Favorite、Integration IDs、Reporting、Security。
  • Security 这一项对应口播的坑:报表共享给别人后,如果对方没有数据源、主业务对象或字段的访问权,报表照样能跑,但看不到值。
  • 口播同期说明 Total Base Pay 字段的描述:该员工 primary job 的 base pay,加上所有被视为 base pay 的 comp element 之和。

"if I go to the related actions of the field you can see that for every workday delivered of field sources you will also have like a description so the description says that this is a base pay of the employees primary job and the sum of all the comp elements that are considered base pay"— 打开这个字段的相关操作你会发现,每个 Workday 交付字段都带一段描述:它是员工 primary job 的 base pay,加上所有被当作 base pay 的 comp element 的合计。

57:00

92 条输出里的空值

92 条输出里的空值
  • 报表页眉 CUSTOM TEST REPORT,结果计数 92 items,列 Employee ID / Legal Name / Position / Hire Date / Total Base Pay - Amount / Reference ID。
  • Position 与 Reference ID 成对出现(Archer Graham 的 Position 是 P-00742 Controller,Reference ID 列同为 P-00742),说明最后一列取自 Position 业务对象。
  • 金额有值也有空行:40010 Anh Phan 37.50、40014 Bill Andrews 27.50、30001 Brittany Burrows 123,600.00、21489 Archer Graham 137,025.00,而部分行 Total Base Pay - Amount 留空。
  • 口播解释空值原因:那一行是 contingent worker,承包商没有 compensation;于是再补一条 Worker Type 过滤把承包商排除掉。
  • 口播另外提到已离职(terminated)的员工也会显示为零,因为过去的补偿不再算在当下。

"however if I go to this employee I don't see any value for this employee so let us see why we are not able to see any value so the reason is this employee is a contingent worker so contractors will not have any compensation so probably all the employees who are not listed here uh who has a zero would probably be a contingent worker"— 可换到另一个员工,我就看不到任何值了。来看看为什么看不到:原因是这名员工是 contingent worker,承包商本来就没有补偿。所以那些没有列出值、显示为零的人,大概都是 contingent worker。

59:00

三条过滤与文本回显

三条过滤与文本回显
  • Filter on Instances 共 3 items:Hire Date / greater than or equal to / Value specified in this filter / 01/01/2020;Worker Type / in the selection list / Value specified in this filter / 选择列表值 Employee;Active Status / equal to / Value specified in this filter / 勾选复选框。
  • 三行的 And/Or 都是 And,Condition as Text 整句回显为:Hire Date greater than or equal to 01/01/2020 And Worker Type in the selection list Employee And Active Status equal to Y。
  • Active Status 的比较值在画面上是一个勾选框,对应文本里的 Y,而不是输入 true 字样。
  • Filter on Aggregations 仍是 0 items,正文显示 No Data,列头为 *Aggregation Function / Field / *Operator / Comparison Type / Comparison Value。
  • 口播同期开始换思路:这三条现在是硬编码的,客户想在执行时自己改,就得把 Comparison Type 从 value specified in this filter 改成 prompt user for value。

"so here I am hardcoding it so I'm saying that higher date is greater than or equal to a specific date I'm saying that worker type is employee and I'm saying active status is equal to yes now the client wants the ability to change this at the time of executing the report"— 这里我是把条件写死的:Hire Date 大于等于某个具体日期、Worker Type 是 Employee、Active Status 等于 yes。可客户希望在执行报表的时候自己改这些值。

1:02:10

提示词的标签与默认值

提示词的标签与默认值
  • Prompts 页顶部是 Instructions 文本框;Runtime Date Prompts 两项 Effective Date 与 Entry Date 都取 Use date and time at runtime;下面 Populate Undefined Prompt Defaults 未勾,Display Prompt Values in Subtitle 已勾。
  • Prompt Defaults 共 3 items,列头依次为 *Field / Prompt Qualifier / Label for Prompt / *Default Type / Default Value / Required / Do Not Prompt at Runtime / Do Not Include in Subtitle。
  • Worker Type 行:Prompt Qualifier 是 Default Prompt,Label for Prompt 改成 Choose Worker Type,*Default Type 选 Specify default value,Default Value 挂 Employee 与 Contingent Worker 两个芯片。
  • Hire Date 行:Label for Prompt 写成 Hire Date(greater than or equal to),把比较方向写进标签好让执行人看懂;*Default Type 选 Determine default value at runtime。
  • Active Status 行:Label 为 Active (Yes/No),*Default Type 也是 Specify default value;三行右侧还有 Required 等三个复选列。

"and let's say at the time when the report is being executed when before even you choose the prompt I want to also provide some default prompts so here you can see specify the default value so what would happen I'll I'll just remove this one as default determin one time and here I will say specify default value so default value over here I'm saying I want to choose both I want to choose both employee as well as contingent worker"— 在执行人还没选提示词之前,我想先给一些默认值——这里能看到 Specify default value 这个选项。这一个我改成运行时决定(Determine default value at runtime),这里选 Specify default value,默认值我两个都要:Employee 和 Contingent Worker。

1:04:30

提示词留空会多出一堆结果

提示词留空会多出一堆结果
  • 报表页眉 CUSTOM TEST REPORT,副标题区把运行时提示值原样显示:Choose Worker Type 为 Contingent Worker、Employee,Active (Yes/No) 为 Yes。
  • 结果计数 583 items,明显多于之前加了 Hire Date 硬过滤后的 92 条,因为 Hire Date 提示被留空、该条件没生效。
  • 表里 contingent worker 的 Total Base Pay - Amount 显示为 0(21548 Aaron Turner、12221 Abby Brennan),其余有正常金额如 66,116.80、131,870.00、407,263.00、730,182.00。
  • 口播给出的解法:Comparison Type 换成 prompt user for the value and ignore the filter condition if the value is blank,这样既能给提示又不强制填写,行为也变得可预期。

"so there is another uh comparison type over here prompt user for the value and ignore the filter condition if the value is blank so if your customer says that I want a filter with a prompt but I don't want it to be required so in that case you will give this particular value now when I run this report you'll see that initially it has it had given me like what 583 if I run it as it is you'll see that 583 result"— 这里还有另一种 Comparison Type:prompt user for the value and ignore the filter condition if the value is blank。客户说“我要带提示的过滤,但不想强制填”时就用它。直接跑这张报表,你会看到结果是 583 条。

1:06:50

图表类型清单

图表类型清单
  • Output 页:Additional Info 下 Sections 复选框、Specify output… 说明行、Output Type、Chart Options / Primary Sections 分组、Chart Type *。
  • Chart Type 下拉逐字为:Column - Stacked、Column - 100%、Bar - Clustered、Bar - Stacked、Bar - 100%、Donut、Line、Bubble、Area - Stacked、Area - 100%、Area - Overlay、Scatter,底部另有一行 Search;框下方已选芯片是 Column - Clustered。
  • 图表参数三项:Top n Values = 50、Sum Remaining Values 已勾选、Filter by 挂着字段芯片(尾缀 …oyee ID,即 Employee ID)。
  • 口播交代:报表默认输出是 table,chart 属于 advanced reporting 范围,本场只演示 donut 一例。

"so currently the default output is a table output okay however you have some chart options over here uh again this is uh part of advanced reporting so I'm not going to go into a lot detail but you have different types of uh charting options available on the report so let's say you want a bar chart or a pie chart"— 目前默认输出是 table,不过这里有 chart 选项。这块又归到 advanced reporting,我不深挖,但报表上确实提供了不少图表类型,比如柱状图、饼图。

1:11:10

图例字段必填报错

图例字段必填报错
  • Output 页说明行 Specify output options for the report,右上角红色徽标 1 Error。
  • Output Type * 选 Chart and Table;Chart Options 展开 Primary Axis,Chart Type * 选 Bar - Clustered。
  • 参数:Top n Values = 50、Sum Remaining Values 勾选、Filter by 空、Categories (for label) * 填芯片 Employee ID、Switch Categories/Series 勾选。
  • Series (for legend) * 输入框标红,下方错误原文:Error: The field Series (for legend) is required and must have a value. 讲师当场说这个错以前没遇到过。
  • 口播给出的判断:不是每种图表都能配任意数据,数据量或维度不够时系统就不让出图;这个示例最后退回 table 输出。

"now this particular report I need to provide a series for legend I am going to check this out maybe tomorrow so you cannot have every type of chart uh there are certain charts you can use for certain type of report I mean certain type of data so if you don't have enough data it would not give"— 这张报表我需要给 Series (for legend) 提供值,这个我明天再查一下。并不是所有图表类型都能用——某些图表只适用于某类报表、某类数据,数据不够它就不会给你出图。

1:11:40

报表定义的三种共享

报表定义的三种共享
  • Share 页说明行:Specify sharing options for the report definition,Report Definition Sharing Options 后显示 (empty)。
  • 三个单选逐字为:Don't share report definition(图中选中)、Share with all authorized users、Share with specific authorized groups and users。
  • 底部 Report Owned by 显示 …cNeil / Logan McNeil,即报表所有者。
  • 页头字段仍列出 Report Name CUSTOM TEST REPORT、Report Tags、Report Type Advanced、Data Source All Workers、Data Source Type Standard、Primary Business Object Worker。
  • 口播解释:all authorized users 指的是对该数据源有访问权的人;要给具体对象就用第三项,可以同时选多个 Security Group 和若干用户。

"in the share option you will be able to Define different shares so either you don't want to share this report meaning this report will only be available for you nobody else can access this report um share with all authorized users so all authorized users are users who have access to this particular data source"— 在 Share 里能定义不同的共享方式:一种是不共享,这张报表只有你自己能用,别人访问不到;一种是 Share with all authorized users,也就是对这个数据源有访问权限的那些人。