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    

Copyright © 2019, 2024, Oracle and/or its affiliates.