簡介

雲端 HCM 提供使用具有讀取最佳化資料存放區的新一代平台，從 HCM 擷取資料的功能。

目標

完成本教學課程後，您將瞭解如何：

• 查詢擷取視觀表及其物件的階層
• 以非同步方式提交並追蹤擷取工作要求，以擷取選取的資料
• 下載擷取輸出檔案

必要條件

在您開始之前：

1. 請聯絡 Oracle CoE，確定您的 Pod 中已佈建讀取最佳化資料存放區，並且正在複製您的資料
2. 執行必要的安全組態，包括：
   • 資料安全性設定
   • OAuth 用戶端應用程式設定

請參閱設定從 HCM 讀取最佳化資料存放區擷取資料的安全性教學課程。

使用案例

此功能可讓您解決下列使用案例。

完整資料擷取

選取資料的完整擷取可以是單次或定期活動。

您可以擷取整個物件階層或僅擷取其子集。

完整資料擷取會擷取符合篩選準則的所有記錄，而輸出檔案可能會非常大。

系統將從要求的生效日期擷取生效日期，其中預設為目前擷取日期。

增量資料擷取

所選資料的遞增擷取通常是定期的排定活動。

您可以擷取整個物件階層或僅擷取其子集。

在此使用案例中，您只要擷取自上次擷取執行後變更的物件，其中第一個擷取執行是基準線。若要達到此目的，必須將 timeUpdated 屬性篩選套用至任何受變更偵測影響的層次。

增量資料擷取查詢可套用其他篩選準則。輸出檔案通常會比完整擷取小，因為它們只會包含差異。

只會擷取目前的屬性值。

系統將從要求的生效日期擷取生效日期，其中預設為目前擷取日期。

警示：

將不會使用 timeUpdated 篩選傳回實體刪除的記錄。

作業 1：選擇擷取檢視

根據必要的物件和屬性，選擇要使用的擷取檢視。以下為自版本 26B 起的可用檢視，以及可擷取的物件與屬性 (依模組分組)。

對於生效日期物件，您通常會發現一般檢視，此檢視會傳回自指定日期起生效的資料，另外也會傳回所有生效日期記錄的歷史記錄檢視。

多國語言：

可翻譯的屬性目前只能使用英文。

全域 HR - 僱用

模組名稱	oraHcmHrCoreEmployment
模組相關資訊環境路徑	hcmHrCore/employment

