> 持续流程改进 > 招聘与人才获取 > Oracle HCM Recruiting > 数据模板

您的招聘与人才获取数据模板

Oracle HCM Recruiting

← 返回改进指南

招聘与人才获取属性 (18) 招聘与人才获取活动 (14) 提取指南 (2)

您的招聘与人才获取数据模板

此模板全面介绍如何收集优化招聘与人才获取流程所需的数据，包括必要的数据属性、需要跟踪的关键活动，以及从源系统提取这些信息的实用指南。使用此资源，确保数据准备阶段顺利高效。

建议收集的属性，支持全面分析
需要跟踪的关键流程活动和里程碑
从您的系统提取数据的指南

刚接触事件日志？了解如何创建流程挖掘事件日志.

下载模板

招聘与人才获取属性

建议在事件日志中包含以下数据字段，以便全面分析招聘与人才获取流程。

5 必需 5 建议 8 可选

	名称	说明
	开始时间 EventTime	表示招聘活动开始时间的时间戳。
说明此属性记录具体活动发生的准确日期和时间，为每个职位申请案例中的事件排序提供时间依据。开始时间是所有基于时间的流程挖掘分析的关键。它用于计算活动之间的周期时间、识别延误、衡量整体招聘周期，并检查服务级别协议或绩效目标的遵循情况。为什么重要它提供事件的时间顺序，对于计算时长、发现瓶颈和分析流程绩效至关重要。获取位置此时间戳通常与活动名称一起出现在Oracle HCM Recruiting的事件日志或状态历史表中。示例 2023-10-01T10:00:00Z2023-10-05T14:30:00Z2023-11-12T09:15:00Z
	活动 ActivityName	已发生的具体招聘活动或事件的名称。
说明此属性描述招聘流程中的单个步骤或里程碑，例如“Application Screened”“Interview Conducted”或“Offer Extended”。每项活动都代表申请生命周期中的一个独立事件。它是流程挖掘的基础组成部分，用于定义流程图中的节点。分析活动的顺序和频率，有助于识别常见流程路径、瓶颈、偏离标准流程的情况以及返工循环。为什么重要此属性定义招聘流程中的步骤，是构建流程图、分析流程和流程变体的基础。获取位置通常取自Oracle HCM Recruiting中与职位申请对象相关的事件表或状态历史表。示例申请已筛选面试已完成已发放录用通知候选人已录用
	职位申请 JobApplicationId	每份候选人职位申请的唯一标识符。
说明职位申请ID是跟踪候选人在特定职位需求中完整历程的主键。它将从初次提交到最终录用决策的所有相关活动关联起来，形成一个完整、连贯的流程实例。在流程挖掘中，此属性对于定义案例至关重要，可用于重建每位候选人的独特路径。分析人员可以利用它可视化端到端申请流程、衡量整体周期时间，并分析招聘漏斗不同阶段之间的转化率。为什么重要它可以唯一标识每个招聘案例，从而追踪候选人申请从开始到结束的完整生命周期。获取位置这是Oracle HCM Recruiting模块中的主要标识符，通常与候选人提交记录关联。示例 APP-2024-00123APP-2024-00124APP-2024-00125
	最近数据更新时间 LastDataUpdate	数据最近一次从源系统刷新或提取的时间戳。
说明此属性表示最近一次数据提取的日期和时间，说明当前分析所用数据的新鲜度。这有助于用户了解流程分析的时效性，并合理预期近期活动的可见程度。它是任何仪表板或报告的重要元数据。为什么重要告知用户数据的时效性，帮助其了解分析覆盖的时间范围。获取位置此时间戳在数据提取、转换和加载（ETL）过程中生成并添加。示例 2024-05-20T08:00:00Z2024-05-21T08:00:00Z
	源系统 SourceSystem	数据来源的系统。
说明此属性标识记录招聘数据的源信息系统。对于此流程，通常为“Oracle HCM Recruiting”。在包含多个系统的环境中，该字段对于数据血缘和问题排查至关重要。它有助于确认数据来自预期来源，也可用于筛选特定平台的数据进行分析。为什么重要标识数据来源，对于数据治理、验证以及确保分析基于正确的信息来源至关重要。获取位置通常是在数据提取、转换和加载（ETL）过程中添加的静态值，用于标记数据集。示例 Oracle HCM RecruitingOracle Fusion Cloud HCM
	招聘人员 Recruiter	负责管理职位申请的招聘人员姓名或ID。
说明此属性标识负责该申请的人才获取专业人员，通常由其引导候选人完成整个流程。按招聘人员分析流程，有助于平衡工作量、开展绩效对标并识别最佳实践。您可以了解哪些招聘人员的周期时间最短或录用通知接受率最高，从而支持招聘人员工作量与效率仪表板。为什么重要将活动归属到具体人员，以便分析招聘人员的工作量、效率和绩效。获取位置与Oracle HCM Recruiting中的职位申请或职位需求对象关联。示例 John SmithJane DoeEmily Jones
	招聘经理 HiringManager	相关职位需求的招聘经理姓名或ID。
说明此属性标识有空缺职位的团队或部门经理。招聘经理是关键利益相关者，通常参与筛选、面试和最终录用决策。按招聘经理分析流程绩效，可以发现与其面试时间安排或反馈提交延迟相关的瓶颈。这有助于识别培训或流程改进机会，帮助经理更高效地履行招聘职责。为什么重要标识流程中的关键利益相关者，以便分析招聘经理参与所带来的延误或效率。获取位置存储在Oracle HCM Recruiting的职位需求对象中，并与职位申请关联。示例 Robert BrownSusan WhiteMichael Green
	申请来源 ApplicationSource	收到申请的渠道或来源。
说明此属性跟踪候选人发现职位空缺的渠道，例如“LinkedIn”“Company Website”“Employee Referral”或“Job Board”。它是申请来源效果仪表板的关键数据，可帮助组织衡量不同招聘渠道的投资回报。通过分析哪些来源带来的录用人数最多或招聘周期最短，人才获取团队可以优化招聘来源策略。为什么重要帮助确定吸引和录用合格候选人的最有效渠道，优化招聘营销投入。获取位置候选人在Oracle HCM Recruiting中提交申请时，系统通常会记录此信息。示例 LinkedIn员工推荐公司招聘页面Indeed
	申请状态 ApplicationStatus	职位申请当前或最终状态。
