<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
According to <a href="http://www.salesforce.com/us/developer/docs/api/Content/system_fields.htm" rel="ugc">SF's page on System Fields</a>, SystemModstamp gets updated 'Date and time when this record was last modified by a user <b>or by an automated process (such as a trigger).</b> '.<br />
<br />
<b>Question: &nbsp;Does anyone have a definitive list of 'or by an automated process'?</b><br />
<br />
Reason I ask is because I have an SSIS package connecting to SalesForce.com where each Data Source has ... 'WHERE SystemModstamp &gt;&nbsp;&lt;@User::dt_last_success&gt;',<wbr /> and I'm observing that I'm getting way more rows that are reflected in a day's data entry activity. I haven't proved this yet by doing a compare of rows across days, but that might be coming.<br />
<br />
Thanks in advance. Jim
</div>
</div>


Hi All

According to SF's page on System Fields (http://www.salesforce.com/us/developer/docs/api/Content/system_fields.htm), SystemModstamp gets updated 'Date and time when this record was last modified by a user or by an automated process (such as a trigger). '.

Question:  Does anyone have a definitive list of 'or by an automated process'?

Reason I ask is because I have an SSIS package connecting to SalesForce.com where each Data Source has ... 'WHERE SystemModstamp > <@User::dt_last_success>', and I'm observing that I'm getting way more rows that are reflected in a day's data entry activity. I haven't proved this yet by doing a compare of rows across days, but that might be coming.

Thanks in advance. Jim

Salesforce.com:  LastModifiedDate vs. SystemModstamp

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.