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

您的招聘与人才获取 data 模板

Oracle HCM Recruiting

← 返回改进指南

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

您的招聘与人才获取 data 模板

本模板为收集优化招聘与人才获取流程所需的 data 提供了全面指南。它列出了核心的 data 属性、需要追踪的关键活动，以及从源系统中提取这些信息的实用指导。利用此资源，确保 data 准备阶段顺利且高效。

建议采集的属性，用于全面分析
要追踪的关键流程活动和里程碑
系统数据提取指南

不熟悉事件日志？了解如何创建流程挖掘事件日志.

下载模板

招聘与人才获取属性

为了对您的招聘与人才获取流程进行全面分析，建议在 event log 中包含这些 data 字段。

5 必填 5 推荐 9 可选

	名称	描述
	开始时间 EventTime	指示招聘活动何时开始的 timestamp。
描述此属性捕获特定活动发生的精确日期和时间。它为每个职位申请 case 内的 event 排序提供时间背景。开始时间对于所有基于时间的 Process Mining 分析都至关重要。它用于计算活动间的周期时间、识别延误、衡量整体招聘周期，并检查是否符合服务水平协议或绩效目标。为何重要它提供了事件的时间顺序，这对于计算持续时间、发现瓶颈以及分析流程绩效至关重要。获取方式此 timestamp 通常位于 Oracle HCM Recruiting 的 event log 或状态历史记录表中的活动名称旁边。示例 2023-10-01T10:00:00Z2023-10-05T14:30:00Z2023-11-12T09:15:00Z
	活动 ActivityName	发生的特定招聘活动或 event 的名称。
描述此属性描述招聘流程中的单个步骤或里程碑，例如“申请已筛选”、“面试已进行”或“Offer 已发送”。每个活动代表申请生命周期中的一个独立 event。它是 Process Mining 的基础组件，因为它定义了流程图中的节点。分析活动的顺序和频率有助于识别常见流程路径、瓶颈、偏离标准程序的行为以及返工循环。为何重要此属性定义了招聘流程中的各个步骤，构成了流程图的基础，并支持对流程流向和变体的分析。获取方式通常源自 Oracle HCM Recruiting 中与职位申请对象相关的 event 或状态历史记录表。示例申请已筛选面试已进行已发出 Offer候选人已入职
	职位申请 JobApplicationId	每份候选人职位申请的唯一标识符。
描述职位申请 ID 是追踪候选人在特定职位申请中完整旅程的主键。它关联了从初始提交到最终雇佣决策的所有相关活动，形成了一个单一且连贯的流程实例。在 Process Mining 中，此属性对于定义 case 至关重要，它能够重构每个候选人的独特路径。分析师利用它来可视化端到端的申请流程，衡量整体周期时间，并分析招聘漏斗不同阶段之间的转化率。为何重要它唯一标识每个招聘 case，使得全程追踪候选人从申请到结束的完整生命周期成为可能。获取方式这是 Oracle HCM Recruiting 模块中的主要标识符，通常与候选人提交记录相关联。示例 APP-2024-00123APP-2024-00124APP-2024-00125
	最后数据更新 LastDataUpdate	从源系统最后一次刷新或提取数据的时间戳。
描述此属性指示最近一次 data 提取的日期和时间。它提供了所分析 data 的新鲜度背景。这对于用户了解流程分析的实时性以及管理对最近活动可见性的预期非常重要。它是任何 Dashboard 或报表中的关键元数据。为何重要告知用户数据的时效性，确保其了解分析所涵盖的时间段。获取方式此时间戳在数据提取、转换与加载（ETL）过程中生成并添加。示例 2024-05-20T08:00:00Z2024-05-21T08:00:00Z
	源系统 SourceSystem	data 来源的系统。
描述此属性用于识别记录招聘 data 的来源信息系统。对于此流程，通常为“Oracle HCM Recruiting”。在多系统环境中，此字段对于 data 溯源和故障排查至关重要。它有助于确认 data 是否来自预期源，并可用于过滤来自特定平台的分析 data。为何重要识别数据来源，这对于数据治理、验证以及确保分析基于正确的信息源至关重要。获取方式这通常是在数据提取、转换和加载（ETL）过程中添加的静态值，用于标记数据集。示例 Oracle HCM RecruitingOracle Fusion Cloud HCM
	Recruiter Recruiter	负责管理该职位申请的招聘专员姓名或 ID。