说明此属性表示申请的处理状态，例如“Active”“Hired”“Rejected”或“Withdrawn”。它反映申请在流程中的当前进展或最终结果。分析最终状态是计算录用率和流失率等关键指标的基础。通过显示成功到达最终阶段的候选人数，它有助于了解招聘漏斗的整体效果。为什么重要提供招聘流程的结果，对于计算转化率、录用率和流失率至关重要。获取位置 Oracle HCM Recruiting主职位申请记录中的标准字段。示例已录用已拒绝候选人撤回申请录用通知已接受
	部门 Department	招聘候选人所在的部门或业务单元。
说明此属性指定拥有空缺职位的组织单元，例如“Engineering”“Sales”或“Marketing”，为每份职位申请提供组织背景。按部门细分招聘流程对于绩效对标至关重要。管理层可以比较组织不同部门的招聘周期、流失率和其他关键指标，这也是部门招聘绩效对标仪表板所需的分析。为什么重要支持比较不同业务单元或部门的招聘绩效和流程差异。获取位置通常属于Oracle HCM Recruiting中与申请关联的职位需求数据。示例工程销售财务人力资源
	录用金额 OfferAmount	向候选人发出的录用通知中包含的薪资金额。
说明此属性记录职位拟提供的薪酬，是招聘流程最后阶段的重要信息。尽管属于敏感数据，分析录用金额仍可帮助了解薪酬竞争力。将其与录用接受率关联，可以判断薪酬是否导致候选人拒绝录用；同时也可用于确保不同部门和职位之间的薪酬公平。为什么重要支持分析薪酬趋势及其对录用接受率的影响，帮助制定更具竞争力的招聘策略。获取位置位于Oracle HCM Recruiting申请的录用通知详情部分。示例 8500012000065000
	拒绝原因 RejectionReason	候选人申请被拒绝的原因。
说明当申请状态变更为“Rejected”时，此属性提供相关背景。原因可能包括“不符合文化要求”“缺少所需技能”或“已录用其他候选人”。分析流程不同阶段的拒绝原因，可以获得重要反馈。它有助于发现职位描述、预期匹配或筛选流程中的问题，从而优化招聘策略并提升候选人池质量。为什么重要帮助了解候选人未能继续推进的原因，对于改进职位描述、筛选标准和整体流程效果至关重要。获取位置招聘人员或招聘经理在Oracle HCM Recruiting中拒绝候选人时，通常会在专用字段或备注区域记录。示例不符合最低任职资格已选择更合适的候选人薪酬期望不匹配
	招聘周期目标 TimeToHireTarget	完成职位申请所需的目标时长，以天为单位。
说明此属性定义完成招聘流程的预期时限，从职位申请创建到候选人接受录用通知为止。该目标通常根据职位级别或部门标准设定。它是“招聘周期目标达成率”KPI的基础。将实际招聘周期与目标进行比较，组织可以衡量招聘绩效是否符合战略目标，并主动识别可能超期的职位申请。为什么重要为衡量实际招聘周期绩效提供基准，直接支持目标达成率KPI的计算。获取位置可能是Oracle HCM Recruiting职位申请对象中的字段，也可能在单独的系统中维护。示例 30456090
	是否为内部候选人 IsInternalCandidate	用于标明候选人是否为现有员工的标志。
说明此布尔属性用于区分内部候选人和外部候选人。内部候选人是现有员工，外部候选人则不是。内部招聘和外部招聘通常具有不同的步骤、SLA和成功率。分析此属性可以比较内部人才流动与外部招聘流程，帮助判断企业是否有效开展内部晋升，以及内部招聘流程是否比外部招聘更高效。为什么重要区分内部候选人和外部候选人。两者的招聘路径和绩效指标通常存在显著差异，从而支持更准确的分组分析。获取位置通常作为Oracle HCM Recruiting中候选人或申请档案上的标志。示例 truefalse
	是否返工 IsRework	用于标明某项活动是否正在第二次或后续重复执行的标志。
说明此计算属性用于识别同一案例中重复执行某项活动的情况。例如，申请从“面试”退回“筛选”，之后又回到“面试”时，第二次执行的“筛选”和“面试”会被标记为返工。分析返工是发现流程低效和隐性成本的关键。它可以定位流程失效、导致步骤重复的环节，并通过量化此类循环的频率和影响，直接支持“申请返工与瓶颈分析”仪表板。为什么重要识别重复执行工作的流程低效和循环，帮助发现隐性成本及流程精简机会。获取位置在数据准备阶段计算，检查指定CaseId对应的案例中是否已发生相同活动。示例 truefalse
	结束时间 EventEndTime	表示招聘活动完成时间的时间戳。
说明结束时间标志着活动完成。开始时间与结束时间之间的差值代表单项活动的处理时间。在流程挖掘中，它用于计算具体任务的持续时间，例如筛选申请或进行面试所需的时间。分析活动时长有助于识别整体流程中最耗时的具体步骤。为什么重要支持计算单项活动的持续时间，对于定位低效步骤和衡量任务级绩效至关重要。获取位置可能存在于事件日志表中，也可以根据后续活动的开始时间推导。示例 2023-10-01T10:30:00Z2023-10-05T15:00:00Z2023-11-12T11:15:00Z
	职位地点 JobLocation	职位所在的地理位置或办公地点。
说明此属性用于指定与职位申请相关的城市、州或国家，也可标明职位是否支持远程办公。此维度支持对招聘流程进行区域分析，帮助回答不同地点的招聘周期是否存在显著差异，或某些地区的候选人流失率是否更高。这些信息有助于针对不同劳动力市场制定招聘策略。为什么重要支持对招聘指标进行地理分析，帮助识别不同地区在招聘绩效和挑战方面的差异。获取位置存储在Oracle HCM Recruiting的职位申请对象中。示例纽约，纽约州伦敦，英国远程旧金山，加利福尼亚州
	职位需求ID JobRequisitionId	候选人申请的职位空缺的唯一标识符。
说明职位需求ID将多份职位申请关联到同一个已批准的职位空缺，代表招聘流程中的需求侧。此属性对于汇总申请数据、分析特定招聘工作的整体状况至关重要。您可以据此分析某个职位的候选人管道数量、该职位的招聘来源效果，以及填补职位所需的总时间。为什么重要汇总同一职位空缺的所有申请，从而分析特定职位的完整人才管道。获取位置这是职位需求对象的主键，并与Oracle HCM Recruiting中的每份申请关联。示例 REQ-2024-501REQ-2024-502REQ-2024-503

必需建议可选

招聘与人才获取活动

应在事件日志中记录以下关键流程步骤和里程碑，以准确发现流程并识别瓶颈。

6 建议 8 可选

	活动	说明
	候选人已录用	表示招聘流程最终成功结束。候选人状态正式变更为“Hired”时触发此事件，并将流程移交核心HR。
