ZPS_APP_SETTINGS
This table stores the Microsoft Oracle Sales Application data.
Details
-
Schema: FUSION
-
Object owner: ZPS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZPS_APP_SETTINGS_PK |
APPLICATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| APPLICATION_ID | NUMBER | 18 | Yes | Primary key of the table | |
| OSC_SERVER_ADDRESS | VARCHAR2 | 128 | Yes | OSC server address. | |
| CLIENT_ID | VARCHAR2 | 256 | Yes | Microsoft Client ID | |
| CLIENT_SECRET | VARCHAR2 | 256 | Yes | Microsoft Client Secret code | |
| CLIENT_SECRET_EXPIRY_DATE | TIMESTAMP | Microsoft Client Secret expiry date. | |||
| IS_ACTIVE | VARCHAR2 | 1 | Yes | Determines whether the row is active. | |
| PROXY_SERVER | VARCHAR2 | 64 | Proxy Server | ||
| PROXY_PORT | NUMBER | 6 | Proxy port | ||
| VERSION | VARCHAR2 | 20 | Yes | Application Version | |
| RECENT_REC_RANGE_SIZE | NUMBER | 4 | Range size for recent records | ||
| RECENT_PERIOD_IN_DAYS | NUMBER | 4 | Period in days for recent records | ||
| SYNC_RECORD_LIMIT | NUMBER | 10 | Limit for total records to sync | ||
| CONTACT_SYNC_LIMIT | NUMBER | 10 | Limit for total contacts to sync | ||
| APPOINMENT_SYNC_LIMIT | NUMBER | 10 | Limit for total appointments to sync | ||
| TASK_SYNC_LIMIT | NUMBER | 10 | Limit for total tasks to sync | ||
| INC_SYNC_BATCH_SIZE | NUMBER | 4 | Batch size for incremental sync | ||
| INITIAL_SYNC_BATCH_SIZE | NUMBER | 4 | Batch size for initial sync | ||
| SYNC_PRIVATE_EVENTS | VARCHAR2 | 1 | Sync private appointments | ||
| SYNC_PRIVATE_TASKS | VARCHAR2 | 1 | Sync private tasks | ||
| USE_ALT_HOST_DETAILS | VARCHAR2 | 1 | Flag to use alternate host details | ||
| SUSPND_POLL_INTERVAL | NUMBER | 5 | Sync job needs to keep checking if a cancel request is queued. This column would store the processed record count after which sync engine requires to repoll for cancel or suspend request. | ||
| RUNNG_STATUS_CHK_INTERVAL | NUMBER | 5 | Time interval the sync job needs to poll for the sync running status, this is to find out if a sync job is really running or not. | ||
| MS_REST_VERSION | VARCHAR2 | 64 | Microsoft rest version | ||
| DATA_CHANNEL | VARCHAR2 | 64 | Data channel | ||
| USE_BASIC_AUTH | VARCHAR2 | 1 | Flag to use basic authentication | ||
| IS_MIGRATING | VARCHAR2 | 1 | Flag to indicate migrating status | ||
| ALLOW_CONFLICT_RES_OVERRIDE | VARCHAR2 | 1 | Flag to allow override of conflict resolution | ||
| DEFAULT_CONFLICT_RES_OPTION | VARCHAR2 | 64 | Default conflict resolution | ||
| ENABLE_DEV_EXT | VARCHAR2 | 1 | Enable extensibility | ||
| EULA_ACCEPTED_STATUS | VARCHAR2 | 1 | End user license accepted status | ||
| EULA_ACCEPTED_BY | VARCHAR2 | 64 | End user license accepted by user | ||
| EULA_ACCEPTED_TIMESTAMP | TIMESTAMP | End user license accepted timestamp | |||
| APP_DISPLAY_NAME | VARCHAR2 | 256 | Application Display Name | ||
| 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. | |
| CONFIG | CLOB | Additional Configuration | |||
| CAPTURE_SYNC_USAGES | VARCHAR2 | 1 | Flag to enable capturing of Sync usages. | ||
| SYNC_USAGES_PER_USR_LIMIT | NUMBER | 5 | Sync Usage limit | ||
| CAPTURE_CLIENT_USAGE | VARCHAR2 | 1 | Flag to enable capturing of Client usages. | ||
| CLIENT_USAGE_LIMIT | NUMBER | 5 | Number of days the Client Usage data to be kept in system, data older than this limit would be purged. | ||
| ENABLE_APPT_INVITEE_SHARE | VARCHAR2 | 1 | Flag to enable invitee share feature for Appointments | ||
| CONT_UPSYNC_CREATE_ENBLD_FLAG | VARCHAR2 | 1 | Indicates whether creation of contacts in Oracle Engagement Cloud is enabled during sync. | ||
| CONT_UPSYNC_DELETE_ENBLD_FLAG | VARCHAR2 | 1 | Indicates whether deletion of contacts in Oracle Engagement Cloud is enabled during sync. | ||
| APPT_UPSYNC_CREATE_ENBLD_FLAG | VARCHAR2 | 1 | Indicates whether creation of appointments in Oracle Engagement Cloud is enabled during sync. | ||
| APPT_UPSYNC_DELETE_ENBLD_FLAG | VARCHAR2 | 1 | Indicates whether deletion of appointments in Oracle Engagement Cloud is enabled during sync. | ||
| TASK_UPSYNC_CREATE_ENBLD_FLAG | VARCHAR2 | 1 | Indicates whether creation of tasks in Oracle Engagement Cloud is enabled during sync. | ||
| TASK_UPSYNC_DELETE_ENBLD_FLAG | VARCHAR2 | 1 | Indicates whether deletion of tasks in Oracle Engagement Cloud is enabled during sync. | ||
| EMAIL_INTEGRATION_ACTIVE_FLAG | VARCHAR2 | 1 | Indicates if email tracking is active. | ||
| EMAIL_INTEGRATION_KEYWORD | VARCHAR2 | 2000 | Keyword used for mail rule. | ||
| EMAIL_INTEGRATION_ADDRESS | VARCHAR2 | 320 | The email address used to track email integration with Microsoft Exchange and other third party email services. | ||
| EMAIL_INTEGRATION_SUB_ID | VARCHAR2 | 2000 | The Microsoft subscription ID for tracking email. | ||
| EMAIL_INTEGRATION_EXPR_TIME | TIMESTAMP | The Microsoft email tracking subscription expiration time. | |||
| EMAIL_INTEGRATION_SYNC_DATE | TIMESTAMP | The Microsoft email integration sync time. | |||
| MS_API_HOST_NAME | VARCHAR2 | 256 | Microsoft server address for integration. | ||
| MS_TOKEN_HOST_NAME | VARCHAR2 | 256 | Microsoft token server address for integration. | ||
| MS_AUTH_HOST_NAME | VARCHAR2 | 256 | Microsoft authentication server address for integration. | ||
| ALL_USER_INSTANT_SYNC_DATE | TIMESTAMP | The latest Microsoft 365 instant sync time for users. | |||
| CACHED_SS_LIST | CLOB | Saved search list cached for sync. | |||
| USE_DEFAULT_SAVEDSEARCH | VARCHAR2 | 1 | Flag to indicate that the default saved search is used for sync. | ||
| EMPTY_APPT_SYNC_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if an empty invitee appointment should be synced. The flag is at an Admin level. | ||
| MS_TENANT_ID | VARCHAR2 | 256 | The unique identifier of the Microsoft tenant that is required to sync using Microsoft Graph API. | ||
| RUN_ALL_USER_FULL_SYNC_FLAG | VARCHAR2 | 1 | Indicates if the initial sync should be run for all users. | ||
| APP_PERMISSION_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if Microsoft Application Permission is enabled for sync. | ||
| APP_PERMISSION_DETAILS | CLOB | A CLOB column that stores details of the Application Permission token such as token generation status and errors. | |||
| APPLICATION_TYPE | VARCHAR2 | 64 | Type of the application registered. | ||
| MS_DOMAIN_NAME | VARCHAR2 | 256 | Name of the Microsoft domain. | ||
| DEFAULT_APPLICATION_FLAG | VARCHAR2 | 1 | Indicates if it is the default application settings. | ||
| DYNAMIC_BATCHING_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if dynamic batching feature is enabled. | ||
| EMAIL_AUTO_SYNC_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if automatic sync of emails is enabled. | ||
| EMAIL_SYNC_FREQUENCY | NUMBER | 5 | Frequency of email sync in minutes. | ||
| ATTACHMENT_SYNC_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if attachments should be included in sync. | ||
| ATTACHMENT_SYNC_SIZE_LIMIT | NUMBER | 9 | Size limit in bytes for attachments in sync. | ||
| APPT_ONE_WAY_SYNC_ALERT_FLAG | VARCHAR2 | 1 | Indicates if the alert for appointment one way sync is enabled. | ||
| GOVT_TENANT_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if the Microsoft tenant is a goverment domain. | ||
| 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. | ||
| WORKSPACE_SS_NAME_CONTACT | VARCHAR2 | 256 | Workspace saved search name for contacts. | ||
| WORKSPACE_SS_NAME_APPT | VARCHAR2 | 256 | Workspace saved search name for appointments. | ||
| WORKSPACE_SS_NAME_TASK | VARCHAR2 | 256 | Workspace saved search Id for tasks. | ||
| ALLOW_USERS_OVERRIDE_SS | VARCHAR2 | 1 | Indicates if users are allowed to override the saved search. | ||
| SYNC_ERROR_NOTIFY_FREQUENCY | VARCHAR2 | 64 | Email notification frequency of synchronization errors. | ||
| SYNC_ERROR_SENDER_EMAIL | VARCHAR2 | 256 | Email address of sender for the sync error Email notification. | ||
| REGULAR_SYNC_JOB_START_TS | TIMESTAMP | Starting time of the regular sync job. | |||
| LOGIN_HOST_NAME_CX | VARCHAR2 | 256 | Login host name of the CX Application. | ||
| MICROSOFT_SUB_DOMAINS | VARCHAR2 | 4000 | Subdomain names of the Microsoft tenant. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZPS_APP_SETTINGS_U1 | Unique | Default | APPLICATION_ID |