描述此属性用于识别分配给该申请的人才获取专业人员。此人通常负责引导候选人完成整个流程。按招聘人员分析流程可以实现工作量平衡、绩效基准评估并确定最佳实践。它能回答诸如哪些招聘人员的周期最短或 Offer 接受率最高等问题，从而为“招聘人员工作量与效率”Dashboard 提供支持。为何重要将活动归因于特定个人，支持对招聘人员的工作量、效率和绩效进行分析。获取方式与 Oracle HCM 招聘中的职位申请或招聘需求对象相关联。示例约翰·史密斯Jane DoeEmily Jones
	应用源 ApplicationSource	收到申请的渠道或来源。
描述此属性追踪候选人发现职位空缺的途径，例如“LinkedIn”、“公司官网”、“员工推荐”或“招聘门户”。它对于“申请来源有效性”Dashboard 至关重要，因为它允许组织衡量不同寻才渠道的投资回报率。通过分析哪些来源产生的入职人数最多或招聘周期最快，人才获取团队可以优化其渠道策略。为何重要有助于确定吸引和聘用合格候选人的最有效渠道，从而优化招聘营销支出。获取方式这些信息通常是在候选人在 Oracle HCM Recruiting 中提交申请时捕获的。示例 LinkedIn员工推荐公司招聘页面Indeed
	招聘经理 HiringManager	关联职位申请的招聘经理姓名或 ID。
描述此属性用于识别职位空缺所属团队或部门的经理。招聘经理是核心利益相关者，通常参与筛选、面试和最终雇佣决策。按招聘经理分析流程绩效，可以揭示与其面试时间安排或反馈延迟相关的瓶颈。这有助于发现培训或流程改进的机会，帮助经理更高效地履行招聘职责。为何重要识别流程中的关键利益相关者，支持分析与招聘经理参与相关的延迟或效率。获取方式存储在职位申请对象中，该对象在 Oracle HCM Recruiting 内与职位申请关联。示例 Robert BrownSusan WhiteMichael Green
	申请状态 ApplicationStatus	职位申请的当前或最终状态。
描述此属性指示申请的处理情况，例如“进行中”、“已雇佣”、“已拒绝”或“已撤回”。它提供了申请在流程中所处位置或其最终结果的快照。分析最终状态是计算录用率和流失率等关键指标的基础。通过展示有多少候选人成功进入最后阶段，它有助于了解招聘漏斗的整体有效性。为何重要提供招聘流程的最终结果，这对于计算转化率、录用率和流失率至关重要。获取方式 Oracle HCM 招聘中主职位申请记录上的标准字段。示例已录用已驳回由候选人撤回已接受 Offer
	部门 Department	候选人受聘的部门或业务单位。
描述此属性指定拥有职位空缺的组织单位，例如“工程部”、“销售部”或“市场部”。它为每个职位申请提供了组织背景。按部门划分招聘流程对于绩效基准评估至关重要。如“部门招聘绩效基准评估”Dashboard 所要求的，它允许领导层比较组织不同部门的招聘周期、流失率和其他关键指标。为何重要支持对不同业务单位或部门之间的招聘绩效和流程差异进行比较。获取方式通常是 Oracle HCM Recruiting 中与申请关联的职位申请 data 的一部分。示例工程部销售财务人力资源
	Offer 金额 OfferAmount	向候选人发送的 Offer 中的薪资数额。
描述此属性捕获岗位的拟议薪酬。这是招聘流程最后阶段的一项关键信息。虽然数据敏感，但分析 Offer 金额可以揭示薪酬竞争力。它可以与 Offer 接受率相关联，以了解薪酬是否是候选人拒绝 Offer 的因素。它还可以用于确保不同部门和岗位之间的薪酬公平。为何重要支持分析薪酬趋势及其对 offer 接受率的影响，有助于制定更具竞争力的招聘策略。获取方式位于 Oracle HCM 招聘中申请的职位 offer 详情部分。示例 8500012000065000
	处理时间 ProcessingTime	单个活动的持续时间。
