ACCU borrow: Difference between revisions
Ttenbergen (talk | contribs) m link |
|||
| Line 25: | Line 25: | ||
needs review from ''Tina'' and ''Julie''. | needs review from ''Tina'' and ''Julie''. | ||
* query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any | * 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) | |||
* query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time) | * 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) | |||
* added code to check that same service in consecutive sequence is not allowed | * 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) | |||
== SAS Program == | == SAS Program == | ||