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 - Feb 2021 Updates Reference Docs and Deprecations and DEX - Updates and Deprecations Feb 2021 (21.01).

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

For clients 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 organizations six months prior to their deletion. To avoid disruptions, replacements for objects that will be deprecated with the February ’21 Release must be requested before February 2 for stage and February 19 for production/pilot.

Data Exporter - Deprecated Objects Scheduled for February '21 Release

This table describes deprecated objects that are still available in the Data Exporter. These objects are scheduled to be removed in the February '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
transcript_curricula	None. Existing consumers of this object, if you wish to continue receiving this data beyond the deprecation date, please contact GPS so we can make arrangements.	Release 21.01.00 (Feb 2021)	Deleted
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

Data Exporter - New Objects Scheduled for February '21 Release

The following new objects are being added to Data Exporter with the February '21 Release.

object public name	Description	Addition Date	Action
scorm_session	Scorm session	Release 21.01.00 (Feb 2021)	Added
scorm_subsession	Scorm subsession	Release 21.01.00 (Feb 2021)	Added
scorm_subsession_interaction	Scorm subsession interaction	Release 21.01.00 (Feb 2021)	Added
scorm_subsession_interaction_correct_response	Scorm subsession interaction correct response	Release 21.01.00 (Feb 2021)	Added
training_bundle_core	Training bundle. Also referred within the app as "subscriptions."	Release 21.01.00 (Feb 2021)	Added
training_bundle_manifest_core	Training bundle manifest. Course(s) which are part of a training bundle (subscription).	Release 21.01.00 (Feb 2021)	Added

RTDW - Deprecated Objects Scheduled for February '21 Release

This table describes the deprecated objects that are still available in RTDW. These objects are scheduled to be removed in the February '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
Training and Transcript	report.vw_rpt_transcript_curricula	report.vw_rpt_transcript_src_curriculum	Release 21.01.00 (Feb 2020)	Deleted
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

RTDW - New Views Scheduled for February '21 Release

The following new views are being added to RTDW with the February '21 Release.

Category	View	Description	Addition Date	Action
Training and Transcript	vw_rpt_training_bundle	Training bundle. Also referred within the app as "subscriptions."	Release 21.01.00 (Feb 2020)	Added
Training and Transcript	vw_rpt_training_bundle_manifest	Training bundle manifest. Course(s) which are part of a training bundle (subscription).	Release 21.01.00 (Feb 2020)	Added