A TDATASEG Table Reference
The TDATASEG table is used to store the data loaded by the user and any transformations between the source dimension members and results of the mapping process.
Note:
When loading text, the column in TDATASEG it is loaded to DATA, and the mapped result is loaded to DATAX.Table A-1 TDATASEG Table Reference
Column Name | Definition | Description |
---|---|---|
DATAKEY | NUMBER(31,0) NOT NULL ENABLE | System generated unique key for each row of data |
PARTIONNKEY | NUMBER(10,0) NOT NULL ENABLE | Location key. Join to TPOVPARTITION to retrieve location information. |
CATKEY | NUMBER(10,0) NOT NULL ENABLE | Category Key. Join to TPOVCATEGORY to retrieve category information. |
PERIODKEY | DATE NOT NULL ENABLE | Period Key. Join to TPOVPERIOD to retrieve Data Management to EPM period mapping details. |
DATAVIEW | VARCHAR2(20 CHAR) DEFAULT 'YTD' NOT NULL ENABLE | Hard coded to YTD for file, and set to YTD for balance sheet and PTD for income statement when pulling data from an Enterprise Resource Planning (ERP) system. |
CURKEY | VARCHAR2(25 CHAR) DEFAULT | Currency code of the data. |
CALCACCTTYPE | NUMBER(6,0) DEFAULT 9 NOT NULL ENABLE | Indicates if row was imported from source or computed by Logic Group:
|
CHANGESIGN | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE | Indicates that the sign of the imported amount should be reversed:
|
JOURNALID | VARCHAR2(80 CHAR) DEFAULT | ID for the Journal. User provided value |
AMOUNT | NUMBER(38,12) DEFAULT 0 NOT NULL ENABLE | Amount loaded from source |
AMOUNTX | NUMBER(38, 12) DEFAULT 0 NOT NULL ENABLE | Amount after any transformation rules. This value is loaded to the target application. |
DESC1 | VARCHAR2(300 CHAR) DEFAULT | Description can be imported from file |
DESC2 | VARCHAR2(300 CHAR) DEFAULT | Description can be imported from file |
ACCOUNT | VARCHAR2(300 CHAR) NOT NULL ENABLE | Account member from source |
ACCOUNTX | VARCHAR2(2000 CHAR) DEFAULT | Account member after mapping rules processed |
ACCOUNTR | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE | Key to Mapping used for this dimension. Refers to DATAKEY in TDATAMAPSEG. |
ACCOUNTF | NUMBER(6,0) DEFAULT 0 NOT NULL ENABLE | Map types:
|
ENTITY | VARCHAR2(300 CHAR) DEFAULT | Entity member from source |
ENTITYX | VARCHAR2(300 CHAR) DEFAULT | Entity member after mapping rules processed. This value is exported. |
ENTITYR | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE | Key to Mapping used for this dimension. Refers to DATAKEY in TDATAMAPSEG |
ENTITYF | NUMBER(6,0) DEFAULT 0 NOT NULL ENABLE | Map types:
|
ICP | VARCHAR2(300 CHAR) DEFAULT | ICP from source |
ICPX | VARCHAR2(300 CHAR) DEFAULT | ICP after mapping rules processed. This value is exported. |
ICPR | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE | Key to mapping used for this dimension. Refers to DATAKEY in TDATAMAPSEG. |
ICPF | NUMBER(6,0) DEFAULT 0 NOT NULL ENABLE | Map type:
|
UD1 | VARCHAR2(280 CHAR) DEFAULT | UD1 from source |
UD1X | VARCHAR2(280 CHAR) DEFAULT | UD1 after mapping rules processed. This value is exported. |
UD1R | VARCHAR2(10, 0 CHAR) DEFAULT | Key to mapping used for this dimension. Refers to DATAKEY in TDATAMAPSEG |
UD1F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | Map type:
|
UD2 | VARCHAR2(300 CHAR) DEFAULT | UD2 from source |
UD2X | VARCHAR2(300 CHAR) DEFAULT | UD2X from source |
UD2R | VARCHAR2(10, 0 CHAR) DEFAULT | UD2R from source |
UD2F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD2F from source |
UD3 | VARCHAR2(300 CHAR) DEFAULT | UD3 from source |
UD3X | VARCHAR2(300 CHAR) DEFAULT | UD3X from source |
UD3R | VARCHAR2(10, 0 CHAR) DEFAULT | UD3R from source |
UD3F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD3F from source |
UD4 | VARCHAR2(300 CHAR) DEFAULT | UD4 from source |
UD4X | VARCHAR2(300 CHAR) DEFAULT | UD4X from source |
UD4R | VARCHAR2(10, 0 CHAR) DEFAULT | UD4R from source |
UD4F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD4F from source |
UD5 | VARCHAR2(300 CHAR) DEFAULT | UD5 from source |
UD5X | VARCHAR2(300 CHAR) DEFAULT | UD5X from source |
UD5R | VARCHAR2(10, 0 CHAR) DEFAULT | UD5R from source |
UD5F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD5F from source |
UD6 | VARCHAR2(300 CHAR) DEFAULT | UD6 from source |
UD6X | VARCHAR2(300 CHAR) DEFAULT | UD6X from source |
UD6R | VARCHAR2(10, 0 CHAR) DEFAULT | UD6R from source |
UD6F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD6F from source |
UD7 | VARCHAR2(300 CHAR) DEFAULT | UD7 from source |
UD7X | VARCHAR2(300 CHAR) DEFAULT | UD7X from source |
UD7R | VARCHAR2(10, 0 CHAR) DEFAULT | UD7R from source |
UD7F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD7F from source |
UD8 | VARCHAR2(300 CHAR) DEFAULT | UD8 from source |
UD8X | VARCHAR2(300 CHAR) DEFAULT | UD8X from source |
UD8R | VARCHAR2(10, 0 CHAR) DEFAULT | UD8R from source |
UD8F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD8F from source |
ARCHIVEID | NUMBER(31,0) DEFAULT 0 NOT NULL ENABLE | Future use |
HASMEMOITEM | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE | Future use |
STATICDATAKEY | NUMBER(31,0) DEFAULT 0 NOT NULL ENABLE | Future use |
UD9 | VARCHAR2(300 CHAR) DEFAULT | UD9 from source |
UD9X | VARCHAR2(300 CHAR) DEFAULT | UD9X from source |
UD9R | VARCHAR2(10, 0 CHAR) DEFAULT | UD9R from source |
UD9F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD9F from source |
UD10 | VARCHAR2(300 CHAR) DEFAULT | UD10 from source |
UD10X | VARCHAR2(300 CHAR) DEFAULT | UD10X from source |
UD10R | VARCHAR2(10, 0 CHAR) DEFAULT | UD10R from source |
UD10F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD10F from source |
UD11 | VARCHAR2(300 CHAR) DEFAULT | UD11 from source |
UD11X | VARCHAR2(300 CHAR) DEFAULT | UD11X from source |
UD11R | VARCHAR2(10, 0 CHAR) DEFAULT | UD11R from source |
UD11F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD11F from source |
UD12 | VARCHAR2(300 CHAR) DEFAULT | UD12 from source |
UD12X | VARCHAR2(300 CHAR) DEFAULT | UD12X from source |
UD12R | VARCHAR2(10, 0 CHAR) DEFAULT | UD12R from source |
UD12F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD12F from source |
UD13 | VARCHAR2(300 CHAR) DEFAULT | UD13 from source |
UD13X | VARCHAR2(300 CHAR) DEFAULT | UD13X from source |
UD13R | VARCHAR2(10, 0 CHAR) DEFAULT | UD13R from source |
UD13F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD13F from source |
UD14 | VARCHAR2(300 CHAR) DEFAULT | UD14 from source |
UD14X | VARCHAR2(300 CHAR) DEFAULT | UD14X from source |
UD14R | VARCHAR2(10, 0 CHAR) DEFAULT | UD14R from source |
UD14F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD14F from source |
UD15 | VARCHAR2(80 CHAR) DEFAULT | UD15 from source |
UD15X | VARCHAR2(300 CHAR) DEFAULT | UD15X from source |
UD15R | VARCHAR2(10, 0 CHAR) DEFAULT | UD15R from source |
UD15F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD15F from source |
UD16 | VARCHAR2(300 CHAR) DEFAULT | UD16 from source |
UD16X | VARCHAR2(300 CHAR) DEFAULT | UD16X from source |
UD16R | VARCHAR2(10, 0 CHAR) DEFAULT | UD16R from source |
UD16F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD16F from source |
UD17 | VARCHAR2(300 CHAR) DEFAULT | UD17 from source |
UD17X | VARCHAR2(300 CHAR) DEFAULT | UD1X from source |
UD17R | VARCHAR2(10, 0 CHAR) DEFAULT | UD17R from source |
UD17F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD17F from source |
UD18 | VARCHAR2(300 CHAR) DEFAULT | UD18 from source |
UD18X | VARCHAR2(300 CHAR) DEFAULT | UD18X from source |
UD18R | VARCHAR2(10, 0 CHAR) DEFAULT | UD18R from source |
UD18F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD18F from source |
UD19 | VARCHAR2(300 CHAR) DEFAULT | UD19 from source |
UD19X | VARCHAR2(300 CHAR) DEFAULT | UD19X from source |
UD19R | VARCHAR2(10, 0 CHAR) DEFAULT | UD19R from source |
UD19F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD19F from source |
UD20 | VARCHAR2(300 CHAR) DEFAULT | UD20 from source |
UD20X | VARCHAR2(300 CHAR) DEFAULT | UD20X from source |
UD20R | VARCHAR2(10, 0 CHAR) DEFAULT | UD20R from source |
UD20F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD20F from source |
ATTR1 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR2 | VARCHAR2(300 CHAR) DEFAULT |
User defined attribute - used as needed for mapping or drill-through Note: When importing data from Financial Consolidation and Close, attribute columns ATTR2 and ATTR3 should not be used for any other dimension mappings. |
ATTR3 | VARCHAR2(300 CHAR) DEFAULT |
User defined attribute - used as needed for mapping or drill-through Note: When importing data from Financial Consolidation and Close, attribute columns ATTR2 and ATTR3 should not be used for any other dimension mappings. |
ATTR4 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR5 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR6 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR7 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR8 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR9 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR10 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR11 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR12 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR13 | VARCHAR2(300 CHAR) DEFAULT | Restricted. Used to store the "Logic Item" if a logic group is assigned to a location. |
ATTR14 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR15 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR16 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR17 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR18 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR19 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR20 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR21 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR22 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR23 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR24 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR25 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR26 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR27 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR28 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR29 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR30 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR31 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR32 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR33 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR34 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR35 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR36 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR37 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR38 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR39 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR40 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
DATA | VARCHAR2(2000 CHAR) | |
DATAX | VARCHAR2(2000 CHAR) | |
DATAR | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE | |
DATAF | NUMBER(6,0) DEFAULT 0 NOT NULL ENABLE | |
CODE_COMBINATION_ID | VARCHAR2(500 CHAR) | Used for integration with Oracle E-Business Suite. |
AMOUNT_YTD | NUMBER(29,12) | YTD Amount. Used for E-Business Suite, Peoplesoft, Fusion data sources |
AMOUNT_PTD | NUMBER(29,12) | PTD Amount. Used for E-Business Suite, Peoplesoft, Fusion data sources |
LOADID | NUMBER(15,0) | Process ID that created or updated this row. |
RULE_ID | NUMBER(15,0) | Data Rule ID used to create this row. Join to AIF_BALANCE_RULES for details. |
STAT_BALANCE_FLAG | VARCHAR2(1 CHAR) | Indicates if balance is a statistic:
|
VALID_FLAG | VARCHAR2(1 CHAR) | Indicates if row has valid mappings:
|