Skip to Content

Need to get the Time Stamp for when the Master Agreement was changed to Executed Status

Hi All,

I need to pull the time-stamp details of when a Master Agreement was changed to status "Executed" and report it on a custom report

I am trying to achieve cycle time metrics for

Since this is not an extension, which field in the time-stamp table should I pick from, its also not clear from the "Browse Extension Schema" since its a standard field

Any thoughts, would be appreciated

Hi@Vikram Shanmugasundaram does the standard cycle time metrics report have any bearing or resemblance to this? if yes, have you encountered this in the past, would love to hear from you

Cheers

Tridip

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    May 01, 2012 at 11:32 AM

    Hi Tridip,
    You may want to check the FCI_DOC_CHG_HISTORY table where the change history information is stored. I believe MA status change is one of the items that is tracked in the change history table. Note, since change history table is a common table used by other areas of the system, caution must be applied when quering this table. Make sure to use the context id and parent class id in the WHERE clause.

    Another approach would be to track Executed status change on an extension field and then pull in that field in your report.

    Hope this helps.

    Regards,
    Vikram

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tridip,
      Making the extension field non editable probably would be a better approach as it allows you to easily set the date via scripting and also report on that field.

      With the change history table it is not going to be straight forward as the data would have to be parsed.

      Regards,
      Vikram