RTDW Updates to Reporting API, RDW, and Data Exporter

Impacting only clients using Reporting API, Replicated Data Warehouse, 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.

RTDW Deprecated Objects - For Feb’ 20 Release

This table describes the objects that will be deprecated with the Aug '19 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 transcript fields in report.vw_rpt_certification Transcript fields in report.vw_rpt_transcript. Join report.vw_rpt_certification with report.vw_rpt_transcript on user_id = transc_user_id and cert_object_id = transc_object_id and reg_num = reg_num Release 20.01.00 (Feb 2020) Deleted
Compliance report.vw_rpt_compliance No replacement, 'Compliance Report' Report Category was deprecated and deleted in Release 19.02.00 (May 2019). Release 20.01.00 (Feb 2020) Deleted
Evaluation transcript fields in report.vw_rpt_evaluations Transcript fields in report.vw_rpt_transcript. Join report.vw_rpt_evaluations with report.vw_rpt_transcript on target_user_id = transc_user_id and re_eval_lo_id = transc_object_id eval_reg_num (new field that will be added) = reg_num Release 20.01.00 (Feb 2020) Deleted
Test transcript fields in report.vw_rpt_test Transcript fields in report.vw_rpt_transcript. Join report.vw_rpt_test with report.vw_rpt_transcript on eval_user_id = transc_user_id and eval_lo_id = transc_object_id and eval_reg_num = reg_num Release 20.01.00 (Feb 2020) Deleted
Transaction transcript fields in report.vw_rpt_transaction Transcript fields in report.vw_rpt_transcript. Join report.vw_rpt_transaction with report.vw_rpt_transcript on rb_user_id = transc_user_id and rb_object_id = transc_object_id and trans_reg_num = reg_num Release 20.01.00 (Feb 2020) Deleted
Training and Transcript [user_lo_remover_first_name], [user_lo_remover_last_name] fields in report.vw_rpt_transcript [user_name_first] , [user_name_last] fields in report.vw_rpt_user. Join report.vw_rpt_transcript with report.vw_rpt_user on user_lo_remover_id ( new field that will be added to report.vw_rpt_transcript) = user_id (in report.vw_rpt_user) Release 20.01.00 (Feb 2020) Deleted
Training and Transcript [exemptor_ref], [exemptor_full_name] fields in report.vw_rpt_transcript [user_ref], [user_name_first], [user_name_last] fields in report.vw_rpt_user. Join report.vw_rpt_transcript with report.vw_rpt_user on exemptor_id = user_id Release 20.01.00 (Feb 2020) Deleted
Training and Transcript [user_part_attendance] field in report.vw_rpt_transcript New report object with [user_part_attendance] field will be provided Release 20.01.00 (Feb 2020) Deleted
Training and Transcript [user_lo_status] field in report.vw_rpt_transcript [status] in report.vw_rpt_transcript_status_local Join report.vw_rpt_transcript with report.vw_rpt_transcript_status_local on user_lo_status_id (in report.vw_rpt_transcript) = status_id and culture_id =1 (default culture) Release 20.01.00 (Feb 2020) Deleted
User OU fields in report.vw_rpt_user report.vw_rpt_user_ou_info 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.01.00 (Feb 2020) Marked for deletion
User User dynamic relation fields in report.vw_rpt_user report.vw_rpt_user_dynamic_relation 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.01.00 (Feb 2020) Marked for deletion

Scheduled Changes in RTDW Objects

This table describes changes in RTDW objects for future releases.

Category

OBject/fields

Date of scheduled change

Action

Development Plan Datatype for [target_dt] field in report.vw_rpt_devplan will be changed from smalldatetime to datetime. Release 20.01.00 (Feb 2020) Marked for update
Succession

Datatype of the succession custom fields in report.vw_rpt_succession_incumbent_smp_cf will be changed from nvarchar(4000) to datatype based on the custom field type, e.g.:

  • ‘Checkbox’: bit
  • ‘Date Field’: datetime
  • ‘Numeric Field ‘: float
  • ‘Short Text Box’: nvarchar(200)
  • ‘Scrolling Text Box: nvarchar(2000)
