Chart number: Difference between revisions

Jvelasco (talk | contribs)
No edit summary
 
(2 intermediate revisions by one other user not shown)
Line 30: Line 30:


== Data Processing ==
== Data Processing ==
The Centralized_data_front_end.mdb has queries that make sure that the chart number for each Hospital site is the same for the same patient and make sure the chart number has valid format.
The [[Centralized_data_front_end.accdb]] has queries that make sure that the chart number for each Hospital site is the same for the same patient and make sure the chart number has valid format.
*query PL_SameCHART_Site_Diff_PHIN
*query [[PL_SameCHART_Site_Diff_PHIN]]
*query PL_SamePHIN_Site_Diff_chart
*query [[PL_SamePHIN_Site_Diff_chart]]
*query PL_Chart_9_Digit
*query [[PL Chart 9 Digit]]


The [[Data Processor]] fixes any inconsistencies found from these queries by crosschecking from EPR and adds the alias identifier to the tmp project [[Alias ID collection]].
The [[Data Processor]] fixes any inconsistencies found from these queries by crosschecking from EPR and adds the alias identifier to the tmp project [[Alias ID collection]].
Line 51: Line 51:
[[Category:Registry Data]]
[[Category:Registry Data]]
[[Category:Demographics]]
[[Category:Demographics]]
[[Category:Cognos Report Integrator]]
[[Category:Data Collection Guide]]