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.