Overview of EIB in Workday HCM | ZaranTech
"in order to edit any EIB, you can access the integration system report and access the EIB from the integration systems from folder as well."— 要编辑任何 EIB,你可以打开集成系统报表,也能从集成系统文件夹里进到那条 EIB。
"And from the enterprise interface, you can make changes to your EIB as well. So, we use a custom report for our EIB. We created a Benefits Census copy of the report, uh filtered it out for a single provider for Vision, and created the EIB uh attachment around that."— 从 Enterprise Interface 也能改你的 EIB。我们这条 EIB 用了自定义报表:把 Benefits Census 报表建了个副本,按 Vision 这一个供应商做了过滤,再围绕它建 EIB 附件。
"Whenever you're trying to create uh a report to be used by an outbound EIB, you have to enable the web services option in that report."— 每当你要建一张给出站 EIB 用的报表,都必须先在那张报表里启用 web services 选项。
"first step is to set up the inbound EAB integration, create an EAB based on an inbound public Workday web service operation, grant the integration permissions, get input access to the integration even security domain, grant integration external endpoint access to Workday."— 第一步是建入站 EIB 集成:基于一个入站公共 Workday web service operation 建 EIB,授予集成权限,拿到 Integration Event 安全域的输入访问权,并授予集成对 Workday 外部端点的访问。
"From related actions menu of the integration system for the upload, select template model, generate spreadsheet. And to maintain the correct spreadsheet format, don't change the XML or XLSX format extension that you are using from the template model."— 从集成系统的 Related Actions 菜单,选 Template Model → Generate Spreadsheet。为保持正确的电子表格格式,别改你从模板带出的 XML 或 XLSX 扩展名。
"All right, so let's use the benefits department. You create say 10 positions. The task that I'm going to use is the same as inbound EIB outbound EIB. So, create EIB."— 好,我们用 Benefits Department 来示范,建大概 10 个 position。要用的任务和出站/入站 EIB 一样:Create EIB。
"So, we'll call it CT create position inbound. I select the type whether it's an inbound or outbound. And the name of the EIB the one that you created the ID is going to be assigned by Workday itself being a unique ID for this uh EIB."— 我们就叫它 ZT create position inbound(字幕念成 CT),选类型是入站还是出站;EIB 的 ID 由 Workday 自己分配,是这条 EIB 的唯一标识。
"Now, to get the data source, we are going to use select attached file at launch, and that is going to be the our Excel template or XML template that we're going to use. You have other options as well for the data source like FTPS, Google Drive, REST URL, SFTP, or any other method that you may have set up within your tenant, or you can use Amazon Simple Storage Service."— 取数源我们选 Attach File at Launch,那就是我们运行时要上传的 Excel 或 XML 模板。数据源还有 FTPS、Google Drive、REST URL、SFTP,或你租户里配好的其他方式,也可以用 Amazon S3。
"Then, the data format. So, for here, I'm going to use the web services template sheet. Or I can use a custom object sheets template. Custom objects are those objects that we create on the tenant ourselves."— 然后是数据格式。这里我用 web services 模板表;也可以用 custom object 模板。Custom Object 是我们在租户里自己建的对象。
"So, create position is delivered and designed by Workday, so I'm going to use web services spreadsheet template, and here I can search for say create position. So, I'm going to select the create position web service."— Create Position 是 Workday 交付并设计好的,所以我用 web services 电子表格模板,在这里搜 create position,然后选中 create position 这个 web service。
"I can see the name, the system ID, the security configuration, the transformation type, create position, Workday web services operation, and then the Workday endpoint."— 我能看到名称、System ID、安全配置、transformation 类型 Create Position、Workday web services operation,以及 Workday endpoint。
"So, I'm going to have create position, edit organization assignment, request default compensation, assign pay group, and assign cost allocation. And every folder here is going to be a worksheet in our template model."— 我会有 create position、edit organization assignment、request default compensation、assign pay group、assign cost allocation;这里每个 folder 就是模板模型里的一张 worksheet。
"if I need to create a position in the supervisory organization, I would have the position request reason, the job posting title, number of position, availability date, earliest hire date. No job restrictions, and all this information."— 如果我在某个 supervisory organization 下建 position,会用到 position request reason、job posting title、number of position、availability date、earliest hire date、no job restrictions 等信息。
"I go to the related actions button, go to template model, and say generate spreadsheet template. I can have it in either XML format or XLS. I'm comfortable with XLS because I can open it in my Excel sheet."— 我点 Related Actions,进 Template Model,选 Generate Spreadsheet Template。可以出 XML 或 XLS;我用 XLS,因为能在 Excel 里打开。
"So, for now we are going to use create position and edit organization assignment only. So, let's look at the create position. Say I want to create 10 positions here. So, I can give my first position the spreadsheet key of one."— 现在我们只用 create position 和 edit organization assignment 两张。先看 create position:假设要建 10 个 position,我给第一条的 spreadsheet key 设成 1。
"Before I jump into the details, let's have a look at the EIB template structure. So, on the top row, you will see the name of the EIB. Then, on column A you have areas, restrictions, format, and fields."— 进细节之前先看 EIB 模板结构:顶行是 EIB 名称;A 列往下是 areas、restrictions、format、fields。
"everything that you put in here is available in the EIB. Whatever is possible to be put in the UI is also available in the EIB interface in these different sections under that create position spreadsheet."— 你在 UI 里填的每样东西 EIB 里都有——凡是 UI 能填的,在 create position 表下的各个 section 里也都能填。
"So here you can see create position, then position request, then staff new project. If I need to use understaffed or new position previously approved, new position requesting additional staff, and so on. So I'm going to use say staff new project."— 这里能看到 create position、然后 position request、staff new project;还可以用 understaffed、new position previously approved、new position requesting additional staff 等。我就用 staff new project。
"Remember, we had an option for critical job in our create position. Whether it's a critical job or not. Check box yes or no. Here we have this option as well. So, I can select yes or no because it's an optional. I do not need to compulsory fill it."— 记得我们建 position 时有个 critical job 选项,是不是关键岗位、勾 Yes 或 No;这里也有,因为是可选,所以不必强制填。
"Now, do keep in mind that the format is defined in the row four. So, here the format for availability date is equivalent to the format defined here. Year year year year {dash} month month {slash} {dash} day day."— 记住格式定义在第 4 行:availability date 的格式要和这里定义的一致,即年年年年-月月/日(YYYY-M-D)。
"So, here we have either the option of job family group ID or job family ID. As we use the job family, I'm going to select job family ID. Replace this field. And again, go to my reference IDs. Select job family."— 这里可以选 job family group ID 或 job family ID;因为我们用的是 job family,所以选 job family ID,替换这个字段,再回 reference IDs 选 job family。
"Now I'm going to see how many I need to create. Say I need two. So I need to create, say, 20 positions. And again in the same supervisory organization, same reason. Let's see my IDs here. So this is was 25, so I put it down, it'll add 26, 27, 28, 29, 30."— 现在看要建多少条,假设建 20 条 position,仍在同一个 supervisory organization、同一个 reason。这里起始是 25,往下拉就自动 26、27、28、29、30。
"And now I need the company reference ID, cost center, any regions that I may have assigned, any custom organization, any fund assignment, grant assignment, program assistance, business unit, or gift assignments."— 现在我还要 company reference ID、cost center、可分配的 region、custom organization、fund/grant/program assignment、business unit 或 gift assignment 等。
"Now, as I'm going to use these two spreadsheets to build my data or build my positions, so create position and edit organization assignment, I need to go to my overview tab. And I need to select the values for each of the spreadsheet, whether it's going to be automatic or manual processing."— 因为要用这两张表来建数据、建 position(create position 和 edit organization assignment),我要去 overview 标签,为每张表选处理方式:automatic 还是 manual。
"I can go to the value, create integration attachment, select the file. It's in my download. This one. It'll scan it for any viruses, if any. I press okay."— 我在该值里选 Create Integration Attachment,挑我下载目录里的那个文件;它会先扫描有无病毒,然后我点 Okay。
"So, whenever you're using an inbound integration, this option is always available to you, validate only. Not always, but it will not be available in case of custom objects, where you can't validate the data. But, the web services template, you should have this option for validate only load."— 用入站集成时一般都有 validate only 选项——不是绝对,Custom Object 就不能校验;但 web service 模板应该有 validate only,只校验不写库。
"Here I can see while it's doing this, we can see the process name, the request name, the status, processing time, the enterprise interface event, the integration process, which integration system is using, which is the event, was it initiated by, initiated as run as, then the any of the child processes that are happening within the background, execution summary, then the get data details, transformation details, delivery details."— 运行中能看到 process name、request name、status、处理时间、Enterprise Interface Event、集成过程、用的哪个集成系统、由谁发起、以谁身份运行,还有后台 child processes、execution summary,以及 get data、transformation、delivery 的详情。
"it's giving me an error for all the transactions, all the spreadsheet key, all the 20 of them. It is giving you one error, the employee is not a valid value for worker type ID. And if I understand XML, I can click on view details."— 它给所有交易、所有 spreadsheet key、20 条全都报同一个错:employee 不是 worker type ID 的有效值;如果看得懂 XML,可以点 View Details。
"So, here we say success validation mode only, all records successfully loaded. So, there are no errors, so I can relaunch it. I remove validation mode. And I press okay."— 这里显示 success、validation mode only,所有记录都校验通过了;没有错误,我就重跑一次,这次去掉 validation mode 再点 Okay。
"the business process security settings that the user must be part of the initiating web services group. And also the user would need to have access to the business object that is being used. So, the create position is part of the staffing functional area and you must be in one of these groups to be able to use that business object."— 业务流程安全要求:用户必须在发起 web services 的组里,且要有所用业务对象的访问权;create position 属 staffing 功能域,你必须在其列的某个组内才能用这个业务对象。
"So, limitations of EIB. So, inbound file size and document attachment limits. So, I think in one go, you can probably put about 15,000 rows of data into an EIB to be loaded into the system."— EIB 的限制:入站文件大小与文档附件上限——一次大概能往一条 EIB 里放约 15,000 行数据装载进系统。