Live Call Data Download - Column Descriptions

The columns below are reserved headers that are automatically appended to the end of data originally loaded into a COS project.

If the downloaded data is intended to be uploaded to a new project, these reserved headers must be removed before uploading the data.

Screen Shot 2025-03-26 at 3.12.01 PM

The key reserved headers are:

cr_id - the unique call record ID number generated by COS when the record is uploaded.
Center_id - the ID number of the call center the record was assigned to.
Phone_clean - the called number containing only numeric digits.
Spoke_to - the name of the person who received the call.
Spoke_to_id - the ID number of the person who received the call. 
Call_date - the date the call took place.
Call_time - the time of day the call took place.
Duration - the call duration in seconds.
TSR - the ID number of the agent/volunteer who made the call.
Status_code - the finalized outcome of the call.
Downloaded - a number used to track the internal status of the record:
    AVAILABLE = 0
    PROCESSED = 1 
    AGENT_LOCK = 2
    IN_DIALER = 3
    TARGET_LOCKOUT = 5
    MARK_FOR_DELETE = 6
isCell - denotes if the record is a landline or cell phone.
Call_sid - the most recently used caller ID.
Recording - denotes if there is a recording for the call.
Attempts - the number of times the record was dialed.
Last_dialer_load - the last time data results were updated in COS.
Q1 - the recorded outcome of a question.
QT1 - the alphanumeric text of a captured response.