| # |
Name |
Data Type |
Length |
| 1 |
SURVEY_ITEM_UNIQUE_ID |
CHARACTER VARYING(100) |
100 |
| 2 |
CUSTOMER_NUMBER |
CHARACTER VARYING(12) |
12 |
| 3 |
POLICY_NUMBER |
CHARACTER VARYING(20) |
20 |
| 4 |
CLAIM_NUMBER |
CHARACTER VARYING(20) |
20 |
| 5 |
ACCOUNT_NUMBER |
CHARACTER VARYING(20) |
20 |
| 6 |
CALL_ID |
CHARACTER VARYING(20) |
20 |
| 7 |
TELLER_ID |
CHARACTER VARYING(20) |
20 |
| 8 |
GCIS_ID |
CHARACTER VARYING(20) |
20 |
| 9 |
EXTRA_SUNCORP_ID |
CHARACTER VARYING(20) |
20 |
| 10 |
SURVEY_ID |
INTEGER |
4 |
| 11 |
SURVEY_DATE |
DATE |
4 |
| 12 |
RESPONSE_Q1 |
CHARACTER VARYING(1250) |
1250 |
| 13 |
RESPONSE_Q2 |
CHARACTER VARYING(1250) |
1250 |
| 14 |
RESPONSE_Q3 |
CHARACTER VARYING(1250) |
1250 |
| 15 |
RESPONSE_Q4 |
CHARACTER VARYING(1250) |
1250 |
| 16 |
RESPONSE_Q5 |
CHARACTER VARYING(1250) |
1250 |
| 17 |
RESPONSE_Q6 |
CHARACTER VARYING(1250) |
1250 |
| 18 |
RESPONSE_Q7 |
CHARACTER VARYING(1250) |
1250 |
| 19 |
RESPONSE_Q8 |
CHARACTER VARYING(1250) |
1250 |
| 20 |
RESPONSE_Q9 |
CHARACTER VARYING(1250) |
1250 |
| 21 |
RESPONSE_Q10 |
CHARACTER VARYING(1250) |
1250 |
| 22 |
RESPONSE_Q11 |
CHARACTER VARYING(1250) |
1250 |
| 23 |
RESPONSE_Q12 |
CHARACTER VARYING(1250) |
1250 |
| 24 |
RESPONSE_Q13 |
CHARACTER VARYING(1250) |
1250 |
| 25 |
RESPONSE_Q14 |
CHARACTER VARYING(1250) |
1250 |
| 26 |
RESPONSE_Q15 |
CHARACTER VARYING(1250) |
1250 |
| 27 |
RESPONSE_Q16 |
CHARACTER VARYING(1250) |
1250 |
| 28 |
RESPONSE_Q17 |
CHARACTER VARYING(1250) |
1250 |
| 29 |
RESPONSE_Q18 |
CHARACTER VARYING(1250) |
1250 |
| 30 |
RESPONSE_Q19 |
CHARACTER VARYING(1250) |
1250 |
| 31 |
RESPONSE_Q20 |
CHARACTER VARYING(1250) |
1250 |
| 32 |
RESPONSE_Q21 |
CHARACTER VARYING(1250) |
1250 |
| 33 |
RESPONSE_Q22 |
CHARACTER VARYING(1250) |
1250 |
| 34 |
RESPONSE_Q23 |
CHARACTER VARYING(1250) |
1250 |
| 35 |
RESPONSE_Q24 |
CHARACTER VARYING(1250) |
1250 |
| 36 |
RESPONSE_Q25 |
CHARACTER VARYING(1250) |
1250 |
| 37 |
RESPONSE_Q26 |
CHARACTER VARYING(1250) |
1250 |
| 38 |
RESPONSE_Q27 |
CHARACTER VARYING(1250) |
1250 |
| 39 |
RESPONSE_Q28 |
CHARACTER VARYING(1250) |
1250 |
| 40 |
RESPONSE_Q29 |
CHARACTER VARYING(1250) |
1250 |
| 41 |
RESPONSE_Q30 |
CHARACTER VARYING(1250) |
1250 |
| 42 |
RESPONSE_Q31 |
CHARACTER VARYING(1250) |
1250 |
| 43 |
RESPONSE_Q32 |
CHARACTER VARYING(1250) |
1250 |
| 44 |
RESPONSE_Q33 |
CHARACTER VARYING(1250) |
1250 |
| 45 |
RESPONSE_Q34 |
CHARACTER VARYING(1250) |
1250 |
| 46 |
RESPONSE_Q35 |
CHARACTER VARYING(1250) |
1250 |
| 47 |
RESPONSE_Q36 |
CHARACTER VARYING(1250) |
1250 |
| 48 |
RESPONSE_Q37 |
CHARACTER VARYING(1250) |
1250 |
| 49 |
RESPONSE_Q38 |
CHARACTER VARYING(1250) |
1250 |
| 50 |
RESPONSE_Q39 |
CHARACTER VARYING(1250) |
1250 |
| 51 |
RESPONSE_Q40 |
CHARACTER VARYING(1250) |
1250 |
| 52 |
RESPONSE_Q41 |
CHARACTER VARYING(1250) |
1250 |
| 53 |
RESPONSE_Q42 |
CHARACTER VARYING(1250) |
1250 |
| 54 |
RESPONSE_Q43 |
CHARACTER VARYING(1250) |
1250 |
| 55 |
RESPONSE_Q44 |
CHARACTER VARYING(1250) |
1250 |
| 56 |
RESPONSE_Q45 |
CHARACTER VARYING(1250) |
1250 |
| 57 |
RESPONSE_Q46 |
CHARACTER VARYING(1250) |
1250 |
| 58 |
RESPONSE_Q47 |
CHARACTER VARYING(1250) |
1250 |
| 59 |
RESPONSE_Q48 |
CHARACTER VARYING(1250) |
1250 |
| 60 |
RESPONSE_Q49 |
CHARACTER VARYING(1250) |
1250 |
| 61 |
RESPONSE_Q50 |
CHARACTER VARYING(1250) |
1250 |
| 62 |
NPS |
CHARACTER VARYING(300) |
300 |
| 63 |
OPT_OUT_FLAG_THIS_SURVEY |
CHARACTER VARYING(1) |
1 |
| 64 |
OPT_OUT_FLAG_ALL_SURVEYS |
CHARACTER VARYING(1) |
1 |
| 65 |
DATE_COMPLETED |
DATE |
4 |
| 66 |
EFF_STRT_DT |
DATE |
4 |
| 67 |
EFF_END_DT |
DATE |
4 |