Try DataDirect Cloud Now
skip to main content
Mapping tab options : System Columns
 

System Columns

You can control how the map identifies system columns for the following data stores:
*Salesforce-created System Columns
*Oracle Service Cloud-created System Columns

Salesforce-created System Columns

By default, when mapping Salesforce system fields to columns in a table, DataDirect Cloud changes system column names to make it evident that the column is a system column. System columns include those for name and id. If the system column names are not changed and you create a new table with id and name columns, the map will need to append a suffix to your columns to differentiate them from the system columns, even if the map option is set to strip suffixes.
If you do not want to change the names of system columns, add a Map System Column Names parameter on the Mapping tab of your data source definition.
Valid values for MapSystemColumnNames are:
Table 181. Valid values for MapSystemColumnNames
Value
Description
0
DataDirect Cloud does not change the names of the Salesforce system columns.
1
DataDirect Cloud changes the names of the Salesforce system columns as described in the following table:
Field Name
Mapped Name
Id
ROWID
Name
SYS_NAME
IsDeleted
SYS_ISDELETED
CreatedDate
SYS_CREATEDDATE
CreatedById
SYS_CREATEDBYID
LastModifiedDate
SYS_LASTMODIFIEDDATE
LastModifiedid
SYS_LASTMODIFIEDID
SystemModstamp
SYS_SYSTEMMODSTAMP
LastActivityDate
SYS_LASTACTIVITYDATE
The default value for MapSystemColumnNames is 1.

Oracle Service Cloud-created System Columns

When mapping Service Cloud system fields to columns in a table, DataDirect Cloud changes the column name to make it evident that the column is a system column. If you do not want to change the names of system columns, set the mapSystemColumnNames key to 0 in Map Options field.
Valid values for mapSystemColumnNames are:
Table 182. Valid values for mapSystemColumnNames
Value
Description
0
DataDirect Cloud does not change the names of the Oracle Service Cloud system columns.
1
DataDirect Cloud changes the names of the Oracle Service Cloud system columns as described in the following table:
Field Name
Mapped Name
Id
ROWID
LookupName
SYS_LOOKUPNAME
CreatedTime
SYS_CREATEDTIME
UpdatedTime
SYS_UPDATEDTIME
CreatedByAccountId
SYS_CREATEDBYACCOUNT_ID
UpdatedByAccountId
SYS_UPDATEDBYACCOUNT_ID
The default value for mapSystemColumnNames is 0.