視觀表名稱	屬性
actionExtracts	ID 代碼 startDate endDate 名稱 描述 timeCreated timeUpdated createdBy updatedBy
動作發生擷取	id actionDate actionTypeCode categoryCode createdBy entityType freezeStartDate freezeUntilDate howToProcess parentEntityType proposedActionType proposedStartDate proposedWorkerType submittedBy timeCreated timeUpdated updatedBy actionReason.id actionReason.code actionReason.name action.id action.code action.name
動作原因擷取	id code name createdBy description endDate startDate timeCreated timeUpdated updatedBy
assignmentStatusTypeExtracts	id userStatus assignmentStatusCode activeFlag defaultFlag fromDate toDate timeCreated timeUpdated createdBy updatedBy
contractExtracts	id endDate contractNumber contractualJobTitle description documentStatus documentStatusChangeDate duration durationUnits effectiveEndDate effectiveStartDate endReason extensionPeriod extensionPeriodUnits extensionReason numberOfExtensions parties reference startReason statusReason createdBy timeCreated timeUpdated updatedBy type.lookupCode type.lookupType type.meaning country.territoryCode country.territoryShortName workRelationship.id workRelationship.startDate workRelationship.workerType personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate assignment.id assignment.effectiveStartDate assignment.effectiveEndDate assignment.effectiveSequence assignment.effectiveLatestChange assignment.assignmentType assignment.businessTitle assignment.assignmentNumber assignment.primaryFlag assignment.assignmentStatusType
文件記錄摘錄	id comments createdBy creationSource dateFrom dateTo documentCode documentName documentNumber issuedDate issuingAuthority issuingCountry issuingLocation publish publishDate relatedObjectName status tagList timeCreated timeUpdated updatedBy verifiedBy verifiedDate personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate assignment.id assignment.effectiveStartDate assignment.effectiveEndDate assignment.effectiveSequence assignment.effectiveLatestChange assignment.assignmentType assignment.businessTitle assignment.assignmentNumber assignment.primaryFlag assignment.assignmentStatusType
文件記錄類型摘錄	id activeInactiveFlag archiveCriteriaBasis archiveCriteriaDays authorizationRequired biReportPath categoryCode commentsLabel commentsRequired createdBy dateFromLabel dateFromRequired dateToLabel dateToRequired description documentNameLabel documentNameRequired documentNumberLabel documentNumberRequired documentType documentTypeLevel hierarchyCode issuedDateLabel issuedDateRequired issuingAuthorityLabel issuingAuthorityRequired issuingCountryLabel issuingCountryRequired issuingLocationLabel issuingLocationRequired legislationCode lockCreate lockCreateRoleList lockDelete lockDeleteRoleList lockUpdate lockUpdateRoleList minimumAttachmentsCount multipleOccurencesFlag publishRequired purgeArchiveCriteriaDays subCategoryCode systemDocumentType tagList timeCreated timeUpdated updatedBy warningPeriod
emailExtracts	id fromDate toDate type emailAddress primaryFlag createdBy timeCreatedBy updatedBy timeUpdated personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
legislativeInformationExtracts	id effectiveStartDate effectiveEndDate 性別 maritalStatus maritalStatusChangeDate highestEducationLevel createdBy timeCreated updatedBy timeUpdated legislation.territoryCode legislation.territoryShortName personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
legislativeInformationHistoryExtracts	id effectiveStartDate effectiveEndDate 性別 婚姻狀態 maritalStatusChangeDate highestEducationLevel createdBy timeCreated updatedBy timeUpdated legislation.territoryCode legislation.territoryShortName personDetail.id personDetail.personNumber
managerHierarchyExtracts	effectiveStartDate effectiveEndDate personId assignmentId managerType managerLevel managerId managerAssignmentId primaryAssignmentFlag primaryManagerFlag createdBy timeCreated updatedBy timeUpdated personAssignment.id personAssignment.effectiveStartDate personAssignment.effectiveEndDate personAssignment.effectiveSequence personAssignment.effectiveLatestChange personAssignment.assignmentType personAssignment.assignmentNumber personAssignment.primaryFlag personAssignment.businessTitle personAssignment.workAtHomeFlag personAssignment.officeBuilding personAssignment.officeFloor personAssignment.officeMailStop personAssignment.officeNumber personAssignment.primaryAssignmentFlag personAssignment.primaryWorkRelationshipFlag personAssignment.timeUpdated personAssignment.updatedBy personAssignment.timeCreated personAssignment.createdBy personAssignment.systemPersonType personAssignment.labourUnionMemberFlag personAssignment.managerFlag personAssignment.probationEndDate personAssignment.probationPeriod personAssignment.probationPeriodUnit personAssignment.normalHours personAssignment.frequency personAssignment.endTime personAssignment.startTime personAssignment.noticePeriod personAssignment.noticePeriodUOM personAssignment.workerCategory personAssignment.assignmentCategory personAssignment.hourlyPaidOrSalaried personAssignment.projectedEndDate personAssignment.projectedStartDate personAssignment.assignmentStatusType personAssignment.retirementAge personAssignment.retirementDate personAssignment.synchronizeFromPositionFlag personAssignment.fullTimeOrPartTime personAssignment.permanentAssignmentFlag personAssignment.seniorityBasis personAssignment.overtimePeriod personAssignment.adjustedFullTimeEquivalent personAssignment.annualWorkingDuration personAssignment.annualWorkingDurationUnit personAssignment.annualWorkingRatio personAssignment.standardFrequency personAssignment.standardWorkingHours personAssignment.standardAnnualWorkingDuration personAssignment.sequence personAssignment.department.id personAssignment.department.name personAssignment.department.title personAssignment.department.effectiveStartDate personAssignment.department.effectiveEndDate personAssignment.legalEmployer.id personAssignment.legalEmployer.name personAssignment.legalEmployer.effectiveStartDate personAssignment.legalEmployer.effectiveEndDate personAssignment.legislation.territoryCode personAssignment.legislation.territoryShortName personAssignment.position.id personAssignment.position.effectiveStartDate personAssignment.position.effectiveEndDate personAssignment.position.name personAssignment.position.code personAssignment.grade.id personAssignment.grade.effectiveStartDate personAssignment.grade.effectiveEndDate personAssignment.grade.name personAssignment.grade.code personAssignment.location.id personAssignment.location.effectiveStartDate personAssignment.location.effectiveEndDate personAssignment.location.name personAssignment.location.code personAssignment.location.mainAddress.id personAssignment.location.mainAddress.effectiveStartDate personAssignment.location.mainAddress.effectiveEndDate personAssignment.location.mainAddress.county personAssignment.location.mainAddress.state personAssignment.location.mainAddress.province personAssignment.location.mainAddress.townOrCity personAssignment.location.mainAddress.postalCode personAssignment.location.mainAddress.longPostalCode personAssignment.location.mainAddress.addressLine1 personAssignment.location.mainAddress.addressLine2 personAssignment.location.mainAddress.addressLine3 personAssignment.location.mainAddress.addressLine4 personAssignment.location.mainAddress.country.territoryCode personAssignment.location.mainAddress.country.territoryShortName personAssignment.job.id personAssignment.job.effectiveStartDate personAssignment.job.effectiveEndDate personAssignment.job.name personAssignment.job.code personAssignment.job.jobFunctionCode personAssignment.job.managerLevel personAssignment.job.jobFamily.id personAssignment.job.jobFamily.effectiveStartDate personAssignment.job.jobFamily.effectiveEndDate personAssignment.job.jobFamily.code personAssignment.job.jobFamily.name personAssignment.collectiveAgreement.id personAssignment.collectiveAgreement.effectiveStartDate personAssignment.collectiveAgreement.effectiveEndDate personAssignment.collectiveAgreement.name personAssignment.personType.id personAssignment.personType.userPersonType personAssignment.workerUnion.id personAssignment.workerUnion.effectiveStartDate personAssignment.workerUnion.effectiveEndDate personAssignment.workerUnion.name personAssignment.assignmentUserStatus.id personAssignment.assignmentUserStatus.userStatus personAssignment.businessUnit.id personAssignment.businessUnit.effectiveStartDate personAssignment.businessUnit.effectiveEndDate personAssignment.businessUnit.name personAssignment.account.codeCombinationId personAssignment.account.concatenatedSegments personAssignment.account.chartOfAccountsId personAssignment.ledger.ledgerId personAssignment.ledger.name personAssignment.workRelationship.id personAssignment.workRelationship.startDate personAssignment.workRelationship.workerType personAssignment.workRelationship.timeCreated personAssignment.workRelationship.timeUpdated personAssignment.localName.id personAssignment.localName.effectiveStartDate personAssignment.localName.effectiveEndDate personAssignment.localName.lastName personAssignment.localName.firstName personAssignment.localName.displayName personAssignment.localName.listName personAssignment.localName.timeCreated personAssignment.localName.timeUpdated personAssignment.globalName.id personAssignment.globalName.effectiveStartDate personAssignment.globalName.effectiveEndDate personAssignment.globalName.lastName personAssignment.globalName.firstName personAssignment.globalName.displayName personAssignment.globalName.listName personAssignment.globalName.timeCreated personAssignment.globalName.timeUpdated personAssignment.personDetail.id personAssignment.personDetail.personNumber personAssignment.personDetail.effectiveStartDate personAssignment.personDetail.effectiveEndDate personAssignment.personDetail.timeCreated personAssignment.personDetail.timeUpdated personAssignment.actionOccurrence.id personAssignment.peopleGroup.id
nameExtracts	id effectiveStartDate effectiveEndDate type lastName firstName middleNames title prefix suffix knownAs previousLastName honors militaryRank displayName fullName listName orderName createdBy timeCreated updatedBy timeUpdated legislation.territoryCode legislation.territoryShortName personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
nationalIdentifierExtracts	id createdBy expirationDate issueDate identifierNumber placeOfIssue timeCreated timeUpdated updatedBy country.territoryCode country.territoryShortName type.lookupCode type.lookupType type.meaning personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
人員群組摘錄	id createdBy enabledFlag endDateActive groupName startDateActive summaryFlag timeCreated timeUpdated updatedBy
personAddressExtracts	effectiveStartDate effectiveEndDate id type createdBy timeCreated timeUpdated updatedBy building floorNumber townOrCity postalCode longPostalCode addressLine1 addressLine2 addressLine3 addressLine4 county state province primaryFlag personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate country.territoryCode country.territoryShortName
personAddressHistoryExtracts	effectiveStartDate effectiveEndDate id type createdBy timeCreated timeUpdated updatedBy building floorNumber townOrCity postalCode longPostalCode addressLine1 addressLine2 addressLine3 addressLine4 county state province primaryFlag personDetail.id personDetail.personNumber country.territoryCode country.territoryShortName
personTypeExtracts	id userPersonType systemPersonType activeFlag defaultFlag timeCreated timeUpdated createdBy updatedBy
phoneExtracts	id fromDate toDate phoneNumber areaCode countryCodeNumber extension primaryFlag validity createdBy timeCreated updatedBy timeUpdated legislation.territoryCode legislation.territoryShortName type.lookupCode type.lookupType type.meaning personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
workerAssignmentExtracts	id effectiveStartDate effectiveEndDate effectiveSequence effectiveLatestChange assignmentType assignmentNumber primaryFlag businessTitle workAtHomeFlag officeBuilding officeFloor officeMailStop officeNumber primaryAssignmentFlag primaryWorkRelationshipFlag timeUpdated updatedBy timeCreated createdBy systemPersonType labourUnionMemberFlag managerFlag probationEndDate probationPeriod probationPeriodUnit normalHours frequency endTime startTime noticePeriod noticePeriodUOM workerCategory assignmentCategory hourlyPaidOrSalaried projectedEndDate projectedStartDate assignmentStatusType expenseCheckSendToAddress retirementAge retirementDate synchronizeFromPositionFlag fullTimeOrPartTime permanentAssignmentFlag seniorityBasis overtimePeriod adjustedFullTimeEquivalent annualWorkingDuration annualWorkingDurationUnit annualWorkingRatio standardFrequency standardWorkingHours standardAnnualWorkingDuration sequence department.id department.name department.title department.effectiveStartDate department.effectiveEndDate legalEmployer.id legalEmployer.name legalEmployer.effectiveStartDate legalEmployer.effectiveEndDate legislation.territoryCode legislation.territoryShortName position.id position.effectiveStartDate position.effectiveEndDate position.name position.code grade.id grade.effectiveStartDate grade.effectiveEndDate grade.name grade.code location.id location.effectiveStartDate location.effectiveEndDate location.name location.code location.mainAddress.id location.mainAddress.effectiveStartDate location.mainAddress.effectiveEndDate location.mainAddress.county location.mainAddress.state location.mainAddress.province location.mainAddress.townOrCity location.mainAddress.postalCode location.mainAddress.longPostalCode location.mainAddress.addressLine1 location.mainAddress.addressLine2 location.mainAddress.addressLine3 location.mainAddress.addressLine4 location.mainAddress.country.territoryCode location.mainAddress.country.territoryShortName job.id job.effectiveStartDate job.effectiveEndDate job.name job.code job.jobFunctionCode job.managerLevel job.jobFamily.id job.jobFamily.effectiveStartDate job.jobFamily.effectiveEndDate job.jobFamily.code job.jobFamily.name collectiveAgreement.id collectiveAgreement.effectiveStartDate collectiveAgreement.effectiveEndDate collectiveAgreement.name personType.id personType.userPersonType workerUnion.id workerUnion.effectiveStartDate workerUnion.effectiveEndDate workerUnion.name assignmentUserStatus.id assignmentUserStatus.userStatus businessUnit.id businessUnit.effectiveStartDate businessUnit.effectiveEndDate businessUnit.name account.codeCombinationId account.concatenatedSegments account.chartOfAccountsId ledger.ledgerId ledger.name workRelationship.id workRelationship.startDate workRelationship.workerType workRelationship.timeCreated workRelationship.timeUpdated localName.id localName.effectiveStartDate localName.effectiveEndDate localName.lastName localName.firstName localName.displayName localName.listName localName.timeCreated localName.timeUpdated globalName.id globalName.effectiveStartDate globalName.effectiveEndDate globalName.lastName globalName.firstName globalName.displayName globalName.listName globalName.timeCreated globalName.timeUpdated personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate personDetail.timeCreated personDetail.timeUpdated actionOccurrence.id peopleGroup.id
workerAssignmentHistoryExtracts	id effectiveStartDate effectiveEndDate effectiveSequence effectiveLatestChange assignmentType assignmentNumber primaryFlag businessTitle workAtHomeFlag officeBuilding officeFloor officeMailStop officeNumber primaryAssignmentFlag primaryWorkRelationshipFlag timeUpdated updatedBy timeCreated createdBy systemPersonType labourUnionMemberFlag managerFlag probationEndDate probationPeriod probationPeriodUnit normalHours frequency endTime startTime noticePeriod noticePeriodUOM workerCategory assignmentCategory hourlyPaidOrSalaried projectedEndDate projectedStartDate assignmentStatusType expenseCheckSendToAddress retirementAge retirementDate synchronizeFromPositionFlag fullTimeOrPartTime permanentAssignmentFlag seniorityBasis overtimePeriod adjustedFullTimeEquivalent annualWorkingDuration annualWorkingDurationUnit annualWorkingRatio standardFrequency standardWorkingHours standardAnnualWorkingDuration sequence department.id legalEmployer.id legislation.territoryCode legislation.territoryShortName position.id grade.id location.id location.mainAddress.id location.mainAddress.country.territoryCode location.mainAddress.country.territoryShortName job.id job.jobFamily.id collectiveAgreement.id personType.id personType.userPersonType workerUnion.id assignmentUserStatus.id assignmentUserStatus.userStatus businessUnit.id account.codeCombinationId account.concatenatedSegments account.chartOfAccountsId ledger.ledgerId ledger.name workRelationship.id localName.id globalName.id personDetail.id personDetail.personNumber actionOccurrence.id peopleGroup.id
worker 擷取	id personDetail.id personDetail.effectiveStartDate personDetail.effectiveEndDate personDetail.personNumber personDetail.primaryNationalIdentifier.id personDetail.primaryNationalIdentifier.identifierNumber personDetail.primaryEmail.id personDetail.primaryEmail.emailAddress personDetail.primaryPhone.id personDetail.primaryPhone.phoneNumber personDetail.primaryPhone.areaCode personDetail.primaryPhone.countryCodeNumber personDetail.primaryPhone.extension personDetail.mailingAddress.id personDetail.mailingAddress.effectiveStartDate personDetail.mailingAddress.effectiveEndDate personDetail.mailingAddress.addressLine1 personDetail.mailingAddress.addressLine2 personDetail.mailingAddress.addressLine3 personDetail.mailingAddress.addressLine4 personDetail.mailingAddress.building personDetail.mailingAddress.floorNumber personDetail.mailingAddress.townOrCity personDetail.mailingAddress.county personDetail.mailingAddress.state personDetail.mailingAddress.province personDetail.mailingAddress.postalCode personDetail.mailingAddress.longPostalCode personDetail.mailingAddress.country.territoryCode personDetail.mailingAddress.country.territoryShortName personDetail.localName.id personDetail.localName.effectiveStartDate personDetail.localName.effectiveEndDate personDetail.localName.lastName personDetail.localName.firstName personDetail.localName.displayName personDetail.localName.listName personDetail.globalName.id personDetail.globalName.effectiveStartDate personDetail.globalName.effectiveEndDate personDetail.globalName.lastName personDetail.globalName.firstName personDetail.globalName.displayName personDetail.globalName.listName
workRelationshipExtracts	id startDate workerType timeCreated timeUpdated workerNumber primaryFlag createdBy updatedBy readyToConvertFlag enterpriseSeniorityDate legalEmployerSeniorityDate onMilitaryServiceFlag lastWorkingDate terminationDate notificationDate projectedTerminationDate legalEmployer.id legalEmployer.name legalEmployer.effectiveStartDate legalEmployer.effectiveEndDate legislation.territoryCode legislation.territoryShortName personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate

全域 HR - 工作結構

模組名稱	oraHcmHrCoreWorkStructures
模組相關資訊環境路徑	hcmHrCore/workStructures

視觀表名稱	屬性
gradeExtracts	id code effectiveStartDate effectiveEndDate 狀態 timeUpdated updatedBy timeCreated createdBy name actionOccurrence.id
gradeHistoryExtracts	id code effectiveStartDate effectiveEndDate 狀態 timeUpdated updatedBy timeCreated createdBy name actionOccurrence.id
職等階梯擷取	id effectiveStartDate effectiveEndDate activeStatus allowProgressionOverrideFlag allowSalaryOverrideFlag autoProgressionCode autoSalaryChangeCode createdBy groupCode gradeType name progressionDateCode progressionStyleCode rateChangeDateCode salaryAdjustmentTypeCode salaryCalculationMethodCode salaryChangeDateCode salaryUpdateMethodCode stepDeterminationCode timeCreated timeUpdated updateSalaryFlag updatedBy actionOccurrence.id
jobExtracts	id effectiveStartDate effectiveEndDate code status createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
jobFamilyExtracts	id effectiveStartDate effectiveEndDate code status createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
jobFamilyHistoryExtracts	id effectiveStartDate effectiveEndDate code status createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
jobHistoryExtracts	id effectiveStartDate effectiveEndDate code status createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
legislativeDataGroupExtracts	id name createdBy timeCreated timeUpdated updatedBy country.territoryCode country.territoryShortName
地點地址摘錄	id effectiveStartDate effectiveEndDate type building floorNumber townOrCity countryCode postalCode longPostalCode addressLine1 addressLine2 addressLine3 addressLine4 county state province createdBy updatedBy timeCreated timeUpdated addressCreatedBy addressTimeCreated addressTimeUpdated addressUpdatedBy
locationExtracts	id code createdBy timeCreated updatedBy timeUpdated employeeLocationFlag effectiveStartDate effectiveEndDate countryCode status shipToSiteFlag receivingSiteFlag billToSiteFlag officeSiteFlag detailCreatedBy detailTimeCreated detailUpdatedBy detailTimeUpdated timezoneCode description name actionOccurrence.id mainAddress.id mainAddress.effectiveStartDate mainAddress.effectiveEndDate
locationHistoryExtracts	id code createdBy timeCreated updatedBy timeUpdated employeeLocationFlag effectiveStartDate effectiveEndDate countryCode 狀態 shipToSiteFlag receivingSiteFlag billToSiteFlag officeSiteFlag detailCreatedBy detailTimeCreated detailUpdatedBy detailTimeUpdatedBy timezoneCode 說明 name actionOccurrence.id
organizationExtracts	id effectiveStartDate effectiveEndDate 名稱 標題 createdBy updatedBy timeCreated timeUpdated classifications.id classifications.effectiveStartDate classifications.effectiveEndDate classifications.code location.id location.effectiveStartDate location.effectiveEndDate location.name location.code
organizationHistoryExtracts	id effectiveStartDate effectiveEndDate 名稱 標題 createdBy updatedBy timeCreated timeUpdated classifications.id classifications.effectiveStartDate classifications.effectiveEndDate classifications.code location.id location.effectiveStartDate location.effectiveEndDate location.name location.code
positionExtracts	id effectiveStartDate effectiveEndDate code status hiringStatus createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
positionHistoryExtracts	id effectiveStartDate effectiveEndDate code status hiringStatus createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id

HCM 通用 - 事件

模組名稱	oraHcmHrCoreEvents
模組相關資訊環境路徑	hcmHrCore/events

視觀表名稱

屬性

objectChangeExtracts

id sourceObjectName groupSequence operationType dateEffectiveMode effectiveDate keyAttribute1Name keyAttribute1DataType keyAttribute1StringValue keyAttribute1NumberValue keyAttribute1DateValue keyAttribute2Name keyAttribute2DataType keyAttribute2StringValue keyAttribute2NumberValue keyAttribute2DateValue keyAttribute3Name keyAttribute3DataType keyAttribute3StringValue keyAttribute3NumberValue keyAttribute3DateValue purgeDate createdBy timeCreated updatedBy timeUpdated changeComponents.id changeComponents.physicalType changeComponents.logicalType changeComponents.oldEffectiveStartDate changeComponents.newEffectiveStartDate changeComponents.oldEffectiveEndDate changeComponents.newEffectiveEndDate changeComponents.oldEffectiveSequence changeComponents.newEffectiveSequence changeComponents.createdBy changeComponents.timeCreated changeComponents.updatedBy changeComponents.timeUpdated changeComponents.changedAttributes.changedAttributesXml

薪資 - 餘額定義

模組名稱	oraHcmPayrollBalanceDefinitions
模組相關資訊環境路徑	hcmPayroll/balanceDefinitions

視觀表名稱	屬性
balance 屬性預設擷取	id createdBy legislationCode timeCreated timeUpdated updatedBy legislativeDataGroup.id balanceDimension.id attributeExclusion.id
balance 屬性擷取	id createdBy legislationCode timeCreated timeUpdated updatedBy legislativeDataGroup.id definedBalance.id attributeExclusion.id
balanceDimension 擷取	id code legislationCode dimensionLevel dimensionType periodType baseDatabaseItemSuffix description paymentsFlag expiryCheckingLevel feedCheckingType initialDate timeUpdated timeCreated timePeriod.id timePeriod.name initialTimeDefinition.id initialTimeDefinition.name expiryTimeDefinition.id expiryTimeDefinition.name startTimeDefinition.id startTimeDefinition.name endTimeDefinition.id endTimeDefinition.name legislativeDataGroup.id legislativeDataGroup.name assignmentActionBalanceDimension.id
balance 擷取	id code currencyCode 說明 名稱 remunerationFlag reportingName timeCreated timeUpdated uomCode legislationCode createdBy updatedBy comments baseBalanceType.id baseBalanceType.name inputValue.id inputValue.effectiveStartDate inputValue.effectiveEndDate legislativeDataGroup.id
balanceGroupAttributeExclusionExtract	id code alterable legislationCode groupLevelFlag timeCreated timeUpdated createdBy updatedBy balanceDimension.id legislativeDataGroup.id legislativeDataGroup.name
balanceGroupAttributeInclusionExtract	id legislationCode timeCreated timeUpdated balanceGroup.id attributeExclusion.id legislativeDataGroup.id legislativeDataGroup.name
balanceGroup 擷取	ID 代碼 legislationCode balanceCategoryAttributeFlag balanceDimensionAttributeFlag groupLevelFlag timeCreated timeUpdated legislativeDataGroup.id
balanceGroupUsage 擷取	id balanceReportType createdBy description formatType legislationCode timeCreated timeUpdated updatedBy code name balanceGroup.id legialtiveDataGroup.id
balanceReportSortItemExtract	id createdBy legislationCode timeCreated timeUpdated updatedBy sequenceNumber legialtiveDataGroup.id
已定義餘額摘錄	id legislationCode grossupAllowedFlag grossupExcludeByDefault saveRunBalance timeCreated timeUpdated balanceType.id balanceType.name balanceDimension.id legislativeDataGroup.id
dimensionUsageExtract	ID name databaseItemSuffix legislationCode useInExceptionReportingFlag timeCreated timeUpdated balanceDimension.id legislativeDataGroup.id

