[
{
"Survey ID": 123456,
"Parent ID": "1151191",
"PSID": "PSID456",
"Transaction ID": "TX789",
"Project Name": "Traffic Survey Project",
"Child Type": "TypeA",
"Survey Country": "US",
"Survey Language": "en",
"Supplier ID": 101,
"Supplier Name": "Supplier Inc.",
"Supplier Group": "GroupA",
"PO / Billing": "PO123456",
"Requested By": "John Doe",
"Supplier Respondent ID": "SRID789",
"Supplier Sid": "SID101",
"Buyer ID": 202,
"Buyer Name": "Buyer Corp.",
"PS Entry DateTime": "2024-06-01T12:00:00Z",
"Buyer Survey Entry Datetime": "2024-06-01T12:05:00Z",
"Buyer Survey Return Datetime": "2024-06-01T12:30:00Z",
"PS Exit Datetime": "2024-06-01T12:35:00Z",
"Respondent Status Code": 1,
"Respondent Status Description": "Completed",
"Offer ID": "OFFER123",
"Respondent Source": "Online",
"Expected Buyer CPI": 2.5,
"Expected Buyer CPI Fx": 2,
"Block": 0,
"Is Block Factor": 0,
"GPP": 10,
"GPP LOI": 15,
"GPP IR": 20,
"Respondent LOI": 12,
"Respondent Buyer CPI": 2.5,
"Reconciliation Status": 1,
"Reconciliation Date": "2024-06-02T09:00:00Z",
"Reconciliation Reason": "Verified",
"Transaction Original Status": "Active",
"Transaction Original Description": "Initial transaction",
"PM": "Jane Smith",
"Buyer PM Email": "jane.smith@buyer.com",
"Sub Supplier Name": "SubSupplier Ltd.",
"PS_Termination Reason": "Quota Full",
"PS_Termination Code": "QF",
"PS_QuotaFull Reason": "Reached max respondents",
"Gender": "Male",
"Gender Code": 1,
"Age": 35,
"Income": 50000,
"Race": "White",
"Race Code": 1,
"Race/Ethnicity": "Non-Hispanic",
"Race/Ethnicity Code": 1,
"HispanicOrigin": "No",
"HispanicOrigin Code": 0,
"Relationship": "Single",
"Relationship Code": 1,
"Employment": "Employed",
"Employment Code": 1,
"Education": "Bachelor's",
"Education Code": 2,
"Device": "Mobile",
"Device Code": 1,
"ZipCode": "90210",
"Children Count": 2,
"Child1 Age": 5,
"Child1 Gender": "Female",
"Child2 Age": 3,
"Child2 Gender": "Male",
"Child3 Age": "",
"Child3 Gender": "",
"Child4 Age": "",
"Child4 Gender": "",
"Child5 Age": "",
"Child5 Gender": "",
"Region": "West",
"Region Code": 1,
"Division": "Pacific",
"Division Code": 1,
"State": "California",
"State Code": 6,
"Browser": "Chrome",
"UserAgent": "Mozilla/5.0",
"IP": "192.168.1.1",
"Programmatic Direct Transaction": true,
"Buyer PM": "Jane Smith",
"Reconciliation By": "Admin",
"Respondent Substatus Description": "Verified",
"Modular Transaction": false
}
]
