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.

Table 73. TDATASEG Table Reference

Column NameDefinitionDescription
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 FDMEE 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:

  • 9=Imported

  • 5=Calculated and Exported

  • 1=Calculated, and Not Exported

CHANGESIGN NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Indicates that the sign of the imported amount should be reversed:

  • 0=No Change

  • 1=Reverse Sign

JOURNALID VARCHAR2(10 CHAR) DEFAULT ID for the Journal. User provided value
AMOUNT NUMBER(29,12) DEFAULT 0 NOT NULL ENABLEAmount 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(75 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:

  • 1=Exception

  • 3=Between

  • 4=Range

ENTITY VARCHAR2(75 CHAR) DEFAULT Entity member from source
ENTITYX VARCHAR2(75 CHAR) DEFAULT Entity member after mapping rules processed. This is value that will be 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:

  • 1=Exception

  • 3=Between

  • 4=Range

ICPVARCHAR2(75 CHAR) DEFAULT ICP from source
ICPXVARCHAR2(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:

  • 1=Exception

  • 3=Between

  • 4=Range

UD1 VARCHAR2(75 CHAR) DEFAULT UD1 from source
UD2VARCHAR2(75 CHAR) DEFAULT UD2 from source
UD3VARCHAR2(75 CHAR) DEFAULT UD3 from source
UD4VARCHAR2(75 CHAR) DEFAULT UD4 from source
UD5VARCHAR2(75 CHAR) DEFAULT UD5 from source
UD6VARCHAR2(75 CHAR) DEFAULT UD6 from source
UD7VARCHAR2(75 CHAR) DEFAULT UD7 from source
UD8VARCHAR2(75 CHAR) DEFAULT UD8 from source
UD9VARCHAR2(75 CHAR) DEFAULT UD9 from source
UD10VARCHAR2(75 CHAR) DEFAULT UD10 from source
UD11VARCHAR2(75 CHAR) DEFAULT UD11 from source
UD12VARCHAR2(75 CHAR) DEFAULT UD12 from source
UD13VARCHAR2(75 CHAR) DEFAULT UD13 from source
UD14VARCHAR2(75 CHAR) DEFAULT UD14 from source
UD15VARCHAR2(75 CHAR) DEFAULT UD15 from source
UD16VARCHAR2(75 CHAR) DEFAULT UD16 from source
UD17VARCHAR2(75 CHAR) DEFAULT UD17 from source
UD18VARCHAR2(75 CHAR) DEFAULT UD18 from source
UD19VARCHAR2(75 CHAR) DEFAULT UD19 from source
UD20VARCHAR2(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:

  • 1=Exception

  • 3=Between

  • 4=Range

ARCHIVEIDNUMBER(31,0) DEFAULT 0 NOT NULL ENABLE Future use
HASMEMOITEM NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Future use
STATICDATAKEYNUMBER(31,0) DEFAULT 0 NOT NULL ENABLE Future use
ATTR1VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR2VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR3VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR4VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR5VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR6VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR7VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR8VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR9VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR10VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR11VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR12VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR13VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
ATTR14VARCHAR2(20 CHAR) DEFAULT User defined attribute - used as needed for mapping or drill-through
CODE_COMBINATION_IDVARCHAR2(155 CHAR) Used for integration with E-Business Suite.
AMOUNT_YTDNUMBER(29,12) YTD Amount. Used for E-Business Suite, Peoplesoft, Fusion data sources
AMOUNT_PTDNUMBER(29,12) PTD Amount. Used for Oracle E-Business Suite, Peoplesoft, Fusion data sources
LOADIDNUMBER(15,0) Process ID that created or updated this row.
RULE_IDNUMBER(15,0) Data Rule ID used to create this row. Join to AIF_BALANCE_RULES for details.
STAT_BALANCE_FLAGVARCHAR2(1 CHAR) Indicates if balance is a statistic:

  • Y=Stat

  • N=Balance

VALID_FLAGVARCHAR2(1 CHAR)Indicates if row has valid mappings:

  • Y=Valid

  • N=Not Valid

  • I=Ignore