INT_ATOCRS_ENTITY_ATO_QUALIFICATION_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP02_BANK..INT_ATOCRS_ENTITY_ATO_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 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
6 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(24) 24
7 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(256) 256
8 FATCA_RELATIONSHIP_TYPE_ENTITY CHARACTER VARYING(100) 100
9 FATCA_SELF_CERTIFICATION_FLAG_ENTITY CHARACTER VARYING(50) 50
10 DERIVED_ROLE_EFF_DATE TIMESTAMP 8
11 DERIVED_ROLE_EXPIRY_DATE TIMESTAMP 8
12 TAX_LIABLE CHARACTER VARYING(255) 255
13 TAX_LIABLE_COUNTRY CHARACTER VARYING(255) 255
14 EFFECTIVE_DATE_CREST TIMESTAMP 8
15 CUSTOMER_TYPE_CREST CHARACTER VARYING(255) 255
16 STATUS CHARACTER VARYING(255) 255
17 DELETION_FLAG CHARACTER VARYING(255) 255
18 DELETION_REASON CHARACTER VARYING(255) 255
19 TIN CHARACTER VARYING(255) 255
20 GIIN CHARACTER VARYING(255) 255
21 BO_CP_TAX_LIABLE CHARACTER VARYING(255) 255
22 CRS_ENTITY_TYPE CHARACTER VARYING(255) 255
23 FATCA_ENTITY_TYPE CHARACTER VARYING(255) 255
24 FFI_TYPE CHARACTER VARYING(255) 255
25 BENOWNER_GCIS_ID INTEGER 4
26 BENOWNER_TAX_LIABLE_COUNTRY CHARACTER VARYING(255) 255
27 BOCP_EFFECTIVE_DATE TIMESTAMP 8
28 CRS_PRODUCT_TYPE CHARACTER VARYING(30) 30
29 CRS_PRODUCT_CODE CHARACTER VARYING(10) 10
30 CRS_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
31 CRS_REFERENCE_PRODUCT_TYPE CHARACTER VARYING(50) 50
32 CRS_IN_SCOPE CHARACTER VARYING(1) 1
33 FATCA_NEW_ACCOUNT_IN_SCOPE_FLAG CHARACTER VARYING(1) 1
34 DATE_OPEN TIMESTAMP 8
35 DATE_CLOSED TIMESTAMP 8
36 MATURITY_DATE TIMESTAMP 8
37 MIGRATED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
38 MIGRATION_STATUS CHARACTER VARYING(3) 3
39 MIGRATED_DATE DATE 4
40 MIGRATED_FROM CHARACTER VARYING(3) 3
41 MIGRATED_TO CHARACTER VARYING(3) 3
42 RENEWED_FLAG CHARACTER VARYING(1) 1
43 RENEWED_FROM_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
44 CRS_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
45 FATCA_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
46 SOURCE_CURRENCY_CODE CHARACTER VARYING(24) 24
47 LOAN_ACCOUNT CHARACTER VARYING(1) 1
48 YTD_DATE TIMESTAMP 8
49 PRE_CRS_BALANCE NUMERIC(38,8) 19
50 PRE_CRS_BALANCE_AUD NUMERIC(38,15) 19
51 PRE_CRS_BALANCE_USD NUMERIC(38,23) 19
52 OPEN_BALANCE_YTD NUMERIC(38,8) 19
53 OPEN_BALANCE_YTD_AUD NUMERIC(38,15) 19
54 OPEN_BALANCE_YTD_USD NUMERIC(38,23) 19
55 CRS_CLOSED_BALANCE_YTD NUMERIC(38,8) 19
56 CRS_CLOSED_BALANCE_YTD_AUD NUMERIC(38,15) 19
57 CRS_CLOSED_BALANCE_YTD_USD NUMERIC(38,23) 19
58 CRS_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
59 CRS_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
60 CRS_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
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 FATCA_CLOSED_BALANCE_YTD NUMERIC(38,8) 19
65 FATCA_CLOSED_BALANCE_YTD_AUD NUMERIC(38,15) 19
66 FATCA_CLOSED_BALANCE_YTD_USD NUMERIC(38,23) 19
67 FATCA_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
68 FATCA_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
69 FATCA_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
70 AGG_PRE_CRS_BALANCE NUMERIC(38,8) 19
71 AGG_PRE_CRS_BALANCE_AUD NUMERIC(38,15) 19
72 AGG_PRE_CRS_BALANCE_USD NUMERIC(38,23) 19
73 AGG_PRE_FATCA_BALANCE NUMERIC(38,8) 19
74 AGG_PRE_FATCA_BALANCE_AUD NUMERIC(38,15) 19
75 AGG_PRE_FATCA_BALANCE_USD NUMERIC(38,23) 19
76 CREDIT_INTEREST_CALENDAR_YTD NUMERIC(38,4) 19
77 CREDIT_INTEREST_CALENDAR_YTD_AUD NUMERIC(38,14) 19
78 CREDIT_INTEREST_CALENDAR_YTD_USD NUMERIC(38,22) 19
79 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
80 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
81 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
82 AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
83 AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
84 AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
85 FATCA_FLAG CHARACTER VARYING(1) 1
86 CRS_FLAG CHARACTER VARYING(1) 1