https://community.qlik.com/t5/Suggest-an-Idea/Add-column-in-attrep-status-to-specify-last-processed-timestamp/idi-p/1941925 <P>The attrep_status table provides the replication status at a task level. This table is updated every minute.</P> <P>This table contains 'SOURCE_TIMESTAMP_APPLIED' column which tells the timestamp until which the data is applied to the target. There are a few other columns that provide additional information.</P> <P>However, we are looking to build a monitoring process to determine if the task has processed all the data for a given day. If we see&nbsp;SOURCE_TIMESTAMP_APPLIED value &gt; midnight, we can confidently say that the task has processed all the data for the prior day for the tables it is replicating.</P> <P>However, this is not a foolproof solution. If the tables being replicated within the task are not high velocity, then the&nbsp;SOURCE_TIMESTAMP_APPLIED corresponds to the time when data was committed to target for the task.</P> <P>E.g. if the tables within the task are only updated in CST business time, we may not see any change to&nbsp;SOURCE_TIMESTAMP_APPLIED post 5:00 PM CT. Our monitoring process cannot determine if the data for these tables was processes for yesterday, as it has no way to know that there was no data in source after 5 PM.</P> <P>&nbsp;</P> <P>I would like to propose an enhancement to add 'SOURCE_TIMESTAMP_PROCESSED' or equivalent column. This should be the timestamp value of the most recent transaction from source that was completely processed. This transaction may or may not produce any data for the tables in that task.</P> Fri, 10 Jun 2022 02:51:55 GMT Prabodh 2022-06-10T02:51:55Z https://community.qlik.com/t5/Suggest-an-Idea/Add-column-in-attrep-status-to-specify-last-processed-timestamp/idc-p/2099752#M13031 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/281538" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Wed, 02 Aug 2023 14:56:42 GMT https://community.qlik.com/t5/Suggest-an-Idea/Add-column-in-attrep-status-to-specify-last-processed-timestamp/idc-p/2099752#M13031 Meghann_MacDonald 2023-08-02T14:56:42Z https://community.qlik.com/t5/Suggest-an-Idea/Add-column-in-attrep-status-to-specify-last-processed-timestamp/idc-p/2099753#M13032 Wed, 02 Aug 2023 14:56:43 GMT https://community.qlik.com/t5/Suggest-an-Idea/Add-column-in-attrep-status-to-specify-last-processed-timestamp/idc-p/2099753#M13032 Ideation 2023-08-02T14:56:43Z