CRS_INDV_WFT_REPORT_PREV

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_CRS_INDV_WFT_REPORT_PREV

Columns
# Name Data Type Length
1 EXTRACT_DATE TIMESTAMP 8
2 CUSTOMER_IDENTIFIER CHARACTER VARYING(50) 50
3 US_TAX_LIABLE_STATUS CHARACTER VARYING(9) 9
4 CUSTOMER_TYPE CHARACTER VARYING(20) 20
5 ENTITY_NAME CHARACTER VARYING(1014) 1014
6 TITLE CHARACTER VARYING(120) 120
7 SURNAME CHARACTER VARYING(100) 100
8 MIDDLE_NAME_INITIAL CHARACTER VARYING(101) 101
9 FIRST_NAME CHARACTER VARYING(1014) 1014
10 SUFFIX CHARACTER VARYING(50) 50
11 DATE_OF_BIRTH TIMESTAMP 8
12 DECEASED_IND CHARACTER VARYING(3) 3
13 RESIDENTIAL_ADDRESS_LINE_1 CHARACTER VARYING(120) 120
14 RESIDENTIAL_ADDRESS_LINE_2 CHARACTER VARYING(120) 120
15 RESIDENTIAL_ADDRESS_LINE_3 CHARACTER VARYING(120) 120
16 RESIDENTIAL_UNIT_STRT_NUMBER CHARACTER VARYING(241) 241
17 RESIDENTIAL_STREET_NAME CHARACTER VARYING(241) 241
18 RESIDENTIAL_CITY_TWN_SUBURB CHARACTER VARYING(50) 50
19 RESIDENTIAL_STATE CHARACTER VARYING(50) 50
20 RESIDENTIAL_POST_CODE CHARACTER VARYING(30) 30
21 RESIDENTIAL_COUNTRY CHARACTER VARYING(24) 24
22 MAIL_ADDRESS_LINE_1 CHARACTER VARYING(120) 120
23 MAIL_ADDRESS_LINE_2 CHARACTER VARYING(120) 120
24 MAIL_ADDRESS_LINE_3 CHARACTER VARYING(120) 120
25 MAIL_PO_BOX CHARACTER VARYING(120) 120
26 MAIL_UNIT_STREET_NUMBER CHARACTER VARYING(241) 241
27 MAIL_STREET_NAME CHARACTER VARYING(241) 241
28 MAIL_CITY_TWN_SUBURB CHARACTER VARYING(70) 70
29 MAIL_STATE CHARACTER VARYING(70) 70
30 MAIL_POST_CODE CHARACTER VARYING(30) 30
31 MAIL_COUNTRY CHARACTER VARYING(24) 24
32 EMAIL_ADDRESS CHARACTER VARYING(120) 120
33 HOME_NUMBER CHARACTER VARYING(20) 20
34 WORK_NUMBER CHARACTER VARYING(45) 45
35 MOBILE_NUMBER CHARACTER VARYING(45) 45
36 TREASURY_COUNTERPARTY_TYPE_DESC CHARACTER VARYING(16) 16
37 CORPORATE_TYPE CHARACTER VARYING(15) 15
38 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
39 CUST_PRODUCT_REL_TYPE_DESCIRPTION CHARACTER VARYING(256) 256
40 PRODUCT_SYSTEM_COMPANY_CODE CHARACTER VARYING(12) 12
41 PRODUCT_GROUP_CODE CHARACTER VARYING(20) 20
42 PRODUCT_TYPE_CODE CHARACTER VARYING(22) 22
43 PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
44 ACCOUNT_ADDRESS_LINE_1 CHARACTER VARYING(50) 50
45 ACCOUNT_ADDRESS_LINE_2 CHARACTER VARYING(50) 50
46 ACCOUNT_ADDRESS_LINE_3 CHARACTER VARYING(50) 50
47 ACCOUNT_ADDRESS_LINE_4 CHARACTER VARYING(50) 50
48 ACCOUNT_MAIL_UNIT_STREET_NUMBER CHARACTER VARYING(203) 203
49 ACCOUNT_MAIL_STREET_NAME CHARACTER VARYING(150) 150
50 ACCOUNT_MAIL_CITY_TWN_SUBURB CHARACTER VARYING(50) 50
51 ACCOUNT_MAIL_STATE CHARACTER VARYING(50) 50
52 ACCOUNT_MAIL_POST_CODE CHARACTER VARYING(10) 10
53 ACCOUNT_MAIL_COUNTRY CHARACTER VARYING(100) 100
54 US_DRIVERS_LICENCE_ISSUING_COUNTRY CHARACTER VARYING(3) 3
55 US_CITIZENSHIP_ENGLISH_ISSUING_COUNTRY CHARACTER VARYING(3) 3
56 US_CITIZENSHIP_NON_ENGLISH_ISSUING_COUNTRY CHARACTER VARYING(3) 3
57 US_PASSPORT_ISSUING_COUNTRY CHARACTER VARYING(3) 3
58 US_BIRTH_CERTIFICATE_ENGLISH_ISSUING_COUNTRY CHARACTER VARYING(3) 3
59 US_BIRTH_CERTIFICATE_NON_ENGLISH_ISSUING_COUNTRY CHARACTER VARYING(3) 3
60 US_INTERNATIONAL_TRAVEL_DOC_ISSUING_COUNTRY CHARACTER VARYING(3) 3
61 US_NATIONAL_IDENTITY_ISSUING_COUNTRY CHARACTER VARYING(3) 3
62 BDW_PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
63 BDW_PRODUCT_CODE CHARACTER VARYING(30) 30
64 BDW_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
65 ACCOUNT_STATUS CHARACTER VARYING(6) 6
66 DATE_CLOSED TIMESTAMP 8
67 DATE_OPEN TIMESTAMP 8
68 CLOSED_BALANCE_AUD NUMERIC(31,8) 19
69 CLOSED_BALANCE_USD NUMERIC(31,8) 19
70 BALANCE_PRE_FATCA_AUD NUMERIC(31,8) 19
71 BALANCE_PRE_FATCA_USD NUMERIC(31,8) 19
72 OPEN_BALANCE_YTD_AUD NUMERIC(31,8) 19
73 OPEN_BALANCE_YTD_USD NUMERIC(31,8) 19
74 CLOSED_BALANCE_YTD_AUD NUMERIC(31,8) 19
75 CLOSED_BALANCE_YTD_USD NUMERIC(31,8) 19
76 BALANCE_AUD NUMERIC(31,8) 19
77 BALANCE_USD NUMERIC(31,8) 19
78 ATO_REPORTABLE_BALANCE_YTD_AUD NUMERIC(31,8) 19
79 ATO_REPORTABLE_BALANCE_YTD_USD NUMERIC(31,8) 19
80 AGGR_BALANCE_ACCT_HOLDER_USD NUMERIC(31,8) 19
81 AGGR_BALANCE_ALL_RELATIONSHIP_USD NUMERIC(31,8) 19
82 AGGR_BALANCE_PRE_FATCA_ACCT_HOLDER_USD NUMERIC(31,8) 19
83 AGGR_BALANCE_PRE_FATCA_ALL_RELATIONSHIP_USD NUMERIC(31,8) 19
84 AGGR_ATO_BALANCE_YTD_ACCT_HOLDER_USD NUMERIC(31,8) 19
85 AGGR_ATO_BALANCE_YTD_ALL_RELATIONSHIP_USD NUMERIC(31,8) 19
86 US_REPORTABLE_ACCOUNT_FLAG CHARACTER VARYING(9) 9
87 CRM_TAX_LIABLE_STATUS CHARACTER VARYING(40) 40
88 CRM_TAX_LIABLE_COUNTRY CHARACTER VARYING(40) 40
89 CRM_TAX_LIABLE_STATUS_DATE DATE 4
90 GIIN CHARACTER VARYING(40) 40
91 TIN_SSN CHARACTER VARYING(40) 40
92 NFFE_STATUS CHARACTER VARYING(40) 40
93 GCIS_CUSTOMER_FLAG CHARACTER VARYING(1) 1
94 HOG_CUSTOMER_FLAG CHARACTER VARYING(1) 1
95 OPC_CUSTOMER_FLAG CHARACTER VARYING(1) 1
96 PRODUCT_ADDRESS_CUSTOMER_FLAG CHARACTER VARYING(1) 1
97 KYC_CUSTOMER_FLAG CHARACTER VARYING(1) 1
98 BDW_TRC_CUSOTMER_FLAG CHARACTER VARYING(1) 1
99 US_RELATIONSHIP_FLAG CHARACTER VARYING(1) 1
100 NEW_CUSTOMER_PRODUCT_FLAG CHARACTER VARYING(1) 1
101 USINDICIA_CHANGE_FLAG CHARACTER VARYING(1) 1
102 MGL_CUSTOMER_FLAG CHARACTER VARYING(1) 1
103 OCH_CUSTOMER_FLAG CHARACTER VARYING(1) 1
104 CREST_FLAG CHARACTER VARYING(10) 10
105 CRS_DD_IND CHARACTER VARYING(10) 10
106 CUST_GCIS_ID_STATUS CHARACTER VARYING(20) 20
107 CUST_NEW_GCIS_ID CHARACTER VARYING(20) 20
108 DATA_DATE TIMESTAMP 8
109 LOAD_ID INTEGER 4
110 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
111 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
112 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
113 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8