CRS_ENTITY_WFT_REPORT_PREV

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_CRS_ENTITY_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 BDW_PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
55 BDW_PRODUCT_CODE CHARACTER VARYING(30) 30
56 BDW_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
57 ACCOUNT_STATUS CHARACTER VARYING(6) 6
58 DATE_CLOSED TIMESTAMP 8
59 DATE_OPEN TIMESTAMP 8
60 CLOSED_BALANCE_AUD NUMERIC(31,8) 19
61 CLOSED_BALANCE_USD NUMERIC(31,8) 19
62 BALANCE_PRE_FATCA_AUD NUMERIC(31,8) 19
63 BALANCE_PRE_FATCA_USD NUMERIC(31,8) 19
64 OPEN_BALANCE_YTD_AUD NUMERIC(31,8) 19
65 OPEN_BALANCE_YTD_USD NUMERIC(31,8) 19
66 CLOSED_BALANCE_YTD_AUD NUMERIC(31,8) 19
67 CLOSED_BALANCE_YTD_USD NUMERIC(31,8) 19
68 BALANCE_AUD NUMERIC(31,8) 19
69 BALANCE_USD NUMERIC(31,8) 19
70 ATO_REPORTABLE_BALANCE_YTD_AUD NUMERIC(31,8) 19
71 ATO_REPORTABLE_BALANCE_YTD_USD NUMERIC(31,8) 19
72 AGGR_BALANCE_ACCT_HOLDER_USD NUMERIC(31,8) 19
73 AGGR_BALANCE_ALL_RELATIONSHIP_USD NUMERIC(31,8) 19
74 AGGR_BALANCE_PRE_FATCA_ACCT_HOLDER_USD NUMERIC(31,8) 19
75 AGGR_BALANCE_PRE_FATCA_ALL_RELATIONSHIP_USD NUMERIC(31,8) 19
76 AGGR_ATO_BALANCE_YTD_ACCT_HOLDER_USD NUMERIC(31,8) 19
77 AGGR_ATO_BALANCE_YTD_ALL_RELATIONSHIP_USD NUMERIC(31,8) 19
78 US_REPORTABLE_ACCOUNT_FLAG CHARACTER VARYING(9) 9
79 CRM_TAX_LIABLE_STATUS CHARACTER VARYING(40) 40
80 CRM_TAX_LIABLE_COUNTRY CHARACTER VARYING(40) 40
81 CRM_TAX_LIABLE_STATUS_DATE DATE 4
82 GIIN CHARACTER VARYING(40) 40
83 TIN_SSN CHARACTER VARYING(40) 40
84 NFFE_STATUS CHARACTER VARYING(40) 40
85 GCIS_CUSTOMER_FLAG CHARACTER VARYING(1) 1
86 HOG_CUSTOMER_FLAG CHARACTER VARYING(1) 1
87 OPC_CUSTOMER_FLAG CHARACTER VARYING(1) 1
88 PRODUCT_ADDRESS_CUSTOMER_FLAG CHARACTER VARYING(1) 1
89 KYC_CUSTOMER_FLAG CHARACTER VARYING(1) 1
90 BDW_TRC_CUSOTMER_FLAG CHARACTER VARYING(1) 1
91 NEW_CUSTOMER_PRODUCT_FLAG CHARACTER VARYING(1) 1
92 USINDICIA_CHANGE_FLAG CHARACTER VARYING(1) 1
93 MGL_CUSTOMER_FLAG CHARACTER VARYING(1) 1
94 US_INDICIA_FLAG CHARACTER VARYING(1) 1
95 KYC_CLASSIFICATION_TYPE CHARACTER VARYING(100) 100
96 KYC_TRUST_TYPE CHARACTER VARYING(100) 100
97 NEW_ACCOUNT_IN_SCOPE_FLAG CHARACTER VARYING(1) 1
98 ABN CHARACTER VARYING(30) 30
99 ACN_ARBN CHARACTER VARYING(30) 30
100 ANZSIC_TYPE_CODE CHARACTER VARYING(100) 100
101 ANZSIC_TYPE_DESC CHARACTER VARYING(256) 256
102 VEDA_CLASSIFICATION CHARACTER VARYING(7) 7
103 US_OWNER_FLAG CHARACTER VARYING(1) 1
104 INTERNAL_REPORTING_ENTITY_TYPE CHARACTER VARYING(256) 256
105 FINANCIAL_INSTITUTION_FLAG CHARACTER VARYING(1) 1
106 INTERNAL_ATO_REPORTING_TYPE CHARACTER VARYING(23) 23
107 CUST_RESPONSE_FATCA_STATUS CHARACTER VARYING(100) 100
108 CUST_RESPONSE_FATCA_ENTITY_TYPE CHARACTER VARYING(100) 100
109 CUST_RESPONSE_ASSOCIATION_TYPE CHARACTER VARYING(50) 50
110 CUST_RESPONSE_ADDITIONAL_DETAILS CHARACTER VARYING(300) 300
111 ATO_ACCOUNT_HOLDER_TYPE CHARACTER VARYING(100) 100
112 RELATIONSHIP_MANAGER_ID CHARACTER VARYING(40) 40
113 RELATIONSHIP_MANAGER_NAME CHARACTER VARYING(255) 255
114 RELATIONSHIP_MANAGER_SOURCE CHARACTER VARYING(3) 3
115 OCH_CUSTOMER_FLAG CHARACTER VARYING(3) 3
116 CREST_FLAG CHARACTER VARYING(10) 10
117 CRS_DD_IND CHARACTER VARYING(10) 10
118 CUST_GCIS_ID_STATUS CHARACTER VARYING(20) 20
119 CUST_NEW_GCIS_ID CHARACTER VARYING(20) 20
120 DATA_DATE TIMESTAMP 8
121 LOAD_ID INTEGER 4
122 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
123 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
124 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
125 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8