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.

This functionality available in Stage portals as of 21 April 2020.

RTDW Deprecated Objects

This table describes the deprecated objects that are still available in RTDW. These objects are scheduled to be removed in future releases.

Category

Deprecated Object

Replacement Removal Date Action

Goals

User fields in report.vw_rpt_goals

report.vw_rpt_user

Join report.vw_rpt_user with report.vw_rpt_goals on goal_user_id (vw_rpt_goals) = user_id (report.vw_rpt_user)

Release 20.03.00 (Aug 2020) Marked for deletion
Goals OU fields in report.vw_rpt_goals

report.vw_rpt_user_ou_info

  1. Join report.vw_rpt_user with report.vw_rpt_goals on goal_user_id (vw_rpt_goals) = user_id (report.vw_rpt_user).
  2. Join report.vw_rpt_user_ou_info with report.vw_rpt_user on user_ou_info_user_id (vw_rpt_user_ou_info) = user_id (report.vw_rpt_user)
Release 20.03.00 (Aug 2020) Marked for deletion
Goals User dynamic relation fields in in report.vw_rpt_goals

report.vw_rpt_user_dynamic_relation

  1. Join report.vw_rpt_user with report.vw_rpt_goals on goal_user_id (vw_rpt_goals) = user_id (report.vw_rpt_user)
  2. Join report.vw_rpt_user_dynamic_relation with report.vw_rpt_user on user_dynamic_relation_user_id (vw_rpt_user_dynamic_relation) = user_id (report.vw_rpt_user)
Release 20.03.00 (Aug 2020) Marked for deletion
Training and Transcript report.vw_rpt_training_subject

report.vw_rpt_subject,

report.vw_rpt_subject_training

Join report.vw_rpt_subject with report.vw_rpt_subject_training on vw_rpt_subject.subject_id = vw_rpt_subject_training.subject_id

Release 20.03.00 (Aug 2020) Marked for deletion
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) Marked for deletion
Certification report.vw_rpt_certification_export report.vw_rpt_certification2 Release 20.04.00 (Oct 2020) Marked for deletion
Test report.vw_rpt_test_export report.vw_rpt_test Release 20.04.00 (Oct 2020) Marked for deletion
Evaluation report.vw_rpt_evaluation_export report.vw_rpt_evaluations Release 20.04.00 (Oct 2020) Marked for deletion
Transaction report.vw_rpt_transaction_export report.vw_rpt_transaction Release 20.04.00 (Oct 2020) Marked for deletion
Training and Transcript report.vw_rpt_transcript_export report.vw_rpt_transcript Release 20.04.00 (Oct 2020) Marked for deletion
Goals report.vw_rpt_goals_base report.vw_rpt_goals Release 20.04.00 (Oct 2020) Marked for deletion
User report.vw_rpt_user_base report.vw_rpt_user Release 20.04.00 (Oct 2020) Marked for deletion
Training and Transcript report.vw_rpt_subject_local report.vw_rpt_subject_local2 Release 20.04.00 (Oct 2020) Marked for deletion
Training and Transcript report.vw_rpt_lo_subject_local report.vw_rpt_subject_local2 Release 20.04.00 (Oct 2020) Marked for deletion
Evaluations, Test report.vw_rpt_qti_text_local report.qna_text_local_core Release 20.04.00 (Oct 2020) Marked for deletion
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) Marked for deletion
Training and Transcript report.vw_rpt_lo_material_type_local report.vw_rpt_training_material_type_local Release 20.04.00 (Oct 2020) Marked for deletion
Training and Transcript report.vw_rpt_session_schedule_local report.vw_rpt_training_part_local Release 20.04.00 (Oct 2020) Marked for deletion

Deprecated Data Exporter Objects

