CRS_INT_ATOCRS_CRS_INDV_INITIAL_DD_DETAIL_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 PRODUCT_SYSTEM_COMPANY_CODE CHARACTER VARYING(12) 12
4 PRODUCT_SYSTEM_CUSTOMER_NUMBER CHARACTER VARYING(50) 50
5 CUSTOMER_IDENTIFIER CHARACTER VARYING(404) 404
6 FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
7 US_ONLY_INDICIA_FLAG CHARACTER VARYING(1) 1
8 INDICIA_CNTRY_CNT BIGINT 8
9 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(255) 255
10 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(255) 255
11 FOREIGN_INDICIA_START_TIMESTAMP CHARACTER VARYING(200) 200
12 FOREIGN_INDICIA_END_TIMESTAMP CHARACTER VARYING(200) 200
13 MAX_INDICIA_START_TIMESTAMP CHARACTER VARYING(200) 200
14 MAX_COUNTRY_INDICIA_START_TIMESTAMP CHARACTER VARYING(200) 200
15 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(24) 24
16 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(256) 256
17 FATCA_RELATIONSHIP_TYPE CHARACTER VARYING(100) 100
18 FATCA_SELF_CERTIFICATION_FLAG CHARACTER VARYING(50) 50
19 CUSTOMER_THROUGH_FOREIGN_RELATION CHARACTER VARYING(1) 1
20 FOREIGN_RELATION_START_TIMESTAMP CHARACTER VARYING(200) 200
21 FOREIGN_RELATION_END_TIMESTAMP CHARACTER VARYING(200) 200
22 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
23 CRS_PRODUCT_TYPE CHARACTER VARYING(30) 30
24 CRS_PRODUCT_CODE CHARACTER VARYING(10) 10
25 CRS_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
26 DATE_OPEN CHARACTER VARYING(200) 200
27 DATE_CLOSED CHARACTER VARYING(200) 200
28 MATURITY_DATE CHARACTER VARYING(200) 200
29 MIGRATED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
30 MIGRATION_STATUS CHARACTER VARYING(3) 3
31 MIGRATED_DATE CHARACTER VARYING(200) 200
32 MIGRATED_FROM CHARACTER VARYING(3) 3
33 MIGRATED_TO CHARACTER VARYING(3) 3
34 RENEWED_FLAG CHARACTER VARYING(1) 1
35 RENEWED_FROM_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
36 PRE_CRS_CUSTOMER CHARACTER VARYING(1) 1
37 YTD_DATE CHARACTER VARYING(200) 200
38 CRS_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
39 SOURCE_CURRENCY_CODE CHARACTER VARYING(24) 24
40 PRE_CRS_BALANCE NUMERIC(31,8) 19
41 PRE_CRS_BALANCE_AUD NUMERIC(31,8) 19
42 PRE_CRS_BALANCE_USD NUMERIC(31,8) 19
43 OPEN_BALANCE_YTD NUMERIC(31,8) 19
44 OPEN_BALANCE_YTD_AUD NUMERIC(31,8) 19
45 OPEN_BALANCE_YTD_USD NUMERIC(31,8) 19
46 CRS_CLOSED_BALANCE_YTD NUMERIC(31,8) 19
47 CRS_CLOSED_BALANCE_YTD_AUD NUMERIC(31,8) 19
48 CRS_CLOSED_BALANCE_YTD_USD NUMERIC(31,8) 19
49 CURRENT_BALANCE NUMERIC(31,8) 19
50 CURRENT_BALANCE_AUD NUMERIC(31,8) 19
51 CURRENT_BALANCE_USD NUMERIC(31,8) 19
52 CRS_CLOSED_BALANCE NUMERIC(31,8) 19
53 CRS_CLOSED_BALANCE_AUD NUMERIC(31,8) 19
54 CRS_CLOSED_BALANCE_USD NUMERIC(31,8) 19
55 PRE_FATCA_BALANCE NUMERIC(31,8) 19
56 PRE_FATCA_BALANCE_AUD NUMERIC(31,8) 19
57 PRE_FATCA_BALANCE_USD NUMERIC(31,8) 19
58 FATCA_CLOSED_BALANCE_YTD NUMERIC(31,8) 19
59 FATCA_CLOSED_BALANCE_YTD_AUD NUMERIC(31,8) 19
60 FATCA_CLOSED_BALANCE_YTD_USD NUMERIC(31,8) 19
61 FATCA_CLOSED_BALANCE NUMERIC(31,8) 19
62 FATCA_CLOSED_BALANCE_AUD NUMERIC(31,8) 19
63 FATCA_CLOSED_BALANCE_USD NUMERIC(31,8) 19
64 FATCA_IN_SCOPE CHARACTER VARYING(1) 1
65 FATCA_PRODUCT_TYPE CHARACTER VARYING(50) 50
66 PHONE_ONLY_INDICIA CHARACTER VARYING(1) 1
67 DATA_DATE TIMESTAMP 8
68 LOAD_ID INTEGER 4
69 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
70 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
71 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
72 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8