RTDW Updates to Reporting API, RDW, and Data Exporter

Impacting only organizations using Reporting API, Replicated Data Warehouse (RDW), 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 are updated 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 and of upcoming changes occurring in this release and future deprecations scheduled in future releases. Information on deprecated objects and changes can be found in RTDW - Apr 2021 Updates Reference Docs and Deprecations and DEX - Updates and Deprecations Apr 2021 (21.02).

For organizations using Reporting API, Replicated Data Warehouse (RDW), or Data Exporter, the changes and deprecated objects are reflected in stage as of April 13 and in production with the release on April 30.

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 Future Releases

This table describes deprecated objects that are still available in the Data Exporter. These objects are scheduled to be removed in upcoming releases. 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
Field status_id in [devplan_training_core] Field is_training_item_completed in [devplan_training_core] Release 21.03.00 (Jul 2021) Marked for deletion

Referrer fields:

applicant__referrer_username, applicant__referrer_user_ref, applicant__referrer_name, applicant__referrer_email

in [applicant]

Use [users_core] for Referrer fields.

Fields from [users_core]:

user_login, user_ref, user_name_last, user_name_first, user_email

applicant__referrer_username = user_login

applicant__referrer_user_ref = user_ref

applicant__referrer_name = user_name_last + ', ' + user_name_first

applicant__referrer_email = user_email

Note: Field applicant_referred_by in [applicant] object is internal identifier of the user (user_id in [users_core]) who referred the applicant.

Refer to “Deprecated Objects - RTDW Documentation” for details.

Release 21.03.00 (Jul 2021) Marked for deletion

COMPATIBILITY_curriculum_child_due_date_typ e_local

curriculum_due_date_type_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

COMPATIBILITY_feedback_badge_local

feedback_badge_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

COMPATIBILITY_training_removal_reason_local

training_removal_reason_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

COMPATIBILITY_transcript_delivery_method_local

transcript_origin_type_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

COMPATIBILITY_user_category_local

user_category_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

COMPATIBILITY_user_employment_status_local

user_employment_status_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

COMPATIBILITY_user_leave_reason_local

user_leave_reason_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

COMPATIBILITY_user_sub_category_local

user_sub_category_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

COMPATIBILITY_user_termination_reason_local

user_termination_reason_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

lo_exempt_status_reason_approver_local

training_exemption_reason_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

lo_exempt_status_reason_local

training_exemption_reason_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

transcript_action_reason_local

transcript_action_reason_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

user_ou_status_local

user_ou_status_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

user_status

user_status_core

Release 21.04.00 (Oct 2021) Marked for deletion

user_status_local

user_status_local_core

Release 21.04.00 (Oct 2021) Marked for deletion

culture

culture_core

Release 21.04.00 (Oct 2021) Marked for deletion

language

language_core

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

Release 21.04.00 (Oct 2021) Marked for deletion

ou_path

ou_hierarchy_core

ou_core

Release 21.04.00 (Oct 2021) Marked for deletion

COMPATIBILITY_training_contact_concat

Note: One record corresponds to the concatenated list of all contacts (users) to a course.

training_contact_core

users_core

Note: 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

Fields object_id, course_relation_type_id, related_object_id in [training_relation]

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

Fields object_id, course_relation_type_id, related_object_id in [training_relationship_core] Release 22.01.00 (Feb 2022) Marked for deletion

RTDW - Deprecated Objects Scheduled for Future Releases

This table describes the deprecated objects that are still available in RTDW. These objects are scheduled to be removed in upcoming releases. 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, applicant__referrer_email

in report.vw_rpt_applicant

Fields from report.vw_rpt_user:

user_login, user_ref, user_name_last, user_name_first, user_email

To get Referrer fields:

1. Join report.vw_rpt_applicant 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], [user_email] 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

applicant__referrer_email = user_email

Release 21.03.00 (Jul 2021) Marked for deletion