1. Tables and Views for Sales, Fusion Service, and Field Service
  2. CN_TP_ROLLUP_LOG_DETAILS_ALL

CN_TP_ROLLUP_LOG_DETAILS_ALL

This table stores rollup log details information

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CN_TP_ROLLUP_LOG_DETAILS_PK

ROLLUP_LOG_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ROLLUP_LOG_DETAIL_ID NUMBER Yes Unique Identifier
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
ROLLUP_LOG_ID NUMBER Yes FK to cn_tp_rollup_logs_all Active
PARTICIPANT_ID NUMBER FK to cn_participants Active
RULE_ID NUMBER FK to cn_rs_rules_all Active
PARENT_RULE_ID NUMBER Parent Rule Active
PERIOD_ID NUMBER Period where the event is logged Active
START_DATE DATE Start date Active
END_DATE DATE End date Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
ACTION VARCHAR2 60 Action that need to be taken because of the change Active
LOG_DETAIL_STATUS VARCHAR2 30 Status of the notify log Active
LOG_DETAIL_DATE DATE Notify log date Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Foreign Keys

Table Foreign Table Foreign Key Column
CN_TP_ROLLUP_LOG_DETAILS_ALL cn_tp_rollup_logs_all ROLLUP_LOG_ID

Indexes

Index Uniqueness Tablespace Columns
CN_TP_ROLLUP_LOG_DETAILS_N1 Non Unique Default PARTICIPANT_ID, RULE_ID, PERIOD_ID, ACTION
CN_TP_ROLLUP_LOG_DETAILS_N2 Non Unique Default START_DATE, END_DATE, PERIOD_ID
CN_TP_ROLLUP_LOG_DETAILS_N3 Non Unique Default ORG_ID, PERIOD_ID
CN_TP_ROLLUP_LOG_DETAILS_N4 Non Unique Default REQUEST_ID, LOG_DETAIL_STATUS, PERIOD_ID, START_DATE, END_DATE
CN_TP_ROLLUP_LOG_DETAILS_U1 Unique Default ROLLUP_LOG_DETAIL_ID