System Fields

The following fields are read-only fields found on most objects. These fields are automatically updated during API operations. For example, the ID field is automatically generated during a create operation and the LastModifiedDate is automatically updated during any operation on an object.

Field	Field Type	Description
Id	ID	Globally unique string that identifies a record. For information on IDs, see ID Field Type. Because this field exists in every object, it is not listed in the field table for each object. Id fields have Defaulted on create and Filter access.
IsDeleted	boolean	Indicates whether the record has been moved to the Recycle Bin (`true`) or not (`false`). Because this field does not appear in all objects, it is listed in the field table for each object.
Audit Fields
CreatedById	reference	ID of the User who created this object. CreatedById fields have Defaulted on create and Filter access.
CreatedDate	dateTime	Date and time when this object was created. CreatedDate fields have Defaulted on create and Filter access.
LastModifiedById	reference	ID of the User who last updated this object. LastModifiedById fields have Defaulted on create and Filter access.
LastModifiedDate	dateTime	Date and time when this object was last modified by a user. LastModifiedDate fields have Defaulted on create and Filter access.
SystemModstamp	dateTime	Date and time when this record was last modified by a user or by a workflow process (such as a trigger). SystemModstamp fields have Defaulted on create and Filter access.

If you import data into Salesforce.com and need to set the value for an audit field, contact salesforce.com. Once salesforce.com enables this capability for your organization, you can set audit field values for the following objects: Account, CampaignMember, Case, CaseComment, Contact, Idea, IdeaComment, Lead, Opportunity, and Vote. The only audit field you cannot set a value for is systemModstamp.

For information on setting audit fields for custom objects, see Audit Fields for Custom Objects.

These standard objects do not have the audit fields:

Object	No Created byId	No Created Date	No LastMod ifiedById	No LastMod ifiedDate	No System Modstamp	Only System Modstamp (no other audit fields)
AccountShare	X	X			X
AccountTerritoryAssignmentRule	X	X			X
CaseComment			X	X
CaseHistory			X	X	X
CaseSolution			X	X
CaseShare	X	X			X
EmailStatus					X
EntityHistory			X	X	X
FiscalYearSettings						X
GroupMember						X
LeadShare	X	X			X
Name					X	X
OpportunityHistory			X	X
OpportunityShare	X	X			X
Period						X
ProcessInstanceHistory			X	X
ProcessInstanceStep			X	X
ProcessInstanceWorkitem			X	X
QuantityForecastHistory			X	X
RevenueForecastHistory			X	X
Territory	X	X
UserRole	X	X
UserTerritory	X	X

Parent Reference Fields

If an object has a relationship to a parent object, two fields are added:

Parent_Name contains the object name of the parent. For example, Case has a Contact field that contains a reference to the contact parent of the case.
Parent_NameId contains the ID of the parent. For example, Case has a ContactId field that refers to the contact parent of the case. This field is used in SOQL relationship queries such as the following:
```
SELECT Case.ContactId, Case.Contact.Name FROM Case
```

Even if the object can parent itself, these fields occur. For example, the Campaign object has a Campaign and CampaignId field for referencing the parent Campaign.