描述该指标代表在特定任务上花费的时间，计算为活动结束时间与开始时间之差。它衡量一个步骤的主动处理时长。此计算属性对于识别哪些具体活动最耗时至关重要。例如，它可以突出面试反馈提交是否耗时过长，或者 Offer 审批是否延误。这有助于将改进工作集中在最高效低下的步骤上。为何重要精准定位单个流程步骤的具体时长，从而识别并解决最耗时的活动。获取方式在数据转换期间，通过从 EventEndTime 中减去活动的 EventTime 来计算。示例 360086400604800
	工作地点 JobLocation	职位所在的地理位置或办公室。
描述此属性指定与职位申请相关的城市、省/州或国家。它还可以指示该职位是否为远程办公。这一维度支持对招聘流程进行区域分析。它可以帮助解答诸如不同地点的招聘周期是否存在显著差异，或者某些地区的候选人流失率是否更高。这对于针对特定劳动力市场量身定制招聘策略非常有用。为何重要支持对招聘指标进行地理位置分析，有助于识别不同地区在招聘表现和挑战方面的差异。获取方式存储在 Oracle HCM Recruiting 的职位申请对象中。示例美国纽约英国伦敦远程加州旧金山
	拒绝原因 RejectionReason	候选人申请被拒绝的原因。
描述当申请转入“已拒绝”状态时，此属性提供了背景信息。原因可能包括“不符合企业文化”、“缺乏所需技能”或“已雇佣其他候选人”。分析流程不同阶段的拒绝原因可以提供极其宝贵的反馈。它可以突出职位描述的问题、预期不一致或筛选过程中的缺陷，从而帮助优化招聘策略并提高候选池的质量。为何重要深入了解候选人停止进度的原因，这对于改进职位描述、筛选标准和提升整体流程有效性至关重要。获取方式通常在招聘专员或招聘经理在 Oracle HCM Recruiting 中拒绝候选人时，记录在特定字段或备注部分。示例不符合最低任职资格选择了更合适的候选人薪酬期望不匹配
	招聘周期目标 TimeToHireTarget	填补该职位申请的目标时长（天数）。
描述此属性定义了完成招聘流程的预期时间范围，从发布职位到候选人接受 Offer。该目标通常基于岗位级别或部门标准设定。这对于“招聘周期目标达成率”这一 KPI 至关重要。通过将实际招聘周期与此目标进行对比，组织可以衡量其相对于战略目标的绩效，并主动识别那些有延期风险的职位申请。为何重要提供衡量实际招聘周期绩效的基准，直接支持目标达成率的 KPI 计算。获取方式这可能是 Oracle HCM Recruiting 中职位申请对象上的一个字段，也可能在单独的系统中维护。示例 30456090
	招聘需求ID JobRequisitionId	候选人申请职位的唯一标识符。
描述职位申请 ID 将多个职位申请链接到单个已批准的职位空缺。它代表了招聘流程的需求端。此属性对于聚合申请 data 以分析特定招聘工作的整体健康状况至关重要。通过它，可以分析有多少候选人处于该岗位的候选池中、该岗位的渠道有效性以及填补该职位所需的总时间。为何重要将同一职位空缺的所有申请分组，支持对特定职位的整个招聘流水线进行分析。获取方式这是职位申请对象上的一个主键，链接到 Oracle HCM Recruiting 中的每个申请。示例 REQ-2024-501REQ-2024-502REQ-2024-503
	是内部候选人 IsInternalCandidate	指示候选人是否为当前员工的标志。
描述此布尔属性用于区分内部候选人（现有员工）和外部候选人。内部和外部招聘流程通常具有不同的步骤、SLA 和成功率。分析此属性可以对内部调动和外部招聘流程进行比较。它可以帮助确定公司是否有效地实现了内部晋升，以及内部招聘流程是否比外部流程更高效。为何重要区分内部和外部候选人，因为两者的招聘路径和绩效指标通常差异巨大，这样可以实现更准确的分段分析。获取方式这通常是 Oracle HCM Recruiting 中候选人或申请资料上的一个标记。示例 truefalse
	是否返工 IsRework	指示某个活动是否正在第二次或随后多次执行的标志。
