Staging Table Node

This node represents the Sun Staging Table created inside the Oracle database. All columns in the table are exposed, and can be dragged and dropped in the Java Collaboration. The node has a name of the form SB_<Oracle_Interface_Table_name> having a maximum length of 30 characters.

The Staging Table is created from the Interface Table with the following six extra fields used to support the pre-validation process:

• SB_EWAY_ID

• SB_GROUP_ID

• SB_OBJECT_ID

• SB_PASS_OR_FAIL

• SB_ERROR_CODE

• SB_ERROR_MESSAGE

All of the ID fields (the first three fields shown above) are used for pre-validation purposes within CAPS.