ug
sub_id
|
645D2A50-1D53-40B7-9DD5-8238AFAF8029
VAQ1234 or 123456
|
varchar(36)
varchar(20)
|
Optional
Optional
|
Lead's Unique identifier
External Member Id
* Note : one of these two is required.
|
|
status
|
S or T or Q
|
varchar(5)
|
Yes
|
Status = S, means member completed the Survey Preliminarily.
= T, means member failed or terminated from the Survey.
= Q, means memeber quota full for the Survey.
Initially when the member completes the survey preliminarily we fire a Pixel with
status = S and then after 2 to 3 weeks (means, when we have the Updated final completes
list from the client side people), if this member is not in the final completed
list we fire the pixel with Status = R. So always the status “S” indicates that
member can get reward and the Status “R” cancels the rewards issued preliminarily
(Status = S).
|
|
title
|
Health Survey
|
varchar(250)
|
Yes
|
Name of the Survey, member completed
|
|
surveyid
|
9345
|
int
|
Yes
|
Id of the Survey, member completed
|
|
es_id
|
1234
|
int
|
Optional
|
Entry Id of the Survey, member participated
|
Redirect URL