Release 20.01.00 (Feb 2020) Marked for update
Training Plan Datatype and values for training plan custom fields of type Enumerated Options in report.vw_rpt_training_plan_forecasted_item will be changed: Datatype: from nvarchar(200) to int Values: from Option label to Option ID Release 20.01.00 (Feb 2020) Marked for update
Evaluation Transcript fields will be removed from report.vw_rpt_evaluations (as described in RTDW Deprecated Objects), new field eval_reg_num - the registration number for the transcript will be added. Before the change, report.vw_rpt_evaluations has transcript fields for trainings only with latest registration (is_latest_reg_num = 1). After change, joining report.vw_rpt_evaluations and report.vw_rpt_transcript will allow to have transctipt fields for all registered trainings. Release 20.01.00 (Feb 2020) Updated
User Data in report.vw_rpt_user_ou_info after change will include users’ OU details for OU of all OU types which allow singular membership. Before change report.vw_rpt_user_ou_info includes users’ OU details for OU of the OU types that have defined in application flag ‘Show in Analytics‘ and excuded OU type ‘Group’ Release 20.01.00 (Feb 2020) Marked for update

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
[user_ou] (RTDW object report.vw_rpt_user_ou) [user_ou_core] - User-OU associations that exclude Organizational Units that have OU types: "Legacy Availability", "Deprecated Legacy Availability” Release 20.01.00 (Feb 2020) Marked for deletion
user_groups_core [user_ou_multi_core] - User-OU associations (multi-membership only). This is a subset of user_ou_core whose OU types allow for multi-membership. Note: deprecated [user_groups_core] included User-OU associations only for OU type ‘Group’. [user_ou_multi_core] includes all multi-membership User-OU associations, for OU type ‘Group’ use filter ou_type_id = 128 . Release 20.01.00 (Feb 2020) Marked for deletion
ou_type [ou_type_core] – OU type master list that excludes OU types: "Legacy Availability", "Deprecated Legacy Availability” and inactive OU types Release 20.01.00 (Feb 2020) Marked for deletion
compliance No replacement, 'Compliance Report' Report Category was deprecated and deleted in Release 19.02.00 (May 2019). Release 20.01.00 (Feb 2020) Marked for deletion

Following fields in [transcript] object (documented in RTDW Documentation:

report.vw_rpt_transcript) [user_lo_remover_first_name],

[user_lo_remover_last_name],

[exemptor_ref], [exemptor_full_name],

[user_part_attendance], [user_lo_status]

  Release 20.01.00 (Feb 2020) Marked for deletion

Datatype for [target_dt] field in [devplan],

[due_dt] field in [devplan_core],

will be changed from smalldatetime to datetime

  Release 20.01.00 (Feb 2020) Marked for deletion
[lo_root_id] field in [training_core] New field [source_object_id] in [training_core] (it will be available in 19.04.01) Release 20.02.00 (May 2020) Marked for deletion
COMPATIBILITY_ou_title_local [ou_local_core] Release 20.02.00 (May 2020) Marked for deletion
COMPATIBILITY_qti_text_local [qna_text_local_core] Release 20.02.00 (May 2020) Marked for deletion
ou [ou_core] Release 20.02.00 (May 2020) Marked for deletion
training_type [training_type_core] Release 20.02.00 (May 2020) Marked for deletion
training_type_local [training_type_local_core] Release 20.02.00 (May 2020) Marked for deletion
transcript_status [transcript_status_local_core] Use filter for default culture: [is_default] = 1 Release 20.02.00 (May 2020) Marked for deletion
transcript_status_local [transcript_status_local_core] Release 20.02.00 (May 2020) Marked for deletion
training_title_local [training_local_core] Release 20.02.00 (May 2020) Marked for deletion
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) Marked for deletion
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) Marked for deletion
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) Marked for deletion
COMPATIBILITY_training_form_cf_display _value_local [training_cf_enum_local_core] Release 20.02.00 (May 2020) Marked for deletion