CRS_FCT_ATOCRS_CRS_ATO_ENTITY_QUALIFICATION_EXTRACT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

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 ENTITY_NAME CHARACTER VARYING(1014) 1014
12 ADDRESS_LINE_1 CHARACTER VARYING(120) 120
13 ADDRESS_LINE_2 CHARACTER VARYING(120) 120
14 ADDRESS_LINE_3 CHARACTER VARYING(120) 120
15 CITY_TWN_SUBURB CHARACTER VARYING(70) 70
16 STATE CHARACTER VARYING(70) 70
17 POST_CODE CHARACTER VARYING(30) 30
18 COUNTRY CHARACTER VARYING(24) 24
19 BANK_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
20 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(24) 24
21 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(256) 256
22 FATCA_RELATIONSHIP_TYPE CHARACTER VARYING(100) 100
23 FATCA_SELF_CERTIFICATION_FLAG CHARACTER VARYING(50) 50
24 DERIVED_ROLE_EFF_DATE TIMESTAMP 8
25 DERIVED_ROLE_EXPIRY_DATE TIMESTAMP 8
26 TAX_LIABLE CHARACTER VARYING(255) 255
27 TAX_LIABLE_COUNTRY CHARACTER VARYING(255) 255
28 EFFECTIVE_DATE_CREST TIMESTAMP 8
29 CUSTOMER_TYPE_CREST CHARACTER VARYING(255) 255
30 STATUS CHARACTER VARYING(255) 255
31 DELETION_FLAG CHARACTER VARYING(255) 255
32 DELETION_REASON CHARACTER VARYING(255) 255
33 TIN CHARACTER VARYING(255) 255
34 GIIN CHARACTER VARYING(255) 255
35 BO_CP_TAX_LIABLE CHARACTER VARYING(255) 255
36 CRS_ENTITY_TYPE CHARACTER VARYING(255) 255
37 CRS_PRODUCT_TYPE CHARACTER VARYING(30) 30
38 CRS_PRODUCT_CODE CHARACTER VARYING(10) 10
39 CRS_PRODUCT_DESCRIPTION CHARACTER VARYING(256) 256
40 CRS_REFERENCE_PRODUCT_TYPE CHARACTER VARYING(50) 50
41 CRS_IN_SCOPE CHARACTER VARYING(1) 1
42 DATE_OPEN TIMESTAMP 8
43 DATE_CLOSED TIMESTAMP 8
44 MATURITY_DATE TIMESTAMP 8
45 MIGRATED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
46 MIGRATION_STATUS CHARACTER VARYING(3) 3
47 MIGRATED_DATE TIMESTAMP 8
48 MIGRATED_FROM CHARACTER VARYING(3) 3
49 MIGRATED_TO CHARACTER VARYING(3) 3
50 RENEWED_FLAG CHARACTER VARYING(1) 1
51 RENEWED_FROM_PRODUCT_HOLDING_NUMBER CHARACTER VARYING(45) 45
52 CRS_YTD_ACCOUNT_STATUS CHARACTER VARYING(6) 6
53 SOURCE_CURRENCY_CODE CHARACTER VARYING(24) 24
54 YTD_DATE TIMESTAMP 8
55 PRE_CRS_BALANCE NUMERIC(31,8) 19
56 PRE_CRS_BALANCE_AUD NUMERIC(31,8) 19
57 PRE_CRS_BALANCE_USD NUMERIC(31,8) 19
58 OPEN_BALANCE_YTD NUMERIC(31,8) 19
59 OPEN_BALANCE_YTD_AUD NUMERIC(31,8) 19
60 OPEN_BALANCE_YTD_USD NUMERIC(31,8) 19
61 CRS_CLOSED_BALANCE_YTD NUMERIC(31,8) 19
62 CRS_CLOSED_BALANCE_YTD_AUD NUMERIC(31,8) 19
63 CRS_CLOSED_BALANCE_YTD_USD NUMERIC(31,8) 19
64 CRS_ATO_REPORTABLE_YTD_BALANCE NUMERIC(31,8) 19
65 CRS_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(31,8) 19
66 CRS_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(31,8) 19
67 CREDIT_INTEREST_CALENDAR_YTD NUMERIC(31,8) 19
68 CREDIT_INTEREST_CALENDAR_YTD_AUD NUMERIC(31,8) 19
69 CREDIT_INTEREST_CALENDAR_YTD_USD NUMERIC(31,8) 19
70 AGG_PRE_CRS_BALANCE NUMERIC(31,8) 19
71 AGG_PRE_CRS_BALANCE_AUD NUMERIC(31,8) 19
72 AGG_PRE_CRS_BALANCE_USD NUMERIC(31,8) 19
73 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE NUMERIC(31,8) 19
74 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_AUD NUMERIC(31,8) 19
75 AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_USD NUMERIC(31,8) 19
76 FATCA_FLAG CHARACTER VARYING(1) 1
77 CRS_FLAG CHARACTER VARYING(1) 1
78 BENOWNER_GCIS_ID INTEGER 4
79 BENOWNER_TAX_LIABLE_COUNTRY CHARACTER VARYING(255) 255
80 BOCP_EFFECTIVE_DATE TIMESTAMP 8
81 DERIVED_CRS_FLAG CHARACTER VARYING(1) 1
82 DATA_DATE TIMESTAMP 8
83 LOAD_ID INTEGER 4
84 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
85 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
86 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
87 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8