为什么重要这是流程的主要成功结果，也是计算招聘周期和其他关键效率指标的终点。获取位置这是IRC_SUBMISSIONS中职位申请记录的关键状态变更，由Oracle Recruiting中的“Hire”或“Move to HR”操作触发。采集招聘人员执行最终“Hire”操作时记录。事件类型 explicit
	已发放录用通知	标志着正式向候选人发放职位录用通知。招聘人员通过Oracle Recruiting系统正式发送录用通知时，会明确记录此事件。
为什么重要这是衡量录用通知接受率，以及计算最终面试到发放录用通知之间时长的关键里程碑，也是候选人体验的重要环节。获取位置职位录用通知状态变更为“Extended”或“Sent”时明确记录。该操作的时间戳保存在录用通知对象中。采集招聘人员执行“Extend Offer”操作时记录。事件类型 explicit
	录用通知已接受	表示候选人已正式接受职位录用通知。候选人通过招聘门户接受，或招聘人员手动更新状态时，系统会记录此事件。
为什么重要这是流程中的主要成功里程碑，是计算录用通知接受率的基础，也标志着录用后活动的开始。获取位置取自录用通知记录状态变更为“Accepted”的更新。该状态可由候选人在线触发，也可由招聘人员手动录入。采集取自录用通知状态变更为“Accepted”时的时间戳。事件类型 explicit
	收到申请	候选人申请职位时创建新的职位申请，标志着一份申请的产生。系统通常会在首次创建申请记录时明确记录此事件。
为什么重要这是每个案例的起点，对于计算招聘周期等端到端流程时长，以及分析一段时间内的申请量至关重要。获取位置此事件取自Oracle Recruiting中候选人提交记录的创建时间戳，可能来自IRC_SUBMISSIONS等数据表。采集取自职位申请记录的创建时间戳。事件类型 explicit
	申请已拒绝	表示公司决定在流程的任一阶段不再推进该候选人。系统通过申请状态变更记录此事件。
为什么重要这是申请常见的终点。分析申请在哪个阶段被拒绝，对于了解流失率和流程效率至关重要。获取位置根据职位申请的任意终止状态变更推断，例如“Rejected”“Not Selected”或其他类似的已配置值。采集根据职位申请状态变更为终止状态“Rejected”推断。事件类型 inferred
	面试已完成	标志着候选人面试结束。通常根据面试官或招聘人员将已安排面试的状态更新为“Completed”或“Conducted”推断。
为什么重要这是招聘流程中的关键里程碑。从此活动到“Offer Extended”的周期时间是重要的绩效指标。获取位置根据Oracle Recruiting中已安排面试记录的状态变更推断。该状态变更的时间戳作为事件时间。采集根据面试状态变更为“Completed”或“Finished”推断。事件类型 inferred
	已发起背景调查	标志着候选人接受录用通知后启动背景调查。此事件通常由状态变更或与第三方服务集成触发。
为什么重要此活动对于跟踪录用后、入职前的时间线并确保合规至关重要。这里的延误可能影响候选人的入职日期。获取位置根据职位申请状态变更为“Background Check”，或通过集成背景调查服务商的API调用记录。采集根据申请状态变更为“Background Check in Progress”推断。事件类型 inferred
	录用通知已拒绝	表示候选人决定拒绝职位录用通知。通常表现为录用通知记录中的明确状态变更，并可能附带拒绝原因。
为什么重要这是流程中的关键失败节点。分析录用通知被拒绝的时间和原因，有助于了解薪酬竞争力和候选人体验。获取位置取自录用通知记录状态变更为“Declined”或“Rejected by Candidate”的更新。采集取自录用通知状态变更为“Declined”时的时间戳。事件类型 explicit
	录用通知详情已批准	表示录用通知发给候选人前，内部审批工作流已完成。通常根据录用通知记录的最终审批状态推断。
为什么重要此活动有助于分析内部录用通知审批流程的时长和效率，该流程可能是重要的延误来源。获取位置根据Oracle Recruiting中职位录用通知记录的状态变更历史推断，跟踪其进入“Approved”状态的时间。采集根据录用通知对象状态变更为“Approved”推断。事件类型 inferred
	申请已撤回	表示候选人决定退出该职位的选拔流程。申请状态更新为“Withdrawn by Candidate”时记录此事件。
为什么重要跟踪申请撤回有助于识别候选人体验不佳并导致高流失率的阶段，也是分析候选人流失率KPI的关键。获取位置根据职位申请状态变更为“Withdrawn”推断。候选人可以在门户中发起撤回，招聘人员也可以代为操作。采集根据职位申请状态变更为“Withdrawn by Candidate”推断。事件类型 inferred
	申请已筛选	表示招聘人员对候选人申请进行初步审核，以确认其是否具备基本资格。通常根据申请状态从“New”变为“Under Review”推断。
为什么重要分析候选人在此阶段耗费的时间，有助于识别初步审核流程中的瓶颈，也是衡量申请筛选返工率KPI的关键。获取位置根据Oracle Recruiting中职位申请状态字段的历史记录推断。请在IRC_SUBMISSIONS表的历史记录中查找状态变更。采集根据职位申请状态变更为“Screening”或“Under Review”推断。事件类型 inferred
	评估已完成	表示候选人已完成所需的预筛选评估，例如技能测试或性格测评。评估平台将完成状态返回至Oracle HCM时，系统通常会记录此事件。
为什么重要此活动有助于跟踪候选人参与度，并分析候选人完成评估所需的时间，因为评估阶段可能导致候选人流失。获取位置取自集成的第三方评估工具推送的状态更新，或招聘人员在候选人申请档案中手动变更的状态。采集评估服务商API更新候选人状态时记录。事件类型 explicit
	面试反馈已提交	表示面试官已在面试后提交对候选人的反馈和评价。保存反馈表单时，系统会明确记录此事件。
为什么重要面试结束到提交反馈之间的延误可能显著拖慢招聘流程。跟踪这一时段有助于识别决策环节中的瓶颈。获取位置面试官通过Oracle Recruiting门户提交评价时明确记录。使用反馈记录的创建时间戳。采集取自面试反馈记录的创建时间戳。事件类型 explicit
	面试已安排	表示系统正式安排候选人面试的时间点。通常在创建面试并将其关联到职位申请时记录。
为什么重要跟踪此活动有助于衡量安排面试所需的时间，这是候选人体验和整体招聘周期的重要组成部分。获取位置此事件会明确记录在Oracle Recruiting的面试安排模块中。相关数据应位于与职位申请关联的面试数据表中。采集取自与申请关联的面试事件创建记录。事件类型 explicit

建议可选

提取指南

如何从Oracle HCM Recruiting获取数据