薪資 - 元素定義

模組名稱	oraHcmPayrollElementDefinitions
模組相關資訊環境路徑	hcmPayroll/elementDefinitions

視觀表名稱	屬性
elementClassification 擷取	id code costableFlag costingDebitOrCredit createByDefaultFlag createdBy dateFrom dateTo defaultHighPriority defaultLowPriority defaultPriority description distributableOverFlag frequencyRuleEnabledFlag legislationCode name nonPaymentsFlag processWhenEarningFlag secondaryClassificationFlag timeCreated timeUpdated updatedBy baseClassification.id baseClassification.name parentClassification.id parentClassification.name legislativeDataGroup.id legislativeDataGroup.name
元素歷史擷取	id code effectiveStartDate effectiveEndDate grossupFlag indirectOnlyFlag inputCurrencyCode outputCurrencyCode iterativeFlag iterativePriority creatorType deductionOrExemption legislationCode multipleEntriesAllowedFlag onceEachPeriodFlag processInRunFlag processMode processingPriority processingType standardLinkFlag timeDefinitionType validationOverrideMessage closedForEntryFlag additionalEntryAllowedFlag timeUpdated updatedBy timeCreated createdBy category description expeditedMode name parentBaseElementName reportingName primaryClassification.id primaryClassification.name secondaryClassification.id secondaryClassification.name endingTimeDefinition.id endingTimeDefinition.name frequencyTimeDefinition.id frequencyTimeDefinition.name startingTimeDefinition.id startingTimeDefinition.name legislativeDataGroup.id legislativeDataGroup.name
輸入值歷史記錄擷取	id code createdBy defaultValue displaySequence effectiveEndDate effectiveStartDate forceRunResultValueFlag generateDatabaseItemsFlag hotDefaultFlag lookupType mandatoryFlag maximumValue minimumValue name reservedInputValue retroActiveStaticFlag timeCreated timeUpdated unitOfMeasure updatedBy userDisplayFlag userEnterableFlag validationOverrideMessage valueSetCode viewObjectName warningOrError element.id element.name

薪資 - 薪資定義

模組名稱	oraHcmPayrollDefinitions
模組相關資訊環境路徑	hcmPayroll/definitions

視觀表名稱	屬性
合併群組擷取	id code name timeCreated timeUpdated 說明 createdBy updatedBy legislativeDataGroup.id legislativeDataGroup.name
薪資歷史記錄摘錄	id effectiveStartDate effectiveEndDate name periodType firstPeriodEndDate numberOfYears periodResetYears cutoffDateOffset regularEarnDateOffset regularProcessDateOffset payslipViewDateOffset negativePayAllowedFlag timeCreated timeUpdated baseOffsets paymentDayType payslipAvailabilityDayType cutoffDayType payrollRunDayType earningsDayType payslipAvailabilityBaseDate cutoffBaseDate payrollRunBaseDate earningsBaseDate paymentBaseDate earningsOffsetDays paymentOffsetDays payslipAvailabilityOffsetDays cutoffOffsetDays payslipOffset earningsOffset processOffset cutoffOffset defaultPaydateOffset earningsFixedDate payslipAvailabilityFixedDate cutoffFixedDate payrollRunFixedDate paymentFixedDate reportingName processSubDateOffset plannedSubmissionDayType plannedSubmissionBaseDate processSubOffset plannedSubmissionFixedDate consolidationGroup.id consolidationGroup.name ledger.ledgerId timeDefinition.id timeDefinition.name legislativeDataGroup.id legislativeDataGroup.name
timeDefinitionExtract	id shortName name definitionType periodType periodUnit dayAdjustment legislationCode numberOfYears startDate creatorType dynamicCode timeCreated timeUpdated createdBy updatedBy baseTimeDefinition.name baseTimeDefinition.name periodTimeDefinition.id periodTimeDefinition.name legislativeDataGroup.id legislativeDataGroup.name
timePeriodExtract	id legislationCode endDate name periodNumber periodType startDate cutOffDate description periodSetName periodYear quarterNumber quickpayDisplayNumber runDisplayNumber status defaultPaydate regularProcessDate plannedSubmissionDate regularEarnDate yearNumber periodCategory payslipViewDate timeCreated timeUpdated createdBy updatedBy payroll.id payroll.effectiveStartDate payroll.effectiveEndDate payroll.name timeDefinition.id timeDefinition.name legislativeDataGroup.id legislativeDataGroup.name

薪資 - 薪資關係

模組名稱	oraHcmPayrollRelationships
模組相關資訊環境路徑	hcmPayroll/relationships

