FCT_ATOCRS_CRS_INDV_DD_QUALIFICATION_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP02_BANK..FCT_ATOCRS_CRS_INDV_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 TITLE CHARACTER VARYING(120) 120
8 SURNAME CHARACTER VARYING(100) 100
9 MIDDLE_NAME_INITIAL CHARACTER VARYING(101) 101
10 FIRST_NAME CHARACTER VARYING(1014) 1014
11 SUFFIX CHARACTER VARYING(50) 50
12 DECEASED_IND CHARACTER VARYING(3) 3
13 GCIS_PROFILE_STATUS CHARACTER VARYING(8) 8
14 NEW_GCIS_CUSTOMER_NUMBER_1 INTEGER 4
15 NEW_GCIS_CUSTOMER_NUMBER_2 INTEGER 4
16 GCIS_AUDIT_DESCRIPTION CHARACTER VARYING(300) 300
17 MAIL_ADDR_FLAG CHARACTER VARYING(1) 1
18 ADDRESS_LINE_1 CHARACTER VARYING(120) 120
19 ADDRESS_LINE_2 CHARACTER VARYING(120) 120
20 ADDRESS_LINE_3 CHARACTER VARYING(120) 120
21 CITY_TWN_SUBURB CHARACTER VARYING(70) 70
22 STATE CHARACTER VARYING(70) 70
23 POST_CODE CHARACTER VARYING(30) 30
24 COUNTRY CHARACTER VARYING(24) 24
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 PRE_CRS_CUSTOMER CHARACTER VARYING(1) 1
34 INDICIA_CNTRY_CNT BIGINT 8
35 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(255) 255
36 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(255) 255
37 FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
38 US_ONLY_INDICIA_FLAG CHARACTER VARYING(1) 1
39 PHONE_ONLY_INDICIA CHARACTER VARYING(1) 1
40 RMV_PHONE_INDICIA_FLAG CHARACTER VARYING(1) 1
41 FOREIGN_INDICIA_START_TIMESTAMP TIMESTAMP 8
42 FOREIGN_INDICIA_END_TIMESTAMP TIMESTAMP 8
43 CUSTOMER_THROUGH_FOREIGN_RELATION CHARACTER VARYING(1) 1
44 FOREIGN_RELATION_START_TIMESTAMP TIMESTAMP 8
45 FOREIGN_RELATION_END_TIMESTAMP TIMESTAMP 8
46 HAS_CREST_RESPONSE CHARACTER VARYING(2) 2
47 LAST_CUST_CREST_RESPONSE_DATE TIMESTAMP 8
48 FOLLOW_UP_LETTER_FLAG CHARACTER VARYING(1) 1
49 HAS_INDICIA_AFTER_RESPONSE CHARACTER VARYING(2) 2
50 HAS_INDICIA_BEFORE_RESPONSE CHARACTER VARYING(2) 2
51 COUNTRY_INDICIA_AFTER_RESPONSE CHARACTER VARYING(2) 2
52 COUNTRY_INDICIA_BEFORE_RESPONSE CHARACTER VARYING(2) 2
53 LATEST_INDICIA_START_TIMESTAMP TIMESTAMP 8
54 LATEST_COUNTRY_INDICIA_START_TIMESTAMP TIMESTAMP 8
55 POST_CERTIFICATION_COUNTRY_MISMATCH_CUST CHARACTER VARYING(1) 1
56 POST_CERTIFICATION_COUNTRY_MISMATCH CHARACTER VARYING(1) 1
57 POST_CERTIFICATION_INDICIA_UNKNOWN CHARACTER VARYING(1) 1
58 HAS_LEGACY_CERTIFICATION CHARACTER VARYING(1) 1
59 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(24) 24
60 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(256) 256
61 CRS_FATCA_RELATIONSHIP_TYPE CHARACTER VARYING(100) 100
62 CRS_FATCA_SELF_CERTIFICATION_FLAG CHARACTER VARYING(50) 50
63 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
64 CRS_PRODUCT_TYPE CHARACTER VARYING(30) 30
65 CRS_PRODUCT_CODE CHARACTER VARYING(10) 10
66 CRS_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
67 DATE_OPEN TIMESTAMP 8
68 DATE_CLOSED TIMESTAMP 8
69 MATURITY_DATE TIMESTAMP 8
70 MIGRATED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
71 MIGRATION_STATUS CHARACTER VARYING(3) 3
72 MIGRATED_DATE DATE 4
73 MIGRATED_FROM CHARACTER VARYING(3) 3
74 MIGRATED_TO CHARACTER VARYING(3) 3
75 RENEWED_FLAG CHARACTER VARYING(1) 1
76 RENEWED_FROM_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
77 YTD_DATE TIMESTAMP 8
78 CRS_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
79 SOURCE_CURRENCY_CODE CHARACTER VARYING(24) 24
80 PRE_CRS_BALANCE NUMERIC(38,8) 19
81 PRE_CRS_BALANCE_AUD NUMERIC(38,15) 19
82 PRE_CRS_BALANCE_USD NUMERIC(38,23) 19
83 OPEN_BALANCE_YTD NUMERIC(38,8) 19
84 CRS_CLOSED_BALANCE_YTD NUMERIC(38,8) 19
85 OPEN_BALANCE_YTD_AUD NUMERIC(38,15) 19
86 CRS_CLOSED_BALANCE_YTD_AUD NUMERIC(38,15) 19
87 OPEN_BALANCE_YTD_USD NUMERIC(38,23) 19
88 CRS_CLOSED_BALANCE_YTD_USD NUMERIC(38,23) 19
89 CURRENT_BALANCE NUMERIC(38,8) 19
90 CURRENT_BALANCE_AUD NUMERIC(38,15) 19
91 CURRENT_BALANCE_USD NUMERIC(38,23) 19
92 CRS_CLOSED_BALANCE NUMERIC(38,8) 19
93 CRS_CLOSED_BALANCE_AUD NUMERIC(38,15) 19
94 CRS_CLOSED_BALANCE_USD NUMERIC(38,23) 19
95 PRE_FATCA_BALANCE NUMERIC(31,8) 19
96 PRE_FATCA_BALANCE_AUD NUMERIC(38,15) 19
97 PRE_FATCA_BALANCE_USD NUMERIC(38,23) 19
98 FATCA_CLOSED_BALANCE_YTD NUMERIC(38,8) 19
99 FATCA_CLOSED_BALANCE_YTD_AUD NUMERIC(38,15) 19
100 FATCA_CLOSED_BALANCE_YTD_USD NUMERIC(38,23) 19
101 FATCA_CLOSED_BALANCE NUMERIC(38,8) 19
102 FATCA_CLOSED_BALANCE_AUD NUMERIC(38,15) 19
103 FATCA_CLOSED_BALANCE_USD NUMERIC(38,23) 19
104 AGG_ACCT_HOLDER_PRE_CRS_BALANCE NUMERIC(38,8) 19
105 AGG_ACCT_HOLDER_PRE_CRS_BALANCE_AUD NUMERIC(38,15) 19
106 AGG_ACCT_HOLDER_PRE_CRS_BALANCE_USD NUMERIC(38,23) 19
107 AGG_ACCT_HOLDER_CRS_BALANCE_YTD NUMERIC(38,8) 19
108 AGG_ACCT_HOLDER_CRS_BALANCE_YTD_AUD NUMERIC(38,15) 19
109 AGG_ACCT_HOLDER_CRS_BALANCE_YTD_USD NUMERIC(38,23) 19
110 AGG_ACCT_HOLDER_CURRENT_BALANCE NUMERIC(38,8) 19
111 AGG_ACCT_HOLDER_CURRENT_BALANCE_AUD NUMERIC(38,15) 19
112 AGG_ACCT_HOLDER_CURRENT_BALANCE_USD NUMERIC(38,23) 19
113 AGG_ACCT_HOLDER_FATCA_BALANCE_YTD NUMERIC(38,8) 19
114 AGG_ACCT_HOLDER_FATCA_BALANCE_YTD_AUD NUMERIC(38,15) 19
115 AGG_ACCT_HOLDER_FATCA_BALANCE_YTD_USD NUMERIC(38,23) 19
116 AGG_ACCT_HOLDER_PRE_FATCA_BALANCE NUMERIC(38,8) 19
117 AGG_ACCT_HOLDER_PRE_FATCA_BALANCE_AUD NUMERIC(38,15) 19
118 AGG_ACCT_HOLDER_PRE_FATCA_BALANCE_USD NUMERIC(38,23) 19
119 HIGH_VALUE_PRE_CRS_FLG CHARACTER VARYING(1) 1
120 HIGH_VALUE_YTD_FLG CHARACTER VARYING(1) 1
121 PRODUCT_IN_CRS_FATCA_SCOPE CHARACTER VARYING(1) 1
122 CRS_FATCA_PRODUCT_TYPE CHARACTER VARYING(50) 50
123 INTNL_ADDR_CHECK CHARACTER VARYING(21) 21