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

Workday 开放注册全流程:发起、时间窗、事件规则与员工自助选择(ZaranTech 导师课)

Open Enrollment in Workday HCM | ZaranTech

频道:Workday Learner Community(ZaranTech) 时长 1:08:32 发布于 2024-08-15 26 帧对照 · 全片覆盖 原视频 ↗
⏱ 每节的 时间点 对应视频画面,点开原视频拖到该时间即可对照。
这一集的实际内容与标题相符:标题写 Open Enrollment,全片确实围绕开放注册(Open Enrollment,简称 OE)展开——发起、时间窗、事件规则、员工侧自助选择、关闭与定稿。结构上:约 0–8 分钟先讲开放注册的前置动作——如何在 Benefits worklet 里添加受抚养人(含重复受抚养人、删除 vs 停用的区别);8–19 分钟讲开放注册前的准备清单(新增供应商与集成、FSA/HSA 年度额度、发薪周期、福利组与资格审计报表)以及完整工作流;19–31 分钟讲时间窗与“事件规则”(开一次、关多次,协调福利 Coordination of Benefits,新员工/新生儿/婚姻会自动触发开放注册任务,eligible workers with no open enrollment 报表手动补人,终止则撤销任务);31–40 分钟在 GMS 租户实操 Initiate Open Enrollment,演示“同一有效日不可重复、生产环境只发起一次”的报错;41–57 分钟以员工 Teresa Serrano 走自助选择(开放注册新 UI 卡片、HDHP↔HSA 跨计划依赖、HSA 按发薪日供款与无法前置供款的坑、汇总与电子签名、查看未来生效);57–62 分钟关闭→定稿(FSA 自动弃权、管理员仍可改);62–68 分钟讲开放注册完成后向供应商投递数据(自定义报表 + 出向 EIB)。本片与已上线的 workday-benefits-notes.html(视频 WIV80wH1-30,福利模块第一课,讲福利组配置并演示过“关闭开放注册”)同属 Benefits 域的上下篇:第一课打基础、本讲聚焦开放注册本身的增量流程。画面来源多为讲师的 Google Sheet 备课表(标签页为 Prep for OE / Open Enrollment,内嵌决策流程图)与 Workday GMS 租户实操;演示账号为 Logan McNeil、Teresa Serrano 等。字幕为 YouTube 自动生成,术语误识别较多:benefit 常成 benit/benfit、integration 在表格里也写成 interation、eligible 成 eliglble、focal process(应指年度 merit/复核)、Teresa Serena 实为画面上的 Teresa Serrano、Logan McNeal 实为 Logan McNeil;正文统一用正确术语,quote_en 保留字幕原样不改写,请对照理解。凡与口播数字不一致处,以画面为准:口播“163 人已纳入”对应画面 Not Started 162 + Submitted 1(另有 On Hold 7、Total 170);口播 HSA 上限“7,000”而画面 Maximum Annual Amount 显示 $7,100;发起时报错弹窗文字未截入画面,按口播记为(待核对)。个别表格单元格被裁切,如 Run the Benefit Group Audit (to ma… group)(待核对)。
0:20

开场:开放注册状态报表

开场:开放注册状态报表
  • 画面落在 Workday 的 Open Enrollment Status Report(搜索框输入 open enroll),顶部蓝色标题条,右侧有导出/打印图标。
  • Currently Active Events 显示 0 items / No Data;列名含 Enrollment Event Type、Benefit Group、Started、End、Effective Date、Not Started、In Progress、Submitted、On Hold、Closed with Changes、Finalized with Changes、Canceled、Rescind。
  • Completed Events 有 77 items:Open Enrollment 分别对 Active Employees in U.S. - Hourly(Finalized with No Changes 11、Total 11)、- Salaried(170)、Retirees in U.S.(1),每行有 View Details。
  • 讲师口述本集主线是开放注册的“发起—维护—关闭”,并提醒 OE 本身工作量不大、准备工作才是重头。

