| # |
Name |
Data Type |
Length |
| 1 |
gcis_party_id |
character varying |
400 |
| 2 |
dob |
date |
|
| 3 |
gender |
character varying |
7 |
| 4 |
surname_change_flag |
text |
|
| 5 |
deceased_ind |
character varying |
3 |
| 6 |
prim_contact_ind |
character varying |
3 |
| 7 |
res_address_suburb |
character varying |
|
| 8 |
res_address_postcode |
character varying |
30 |
| 9 |
res_address_state |
character varying |
90 |
| 10 |
res_address_country_code |
character varying |
6 |
| 11 |
res_country_name |
character varying |
180 |
| 12 |
mailing_address_suburb |
character varying |
|
| 13 |
mailing_address_postcode |
character varying |
30 |
| 14 |
mailing_address_state |
character varying |
90 |
| 15 |
mailing_address_country |
character varying |
6 |
| 16 |
mailing_country_name |
character varying |
180 |
| 17 |
mailing_po_box_flag |
text |
|
| 18 |
global_consent_ind |
character varying |
3 |
| 19 |
sms_consent_ind |
text |
|
| 20 |
phone_consent_ind |
text |
|
| 21 |
email_consent_ind |
text |
|
| 22 |
online_consent_ind |
text |
|
| 23 |
mail_consent_ind |
text |
|
| 24 |
monthend_date |
date |
|