TDATASEG Table Reference
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 G-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(80 CHAR) DEFAULT | Entity member from source |
| ENTITYX | VARCHAR2(80 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(80 CHAR) DEFAULT | ICP from source |
| ICPX | VARCHAR2(80 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(80 CHAR) DEFAULT | UD1 from source |
| UD2 | VARCHAR2(80 CHAR) DEFAULT | UD2 from source |
| UD3 | VARCHAR2(80 CHAR) DEFAULT | UD3 from source |
| UD4 | VARCHAR2(80 CHAR) DEFAULT | UD4 from source |
| UD5 | VARCHAR2(80 CHAR) DEFAULT | UD5 from source |
| UD6 | VARCHAR2(80 CHAR) DEFAULT | UD6 from source |
| UD7 | VARCHAR2(80 CHAR) DEFAULT | UD7 from source |
| UD8 | VARCHAR2(80 CHAR) DEFAULT | UD8 from source |
| UD9 | VARCHAR2(80 CHAR) DEFAULT | UD9 from source |
| UD10 | VARCHAR2(80 CHAR) DEFAULT | UD10 from source |
| UD11 | VARCHAR2(80 CHAR) DEFAULT | UD11 from source |
| UD12 | VARCHAR2(80 CHAR) DEFAULT | UD12 from source |
| UD13 | VARCHAR2(80 CHAR) DEFAULT | UD13 from source |
| UD14 | VARCHAR2(80 CHAR) DEFAULT | UD14 from source |
| UD15 | VARCHAR2(80 CHAR) DEFAULT | UD15 from source |
| UD16 | VARCHAR2(80 CHAR) DEFAULT | UD16 from source |
| UD17 | VARCHAR2(80 CHAR) DEFAULT | UD17 from source |
| UD18 | VARCHAR2(80 CHAR) DEFAULT | UD18 from source |
| UD19 | VARCHAR2(80 CHAR) DEFAULT | UD19 from source |
| UD20 | VARCHAR2(80 CHAR) DEFAULT | UD20 from source |
| UD1X | VARCHAR2(80 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(80 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR2 | VARCHAR2(80 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR3 | VARCHAR2(80 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR4 | VARCHAR2(80 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR5 | VARCHAR2(80 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR6 | VARCHAR2(80 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
| ATTR7 | VARCHAR2(80 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 |
| ATTR15-ATTR40 | New Columns | 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 data sources |
| AMOUNT_PTD | NUMBER(29,12) | PTD Amount. Used for E-Business Suite, Peoplesoft 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:
|