Real-Time Data Warehouse (RTDW) - Optimize CHR Object "forms2-submissions"

This enhancement applies to Cornerstone HR and Cornerstone Recruiting clients running forms reports using the Reporting API, Data Exporter, and Replicated Data Warehouse (RDW). To lessen the risk of ETL failure when generating forms data, the query used to update the “forms2-submissions” object is updated to only return question bank and custom fields used in a form (both published and non-published). Prior tot his enhancement, unused fields were returned.

This functionality was released as part of the 5 June 2020 patch.


This functionality is automatically enabled for all organizations using RTDW.