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.

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.