DW_HRSR_QUEUE_D (Preview)

This table requires activation of HR Help Desk functional area. This table is used to store the queues that requests get assigned to based on routing algorithm.

Details

Module:

Key Columns

QUEUE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
QUEUE_ID NUMBER 38 0 True Queue ID    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. System Generated Unique Identifier    
QUEUE_NUMBER VARCHAR2 32     Public Unique Identifier for Queues.    
CREATION_DATE TIMESTAMP       Indicates the date and time of the creation of the row.    
QUEUE_NAME VARCHAR2 512     This column stores the name of the queue.    
QUEUE_DESCRIPTION VARCHAR2 999     Description of the queue, SLA, etc.    
STRIPE_CODE VARCHAR2 32     Lookup code that indicates the stripe code, such as CRM or HCM. DW_HRSR_STRIPE_CODE_D_TL CODE
AUTO_ROUTING_FLAG VARCHAR2 16     Indicates whether this queue supports advanced automated routing (Y) or is manual (N).    
ENABLED_FLAG VARCHAR2 16     Indicates whether the queue is enabled (Y or N) for assignment.    
SKILL_ROUTING_ENABLED_FLAG VARCHAR2 16     Skill-Based Assignment Enabled    
DELETED_FLAG VARCHAR2 16     Indicates whether the queue is logically deleted (Y or N).    
EXTERNAL_FLAG VARCHAR2 16     Indicates whether this queue supports external routing (Y) or only internal routing (N).    
VIRTUAL_ASSISTANT_ENABLED_FLAG VARCHAR2 16     Indicates whether the queue is VA enabled (Y or N)    
VIRTUAL_ASSISTANT_THRESHOLD NUMBER 38 0   If the estimated wait time for a request exceeds this number of seconds, route the requests to the virtual agent.    
VIRTUAL_ASSISTANT_PERCENTAGE NUMBER 38 0   This number represents the percentage of requests that have to be routed to the virtual agent, in case the VA policy code is "VA_PERCENTAGE".    
OVERFLOW_ENABLED_FLAG VARCHAR2 16     Indicates whether the Overflow feature is enabled on this queue (Y or N)    
OVERFLOW_CONDITION_REAL_TM_Q_LENGTH NUMBER 38 0   The overflow condition is: if there are more than this number of real-time items waiting in the queue. Applicable if the Overflow policy code is ORA_SVC_OVERFLOW_QUEUE_LENGTH.    
OVERFLOW_CONDITION_NON_REAL_TM_Q_LENGTH NUMBER 38 0   The overflow condition is: if there are more than this number of non-real-time items waiting in the queue. Applicable if the Overflow policy code is ORA_SVC_OVERFLOW_QUEUE_LENGTH.    
OVERFLOW_COND_REAL_TIME_IN_Q NUMBER       The overflow condition is: if any real-time item was waiting in the queue for more than this number of hours. Applicable if the Overflow policy code is ORA_SVC_OVERFLOW_TIME_PERIOD    
OVERFLOW_COND_NON_REAL_TIME_IN_Q NUMBER       The overflow condition is: if any non-real-time item was waiting in the queue for more than this number of hours. Applicable if the Overflow policy code is ORA_SVC_OVERFLOW_TIME_PERIOD    

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