DW_HRSR_MILESTONE_CONFIGURATION_D (Preview)

This table requires activation of HR Help Desk functional area. Dimension table for milestone configurtion Queues

Details

Module:

Key Columns

MILESTONE_CONFIGURATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
MILESTONE_CONFIGURATION_ID NUMBER 38 0 True MilestoneConfigId
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System Generated Unique Identifier
DELETED_FLAG VARCHAR2 16 Indicates whether the milestone configurations are logically deleted or not.(Y or N)
DISABLED_FLAG VARCHAR2 16 Indicates if the milestone configuration is disabled or not
MILESTONE_CODE VARCHAR2 256 The code defined in contracts object for each milestone
MILESTONE_LABEL VARCHAR2 256 User defined display label for each milestone
MILESTONE_TYPE VARCHAR2 256 Milestone type indicates whether the milestone can have multiple instances, reopenable et
THRESHOLD_CODE VARCHAR2 256 The code defined in contracts object for each threshold
START_CONDITION VARCHAR2 999 This column will store the exact SQL expression for the start condition
START_CONDITION_LABEL VARCHAR2 999 Stores description for the rule expression which defines the Start Status
PAUSE_CONDITION VARCHAR2 999 This column will store the exact SQL expression for the pause condition
PAUSE_CONDITION_LABEL VARCHAR2 999 Stores description for the rule expression which defines the pause Status
STOP_CONDITION VARCHAR2 999 This column will store the exact SQL expression for the stop condition
STOP_CONDITION_LABEL VARCHAR2 999 Stores description for the rule expression which defines the stop Status
ALLOW_DUE_DATE_OVERRIDE_FLAG VARCHAR2 16 Indicates whether an agent can override milestone due date or not.
ALLOW_AGENT_COMPLETION_FLAG VARCHAR2 16 Indicates whether an agent can mark milestone as complete or not
OBJECT_NAME VARCHAR2 256 Indicates the object to which this milestone is associated
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row