Accept DtTm field: Difference between revisions

mNo edit summary
mNo edit summary
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
  | who = Tina  
  | who = Tina  
  | todo_added = 2022-06-30
  | todo_added = 2022-06-30
  | todo_action = 2022-10-30
  | todo_action = 2023-05-04
  | question =  _after
  | question =  _ccmdb_dev
* Field is legacy; once no longer used, remove it from sending and then from ccmdb_data. Query to check:
* Field is legacy; once no longer used, remove it from sending and then from ccmdb_data.  
::SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm
** remove from sending
::FROM L_Log
** remove from CCMDB_data
::WHERE (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Accept_DtTm) Is Not Null) AND ((L_Log.Arrive_DtTm) Is Not Null));
* 98 left as of 2022-08-04
  }}
  }}