RTDW Updates to Reporting API, RDW, and Data Exporter

Impacting only clients 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 - Oct 2020 Updates Reference docs and Deprecations and DEX - Updates and Deprecations Oct 2020 (20.04). Updated documentation available as of October 8.

For clients using Reporting API, Replicated Data Warehouse (RDW), or Data Exporter, the changes and deprecated objects will be reflected in stage on October 13 and in production with the release on October 30.

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 Product Support (GPS). Replacement objects are made available to clients six months prior to their deletion. To avoid disruptions, replacements for objects that will be deprecated with the October ’20 Release must be requested before October 13 for stage and October 30 for production/pilot.

Data Exporter - Deprecated Objects Scheduled for October '20 Release

This table describes deprecated objects that are still available in the Data Exporter. These objects are scheduled to be removed in the October '20 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
certification

[certification2] (added in 20.01.03)

[certification_owner] (added in 20.01.03)

Note: [certification2] has all fields from deprecated [certification] except fields of certification owner: [certification_owner], [certification_owner_user_ref] and fields of certification contact person: [cert_contact_user_ref], [cert_contact_user_name], [cert_contact_user_email].

Use [users_core] for certification owner and certification contact person fields.

Refer to “RTDW Deprecated Objects” for details.

Release 20.04.00 (Oct 2020) Deleted

goals_base

[goal] Release 20.04.00 (Oct 2020) Deleted
evaluation: [eval_question_category_id] field will be renamed to [re_eval_question_category_id]   Release 20.04.00 (Oct 2020) Updated
transcript: [object_id] field will be renamed to [transc_object_id], [_last_touched_dt_utc] field will be added   Release 20.04.00 (Oct 2020) Updated
COMPATIBILITY_subject_local [subject_local_core] Release 20.04.00 (Oct 2020) Deleted
COMPATIBILITY_training_subject_local [subject_local_core] Release 20.04.00 (Oct 2020) Deleted
COMPATIBILITY_qti_category_local [qna_question_category_local_core] Release 20.04.00 (Oct 2020) Deleted
COMPATIBILITY_ou_type_local [ou_type_local _core] (added in 20.01.03) Release 20.04.00 (Oct 2020) Deleted
training_material_type_local [training_material_type_local_core] Release 20.04.00 (Oct 2020) Deleted
COMPATIBILITY_session_schedule_local [training_part_local_core] Release 20.04.00 (Oct 2020) Deleted
COMPATIBILITY_transcript_user_part_atte ndance [training_part_core], [training_part_attendance] Release 20.04.00 (Oct 2020) Deleted
instructor [instructor_core] Release 20.04.00 (Oct 2020) Deleted
test_questions [qna_question_core] Release 20.04.00 (Oct 2020) Deleted
training_cf [training_cf_core] Release 20.04.00 (Oct 2020) Deleted
training_rating_review

[course_rating_core]

Use [users_core] for the reviewer fields (First Name, Last Name).

Note: to get replacement for [user_rating_is_anonymous] field in deprecated [training_rating_review] object use the following: cast ( case when [course_rating_core].[user_id] is null then 1 else 0 end as bit) as [user_rating_is_anonymous].

Field [user_id] in [course_rating_core] is unique identifier of the user who reviewed the course. Note that [user_id] has NULL value if the course reviewer is anonymous).

Release 20.04.00 (Oct 2020) Deleted
training_session_schedule [training_part_core], [training_part_local_core] Release 20.04.00 (Oct 2020) Deleted
training_subject_equivalent [subject_equivalent_core], [subject_core] Release 20.04.00 (Oct 2020) Deleted
transcript_cf [transcript_cf_core] Release 20.04.00 (Oct 2020) Deleted
transcript_scorm2004 [scorm2004_activity_session_history], [scorm2004_interaction_history], [training_scorm_core] Release 20.04.00 (Oct 2020) Deleted

user_cf

[users_cf_core] Release 20.04.00 (Oct 2020) Deleted

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 20.01.00 (Feb 2021) Marked for deletion

