Calculated Fields Design and Configuration in Workday HCM | ZaranTech
"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)时才会用到。
"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 也不会移除员工已经不合格的那个补偿计划——因为这个进程根本不评估补偿资格。
"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,员工应当只符合其中一个,不能同时符合两个以上,只有唯一命中时值才会自动带出来。
"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 两个都会评估资格,并替操作人把值自动带出来。
"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。
"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。
"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 就能看到它,任何一天都能发起。想今天就付就选当天日期、加一条一次性付款,从员工有资格的那些计划里选一个再提交。
"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 交易。
"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 这里也一样,员工被分配了一个自定义补偿基准。按配置不同,这些细节全部自动赋值。
"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 是个合并式模板,你得一步步把表填下去。
"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 补上来,说明在这种情况下他确实不再合格。
"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 都会一起呈现。
"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”,所以要给对日期,也就是那个分配生效日;以那天为准就能看到有多少人被加进了这个计划。
"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 这个用户能看到的报表和能做的任务。站点地图会给你一份全景视图:这个员工手里到底有哪些报表、哪些任务可用。
"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。
"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。
"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 天有效期,到期这张报表就被停用,你可以把它删掉。这个我不想做成临时的。
"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。
"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 数据源,否则就别用它。
"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。
"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 的选项。
"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 取值,而是能按字段换对象去提取。
"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、选升序,整张报表就按升序输出。
"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 相关的金额字段也分好几种。
"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 的合计。
"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。
"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。可客户希望在执行报表的时候自己改这些值。
"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。
"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 条。
"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,我不深挖,但报表上确实提供了不少图表类型,比如柱状图、饼图。
"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) 提供值,这个我明天再查一下。并不是所有图表类型都能用——某些图表只适用于某类报表、某类数据,数据不够它就不会给你出图。
"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,也就是对这个数据源有访问权限的那些人。