# 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, 2025, Oracle and/or its affiliates.