視觀表名稱	屬性
指定給薪明細歷史記錄摘錄	id effectiveStartDate effectiveEndDate timeCardRequiredFlag primaryFlag timeCreated timeUpdated updatedBy createdBy overtimePeriod.id overtimePeriod.name elementCriteria.id assignedPayroll.id assignedPayroll.payroll.id assignedPayroll.payroll.name assignedPayroll.legislativeDataGroup.id assignedPayroll.legislativeDataGroup.name assignedPayroll.payrollAssignment.id assignedPayroll.payrollAssignment.assignmentNumber assignedPayroll.payrollAssignment.startDate assignedPayroll.payrollAssignment.endDate assignedPayroll.payrollAssignment.payrollRelationship.id assignedPayroll.payrollAssignment.payrollRelationship.payrollRelationshipNumber assignedPayroll.payrollAssignment.payrollRelationship.person.id assignedPayroll.payrollAssignment.payrollRelationship.person.personNumber assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.id assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.lastName assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.firstName assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.displayName assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.listName assignedPayroll.payrollAssignment.payrollRelationship.payrollStatutoryUnit.id assignedPayroll.payrollAssignment.payrollRelationship.payrollStatutoryUnit.name assignedPayroll.payrollAssignment.assignment.id assignedPayroll.payrollAssignment.assignment.effectiveSequence assignedPayroll.payrollAssignment.assignment.effectiveLatestChange assignedPayroll.payrollAssignment.assignment.assignmentNumber assignedPayroll.payrollAssignment.assignment.businessTitle assignedPayroll.payrollAssignment.assignment.assignmentType assignedPayroll.payrollAssignment.assignment.assignmentStatusType assignedPayroll.payrollAssignment.assignment.systemPersonType assignedPayroll.payrollAssignment.assignment.primaryAssignmentFlag assignedPayroll.payrollAssignment.assignment.primaryWorkRelationshipFlag assignedPayroll.payrollAssignment.assignment.primaryFlag assignedPayroll.payrollAssignment.assignment.workerCategory assignedPayroll.payrollAssignment.assignment.assignmentCategory assignedPayroll.payrollAssignment.assignment.frequency assignedPayroll.payrollAssignment.assignment.timeUpdated assignedPayroll.payrollAssignment.assignment.timeCreated assignedPayroll.payrollAssignment.assignment.department.id assignedPayroll.payrollAssignment.assignment.department.name assignedPayroll.payrollAssignment.assignment.department.title assignedPayroll.payrollAssignment.assignment.legalEmployer.id assignedPayroll.payrollAssignment.assignment.legalEmployer.name assignedPayroll.payrollAssignment.assignment.legislation.territoryCode assignedPayroll.payrollAssignment.assignment.legislation.territoryShortName assignedPayroll.payrollAssignment.assignment.position.id assignedPayroll.payrollAssignment.assignment.position.name assignedPayroll.payrollAssignment.assignment.position.code assignedPayroll.payrollAssignment.assignment.grade.id assignedPayroll.payrollAssignment.assignment.grade.name assignedPayroll.payrollAssignment.assignment.grade.code assignedPayroll.payrollAssignment.assignment.location.id assignedPayroll.payrollAssignment.assignment.location.name assignedPayroll.payrollAssignment.assignment.location.code assignedPayroll.payrollAssignment.assignment.job.id assignedPayroll.payrollAssignment.assignment.job.name assignedPayroll.payrollAssignment.assignment.job.code assignedPayroll.payrollAssignment.assignment.businessUnit.id assignedPayroll.payrollAssignment.assignment.businessUnit.name assignedPayroll.payrollAssignment.assignment.workRelationship.id assignedPayroll.payrollAssignment.assignment.workRelationship.startDate assignedPayroll.payrollAssignment.assignment.workRelationship.enterpriseSeniorityDate assignedPayroll.payrollAssignment.assignment.workRelationship.primaryFlag assignedPayroll.payrollAssignment.assignment.workRelationship.workerNumber assignedPayroll.payrollAssignment.assignment.workRelationship.terminationDate assignedPayroll.payrollAssignment.assignment.workRelationship.legalEmployerSeniorityDate
已指派薪資摘錄	id createdBy endDate finalCloseDate firstStandardEarningDate lastStandardEarningDate lastStandardProcessDate startDate timeCreated timeUpdated updatedBy payroll.id payroll.name payroll.effectiveStartDate payroll.effectiveEndDate payrollTerm.id payrollAssignment.id payrollAssignment.assignmentNumber payrollAssignment.startDate payrollAssignment.endDate payrollAssignment.payrollRelationship.id payrollAssignment.payrollRelationship.payrollRelationshipNumber payrollAssignment.payrollRelationship.person.id payrollAssignment.payrollRelationship.person.personNumber payrollAssignment.payrollRelationship.person.effectiveStartDate payrollAssignment.payrollRelationship.person.effectiveEndDate payrollAssignment.payrollRelationship.person.globalName.id payrollAssignment.payrollRelationship.person.globalName.effectiveStartDate payrollAssignment.payrollRelationship.person.globalName.effectiveEndDate payrollAssignment.payrollRelationship.person.globalName.lastName payrollAssignment.payrollRelationship.person.globalName.firstName payrollAssignment.payrollRelationship.person.globalName.displayName payrollAssignment.payrollRelationship.person.globalName.listName payrollAssignment.payrollRelationship.payrollStatutoryUnit.id payrollAssignment.payrollRelationship.payrollStatutoryUnit.name payrollAssignment.payrollRelationship.payrollStatutoryUnit.effectiveStartDate payrollAssignment.payrollRelationship.payrollStatutoryUnit.effectiveEndDate payrollAssignment.assignment.id payrollAssignment.assignment.effectiveStartDate payrollAssignment.assignment.effectiveEndDate payrollAssignment.assignment.effectiveSequence payrollAssignment.assignment.effectiveLatestChange payrollAssignment.assignment.assignmentNumber payrollAssignment.assignment.businessTitle payrollAssignment.assignment.assignmentType payrollAssignment.assignment.assignmentStatusType payrollAssignment.assignment.systemPersonType payrollAssignment.assignment.primaryAssignmentFlag payrollAssignment.assignment.primaryWorkRelationshipFlag payrollAssignment.assignment.primaryFlag payrollAssignment.assignment.workerCategory payrollAssignment.assignment.assignmentCategory payrollAssignment.assignment.frequency payrollAssignment.assignment.timeUpdated payrollAssignment.assignment.timeCreated payrollAssignment.assignment.department.id payrollAssignment.assignment.department.name payrollAssignment.assignment.department.title payrollAssignment.assignment.department.effectiveStartDate payrollAssignment.assignment.department.effectiveEndDate payrollAssignment.assignment.legalEmployer.id payrollAssignment.assignment.legalEmployer.name payrollAssignment.assignment.legalEmployer.effectiveStartDate payrollAssignment.assignment.legalEmployer.effectiveEndDate payrollAssignment.assignment.legislation.territoryCode payrollAssignment.assignment.legislation.territoryShortName payrollAssignment.assignment.position.id payrollAssignment.assignment.position.effectiveStartDate payrollAssignment.assignment.position.effectiveEndDate payrollAssignment.assignment.position.name payrollAssignment.assignment.position.code payrollAssignment.assignment.grade.id payrollAssignment.assignment.grade.effectiveStartDate payrollAssignment.assignment.grade.effectiveEndDate payrollAssignment.assignment.grade.name payrollAssignment.assignment.grade.code payrollAssignment.assignment.location.id payrollAssignment.assignment.location.effectiveStartDate payrollAssignment.assignment.location.effectiveEndDate payrollAssignment.assignment.location.name payrollAssignment.assignment.location.code payrollAssignment.assignment.job.id payrollAssignment.assignment.job.effectiveStartDate payrollAssignment.assignment.job.effectiveEndDate payrollAssignment.assignment.job.name payrollAssignment.assignment.job.code payrollAssignment.assignment.businessUnit.id payrollAssignment.assignment.businessUnit.effectiveStartDate payrollAssignment.assignment.businessUnit.effectiveEndDate payrollAssignment.assignment.businessUnit.name payrollAssignment.assignment.workRelationship.id payrollAssignment.assignment.workRelationship.startDate payrollAssignment.assignment.workRelationship.enterpriseSeniorityDate payrollAssignment.assignment.workRelationship.primaryFlag payrollAssignment.assignment.workRelationship.workerNumber payrollAssignment.assignment.workRelationship.terminationDate payrollAssignment.assignment.workRelationship.legalEmployerSeniorityDate legislativeDataGroup.id legislativeDataGroup.name
payrollEmploymentDateExtract	ID createdBy dateValue sourceType timeCreated timeUpdated updatedBy assignedPayroll.id payrollTerm.id payrollTerm.assignmentNumber payrollAssignment.id payrollAssignment.assignmentNumber payrollRelationship.id payrollRelationship.payrollRelationshipNumber timeDefintion.id timeDefintion.name
給薪關係明細歷史記錄摘錄	id effectiveStartDate effectiveEndDate timeCreated timeUpdated updatedBy createdBy payrollRelationship.id payrollRelationship.createdBy payrollRelationship.endDate payrollRelationship.payrollRelationshipNumber payrollRelationship.startDate payrollRelationship.timeCreated payrollRelationship.timeUpdated payrollRelationship.updatedBy payrollRelationship.payrollStatutoryUnit.id payrollRelationship.payrollStatutoryUnit.name payrollRelationship.legislativeDataGroup.id payrollRelationship.legislativeDataGroup.name payrollRelationship.relationshipType.id payrollRelationship.relationshipType.name payrollRelationship.person.id payrollRelationship.person.personNumber payrollRelationship.person.globalName.id payrollRelationship.person.globalName.lastName payrollRelationship.person.globalName.firstName payrollRelationship.person.globalName.displayName payrollRelationship.person.globalName.listName overtimePeriod.id overtimePeriod.name elementCriteria.id
payrollRelationshipExtract	id createdBy endDate payrollRelationshipNumber startDate timeCreated timeUpdated updatedBy payrollStatutoryUnit.id payrollStatutoryUnit.name payrollStatutoryUnit.effectiveStartDate payrollStatutoryUnit.effectiveEndDate person.id person.personNumber person.effectiveStartDate person.effectiveEndDate person.globalName.id person.globalName.effectiveStartDate person.globalName.effectiveEndDate person.globalName.lastName person.globalName.firstName person.globalName.displayName person.globalName.listName legislativeDataGroup.id legislativeDataGroup.name relationshipType.id relationshipType.name
關係群組明細歷史記錄擷取	id effectiveStartDate effectiveEndDate timeCardRequiredFlag timeCreated timeUpdated updatedBy createdBy overtimePeriod.id overtimePeriod.name assignmentStatusType.id assignmentStatusType.assignmentStatusCode elementCriteria.id
關係群組擷取	id assignmentNumber createdBy endDate groupType startDate timeCreated timeUpdated updatedBy payrollRelationship.id payrollRelationship.payrollRelationshipNumber payrollTerm.id assignment.id assignment.effectiveStartDate assignment.effectiveEndDate assignment.effectiveSequence assignment.effectiveLatestChange assignment.assignmentNumber legalEmployer.id legalEmployer.name legalEmployer.effectiveStartDate legalEmployer.effectiveEndDate taxReportingUnit.id taxReportingUnit.name taxReportingUnit.effectiveStartDate taxReportingUnit.effectiveEndDate legislativeDataGroup.id legislativeDataGroup.name

薪資 - 個人付款方式

模組名稱	oraHcmPayrollPersonalPaymentMethods
模組相關資訊環境路徑	hcmPayroll/personalPaymentMethods

視觀表名稱	屬性
個人付款方式歷史記錄摘錄	id effectiveStartDate effectiveEndDate amount createdBy name paymentAmountType 百分比 優先順序 remainingAmountFlag timeCreated timeUpdated updatedBy legislativeDataGroup.id legislativeDataGroup.name payrollRelationship.id payrollRelationship.payrollRelationshipRelationshipNumber

薪資 - 處理流程任務

模組名稱	oraHcmPayrollProcessFlowTasks
模組相關資訊環境路徑	hcmPayroll/processFlowTasks

視觀表名稱	屬性
taskActionExtract	id activeIndicator code createdBy defaultActionFlag description executionMode legislationCode method name parentActionFlag actionSequence timeCreated timeUpdated type updatedBy baseTaskAction.id legislativeDataGroup.id legislativeDataGroup.name
任務擷取	id automaticFlag code createdBy defaultCategoryType defaultChecklistName defaultSubCategoryType description destinationUiUrl hideIncompleteActionFlag legislationCode name requestCategory submittingUserIndicator timeCreated timeUpdated type updatedBy baseTask.id baseTask.name legislativeDataGroup.id legislativeDataGroup.name

