Staging Tables Used for Import from Source

Table / View Name	Description
TDATASEG_T	Temporary data table used for transforming data from source to target in a data rule execution. To ensure read consistency, data is extracted from the corresponding staging table (for example, AIF_EBS_GL_BALANCES_STG, AIF_EBS_GL_DAILY_BAL_STG, or AIF_PS_LEDGER) and copied to TDATASEG_T (partitioned by LOADID), which is then used for transforming source data to target data based on the data mappings specified in TDATAMAP_T. If you have selected to only “Import from Source,” you can query this table by LOADID to view the data transformations that were applied during the data rule execution.
TDATASEGW	Temporary data table used for transforming write-back data from source to target in a write-back rule execution. Write-back data is extracted from the temporary staging table (AIF_WRITEBACK_ESS_DATA_T) and copied over to TDATASEGW (partitioned by LOADID), which is then used for transforming source data to target data based on the data mappings specified in TDATAMAP_T. If you have selected to only “Import from Source,” you can query this table by LOADID to view the data transformations that were applied during the write-back rule execution.

Table / View Name

Description

TDATASEG_T

Temporary data table used for transforming data from source to target in a data rule execution. To ensure read consistency, data is extracted from the corresponding staging table (for example, AIF_EBS_GL_BALANCES_STG, AIF_EBS_GL_DAILY_BAL_STG, or AIF_PS_LEDGER) and copied to TDATASEG_T (partitioned by LOADID), which is then used for transforming source data to target data based on the data mappings specified in TDATAMAP_T.

If you have selected to only “Import from Source,” you can query this table by LOADID to view the data transformations that were applied during the data rule execution.

TDATASEGW

Temporary data table used for transforming write-back data from source to target in a write-back rule execution. Write-back data is extracted from the temporary staging table (AIF_WRITEBACK_ESS_DATA_T) and copied over to TDATASEGW (partitioned by LOADID), which is then used for transforming source data to target data based on the data mappings specified in TDATAMAP_T.

If you have selected to only “Import from Source,” you can query this table by LOADID to view the data transformations that were applied during the write-back rule execution.