CRS_DIM_ATOCRS_CRS_INDV_INITIAL_DD_MAILOUT_EXTRACT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RUN_DATE_TIME CHARACTER VARYING(200) 200
2 GCIS_CUSTOMER_NUMBER INTEGER 4
3 CUSTOMER_TYPE CHARACTER VARYING(20) 20
4 CUSTOMER_NAME_GENERIC CHARACTER VARYING(1387) 1387
5 ADDRESS_LINE_1 CHARACTER VARYING(122) 122
6 ADDRESS_LINE_2 CHARACTER VARYING(122) 122
7 ADDRESS_LINE_3 CHARACTER VARYING(122) 122
8 ADDRESS_CITY CHARACTER VARYING(72) 72
9 ADDRESS_STATE CHARACTER VARYING(72) 72
10 ADDRESS_POST_CODE CHARACTER VARYING(32) 32
11 ADDRESS_COUNTRY CHARACTER VARYING(26) 26
12 RELATIONSHIP_MANAGER_ID CHARACTER VARYING(40) 40
13 RELATIONSHIP_MANAGER_NAME CHARACTER VARYING(255) 255
14 RELATIONSHIP_MANAGER_SOURCE CHARACTER VARYING(4) 4
15 INDV_TITLE CHARACTER VARYING(120) 120
16 INDV_FIRST_NAME CHARACTER VARYING(1014) 1014
17 INDV_MIDDLE_NAME_INITIAL CHARACTER VARYING(101) 101
18 INDV_LAST_NAME CHARACTER VARYING(100) 100
19 INDV_SUFFIX CHARACTER VARYING(50) 50
20 ENTITY_NAME CHARACTER VARYING(1) 1
21 GCIS_PROFILE_STATUS CHARACTER VARYING(8) 8
22 DECEASED_IND CHARACTER VARYING(3) 3
23 CHK_SUNCORP_ENTITY_FLAG CHARACTER VARYING(1) 1
24 FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
25 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(255) 255
26 CUSTOMER_THROUGH_FOREIGN_RELATION CHARACTER VARYING(1) 1
27 AML_BOCP_FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
28 DERIVED_CRS_ENTITY_TYPE CHARACTER VARYING(1) 1
29 DERIVED_FATCA_ENTITY_TYPE CHARACTER VARYING(1) 1
30 DERIVED_FFI_TYPE CHARACTER VARYING(1) 1
31 CURRENT_GIIN CHARACTER VARYING(1) 1
32 EMAIL_ADDRESS CHARACTER VARYING(120) 120
33 MOBILE_NUMBER CHARACTER VARYING(45) 45
34 CUSTOMER_IDENTIFIER CHARACTER VARYING(404) 404
35 DATA_DATE TIMESTAMP 8
36 LOAD_ID INTEGER 4
37 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8