Accept DtTm field: Difference between revisions

mNo edit summary
mNo edit summary
 
Line 4: Line 4:
  | todo_action = 2023-05-04
  | todo_action = 2023-05-04
  | question =  _ccmdb_dev
  | 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
::FROM L_Log
::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
* None left as of 2023-05-04, field can be removed...  
** remove from sending
** remove from sending
** remove from CCMDB_data
** remove from CCMDB_data