MDS Paperwork Issue

SELECT * FROM SupportDispense.vDispenseInfo
WHERE PID = fn.ID(4055)
ORDER BY SESSION_ID DESC

UPDATE DISPENSE_SCRIPTS SET RECORD_DELETED = 0, RECORD_STATUS = 2 WHERE SCRIPT_ID = 549755928910
UPDATE DISPENSE_DRUGS SET RECORD_DELETED = 1, RECORD_STATUS = 9 WHERE SCRIPT_ID = 549755928910
UPDATE DISPENSE_SESSIONS SET RECORD_DELETED = 1, RECORD_STATUS = 9 WHERE SESSION_ID = 549756027323

UPDATE DISPENSE_DRUGS SET RECORD_DELETED = 0, RECORD_STATUS = 2 WHERE DISPENSE_ID IN (549756087922,
549756087923,
549756087924,
549756087925,
549756087926,
549756087927,
549756087928)

SELECT * FROM DISPENSE_DOSAGES WHERE DISPENSE_ID IN (549756087922,
549756087923,
549756087924,
549756087925,
549756087926,
549756087927,
549756087928)

UPDATE DISPENSE_DOSAGES SET CYCLE_ID = 549755814925 WHERE DISPENSE_ID IN (549756087922,
549756087923,
549756087924,
549756087925,
549756087926,
549756087927,
549756087928)

UPDATE DISPENSE_DOSAGES SET SEPARATE_ITEM = 1 WHERE DISPENSE_ID = 549756087928

SELECT * FROM DOSAGE_CYCLES WHERE CYCLE_ID IN (549755814924,549755814925)

-----------------------------------------------

UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-01 00:00:00.000', DISPENSE_ID = 549756087922 WHERE CYCLE_NUMBER = 1 AND RECORD_ID = 549756074632
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-08 00:00:00.000', DISPENSE_ID = 549756087922 WHERE CYCLE_NUMBER = 2 AND RECORD_ID = 549756074633
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-15 00:00:00.000', DISPENSE_ID = 549756087922 WHERE CYCLE_NUMBER = 3 AND RECORD_ID = 549756074634
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-22 00:00:00.000', DISPENSE_ID = 549756087922 WHERE CYCLE_NUMBER = 4 AND RECORD_ID = 549756074635
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-01 00:00:00.000', DISPENSE_ID = 549756087923 WHERE CYCLE_NUMBER = 1 AND RECORD_ID = 549756074636
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-08 00:00:00.000', DISPENSE_ID = 549756087923 WHERE CYCLE_NUMBER = 2 AND RECORD_ID = 549756074637
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-15 00:00:00.000', DISPENSE_ID = 549756087923 WHERE CYCLE_NUMBER = 3 AND RECORD_ID = 549756074638
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-22 00:00:00.000', DISPENSE_ID = 549756087923 WHERE CYCLE_NUMBER = 4 AND RECORD_ID = 549756074639
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-01 00:00:00.000', DISPENSE_ID = 549756087924 WHERE CYCLE_NUMBER = 1 AND RECORD_ID = 549756074640
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-08 00:00:00.000', DISPENSE_ID = 549756087924 WHERE CYCLE_NUMBER = 2 AND RECORD_ID = 549756074641
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-15 00:00:00.000', DISPENSE_ID = 549756087924 WHERE CYCLE_NUMBER = 3 AND RECORD_ID = 549756074642
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-22 00:00:00.000', DISPENSE_ID = 549756087924 WHERE CYCLE_NUMBER = 4 AND RECORD_ID = 549756074643
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-01 00:00:00.000', DISPENSE_ID = 549756087925 WHERE CYCLE_NUMBER = 1 AND RECORD_ID = 549756074644
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-08 00:00:00.000', DISPENSE_ID = 549756087925 WHERE CYCLE_NUMBER = 2 AND RECORD_ID = 549756074645
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-15 00:00:00.000', DISPENSE_ID = 549756087925 WHERE CYCLE_NUMBER = 3 AND RECORD_ID = 549756074646
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-22 00:00:00.000', DISPENSE_ID = 549756087925 WHERE CYCLE_NUMBER = 4 AND RECORD_ID = 549756074647
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-01 00:00:00.000', DISPENSE_ID = 549756087926 WHERE CYCLE_NUMBER = 1 AND RECORD_ID = 549756074648
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-08 00:00:00.000', DISPENSE_ID = 549756087926 WHERE CYCLE_NUMBER = 2 AND RECORD_ID = 549756074649
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-15 00:00:00.000', DISPENSE_ID = 549756087926 WHERE CYCLE_NUMBER = 3 AND RECORD_ID = 549756074650
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-22 00:00:00.000', DISPENSE_ID = 549756087926 WHERE CYCLE_NUMBER = 4 AND RECORD_ID = 549756074651
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-01 00:00:00.000', DISPENSE_ID = 549756087927 WHERE CYCLE_NUMBER = 1 AND RECORD_ID = 549756074652
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-08 00:00:00.000', DISPENSE_ID = 549756087927 WHERE CYCLE_NUMBER = 2 AND RECORD_ID = 549756074653
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-15 00:00:00.000', DISPENSE_ID = 549756087927 WHERE CYCLE_NUMBER = 3 AND RECORD_ID = 549756074654
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-22 00:00:00.000', DISPENSE_ID = 549756087927 WHERE CYCLE_NUMBER = 4 AND RECORD_ID = 549756074655
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-01 00:00:00.000', DISPENSE_ID = 549756087928 WHERE CYCLE_NUMBER = 1 AND RECORD_ID = 549756074656
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-08 00:00:00.000', DISPENSE_ID = 549756087928 WHERE CYCLE_NUMBER = 2 AND RECORD_ID = 549756074657
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-15 00:00:00.000', DISPENSE_ID = 549756087928 WHERE CYCLE_NUMBER = 3 AND RECORD_ID = 549756074658
UPDATE DISPENSE_DOSAGES SET START_DATE = '2014-12-22 00:00:00.000', DISPENSE_ID = 549756087928 WHERE CYCLE_NUMBER = 4 AND RECORD_ID = 549756074659


SELECT * FROM DISPENSE_DOSAGES WHERE RECORD_ID >= 549756074632 AND RECORD_ID <= 549756074659