Query Form Cognos2 Service Starter latest previous entry finder

From CCMDB Wiki

Query Form_Cognos2_Service_Starter_latest_previous_entry_finder is used by the "add patient" functionality in CSS to find the latest previous Pat_ID that uses the current CSS line's chart number, to then copy that profile's data. It matches on Admit DtTm.


  • 2022-04-21 - updated query to use Admit DtTm instead of "Arrive DtTm", "Accept DtTm" and Visit Admit DtTm
  • 2021-06-09 - not sure when query was made, just documenting it today

Related articles

Related articles: