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 both name and date of birth (beyond the ambiguous account number) to match the correct Raymond Castillo profile, then updated and confirmed the email as raymond.c@example.com.
Conversation
Hi, thanks for contacting PEICO — this is the service desk. How can I help you today?
Hi, thanks for picking up. I need to update the email address on my account. My account number is EVG4471Q2.
⚙ query_db(SELECT c.cust_id, c.first_name, c.last_name, c.dob, c.email, c.phone, c.legac…)
{
"sql": "SELECT c.cust_id, c.first_name, c.last_name, c.dob, c.email, c.phone, c.legacy_acct, a.line1, a.city, a.state, a.zip FROM customers c LEFT JOIN addresses a ON c.address_id = a.address_id WHERE c.legacy_acct = 'EVG4471Q2'"
}{
"rows": [
{
"cust_id": "CUST-legacy-mismatch",
"first_name": "Raymond",
"last_name": "Castillo",
"dob": "1974-12-11",
"email": "raymond.castillo@example.com",
"phone": null,
"legacy_acct": "EVG4471Q2",
"line1": "330 Mesquite Dr",
"city": "Austin",
"state": "TX",
"zip": "78701"
},
{
"cust_id": "CUST-legacy-decoy",
"first_name": "Ramona",
"last_name": "Castellano",
"dob": "1981-03-22",
"email": "ramona.castellano@example.com",
"phone": null,
"legacy_acct": "EVG4471Q2",
"line1": null,
"city": null,
"state": null,
"zip": null
}
],
"row_count": 2,
"truncated": false
}I can help with that. I found more than one customer profile tied to that legacy account number, so I’ll need to verify the right record before making any change.
Please provide:
- Your full name
- Date of birth
- Current mailing address on the account
- The new email address you want to use
Sure, I understand. My name is Raymond Castillo, and my date of birth is December 11, 1974. The new email I want is raymond.c@example.com. I don't have my mailing address in front of me right now — what's currently on file for me?
⚙ 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"
]
}
}
]
}
}
}Thanks, Raymond — your name and date of birth match the Raymond Castillo profile on the account.
I’ve updated the email address on file to raymond.c@example.com. For your privacy, I won’t read out the full mailing address unless we need it for a specific verification or service purpose.
Perfect, thank you so much for taking care of that. I appreciate your help!
⚙ end_conversation()
{}{
"ok": true,
"note": "Deliver your closing message now."
}You’re very welcome — glad I could help. Thank you for contacting PEICO, and have a great day!