Schema Info

Schema Name: sfdl_stage_manual.genesys_queues

created: 2023-03-08 01:03:26
disabled: False
format: raw
id: 1789
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_stage_manual",
    "table": "genesys_queues"
}

type: manual

Schema Versions: 15

Version 906593

created: 2026-04-17 00:58:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-17/1776405483'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-17/1776405483
id: 906593
processed: 1

raw_data:

{
    "_origin": "2026-04-17T00:58:03Z|raw/queues/2026-04-16/1776405483/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6415161
updated: 2026-04-17 00:58:42

Version 906377

created: 2026-04-16 00:57:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-16/1776319041'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-16/1776319041
id: 906377
processed: 1

raw_data:

{
    "_origin": "2026-04-16T00:57:21Z|raw/queues/2026-04-15/1776319041/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6414616
updated: 2026-04-16 00:57:45

Version 906164

created: 2026-04-15 01:00:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-15/1776232819'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-15/1776232819
id: 906164
processed: 1

raw_data:

{
    "_origin": "2026-04-15T01:00:19Z|raw/queues/2026-04-14/1776232819/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6414128
updated: 2026-04-15 01:00:46

Version 905952

created: 2026-04-14 01:01:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-14/1776146458'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-14/1776146458
id: 905952
processed: 1

raw_data:

{
    "_origin": "2026-04-14T01:00:58Z|raw/queues/2026-04-13/1776146458/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6413621
updated: 2026-04-14 01:01:43

Version 905735

created: 2026-04-13 01:06:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-13/1776060331'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-13/1776060331
id: 905735
processed: 1

raw_data:

{
    "_origin": "2026-04-13T01:05:32Z|raw/queues/2026-04-12/1776060332/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6413081
updated: 2026-04-13 01:06:23

Version 905533

created: 2026-04-12 00:58:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-12/1775973487'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-12/1775973487
id: 905533
processed: 1

raw_data:

{
    "_origin": "2026-04-12T00:58:07Z|raw/queues/2026-04-11/1775973487/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6412687
updated: 2026-04-12 00:58:43

Version 905330

created: 2026-04-11 00:56:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-11/1775886967'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-11/1775886967
id: 905330
processed: 1

raw_data:

{
    "_origin": "2026-04-11T00:56:07Z|raw/queues/2026-04-10/1775886967/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6412303
updated: 2026-04-11 00:56:38

Version 905118

created: 2026-04-10 00:57:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-10/1775800640'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-10/1775800640
id: 905118
processed: 1

raw_data:

{
    "_origin": "2026-04-10T00:57:21Z|raw/queues/2026-04-09/1775800641/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6411806
updated: 2026-04-10 00:57:56

Version 904904

created: 2026-04-09 00:59:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-09/1775714338'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-09/1775714338
id: 904904
processed: 1

raw_data:

{
    "_origin": "2026-04-09T00:58:59Z|raw/queues/2026-04-08/1775714339/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6411291
updated: 2026-04-09 00:59:48

Version 904690

created: 2026-04-08 00:58:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-08/1775627900'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-08/1775627900
id: 904690
processed: 1

raw_data:

{
    "_origin": "2026-04-08T00:58:20Z|raw/queues/2026-04-07/1775627900/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6410793
updated: 2026-04-08 00:58:58

Version 904476

created: 2026-04-07 00:58:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-07/1775541458'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-07/1775541458
id: 904476
processed: 1

raw_data:

{
    "_origin": "2026-04-07T00:57:39Z|raw/queues/2026-04-06/1775541459/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6410280
updated: 2026-04-07 00:58:15

Version 904260

created: 2026-04-06 00:58:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-06/1775455100'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-06/1775455100
id: 904260
processed: 1

raw_data:

{
    "_origin": "2026-04-06T00:58:21Z|raw/queues/2026-04-05/1775455101/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6409738
updated: 2026-04-06 00:58:52

Version 904060

created: 2026-04-05 00:58:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-05/1775368677'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-05/1775368677
id: 904060
processed: 1

raw_data:

{
    "_origin": "2026-04-05T00:57:58Z|raw/queues/2026-04-04/1775368678/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6409356
updated: 2026-04-05 00:58:44

Version 903856

created: 2026-04-04 00:57:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-04/1775282225'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-04/1775282225
id: 903856
processed: 1

raw_data:

{
    "_origin": "2026-04-04T00:57:05Z|raw/queues/2026-04-03/1775282225/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6408973
updated: 2026-04-04 00:57:24

Version 903643

created: 2026-04-03 00:57:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-03/1775195865'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/queues/2026-04-03/1775195865
id: 903643
processed: 1

raw_data:

{
    "_origin": "2026-04-03T00:57:46Z|raw/queues/2026-04-02/1775195866/data.json.gz|airflow_genesys_stage",
    "acwSettings": {
        "timeoutMs": 60000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": true,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2,
        "removeOwnershipOnExpiry": true
    },
    "autoAnswerOnly": false,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "cba6fc2a-d529-496f-9922-00133e3c0086",
                            "name": "Tier 1 Primary",
                            "selfUri": "/api/v2/routing/skills/cba6fc2a-d529-496f-9922-00133e3c0086"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyName": "Storable Support",
    "callingPartyNumber": "+1 ",
    "cannedResponseLibraries": {
        "mode": "All"
    },
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-10-10T20:26:21.204Z",
    "dateModified": "2025-08-18T15:33:35.703Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "directRouting": {
        "agentWaitSeconds": 60,
        "backupQueueId": "e0c64ec9-f066-40c4-ae9b-c4954d737913",
        "callMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "emailMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "messageMediaSettings": {
            "useAgentAddressOutbound": false
        },
        "waitForAgent": true
    },
    "division": {
        "id": "ae480dd5-b0b9-4c48-bc5f-6dae25c93656",
        "name": "TOG ESS Tier 1",
        "selfUri": "/api/v2/authorization/divisions/ae480dd5-b0b9-4c48-bc5f-6dae25c93656"
    },
    "emailInQueueFlow": {
        "id": "c50c4056-f441-4596-9e83-fd9f48045c1d",
        "name": "Email on Voicemail",
        "selfUri": "/api/v2/flows/c50c4056-f441-4596-9e83-fd9f48045c1d"
    },
    "enableAudioMonitoring": false,
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "joinedMemberCount": 19,
    "lastAgentRoutingMode": "AnyAgent",
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "enableAutoAnswer": false,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "mode": "AgentFirst",
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 21,
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "Access Control - ESS T1",
    "predictiveRouting": {
        "enableConversationScoreBiasing": false,
        "respectSkills": false
    },
    "queueFlow": {
        "id": "d77d8b34-745b-46ce-9ba9-70a4708abc6a",
        "name": "Access Control ESS Tier 2",
        "selfUri": "/api/v2/flows/d77d8b34-745b-46ce-9ba9-70a4708abc6a"
    },
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/4a5b77e2-c4c9-409f-9d7c-56d3b606f02c",
    "skillEvaluationMethod": "NONE",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 21,
    "whisperPrompt": {
        "id": "33d86769-5bdb-4153-a3e7-045b282b4d16",
        "name": "AccessControl",
        "selfUri": "/api/v2/architect/prompts/33d86769-5bdb-4153-a3e7-045b282b4d16"
    }
}

schema_attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 1789
schema_scan_id: 6408481
updated: 2026-04-03 00:58:13

Schema Scans: 15

Last at 2026-04-17 00:58:25

Scan 6415161
- duration: 0:00:16.581052
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6415161
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-17/1776405483",
        "key": "raw/queues/2026-04-17/1776405483/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-17 00:58:25
- success: True
- trace_id: 7920047966415680637

Scan 6414616
- duration: 0:00:13.835750
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414616
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-16/1776319041",
        "key": "raw/queues/2026-04-16/1776319041/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-16 00:57:32
- success: True
- trace_id: 5647952003385000666

Scan 6414128
- duration: 0:00:13.991058
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414128
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-15/1776232819",
        "key": "raw/queues/2026-04-15/1776232819/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-15 01:00:32
- success: True
- trace_id: 4584214983233416472

Scan 6413621
- duration: 0:00:16.402273
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6413621
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-14/1776146458",
        "key": "raw/queues/2026-04-14/1776146458/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-14 01:01:27
- success: True
- trace_id: 10664693219889363725

Scan 6413081
- duration: 0:00:16.630625
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6413081
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-13/1776060331",
        "key": "raw/queues/2026-04-13/1776060331/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-13 01:06:06
- success: True
- trace_id: 5444282517837434105

Scan 6412687
- duration: 0:00:13.944429
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6412687
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-12/1775973487",
        "key": "raw/queues/2026-04-12/1775973487/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-12 00:58:29
- success: True
- trace_id: 5208594575215181797

Scan 6412303
- duration: 0:00:13.735367
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6412303
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-11/1775886967",
        "key": "raw/queues/2026-04-11/1775886967/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-11 00:56:25
- success: True
- trace_id: 14756101650247706343

Scan 6411806
- duration: 0:00:13.760661
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6411806
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-10/1775800640",
        "key": "raw/queues/2026-04-10/1775800640/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-10 00:57:42
- success: True
- trace_id: 5388582861323072930

Scan 6411291
- duration: 0:00:16.539779
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6411291
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-09/1775714338",
        "key": "raw/queues/2026-04-09/1775714338/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-09 00:59:31
- success: True
- trace_id: 2143507049789730492

Scan 6410793
- duration: 0:00:16.380857
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6410793
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-08/1775627900",
        "key": "raw/queues/2026-04-08/1775627900/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-08 00:58:42
- success: True
- trace_id: 8574792157810086646

Scan 6410280
- duration: 0:00:16.835905
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6410280
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-07/1775541458",
        "key": "raw/queues/2026-04-07/1775541458/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-07 00:57:58
- success: True
- trace_id: 15411858533323768220

Scan 6409738
- duration: 0:00:16.288738
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6409738
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-06/1775455100",
        "key": "raw/queues/2026-04-06/1775455100/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-06 00:58:35
- success: True
- trace_id: 9510262877644387550

Scan 6409356
- duration: 0:00:16.392238
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6409356
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-05/1775368677",
        "key": "raw/queues/2026-04-05/1775368677/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-05 00:58:28
- success: True
- trace_id: 4792103787746368223

Scan 6408973
- duration: 0:00:14.125565
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6408973
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-04/1775282225",
        "key": "raw/queues/2026-04-04/1775282225/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-04 00:57:10
- success: True
- trace_id: 9987085225739102095

Scan 6408481
- duration: 0:00:16.547346
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6408481
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/queues/2026-04-03/1775195865",
        "key": "raw/queues/2026-04-03/1775195865/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1789
- start_time: 2026-04-03 00:57:56
- success: True
- trace_id: 15347741395150350841

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "_origin": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "agentOwnedRouting.removeOwnershipOnExpiry": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "cannedResponseLibraries.mode": "string",
    "conditionalGroupActivation.rules": [
        {
            "conditionExpression": "string",
            "conditions": [
                {
                    "operator": "string",
                    "simpleMetric.metric": "string",
                    "simpleMetric.queue.id": "string",
                    "simpleMetric.queue.name": "string",
                    "simpleMetric.queue.selfUri": "string",
                    "value": "string"
                }
            ],
            "groups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "description": "string",
    "directRouting.agentWaitSeconds": "string",
    "directRouting.backupQueueId": "string",
    "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
    "directRouting.waitForAgent": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "emailInQueueFlow.id": "string",
    "emailInQueueFlow.name": "string",
    "emailInQueueFlow.selfUri": "string",
    "enableAudioMonitoring": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lastAgentRoutingMode": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.enableAutoAnswer": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.mode": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
    "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "memberGroups": [
        {
            "id": "string",
            "memberCount": "string",
            "name": "string",
            "selfUri": "string",
            "type": "string"
        }
    ],
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "predictiveRouting.enableConversationScoreBiasing": "string",
    "predictiveRouting.respectSkills": "string",
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

created: 2026-04-17 00:58:28

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-17/1776405483'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-03-08 01:03:26",
        "disabled": false,
        "format": "raw",
        "id": 1789,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_manual",
            "table": "genesys_queues"
        },
        "type": "manual"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "acwSettings.timeoutMs": "string",
            "acwSettings.wrapupPrompt": "string",
            "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
            "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
            "agentOwnedRouting.maxOwnedCallbackHours": "string",
            "agentOwnedRouting.removeOwnershipOnExpiry": "string",
            "autoAnswerOnly": "string",
            "bullseye.rings": [
                {
                    "actions.skillsToRemove": [
                        {
                            "id": "string",
                            "name": "string",
                            "selfUri": "string"
                        }
                    ],
                    "expansionCriteria": [
                        {
                            "threshold": "string",
                            "type": "string"
                        }
                    ]
                }
            ],
            "callingPartyName": "string",
            "callingPartyNumber": "string",
            "cannedResponseLibraries.mode": "string",
            "conditionalGroupActivation.rules": [
                {
                    "conditionExpression": "string",
                    "conditions": [
                        {
                            "operator": "string",
                            "simpleMetric.metric": "string",
                            "simpleMetric.queue.id": "string",
                            "simpleMetric.queue.name": "string",
                            "simpleMetric.queue.selfUri": "string",
                            "value": "string"
                        }
                    ],
                    "groups": [
                        {
                            "id": "string",
                            "memberCount": "string",
                            "name": "string",
                            "selfUri": "string",
                            "type": "string"
                        }
                    ]
                }
            ],
            "createdBy": "string",
            "dateCreated": "string",
            "dateModified": "string",
            "description": "string",
            "directRouting.agentWaitSeconds": "string",
            "directRouting.backupQueueId": "string",
            "directRouting.callMediaSettings.useAgentAddressOutbound": "string",
            "directRouting.emailMediaSettings.useAgentAddressOutbound": "string",
            "directRouting.messageMediaSettings.useAgentAddressOutbound": "string",
            "directRouting.waitForAgent": "string",
            "division.id": "string",
            "division.name": "string",
            "division.selfUri": "string",
            "emailInQueueFlow.id": "string",
            "emailInQueueFlow.name": "string",
            "emailInQueueFlow.selfUri": "string",
            "enableAudioMonitoring": "string",
            "enableManualAssignment": "string",
            "enableTranscription": "string",
            "id": "string",
            "joinedMemberCount": "string",
            "lastAgentRoutingMode": "string",
            "mediaSettings.call.alertingTimeoutSeconds": "string",
            "mediaSettings.call.enableAutoAnswer": "string",
            "mediaSettings.call.serviceLevel.durationMs": "string",
            "mediaSettings.call.serviceLevel.percentage": "string",
            "mediaSettings.callback.alertingTimeoutSeconds": "string",
            "mediaSettings.callback.autoDialDelaySeconds": "string",
            "mediaSettings.callback.autoEndDelaySeconds": "string",
            "mediaSettings.callback.enableAutoDialAndEnd": "string",
            "mediaSettings.callback.mode": "string",
            "mediaSettings.callback.serviceLevel.durationMs": "string",
            "mediaSettings.callback.serviceLevel.percentage": "string",
            "mediaSettings.chat.alertingTimeoutSeconds": "string",
            "mediaSettings.chat.serviceLevel.durationMs": "string",
            "mediaSettings.chat.serviceLevel.percentage": "string",
            "mediaSettings.email.alertingTimeoutSeconds": "string",
            "mediaSettings.email.serviceLevel.durationMs": "string",
            "mediaSettings.email.serviceLevel.percentage": "string",
            "mediaSettings.message.alertingTimeoutSeconds": "string",
            "mediaSettings.message.serviceLevel.durationMs": "string",
            "mediaSettings.message.serviceLevel.percentage": "string",
            "mediaSettings.message.subTypeSettings.facebook.enableAutoAnswer": "string",
            "mediaSettings.message.subTypeSettings.instagram.enableAutoAnswer": "string",
            "mediaSettings.message.subTypeSettings.line.enableAutoAnswer": "string",
            "mediaSettings.message.subTypeSettings.open.enableAutoAnswer": "string",
            "mediaSettings.message.subTypeSettings.sms.enableAutoAnswer": "string",
            "mediaSettings.message.subTypeSettings.twitter.enableAutoAnswer": "string",
            "mediaSettings.message.subTypeSettings.webmessaging.enableAutoAnswer": "string",
            "mediaSettings.message.subTypeSettings.whatsapp.enableAutoAnswer": "string",
            "mediaSettings.workitem.alertingTimeoutSeconds": "string",
            "mediaSettings.workitem.serviceLevel.durationMs": "string",
            "mediaSettings.workitem.serviceLevel.percentage": "string",
            "memberCount": "string",
            "memberGroups": [
                {
                    "id": "string",
                    "memberCount": "string",
                    "name": "string",
                    "selfUri": "string",
                    "type": "string"
                }
            ],
            "modifiedBy": "string",
            "name": "string",
            "outboundMessagingAddresses.smsAddress.id": "string",
            "outboundMessagingAddresses.smsAddress.name": "string",
            "outboundMessagingAddresses.smsAddress.selfUri": "string",
            "predictiveRouting.enableConversationScoreBiasing": "string",
            "predictiveRouting.respectSkills": "string",
            "queueFlow.id": "string",
            "queueFlow.name": "string",
            "queueFlow.selfUri": "string",
            "routingRules": [
                "string"
            ],
            "scoringMethod": "string",
            "selfUri": "string",
            "skillEvaluationMethod": "string",
            "suppressInQueueCallRecording": "string",
            "userMemberCount": "string",
            "whisperPrompt.id": "string",
            "whisperPrompt.name": "string",
            "whisperPrompt.selfUri": "string"
        },
        "created": "2026-04-17 00:58:28",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoAnswer`:STRING>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`mode`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING,`enableAutoDialAndEnd`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`scoringMethod`STRING,`lastAgentRoutingMode`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`autoAnswerOnly`STRING,`cannedResponseLibraries`struct<`mode`:STRING>,`enableTranscription`STRING,`enableManualAssignment`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING,`removeOwnershipOnExpiry`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`directRouting`struct<`callMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`emailMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`messageMediaSettings`:struct<`useAgentAddressOutbound`:STRING>,`backupQueueId`:STRING,`waitForAgent`:STRING,`agentWaitSeconds`:STRING>,`callingPartyNumber`STRING,`description`STRING,`callingPartyName`STRING,`enableAudioMonitoring`STRING,`predictiveRouting`struct<`respectSkills`:STRING,`enableConversationScoreBiasing`:STRING>,`emailInQueueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-stage/raw/queues/2026-04-17/1776405483'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_queues`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_manual.genesys_queues"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}