RTDW - Deprecated Objects Scheduled for October '20 Release

This table describes the deprecated objects that are still available in RTDW. These objects are scheduled to be removed in the October '20 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
Certification report.vw_rpt_certification

report.vw_rpt_certification2 (added in 20.01.03)

report.vw_rpt_certification_owner (added in 20.01.03)

Note: report.vw_rpt_certification2 has all fields from deprecated report.vw_rpt_certification except fields of certification owner: [certification_owner], [certification_owner_user_ref] and fields of certification contact person: [cert_contact_user_ref], [cert_contact_user_name], [cert_contact_user_email].

To get fields of certification owner:

  1. Join report.vw_rpt_certification2 with report.vw_rpt_certification_owner on cert_id = cert_owner__cert_id
  2. Join report.vw_rpt_certification_owner with report.vw_rpt_user on cert_owner__user_id (vw_rpt_certification_owner) = user_id (report.vw_rpt_user)
  3. Use [user_name_first] , [user_name_last], [user_ref] fields from report.vw_rpt_user.

To get fields of certification contact person:

  1. Join report.vw_rpt_certification2 with report.vw_rpt_user on cert_contact_user_id (report.vw_rpt_certification2) = user_id (report.vw_rpt_user).
  2. Use [user_name_first] , [user_name_last], [user_ref], [user_email] fields from report.vw_rpt_user.

Note: Inclusion of certification owner fields into deprecated report.vw_rpt_certification causes multiplication of rows with certification fields on number of certification owners which results in a huge volume of extra rows of data to be generated.

report.vw_rpt_certification2 (without certification owner fields) doesn’t have extra rows of data.

Illustrative Example: With 500 users on a certification who have each complete 3 periods and are now in refresh, with 5 certification owners this results in 10,000 rows of data: report.vw_rpt_certification: 500 (users) *4 (periods) * 5 (certification owners) = 10,000 rows.

report.vw_rpt_certification2: 500 (users) *4 (periods) = 2,000 rows.

Release 20.04.00 (Oct 2020) Deleted
Certification report.vw_rpt_certification_export report.vw_rpt_certification2 Release 20.04.00 (Oct 2020) Deleted
Test report.vw_rpt_test_export report.vw_rpt_test Release 20.04.00 (Oct 2020) Deleted
Evaluation report.vw_rpt_evaluation_export report.vw_rpt_evaluations Release 20.04.00 (Oct 2020) Deleted
Transaction report.vw_rpt_transaction_export report.vw_rpt_transaction Release 20.04.00 (Oct 2020) Deleted
Training and Transcript report.vw_rpt_transcript_export report.vw_rpt_transcript Release 20.04.00 (Oct 2020) Deleted
Goals report.vw_rpt_goals_base report.vw_rpt_goals Release 20.04.00 (Oct 2020) Deleted
User report.vw_rpt_user_base report.vw_rpt_user Release 20.04.00 (Oct 2020) Deleted
Training and Transcript report.vw_rpt_subject_local report.vw_rpt_subject_local2 Release 20.04.00 (Oct 2020) Deleted
Training and Transcript report.vw_rpt_lo_subject_local report.vw_rpt_subject_local2 Release 20.04.00 (Oct 2020) Deleted
Evaluations, Test, Performance Review report.vw_rpt_qti_text_local report.qna_text_local_core Release 20.04.00 (Oct 2020) Deleted
Evaluations, Test report.vw_rpt_qti_category_local report.qna_question_category_local_core Release 20.04.00 (Oct 2020) Marked for deletion
Training and Transcript, Training Plan, Training Unit, Connect report.vw_rpt_ou_type_local report.vw_rpt_ou_type_local2 (added in 20.01.03) Release 20.04.00 (Oct 2020) Deleted
Training and Transcript report.vw_rpt_lo_material_type_local report.vw_rpt_training_material_type_local Release 20.04.00 (Oct 2020) Deleted
Training and Transcript report.vw_rpt_session_schedule_local report.vw_rpt_training_part_local Release 20.04.00 (Oct 2020) Deleted

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) Marked for deletion