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