The columns below are appended to the end of the data that was originally loaded into a COS project.
cr_id - the call record ID number. Once uploaded, every record in a universe is given a unique cr_id number generate by COS.
Center_id - the ID number of the call center that the records were assigned to.
Phone_clean - the number that was called containing only numeric digits
Spoke_to - the name of the person that received the call
Spoke_to_id - the ID number of the person that received the call
Call_date - the date in which the call took place
Call_time - the time of day that the call took place
Duration - the amount of time the call lasted in seconds
TSR - the ID number of the agent/volunteer who made the call
Status_code - the finalized outcome of the call
Downloaded - this field is a number used to track internal status of a record
- AVAILABLE = 0
- PROCESSED = 1
- AGENT_LOCK = 2
- IN_DIALER =3
- TARGET_LOCKOUT = 5
- MARK_FOR_DELETE = 6
Call_sid - the most recently used caller ID
Recording - denotes if there is a recording for the call
Attempts - the number of times a 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