RTDW Updates to Reporting API, RDW, and Data Exporter

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 October ’21 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 as of October 12 and in Production with the release on October 29.

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.

Data Exporter - Deprecated Objects Scheduled for October '21 Release

This table describes deprecated objects that are still available in the Data Exporter. These objects are scheduled to be removed in the October '21 Release. Do not use these deprecated objects in new development work, and modify applications that currently use these deprecated objects as soon as possible.

Deprecated object public name Replacement Removal Date Action

COMPATIBILITY_curriculum_child_due_date_type_local

curriculum_due_date_type_local_core

Release 21.04.00 (Oct 2021) Deleted

COMPATIBILITY_feedback_badge_local

feedback_badge_local_core

Release 21.04.00 (Oct 2021) Deleted

COMPATIBILITY_training_removal_reason_local

training_removal_reason_local_core

Release 21.04.00 (Oct 2021) Deleted

COMPATIBILITY_transcript_delivery_method_local

transcript_origin_type_local_core

Release 21.04.00 (Oct 2021) Deleted

COMPATIBILITY_user_category_local

user_category_local_core

Release 21.04.00 (Oct 2021) Deleted

COMPATIBILITY_user_employment_status_local

user_employment_status_local_core

Release 21.04.00 (Oct 2021) Deleted

COMPATIBILITY_user_leave_reason_local

user_leave_reason_local_core

Release 21.04.00 (Oct 2021) Deleted

COMPATIBILITY_user_sub_category_local

user_sub_category_local_core

Release 21.04.00 (Oct 2021) Deleted

COMPATIBILITY_user_termination_reason_local

user_termination_reason_local_core

Release 21.04.00 (Oct 2021) Deleted

lo_exempt_status_reason_approver_local

training_exemption_reason_local_core

Release 21.04.00 (Oct 2021) Deleted

lo_exempt_status_reason_local

training_exemption_reason_local_core

Release 21.04.00 (Oct 2021) Deleted

transcript_action_reason_local

transcript_action_reason_local_core

Release 21.04.00 (Oct 2021) Deleted

user_ou_status_local

user_ou_status_local_core

Release 21.04.00 (Oct 2021) Deleted

user_status

user_status_core

Release 21.04.00 (Oct 2021) Deleted

user_status_local

user_status_local_core

Release 21.04.00 (Oct 2021) Deleted

culture

culture_core

Release 21.04.00 (Oct 2021) Deleted

language

language_core

Note: Use culture_core for culture_name, culture_descr fields in [language].

Release 21.04.00 (Oct 2021) Deleted

ou_path

ou_hierarchy_core

ou_core

Release 21.04.00 (Oct 2021) Deleted
COMPATIBILITY_training_contact_concat

training_contact_core

users_core

Note: For COMPATIBILITY_training_contact_concat, one record corresponds to the concatenated list of all contacts (users) to a course.

For training_contact_core, one record corresponds to the association of one contact (user) to a course.

Use [users_core] to get [user_name_last],[user_name_first, [user_ref] fields for course contact (user).

Release 22.01.00 (Feb 2022) Marked for deletion
transcript_part_attendance

training_part_attendance_core

training_part_core

Release 22.01.00 (Feb 2022) Marked for deletion
training_curricula curriculum_structure_core Release 22.01.00 (Feb 2022) Marked for deletion
training_relation

training_relationship_core

(fields: [object_id], [course_relation_type_id], [related_object_id])

Note: Use curriculum_structure_core as replacement for fields in training_relation which are specific for curricula.

Release 22.01.00 (Feb 2022) Marked for deletion
smp_task_review_user_property_audit No Release 22.01.00 (Feb 2022) Marked for deletion
smp_task_review_successor_property_audit No Release 22.01.00 (Feb 2022) Marked for deletion

RTDW - Deprecated Objects Scheduled for July '21 Release

This table describes the deprecated objects that are still available in RTDW. These objects are scheduled to be removed in the July '21 Release. Do not use these deprecated objects in new development work, and modify applications that currently use these deprecated objects as soon as possible.

Category

Deprecated Object

Replacement Removal Date Action
Recruiting

Referrer fields:

applicant__referrer_username,

applicant__referrer_user_ref,

applicant__referrer_name,

in report.vw_rpt_applicant_lite

Fields from report.vw_rpt_user:

user_login, user_ref, user_name_last, user_name_first

To get Referrer fields:

1. Join report.vw_rpt_applicant_lite with report.vw_rpt_user on applicant_referred_by(report.vw_rpt_applicant) = user_id (report.vw_rpt_user).

2. Use [user_login], [user_ref], [user_name_last], [user_name_first] fields from report.vw_rpt_user:

applicant__referrer_username = user_login

applicant__referrer_user_ref = user_ref

applicant__referrer_name = user_name_last + ', ' + user_name_first

Release 22.01.00 (Feb 2022) Marked for deletion
Job Pool, Succession

report.vw_rpt_smp_task

_review_user_property_audit

No Release 22.01.00 (Feb 2022) Marked for deletion
Job Pool

report.vw_rpt_smp_task

_review_successor_property_audit

No Release 22.01.00 (Feb 2022) Marked for deletion