步骤

进入OTBI：登录Oracle HCM Cloud。使用Navigator菜单进入Tools，然后选择Reports and Analytics。
创建新分析：在Reports and Analytics工作区中，点击Create，然后选择Analysis。不要选择Report，因为Analysis提供所需的灵活性。
选择主题区域：出现提示时，选择“Recruiting - Recruiting Real Time”主题区域。该数据模型包含职位申请、面试和录用通知所需的全部详情。
访问高级配置：选择主题区域后，系统会打开分析编辑器。进入右上角的Advanced选项卡，以便直接操作逻辑SQL查询。
粘贴逻辑SQL：在“Analysis XML”部分找到saw:query标签。将该标签中的现有SQL查询替换为本文档“Query”部分提供的完整逻辑SQL。必须替换整个默认查询。
设置日期范围参数：运行查询前，将[Start Date]和[End Date]的占位值替换为所需日期范围，格式为“YYYY-MM-DD”。这对控制提取数据量至关重要。
验证查询：点击“Validate SQL”按钮，确保不存在语法错误。验证成功后即可继续。请注意，此操作只检查语法，不检查您的具体配置中是否存在相应列。
查看结果：返回Results选项卡。分析将执行并显示事件日志数据预览。请确认列和数据均符合预期。
配置导出设置：对于大型数据集，建议将分析安排为作业，而不是交互式运行。在分析编辑器中设置导出属性，确保CSV格式规范。
导出数据：确认结果无误后，点击Export链接并选择CSV格式，下载完整的事件日志文件。
准备上传：打开下载的CSV文件，确保列标题与所需属性（JobApplicationId、ActivityName、EventTime等）一致，并确保日期格式统一。现在即可将文件上传到流程挖掘工具。

配置

主题区域：整个查询基于Recruiting - Recruiting Real Time主题区域构建。运行报告的用户必须拥有访问该主题区域所需的权限。
日期范围筛选：查询包含[Start Date]和[End Date]占位符。必须定义具体日期范围，以控制性能和数据量。建议先从最近3至6个月的数据开始。
数据安全：OTBI执行Oracle HCM数据安全角色限制。运行报告的用户只能查看其获授权访问的业务单元、部门和法定雇主数据。
性能注意事项：对于招聘量较大的组织，长时间范围运行查询可能速度较慢，或在交互式用户界面中超时。提取大量数据时，最佳做法是保存分析并安排其作为后台作业运行，将输出发送到内容服务器或电子邮件。
自定义：所提供的查询使用标准字段。如果您的组织使用描述性弹性域（DFF）或自定义对象记录特定招聘事件，则需要修改逻辑SQL以包含这些字段。

a 示例查询 sql

