Template:Combined instructions for Transfer Ready DtTm and Boarding Loc

From CCMDB Wiki
Revision as of 10:25, 2021 August 26 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

This template holds info that should be the same on Transfer Ready DtTm tmp entry and Boarding Loc.

Combining Transfer Ready DtTm tmp entry and Boarding Loc records

There needs to be one Transfer Ready DtTm tmp entry for each Boarding Loc and vice versa. To mark which entries belong together, use the same integer number in the "combiner" field in Patient Viewer Tab Cognos ADT2 for both records and in sequential order according to Boarding start_dt and start_tm. The presence of matching records is validated by query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm, and their sequential status by query s_tmp_check_combined_BL_and_TRDtTm_nonsequential.