FCT_ATOCRS_FATCA_ATO_ENTITY_QUALIFICATION_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_ATOCRS_FATCA_ATO_ENTITY_QUALIFICATION

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