RTDW Updates to Reporting API, RDW, Data Exporter and Data Exporter API

Impacting only customers using Reporting API, Replicated Data Warehouse (RDW), Data Exporter API, and Data Exporter, the Real-Time Data Warehouse (RTDW) categories may be impacted, deprecated, or break applications, scripts, or functionalities that are based on earlier versions of RTDW objects.

Documentation that describes RTDW views and fields used in Custom Reports will be updated for the March '24 Release and available in the RTDW Documentation for Reporting API, RDW, and Data Exporter Community. Join and follow the community to be notified of new posts.

For customers using Reporting API, Replicated Data Warehouse (RDW), Data Exporter API, or Data Exporter, the changes and deprecated objects will be reflected in stage portals as of February 22 and in production portals with the release on March 22.

For customers using Data Exporter, new objects and replacements for deprecated objects are not automatically added to your export, they must be requested via a case to Global Customer Support. Replacement objects are made available to customers six months prior to their deletion.

Resources

Data Exporter - Changes Scheduled

The following items are scheduled for deprecation:

object public name Replaced By Change Date Action
training_part_core training_part2_core Release 24.03.00 (Nov 2024) Marked for deletion
applicant

job_application_core

job_application_disposition_local_core

job_application_submission_source_core

Release 24.03.00 (Nov 2024) Marked for deletion
CheckinNote CheckinNote2 Release 24.03.00 (Nov 2024) Marked for deletion
COMPATIBILITY_eval_question_user_response_local

assessment_evaluation_core

assessment_response_core

assessment_result_core

qna_container_core

qna_structure_core

qna_question_core

qna_answer_bank_core

qna_text_local_core

Release 24.03.00 (Nov 2024) Marked for deletion
COMPATIBILITY_job_requisition_applicant_status_local job_application_status_local_core Release 24.03.00 (Nov 2024) Marked for deletion
COMPATIBILITY_ou_custom_field_text_response_local ou_cf_text_local_core Release 24.03.00 (Nov 2024) Marked for deletion
curriculum_user_info

transcript_core

field [progress_percentage] in deprecated [curriculum_user_info] corresponds to field [user_lo_pct_complete] in [transcript_core] for Curriculum objects

Release 24.03.00 (Nov 2024) Marked for deletion
devplan

devplan_core

devplan_training_core

devplan_objective_core

devplan_status_core

devplan_action_step_core

devplan_cf_core

Release 24.03.00 (Nov 2024) Marked for deletion
evaluation

assessment_evaluation_core

assessment_response_core

assessment_result_core

assessment_type_core

qna_answer_bank_core

qna_container_core

qna_correct_answer_core

qna_item_audit_core

qna_question_category_core

qna_question_category_local_core

qna_question_core

qna_question_type_local_core

qna_section_core

qna_structure_core

qna_text_local_core

Release 24.03.00 (Nov 2024) Marked for deletion
filter_lo_ou training_availability_by_ou_core Release 24.03.00 (Nov 2024) Marked for deletion
filter_lo_user training_availability_by_user_core Release 24.03.00 (Nov 2024) Marked for deletion
goal

goal_core

goal_association_core

users_core

 Release 24.03.00 (Nov 2024) Marked for deletion
ou_cf

user_ou_pivoted_core

user_ou_core

ou_cf_core

Release 24.03.00 (Nov 2024) Marked for deletion
recruiting

job_requisition_core

job_application_workflow_core

job_requisition_target_ou_core

job_requisition_template_core

job_requisition_eeo_category_core

compensation_type_local_core

job_requisition_employment_type_local_core

users_core

ou_core

Release 24.03.00 (Nov 2024) Marked for deletion
requisition_cf job_requisition_cf_core Release 24.03.00 (Nov 2024) Marked for deletion
requisition_location

job_requisition_target_ou_core

ou_core

Release 24.03.00 (Nov 2024) Marked for deletion
test

assessment_test_core

assessment_response_core

assessment_result_core

assessment_type_core

qna_answer_bank_core

qna_container_core

qna_correct_answer_core

qna_item_audit_core

qna_question_category_core

qna_question_category_local_core

qna_question_core

qna_question_type_local_core

qna_section_core

qna_structure_core

qna_text_local_core

Release 24.03.00 (Nov 2024) Marked for deletion
training_schedule

training_part2_core

training_part_attendance_core

address_core timezone_core

training_core

users_core ou_core

Release 24.03.00 (Nov 2024) Marked for deletion
transaction

training_purchase_core

training_purchase_line_item_core

training_purchase_payer_core

