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.
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.
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.
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:
- Join report.vw_rpt_certification2 with report.vw_rpt_certification_owner on cert_id = cert_owner__cert_id
- 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)
- Use [user_name_first] , [user_name_last], [user_ref] fields from report.vw_rpt_user.
To get fields of certification contact person:
- 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).
- 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.
Training
and
Transcript |
report.vw_rpt_transcript_curricula |
report.vw_rpt_transcript_src_curriculum |
Release
21.01.00
(Feb
2020) |
Marked
for
deletion |