FCT_ATOCRS_FATCA_ATO_INDV_QUALIFICATION_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 REPORTING_YEAR BIGINT 8
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_TYPE CHARACTER VARYING(20) 20
6 PROFILE_STATUS CHARACTER VARYING(8) 8
7 NEW_GCIS_CUSTOMER_NUMBER_1 INTEGER 4
8 NEW_GCIS_CUSTOMER_NUMBER_2 INTEGER 4
9 GCIS_AUDIT_DESCRIPTION CHARACTER VARYING(300) 300
10 TITLE CHARACTER VARYING(120) 120
11 SURNAME CHARACTER VARYING(100) 100
12 MIDDLE_NAME_INITIAL CHARACTER VARYING(101) 101
13 FIRST_NAME CHARACTER VARYING(1014) 1014
14 SUFFIX CHARACTER VARYING(50) 50
15 DATE_OF_BIRTH TIMESTAMP 8
16 DECEASED_IND CHARACTER VARYING(3) 3
17 GENDER_CODE CHARACTER VARYING(1) 1
18 ADDRESS_LINE_1 CHARACTER VARYING(120) 120
19 ADDRESS_LINE_2 CHARACTER VARYING(120) 120
20 ADDRESS_LINE_3 CHARACTER VARYING(120) 120
21 CITY_TWN_SUBURB CHARACTER VARYING(70) 70
22 STATE CHARACTER VARYING(70) 70
23 POST_CODE CHARACTER VARYING(30) 30
24 COUNTRY CHARACTER VARYING(24) 24
25 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
26 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(24) 24
27 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(256) 256
28 FATCA_RELATIONSHIP_TYPE CHARACTER VARYING(100) 100
29 FATCA_SELF_CERTIFICATION_FLAG CHARACTER VARYING(50) 50
30 DERIVED_ROLE_EFF_DATE TIMESTAMP 8
31 DERIVED_ROLE_EXPIRY_DATE TIMESTAMP 8
32 TAX_LIABLE CHARACTER VARYING(255) 255
33 TAX_LIABLE_COUNTRY CHARACTER VARYING(255) 255
34 EFFECTIVE_DATE_CREST TIMESTAMP 8
35 CUSTOMER_TYPE_CREST CHARACTER VARYING(1) 1
36 STATUS CHARACTER VARYING(255) 255
37 DELETION_FLAG CHARACTER VARYING(255) 255
38 DELETION_REASON CHARACTER VARYING(255) 255
39 TIN CHARACTER VARYING(255) 255
40 GIIN CHARACTER VARYING(1) 1
41 CRS_PRODUCT_TYPE CHARACTER VARYING(30) 30
42 CRS_PRODUCT_CODE CHARACTER VARYING(10) 10
43 CRS_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
44 CRS_REFERENCE_PRODUCT_TYPE CHARACTER VARYING(50) 50
45 CRS_IN_SCOPE CHARACTER VARYING(1) 1
46 FATCA_NEW_DEPOSITORY_CUSTOMER_ACCOUNT_FLAG CHARACTER VARYING(1) 1
47 FATCA_NEW_CUSTODIAL_CUSTOMER_ACCOUNT_FLAG CHARACTER VARYING(1) 1
48 DATE_OPEN TIMESTAMP 8
49 DATE_CLOSED TIMESTAMP 8
50 MATURITY_DATE TIMESTAMP 8
51 MIGRATED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
52 MIGRATION_STATUS CHARACTER VARYING(3) 3
53 MIGRATED_DATE DATE 4
54 MIGRATED_FROM CHARACTER VARYING(3) 3
55 MIGRATED_TO CHARACTER VARYING(3) 3
56 RENEWED_FLAG CHARACTER VARYING(1) 1
57 RENEWED_FROM_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
58 FATCA_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
59 SOURCE_CURRENCY_CODE CHARACTER VARYING(24) 24
60 YTD_DATE TIMESTAMP 8
61 PRE_FATCA_BALANCE NUMERIC(28,8) 19
62 PRE_FATCA_BALANCE_AUD NUMERIC(38,15) 19
63 PRE_FATCA_BALANCE_USD NUMERIC(38,23) 19
64 OPEN_BALANCE_YTD NUMERIC(38,8) 19
65 OPEN_BALANCE_YTD_AUD NUMERIC(38,15) 19
66 OPEN_BALANCE_YTD_USD NUMERIC(38,23) 19
67 FATCA_CLOSED_BALANCE_YTD NUMERIC(38,8) 19
68 FATCA_CLOSED_BALANCE_YTD_AUD NUMERIC(38,15) 19
69 FATCA_CLOSED_BALANCE_YTD_USD NUMERIC(38,23) 19
70 FATCA_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
71 FATCA_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
72 FATCA_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
73 CREDIT_INTEREST_CALENDAR_YTD NUMERIC(38,4) 19
74 CREDIT_INTEREST_CALENDAR_YTD_AUD NUMERIC(38,14) 19
75 CREDIT_INTEREST_CALENDAR_YTD_USD NUMERIC(38,22) 19
76 AGG_PRE_FATCA_BALANCE NUMERIC(38,8) 19
77 AGG_PRE_FATCA_BALANCE_AUD NUMERIC(38,15) 19
78 AGG_PRE_FATCA_BALANCE_USD NUMERIC(38,23) 19
79 AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
80 AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
81 AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
82 HIGH_VALUE_YTD_FLG CHARACTER VARYING(1) 1
83 HIGH_VALUE_PREFATCA_FLG CHARACTER VARYING(1) 1
84 HIGH_VALUE_NEW_DEPOSITORY_FLAG CHARACTER VARYING(1) 1
85 NEW_CUSTODIAL_FLAG CHARACTER VARYING(1) 1
86 FATCA_FLAG CHARACTER VARYING(1) 1
87 CRS_FLAG CHARACTER VARYING(1) 1