薪資 - 處理結果

模組名稱	oraHcmPayrollProcessResults
模組相關資訊環境路徑	hcmPayroll/processResults

視觀表名稱	屬性
payrollActionExtract	id actionPopulationStatus actionSequence actionStatus actionTypeCode batchProcessMode chequeProcedure costingProcessMode currentChunkNumber currentTask dateEarned displayRunNumber effectiveDate eftExpiryDate eftFileReference endChequeNumber endDate expediteFlag fileName futureProcessMode legislationCode legislativeParameters overrideDate overridingDdDate payPayeeType paymentReason processPhase startChequeNumber startDate timeCreated timeUpdated updatedBy payroll.id payroll.effectiveStartDate payroll.effectiveEndDate consolidationSet.id deductionTimePeriod.id earnTimePeriod.id legislativeDataGroup.id payrollAction.id
payrollRelationshipActionExtract	ID actionSequence actionStatusCode chunkNumber endDate serialNumber startDate parentObject processPath payrollAction.id payrollRelationship.id prepayment.id
人員結果訊息擷取	id lineSequence lineText messageLevel name sourceType payrollRelationshipAction.id payrollRelationshipAction.payrollAction.id payrollRelationshipAction.payrollAction.effectiveDate payrollRelationshipAction.payrollAction.dateEarned payrollRelationshipAction.payrollAction.startDate payrollRelationshipAction.payrollAction.endDate payrollRelationshipAction.payrollAction.payroll.id payrollRelationshipAction.payrollAction.payroll.effectiveStartDate payrollRelationshipAction.payrollAction.payroll.effectiveEndDate payrollRelationshipAction.payrollAction.payroll.name payrollRelationshipAction.payrollAction.actionType.lookupCode payrollRelationshipAction.payrollAction.actionType.lookupType payrollRelationshipAction.payrollAction.actionType.meaning payrollRelationshipAction.payrollAction.legislativeDataGroup.id payrollRelationshipAction.payrollAction.legislativeDataGroup.name payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.id payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.flowName payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.timeCreated payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.task.id payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.task.name payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.task.code payrollRelationshipAction.payrollRelationship.id payrollRelationshipAction.payrollRelationship.payrollRelationshipNumber payrollRelationshipAction.payrollRelationship.person.id payrollRelationshipAction.payrollRelationship.person.personNumber payrollRelationshipAction.payrollRelationship.person.effectiveStartDate payrollRelationshipAction.payrollRelationship.person.effectiveEndDate payrollRelationshipAction.payrollRelationship.person.globalName.id payrollRelationshipAction.payrollRelationship.person.globalName.effectiveStartDate payrollRelationshipAction.payrollRelationship.person.globalName.effectiveEndDate payrollRelationshipAction.payrollRelationship.person.globalName.lastName payrollRelationshipAction.payrollRelationship.person.globalName.firstName payrollRelationshipAction.payrollRelationship.person.globalName.displayName payrollRelationshipAction.payrollRelationship.person.globalName.listName payrollRelationshipAction.actionStatus.lookupCode payrollRelationshipAction.actionStatus.lookupType payrollRelationshipAction.actionStatus.meaning payroll.id payroll.effectiveStartDate payroll.effectiveEndDate payroll.name
處理結果訊息擷取	id lineSequence lineText messageLevel name sourceType payrollAction.id payrollAction.effectiveDate payrollAction.dateEarned payrollAction.payroll.id payrollAction.payroll.effectiveStartDate payrollAction.payroll.effectiveEndDate payrollAction.payroll.name payrollAction.actionType.lookupCode payrollAction.actionType.lookupType payrollAction.actionType.meaning payrollAction.legislativeDataGroup.id payrollAction.legislativeDataGroup.name payrollAction.payrollFlowActionStatistic.id payrollAction.payrollFlowActionStatistic.flowName payrollAction.payrollFlowActionStatistic.timeCreated payrollAction.payrollFlowActionStatistic.task.id payrollAction.payrollFlowActionStatistic.task.name payrollAction.payrollFlowActionStatistic.task.code payroll.id payroll.effectiveStartDate payroll.effectiveEndDate payroll.name

工作 2：準備與測試擷取查詢

每個擷取檢視都有一個查詢 API，可以建立和測試擷取查詢。

URL	/api/boss/data/objects/ora/{{moduleContextPath}}/v1/{{viewName}}/$query
HTTP 方法	POST
要求範本	{ "collection": { "limit": {{limit}}, "offset": {{offset}}, "sortBy": [ {{sortAttributes}} ], "filter": "{{topLevelFilter}}" }, "fields": [ {{topLevelAttributes}} ], "accessors": { "{{childObject}}": { "collection": { "filter": "{{childLevelFilter}}" }, "fields": [ {{childLevelAttributes}} ], "accessors": { {{nestedChildAccessors}} } }, ... } }
回應樣板	200 OK { "items": [ {{items}} ], "hasMore": {{hasMore}} }

物件和屬性

定義要擷取的資料，亦即應包含檢視的物件與屬性。包含子項物件需要新增 accessors，而包含特定欄位則需要在 fields 陣列中列出。請參閱完整範例。

警示：

如果您沒有明確指定子項 accessors 和 fields，將會取得檢視的預設形狀。請記住，預設形狀可能未包含檢視的所有可用物件和屬性。

篩選

定義資料篩選方式。您可以使用下列表示式來建立查詢的篩選。

目的	表示式	範例
相等測試	field = value	ename = 'KING'
不平等測試	field != value	activeFlag != true
大於測試 小於測試	field > value field < value	sal > 1999.99 hireDate < '2000-01-01' timeUpdated> '1900-01-01T13:51:54Z'
高於或等於測試 低於或等於測試	field >= value field <= value< code>	sal >= 1999.99 hireDate <= '2000-01-01' timeUpdated >= '1900-01-01T13:51:54Z'
樣式比對	field LIKE 'pattern'	job LIKE 'SALES%'
會員資格測試	field IN (value1, ..., valueN)	deptno IN (10, 20, 40)
不區分大小寫比較	field ~= value field ~!= value field ~> value field ~< value field ~>= value field ~<= value field ~LIKE 'pattern' field ~IN (value1, ..., valueN)	ename ~= 'king'
存在性測試 (適用於一對多關係)	child[expression]	assignments[startDate = null]
邏輯結合	expression AND expression
邏輯分離	expression OR expression
邏輯否定	!(expression)

依一對一關係中的下階物件篩選：

如果是一對一關係，您可以在篩選子句中參照子項物件及其屬性，就像其他父項物件的屬性一樣，例如 legalEmployer.id in (1001, 1002)。

篩選一對多關係中的子項物件：

在以複數存取子名稱表示的一對多關係罕見的情況下，上表中的存在測試將篩選至少具有一個下階符合準則的上階。不過，這並不表示如果擷取下階記錄，將會自動篩選。如果您想要確保只取得符合準則的下階記錄，則也必須在下階層級重複篩選。

例如，如果您只想擷取實體類型為 UPDATE 的變更元件，您必須在物件變更查詢中套用下列篩選：

