EXT_FCT_ATOCRS_CRS_ATO_INDV_QUALIFICATION_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..EXT_FCT_ATOCRS_CRS_ATO_INDV_QUALIFICATION

Columns
# Name Data Type Length
1 RUN_YEAR BIGINT 8
2 REPORTING_YEAR BIGINT 8
3 GCIS_CUSTOMER_NUMBER INTEGER 4
4 PRODUCT_SYSTEM_COMPANY_CODE CHARACTER VARYING(12) 12
5 PRODUCT_SYSTEM_CUSTOMER_NUMBER CHARACTER VARYING(50) 50
6 CUSTOMER_TYPE CHARACTER VARYING(20) 20
7 PROFILE_STATUS CHARACTER VARYING(8) 8
8 NEW_GCIS_CUSTOMER_NUMBER_1 INTEGER 4
9 NEW_GCIS_CUSTOMER_NUMBER_2 INTEGER 4
10 GCIS_AUDIT_DESCRIPTION CHARACTER VARYING(300) 300
11 TITLE CHARACTER VARYING(120) 120
12 SURNAME CHARACTER VARYING(100) 100
13 MIDDLE_NAME_INITIAL CHARACTER VARYING(101) 101
14 FIRST_NAME CHARACTER VARYING(1014) 1014
15 SUFFIX CHARACTER VARYING(50) 50
16 DATE_OF_BIRTH CHARACTER VARYING(200) 200
17 DECEASED_IND CHARACTER VARYING(3) 3
18 GENDER_CODE CHARACTER VARYING(1) 1
19 ADDRESS_LINE_1 CHARACTER VARYING(120) 120
20 ADDRESS_LINE_2 CHARACTER VARYING(120) 120
21 ADDRESS_LINE_3 CHARACTER VARYING(120) 120
22 CITY_TWN_SUBURB CHARACTER VARYING(70) 70
23 STATE CHARACTER VARYING(70) 70
24 POST_CODE CHARACTER VARYING(30) 30
25 COUNTRY CHARACTER VARYING(24) 24
26 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
27 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(24) 24
28 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(256) 256
29 FATCA_RELATIONSHIP_TYPE CHARACTER VARYING(100) 100
30 FATCA_SELF_CERTIFICATION_FLAG CHARACTER VARYING(50) 50
31 DERIVED_ROLE_EFF_DATE CHARACTER VARYING(200) 200
32 DERIVED_ROLE_EXPIRY_DATE CHARACTER VARYING(200) 200
33 TAX_LIABLE CHARACTER VARYING(255) 255
34 TAX_LIABLE_COUNTRY CHARACTER VARYING(255) 255
35 EFFECTIVE_DATE_CREST CHARACTER VARYING(200) 200
36 CUSTOMER_TYPE_CREST CHARACTER VARYING(1) 1
37 STATUS CHARACTER VARYING(255) 255
38 DELETION_FLAG CHARACTER VARYING(255) 255
39 DELETION_REASON CHARACTER VARYING(255) 255
40 TIN CHARACTER VARYING(255) 255
41 GIIN CHARACTER VARYING(1) 1
42 CRS_PRODUCT_TYPE CHARACTER VARYING(30) 30
43 CRS_PRODUCT_CODE CHARACTER VARYING(10) 10
44 CRS_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
45 CRS_REFERENCE_PRODUCT_TYPE CHARACTER VARYING(50) 50
46 CRS_IN_SCOPE CHARACTER VARYING(1) 1
47 FATCA_NEW_DEPOSITORY_CUSTOMER_ACCOUNT_FLAG CHARACTER VARYING(1) 1
48 FATCA_NEW_CUSTODIAL_CUSTOMER_ACCOUNT_FLAG CHARACTER VARYING(1) 1
49 DATE_OPEN CHARACTER VARYING(200) 200
50 DATE_CLOSED CHARACTER VARYING(200) 200
51 MATURITY_DATE CHARACTER VARYING(200) 200
52 MIGRATED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
53 MIGRATION_STATUS CHARACTER VARYING(3) 3
54 MIGRATED_DATE CHARACTER VARYING(200) 200
55 MIGRATED_FROM CHARACTER VARYING(3) 3
56 MIGRATED_TO CHARACTER VARYING(3) 3
57 RENEWED_FLAG CHARACTER VARYING(1) 1
58 RENEWED_FROM_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
59 CRS_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
60 SOURCE_CURRENCY_CODE CHARACTER VARYING(24) 24
61 YTD_DATE CHARACTER VARYING(200) 200
62 PRE_CRS_BALANCE NUMERIC(31,8) 19
63 PRE_CRS_BALANCE_AUD NUMERIC(31,8) 19
64 PRE_CRS_BALANCE_USD NUMERIC(31,8) 19
65 OPEN_BALANCE_YTD NUMERIC(31,8) 19
66 OPEN_BALANCE_YTD_AUD NUMERIC(31,8) 19
67 OPEN_BALANCE_YTD_USD NUMERIC(31,8) 19
68 CRS_CLOSED_BALANCE_YTD NUMERIC(31,8) 19
69 CRS_CLOSED_BALANCE_YTD_AUD NUMERIC(31,8) 19
70 CRS_CLOSED_BALANCE_YTD_USD NUMERIC(31,8) 19
71 CRS_ATO_REPORTABLE_YTD_BALANCE NUMERIC(31,8) 19
72 CRS_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(31,8) 19
73 CRS_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(31,8) 19
74 CREDIT_INTEREST_CALENDAR_YTD NUMERIC(31,8) 19
75 CREDIT_INTEREST_CALENDAR_YTD_AUD NUMERIC(31,8) 19
76 CREDIT_INTEREST_CALENDAR_YTD_USD NUMERIC(31,8) 19
77 AGG_PRE_CRS_BALANCE NUMERIC(31,8) 19
78 AGG_PRE_CRS_BALANCE_AUD NUMERIC(31,8) 19
79 AGG_PRE_CRS_BALANCE_USD NUMERIC(31,8) 19
80 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE NUMERIC(31,8) 19
81 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(31,8) 19
82 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(31,8) 19
83 FATCA_FLAG CHARACTER VARYING(1) 1
84 CRS_FLAG CHARACTER VARYING(1) 1