The TDATASEG table is used to store the data loaded by the user, and the transformation between the source dimension members and results of the mapping process.
Note:
When loading text, the column in TDATASEG it is loaded to is DATA, and the mapped result is loaded to DATAX.Table I-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 Oracle Hyperion Financial Data Quality Management, Enterprise Edition to EPM period mapping details. |
| DATAVIEW | VARCHAR2(8 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(10 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(10 CHAR) DEFAULT | ID for the Journal. User provided value |
| AMOUNT | NUMBER(29,12) DEFAULT 0 NOT NULL ENABLE | Amount loaded from source |
| AMOUNTX | NUMBER(29 12) DEFAULT 0 NOT NULL ENABLE | Amount after any transformation rules. This value is loaded to the target application. |
| DESC1 | VARCHAR2(240 CHAR) DEFAULT | Description can be imported from file |
| DESC2 | VARCHAR2(75 CHAR) DEFAULT | Description can be imported from file |
| ACCOUNT | VARCHAR2(75 CHAR) NOT NULL ENABLE | Account member from source |
| ACCOUNTX | VARCHAR2(4000 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(75 CHAR) DEFAULT | Entity member from source |
| ENTITYX | VARCHAR2(75 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(75 CHAR) DEFAULT | ICP from source |
| ICPX | VARCHAR2(75 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(75 CHAR) DEFAULT | UD1 from source |
| UD2 | VARCHAR2(75 CHAR) DEFAULT | UD2 from source |
| UD3 | VARCHAR2(75 CHAR) DEFAULT | UD3 from source |
| UD4 | VARCHAR2(75 CHAR) DEFAULT | UD4 from source |
| UD5 | VARCHAR2(75 CHAR) DEFAULT | UD5 from source |
| UD6 | VARCHAR2(75 CHAR) DEFAULT | UD6 from source |
| UD7 | VARCHAR2(75 CHAR) DEFAULT | UD7 from source |
| UD8 | VARCHAR2(75 CHAR) DEFAULT | UD8 from source |
| UD9 | VARCHAR2(75 CHAR) DEFAULT | UD9 from source |
| UD10 | VARCHAR2(75 CHAR) DEFAULT | UD10 from source |
| UD11 | VARCHAR2(75 CHAR) DEFAULT | UD11 from source |
| UD12 | VARCHAR2(75 CHAR) DEFAULT | UD12 from source |
| UD13 | VARCHAR2(75 CHAR) DEFAULT | UD13 from source |
| UD14 | VARCHAR2(75 CHAR) DEFAULT | UD14 from source |
| UD15 | VARCHAR2(75 CHAR) DEFAULT | UD15 from source |
| UD16 | VARCHAR2(75 CHAR) DEFAULT | UD16 from source |
| UD17 | VARCHAR2(75 CHAR) DEFAULT | UD17 from source |
| UD18 | VARCHAR2(75 CHAR) DEFAULT | UD18 from source |
| UD19 | VARCHAR2(75 CHAR) DEFAULT | UD19 from source |
| UD20 | VARCHAR2(75 CHAR) DEFAULT | UD20 from source |
| UD1X | VARCHAR2(75 CHAR) DEFAULT | UD1 after mapping rules processed. This value is exported. |
| UD1R | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE | Key to Mapping used for this dimension. Refers to DATAKEY in TDATAMAPSEG |
| UD1F | NUMBER(6,0) DEFAULT 0 NOT NULL ENABLE | Map type:
|
| 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 |
| ATTR1 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR2 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR3 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR4 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR5 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR6 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR7 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR8 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR9 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR10 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR11 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR12 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR13 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR14 | VARCHAR2(20 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| CODE_COMBINATION_ID | VARCHAR2(155 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:
|