CRS_DIM_ATOCRS_CRS_ORG_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(1014) 1014
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(1) 1
16 INDV_FIRST_NAME CHARACTER VARYING(1) 1
17 INDV_MIDDLE_NAME_INITIAL CHARACTER VARYING(1) 1
18 INDV_LAST_NAME CHARACTER VARYING(1) 1
19 INDV_SUFFIX CHARACTER VARYING(1) 1
20 ENTITY_NAME CHARACTER VARYING(1014) 1014
21 GCIS_PROFILE_STATUS CHARACTER VARYING(8) 8
22 DECEASED_IND CHARACTER VARYING(1) 1
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(21) 21
29 DERIVED_FATCA_ENTITY_TYPE CHARACTER VARYING(21) 21
30 DERIVED_FFI_TYPE CHARACTER VARYING(23) 23
31 CURRENT_GIIN CHARACTER VARYING(255) 255
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