50 likes | 176 Views
Monitor Lookup. Source File - STF_dss14_2010-050-00_00_00_2010-051-00_00_00_mon0158.gif.ctab. Delete / Reinsert Schedule Item 460653 – Manually Delete from tl_schedule _item Where schedule+item+id = 460653 insert into tl_schedule_item
E N D
Source File - STF_dss14_2010-050-00_00_00_2010-051-00_00_00_mon0158.gif.ctab
Delete / Reinsert Schedule Item 460653 – Manually Delete from tl_schedule_item Where schedule+item+id = 460653 insert into tl_schedule_item (SCHEDULE_ITEM_ID, SCHEDULE_ID, GROUND_ANTENNA_ID, MISSION_ID, SUPPORT_ACTIVITY_ID, EQUIPMENT_CONFIG_CD_ID, BEGINNING_OF_TRACK_TIME_DT, END_OF_TRACK_TIME_DT, START_TIME_DT, END_TIME_DT, ACTIVITY_DESC, PASS_NUM_TXT, WORK_CATEGORY_DESC, SEQUENCE_OF_EVENTS_CD, DIRECTION, UPLINK_ORDER_NUM, DOWNLINK_PRIORITY_NUM, PASS_ID, SET_ID, SPACECRAFT_ID, MIA_DATA_START_DT, MIA_DATA_END_DT, MISSION_BAND_CD, ATTRIBUTES_CD, MCON_BOT_TIME_DT, MCON_EOT_TIME_DT, CRITICAL_CD) values ( 460653,4655,203,12127,225839,4122,to_date('02/19/2010 00:00:00','MM/DD/YYYY HH24:MI:SS'), to_date('02/19/2010 03:00:00','MM/DD/YYYY HH24:MI:SS'), to_date('02/18/2010 22:45:00','MM/DD/YYYY HH24:MI:SS'), to_date('02/19/2010 03:15:00','MM/DD/YYYY HH24:MI:SS'),'T/P ARRAY R','0050','1A1',null,'Unknown',null,null,199779, 218449,79,null,null,'X','---', to_date('02/19/2010 00:00:00','MM/DD/YYYY HH24:MI:SS'), to_date('02/19/2010 03:00:00','MM/DD/YYYY HH24:MI:SS'),null )
Schedule Item Lookup in mapping row4.END_TIME_DT != null && (row2.date_2.before(row4.END_TIME_DT) || row2.date_2.equals(row4.END_TIME_DT)) && row4.START_TIME_DT != null && (row2.date_2.after(row4.START_TIME_DT) || row2.date_2.equals(row4.START_TIME_DT))