SELECT
    "Recruiting - Recruiting Real Time"."Job Application - General"."Job Application Identifier" as "JobApplicationId",
    'Application Received' as "ActivityName",
    CAST("Recruiting - Recruiting Real Time"."Job Application - General"."Submission Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    "Recruiting - Recruiting Real Time"."Primary Recruiter"."Recruiter Display Name" as "Recruiter",
    "Recruiting - Recruiting Real Time"."Hiring Manager"."Hiring Manager Display Name" as "HiringManager",
    "Recruiting - Recruiting Real Time"."Requisition - General"."Department Name" as "Department",
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State"."Current State" as "ApplicationStatus",
    "Recruiting - Recruiting Real Time"."Job Application - Source"."Source Name" as "ApplicationSource"
FROM "Recruiting - Recruiting Real Time"
WHERE "Recruiting - Recruiting Real Time"."Job Application - General"."Submission Date" IS NOT NULL
AND "Recruiting - Recruiting Real Time"."Job Application - General"."Submission Date" >= TIMESTAMP '[Start Date]'
AND "Recruiting - Recruiting Real Time"."Job Application - General"."Submission Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    T1."Job Application Identifier" as "JobApplicationId",
    'Application Screened' as "ActivityName",
    CAST(T2."Start Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    T4."Recruiter Display Name" as "Recruiter",
    T5."Hiring Manager Display Name" as "HiringManager",
    T6."Department Name" as "Department",
    T3."Current State" as "ApplicationStatus",
    T7."Source Name" as "ApplicationSource"
FROM
    "Recruiting - Recruiting Real Time"."Job Application - General" T1,
    "Recruiting - Recruiting Real Time"."Job Application - Phase and State History" T2,
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State" T3,
    "Recruiting - Recruiting Real Time"."Primary Recruiter" T4,
    "Recruiting - Recruiting Real Time"."Hiring Manager" T5,
    "Recruiting - Recruiting Real Time"."Requisition - General" T6,
    "Recruiting - Recruiting Real Time"."Job Application - Source" T7
WHERE T1."Job Application Identifier" = T2."Job Application Identifier"
AND T1."Job Application Identifier" = T3."Job Application Identifier"
AND T1."Recruiter Login Name" = T4."Recruiter Login Name"
AND T1."Hiring Manager Login Name" = T5."Hiring Manager Login Name"
AND T1."Requisition Number" = T6."Requisition Number"
AND T1."Source ID" = T7."Source ID"
AND T2."State Name" = 'Screen'
AND T2."Start Date" IS NOT NULL
AND T2."Start Date" >= TIMESTAMP '[Start Date]'
AND T2."Start Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    "Recruiting - Recruiting Real Time"."Job Application - General"."Job Application Identifier" as "JobApplicationId",
    'Assessment Completed' as "ActivityName",
    CAST("Recruiting - Recruiting Real Time"."Job Application - Assessment"."Assessment Completion Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    "Recruiting - Recruiting Real Time"."Primary Recruiter"."Recruiter Display Name" as "Recruiter",
    "Recruiting - Recruiting Real Time"."Hiring Manager"."Hiring Manager Display Name" as "HiringManager",
    "Recruiting - Recruiting Real Time"."Requisition - General"."Department Name" as "Department",
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State"."Current State" as "ApplicationStatus",
    "Recruiting - Recruiting Real Time"."Job Application - Source"."Source Name" as "ApplicationSource"
FROM "Recruiting - Recruiting Real Time"
WHERE "Recruiting - Recruiting Real Time"."Job Application - Assessment"."Assessment Completion Date" IS NOT NULL
AND "Recruiting - Recruiting Real Time"."Job Application - Assessment"."Assessment Completion Date" >= TIMESTAMP '[Start Date]'
AND "Recruiting - Recruiting Real Time"."Job Application - Assessment"."Assessment Completion Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    "Recruiting - Recruiting Real Time"."Job Application - General"."Job Application Identifier" as "JobApplicationId",
    'Interview Scheduled' as "ActivityName",
    CAST("Recruiting - Recruiting Real Time"."Job Application - Interview Schedule"."Interview Scheduled Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    "Recruiting - Recruiting Real Time"."Primary Recruiter"."Recruiter Display Name" as "Recruiter",
    "Recruiting - Recruiting Real Time"."Hiring Manager"."Hiring Manager Display Name" as "HiringManager",
    "Recruiting - Recruiting Real Time"."Requisition - General"."Department Name" as "Department",
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State"."Current State" as "ApplicationStatus",
    "Recruiting - Recruiting Real Time"."Job Application - Source"."Source Name" as "ApplicationSource"
FROM "Recruiting - Recruiting Real Time"
WHERE "Recruiting - Recruiting Real Time"."Job Application - Interview Schedule"."Interview Scheduled Date" IS NOT NULL
AND "Recruiting - Recruiting Real Time"."Job Application - Interview Schedule"."Interview Scheduled Date" >= TIMESTAMP '[Start Date]'
AND "Recruiting - Recruiting Real Time"."Job Application - Interview Schedule"."Interview Scheduled Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    "Recruiting - Recruiting Real Time"."Job Application - General"."Job Application Identifier" as "JobApplicationId",
    'Interview Conducted' as "ActivityName",
    CAST("Recruiting - Recruiting Real Time"."Job Application - Interview Feedback"."Interview Completion Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    "Recruiting - Recruiting Real Time"."Primary Recruiter"."Recruiter Display Name" as "Recruiter",
    "Recruiting - Recruiting Real Time"."Hiring Manager"."Hiring Manager Display Name" as "HiringManager",
    "Recruiting - Recruiting Real Time"."Requisition - General"."Department Name" as "Department",
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State"."Current State" as "ApplicationStatus",
    "Recruiting - Recruiting Real Time"."Job Application - Source"."Source Name" as "ApplicationSource"
FROM "Recruiting - Recruiting Real Time"
WHERE "Recruiting - Recruiting Real Time"."Job Application - Interview Feedback"."Interview Event Overall Status" = 'Completed'
AND "Recruiting - Recruiting Real Time"."Job Application - Interview Feedback"."Interview Completion Date" IS NOT NULL
AND "Recruiting - Recruiting Real Time"."Job Application - Interview Feedback"."Interview Completion Date" >= TIMESTAMP '[Start Date]'
AND "Recruiting - Recruiting Real Time"."Job Application - Interview Feedback"."Interview Completion Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    "Recruiting - Recruiting Real Time"."Job Application - General"."Job Application Identifier" as "JobApplicationId",
    'Interview Feedback Submitted' as "ActivityName",
    CAST("Recruiting - Recruiting Real Time"."Job Application - Interview Feedback"."Feedback Submission Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    "Recruiting - Recruiting Real Time"."Primary Recruiter"."Recruiter Display Name" as "Recruiter",
    "Recruiting - Recruiting Real Time"."Hiring Manager"."Hiring Manager Display Name" as "HiringManager",
    "Recruiting - Recruiting Real Time"."Requisition - General"."Department Name" as "Department",
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State"."Current State" as "ApplicationStatus",
    "Recruiting - Recruiting Real Time"."Job Application - Source"."Source Name" as "ApplicationSource"
FROM "Recruiting - Recruiting Real Time"
WHERE "Recruiting - Recruiting Real Time"."Job Application - Interview Feedback"."Feedback Submission Date" IS NOT NULL
AND "Recruiting - Recruiting Real Time"."Job Application - Interview Feedback"."Feedback Submission Date" >= TIMESTAMP '[Start Date]'
AND "Recruiting - Recruiting Real Time"."Job Application - Interview Feedback"."Feedback Submission Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    "Recruiting - Recruiting Real Time"."Job Application - General"."Job Application Identifier" as "JobApplicationId",
    'Offer Details Approved' as "ActivityName",
    CAST("Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Approval Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    "Recruiting - Recruiting Real Time"."Primary Recruiter"."Recruiter Display Name" as "Recruiter",
    "Recruiting - Recruiting Real Time"."Hiring Manager"."Hiring Manager Display Name" as "HiringManager",
    "Recruiting - Recruiting Real Time"."Requisition - General"."Department Name" as "Department",
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State"."Current State" as "ApplicationStatus",
    "Recruiting - Recruiting Real Time"."Job Application - Source"."Source Name" as "ApplicationSource"
FROM "Recruiting - Recruiting Real Time"
WHERE "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Approval Date" IS NOT NULL
AND "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Approval Date" >= TIMESTAMP '[Start Date]'
AND "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Approval Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    "Recruiting - recruiting Real Time"."Job Application - General"."Job Application Identifier" as "JobApplicationId",
    'Offer Extended' as "ActivityName",
    CAST("Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Extended Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    "Recruiting - Recruiting Real Time"."Primary Recruiter"."Recruiter Display Name" as "Recruiter",
    "Recruiting - Recruiting Real Time"."Hiring Manager"."Hiring Manager Display Name" as "HiringManager",
    "Recruiting - Recruiting Real Time"."Requisition - General"."Department Name" as "Department",
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State"."Current State" as "ApplicationStatus",
    "Recruiting - Recruiting Real Time"."Job Application - Source"."Source Name" as "ApplicationSource"
FROM "Recruiting - Recruiting Real Time"
WHERE "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Extended Date" IS NOT NULL
AND "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Extended Date" >= TIMESTAMP '[Start Date]'
AND "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Extended Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    "Recruiting - Recruiting Real Time"."Job Application - General"."Job Application Identifier" as "JobApplicationId",
    'Offer Accepted' as "ActivityName",
    CAST("Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Accepted Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    "Recruiting - Recruiting Real Time"."Primary Recruiter"."Recruiter Display Name" as "Recruiter",
    "Recruiting - Recruiting Real Time"."Hiring Manager"."Hiring Manager Display Name" as "HiringManager",
    "Recruiting - Recruiting Real Time"."Requisition - General"."Department Name" as "Department",
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State"."Current State" as "ApplicationStatus",
    "Recruiting - Recruiting Real Time"."Job Application - Source"."Source Name" as "ApplicationSource"
FROM "Recruiting - Recruiting Real Time"
WHERE "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Accepted Date" IS NOT NULL
AND "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Accepted Date" >= TIMESTAMP '[Start Date]'
AND "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Accepted Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    "Recruiting - Recruiting Real Time"."Job Application - General"."Job Application Identifier" as "JobApplicationId",
    'Offer Declined' as "ActivityName",
    CAST("Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Declined Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    "Recruiting - Recruiting Real Time"."Primary Recruiter"."Recruiter Display Name" as "Recruiter",
    "Recruiting - Recruiting Real Time"."Hiring Manager"."Hiring Manager Display Name" as "HiringManager",
    "Recruiting - Recruiting Real Time"."Requisition - General"."Department Name" as "Department",
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State"."Current State" as "ApplicationStatus",
    "Recruiting - Recruiting Real Time"."Job Application - Source"."Source Name" as "ApplicationSource"
FROM "Recruiting - Recruiting Real Time"
WHERE "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Declined Date" IS NOT NULL
AND "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Declined Date" >= TIMESTAMP '[Start Date]'
AND "Recruiting - Recruiting Real Time"."Job Application - Offer"."Offer Declined Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    T1."Job Application Identifier" as "JobApplicationId",
    'Background Check Initiated' as "ActivityName",
    CAST(T2."Start Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    T4."Recruiter Display Name" as "Recruiter",
    T5."Hiring Manager Display Name" as "HiringManager",
    T6."Department Name" as "Department",
    T3."Current State" as "ApplicationStatus",
    T7."Source Name" as "ApplicationSource"
FROM
    "Recruiting - Recruiting Real Time"."Job Application - General" T1,
    "Recruiting - Recruiting Real Time"."Job Application - Phase and State History" T2,
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State" T3,
    "Recruiting - Recruiting Real Time"."Primary Recruiter" T4,
    "Recruiting - Recruiting Real Time"."Hiring Manager" T5,
    "Recruiting - Recruiting Real Time"."Requisition - General" T6,
    "Recruiting - Recruiting Real Time"."Job Application - Source" T7
WHERE T1."Job Application Identifier" = T2."Job Application Identifier"
AND T1."Job Application Identifier" = T3."Job Application Identifier"
AND T1."Recruiter Login Name" = T4."Recruiter Login Name"
AND T1."Hiring Manager Login Name" = T5."Hiring Manager Login Name"
AND T1."Requisition Number" = T6."Requisition Number"
AND T1."Source ID" = T7."Source ID"
AND T2."State Name" = 'Background Check'
AND T2."Start Date" IS NOT NULL
AND T2."Start Date" >= TIMESTAMP '[Start Date]'
AND T2."Start Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    T1."Job Application Identifier" as "JobApplicationId",
    'Candidate Hired' as "ActivityName",
    CAST(T2."Start Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    T4."Recruiter Display Name" as "Recruiter",
    T5."Hiring Manager Display Name" as "HiringManager",
    T6."Department Name" as "Department",
    T3."Current State" as "ApplicationStatus",
    T7."Source Name" as "ApplicationSource"
FROM
    "Recruiting - Recruiting Real Time"."Job Application - General" T1,
    "Recruiting - Recruiting Real Time"."Job Application - Phase and State History" T2,
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State" T3,
    "Recruiting - Recruiting Real Time"."Primary Recruiter" T4,
    "Recruiting - Recruiting Real Time"."Hiring Manager" T5,
    "Recruiting - Recruiting Real Time"."Requisition - General" T6,
    "Recruiting - Recruiting Real Time"."Job Application - Source" T7
WHERE T1."Job Application Identifier" = T2."Job Application Identifier"
AND T1."Job Application Identifier" = T3."Job Application Identifier"
AND T1."Recruiter Login Name" = T4."Recruiter Login Name"
AND T1."Hiring Manager Login Name" = T5."Hiring Manager Login Name"
AND T1."Requisition Number" = T6."Requisition Number"
AND T1."Source ID" = T7."Source ID"
AND T2."State Name" = 'Hired'
AND T2."Start Date" IS NOT NULL
AND T2."Start Date" >= TIMESTAMP '[Start Date]'
AND T2."Start Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    T1."Job Application Identifier" as "JobApplicationId",
    'Application Rejected' as "ActivityName",
    CAST(T2."Start Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    T4."Recruiter Display Name" as "Recruiter",
    T5."Hiring Manager Display Name" as "HiringManager",
    T6."Department Name" as "Department",
    T3."Current State" as "ApplicationStatus",
    T7."Source Name" as "ApplicationSource"
FROM
    "Recruiting - Recruiting Real Time"."Job Application - General" T1,
    "Recruiting - Recruiting Real Time"."Job Application - Phase and State History" T2,
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State" T3,
    "Recruiting - Recruiting Real Time"."Primary Recruiter" T4,
    "Recruiting - Recruiting Real Time"."Hiring Manager" T5,
    "Recruiting - Recruiting Real Time"."Requisition - General" T6,
    "Recruiting - Recruiting Real Time"."Job Application - Source" T7
WHERE T1."Job Application Identifier" = T2."Job Application Identifier"
AND T1."Job Application Identifier" = T3."Job Application Identifier"
AND T1."Recruiter Login Name" = T4."Recruiter Login Name"
AND T1."Hiring Manager Login Name" = T5."Hiring Manager Login Name"
AND T1."Requisition Number" = T6."Requisition Number"
AND T1."Source ID" = T7."Source ID"
AND T2."State Name" LIKE '%Rejected%'
AND T2."Start Date" IS NOT NULL
AND T2."Start Date" >= TIMESTAMP '[Start Date]'
AND T2."Start Date" < TIMESTAMP '[End Date]'

UNION ALL

SELECT
    T1."Job Application Identifier" as "JobApplicationId",
    'Application Withdrawn' as "ActivityName",
    CAST(T2."Start Date" AS TIMESTAMP) as "EventTime",
    'Oracle HCM Recruiting' as "SourceSystem",
    CURRENT_TIMESTAMP as "LastDataUpdate",
    T4."Recruiter Display Name" as "Recruiter",
    T5."Hiring Manager Display Name" as "HiringManager",
    T6."Department Name" as "Department",
    T3."Current State" as "ApplicationStatus",
    T7."Source Name" as "ApplicationSource"
FROM
    "Recruiting - Recruiting Real Time"."Job Application - General" T1,
    "Recruiting - Recruiting Real Time"."Job Application - Phase and State History" T2,
    "Recruiting - Recruiting Real Time"."Job Application - Current Phase and State" T3,
    "Recruiting - Recruiting Real Time"."Primary Recruiter" T4,
    "Recruiting - Recruiting Real Time"."Hiring Manager" T5,
    "Recruiting - Recruiting Real Time"."Requisition - General" T6,
    "Recruiting - Recruiting Real Time"."Job Application - Source" T7
WHERE T1."Job Application Identifier" = T2."Job Application Identifier"
AND T1."Job Application Identifier" = T3."Job Application Identifier"
AND T1."Recruiter Login Name" = T4."Recruiter Login Name"
AND T1."Hiring Manager Login Name" = T5."Hiring Manager Login Name"
AND T1."Requisition Number" = T6."Requisition Number"
AND T1."Source ID" = T7."Source ID"
AND T2."State Name" = 'Withdrawn by Candidate'
AND T2."Start Date" IS NOT NULL
AND T2."Start Date" >= TIMESTAMP '[Start Date]'
AND T2."Start Date" < TIMESTAMP '[End Date]'

步骤

前置条件：确保系统已安装Python 3和requests库。可使用pip安装：pip install requests。您还需要有效的用户凭据（用户名和密码），以及具备访问Recruiting REST API权限的Oracle HCM Cloud实例主机名。
初始化脚本：创建新的Python脚本文件，例如extract_hcm_data.py。首先导入所需库：requests、csv和datetime。
定义配置：在脚本顶部定义Oracle HCM主机名、用户名、密码以及所需的数据提取日期范围。使用凭据占位符是安全最佳实践。
建立API会话：创建requests.Session对象，并使用用户名和密码设置会话的身份验证属性。这样，后续通过该会话发出的每个API请求都会自动携带凭据。
实现分页循环：脚本必须分页获取数据，以处理大量数据并遵守API限制。将offset变量初始化为0，并设置limit，例如500。创建while循环，只要API持续返回数据就继续执行。每次循环使用当前offset调用API，然后将offset增加limit，以获取下一页数据。
发起API请求：在循环中构造recruitingCEJobApplications端点的完整API请求URL。使用fields参数指定所需的全部属性，并使用expand参数包含Phases和Offers等关联对象。使用q参数根据配置的日期范围筛选CreationDate。
处理JSON响应：每次API调用都检查HTTP状态码是否为200，然后解析JSON响应。申请数据位于响应正文的items数组中。
遍历并生成事件：遍历API返回的每个申请对象，提取ApplicationId、Recruiter和HiringManager等通用属性。
将状态映射为活动：这是核心逻辑。对于每个申请，必须为14项所需活动分别生成一行数据。具体包括检查CreationDate、Phases集合和Offers集合。例如，使用CreationDate记录“Application Received”。遍历Phases数组，根据每个阶段进入时的时间戳生成“Application Screened”“Interview Scheduled”“Candidate Hired”“Application Rejected”等活动记录。同样，遍历Offers数组，生成“Offer Extended”“Offer Accepted”和“Offer Declined”等事件。
构建事件日志：每生成一项活动事件，就将其保存为字典，键对应事件日志列标题（JobApplicationId、ActivityName、EventTime等），并将每个字典追加到主列表中，形成完整事件日志。
导出为CSV：分页循环完成后，使用Python内置的csv模块将事件字典主列表写入CSV文件。确保文件采用UTF-8编码，且CSV标题与ProcessMind数据导入所需的属性名称完全一致。

配置

API凭据：需要使用专用服务账户，并为其分配可访问Recruiting REST API的角色，例如“Recruiting Manager”，或包含“Recruiting REST API Access”权限的自定义角色。
API端点：主要使用的端点是recruitingCEJobApplications。必须使用expand查询参数（例如expand=Phases,Offers），在一次调用中获取包含状态历史和录用详情的嵌套对象，从而提高效率。
日期范围筛选：使用q查询参数按日期筛选申请。建议根据CreationDate进行筛选，以控制数据量。首次分析建议选择最近3至6个月的数据。例如：q=CreationDate>'2023-01-01T00:00:00Z'。
字段选择：使用fields参数仅请求必要属性，以提升性能并减少网络负载。应包含ApplicationId、CreationDate、LastUpdateDate、Recruiter、HiringManager、Requisition、Phases和Offers等字段。
分页限制：limit参数控制每次API调用返回的记录数。通常，200至500之间的值可以在API调用次数和单次响应大小之间取得较好平衡。
状态映射：脚本包含一个字典，用于将Oracle HCM中的阶段和状态代码映射为标准活动名称。您可能需要根据组织的具体招聘工作流配置自定义此映射。

a 示例查询 python

import requests
import csv
import json
from datetime import datetime

class=class="hl-string">"hl-comment"># --- Configuration Settings ---
HCM_HOST = class="hl-string">"https://[Your HCM Host].fa.us2.oraclecloud.com"
USERNAME = class="hl-string">"[Your Username]"
PASSWORD = class="hl-string">"[Your Password]"

class=class="hl-string">"hl-comment"># Date range for the query (ISO 8601 format)
START_DATE = class="hl-string">"2023-01-01T00:00:00+00:00"
END_DATE = class="hl-string">"2023-12-31T23:59:59+00:00"

class=class="hl-string">"hl-comment"># API and File settings
API_ENDPOINT = class="hl-string">"/hcmRestApi/resources/11.13.18.05/recruitingCEJobApplications"
CSV_FILENAME = class="hl-string">"recruitment_event_log.csv"
API_LIMIT = 500

class=class="hl-string">"hl-comment"># --- Main Extraction Logic ---
def main():
    class="hl-string">"""Main function to orchestrate the extraction process."""
    event_log = []
    offset = 0
    has_more = True

    session = requests.Session()
    session.auth = (USERNAME, PASSWORD)

    print(class="hl-string">"Starting data extraction from Oracle HCM...")

    while has_more:
        print(fclass="hl-string">"Fetching applications, offset: {offset}")
        try:
            params = {
                class="hl-string">'q': fclass="hl-string">"CreationDate between '{START_DATE}' and '{END_DATE}'",
                class="hl-string">'fields': class="hl-string">'ApplicationId,CreationDate,LastUpdateDate,ApplicationStatus,ApplicationSource,Recruiter,HiringManager,Department,Phases,Offers',
                class="hl-string">'expand': class="hl-string">'Phases,Offers',
                class="hl-string">'limit': API_LIMIT,
                class="hl-string">'offset': offset
            }
            response = session.get(HCM_HOST + API_ENDPOINT, params=params)
            response.raise_for_status()  class=class="hl-string">"hl-comment"># Raises an exception for bad status codes

            data = response.json()
            applications = data.get(class="hl-string">'items', [])

            if not applications:
                print(class="hl-string">"No more applications found.")
                break

            process_applications(applications, event_log)

            has_more = data.get(class="hl-string">'hasMore', False)
            offset += API_LIMIT

        except requests.exceptions.HTTPError as http_err:
            print(fclass="hl-string">"HTTP error occurred: {http_err} - {response.text}")
            break
        except Exception as err:
            print(fclass="hl-string">"An error occurred: {err}")
            break

    if event_log:
        write_to_csv(event_log)
        print(fclass="hl-string">"Extraction complete. {len(event_log)} events written to {CSV_FILENAME}")
    else:
        print(class="hl-string">"No events were generated.")

def process_applications(applications, event_log):
    class="hl-string">"""Processes a batch of applications and generates event log entries."""
    now_iso = datetime.utcnow().isoformat() + class="hl-string">'Z'

    for app in applications:
        base_event = {
            class="hl-string">'JobApplicationId': app.get(class="hl-string">'ApplicationId'),
            class="hl-string">'Recruiter': app.get(class="hl-string">'Recruiter'),
            class="hl-string">'HiringManager': app.get(class="hl-string">'HiringManager'),
            class="hl-string">'Department': app.get(class="hl-string">'Department'),
            class="hl-string">'ApplicationSource': app.get(class="hl-string">'ApplicationSource'),
            class="hl-string">'ApplicationStatus': app.get(class="hl-string">'ApplicationStatus'),
            class="hl-string">'SourceSystem': class="hl-string">'Oracle HCM Recruiting',
            class="hl-string">'LastDataUpdate': now_iso
        }

        class=class="hl-string">"hl-comment"># 1. Application Received
        event_log.append({**base_event, class="hl-string">'ActivityName': class="hl-string">'Application Received', class="hl-string">'EventTime': app.get(class="hl-string">'CreationDate')})

        class=class="hl-string">"hl-comment"># Process phases for status-based events
        for phase in app.get(class="hl-string">'Phases', []):
            phase_name = phase.get(class="hl-string">'PhaseName', class="hl-string">'').lower()
            status_name = phase.get(class="hl-string">'StateName', class="hl-string">'').lower()
            entry_date = phase.get(class="hl-string">'EntryDate')

            if not entry_date: continue

            activity_map = {
                class="hl-string">'screen': class="hl-string">'Application Screened',
                class="hl-string">'assessment': class="hl-string">'Assessment Completed',
                class="hl-string">'interview': class="hl-string">'Interview Scheduled',
                class="hl-string">'offer': class="hl-string">'Offer Details Approved', class=class="hl-string">"hl-comment"># Approximation, happens before offer is made
                class="hl-string">'background check': class="hl-string">'Background Check Initiated',
                class="hl-string">'hired': class="hl-string">'Candidate Hired',
                class="hl-string">'rejected': class="hl-string">'Application Rejected',
                class="hl-string">'withdrawn': class="hl-string">'Application Withdrawn'
            }

            class=class="hl-string">"hl-comment"># Simple mapping by phase name
            for key, activity in activity_map.items():
                if key in phase_name:
                    event_log.append({**base_event, class="hl-string">'ActivityName': activity, class="hl-string">'EventTime': entry_date})

            class=class="hl-string">"hl-comment"># Specific logic for Interview Conducted
            if class="hl-string">'interview' in phase_name and status_name == class="hl-string">'completed':
                 event_log.append({**base_event, class="hl-string">'ActivityName': class="hl-string">'Interview Conducted', class="hl-string">'EventTime': entry_date})

            class=class="hl-string">"hl-comment"># Specific logic for Feedback Submitted (approximation)
            if class="hl-string">'interview' in phase_name and status_name == class="hl-string">'completed':
                 class=class="hl-string">"hl-comment"># This is an approximation, assuming feedback is submitted upon completion
                 event_log.append({**base_event, class="hl-string">'ActivityName': class="hl-string">'Interview Feedback Submitted', class="hl-string">'EventTime': entry_date})


        class=class="hl-string">"hl-comment"># Process offers for offer-related events
        for offer in app.get(class="hl-string">'Offers', []):
            offer_status = offer.get(class="hl-string">'OfferStatus', class="hl-string">'').lower()
            offer_date = offer.get(class="hl-string">'OfferDate') or offer.get(class="hl-string">'LastUpdateDate')

            if not offer_date: continue

            if offer_status == class="hl-string">'extended':
                event_log.append({**base_event, class="hl-string">'ActivityName': class="hl-string">'Offer Extended', class="hl-string">'EventTime': offer_date})
            elif offer_status == class="hl-string">'accepted':
                event_log.append({**base_event, class="hl-string">'ActivityName': class="hl-string">'Offer Accepted', class="hl-string">'EventTime': offer_date})
            elif offer_status == class="hl-string">'declined':
                event_log.append({**base_event, class="hl-string">'ActivityName': class="hl-string">'Offer Declined', class="hl-string">'EventTime': offer_date})


def write_to_csv(event_log):
    class="hl-string">"""Writes the event log data to a CSV file."""
    if not event_log:
        return

    headers = [
        class="hl-string">'JobApplicationId', class="hl-string">'ActivityName', class="hl-string">'EventTime', class="hl-string">'SourceSystem', class="hl-string">'LastDataUpdate',
        class="hl-string">'Recruiter', class="hl-string">'HiringManager', class="hl-string">'Department', class="hl-string">'ApplicationStatus', class="hl-string">'ApplicationSource'
    ]

    class=class="hl-string">"hl-comment"># Deduplicate and sort events to ensure chronological order per application
    unique_events = {tuple(event.items()) for event in event_log}
    sorted_events = sorted([dict(event) for event in unique_events], key=lambda x: (x[class="hl-string">'JobApplicationId'], x[class="hl-string">'EventTime']))

    with open(CSV_FILENAME, class="hl-string">'w', newline=class="hl-string">'', encoding=class="hl-string">'utf-8') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=headers)
        writer.writeheader()
        writer.writerows(sorted_events)

if __name__ == class="hl-string">"__main__":
    main()

准备开始了吗？

使用此模板自信完成数据准备，开始发现人才获取流程中的隐藏洞察。立即开启提升招聘策略效率和效果的旅程。

返回改进指南下载模板

立即优化您的招聘与人才获取流程

将周期时间缩短30%，提升候选人体验。

开始免费试用

无需信用卡，几分钟即可完成设置。

您的招聘与人才获取数据模板

您的招聘与人才获取数据模板

招聘与人才获取属性

招聘与人才获取活动

提取指南

用于导出招聘数据的Oracle HCM OTBI报告

步骤

配置

a 示例查询 sql

使用Oracle HCM REST API提取数据的Python脚本

步骤

配置

a 示例查询 python

准备开始了吗？

立即优化您的招聘与人才获取流程

您的招聘与人才获取数据模板

您的招聘与人才获取数据模板

招聘与人才获取属性

招聘与人才获取活动

提取指南

用于导出招聘数据的Oracle HCM OTBI报告

步骤

配置

a 示例查询 sql

使用Oracle HCM REST API提取数据的Python脚本

步骤

配置

a 示例查询 python

准备开始了吗？

立即优化您的招聘与人才获取流程

我们重视您的隐私