ZCA_ROLLUP_CALCULATION
This is a temporary dynamic table that stores the calculated rollup values for each source object record that needs to be updated to source object rollup table.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OBJECT_CODE | VARCHAR2 | 30 | Yes | Name of the source object. This is a foreign key to LANG_INDEPENDENT_CODE column in ZCA_OBJECTS table. | |
| OBJECT_PK | NUMBER | 18 | Yes | Primary key attribute value of the source object row. | |
| ROLLUP_ID | VARCHAR2 | 64 | The unique identifier for the rollup. Copied from ZCA_ROLLUPS_B table. | ||
| ROLLUP_ATTR_NUMBER001 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER002 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER003 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER004 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER005 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER006 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER007 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER008 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER009 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER010 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER011 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER012 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER013 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER014 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER015 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER016 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER017 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER018 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER019 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER020 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER021 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER022 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER023 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER024 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER025 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER026 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER027 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER028 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER029 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER030 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER031 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER032 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER033 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER034 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER035 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER036 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER037 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER038 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER039 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER040 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER041 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER042 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER043 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER044 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER045 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER046 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER047 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER048 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER049 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_NUMBER050 | NUMBER | Calculation process dynamically assigns one of these columns for each of the NUMBER type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP001 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP002 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP003 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP004 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP005 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP006 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP007 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP008 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP009 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP010 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP011 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP012 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP013 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP014 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP015 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP016 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP017 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP018 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP019 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP020 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP021 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP022 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP023 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP024 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP025 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP026 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP027 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP028 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP029 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP030 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP031 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP032 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP033 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP034 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP035 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP036 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP037 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP038 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP039 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. | |||
| ROLLUP_ATTR_TIMESTAMP040 | TIMESTAMP | Calculation process dynamically assigns one of these columns for each of the TIMESTAMP type rollups that needs to be calculated. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_ROLLUP_CALCULATION_N1 | Non Unique | Default | OBJECT_CODE, OBJECT_PK |