INT_ATOCRS_INDV_ATO_QUALIFICATION_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP02_BANK..INT_ATOCRS_INDV_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 CHARACTER VARYING(100) 100
9 FATCA_SELF_CERTIFICATION_FLAG 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(1) 1
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(1) 1
21 CRS_PRODUCT_TYPE CHARACTER VARYING(30) 30
22 CRS_PRODUCT_CODE CHARACTER VARYING(10) 10
23 CRS_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
24 CRS_REFERENCE_PRODUCT_TYPE CHARACTER VARYING(50) 50
25 CRS_IN_SCOPE CHARACTER VARYING(1) 1
26 FATCA_NEW_DEPOSITORY_CUSTOMER_ACCOUNT_FLAG CHARACTER VARYING(1) 1
27 FATCA_NEW_CUSTODIAL_CUSTOMER_ACCOUNT_FLAG CHARACTER VARYING(1) 1
28 DATE_OPEN TIMESTAMP 8
29 DATE_CLOSED TIMESTAMP 8
30 MATURITY_DATE TIMESTAMP 8
31 MIGRATED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
32 MIGRATION_STATUS CHARACTER VARYING(3) 3
33 MIGRATED_DATE DATE 4
34 MIGRATED_FROM CHARACTER VARYING(3) 3
35 MIGRATED_TO CHARACTER VARYING(3) 3
36 RENEWED_FLAG CHARACTER VARYING(1) 1
37 RENEWED_FROM_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
38 CRS_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
39 SOURCE_CURRENCY_CODE CHARACTER VARYING(24) 24
40 LOAN_ACCOUNT CHARACTER VARYING(1) 1
41 YTD_DATE TIMESTAMP 8
42 PRE_CRS_BALANCE NUMERIC(38,8) 19
43 PRE_CRS_BALANCE_AUD NUMERIC(38,15) 19
44 PRE_CRS_BALANCE_USD NUMERIC(38,23) 19
45 OPEN_BALANCE_YTD NUMERIC(38,8) 19
46 OPEN_BALANCE_YTD_AUD NUMERIC(38,15) 19
47 OPEN_BALANCE_YTD_USD NUMERIC(38,23) 19
48 CRS_CLOSED_BALANCE_YTD NUMERIC(38,8) 19
49 CRS_CLOSED_BALANCE_YTD_AUD NUMERIC(38,15) 19
50 CRS_CLOSED_BALANCE_YTD_USD NUMERIC(38,23) 19
51 CRS_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
52 CRS_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
53 CRS_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
54 PRE_FATCA_BALANCE NUMERIC(28,8) 19
55 PRE_FATCA_BALANCE_AUD NUMERIC(38,15) 19
56 PRE_FATCA_BALANCE_USD NUMERIC(38,23) 19
57 FATCA_CLOSED_BALANCE_YTD NUMERIC(38,8) 19
58 FATCA_CLOSED_BALANCE_YTD_AUD NUMERIC(38,15) 19
59 FATCA_CLOSED_BALANCE_YTD_USD NUMERIC(38,23) 19
60 FATCA_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
61 FATCA_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
62 FATCA_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
63 AGG_PRE_CRS_BALANCE NUMERIC(38,8) 19
64 AGG_PRE_CRS_BALANCE_AUD NUMERIC(38,15) 19
65 AGG_PRE_CRS_BALANCE_USD NUMERIC(38,23) 19
66 AGG_PRE_FATCA_BALANCE NUMERIC(38,8) 19
67 AGG_PRE_FATCA_BALANCE_AUD NUMERIC(38,15) 19
68 AGG_PRE_FATCA_BALANCE_USD NUMERIC(38,23) 19
69 CREDIT_INTEREST_CALENDAR_YTD NUMERIC(38,4) 19
70 CREDIT_INTEREST_CALENDAR_YTD_AUD NUMERIC(38,14) 19
71 CREDIT_INTEREST_CALENDAR_YTD_USD NUMERIC(38,22) 19
72 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
73 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
74 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
75 AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE NUMERIC(38,8) 19
76 AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(38,15) 19
77 AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(38,23) 19
78 FATCA_FLAG CHARACTER VARYING(1) 1
79 CRS_FLAG CHARACTER VARYING(1) 1