"main thing among among them is going to be the open enrollment, initiating it, maintaining it, and then closing it."— 重点就是开放注册:怎么发起、怎么维护、然后怎么关闭。

2:40

先演示:以员工身份进 Benefits

先演示:以员工身份进 Benefits
  • 画面是员工主页:欢迎语 Welcome, Logan McNeil,左下 Announcements(5 items),右下 Applications(20 items,可见 Compensation Review、Compensation Dashboard、Compensation、Diversity、Performance、Favorites)。
  • 讲师说明:先假装 Logan 是普通员工而非 HR 管理员,从 Benefits worklet 点进 Dependents,再点 Add a dependent。
  • 添加受抚养人是全年随时可做的动作(孩子出生、结婚等事件触发),不是只在开放注册期间。

"I want to make sure that I show to you guys how to add dependents. So, I'm going to pretend uh, Logan is a normal, uh, employee, not an HR administrator."— 我先演示一下怎么添加受抚养人,假装 Logan 是普通员工、不是 HR 管理员。

4:20

添加受抚养人:资格字段

添加受抚养人:资格字段
  • 表单下方字段:Student Status Start Date(empty)、Student Status End Date(empty)、Relationship*(empty)、Is this a person with a disability?(Disabled:No)、Tobacco Use(Does this person use tobacco? was No / Answer*)。
  • “是否全日制学生”是 Workday 交付的标准题,Obamacare 之后 26 岁以下即符合条件、已无意义,但企业无法删除此题。
  • 残疾标记很关键:若选 No,孩子满 26 岁后系统会按被动事件(passive event)自动把他移出福利,除非另设通知。
  • 关系(Relationship)可选 child、spouse 等。

"Is this a full-time student? Uh, this used to be a standard question. Unfortunately, it's still in Workday, but um, with Obamacare is no longer relevant. Anybody under 26, they're eligible for benefits."— “是否全日制学生”是 Workday 交付的老题,Obamacare 之后已不适用,26 岁以下本来就符合条件。

5:20

受抚养人:生效日与重复陷阱

受抚养人:生效日与重复陷阱
  • Add My Dependent 表单(Logan McNeil / Actions)顶部:Dependent Options 里有 Effective Date*(示例 03/03/2020)、Reason,以及“Use your new dependent as a beneficiary?”;底部 Save for Later / Cancel。
  • 若新孩子是新生儿,生效日期就用出生日期;勾成受益人(beneficiary)后,此人会出现在开放注册页可被选为受益人。
  • 常见坑:员工在开放注册时又点 Add a dependent,会造出重复档案——一份已选保、一份未选保,做集成数据时要排除重复受抚养人。
  • 删除 vs 停用:没选任何福利的可直接 delete;已选福利的要先移除福利选择(election)再 inactivate/deactivate。

"they will end up with duplicate dependent who is the same person, but one profile of the dependent would be the one that's enrolled in benefits, and another one would not be."— 会出现重复的受抚养人,同一人两个档案,一个已入保、一个没入保。

8:50

准备清单:新供应商必带集成

准备清单:新供应商必带集成
  • 画面是讲师的 Google Sheet 备课表(标签页 Prep for OE / Open Enrollment):New Provider → Will need integration(表格里拼成 interation);Update Benefit Plans for Plan Year → Any new or changes? FSA/HSA Amounts may have changed;Update Benefit Plan Definition;Update Pay Period Schedules for FSA and HSA Plans。
  • 下方 Update/Review Benefit Eligibility Rules 列出:Benefit Group、Benefit Plan、Dependent Eligibility、Passive Event Rules、Run Eligibility Rules Audit、Run View Eligibility Rules Results、Run the Benefit Group Audit(单元格被截断,待核对)。
  • 关键点:新增一个福利供应商(provider),Workday 不会自动把数据流过去,必须另外搭集成(EIB 或 Cloud Connect)。
  • 搭集成还要先备好福利计划并做几笔入保才能取样例数据,所以从零到能投递通常要预留两三周。