Release 24.03.00 (Nov 2024) Marked for deletion
transaction_address training_purchase_core Release 24.03.00 (Nov 2024) Marked for deletion
transaction_tax training_purchase_line_item_core Release 24.03.00 (Nov 2024) Marked for deletion
transcript transcript_core Release 24.03.00 (Nov 2024) Marked for deletion
user users_core Release 24.03.00 (Nov 2024) Marked for deletion
user_ou_info user_ou_pivoted_core ou_core Release 24.03.00 (Nov 2024) Marked for deletion
user_ou_status user_ou_status_local_core Release 24.03.00 (Nov 2024) Marked for deletion

The following XXX_cf_enum_local_core objects:

  • application_cf_enum_local_core
  • devplan_cf_enum_local_core
  • offer_letter_cf_enum_local_core
  • ou_cf_enum_local_core
  • performance_review_cf_enum_local_core
  • succession_cf_enum_local_core
  • training_cf_enum_local_core
  • training_forecast_cf_enum_local_core
  • user_cf_enum_local_core

The following XXX_cf_enum_local2_core objects:

  • application_cf_enum_local2_core
  • devplan_cf_enum_local2_core
  • offer_letter_cf_enum_local2_core
  • ou_cf_enum_local2_core
  • performance_review_cf_enum_local2_core
  • succession_cf_enum_local2_core
  • training_cf_enum_local2_core
  • training_forecast_cf_enum_local2_core
  • user_cf_enum_local2_core

'Version 2' of these objects add either 'field_id' or 'property_id' to the primary key to more easily facilitate finding all enumeration options associated with a particular custom field; a unique index on 'option_id' + 'culture_id' is still honored so that the new objects can still be filtered (when using DEAPI) similar to the legacy objects.

 Release 25.01.00 (March 2025) Marked for deletion

The following changes are scheduled:

Change Type object public name Change Description Change Date Action
Object Key Change

application_cf_enum_local_core

devplan_cf_enum_local_core

offer_letter_cf_enum_local_core

ou_cf_enum_local_core

performance_review_cf_enum_local_core

succession_cf_enum_local_core

training_cf_enum_local_core

training_forecast_cf_enum_local_core

user_cf_enum_local_core

Object Key will be changed

from

Key: option_id, culture_id

to

Key: field_id, option_id, culture_id

 Release 24.01.00 (March 2024) Scheduled
Description Change training_core: 'thumbnail_location' Description updated to use case-sensitive 'LoThumbnail_Upload' in url part Release 24.01.00 (March 2024) Scheduled
Data Type Change

Object: training_local_core

Field: descr

Data type will be changed

from nvarchar(4000)

to nvarchar(10000)

 Release 24.01.00 (March 2024) Scheduled
Addition training_ilt_facility_core Added Release 24.01.00 (March 2024) Scheduled
Addition UserRatingVisibility_local Added Release 24.01.00 (March 2024) Scheduled
Addition

Some endpoints were missing in the Edge API Management list of 'Reporting API' scopes available to OAuth applications. So while these objects were available to users of the file-based Data Exporter, and may have even been published in previous versions of DEAPI documentation, they were not accessible by DEAPI users. Scopes have now been added, so these can be considered 'new objects' to DEAPI users:

AvailabilityType

CapabilityCategory

CapabilityCategory_local

CapabilityCategoryMap

CapabilityModelCapabilityMap

CategoryStatus devplan_comment_core

devplan_comment_reply_core

devplan_objective_comment_core

devplan_objective_comment_reply_core

job_application_status_local_core

job_requisition_cf_core

SkillsGraphLinkMethod

TargetType training_available_culture_core

training_ilt_facility_type_local_core

training_part_instructor_core

training_part2_core

training_purchase_payer_core

training_purchase_payment_type_core

training_purchaser_overrides_core

 Added Release 24.01.00 (March 2024) Scheduled

RTDW - Changes Scheduled

There are no deprecated objects for the November '23 Release.

This table describes changes in objects scheduled for a future release.

object public name Change Description Change Date Action

Object:

report.vw_rpt_training_local

Field: [descr]

Data type of [descr] field is changed from nvarchar(4000) to nvarchar(10000)

 Release 24.01.00 (March 2024) Scheduled

Reporting API - Changes Scheduled

The following items are scheduled for deprecation:

object public name Replaced By Change Date Action

vw_rpt_applicant_response

vw_rpt_ats_compliance_question_applicant_responses

vw_rpt_ats_compliance_question_applicant_responses_dt

 Release 24.03.00 (Nov 2024) Marked for deletion