MOO_OPTY_ROLLUPS
The MOO_OPTY_ROLLUPS table stores Rollup Metrics data.
Details
-
Schema: FUSION
-
Object owner: MOO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOO_OPTY_ROLLUPS_PK |
OPTY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OPTY_ID | NUMBER | 18 | Yes | An identifier for the Opportunity used as a foreign key to the MOO_OPTY table. | |
| NUM_OF_CALL_MADE | NUMBER | Total number of interactions of type call where direction is outbound, made in context of opportunity. | |||
| NUM_OF_EMAIL_SENT | NUMBER | Total number of interactions of type email where direction is outbound, made in context of opportunity. | |||
| LAST_CALL_MADE | TIMESTAMP | Last interaction of type call where direction is outbound, made in context of opportunity. | |||
| LAST_EMAIL_SENT | TIMESTAMP | Last interaction of type email where direction is outbound, made in context of opportunity. | |||
| NUM_OF_TOUCHES | NUMBER | Number of interactions where direction is outbound, made in context of opportunity. | |||
| LAST_TOUCH | TIMESTAMP | Last interaction where direction is outbound, made in context of opportunity. | |||
| NUM_OF_OPEN_ACTY | NUMBER | The total number of activities that are open for opportunity: tasks which are not yet completed/cancelled, appointments in future, call reports in future. | |||
| LAST_COMPLETED_ACTIVITY | TIMESTAMP | The date of last completed activity for an opportunity. Activity includes task, appointment, and call report. | |||
| TOTAL_COMPLETED_ACTIVITIES | NUMBER | The total number of completed activities for an opportunity. | |||
| NEXT_TASK_DUE | TIMESTAMP | The date when a task is due for an opportunity. | |||
| TOTAL_QUOTES | NUMBER | The total number of quotes for an opportunity. | |||
| TOTAL_NOTES | NUMBER | The total number of public notes associated with an opportunity. | |||
| 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. | ||
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code for extensibility. | ||
| CORP_CURRENCY_CODE | VARCHAR2 | 15 | Corporate currency code for extensibility. | ||
| CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | Currency conversion rate type for extensibility. | ||
| EXTN_ATTRIBUTE_NUMBER001 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER002 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER003 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER004 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER005 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER006 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER007 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER008 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER009 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER010 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER011 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER012 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER013 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER014 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER015 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER016 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER017 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER018 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER019 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER020 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER021 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER022 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER023 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER024 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER025 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER026 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER027 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER028 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER029 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER030 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER031 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER032 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER033 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER034 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER035 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER036 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER037 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER038 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER039 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER040 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER041 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER042 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER043 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER044 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER045 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER046 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER047 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER048 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER049 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER050 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER051 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER052 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER053 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER054 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER055 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER056 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER057 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER058 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER059 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER060 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER061 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER062 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER063 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER064 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER065 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER066 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER067 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER068 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER069 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER070 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER071 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER072 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER073 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER074 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER075 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER076 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER077 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER078 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER079 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER080 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER081 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER082 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER083 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER084 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER085 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER086 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER087 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER088 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER089 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER090 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER091 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER092 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER093 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER094 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER095 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER096 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER097 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER098 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER099 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER100 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP001 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP002 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP003 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP004 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP005 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP006 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP007 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP008 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP009 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP010 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP011 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP012 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP013 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP014 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP015 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP016 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP017 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP018 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP019 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP020 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP021 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP022 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP023 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP024 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP025 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP026 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP027 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP028 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP029 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP030 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP031 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP032 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP033 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP034 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP035 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP036 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP037 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP038 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP039 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP040 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MOO_OPTY_ROLLUPS_U1 | Unique | Default | OPTY_ID |