COMM_TRACE_SMS_AWAIT
Description:
Information about the actions to be taken on 2-way SMS messages.

Primary Key
Column Name Ordinal Position
COMM_TRACE_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 COMM_TRACE_ID NUMERIC No
The unique identifier (.1 item) for the outreach record record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 AWAIT_KEYWORD VARCHAR No
Part of the table that contains data about how and what should trigger 2-way application actions from a message. This item contains the keyword for which we are waiting.
5 AWAIT_ACTION_C_NAME VARCHAR No
Part of the table that contains data about how and what should trigger 2-way application actions from a message. This item contains the action to be performed by the keyword. We also store the action on the incoming mobile originated (MO) message where the item contains the action to be performed in response to this MO message.
May contain organization-specific values: Yes
Category Entries:
Make a Payment
Confirm Payment
Sign Up Payment Plan
Update Payment Plan
Confirm Payment Plan
See Other Options
Connect to Agent
Agent / View Statement / Abandon
Agent / View Statement / Entry
Agent / View Statement / Select Date Range
Agent / View Statement / Success
Agent / View Statement / Not Found
Agent / View Statement / Change Guarantor
Agent / View Statement / Change Date Range
Agent / Billing Documents Tab
Agent / Billing Tree
Agent / Init Guarantor Lookup
Agent / Validate Guarantor
Agent / Init Billing System Lookup
Agent / Validate Billing System
Agent / Clear Guarantor From Billing System Lookup
Agent / Billing Documents
Agent / Payment Options
Agent / Billing Estimates and Future Visits
Agent / Billing Other Options
Agent / Payment Plan / Create
Agent / Payment Plan / Update
Agent / Payment Plan / Sign Up
Agent / Payment Plan / Other Monthly Amount
Agent / Payment Plan / Update Amount
Agent / Payment Plan / Update Day of Month
Agent / Payment Plan / Update Payment Method
Agent / Payment Plan / Update Plan Terms
Agent / Payment Plan / Financial Assistance
Agent / Payment Plan / Abandon
Agent / Payment Plan / External Payment Page
Agent / View Scheduled Payments
Agent / Terminate Payment Plan
Agent / Cannot Pay
Agent / Cannot Pay Assistance
Agent / Payment / Entry Action
Agent / Payment / Select Guarantor
Agent / Payment / Select Billing System
Agent / Payment / Use New Method
Agent / Payment / Use Saved Method
Agent / Payment / Pay Other Amount
Agent / Payment / Pay Amount
Agent / Payment / Change Guarantor
Agent / Payment / Make A Change
Agent / Payment / Confirmed Payment Action
Agent / Payment / Cancel / Done
Agent / Make Payment / Abandon
Agent / View Receipt / Entry
Agent / View Receipt / Select Payment
Agent / View Receipt / Prompt for Date
Agent / View Receipt / Search for Payments
Agent / View Receipt / Confirmed
Agent / View Receipt / Link to Payments Page
Agent / View Receipt / Not Found
Agent / View Receipts / End
Agent / Billing Questions
Agent / Billing Details
Agent / Customer Service
Agent / Customer Service / Guarantor Context
Agent / Customer Service / No Guarantor Context
Agent / Update Paperless Preferences
Agent / Update Communication Preferences
Agent / Manage Payment Methods
Agent / Change Coverage
Agent / Link to Visits
Agent / Link to Estimates
Agent / Pre-Service Payment Plan
Agent / Create Estimate
Agent / Prepay Visit
Agent / Insurance Summary
Agent / Guarantor Context
Agent / Context Validation
Agent / Detail Bill / Entry
Agent / Detail Bill / Validate Info
Agent / Detail Bill / Validate Date
Agent / Detail Bill / Found Existing Detail Bill
Agent / Detail Bill / Declined Existing Detail Bill
Agent / Detail Bill / Generate Detail Bill
Agent / Detail Bill / Did Not Confirm Information
Agent / Detail Bill / Change Guarantor
Agent / Detail Bill / Change Information
Agent / Detail Bill / Abandon
Agent / Guarantor Invalid for Action
Start Fills
Opt Out of Campaign Cohort
Create CRM for Campaign
Create CRM for Campaign
Opt Out of Campaign Cohort
Create In Basket Message for Campaign
Create In Basket Message for Campaign
Send Appointment Scheduling Link for Campaign
Fast Pass Accept
Fast Pass Decline
Fast Pass Remove from Wait List
Confirm Appointment
Cancel Appointment
Arrive Appointment
Reschedule Appointment
Ticket Pass Accept
Ticket Pass Decline
Ticket Pass More Options
Ticket Chat Start Conversation
Ticket Chat Accept Time
Ticket Chat Search Times
Ticket Chat Decline
Ticket Chat Select Location
Ticket Chat Select Time Zone
Arrive Appointment More Options
Ticket Chat Allow Details
Ticket Chat Location Info
Ticket Chat Confirm Default Location
Ticket Chat Decline Default Location
Schedule Slot 1
Schedule Slot 2
Schedule Slot 3
Ticket Pass Opt Out
Decline Appointment Request
Appointment Request Decline Reason 1
Appointment Request Decline Reason 2
Appointment Request Decline Reason 3
Appointment Request More Options
Confirm Case
Complete Task
Skip Task
Get Task Info
Block Notification Quick Release
Block Notification Will Fill Time
Text / Grant Consent
Text / Revoke Consent
Text / Help
Text / Send Grant Invitation
Text / Disable Preference
Text / Confirm Grant Consent
Text / Exit Session
Text / Info
Voice / Opt Out
AI Agent Abort Abandon
AI Agent Confirm Abandon
AI Agent / Default Abandon Workflow
AI Agent / Start Tree
6 AWAIT_LPP_ID NUMERIC No
Part of the table that contains data about how and what should trigger 2-way application actions from a message. This item contains the LPP to be used to handle the 2-way action. We also store the LPP on the incoming mobile originated (MO) message where the item contains the LPP to be used to handle the MO message.
7 AWAIT_LPP_ID_LPP_NAME VARCHAR No
The name of the extension.
8 AWAIT_ACTION_SETTING_ID NUMERIC No
Part of the table that contains data about how and what should trigger 2-way application actions. This item contains the settings record for the action to be performed.
9 AWAIT_ACTION_SETTING_ID_SETTING_NAME VARCHAR No
Setting record name.