How to pull the initial publish date of a contract term in reporting

[justinlalonde]

Hello all,

So I'm working through the reporting, specifically related to contracts (contract term) and I'm trying to pull in a field that will show the initial publish date for each respective contract term. Essentially, want to have the date it first became active in our system.

In reviewing the data field dictionary I'm not seeing the correct field as Load Update Time & Load Create Time do not bring in the date the contract first became active in our system. I'm using the "Contract" fact table as my main fact.