描述此计算属性用于识别在同一个 case 中活动重复的情况。例如，如果一个申请从“面试”回到“筛选”，然后再回到“面试”，则第二次“筛选”和“面试”活动将被标记为返工。分析返工是发现流程低效和隐性成本的关键。它有助于精准定位流程失效的环节，即需要重复执行步骤的地方。通过量化此类循环的频率和影响，这直接支持了“申请返工与瓶颈分析”Dashboard。为何重要识别流程中的低效环节和工作重复的循环，有助于发现隐藏成本和精简机会。获取方式在数据准备期间，通过检查给定 CaseId 是否已发生过相同活动来计算。示例 truefalse
	结束时间 EventEndTime	指示招聘活动何时完成的 timestamp。
描述结束时间标志着一项活动的完成。开始时间与结束时间之差代表单个活动的处理时间。在 Process Mining 中，这用于计算特定任务的时长，例如筛选申请或进行面试所需的时间。分析活动时长有助于识别在整个流程中哪些具体步骤最耗时。为何重要支持计算单个活动的持续时间，这是精准定位低效步骤和衡量任务级绩效的关键。获取方式可能存在于 event log 表中，或者可以从后续活动的开始时间推断得出。示例 2023-10-01T10:30:00Z2023-10-05T15:00:00Z2023-11-12T11:15:00Z

必填推荐可选

招聘与人才获取活动

这些是您事件日志中需要捕获的关键流程步骤和里程碑，以便准确进行流程发现和瓶颈识别。

6 推荐 8 可选

	活动	描述
	候选人已入职	代表招聘流程最终圆满结束。当候选人状态正式更改为“已雇佣”时发生此 event，并触发向核心 HR 部门的移交。
为何重要这是流程的主要成功结果。它作为计算招聘周期和其他关键效率指标的终点。获取方式这是 IRC_SUBMISSIONS 中职位申请记录上的一个关键状态更改。它由 Oracle Recruiting 中的“雇佣”或“移交给 HR”操作触发。捕获当招聘负责人执行最终的“雇佣”操作时记录。事件类型 explicit
	已发出 Offer	标志着正式向候选人发送录用通知。这是一个明确的 event，在招聘负责人通过 Oracle Recruiting 系统正式发送 Offer 时记录。
为何重要这是衡量 Offer 接受率以及从最终面试到 Offer 发送时长（候选人体验的关键部分）的关键里程碑。获取方式当职位 offer 状态更改为“已发出”或“已发送”时显式捕获。此操作的时间戳记录在 offer 对象上。捕获当招聘负责人执行“发送 Offer”操作时记录。事件类型 explicit
	已接受 Offer	表示候选人已正式接受职位 offer。当候选人通过职业门户接受，或招聘人员手动更新状态时，会捕获此事件。
为何重要这是流程中的主要成功里程碑。它是计算 Offer 接受率的基础，并标志着 Offer 发送后活动的开始。获取方式通过将 offer 记录上的状态更新为“已接受”来捕获。这可以由候选人在网上触发，或由招聘人员手动录入。捕获来自 offer 状态更改为“已接受”的时间戳。事件类型 explicit
	已收到申请	标志着候选人申请职位时创建了新的申请记录。当系统中首次创建申请记录时，通常会明确捕获此 event。
为何重要这是每个 case 的起点，对于计算端到端流程时长（如招聘周期）以及分析一段时间内的申请量至关重要。获取方式此 event 是从 Oracle Recruiting 中候选人提交记录的创建 timestamp 中捕获的，可能来自 IRC_SUBMISSIONS 之类的表。捕获来自职位申请记录的创建时间戳。事件类型 explicit
	申请已拒绝	表示公司已决定在流程的任何阶段不再继续推进该候选人。通过申请上的状态更改来捕获。