This table describes deprecated objects that are still available in the Data Exporter. These objects are scheduled to be removed in the current and future 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
[lo_root_id] field in [training_core] New field [source_object_id] in [training_core] (it will be available in 19.06.00) Release 20.02.00 (May 2020) Deleted
COMPATIBILITY_ou_title_local [ou_local_core] Release 20.02.00 (May 2020) Deleted
COMPATIBILITY_qti_text_local [qna_text_local_core] Release 20.02.00 (May 2020) Deleted
ou [ou_core] Release 20.02.00 (May 2020) Deleted
training_type [training_type_core] Release 20.02.00 (May 2020) Deleted
training_type_local [training_type_local_core] Release 20.02.00 (May 2020) Deleted
transcript_status [transcript_status_local_core] Use filter for default culture: [is_default] = 1 Release 20.02.00 (May 2020) Deleted
transcript_status_local [transcript_status_local_core] Release 20.02.00 (May 2020) Deleted
training_title_local [training_local_core] Release 20.02.00 (May 2020) Deleted
COMPATIBILITY_custom_field_value_local Custom Field Enumerated Options Localization objects: [application_cf_enum_local_core] [devplan_cf_enum_local_core] [offer_letter_cf_enum_local_core] [ou_cf_enum_local_core] [performance_review_cf_enum_local_core] [succession_cf_enum_local_core] [training_forecast_cf_enum_local_core] [user_cf_enum_local_core] Release 20.02.00 (May 2020) Deleted
custom_field_value Custom Field Enumerated Options Localization objects. Use filter for default culture: [is_default] = 1: [application_cf_enum_local_core] [devplan_cf_enum_local_core] [offer_letter_cf_enum_local_core] [ou_cf_enum_local_core] [performance_review_cf_enum_local_core] [succession_cf_enum_local_core] [training_forecast_cf_enum_local_core] [user_cf_enum_local_core] Release 20.02.00 (May 2020) Deleted
custom_field_value_local Custom Field Enumerated Options Localization objects: [application_cf_enum_local_core] [devplan_cf_enum_local_core] [offer_letter_cf_enum_local_core] [ou_cf_enum_local_core] [performance_review_cf_enum_local_core] [succession_cf_enum_local_core] [training_forecast_cf_enum_local_core] [user_cf_enum_local_core] Release 20.02.00 (May 2020) Deleted
COMPATIBILITY_training_form_cf_display_value_local

[training_cf_enum_local_core]

Release 20.02.00 (May 2020) Deleted
training_subject (RTDW object report.vw_rpt_training_subject) [subject_core] [subject_training_core]   Marked for deletion
Following fields in [goal] object (RTDW object report.vw_rpt_goals) will be deleted: User fields, OU fields, User dynamic relation fields [users_core] [user_ou_pivoted_core] [user_dynamic_relation_core]   Marked for deletion
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.   Marked for deletion
goals_base [goal]   Marked for deletion
evaluation: [eval_question_category_id] field will be renamed to [re_eval_question_category_id]   Release 20.04.00 (Oct 2020) Marked for update
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) Marked for update
COMPATIBILITY_subject_local [subject_local_core] Release 20.04.00 (Oct 2020) Marked for deletion
COMPATIBILITY_training_subject_local [subject_local_core] Release 20.04.00 (Oct 2020) Marked for deletion
COMPATIBILITY_qti_category_local [qna_question_category_local_core] Release 20.04.00 (Oct 2020) Marked for deletion
COMPATIBILITY_ou_type_local [ou_type_local _core] (added in 20.01.03) Release 20.04.00 (Oct 2020) Marked for deletion
training_material_type_local [training_material_type_local_core] Release 20.04.00 (Oct 2020) Marked for deletion
COMPATIBILITY_session_schedule_local [training_part_local_core] Release 20.04.00 (Oct 2020) Marked for deletion
COMPATIBILITY_transcript_user_part_attendance [training_part_core], [training_part_attendance] Release 20.04.00 (Oct 2020) Marked for deletion
instructor [instructor_core] Release 20.04.00 (Oct 2020) Marked for deletion
test_questions [qna_question_core] Release 20.04.00 (Oct 2020) Marked for deletion
training_cf [training_cf_core] Release 20.04.00 (Oct 2020) Marked for deletion
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) Marked for deletion
training_session_schedule [training_part_core], [training_part_local_core] Release 20.04.00 (Oct 2020) Marked for deletion
training_subject_equivalent [subject_equivalent_core], [subject_core] Release 20.04.00 (Oct 2020) Marked for deletion
transcript_cf [transcript_cf_core] Release 20.04.00 (Oct 2020) Marked for deletion
transcript_scorm2004 [scorm2004_activity_session_history], [scorm2004_interaction_history], [training_scorm_core] Release 20.04.00 (Oct 2020) Marked for deletion
user_cf [users_cf_core] Release 20.04.00 (Oct 2020) Marked for deletion