DIM_BNK_GCIS_CUSTOMER_DETAILS_INSIGHT
Description
Synonyms
SDSNZP02_BANK..UBAR_DIM_BNK_GCIS_CUSTOMER_DETAILS_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | GCIS_PARTY_ID | INTEGER | 4 |
| 2 | TITLE | CHARACTER VARYING(30) | 30 |
| 3 | FIRST_NAME | CHARACTER VARYING(30) | 30 |
| 4 | MIDDLE_NAME | CHARACTER VARYING(60) | 60 |
| 5 | LAST_NAME | CHARACTER VARYING(40) | 40 |
| 6 | SUFFIX | CHARACTER VARYING(30) | 30 |
| 7 | DATE_OF_BIRTH | DATE | 4 |
| 8 | GENDER_CODE | CHARACTER VARYING(1) | 1 |
| 9 | DRIVERS_LICENCE | CHARACTER VARYING(10) | 10 |
| 10 | CUSTOMER_TYPE | CHARACTER VARYING(1) | 1 |
| 11 | ORGANISATION_NAME | CHARACTER VARYING(120) | 120 |
| 12 | COMPANY_TYPE | INTEGER | 4 |
| 13 | ABN | CHARACTER VARYING(11) | 11 |
| 14 | DECEASED_IND | CHARACTER VARYING(1) | 1 |
| 15 | OCCUPATION_CODE | INTEGER | 4 |
| 16 | CUSTOMER_PACKAGE | INTEGER | 4 |
| 17 | WEBSITE | CHARACTER VARYING(254) | 254 |
| 18 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 19 | EFFECTIVE_START_TIMESTAMP | TIMESTAMP | 8 |
| 20 | EFFECTIVE_END_TIMESTAMP | TIMESTAMP | 8 |
| 21 | IS_CURRENT_FOR_END_OF_DAY | CHARACTER VARYING(1) | 1 |
| 22 | IS_CURRENT | CHARACTER VARYING(1) | 1 |
| 23 | BUSINESS_END_OF_DAY_DATE | DATE | 4 |