1. Tables and Views for Sales and Fusion Service
  2. SVC_MILESTONE_CONFIGS

SVC_MILESTONE_CONFIGS

This table will be used to store milestone configuration details along with start, stop and pause conditions. These conditions will be used to derive the SLA values for the service request.

Details

  • Schema: FUSION

  • Object owner: SVC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

SVC_MILESTONE_CONFIGS_PK

MILESTONE_CONFIG_ID

Columns

Name Datatype Length Precision Not-null Comments Status
MILESTONE_CONFIG_ID NUMBER 18 Yes Auto-generated number and primary key for this table.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. Obsolete
BU_ORG_ID NUMBER 18 Stores the Business Unit Org Id of the Milestone Configuration.
DELETED_FLAG VARCHAR2 1 Yes Indicates whether the milestone configurations are logically deleted or not.(Y or N)
DISABLED_FLAG VARCHAR2 1 Yes Indicates if the milestone configuration is disabled or not
MILESTONE_CODE VARCHAR2 255 Yes The code defined in contracts object for each milestone.
MILESTONE_LABEL VARCHAR2 255 User defined display label for each milestone.
MILESTONE_TYPE VARCHAR2 255 Yes Milestone type indicates whether the milestone can have multiple instances, reopenable etc.
THRESHOLD_CODE VARCHAR2 255 The code defined in contracts object for each threshold.
START_CONDITION VARCHAR2 1000 This column will store the exact SQL expression for the start condition
START_CONDITION_LABEL VARCHAR2 1000 Stores description for the rule expression which defines the Start Status
PAUSE_CONDITION VARCHAR2 1000 This column will store the exact SQL expression for the pause condition
PAUSE_CONDITION_LABEL VARCHAR2 1000 Stores description for the rule expression which defines the pause Status
STOP_CONDITION VARCHAR2 1000 This column will store the exact SQL expression for the stop condition
STOP_CONDITION_LABEL VARCHAR2 1000 Stores description for the rule expression which defines the stop Status
ALLOW_DUE_DATE_OVERRIDE_FLAG VARCHAR2 1 Yes Indicates whether an agent can override milestone due date or not.
ALLOW_AGENT_COMPLETION_FLAG VARCHAR2 1 Yes Indicates whether an agent can mark milestone as complete or not.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update 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.
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.
OBJECT_NAME VARCHAR2 255 Yes Indicates the object to which this milestone is associated.
TZ_PREFERENCE_CD VARCHAR2 30 Indicates the object name from which time zone has to be picked.

Foreign Keys

Table Foreign Table Foreign Key Column
svc_milestone_conditions svc_milestone_configs MILESTONE_CONFIG_ID
svc_sr_milestones svc_milestone_configs MILESTONE_CONFIG_ID

Indexes

Index Uniqueness Tablespace Columns
SVC_MILESTONE_CONFIGS_PK Unique Default MILESTONE_CONFIG_ID
SVC_MILESTONE_CONFIGS_U1 Unique Default MILESTONE_CODE, BU_ORG_ID, OBJECT_NAME