{
    "collection": {
        "filter": "changeComponents[physicalType = 'UPDATE']"
    },
    "accessors": {
        "changeComponents": {
            "collection": {
                "filter": "physicalType = 'UPDATE'"
            },
...
                

依生效日期篩選：

如果是生效日期物件，依預設您將取得自目前日期起生效的資料。若要擷取自特定日期起生效的資料，請使用 $effectiveDate HTTP 查詢參數。

例如，如果您要擷取自 2023-01-01 起生效的資料，請使用下列 URL 進行查詢：

/api/boss/data/objects/ora/hcmHrCore/employment/v1/{{viewPath}}/$query?$effectiveDate=2023-01-01

排序

定義資料的排序方式。排序是以包含排序方向 (asc 或 desc) 的排序屬性陣列來表示。舉例而言：

"sortBy": [
    {
        "totalAmount": "desc"
    },
    {
        "paidAmount": "asc"
    }
]

分頁

定義資料分頁的方式。從屬端可以提供限制和偏移參數來控制分頁。舉例而言：

"limit": 200,
"offset": 400

預設限制為 25，上限為 1000。

預設偏移量為 0，代表結果的開頭。

回應中的最上層 hasMore 屬性會指出是否有更多要擷取的結果。

不應使用分頁作為擷取資料的替代方式。查詢此 API 時，無法保證資料不會在要求之間變更。使用非同步 API 擷取資料。

範例

下方的範例擷取查詢旨在擷取指派資訊以及法定雇主與部門詳細資料，如下所示：

• 是主要指派
• 類型為 Employee
• 不屬於 ID 為 10001 與 10002 的法定雇主
• 自擷取日期起生效
• 自上次執行後已更新 (或已建立)

要求範例

請注意具有上一個擷取執行之時戳的 limit 參數和 timeUpdated 屬性條件。

POST /api/boss/data/objects/ora/hcmHrCore/employment/v1/workerAssignmentExtracts/$query
 
{
    "collection": {
        "limit": 10,
        "filter": "primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))"
    },
    "fields": [ "id", "assignmentType", "assignmentStatusType", "effectiveStartDate", "effectiveEndDate", "businessTitle", "workAtHomeFlag", "assignmentNumber", "timeUpdated" ],
    "accessors": {
        "personDetail": {
            "fields": [ "personNumber" ]
        },
        "globalName": {
            "fields": [ "firstName", "lastName" ]
        },
        "department": {
            "fields": [ "id", "name", "title" ]
        },
        "legalEmployer": {
            "fields": [ "id", "name" ]
        },
        "workRelationship": {
            "fields": [ "id" ]
        }
    }
}
				

回應範例

200 OK
 
{
    "items": [
        {
            "id": "300000795682243",
            "assignmentType": "E",
            "assignmentStatusType": "ACTIVE",
            "effectiveStartDate": "2018-06-14",
            "effectiveEndDate": "4712-12-31",
            "businessTitle": "Aeronautical Engineer Level-9352",
            "workAtHomeFlag": false,
            "assignmentNumber": "EHDLWorker_190903_1637",
            "timeUpdated": "2025-05-06T11:42:17.821Z",
            "$id": "300000795682243",
            "$context": {
                "etag": "89"
            },
            "personDetail": {
                "personNumber": "HDLWorker_190903_1637",
                "$id": "100000329366771",
                "$context": {
                    "etag": ""
                }
            },
            "globalName": {
                "firstName": "Raymond-Olivier",
                "lastName": "Beer-Tröst",
                "$id": "300000795668871",
                "$context": {
                    "etag": ""
                }
            },
            "department": {
                "id": "300000044556980",
                "name": "South - Venaria DC-GROUP/SFIELESOIT74155",
                "title": null,
                "$id": "300000044556980",
                "$context": {
                    "etag": "13",
                    "links": {
                        "$self": {
                            "href": "https://example.com/api/boss/data/objects/ora/hcmHrCore/workStructures/v1/departments/300000044556980?$effectiveDate=2025-05-13"
                        }
                    }
                }
            },
            "legalEmployer": {
                "id": "300000046740247",
                "name": "PSR_US_LE_1",
                "$id": "300000046740247",
                "$context": {
                    "etag": "15",
                    "links": {
                        "$self": {
                            "href": "https://example.com/api/boss/data/objects/ora/hcmHrCore/workStructures/v1/legalEmployers/300000046740247?$effectiveDate=2025-05-13"
                        }
                    }
                }
            },
            "workRelationship": {
                "id": "100000329414679",
                "$id": "100000329414679",
                "$context": {
                    "etag": "1"
                }
            }
        },
        {
            "id": "300000795670049",
            "assignmentType": "E",
            "assignmentStatusType": "ACTIVE",
            "effectiveStartDate": "2018-05-28",
            "effectiveEndDate": "4712-12-31",
            "businessTitle": "Civil Engineer-6864",
            "workAtHomeFlag": false,
            "assignmentNumber": "EHDLWorker_190903_11128",
            "timeUpdated": "2025-05-06T11:42:25.787Z",
            "$id": "300000795670049",
            "$context": {
                "etag": "89"
            },
            "personDetail": {
                "personNumber": "HDLWorker_190903_11128",
                "$id": "100000329383875",
                "$context": {
                    "etag": ""
                }
            },
            "globalName": {
                "firstName": "Charlotte-Pénélope",
                "lastName": "Beer-Tröst",
                "$id": "300000795669677",
                "$context": {
                    "etag": ""
                }
            },
            "department": {
                "id": "300000044582197",
                "name": "Human Resources-GROUP/AT081000101",
                "title": null,
                "$id": "300000044582197",
                "$context": {
                    "etag": "13",
                    "links": {
                        "$self": {
                            "href": "https://example.com/api/boss/data/objects/ora/hcmHrCore/workStructures/v1/departments/300000044582197?$effectiveDate=2025-05-13"
                        }
                    }
                }
            },
            "legalEmployer": {
                "id": "300000046740247",
                "name": "PSR_US_LE_1",
                "$id": "300000046740247",
                "$context": {
                    "etag": "15",
                    "links": {
                        "$self": {
                            "href": "https://example.com/api/boss/data/objects/ora/hcmHrCore/workStructures/v1/legalEmployers/300000046740247?$effectiveDate=2025-05-13"
                        }
                    }
                }
            },
            "workRelationship": {
                "id": "100000329453488",
                "$id": "100000329453488",
                "$context": {
                    "etag": "1"
                }
            }
        },
        ...
    ],
    "hasMore": true
}

任務 3：提交擷取職務要求

定義查詢之後，即可使用「工作排程器 API」提交擷取工作要求。

URL	/api/saas-batch/jobscheduler/v1/jobRequests
HTTP 方法	POST
要求範本	{ "jobDefinitionName": "AsyncDataExtraction", "serviceName": "boss", "requestParameters": { "boss.module": "{{moduleName}}", "boss.resource.name": "{{viewName}}", "boss.resource.version": "v1", "boss.outputFormat": "json", "boss.request.system.param.effectiveDate": "{{effectiveDate}}", "boss.advancedQuery": "{{query}}" } } boss.request.system.param.effectiveDate 是選擇性參數，只有在您要擷取與目前日期不同的資料生效基準日期時，才應提供此參數。
回應樣板	成功提交時，會傳回 202 回應代碼，以及指向特定工作要求例項的 URL Location 標頭。 202 Accepted Location: {{jobRequestUrl}}

擷取資料時的分頁：

雖然您可能已使用分頁控制項 (例如 limit 和 offset 參數)，但在建置和測試查詢時，您不想讓擷取結果受到限制。送出查詢時，請移除 limit 和 offset 參數的任何用法。

通過查詢：

送出擷取工作要求時所傳送的查詢必須是標準 JSON 字串的形式。使用 $query API 端點準備並測試查詢，然後：

• 遁離所有雙引號 (「 → \」)
• 移除任何換行字元 (\n)
• 可能減少其他空格 (例如縮排)

整體而言，例如從：

{
    "collection": {
        "limit": 100,
        "filter": "totalAmount > 10000"
    },
    "fields": [ "id", "totalAmount" ]
}

若要：

{\"collection\": {\"filter\": \"totalAmount > 10000\"},\"fields\": [ \"id\", \"totalAmount\" ]}

範例

要求範例

POST /api/saas-batch/jobscheduler/v1/jobRequests
 
{
    "jobDefinitionName": "AsyncDataExtraction",
    "serviceName": "boss",
    "requestParameters": {
        "boss.module": "oraHcmHrCoreEmployment",
        "boss.resource.name": "workerAssignmentExtracts",
        "boss.resource.version": "v1",
        "boss.outputFormat": "json",
        "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
    }
}

回應範例

202 Accepted
 
Location: https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075

作業 4：檢查工單完成

檢查是否完成需要使用「工作排程器 API」定期輪詢工作要求詳細資訊，直到工作要求詳細資訊順利完成或失敗為止。

URL	/api/saas-batch/jobscheduler/v1/jobRequests/{{jobRequestId}}
HTTP 方法	GET

成功完成：

當符合下列條件時，工作要求會被視為成功完成：

屬性	預期值
jobDetails.jobProgress.completed	true
jobDetails.jobProgress.status	SUCCEEDED

完成失敗 ：

符合下列條件時，工作要求會被視為失敗。在此情況下，jobDetails.jobProgress.message 屬性將包含錯誤訊息。

屬性	預期值
jobDetails.jobProgress.status	FAILED

範例

要求範例

GET /api/saas-batch/jobscheduler/v1/jobRequests/42075

回應範例

回覆下方會顯示已提交工作的不同階段。特別參閱 jobProgress.status 和 jobProgress.completed 屬性。

已接受 / 已排入佇列

200 OK
 
{
    "jobDetails": {
        "jobRequestId": 42075,
        "jobRequest": {
            "jobDefinitionName": "AsyncDataExtraction",
            "serviceName": "boss",
            "systemDerivedVersion": "90",
            "jobSubmitter": "TM-MFITZIMMONS",
            "requestParameters": {
                "boss.module": "oraHcmHrCoreEmployment",
                "boss.resource.name": "workerAssignmentExtracts",
                "boss.resource.version": "v1",
                "boss.outputFormat": "json",
                "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
            },
            "jobRetryNumber": 0,
            "timeoutThreshold": 14400
        },
        "jobStatus": "ENQUEUED",
        "jobProgress": {
            "status": "ACCEPTED",
            "message": "Job is submitted",
            "startTime": "2025-05-25T13:39:01Z",
            "endTime": "2025-05-25T13:39:15Z",
            "completedPercentage": "0",
            "completed": false
        }
    },
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075"
            }
        }
    }
}

執行中

200 OK
 
{
    "jobDetails": {
        "jobRequestId": 42075,
        "jobRequest": {
            "jobDefinitionName": "AsyncDataExtraction",
            "serviceName": "boss",
            "systemDerivedVersion": "90",
            "jobSubmitter": "TM-MFITZIMMONS",
            "requestParameters": {
                "boss.module": "oraHcmHrCoreEmployment",
                "boss.resource.name": "workerAssignmentExtracts",
                "boss.resource.version": "v1",
                "boss.outputFormat": "json",
                "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
            },
            "jobRetryNumber": 0,
            "timeoutThreshold": 14400
        },
        "jobStatus": "RUNNING",
        "jobProgress": {
            "jobRequestId": 42075,
            "status": "RUNNING",
            "message": "Job status is changed to RUNNING",
            "startTime": "2025-05-25T13:39:27Z",
            "endTime": "2025-05-25T13:40:25Z",
            "completedPercentage": "50",
            "completed": false
        }
    },
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075"
            }
        }
    }
}

