Search

Configuration Guide

Configuration Guide

10.5

Back Next

Load Batch Job on System Columns

Load Batch Job on System Columns

The effect of a Load batch job varies for some system columns.

The following table describes the effect that a Load batch job insert operation and update operation have on system columns:

System Column	Type of Load Batch Job Operation	Effect on System Column
CREATE_DATE	Insert	The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
CREATE_DATE	Update	The column in the base object retains the original value.
CREATOR	Insert	The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
CREATOR	Update	The column in the base object retains the original value.
UPDATE_BY	Insert	The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
UPDATE_BY	Update	The column in the base object retains the original value. The Load batch job populates the column in the cross-reference table with data from the staging table.
LAST_UPDATE_DATE	Insert	The Load batch job populates the LAST_UPDATE_DATE column in the base object table and cross-reference table with SYSDATE.
LAST_UPDATE_DATE	Update	The Load batch job populates the LAST_UPDATE_DATE column in the base object table and cross-reference table with SYSDATE.
SRC_LUD	Insert	The Load batch job populates the SRC_LUD column with value from the LAST_UPDATE_DATE column.
SRC_LUD	Update	The Load batch job populates the SRC_LUD column with value from the LAST_UPDATE_DATE column.
DELETED_IND	Insert	The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
DELETED_IND	Update	The column in the base object retains the original value.
DELETED_BY	Insert	The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
DELETED_BY	Update	The column in the base object retains the original value.
DELETED_DATE	Insert	The Load batch job populates these columns with data from the staging table. The Load batch job populates these columns with the column default value if the staging table column has a null value.
DELETED_DATE	Update	The column in the base object retains the original value.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.