CRS_INT_ATOCRS_CRS_ORG_DD_DETAIL_PREV

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