Boarding Loc: Difference between revisions

Line 29:

** start_dt and start_tm:

*** enter as per Cognos initially

*** before setting [[RecordStatus]] to complete~~, change~~ the ~~'''first''' Boarding Loc~~ DtTm to ~~be consistent~~ with ~~the First [[Service tmp entry]]; see~~ [[DtTm for First Boarding Loc and First Service]] ~~and also the "Special Case" headings below~~

*** before setting [[RecordStatus]] to complete update the DtTm to comply with [[DtTm for First Boarding Loc and First Service]]

** checkbox: not used for this project

** Item:

Line 47:

==== Special Case - Can't have two Boarding Locs with same DtTm ====

* '''No two different boarding locations should have same start_dt and start_tm.'''

** if two ~~boarding~~ locations have the same Start_DtTm, this is an error~~, change~~ one to be off by one minute, put a note in ~~"notes" section~~ to check boarding location to confirm the correct date and time for the boarding locations of concern.

** if two locations have the same Start_DtTm in [[CSS]]/[[Cognos2 Unit Starter]] this is an error. Change one to be off by one minute, put a note in [[Notes field]] to check boarding location to confirm the correct date and time for the boarding locations of concern.

** example: Not infrequently, the COGNOS data for HSC_SICU patients coming from the ER, will show the first service, first boarding location(ER) and the second boarding location(SICU) as all having the same start_DtTm. Our solution for this is ~~to change the, second boarding location (SICU) to be off by one minute. We then put a note~~ in the ~~notes section to confirm the boarding location(s) date~~ and ~~time and the first service_DtTm.~~

** This case is especially common in the context of [[DtTm for First Boarding Loc and First Service]]

==== Special Case - GRA MICU boarding in GH-Emergency ====

@@ Line 29: / Line 29: @@
 ** start_dt and start_tm:
 *** enter as per Cognos initially
-*** before setting [[RecordStatus]] to complete, change the '''first''' Boarding Loc DtTm to be consistent with the First [[Service tmp entry]]; see [[DtTm for First Boarding Loc and First Service]] and also the "Special Case" headings below
+*** before setting [[RecordStatus]] to complete update the DtTm to comply with [[DtTm for First Boarding Loc and First Service]]
 ** checkbox: not used for this project <!-- was used for [[cross check]]s in data before 2020-10-15 -->
 ** Item:
@@ Line 47: / Line 47: @@
 ==== Special Case - Can't have two Boarding Locs with same DtTm ====
 * '''No two different boarding locations should have same start_dt and start_tm.'''
-** if two boarding locations have the same Start_DtTm, this is an error, change one to be off by one minute, put a note in "notes" section to check boarding location to confirm the correct date and time for the boarding locations of concern.
+** if two locations have the same Start_DtTm in [[CSS]]/[[Cognos2 Unit Starter]] this is an error. Change one to be off by one minute, put a note in [[Notes field]] to check boarding location to confirm the correct date and time for the boarding locations of concern.
-** example: Not infrequently, the COGNOS data for HSC_SICU patients coming from the ER,  will show the first service, first boarding location(ER) and the second boarding location(SICU) as all having the same start_DtTm.  Our solution for this is to change the, second boarding location (SICU) to be off by one minute.  We then put a note in the notes section to confirm the boarding location(s) date and time and the first service_DtTm.
+{{DL | to check ''where'', ie what is the reference}}
+** This case is especially common in the context of [[DtTm for First Boarding Loc and First Service]]
 ==== Special Case - GRA MICU boarding in GH-Emergency ====