"just because you add a new provider, it's not going to automatically flow there. You'll need to build some type of, um, integration, whether it's going to be EIB or it's going to be Cloud Connect"— 光加一个新供应商数据不会自动流过去,你得建一种集成,EIB 或 Cloud Connect。

15:20

发起指引:福利组与等待期

发起指引:福利组与等待期
  • 备课表里的 Initiate Open Enrollment 文本框(被选中放大)写明:Select all benefit groups that need to be included。
  • Select the “Exclude Employees with Waiting Periods” check box to suppress Open Enrollment events for new hires whose benefit coverage does not take effect until after the plan year begin date。
  • NOTE:该复选框只排除“所有福利类型都在等待期内”的新员工;美国通常就勾一个或两个组(如 all US employees,或 US salaried + US hourly)。
  • Complete enrollments(typical employee does via self-service, and can make changes until OE is closed)——员工自助完成、关闭前可反复改。

"there's one checkbox that says exclude employees with waiting periods. This is if you want to exclude any new hires."— 有一个叫“排除有等待期的员工”的复选框,用来排除新员工。

19:00

工作流:发起→提交→关闭→定稿

工作流:发起→提交→关闭→定稿
  • 备课表内嵌决策流程图:Initiate Open Enrollment Active EE's in U.S. - Salaried → Change Benefit tasks created →(判定)Elections entered and submitted。
  • 判定为 Yes → Change Open Enrollment task → Close Open Enrollment → All Change Benefit tasks removed → Finalize Open。
  • 判定为 No → Change Benefit task available → Reminder emails sent to selected status(回到提交判定,形成催办闭环)。
  • 口述:关闭时所有 change benefit task 被移除,随后 finalize;生产环境一年只发起一次,必须先在 sandbox/preview 测透。

"when you close it, all the benefit all the change benefit tasks are removed, and then you finalize open enrollment."— 关闭时所有的变更福利任务会被移除,然后再定稿开放注册。

21:20

时间窗:11月两周、事件日期1/1

时间窗:11月两周、事件日期1/1
  • 备课表右侧 Open Enrollment 示例日期:Initiate Date Oct 30th / Start Date Nov 1st / End Date Nov 15th / Event Date Jan 1st of next year。
  • 单元格备注:Run Open Enrollment Only Once in Production;Manually reprocess Open Enrollment in case a child is born after Open Enrollment but before beginning of New Year。
  • 另有 Monitor the Workers with Enrollment Events on Hold report,Close and Finalize, but keep Monitoring for any newly eligible events。
  • 时间窗一般约两周(11/1–11/15),新计划年度生效日常取次年 1/1。

"you initiated this on October 30th and you say start date November 1st and end date November 15th for the open enrollment period and then you put January 1st as the event date."— 10月30日发起,开放注册期设 11月1日到11月15日,事件日期设 1月1日。

26:20

事件规则:开一次、关多次

事件规则:开一次、关多次
  • 备课表场景:New Hire Starting Nov 20th / He needs Benefit Coverage 20th / He also needs to be part of Open Enrollment / They have already Closed Open Enrollment。
  • 协调福利(Coordination of Benefits):Someone has a child in Nov or Dec → WD will auto Open Enrollment Task for him,Keep monitoring the Status reports,Assist the employee ... and THEN CLOSE OE。
  • 结论:开放注册只开一次,但要关很多次——因为新生儿、新员工可能在关闭后又触发任务。
  • 典型:孩子 12/25 出生、员工 1 月才进系统录入,会再生成一个开放注册任务,需再次关闭并定稿。

"you will open it once but you will close it many times."— 你只会开一次,但要关很多次。

29:50

补人与终止:状态报表监控

补人与终止:状态报表监控
  • 备课表:Open Enrollment Status Report → View Details>Actions>Close Open Enrollment → Click OK。
  • Employee can become eligible after OE has started and POSSIBLY after it has closed → System will automatically create an OE for them。
  • Coordination of Events:New Hire, Marriage or Child Event first and Then Open Enrollment;可运行 Eligible Workers with no Open Enrollment report,查看列表后点 ADD Workers 任务为其补建开放注册事件。
  • 反向:Workers no longer eligible(因事件或 termination 失去资格),系统会按协调事件自动移除其福利与任务。

"You can create the event sooner by running the eligible workers with no open enrollment report."— 可以运行“没有开放注册的合格员工”报表,尽早给他们建事件。

32:30

实操发起:Initiate Open Enrollment

实操发起:Initiate Open Enrollment
  • GMS 租户里搜索 init open enroll 打开 Initiate Open Enrollment 任务,Details 表单字段:Benefit Groups*、Event Type*、Initiated On、Open Until*、Event Date*。
  • 页顶 NOTE(系统交付):发起前先跑 Benefit Group Audit report,确认没有员工同时符合两个福利组;若用 Spending Account / HSA,务必把发薪周期按整个福利计划年、按相关 Pay Group 配齐。
  • 表单底部有 Exclude Employees with Waiting Periods 复选框与 Cancel 按钮。

"Before initiating open enrollment, you should run the benefit group audit report to make sure your employees are not eligible for more than one benefit group."— 发起开放注册前,应先跑福利组审计报表,确保没人符合两个以上福利组。

34:30

选组与事件类型

选组与事件类型
  • 表单已填:Benefit Groups 选 Active Employees in U.S. - Salaried 与 Active Employees in U.S. - Hourly 两个;Event Type 选 Open Enrollment。
  • Open Until* 与 Event Date* 用日历选择器;Exclude Employees with Waiting Periods 未勾选。
  • Plan Year Definition 下拉展开:Australia / Canada / China-Hong Kong / France / Germany Benefit Program,另有 More (11)——即按国家/地区的福利计划年定义。
  • 注意表单只有 Open Until(开放截止日),没有单独的 Start Date:发起即开、到 Open Until 关闭。

"we're going to select the salaried US benefit group and hourly US benefit group. Event type is open enrollment."— 我们选 US 计时和 US 计薪两个福利组,事件类型是 Open Enrollment。

36:40

报错:有效日不可重复

报错:有效日不可重复
  • 发起后进入 Open Enrollment Processing:Initiate Open Enrollment Job 状态 Initiated,Submitted 03/03/2020 18:25,百分比进度条 + Refresh;上方 Effective Date 05/01/2020,Exclude Employees with Waiting Periods No,各状态计数(Closed/Finalized/Canceled/Rescinded/Total)暂为 0。
  • 此前触发过报错:同一时间段内该福利组已发起过开放注册,需先取消前一次。
  • 有效日期不能重复:先前试过 04/01 冲突,改 05/01;这正是“生产环境只能发起一次”的原因——若 1/1 用错,无法再选同一天。
  • 计数全 0 是因为任务仍在处理,点 Refresh 刷新。

"we cannot have multiple ones with the same uh effective date. So, previously I selected 4 1, I have to select it 5 1."— 同一有效日不能有多次;之前选了 4/1,就得改成 5/1。

39:10

纳入人数与挂起名单

纳入人数与挂起名单
  • 在报表上点 View Details 弹出每个员工的入保清单:Change Adam Carlton (On Leave) on 03/31/2020、Adrian Martin on 05/01/2020、Aidan Mitzner、Alex Grossman、Allison Hunter… 每人右侧一个 Change Benefits for Op… 按钮,左侧可按姓名过滤(输入 mcnail)。
  • 口述本次共 163 人被纳入开放注册;每人会在收件箱收到一条开放注册事项(明细计数在后续状态报表里查看)。
  • 右侧 Employee Enrollment Counts 面板可见 03/31/2020 行 On Hold 4:这些员工有正在进行的福利事件冲突,需福利管理员先取消或完成其现有 change。
  • 讲师因不能代理(proxy)他人登录,无法亲自替员工完成这笔开放注册入保。

