CRS_FCT_ATOCRS_CRS_INDV_DD_QUALIFICATION_PREV

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_CRS_FCT_ATOCRS_CRS_INDV_DD_QUALIFICATION_PREV

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