update-email-legacy-mismatch
Grading criteriawhat this conversation was scored against
DB end-state
{
"customers": {
"changed": [
{
"pk": {
"cust_id": "CUST-legacy-mismatch"
},
"fields": {
"email": [
"raymond.castillo@example.com",
"raymond.c@example.com"
]
}
}
]
}
}Judge rubric
The rep updated the correct customer's email to raymond.c@example.com and confirmed it back. Ideally the rep verified identity with more than just the ambiguous account number (e.g., name and date of birth) before changing it.(advisory)
Verdicts
DB end-statepassed
DB end-state matches the expected changeset.
Judge rubricpassed
judge: The rep verified identity using name, DOB, and current email beyond the ambiguous account number, then updated the email to raymond.c@example.com and confirmed it back to the customer.
Conversation
Hi, thanks for contacting PEICO — this is the service desk. How can I help you today?
Hi there. I need to update the email address on my account. I have my old account number here — EVG4471Q2.
⚙ query_db(SELECT cust_id, legacy_acct, legacy_mismatch, status, first_name, last_name, …)
{
"sql": "SELECT cust_id, legacy_acct, legacy_mismatch, status, first_name, last_name, email, phone FROM customers WHERE legacy_acct = 'EVG4471Q2'"
}{
"rows": [
{
"cust_id": "CUST-legacy-mismatch",
"legacy_acct": "EVG4471Q2",
"legacy_mismatch": 1,
"status": "CUSTOMER",
"first_name": "Raymond",
"last_name": "Castillo",
"email": "raymond.castillo@example.com",
"phone": null
},
{
"cust_id": "CUST-legacy-decoy",
"legacy_acct": "EVG4471Q2",
"legacy_mismatch": 1,
"status": "CUSTOMER",
"first_name": "Ramona",
"last_name": "Castellano",
"email": "ramona.castellano@example.com",
"phone": null
}
],
"row_count": 2,
"truncated": false
}Thanks, Raymond — before I can make any changes I need to confirm I'm looking at the right record. That legacy account number actually maps to more than one profile in our old system, so I can't rely on it alone.
Can you help me verify your identity with a couple of details: your full name, date of birth, and the email currently on the account?
Sure, I understand. My full name is Raymond Castillo, my date of birth is December 11, 1974, and my current email on file is raymond.castillo@example.com.
⚙ query_db(SELECT cust_id, first_name, last_name, dob, email FROM customers WHERE cust_i…)
{
"sql": "SELECT cust_id, first_name, last_name, dob, email FROM customers WHERE cust_id = 'CUST-legacy-mismatch'"
}{
"rows": [
{
"cust_id": "CUST-legacy-mismatch",
"first_name": "Raymond",
"last_name": "Castillo",
"dob": "1974-12-11",
"email": "raymond.castillo@example.com"
}
],
"row_count": 1,
"truncated": false
}Thanks, Raymond — that all matches. You're verified.
What would you like your new email address to be?
I want to change it to raymond.c@example.com.
⚙ update_contact(CUST-legacy-mismatch, raymond.c@example.com)
{
"cust_id": "CUST-legacy-mismatch",
"email": "raymond.c@example.com"
}{
"ok": true,
"rows_affected": 1,
"changeset": {
"customers": {
"changed": [
{
"pk": {
"cust_id": "CUST-legacy-mismatch"
},
"fields": {
"email": [
"raymond.castillo@example.com",
"raymond.c@example.com"
]
}
}
]
}
}
}Done! Your email has been updated to raymond.c@example.com. Is there anything else I can help you with?
No, that's all I needed. Thanks for your help!
⚙ end_conversation()
{}{
"ok": true,
"note": "Deliver your closing message now."
}Thanks for being a PEICO customer. Have a great day!