EXT_FCT_ATOCRS_CRS_ORG_DD_QUALIFICATION_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..EXT_FCT_ATOCRS_CRS_ORG_DD_QUALIFICATION

Columns
# Name Data Type Length
1 RUN_DATE_TIME CHARACTER VARYING(200) 200
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_IDENTIFIER CHARACTER VARYING(404) 404
6 CUSTOMER_TYPE CHARACTER VARYING(20) 20
7 ENTITY_NAME CHARACTER VARYING(1014) 1014
8 GCIS_PROFILE_STATUS CHARACTER VARYING(8) 8
9 NEW_GCIS_CUSTOMER_NUMBER_1 INTEGER 4
10 NEW_GCIS_CUSTOMER_NUMBER_2 INTEGER 4
11 GCIS_AUDIT_DESCRIPTION CHARACTER VARYING(300) 300
12 MAIL_ADDR_FLAG CHARACTER VARYING(1) 1
13 ADDRESS_LINE_1 CHARACTER VARYING(120) 120
14 ADDRESS_LINE_2 CHARACTER VARYING(120) 120
15 ADDRESS_LINE_3 CHARACTER VARYING(120) 120
16 CITY_TWN_SUBURB CHARACTER VARYING(70) 70
17 STATE CHARACTER VARYING(70) 70
18 POST_CODE CHARACTER VARYING(30) 30
19 COUNTRY CHARACTER VARYING(24) 24
20 ABN CHARACTER VARYING(30) 30
21 ACN_ARBN CHARACTER VARYING(30) 30
22 ANZSIC_TYPE_CODE CHARACTER VARYING(100) 100
23 ANZSIC_TYPE_DESC CHARACTER VARYING(256) 256
24 CURRENT_GIIN CHARACTER VARYING(255) 255
25 RELATIONSHIP_MANAGER_ID CHARACTER VARYING(40) 40
26 RELATIONSHIP_MANAGER_NAME CHARACTER VARYING(255) 255
27 RELATIONSHIP_MANAGER_SOURCE CHARACTER VARYING(4) 4
28 HOME_NUMBER CHARACTER VARYING(20) 20
29 WORK_NUMBER CHARACTER VARYING(45) 45
30 MOBILE_NUMBER CHARACTER VARYING(45) 45
31 INTERNAL_ENTITY_CRS_CATEGORISATION CHARACTER VARYING(21) 21
32 INTERNAL_ENTITY_FATCA_CATEGORISATION CHARACTER VARYING(23) 23
33 DERIVED_CRS_ENTITY_TYPE CHARACTER VARYING(21) 21
34 DERIVED_FATCA_ENTITY_TYPE CHARACTER VARYING(21) 21
35 DERIVED_FFI_TYPE CHARACTER VARYING(23) 23
36 CHK_SUNCORP_ENTITY_FLAG CHARACTER VARYING(1) 1
37 INDICIA_CNTRY_CNT BIGINT 8
38 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(255) 255
39 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(255) 255
40 FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
41 US_ONLY_INDICIA_FLAG CHARACTER VARYING(1) 1
42 FOREIGN_INDICIA_START_TIMESTAMP CHARACTER VARYING(200) 200
43 FOREIGN_INDICIA_END_TIMESTAMP CHARACTER VARYING(200) 200
44 AML_BOCP_FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
45 CUSTOMER_THROUGH_FOREIGN_RELATION CHARACTER VARYING(1) 1
46 FOREIGN_RELATION_START_TIMESTAMP CHARACTER VARYING(200) 200
47 FOREIGN_RELATION_END_TIMESTAMP CHARACTER VARYING(200) 200
48 HAS_CREST_RESPONSE CHARACTER VARYING(2) 2
49 LAST_CUST_CREST_RESPONSE_DATE CHARACTER VARYING(200) 200
50 CREST_CRS_ENTITY_TYPE CHARACTER VARYING(255) 255
51 FOLLOW_UP_LETTER_FLAG CHARACTER VARYING(1) 1
52 HAS_INDICIA_AFTER_RESPONSE CHARACTER VARYING(2) 2
53 HAS_INDICIA_BEFORE_RESPONSE CHARACTER VARYING(2) 2
54 COUNTRY_INDICIA_AFTER_RESPONSE CHARACTER VARYING(2) 2
55 COUNTRY_INDICIA_BEFORE_RESPONSE CHARACTER VARYING(2) 2
56 LATEST_INDICIA_START_TIMESTAMP CHARACTER VARYING(200) 200
57 LATEST_COUNTRY_INDICIA_START_TIMESTAMP CHARACTER VARYING(200) 200
58 POST_CERTIFICATION_COUNTRY_MISMATCH_CUST CHARACTER VARYING(1) 1
59 POST_CERTIFICATION_COUNTRY_MISMATCH CHARACTER VARYING(1) 1
60 POST_CERTIFICATION_INDICIA_UNKNOWN CHARACTER VARYING(1) 1
61 HAS_LEGACY_CERTIFICATION CHARACTER VARYING(1) 1
62 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(24) 24
63 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(256) 256
64 FATCA_RELATIONSHIP_TYPE_ENTITY CHARACTER VARYING(100) 100
65 FATCA_SELF_CERTIFICATION_FLAG_ENTITY CHARACTER VARYING(50) 50
66 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
67 CRS_PRODUCT_TYPE CHARACTER VARYING(30) 30
68 CRS_PRODUCT_CODE CHARACTER VARYING(10) 10
69 CRS_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
70 DATE_OPEN CHARACTER VARYING(200) 200
71 DATE_CLOSED CHARACTER VARYING(200) 200
72 MATURITY_DATE CHARACTER VARYING(200) 200
73 MIGRATED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
74 MIGRATION_STATUS CHARACTER VARYING(3) 3
75 MIGRATED_DATE CHARACTER VARYING(200) 200
76 MIGRATED_FROM CHARACTER VARYING(3) 3
77 MIGRATED_TO CHARACTER VARYING(3) 3
78 RENEWED_FLAG CHARACTER VARYING(1) 1
79 RENEWED_FROM_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
80 PRE_CRS_CUSTOMER CHARACTER VARYING(1) 1
81 YTD_DATE CHARACTER VARYING(200) 200
82 CRS_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
83 SOURCE_CURRENCY_CODE CHARACTER VARYING(24) 24
84 PRE_CRS_BALANCE NUMERIC(31,8) 19
85 PRE_CRS_BALANCE_AUD NUMERIC(31,8) 19
86 PRE_CRS_BALANCE_USD NUMERIC(31,8) 19
87 OPEN_BALANCE_YTD NUMERIC(31,8) 19
88 CRS_CLOSED_BALANCE_YTD NUMERIC(31,8) 19
89 OPEN_BALANCE_YTD_AUD NUMERIC(31,8) 19
90 CRS_CLOSED_BALANCE_YTD_AUD NUMERIC(31,8) 19
91 OPEN_BALANCE_YTD_USD NUMERIC(31,8) 19
92 CRS_CLOSED_BALANCE_YTD_USD NUMERIC(31,8) 19
93 CURRENT_BALANCE NUMERIC(31,8) 19
94 CURRENT_BALANCE_AUD NUMERIC(31,8) 19
95 CURRENT_BALANCE_USD NUMERIC(31,8) 19
96 CRS_CLOSED_BALANCE NUMERIC(31,8) 19
97 CRS_CLOSED_BALANCE_AUD NUMERIC(31,8) 19
98 CRS_CLOSED_BALANCE_USD NUMERIC(31,8) 19
99 PRE_FATCA_BALANCE NUMERIC(31,8) 19
100 PRE_FATCA_BALANCE_AUD NUMERIC(31,8) 19
101 PRE_FATCA_BALANCE_USD NUMERIC(31,8) 19
102 FATCA_CLOSED_BALANCE_YTD NUMERIC(31,8) 19
103 FATCA_CLOSED_BALANCE_YTD_AUD NUMERIC(31,8) 19
104 FATCA_CLOSED_BALANCE_YTD_USD NUMERIC(31,8) 19
105 FATCA_CLOSED_BALANCE NUMERIC(31,8) 19
106 FATCA_CLOSED_BALANCE_AUD NUMERIC(31,8) 19
107 FATCA_CLOSED_BALANCE_USD NUMERIC(31,8) 19
108 AGG_ACCT_HOLDER_PRE_CRS_BALANCE NUMERIC(31,8) 19
109 AGG_ACCT_HOLDER_PRE_CRS_BALANCE_AUD NUMERIC(31,8) 19
110 AGG_ACCT_HOLDER_PRE_CRS_BALANCE_USD NUMERIC(31,8) 19
111 AGG_ACCT_HOLDER_CRS_BALANCE_YTD NUMERIC(31,8) 19
112 AGG_ACCT_HOLDER_CRS_BALANCE_YTD_AUD NUMERIC(31,8) 19
113 AGG_ACCT_HOLDER_CRS_BALANCE_YTD_USD NUMERIC(31,8) 19
114 AGG_ACCT_HOLDER_CURRENT_BALANCE NUMERIC(31,8) 19
115 AGG_ACCT_HOLDER_CURRENT_BALANCE_AUD NUMERIC(31,8) 19
116 AGG_ACCT_HOLDER_CURRENT_BALANCE_USD NUMERIC(31,8) 19
117 AGG_ACCT_HOLDER_FATCA_BALANCE_YTD NUMERIC(31,8) 19
118 AGG_ACCT_HOLDER_FATCA_BALANCE_YTD_AUD NUMERIC(31,8) 19
119 AGG_ACCT_HOLDER_FATCA_BALANCE_YTD_USD NUMERIC(31,8) 19
120 AGG_ACCT_HOLDER_PRE_FATCA_BALANCE NUMERIC(31,8) 19
121 AGG_ACCT_HOLDER_PRE_FATCA_BALANCE_AUD NUMERIC(31,8) 19
122 AGG_ACCT_HOLDER_PRE_FATCA_BALANCE_USD NUMERIC(31,8) 19
123 HIGH_VALUE_PRE_CRS_FLG CHARACTER VARYING(1) 1
124 HIGH_VALUE_YTD_FLG CHARACTER VARYING(1) 1
125 PRODUCT_IN_CRS_SCOPE CHARACTER VARYING(1) 1
126 FATCA_PRODUCT_TYPE CHARACTER VARYING(50) 50
127 ACTIVE_AU_PHONE_NUMBER_FLAG CHARACTER VARYING(1) 1
128 EMAIL_ADDRESS CHARACTER VARYING(120) 120
129 PHONE_ONLY_INDICIA CHARACTER VARYING(1) 1
130 RMV_PHONE_INDICIA_FLAG CHARACTER VARYING(1) 1
131 INTNL_ADDR_CHECK CHARACTER VARYING(21) 21