I was needing to build a report containing the number of surveys sent to customers and what percentage of them was successfully answered. I found the Survey_Stats table, having these fields:
|cyc_counter||INTEGER||Identifies the cycle counter to be compared against the cycle (described in the next field).|
|cycle||INTEGER||Identifies the submission cycle.|
|del||INTEGER||Active_Boolean_Table::enum||Specifies the status of the Deleted flag, as follows:0 -- Active1 -- Inactive/marked deleted)|
|id||INTEGER||Primary key of this table.|
|persid||nvarchar(30)||Specifies the Persistent ID: (SystemObjectName:id).|
|sub_counter||INTEGER||Identifies the number of times notification submission was approved.|
|tplid||INTEGER||Survey_Template::id||Identifies the unique (to the table) numeric ID.|
I've identified two fields above (cyc_counter, sub_counter) that could be useful for me. In a chat with an CA analyst, he did some tests and verified these fields indeed register the number of survey that was sent to customers.
My question is: what's the difference between cyc_counter and sub_counter fields? What means a notification to be "approved"? Note: in all environments I checked, the two fields contained the same number for each SDM.