200 OK
 
{
    "jobDetails": {
        "jobRequestId": 42075,
        "jobRequest": {
            "jobDefinitionName": "AsyncDataExtraction",
            "serviceName": "boss",
            "systemDerivedVersion": "90",
            "jobSubmitter": "TM-MFITZIMMONS",
            "requestParameters": {
                "boss.module": "oraHcmHrCoreEmployment",
                "boss.resource.name": "workerAssignmentExtracts",
                "boss.resource.version": "v1",
                "boss.outputFormat": "json",
                "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
            },
            "jobRetryNumber": 0,
            "timeoutThreshold": 14400
        },
        "jobStatus": "RUNNING",
        "jobProgress": {
            "jobRequestId": 42075,
            "status": "RUNNING",
            "message": "Publishing BOSS job progress: JobProgress(jobRequestId=42075, resourcePath=oraHcmHrCoreEmployment/v1/workers, dataDocName=null, deploymentId=null, jobStatus=RUNNING, startTime=2025-05-25T13:40:18Z, endTime=2025-05-25T13:40:38Z, completedPercentage=30, completed=false, error=null)",
            "startTime": "2025-05-25T13:40:40Z",
            "endTime": "2025-05-25T13:40:40Z",
            "completedPercentage": "30",
            "completed": false
        }
    },
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075"
            }
        }
    }
}

已成功完成

200 OK
 
{
    "jobDetails": {
        "jobRequestId": 42075,
        "jobRequest": {
            "jobDefinitionName": "AsyncDataExtraction",
            "serviceName": "boss",
            "systemDerivedVersion": "90",
            "jobSubmitter": "TM-MFITZIMMONS",
            "requestParameters": {
                "boss.module": "oraHcmHrCoreEmployment",
                "boss.resource.name": "workerAssignmentExtracts",
                "boss.resource.version": "v1",
                "boss.outputFormat": "json",
                "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
            },
            "jobRetryNumber": 0,
            "timeoutThreshold": 14400
        },
        "jobStatus": "SUCCEEDED",
        "jobProgress": {
            "jobRequestId": 42075,
            "status": "SUCCEEDED",
            "message": "Job status is changed to SUCCEEDED",
            "startTime": "2025-05-25T13:39:27Z",
            "endTime": "2025-05-25T13:41:26Z",
            "completedPercentage": "100",
            "completed": true
        }
    },
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075"
            }
        }
    }
}

作業 5：提取摘錄輸出明細

工作順利完成之後，即可擷取其輸出檔案資訊。它涉及使用特定擷取工作要求實例的「工作檔案管理員 API」。

輸出儲存於壓縮的區塊中。

URL	/api/saas-batch/jobfilemanager/v1/jobRequests/{{jobRequestId}}/outputFiles
HTTP 方法	GET

檔案大小：

檔案大小會在 items.fileSize 回應屬性中傳回，並以位元組表示。

機箱連結：

實際檔案內容的 URL 會以 items.$context.links.enclosure 回應屬性傳回。

範例

要求範例

GET /api/saas-batch/jobfilemanager/v1/jobRequests/42075/outputFiles

回應範例

在下面的範例中，完整輸出儲存在兩個壓縮檔案中。

200 OK
 
{
    "items": [
        {
            "fileName": "result_1_json.zip",
            "fileSize": 9390419,
            "timeCreated": "2025-04-22T22:04:22.667Z",
            "$context": {
                "links": {
                    "enclosure": {
                        "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles/result_1_json.zip/content"
                    },
                    "$self": {
                        "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles/result_1_json.zip"
                    }
                }
            }
        },
        {
            "fileName": "result_2_json.zip",
            "fileSize": 4462724,
            "timeCreated": "2025-04-22T22:04:36.565Z",
            "$context": {
                "links": {
                    "enclosure": {
                        "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles/result_2_json.zip/content"
                    },
                    "$self": {
                        "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles/result_2_json.zip"
                    }
                }
            }
        }
    ],
    "totalItems": 2,
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles"
            }
        }
    }
}

任務 6：下載擷取輸出

最後，可以針對特定擷取工作要求例項與輸出檔案，使用「工作檔案管理員 API」來下載擷取輸出檔案。

URL	/api/saas-batch/jobfilemanager/v1/jobRequests/{{jobRequestId}}/outputFiles/{{fileName}}/content
HTTP 方法	GET

警示：

單一要求最多可下載 32 MB。如果個別檔案較大，預設會得到檔案的 32mb 部份。對於連續要求，您必須使用 Range HTTP 標頭，如下所示。使用 Range 標頭也可讓您實行多重執行緒下載，以便在需要時更有效率地擷取大型檔案。

Range: {{startByte}}-{{endByte}}/{{fileSize}}

秘訣：

為了避免完全使用 Range 標頭，請以值 180 的額外參數 boss.export.maxChunkSize 提交工作要求。這將確保每個壓縮的區塊都小於 32 MB，且您可在單一要求中下載。

範例

要求範例

GET /api/saas-batch/jobfilemanager/v1/jobRequests/42075/outputFiles/result_42075.json/content

回應範例

實際回應為二進位壓縮檔案內容。解壓縮之後，即為完整或部分 (如果是 Range 標頭使用)、未格式化的 JSON 有效負載，以及擷取查詢的完整或部分 (如果是檔案區塊) 結果。

完整未壓縮結果範例

{"items": [
    {"id":"300008335145001","assignmentType":"E","assignmentStatusType":"ACTIVE","effectiveStartDate":"2025-05-02","effectiveEndDate":"4712-12-31","businessTitle":"E7356262523","workAtHomeFlag":false,"assignmentNumber":"E7356262523","timeUpdated":"2025-05-01T07:53:15.722Z","$id":"300008335145001","$context":{"etag":"1"},"personDetail":{"personNumber":"7356262523","$id":"300008335144985","$context":{"etag":""}},"globalName":{"firstName":null,"lastName":"oracle","$id":"300008335144986","$context":{"etag":""}},"department":null,"legalEmployer":{"id":"300001939234024","name":"AORT Oracle United States","$id":"300001939234024","$context":{"etag":"6","links":{"$self":{"href":"/ora/hcmHrCore/workStructures/v1/$en-US/legalEmployers/300001939234024?$effectiveDate=2025-05-13"}}}},"workRelationship":{"id":"300008335144995","$id":"300008335144995","$context":{"etag":"1"}}},
    {"id":"300000310085281","assignmentType":"E","assignmentStatusType":"ACTIVE","effectiveStartDate":"2018-03-04","effectiveEndDate":"4712-12-31","businessTitle":"Medical Technologist Corporate Level-35321","workAtHomeFlag":false,"assignmentNumber":"EHDLWorker_190409_467490","timeUpdated":"2025-05-07T15:29:46.59Z","$id":"300000310085281","$context":{"etag":"90"},"personDetail":{"personNumber":"HDLWorker_190409_467490","$id":"100000127293313","$context":{"etag":""}},"globalName":{"firstName":"Martin-David","lastName":"Oestrovsky-Krein","$id":"300000310075057","$context":{"etag":""}},"department":{"id":"300000041568062","name":"GFIN Global Controlling-GROUP/GFINGC74155","title":null,"$id":"300000041568062","$context":{"etag":"13","links":{"$self":{"href":"/ora/hcmHrCore/workStructures/v1/$en-US/departments/300000041568062?$effectiveDate=2025-05-13"}}}},"legalEmployer":{"id":"300000046740247","name":"PSR_US_LE_1","$id":"300000046740247","$context":{"etag":"15","links":{"$self":{"href":"/ora/hcmHrCore/workStructures/v1/$en-US/legalEmployers/300000046740247?$effectiveDate=2025-05-13"}}}},"workRelationship":{"id":"100000127362395","$id":"100000127362395","$context":{"etag":"1"}}}
]}

其他學習資源

在 docs.oracle.com/learn 上探索其他實驗室，或在 Oracle Learning YouTube 頻道上存取更多免費學習內容。此外，請造訪 education.oracle.com/learning-explorer 以成為 Oracle Learning Explorer。

如需產品文件，請造訪 Oracle Help Center 。

---

標題與著作權資訊

從 HCM 讀取最佳化資料存放區擷取資料

G38797-07

四月 2026

Copyright ©2026,

Oracle 和 (或) 其關係企業。