ZCA_ROLLUPS_B
This table stores the metadata of various rollups that are defined for different source objects and their related objects.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ZCA_ROLLUPS_B_PK |
ROLLUP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ROLLUP_ID | VARCHAR2 | 64 | Yes | Unique identifier for the rollup. | |
| ROLLUP_TYPE_CODE | VARCHAR2 | 30 | Yes | Specifies the type of the rollup. Valid values are ORA_REGULAR (Regular) and ORA_AGING (Aging). | |
| SOURCE_OBJ_CODE | VARCHAR2 | 128 | Yes | Name of the source object. Foreign key to LANG_INDEPENDENT_CODE column in ZCA_OBJECTS table. | |
| SOURCE_STORAGE_OBJ_CODE | VARCHAR2 | 128 | Yes | Name of the source rollup storage object. Foreign key to LANG_INDEPENDENT_CODE column in ZCA_OBJECTS table. | |
| SOURCE_OBJ_ROLLUP_TABLE | VARCHAR2 | 30 | Yes | Name of the table where calculated rollup data of the source object is stored. | |
| SOURCE_OBJ_ATTR | VARCHAR2 | 100 | Yes | View object attribute name of the source object's rollup attribute. | |
| SOURCE_OBJ_ATTR_TYPE | VARCHAR2 | 30 | Yes | Rollup attribute type. Derived from ZCA_OBJECT_ATTRIUTES.ATTR_TYPE. Supported values are NUMBER and TIMESTAMP. | |
| SOURCE_OBJ_FILTER | VARCHAR2 | 1000 | Filter expression that would be used to filter the source object data. | ||
| RELATED_OBJ_CODE | VARCHAR2 | 128 | Name of the related object. Foreign key to LANG_INDEPENDENT_CODE column in ZCA_OBJECTS table. | ||
| RELATIONSHIP_NAME_LIC | VARCHAR2 | 100 | Name of the relationship between source and related objects. Foreign key to RELATIONSHIP_NAME_LIC column in ZCA_OBJECT_RELATIONS table. | ||
| RELATED_OBJ_ATTR | VARCHAR2 | 100 | View object attribute name of the related object's rollup attribute. | ||
| RELATED_OBJ_FILTER | VARCHAR2 | 1000 | Filter expression that would be used to filter the related object data. | ||
| FUNCTION_CODE | VARCHAR2 | 30 | Yes | Aggregation function code that is used to calculate the rollup data. Valid values include ORA_SUM (Sum), ORA_COUNT (Count), ORA_MAX (Max), and ORA_MIN (Min). | |
| REFRESH_THRESHOLD | NUMBER | 3 | The maximum number of days set as the threshold for the selection of Activity or Interactions records. | ||
| HIERARCHY_FLAG | VARCHAR2 | 1 | Yes | Specifies if the hierarchy rollup is enabled or not. | |
| HIERARCHY_ATTR | VARCHAR2 | 100 | View object attribute name of the source object's hierarchy rollup attribute. | ||
| STATUS_FLAG | VARCHAR2 | 1 | Yes | Indicates if the rollup is active or deleted. | |
| FREQUENCY | NUMBER | 2 | Indicates the frequency of the rollup data refresh. | ||
| FREQUENCY_UNIT_CODE | VARCHAR2 | 30 | Rollup data refresh frequency unit. Valid values include ORA_HOUR (Hour), ORA_DAY (Day), ORA_WEEK (Week), and ORA_MONTH (Month). | ||
| COMPILED_SOURCE_AMT_CONV | VARCHAR2 | 400 | Generated expression to convert the amount field value to corporate currency. | ||
| COMPILED_FULL_SQL | CLOB | Internal attribute to store the full refresh SQL. | |||
| COMPILED_INCREMENTAL_SQL | CLOB | Internal attribute to store the incremental refresh SQL. | |||
| COMPILED_OBJ_LIST_SQL | CLOB | Internal attribute to store the object list refresh SQL. | |||
| PUBLISHED_FLAG | VARCHAR2 | 1 | Yes | Indicates if the rollup is published or not. | |
| PUBLISHED_DATE | TIMESTAMP | Date when the rollup was published. | |||
| PUBLISHED_BY | VARCHAR2 | 64 | User Name of the user who published the rollup. | ||
| LAST_SUCCESSFUL_RUN | TIMESTAMP | Date of the last successful full or incremental run of the back-end job that calculates the rollup attribute value. | |||
| LAST_PROCESSED_DATE | TIMESTAMP | Date of the last full or incremental run of the back-end job that calculates the rollup attribute value. | |||
| LAST_PROCESSED_STATUS_CODE | VARCHAR2 | 30 | Status of the last full or incremental run of the back-end job that calculates the rollup attribute value. Valid values include ORA_SUCCESS (SUCCESS) and ORA_ERROR (Error). | ||
| ERROR_MESSAGE | VARCHAR2 | 4000 | Error message of the full or incremental run of the back-end job that calculates the rollup attribute value. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| NRT_FLAG | VARCHAR2 | 1 | Yes | Indicates if the rollup is enabled for Near Real Time Calculation. | |
| BOFO_LINKSET_REFRESH_SQL | CLOB | Internal attribute to store the back office linkset refresh SQL. | |||
| EXPLAINABILITY_METADATA | VARCHAR2 | 2000 | This column stores the rollup explainability metadata in json format. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| zca_rollup_signals | zca_rollups_b | ROLLUP_ID |
| zca_rollup_attributes | zca_rollups_b | ROLLUP_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_ROLLUPS_B_PK | Unique | Default | ROLLUP_ID, ORA_SEED_SET1 |
| ZCA_ROLLUPS_B_PK1 | Unique | Default | ROLLUP_ID, ORA_SEED_SET2 |