AnsweredAssumed Answered

Explain the timestamps on Work Items and Change Requests

Question asked by Paul Duer on Jun 15, 2016
Latest reply on Jun 19, 2016 by Boris Lekumovich

I am trying to better understand how VIA records timings. I see that these fields are often found:

 

   COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."AVAILABLE_DATE" IS 'Date, with time, that the work item became available.';

   COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."OPEN_DATE" IS 'Date, with time, that the work item was most recently opened.';

   COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."FIRST_OPEN_DATE" IS 'Date, with time, that the work item was first opened.';

   COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."COMPLETE_DATE" IS 'Date, with time, that the work item was completed.';

   COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."DUE_DATE" IS 'Date, with time, that the work item was due.';

 

That text comes from the Change Request Work Item , can someone explain how VIA records timings?

Outcomes