FCT_ATOCRS_INDV_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 US_DRIVERS_LICENCE_ISSUING_COUNTRY CHARACTER VARYING(3) 3
57 US_CITIZENSHIP_ENGLISH_ISSUING_COUNTRY CHARACTER VARYING(3) 3
58 US_CITIZENSHIP_NON_ENGLISH_ISSUING_COUNTRY CHARACTER VARYING(3) 3
59 US_PASSPORT_ISSUING_COUNTRY CHARACTER VARYING(3) 3
60 US_BIRTH_CERTIFICATE_ENGLISH_ISSUING_COUNTRY CHARACTER VARYING(3) 3
61 US_BIRTH_CERTIFICATE_NON_ENGLISH_ISSUING_COUNTRY CHARACTER VARYING(3) 3
62 US_INTERNATIONAL_TRAVEL_DOC_ISSUING_COUNTRY CHARACTER VARYING(3) 3
63 US_NATIONAL_IDENTITY_ISSUING_COUNTRY CHARACTER VARYING(3) 3
64 BDW_PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
65 BDW_PRODUCT_CODE CHARACTER VARYING(30) 30
66 BDW_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
67 ACCOUNT_STATUS CHARACTER VARYING(6) 6
68 DATE_CLOSED TIMESTAMP 8
69 DATE_OPEN TIMESTAMP 8
70 CLOSED_BALANCE_AUD NUMERIC(31,8) 19
71 CLOSED_BALANCE_USD NUMERIC(31,8) 19
72 BALANCE_PRE_FATCA_AUD NUMERIC(31,8) 19
73 BALANCE_PRE_FATCA_USD NUMERIC(31,8) 19
74 OPEN_BALANCE_YTD_AUD NUMERIC(31,8) 19
75 OPEN_BALANCE_YTD_USD NUMERIC(31,8) 19
76 CLOSED_BALANCE_YTD_AUD NUMERIC(31,8) 19
77 CLOSED_BALANCE_YTD_USD NUMERIC(31,8) 19
78 BALANCE_AUD NUMERIC(31,8) 19
79 BALANCE_USD NUMERIC(31,8) 19
80 ATO_REPORTABLE_BALANCE_YTD_AUD NUMERIC(31,8) 19
81 ATO_REPORTABLE_BALANCE_YTD_USD NUMERIC(31,8) 19
82 AGGR_BALANCE_ACCT_HOLDER_USD NUMERIC(31,8) 19
83 AGGR_BALANCE_ALL_RELATIONSHIP_USD NUMERIC(31,8) 19
84 AGGR_BALANCE_PRE_FATCA_ACCT_HOLDER_USD NUMERIC(31,8) 19
85 AGGR_BALANCE_PRE_FATCA_ALL_RELATIONSHIP_USD NUMERIC(31,8) 19
86 AGGR_ATO_BALANCE_YTD_ACCT_HOLDER_USD NUMERIC(31,8) 19
87 AGGR_ATO_BALANCE_YTD_ALL_RELATIONSHIP_USD NUMERIC(31,8) 19
88 US_REPORTABLE_ACCOUNT_FLAG CHARACTER VARYING(9) 9
89 CRM_TAX_LIABLE_STATUS CHARACTER VARYING(40) 40
90 CRM_TAX_LIABLE_COUNTRY CHARACTER VARYING(40) 40
91 CRM_TAX_LIABLE_STATUS_DATE DATE 4
92 GIIN CHARACTER VARYING(40) 40
93 TIN_SSN CHARACTER VARYING(40) 40
94 NFFE_STATUS CHARACTER VARYING(40) 40
95 GCIS_CUSTOMER_FLAG CHARACTER VARYING(1) 1
96 HOG_CUSTOMER_FLAG CHARACTER VARYING(1) 1
97 OPC_CUSTOMER_FLAG CHARACTER VARYING(1) 1
98 PRODUCT_ADDRESS_CUSTOMER_FLAG CHARACTER VARYING(1) 1
99 KYC_CUSTOMER_FLAG CHARACTER VARYING(1) 1
100 BDW_TRC_CUSOTMER_FLAG CHARACTER VARYING(1) 1
101 US_RELATIONSHIP_FLAG CHARACTER VARYING(1) 1
102 NEW_CUSTOMER_PRODUCT_FLAG CHARACTER VARYING(1) 1
103 USINDICIA_CHANGE_FLAG CHARACTER VARYING(1) 1
104 MGL_CUSTOMER_FLAG CHARACTER VARYING(1) 1
105 OCH_CUSTOMER_FLAG CHARACTER VARYING(1) 1
106 CREST_FLAG CHARACTER VARYING(10) 10
107 CRS_DD_IND CHARACTER VARYING(10) 10
108 CUST_GCIS_ID_STATUS CHARACTER VARYING(20) 20
109 CUST_NEW_GCIS_ID CHARACTER VARYING(20) 20