FCT_ATOCRS_CRS_ORG_DD_QUALIFICATION_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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