FCT_ATOCRS_ENTITY_WFT_PREV

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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