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.
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.