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. | ||
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 |