"the people on hold, they have some kind of conflicting enrollment already that needs to be canceled."— 挂起的人是有冲突的入保正在进行,得先取消掉。

42:20

员工自助:健康问卷起始

员工自助:健康问卷起始
  • 以 Teresa Serrano 视角进入自助开放注册,画面是 Health Questionnaire → Health Information 下的 Tobacco Use 问题(涉及过去 12 个月是否使用烟草)。
  • 口述:Teresa 在收件箱收到一条 Change Benefits for Open Enrollment 事项,显示时间窗和一个 Let's get started 按钮,点进来先过问卷。
  • 记录使用(record use)等问题很多公司并未启用、不配置;启用时会出现在此流程里。

"she got a item in her inbox that says change benefits for open enrollment and it shows the time frame and then the let's get started button."— 她收件箱收到一条“为开放注册变更福利”的事项,显示时间范围,然后有 Let's get started 按钮。

43:30

开放注册新 UI:Medical 卡片

开放注册新 UI:Medical 卡片
  • Medical 卡片(Plans Available):Aetna HDHP (High Deductible Health Plan) $83.00/月、Aetna HMO 等,每行 Selection/Benefit Plan/You Pay/Company 列;顶部显示 Projected Total Cost Per Paycheck $485.00、Projected Total Credits $55.00。
  • 提示:Select a plan or Waive to opt out of Medical;waived plans 展示成本按 EE + 1 Dependent 假设。
  • Important Information 直接写明跨计划依赖:选 Medical - Aetna HDHP 才能选 Health Savings Account - OptumHealth Bank;若放弃 HDHP,Workday 会自动放弃 HSA。
  • 这是去年年底才上线的新版开放注册界面,能看到当前保障、覆盖对象与每次薪水成本,点 Manage 可改。

"the medical dental plans and these are called cards."— 医疗、牙科这些计划,在这里是以卡片(cards)形式呈现。

45:30

HSA 被跨计划依赖挡住

HSA 被跨计划依赖挡住
  • Health Savings Account 卡片:Plans Available 仅 OptumHealth Bank,当前 Selection 停在 Waive;Projected Total Cost Per Paycheck $458.00。
  • Instructions 明确:You can select either of the following plans, but not both: Healthcare FSA - SHPS or Health Savings Account - OptumHealth Bank;且必须先选 HDHP 才能选 HSA(General Instructions 也写了 must first elect a HDHP)。
  • 因为前面只选了 HMO(没选高免赔额),此处 HSA 无法勾选——而且没有报错提示,只能靠说明文字判断,是一个刻意设计的跨计划依赖测试。
  • 正确做法:退回 Medical 改选 Aetna HDHP,回来才能勾 HSA。

"we see that we cannot select it. And there's no error message either."— 我们看到它选不了,而且也没有任何报错提示。

49:10

HSA 供款:计算与前置供款之坑

HSA 供款:计算与前置供款之坑
  • 改选 HDHP 后进入 Health Savings Account - OptumHealth Bank:Contribute Per Paycheck 填 100.00 → Annual 自动算出 800.00,Remaining Paychecks 8,Total Annual HSA Contribution $800.00,Maximum Annual Amount $7,100.00;Projected Total Cost Per Paycheck $343.00。
  • Workday 用“每次发薪额 × 剩余发薪次数”推算年度合计,所以填的是每个发薪日的供款额。
  • 但法律允许前置供款(front load):比如 1、2 月按最大额扣、之后归零——Workday 没有地方能表达“只在 1、2 月扣”,填 4000 会被当成每个发薪日都扣 4000 而超限报错。
  • 唯一变通:把 Maximum Annual 上限设得很高(如 10 万),让管理员盯大额、再提醒员工下月改零。

