Workday Standard Report in Workday HCM | ZaranTech
"there is a Workday Report Writer. Uh but it's built into Workday, so when you log in to Workday, it's already part of the app and there's no separate um place to go to access Report Writer."— 有一个 Workday Report Writer,但它内建在 Workday 里,你登录 Workday 时它就已经是应用的一部分,没有单独的地方去访问 Report Writer。
"There's a report called Workday standard reports to view the Workday delivered reports. So, Workday by default gives you tons of reports and the purpose of that is to give you a starting point and then you can modify those later to customize it for your client or your customer."— 有一张叫 Workday Standard Reports 的报表,用来看 Workday 交付的报表。Workday 默认给了很多报表,目的是给你一个起点,之后你再改造成适合自己客户的定制版。
"There's other way to get to all of the reports, which is to click on the profile. And if you have site map enabled, not all tenants have the site map enabled, but um there is a site map icon, and then it will take you to the all the available reports and tasks."— 另一种拿到全部报表的方式是点 profile。如果启用了站点地图(并非所有租户都开),有个 site map 图标,点进去能看到可用的全部报表和任务。
"Once you're copied a report and you're on the edit screen um let's just familiarize with it before we go to the tenant. Um on the very left hand side uh there's columns you that you could add or remove."— 复制一张报表后就到了编辑屏,上租户之前先熟悉一下界面。最左边是能增删的列(Columns)。
"When we create your own report uh it's pretty straightforward task name. It's just create custom report. Uh one key thing is though in recent um year two years Workday has came up with an optimized for performance uh checkbox."— 自己建报表很直接,任务就叫 Create Custom Report。但近一两年 Workday 出了一个 Optimized for Performance 勾选项。
"all of the data in Workday is um, they're stored as business objects. And think of those as Think of a business object as a table or a worksheet in Excel. Workday business object has fields and instances. And the report data source provides a view into the primary business object."— Workday 里所有数据都存成业务对象,把它想成 Excel 的一张表或工作表就行。业务对象有字段和实例,报表数据源提供进入主业务对象的视图。
"class report fields, uh these are the available fields based on your security. These fields can be Workday delivered fields, calculated fields, or custom fields, and they're referred to as uh CRF, class report fields."— Class Report Fields 是按你的权限可使用的字段,可以是 Workday 交付字段、计算字段或自定义字段,简称 CRF。
"if you use all active terminated workers as the data source, this will have anybody who's currently active and who is terminated. And this will also have information on contingent workers, but it will not have future start date workers."— 如果用 All Active and Terminated Workers 作数据源,它会包含在职和已离职的人,也含临时工,但不含未来入职日期的 worker。
"there is also rich text fields. And then when next to the field, you'll see these icons. rich text also has like hyperlink. That means you could take action or you could uh from that field, you could you could click on it and then you could get more information about it."— 还有富文本字段,字段旁边你会看到这些图标。富文本带超链接,意味着你可以对其执行操作、点进去看更多信息。
"if you select employee or you put worker as the business object in this report, you'll get all of the fields that are available on that object, all of the related business objects, and all of the data sources uh this object is available on, and all of the reports uh which have this object."— 如果你选 employee 或在报表里把 worker 作为业务对象填进去,你会得到该对象上全部可用字段、全部相关业务对象、该对象所在的全部数据源,以及含该对象的全部报表。
"if you click on the fields tab, you'll see that in this case, the uh employee compensation event has 1,189 fields."— 如果你点 Fields 标签,会看到在这个例子里 Employee Compensation Event 有 1,189 个字段。
"choose a data source that already has the pre-built filters on it. So, you don't have to do that kind of processing within the report itself."— 选一个本身已带预置过滤条件的数据源,这样你就不用把这类处理放进报表里做。
"It means reporting data based on the um the instance or based on a event, but instead of having to go to the report writer uh or to the report UI, just as long as there is a related action icon available, there is a menu called reporting, and from there, if you click on reporting fields and values, um you will get the data that's available for that action."— 它的意思是基于某个实例或某个事件来出报表,不用进 Report Writer 或报表界面;只要有 related action 图标,就有个 Reporting 菜单,点里面的 Report Fields and Values,就能拿到该动作/事件对应的数据。
"these are all the different report types. So, the most common one um is called advanced and this allow you to display data from primary and related business objects. And you could sort, filter, and the data is shown in either a spreadsheet type."— 这些就是各种报表类型。最常见的是 Advanced,它能展示来自主业务对象和相关业务对象的数据,可以排序、过滤,数据以电子表格式展示。
"when possible, use data source with built-in prompts rather than manually creating any filters and prompts on more a generic data source. So, just for efficiency purposes."— 只要可能,就优先用带内置 prompt 的数据源,而不是在更通用的数据源上手摇过滤器和 prompt,纯粹是为了效率。
"in order to create custom report, your profile must be part of the one of these uh security groups. So, either it's part of the implementer, or manager, or report writer, or setup administrator, or temporary report writer."— 要建自定义报表,你的用户档必须属于这些安全组之一:Implementer、Manager、Report Writer、Setup Administrator 或 Temporary Report Writer。
"let's actually jump into the tenant and create a custom report. Create custom report. Okay, so let's think of a use case where um you are requested to for a given organization they want to know the composition of the employees in that organization. And they want to know what's their current salary and what is the proposed salary and the effective date."— 我们进租户建一张自定义报表。设想一个用例:某个组织想知道它员工的构成、现在的工资、拟议工资以及生效日期。
"And it's because the optimize for performance checkbox is pre-checked. It says, "Right now, it will only show you indexed data sources and you can unselect for performance to show all data sources.""— 这是因为 Optimized for Performance 勾选框预先勾上了,界面写着:现在只显示 Indexed 数据源,取消勾选 Optimized for Performance 才能显示全部数据源。
"now for that source, the primary business object is employee, and that's already populated over here. So, I could select any field that's available on that business object. And I could select any field that is one degree related to this business object."— 对这个数据源,主业务对象是 Employee,已经自动填好了。于是我能选这个业务对象上的任意字段,也能选与它只隔一层的字段。
"We need a salary data so I'm just going to type base pay and let's see what's out there. Okay. So there's a lot of fields related to base pay like base pay as of December 31st from previous year and so on. So the What I'm looking for is base pay current."— 我们需要工资数据,所以我直接输 base pay 看看有什么。出来一堆相关字段,像去年 12 月 31 日的 base pay 之类。我真正要找的是 base pay current。
"but if I want um the the effective date of the last pay last base pay increase I actually need to change the business object."— 但如果你要的是上一次基本工资上调(last base pay increase)的生效日期,就得改业务对象。
"these prompts automatically were built into that data source. So, I did not have to um create these prompts. And this allows the user to select um whichever organization they want the data for."— 这些 prompt 已经自动内置在那个数据源里了,我不用自己造;它让使用者去选自己要哪个组织的数据。
"the words current and proposed, they're with the respect to the transaction. So, this transaction was effective on 4/1."— current 和 proposed 这两个词是相对于这笔交易而言的,而这笔交易在 4/1 生效。
"Now, I'm going to share with you an actual report I had to build for a client. It's in Excel format. So, let me pull that up and put that on the screen. So, the use case was that for the payroll partner who was in APAC region, they wanted to see all of the compensation changes within a particular time frame."— 现在给你们看一张我实际为客户做的报表,是 Excel 格式。用例是:APAC 区的 payroll partner 想看某个时间段内发生的所有薪酬变更。
"one interesting field is date and time completed. So, this actually means um I should have actually override this heading and and change it to date uh date approved. Because the the date and time when this transaction completes is when the final approver completes it."— 有个有意思的字段是 Date and Time Completed……交易完成的时间就是最终审批人把它审完的时间,所以其实应该把列头改成 Date Approved。
"if I selected prompt then on the prompts tab I will have to add that as a prompt. So, then this field will be presented to the user at run time and then they will enter a particular date. And then that will be used as a filter."— 如果我选了 prompt,就得在 Prompts 标签里把它加成一个 prompt;这样这个字段会在运行期呈现给用户,让他们填一个具体日期,再拿它作过滤条件。
"we'll just call it compensation changes for region. We'll call it It's going to be an address report. And we're going to use um compensation changes as the data source. Oh. See, this checkbox got me again. I I went to start typing in my data source, and I have to uncheck that."— 就管它叫 compensation changes for region,用数据源 Compensation Changes。哎,又被这个勾选框坑了一次,一输数据源才发现还得先把它取消勾选。
"Date So, this one is going to be less than or equal to. And once again, we're going to prompt it... I could do a quick test to see if it's working. So, I got all of these prompts by default. Uh based on the prompts that are already there on that uh on that data source."— 另一个条件就设成小于等于,同样让用户 prompt 来填。然后我快速测一下能不能跑——默认就带出了这些数据源里已有的 prompt。