为何重要这是申请的一个常见终点。分析在哪个阶段发生拒绝是了解流失率和流程效率的关键。获取方式从职位申请上的任何最终状态更改（如“已拒绝”、“未被选中”或类似的配置值）推断得出。捕获根据职位申请状态更改为最终的“已拒绝”状态推断得出。事件类型 inferred
	面试已进行	标志着候选人面试的结束。通常在面试官或招聘负责人将预定面试的状态更新为“已完成”或“已进行”时推断得出。
为何重要这是招聘流程中的一个关键里程碑。从该活动到“Offer 已发送”的周期时间是一个关键绩效指标。获取方式根据 Oracle 招聘中已安排面试记录的状态更改推断得出。该状态更改的时间戳即为事件时间。捕获根据面试状态更改为“已完成”或“已结束”推断得出。事件类型 inferred
	Offer 已拒绝	代表候选人决定拒绝录用通知。这是 Offer 记录上的一个明确状态更改，通常伴有拒绝原因。
为何重要这是流程中的一个关键失败点。分析 Offer 被拒绝的时间和原因，可以深入了解薪酬竞争力和候选人体验。获取方式通过将 offer 记录上的状态更新为“已拒绝”或“候选人拒绝”来捕获。捕获来自 offer 状态更改为“已拒绝”的时间戳。事件类型 explicit
	Offer 详情已审批	代表录用通知发送给候选人之前的内部审批 workflow 已完成。这从 Offer 记录上的最终审批状态推断得出。
为何重要此活动有助于分析内部 Offer 审批流程的时长和效率，这可能是延误的一个主要来源。获取方式通过追踪 Oracle 招聘中职位 offer 记录的状态变更历史（何时进入“已批准”状态）推断得出。捕获从 offer 对象状态更改为“已批准”推断得出。事件类型 inferred
	已发起背景调查	标志着候选人接受 Offer 后启动背景调查。此 event 通常由状态更改或与第三方服务的集成触发。
为何重要此活动对于追踪 Offer 之后、入职之前的时间线以及确保合规性至关重要。此处的延误可能会影响候选人的入职日期。获取方式根据职位申请状态更改为“背景调查”推断得出，或通过向集成的背景调查供应商发出的 API 调用记录。捕获根据申请状态更改为“背景调查进行中”推断得出。事件类型 inferred
	申请已撤回	代表候选人决定退出该职位的考量。当申请状态更新为“候选人撤回”时捕获。
为何重要追踪撤回申请有助于识别候选人体验可能较差的阶段，这些阶段会导致高流失。这对于分析“候选人流失率”KPI 至关重要。获取方式根据职位申请状态更改为“已撤回”推断得出。这可以由候选人在门户中发起，或由招聘人员代表其发起。捕获根据职位申请状态更改为“候选人已撤回”推断得出。事件类型 inferred
	申请已筛选	代表招聘负责人对候选人申请进行的初步审查，以检查其基本资质。通常在申请状态从“新申请”变为“审核中”时推断得出。
为何重要分析该阶段的耗时有助于识别初步筛选过程中的瓶颈，同时也是衡量“申请筛选返工率”KPI 的关键。获取方式从 Oracle 招聘中职位申请状态字段的历史记录中推断得出。在 IRC_SUBMISSIONS 表历史记录中查找状态更改。捕获根据职位申请状态更改为“筛选中”或“审核中”推断得出。事件类型 inferred
	评估已完成	表示候选人已完成所需的预筛选评估，如技能测试或性格评估。当评估平台向 Oracle HCM 返回完成状态时，通常会记录此事件。
为何重要此活动有助于追踪候选人的参与度，并分析候选人完成评估所需的时间，这可能是一个流失点。获取方式通过集成第三方评估工具推送的状态更新，或招聘人员在候选人申请档案中手动更改的状态来捕获。捕获当评估供应商 API 更新候选人状态时记录。事件类型 explicit
	面试反馈已提交	表示面试官已在面试后提交了对候选人的反馈和评估。这是在保存反馈表时捕获的一个显式事件。