"there's no place in Workday to indicate that that this is only for January and February."— Workday 里没有地方能标明这笔钱只用于一月和二月。

52:40

汇总页与电子签名

汇总页与电子签名
  • 开放注册末尾的汇总页:按 Plan/Date/Date/Coverage/Dependents/Beneficiaries 列出已选计划,如 Voluntary Supplemental Life Liberty Mutual(Employee)$350,000、受益人 Pablo Serrano、$196.00;Short Term Disability 75% of Salary(Included)、Long Term Disability 60% of Salary、Voluntary AD&D $50,000 $2.00。
  • 下方 Waived Benefits(3 items)列出被弃权的计划(如 Healthcare FSA → Waived);底部 Save for Later / Cancel。
  • 汇总页无需单独配置,含覆盖信息、弃权计划、公司/员工成本与 credits;列名不可改。
  • 流程最后一步是电子签名——它在建福利时最早定义、却排在提交清单最后一项,员工点 Accept 再 Submit。

"the very last step is the electronic signature."— 最后一步是电子签名。

54:20

从资料页看未来生效的福利

从资料页看未来生效的福利
  • Teresa Serrano(Controller)资料页顶部标签 Benefits / Employee Benefit Credits / My Benefit Election History;左栏 Actions 菜单展开:View My Benefit Election History、View My Beneficiaries、View Dependents、Change Retirement Savings、View Current Retirement Savings Elections、Change My Medicare Data、View My Benefit Statement、Change 1095-C Printing Election 等。
  • 资料页 Benefits 图标里看到的是“当前生效”的入保;要看刚提交、未来才生效的那笔,要走 Actions → Benefits → View Benefit Election History。
  • 口述:刚做的这笔生效日是 5/1(示例中为 2020-05-01),点进去能看到她提交时选的高免赔额计划等明细。

"If you want to see the future ones, you go to actions benefits and then view benefit election history."— 想看未来生效的,就走 Actions → Benefits → 查看福利选择历史。

56:10

View Election Package:入保档案明细

View Election Package:入保档案明细
  • 点开进入 View Election Package:Teresa Serrano Benefit Elections Active on 05/01/2020(带 Actions)。
  • 字段逐项可见:Benefit Event Type = Open Enrollment;Offering Types Available for Event = 14;Benefit Group = Active Employees in U.S. - Salaried;Event Date 05/01/2020;Initiated On 03/03/2020;Submit Elections By 03/31/2020;Last Changed 03/03/2020 09:44。
  • Electronic Signature Signed By = Teresa Serrano,Electronic Signature Date = 03/03/2020,状态 Successfully Completed——印证电子签名确随这笔开放注册入保留痕。
  • 口述在此转向监控:从这里回看开放注册状态报表跟进各人提交情况。

"So remember I said keep monitoring the status reports. So this is where you're monitoring from."— 记得我一直强调要盯状态报表,就是从这些界面监控。

58:40

关闭前:员工入保计数

关闭前:员工入保计数
  • 事件页标题:Open Enrollment for Active Employees in U.S. - Salaried for Open Enrollment on 05/01/2020。
  • Event Details:Enrollment Event Type Open Enrollment、Benefit Group Active Employees in U.S. - Salaried、Start 03/03/2020、End 03/31/2020、Effective Date 05/01/2020、Exclude Employees with Waiting Periods No。
  • Employee Enrollment Counts:Not Started 162、In Progress 0、Submitted 1、On Hold 7、各 Closed/Finalized/Canceled/Rescinded 0、Total 170。
  • 关闭前要确保无人挂起、人人已提交、无人进行中,先发一次最终提醒(若通知未配好就直接用 Outlook 群发),再 Close Open Enrollment。

