skip to main content
Connection Option Descriptions : Config Options : AuditColumns (Config Option)
  

Try DataDirect Drivers Now

AuditColumns (Config Option)

Attribute

AuditColumns

Purpose

Determines whether the driver includes audit fields as table columns when it defines the remote data model to relational table mapping.
The driver supports the following audit columns for standard objects and custom objects:
*ICreatedByAccountID
*CreatedTime
*UpdatedByAccountID
*UpdatedTime

Valid Values

all | custom | standard | none
The value for this option is specified as a key=value pair in the Config Options field. See "Config Options" for details.

Behavior

If set to all, the driver includes all of the audit columns in the relational map.
If set to custom, the driver includes audit columns only for custom objects.
If set to standard, the driver includes audit columns only for standard objects in the relational map.
If set to none, the driver removes audit columns for all objects in the relational map.

Default

all

Notes

*Although the CreatedTime and UpdatedTime fields on custom objects map to the relational view, you cannot query against them unless you enable the fields within the Object Designer in the Oracle Service Cloud admin tool.

GUI Tab

The value for config options are specified in the Config Options field on the Advanced tab.

See also

Config Options