ACCU borrow: Difference between revisions

Line 34:

needs review from ''Tina'' and ''Julie''.

* query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any

** this query should be replaced by this - Single record D_ID should have Item equal to 'MICU' or 'CICU' and should not have an item='ACCU' ~~(i.e.~~ if an item is 'ACCU', there should be another entry of same D_ID having an item of either 'MICU' or 'CICU'). ~~[[User:JMojica|JMojica]] 12~~:14, 2017 ~~March 16~~ (CDT)

** this query should be replaced by this:

*** Single record D_ID should have Item equal to 'MICU' or 'CICU' and should not have an item='ACCU'

*** if an item is 'ACCU', there should be another entry of same D_ID having an item of either 'MICU' or 'CICU')

**** I need to understand more about this before I can implement... Ttenbergen 21:57, 2017 July 29 (CDT)

* query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time)

**Need to change the query name. [[User:JMojica|JMojica]] 12:14, 2017 March 16 (CDT)

*** why is that? Ttenbergen 21:57, 2017 July 29 (CDT)

* added code to check that same service in consecutive sequence is not allowed

** This is OK. [[User:JMojica|JMojica]] 12:14, 2017 March 16 (CDT)

*** "next record" comparisons are not supported natively by Access. Is this check vital? It's possible but would be somewhat messy to implement. Ttenbergen 21:57, 2017 July 29 (CDT)

== SAS Program ==

@@ Line 34: / Line 34: @@
 needs review from ''Tina'' and ''Julie''.
 * query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any
-** this query should be replaced by this - Single record D_ID should have Item equal to 'MICU' or 'CICU' and should not have an item='ACCU' (i.e. if an item is 'ACCU', there should be another entry of same D_ID having an item of either 'MICU' or 'CICU').  [[User:JMojica|JMojica]] 12:14, 2017 March 16 (CDT)
+** this query should be replaced by this:
+*** Single record D_ID should have Item equal to 'MICU' or 'CICU' and should not have an item='ACCU'
+*** if an item is 'ACCU', there should be another entry of same D_ID having an item of either 'MICU' or 'CICU')
+**** I need to understand more about this before I can implement... Ttenbergen 21:57, 2017 July 29 (CDT)
+{{discussion}}
 * query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time)
 **Need to change the query name. [[User:JMojica|JMojica]] 12:14, 2017 March 16 (CDT)
+*** why is that? Ttenbergen 21:57, 2017 July 29 (CDT)
+{{discussion}}
 * added code to check that same service in consecutive sequence is not allowed
 ** This is OK. [[User:JMojica|JMojica]] 12:14, 2017 March 16 (CDT)
+*** "next record" comparisons are not supported natively by Access. Is this check vital? It's possible but would be somewhat messy to implement. Ttenbergen 21:57, 2017 July 29 (CDT)
 == SAS Program ==