"you want to make sure that no one's on hold, everybody has submitted, no one's in progress. And then you could close it."— 你要确保没人挂起、所有人都已提交、没人还在进行中,然后才能关闭。

1:00:40

关闭后必须定稿(FSA 自动弃权)

关闭后必须定稿(FSA 自动弃权)
  • Open Enrollment Processing(3 items):Initiate Open Enrollment Job Completed 18:27、Close Open Enrollment Job Completed 18:58、Finalize Open Enrollment Job Processing 19:00——关闭只是倒数第二步,最后必须 Finalize。
  • 计数变化印证:Closed with No Changes 已升到 162、Total 170,Finalized 列在定稿完成后才会回填。
  • 计划默认沿用上期选择,唯独 FSA 例外:开放注册时 FSA 会被自动弃权,除非员工主动重新选。
  • 定稿后员工不能再改,但福利管理员仍可继续修正;这条“关闭要一直复查到 1 月底”的动作要写进日历每周检查。

"On the FSA plan, you actually set it that uh it will automatically get waived at open enrollment unless you actually sign up for it."— FSA 计划是设成开放注册时自动弃权,除非你主动去报。

1:02:50

投递数据:自定义报表 UHC

投递数据:自定义报表 UHC
  • 开放注册完成后要把数据发给供应商。画面 Edit Custom Report - UHC Enrollment:Report Type Advanced、Data Source All Workers、Data Source Type Standard、Primary Business Object Worker、Report Definition Usages 2。
  • Columns 页 33 items,列含 Business Object、Field、Column Heading Override、Column Heading Override XML Alias、Format、Options;另有 Sort/Filter/Subfilter/Prompts/Output/Share/Advanced 页签。
  • 做法是把供应商要求的 CSV 字段照排成一张自定义报表,再包进出向 EIB(配 SFTP)投递,省掉专门开发集成的时间与费用。
  • 像年基本工资这类字段可能要做成计算字段,只为满足格式要求。

"So custom report um it's running off the data source all workers and this is for United Healthcare."— 这张自定义报表的数据源是 All Workers,是给 United Healthcare 用的。

1:04:30

子过滤:按计划在保且排除终止

子过滤:按计划在保且排除终止
  • Sub Level Filter:Business Object 选 Benefit Elections,共 3 条条件。
  • 条件 1:Field Benefit Plan,Operator in the selection list,值为 Medical - UHC EPO、Medical - UHC PPO 150、Medical - UHC PPO 250、Medical - UHC PPO High Deductible Plan——即只取这批 UHC 医疗计划的数据。
  • 条件 2:Field Benefit Elections - Currently Enrolled as of Report Effective Date,Operator equal to,勾选 true;条件 3:Enrollment Type,none in the selection list = Termination(排除终止入保)。
  • 整体过滤思路:员工在保且未终止、且有福利选择记录,就按这些计划范围取数。

"for the sub filter it's basically indicate uh the name of the plans that it should be pulling the data from."— 子过滤基本就是指定它要从哪些计划里取数据。

1:06:40

Prompts:用“截至生效日”跑

Prompts:用“截至生效日”跑
  • 报表编辑切到 Prompts 页:Runtime Date Prompts 里 Effective Date = Prompt for effective as of date,Entry Date = Use date and time at runtime;另有 Prompt Instructions、Populate Undefined Prompt Defaults、Display Prompt Values in Subtitle。
  • 全年平时运行:每次运行用运行日期作生效日、每两周或按公司节奏跑一次投递。
  • 开放注册期间:在 12 月运行同一张报表,但把 As-of Effective Date 设成次年 1/1,这样取到的是即将生效的开放注册结果。
  • Guardian Dental 用的是同一张报表的“几乎原样副本”,只把医疗计划换成 Guardian 计划(大约只差一列),复用度很高。

"you're going to run it in December because the vendors they want the data like beginning of December."— 要在 12 月跑,因为供应商希望十二月初就拿到数据。