Schema Info

Schema Name: sfdl_prod_manual.genesys_queues

created: 2023-03-10 01:03:27
disabled: False
format: raw
id: 1520
is_partitioned: False
is_schema_datatyped: False

name:

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

type: manual

Schema Versions: 15

Version 1717493

created: 2026-04-17 00:54:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-17/1776405284'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-17/1776405284
id: 1717493
processed: 1

raw_data:

{
    "_origin": "2026-04-17T00:54:45Z|raw/queues/2026-04-16/1776405285/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 162163944
updated: 2026-04-17 00:55:13

Version 1716257

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-16/1776319037'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-16/1776319037
id: 1716257
processed: 1

raw_data:

{
    "_origin": "2026-04-16T00:57:18Z|raw/queues/2026-04-15/1776319038/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 162108356
updated: 2026-04-16 00:57:37

Version 1715065

created: 2026-04-15 00:59:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-15/1776232698'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-15/1776232698
id: 1715065
processed: 1

raw_data:

{
    "_origin": "2026-04-15T00:58:18Z|raw/queues/2026-04-14/1776232698/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 162052855
updated: 2026-04-15 00:59:29

Version 1713868

created: 2026-04-14 01:01:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-14/1776146460'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-14/1776146460
id: 1713868
processed: 1

raw_data:

{
    "_origin": "2026-04-14T01:01:01Z|raw/queues/2026-04-13/1776146461/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161997487
updated: 2026-04-14 01:01:27

Version 1712643

created: 2026-04-13 01:03:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-13/1776060221'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-13/1776060221
id: 1712643
processed: 1

raw_data:

{
    "_origin": "2026-04-13T01:03:42Z|raw/queues/2026-04-12/1776060222/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161940034
updated: 2026-04-13 01:04:11

Version 1711431

created: 2026-04-12 00:54:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-12/1775973268'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-12/1775973268
id: 1711431
processed: 1

raw_data:

{
    "_origin": "2026-04-12T00:54:29Z|raw/queues/2026-04-11/1775973269/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161889199
updated: 2026-04-12 00:54:53

Version 1710243

created: 2026-04-11 00:54:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-11/1775886847'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-11/1775886847
id: 1710243
processed: 1

raw_data:

{
    "_origin": "2026-04-11T00:54:07Z|raw/queues/2026-04-10/1775886847/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161837441
updated: 2026-04-11 00:54:37

Version 1709089

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-10/1775800627'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-10/1775800627
id: 1709089
processed: 1

raw_data:

{
    "_origin": "2026-04-10T00:57:08Z|raw/queues/2026-04-09/1775800628/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161782337
updated: 2026-04-10 00:58:12

Version 1707965

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-09/1775714273'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-09/1775714273
id: 1707965
processed: 1

raw_data:

{
    "_origin": "2026-04-09T00:57:53Z|raw/queues/2026-04-08/1775714273/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161727462
updated: 2026-04-09 00:59:24

Version 1706737

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-08/1775627824'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-08/1775627824
id: 1706737
processed: 1

raw_data:

{
    "_origin": "2026-04-08T00:57:05Z|raw/queues/2026-04-07/1775627825/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161671864
updated: 2026-04-08 00:58:44

Version 1705553

created: 2026-04-07 00:57:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-07/1775541436'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-07/1775541436
id: 1705553
processed: 1

raw_data:

{
    "_origin": "2026-04-07T00:57:16Z|raw/queues/2026-04-06/1775541436/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161615841
updated: 2026-04-07 00:57:50

Version 1704323

created: 2026-04-06 01:02:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-06/1775455199'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-06/1775455199
id: 1704323
processed: 1

raw_data:

{
    "_origin": "2026-04-06T00:59:59Z|raw/queues/2026-04-05/1775455199/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161558563
updated: 2026-04-06 01:02:17

Version 1703155

created: 2026-04-05 00:57:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-05/1775368625'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-05/1775368625
id: 1703155
processed: 1

raw_data:

{
    "_origin": "2026-04-05T00:57:06Z|raw/queues/2026-04-04/1775368626/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161511626
updated: 2026-04-05 00:57:49

Version 1701978

created: 2026-04-04 00:58:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-04/1775282236'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-04/1775282236
id: 1701978
processed: 1

raw_data:

{
    "_origin": "2026-04-04T00:57:17Z|raw/queues/2026-04-03/1775282237/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161456469
updated: 2026-04-04 00:58:16

Version 1700750

created: 2026-04-03 00:58:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-03/1775195841'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/queues/2026-04-03/1775195841
id: 1700750
processed: 1

raw_data:

{
    "_origin": "2026-04-03T00:57:21Z|raw/queues/2026-04-02/1775195841/data.json.gz|airflow_genesys_prod",
    "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: 1520
schema_scan_id: 161397773
updated: 2026-04-03 00:58:22

Schema Scans: 15

Last at 2026-04-17 00:54:57

Scan 162163944
- duration: 0:00:16.471674
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162163944
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-17/1776405284",
        "key": "raw/queues/2026-04-17/1776405284/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-17 00:54:57
- success: True
- trace_id: 9596096892966616367

Scan 162108356
- duration: 0:00:13.704264
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162108356
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-16/1776319037",
        "key": "raw/queues/2026-04-16/1776319037/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-16 00:57:23
- success: True
- trace_id: 17514583357801780188

Scan 162052855
- duration: 0:00:16.432910
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162052855
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-15/1776232698",
        "key": "raw/queues/2026-04-15/1776232698/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-15 00:59:13
- success: True
- trace_id: 9947497341430935217

Scan 161997487
- duration: 0:00:16.109141
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161997487
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-14/1776146460",
        "key": "raw/queues/2026-04-14/1776146460/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-14 01:01:11
- success: True
- trace_id: 10796657493445464939

Scan 161940034
- duration: 0:00:16.139760
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161940034
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-13/1776060221",
        "key": "raw/queues/2026-04-13/1776060221/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-13 01:03:55
- success: True
- trace_id: 13182908265844571839

Scan 161889199
- duration: 0:00:16.152936
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161889199
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-12/1775973268",
        "key": "raw/queues/2026-04-12/1775973268/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-12 00:54:37
- success: True
- trace_id: 15964101226466743654

Scan 161837441
- duration: 0:00:16.180018
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161837441
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-11/1775886847",
        "key": "raw/queues/2026-04-11/1775886847/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-11 00:54:21
- success: True
- trace_id: 7034846259175688257

Scan 161782337
- duration: 0:00:14.024113
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161782337
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-10/1775800627",
        "key": "raw/queues/2026-04-10/1775800627/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-10 00:57:58
- success: True
- trace_id: 15190193724303016395

Scan 161727462
- duration: 0:00:16.299865
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161727462
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-09/1775714273",
        "key": "raw/queues/2026-04-09/1775714273/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-09 00:59:08
- success: True
- trace_id: 4626843705601581273

Scan 161671864
- duration: 0:00:13.963660
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161671864
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-08/1775627824",
        "key": "raw/queues/2026-04-08/1775627824/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-08 00:58:30
- success: True
- trace_id: 5083669263151536246

Scan 161615841
- duration: 0:00:16.641973
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161615841
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-07/1775541436",
        "key": "raw/queues/2026-04-07/1775541436/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-07 00:57:34
- success: True
- trace_id: 8926074336791196405

Scan 161558563
- duration: 0:00:16.199066
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161558563
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-06/1775455199",
        "key": "raw/queues/2026-04-06/1775455199/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-06 01:02:01
- success: True
- trace_id: 4464128453001228265

Scan 161511626
- duration: 0:00:16.343129
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161511626
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-05/1775368625",
        "key": "raw/queues/2026-04-05/1775368625/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-05 00:57:32
- success: True
- trace_id: 9330181177509879087

Scan 161456469
- duration: 0:00:16.668955
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161456469
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-04/1775282236",
        "key": "raw/queues/2026-04-04/1775282236/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-04 00:57:59
- success: True
- trace_id: 2526565117907822999

Scan 161397773
- duration: 0:00:13.761610
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161397773
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/queues/2026-04-03/1775195841",
        "key": "raw/queues/2026-04-03/1775195841/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1520
- start_time: 2026-04-03 00:58:09
- success: True
- trace_id: 5877846726948410512

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:54:59

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-17/1776405284'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-03-10 01:03:27",
        "disabled": false,
        "format": "raw",
        "id": 1520,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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:54:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/queues/2026-04-17/1776405284'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_queues`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_queues"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}