为何重要面试和反馈提交之间的延迟会显著减慢招聘过程。跟踪这一点有助于识别决策过程中的瓶颈。获取方式当面试官通过 Oracle 招聘门户提交评估时显式记录。使用反馈记录的创建时间戳。捕获来自面试反馈记录的创建时间戳。事件类型 explicit
	面试已安排	代表候选人面试在系统中正式排定的时间点。通常在创建面试并将其与职位申请关联时捕获。
为何重要追踪此项有助于衡量安排面试所需的时间，这是候选人体验和整体招聘周期的关键组成部分。获取方式此 event 在 Oracle Recruiting 的面试安排模块中明确记录。相关 data 可以在与职位申请关联的面试相关表中找到。捕获来自与申请关联的面试事件的创建记录。事件类型 explicit

推荐可选

提取指南

如何从 Oracle HCM 招聘中获取数据

步骤

导航至 OTBI：登录 Oracle HCM Cloud。使用导航菜单进入“工具”(Tools)，然后选择“报告和分析”(Reports and Analytics)。
创建新分析：在“报告和分析”工作区中，点击“创建”(Create) 并选择“分析”(Analysis)。请勿选择“报告”选项，因为“分析”提供了所需的灵活性。
选择主题领域：系统提示时，选择 'Recruiting - Recruiting Real Time' 主题领域。该数据模型包含所有必要的职位申请、面试和 offer 详情。
进入高级配置：选择主题领域后，您将进入分析编辑器。点击右上角的“高级”(Advanced) 选项卡。这里可以直接操作逻辑 SQL 查询。
粘贴逻辑 SQL：在 'Analysis XML' 部分，找到 saw:query 标签。将该标签内的现有 SQL 查询替换为本文档“查询”部分提供的完整逻辑 SQL。务必替换整个默认查询。
设置日期范围参数：在运行查询前，将 [Start Date] 和 [End Date] 占位符替换为您所需的日期范围（格式为 'YYYY-MM-DD'）。这对于控制提取的数据量至关重要。
验证查询：点击“验证 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 查询示例 config

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。此外，您还需要 Oracle HCM Cloud 实例的有效用户凭证（用户名和密码）和主机名，且具有访问 Recruiting REST API 的权限。
脚本初始化：创建一个新的 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 作为“申请已收到”。遍历 Phases 数组，根据进入每个阶段的时间戳创建“申请已筛选”、“面试已安排”、“候选人已录用”、“申请已拒绝”等记录。类似地，遍历 Offers 数组生成“Offer 已发出”、“Offer 已接受”和“Offer 已拒绝”事件。
构建事件日志：每生成一个活动事件，将其存储为一个字典，键名对应于事件日志列标题（JobApplicationId、ActivityName、EventTime 等）。将每个字典追加到一个主列表中，构成完整的事件日志。
导出为 CSV：分页循环结束后，使用 Python 内置的 csv 模块将事件字典主列表写入 CSV 文件。确保文件采用 UTF-8 编码，且 CSV 文件中的标题与 ProcessMind 导入所需的属性名称完全匹配。

配置

API 凭证：需要一个专用的服务账号，并被授予访问 Recruiting REST API 的角色，例如“招聘经理”或具有“Recruiting REST API Access”权限的自定义角色。
API 端点：主要使用的端点是 recruitingCEJobApplications。关键是要使用 expand 查询参数（例如 expand=Phases,Offers），以便在单次调用中检索包含状态历史和 offer 详情的嵌套对象，这种方式效率更高。
日期范围筛选：使用 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()

您的招聘与人才获取 data 模板

您的招聘与人才获取 data 模板

招聘与人才获取属性

招聘与人才获取活动

提取指南

用于招聘 data 导出的 Oracle HCM OTBI 报表

步骤

配置

a 查询示例 config

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

步骤

配置

a 查询示例 python

准备好开始了吗？

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

您的招聘与人才获取 data 模板

您的招聘与人才获取 data 模板

招聘与人才获取属性

招聘与人才获取活动

提取指南

用于招聘 data 导出的 Oracle HCM OTBI 报表

步骤

配置

a 查询示例 config

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

步骤

配置

a 查询示例 python

我们重视您的隐私

准备好开始了吗？

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