ZPS_USERS
This table stores the Office365 Oracle Sales Integration User data. The Sync Engine will be eanbled only for the users registered in here.
Details
-
Schema: FUSION
-
Object owner: ZPS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZPS_USERS_PK |
USER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USER_ID | NUMBER | 18 | Yes | Primary key of the table | |
| APP_ID | NUMBER | 18 | Foreignkey to ZPS_APPS | ||
| OSC_PARTY_ID | NUMBER | 18 | OSC Party Id | ||
| MICROSOFT_ID | VARCHAR2 | 128 | Yes | Microsoft Id | |
| MICROSOFT_REFRESH_TOKEN | VARCHAR2 | 4000 | Yes | Microsoft OAuth Refresh Token | |
| MICROSOFT_ACCESS_TOKEN | VARCHAR2 | 4000 | Yes | Microsoft OAuth Access Token | |
| MICROSOFT_TOKEN_EXPIRY | NUMBER | 20 | Yes | Microsoft OAuth Token expiry time in ms | |
| MICROSOFT_AUTH_CODE | VARCHAR2 | 4000 | Microsoft Authentication Code | ||
| MICROSOFT_DELTA | VARCHAR2 | 4000 | Delta Urll | ||
| OSC_USERNAME | VARCHAR2 | 64 | Yes | Sales cloud usename | |
| OSC_REFRESH_TOKEN | VARCHAR2 | 4000 | Sales Cloud Refresh Token | ||
| OSC_ACCESS_TOKEN | VARCHAR2 | 4000 | Sales Cloud Access Token | ||
| OSC_TOKEN_EXPIRY | NUMBER | 20 | Sales Cloud Token Expiry in ms | ||
| OSC_AUTH_CODE | VARCHAR2 | 256 | Sales Cloud Authorization Code | ||
| SYNC_STATUS_CD | VARCHAR2 | 32 | Last Sync Staus Code | ||
| HAS_CONFLICTS | VARCHAR2 | 1 | Conflict flag | ||
| LAST_SYNC_TIME | TIMESTAMP | Last sync time | |||
| LAST_SYNC_STATUS | VARCHAR2 | 10 | Last sync status | ||
| LAST_SYNC_MSG | CLOB | Holds the status of the last Sync | |||
| LAST_SYNC_MESSASGE | VARCHAR2 | 4000 | Last Sync details | ||
| CONTACT_SAVED_SEARCH | VARCHAR2 | 256 | Contact Saved search. | ||
| ACTIVITY_SAVED_SEARCH | VARCHAR2 | 256 | Activity Saved search. | ||
| EMAIL_SAVED_SEARCH | VARCHAR2 | 256 | Saved search for email | ||
| TASK_SAVED_SEARCH | VARCHAR2 | 256 | Saved Search for task object. | ||
| ACTIVITY_DELTA | VARCHAR2 | 4000 | Activity Delta Url | ||
| CONTACT_CONFLICT_RESOLUTION | VARCHAR2 | 20 | Contact Conflict Resolution | ||
| ACTIVITY_CONFLICT_RESOLUTION | VARCHAR2 | 20 | Activity Conflict Resolution | ||
| TASK_CONFLICT_RESOLUTION | VARCHAR2 | 20 | Task Conflict Resolution. | ||
| DO_SYNC | VARCHAR2 | 1 | Yes | When this flag is enabled, the synchronization will be triggered. | |
| CONTACT_SS_CLEAR | VARCHAR2 | 1 | Flag to clear the MS contact records. | ||
| ACTIVITY_SS_CLEAR | VARCHAR2 | 1 | Flag to clear the MS activity records. | ||
| IS_AUTHORIZED | VARCHAR2 | 1 | Yes | Flag to determine whether the user is authorized. | |
| IS_ACTIVE | VARCHAR2 | 1 | Yes | Determines whether the row is active. | |
| SUSPEND_SYNC | VARCHAR2 | 1 | Suspends the Sync for the user. | ||
| TURN_OFF_SYNC | VARCHAR2 | 1 | Turns synchronization off for the user. | ||
| EMAIL_SYNC_ENABLED | VARCHAR2 | 1 | EMAIL_SYNC_ENABLED | ||
| DEBUG | VARCHAR2 | 4000 | Debug Flag | ||
| CONFIG | CLOB | Additional Configuration | |||
| CCR_PAYLOAD | CLOB | CCR_PAYLOAD | |||
| CONFLICT_PAYLOAD | CLOB | Conflict Payload | |||
| ACR_PAYLOAD | CLOB | ACR_PAYLOAD | |||
| TCR_PAYLOAD | CLOB | TCR_PAYLOAD | |||
| EMAIL_SYNC_DETAIL | CLOB | Email Sync Detail | |||
| TASK_SUBSCRIPTION_ID | VARCHAR2 | 4000 | The subscription Id of the Microsoft task. | ||
| EVENT_SUBSCRIPTION_ID | VARCHAR2 | 4000 | The subscription Id of the Microsoft event. | ||
| CONTACT_SUBSCRIPTION_ID | VARCHAR2 | 4000 | The subscription Id of the Microsoft contact. | ||
| EMAIL_SUBSCRIPTION_ID | VARCHAR2 | 4000 | The subscription Id of the Microsoft email. | ||
| EMAIL_SUB_EXPR_TIME | TIMESTAMP | The date and time at which the subscription of Microsoft email ends. | |||
| EVENT_SUB_EXPR_TIME | TIMESTAMP | The date and time at which the subscription of Microsoft event ends. | |||
| TASK_SUB_EXPR_TIME | TIMESTAMP | The date and time at which the subscription of Microsoft task ends. | |||
| CONTACT_SUB_EXPR_TIME | TIMESTAMP | The date and time at which the subscription of Microsoft contact ends. | |||
| EMPTY_APPT_SYNC_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if an empty invitee appointment should be synced. The flag is at an User level. | ||
| RUN_FULL_SYNC_FLAG | VARCHAR2 | 1 | Indicates if the initial sync should be run for a user. | ||
| WORKSPACE_SS_UUID_CONTACT | VARCHAR2 | 256 | Workspace saved search Id for contacts. | ||
| WORKSPACE_SS_UUID_APPT | VARCHAR2 | 256 | Workspace saved search Id for appointments. | ||
| WORKSPACE_SS_UUID_TASK | VARCHAR2 | 256 | Workspace saved search Id for tasks. | ||
| APPLICATION_SWITCHED_FLAG | VARCHAR2 | 1 | Indicates if the user has already switched to next generation side panel. | ||
| SIDEPANEL_DEMO_VIEWED_FLAG | VARCHAR2 | 1 | Indicates if the user has viewed the next generation side panel welcome screen. | ||
| CONTACT_SS_UPDATED_FLAG | VARCHAR2 | 1 | Indicates if the user has updated the saved search for contacts. | ||
| TASK_SS_UPDATED_FLAG | VARCHAR2 | 1 | Indicates if the user has updated the saved search for tasks. | ||
| LAST_SYNC_START_TS | TIMESTAMP | Starting time of the last sync. | |||
| MS_TENANT_ID | VARCHAR2 | 256 | The unique identifier of the Microsoft tenant for the user, it is required to sync using Microsoft Graph API. | ||
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZPS_USERS_N1 | Non Unique | Default | TASK_SUBSCRIPTION_ID |
| ZPS_USERS_N2 | Non Unique | Default | EVENT_SUBSCRIPTION_ID |
| ZPS_USERS_N3 | Non Unique | Default | CONTACT_SUBSCRIPTION_ID |
| ZPS_USERS_N4 | Non Unique | Default | EMAIL_SUBSCRIPTION_ID |
| ZPS_USERS_U1 | Unique | Default | USER_ID |
| ZPS_USERS_U2 | Unique | Default | OSC_USERNAME |
| ZPS_USERS_U3 | Unique | Default | MICROSOFT_ID |