EXT_FCT_ATOCRS_FATCA_ATO_ENTITY_QUALIFICATION_INSIGHT
Description
Source Object (CTAS)
SDSNZP02_BANK..EXT_FCT_ATOCRS_FATCA_ATO_ENTITY_QUALIFICATION
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | REPORTING_YEAR | BIGINT | 8 |
| 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_TYPE | CHARACTER VARYING(20) | 20 |
| 6 | PROFILE_STATUS | CHARACTER VARYING(8) | 8 |
| 7 | NEW_GCIS_CUSTOMER_NUMBER_1 | INTEGER | 4 |
| 8 | NEW_GCIS_CUSTOMER_NUMBER_2 | INTEGER | 4 |
| 9 | GCIS_AUDIT_DESCRIPTION | CHARACTER VARYING(300) | 300 |
| 10 | ENTITY_NAME | CHARACTER VARYING(1014) | 1014 |
| 11 | ADDRESS_LINE_1 | CHARACTER VARYING(120) | 120 |
| 12 | ADDRESS_LINE_2 | CHARACTER VARYING(120) | 120 |
| 13 | ADDRESS_LINE_3 | CHARACTER VARYING(120) | 120 |
| 14 | CITY_TWN_SUBURB | CHARACTER VARYING(70) | 70 |
| 15 | STATE | CHARACTER VARYING(70) | 70 |
| 16 | POST_CODE | CHARACTER VARYING(30) | 30 |
| 17 | COUNTRY | CHARACTER VARYING(24) | 24 |
| 18 | BANK_PRODUCT_HOLDING_NUMBER | CHARACTER VARYING(45) | 45 |
| 19 | CUST_PRDT_RSHIP_TYP_CODE | CHARACTER VARYING(24) | 24 |
| 20 | CUST_PRDT_RSHIP_TYP_DESC | CHARACTER VARYING(256) | 256 |
| 21 | FATCA_RELATIONSHIP_TYPE | CHARACTER VARYING(100) | 100 |
| 22 | FATCA_SELF_CERTIFICATION_FLAG | CHARACTER VARYING(50) | 50 |
| 23 | DERIVED_ROLE_EFF_DATE | CHARACTER VARYING(200) | 200 |
| 24 | DERIVED_ROLE_EXPIRY_DATE | CHARACTER VARYING(200) | 200 |
| 25 | TAX_LIABLE | CHARACTER VARYING(14) | 14 |
| 26 | TAX_LIABLE_COUNTRY | CHARACTER VARYING(255) | 255 |
| 27 | EFFECTIVE_DATE_CREST | CHARACTER VARYING(200) | 200 |
| 28 | CUSTOMER_TYPE_CREST | CHARACTER VARYING(255) | 255 |
| 29 | STATUS | CHARACTER VARYING(255) | 255 |
| 30 | DELETION_FLAG | CHARACTER VARYING(255) | 255 |
| 31 | DELETION_REASON | CHARACTER VARYING(255) | 255 |
| 32 | TIN | CHARACTER VARYING(255) | 255 |
| 33 | GIIN | CHARACTER VARYING(255) | 255 |
| 34 | FATCA_ENTITY_TYPE | CHARACTER VARYING(255) | 255 |
| 35 | FFI_TYPE | CHARACTER VARYING(255) | 255 |
| 36 | BO_CP_TAX_LIABLE | 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 | FATCA_NEW_ACCOUNT_IN_SCOPE_FLAG | CHARACTER VARYING(1) | 1 |
| 43 | DATE_OPEN | CHARACTER VARYING(200) | 200 |
| 44 | DATE_CLOSED | CHARACTER VARYING(200) | 200 |
| 45 | MATURITY_DATE | CHARACTER VARYING(200) | 200 |
| 46 | MIGRATED_ACCOUNT_FLAG | CHARACTER VARYING(1) | 1 |
| 47 | MIGRATION_STATUS | CHARACTER VARYING(3) | 3 |
| 48 | MIGRATED_DATE | CHARACTER VARYING(200) | 200 |
| 49 | MIGRATED_FROM | CHARACTER VARYING(3) | 3 |
| 50 | MIGRATED_TO | CHARACTER VARYING(3) | 3 |
| 51 | RENEWED_FLAG | CHARACTER VARYING(1) | 1 |
| 52 | RENEWED_FROM_PRODUCT_HOLDING_NUMBER | CHARACTER VARYING(45) | 45 |
| 53 | FATCA_YTD_ACCOUNT_STATUS | CHARACTER VARYING(6) | 6 |
| 54 | SOURCE_CURRENCY_CODE | CHARACTER VARYING(24) | 24 |
| 55 | YTD_DATE | CHARACTER VARYING(200) | 200 |
| 56 | PRE_FATCA_BALANCE | NUMERIC(31,8) | 19 |
| 57 | PRE_FATCA_BALANCE_AUD | NUMERIC(31,8) | 19 |
| 58 | PRE_FATCA_BALANCE_USD | NUMERIC(31,8) | 19 |
| 59 | OPEN_BALANCE_YTD | NUMERIC(31,8) | 19 |
| 60 | OPEN_BALANCE_YTD_AUD | NUMERIC(31,8) | 19 |
| 61 | OPEN_BALANCE_YTD_USD | NUMERIC(31,8) | 19 |
| 62 | FATCA_CLOSED_BALANCE_YTD | NUMERIC(31,8) | 19 |
| 63 | FATCA_CLOSED_BALANCE_YTD_AUD | NUMERIC(31,8) | 19 |
| 64 | FATCA_CLOSED_BALANCE_YTD_USD | NUMERIC(31,8) | 19 |
| 65 | FATCA_ATO_REPORTABLE_YTD_BALANCE | NUMERIC(31,8) | 19 |
| 66 | FATCA_ATO_REPORTABLE_YTD_BALANCE_AUD | NUMERIC(31,8) | 19 |
| 67 | FATCA_ATO_REPORTABLE_YTD_BALANCE_USD | NUMERIC(31,8) | 19 |
| 68 | CREDIT_INTEREST_CALENDAR_YTD | NUMERIC(31,8) | 19 |
| 69 | CREDIT_INTEREST_CALENDAR_YTD_AUD | NUMERIC(31,8) | 19 |
| 70 | CREDIT_INTEREST_CALENDAR_YTD_USD | NUMERIC(31,8) | 19 |
| 71 | AGG_PRE_FATCA_BALANCE | NUMERIC(31,8) | 19 |
| 72 | AGG_PRE_FATCA_BALANCE_AUD | NUMERIC(31,8) | 19 |
| 73 | AGG_PRE_FATCA_BALANCE_USD | NUMERIC(31,8) | 19 |
| 74 | AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE | NUMERIC(31,8) | 19 |
| 75 | AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE_AUD | NUMERIC(31,8) | 19 |
| 76 | AGG_FATCA_ATO_REPORTABLE_YTD_BALANCE_USD | NUMERIC(31,8) | 19 |
| 77 | BENOWNER_GCIS_ID | INTEGER | 4 |
| 78 | BENOWNER_TAX_LIABLE_COUNTRY | CHARACTER VARYING(255) | 255 |
| 79 | BOCP_EFFECTIVE_DATE | CHARACTER VARYING(200) | 200 |
| 80 | HIGH_VALUE_YTD_FLG | CHARACTER VARYING(1) | 1 |
| 81 | HIGH_VALUE_PREFATCA_FLG | CHARACTER VARYING(1) | 1 |
| 82 | ATO_ACCOUNT_HOLDER_TYPE | CHARACTER VARYING(28) | 28 |
| 83 | CUST_RESPONSE_FATCA_STATUS | CHARACTER VARYING(255) | 255 |
| 84 | FATCA_ATO_IN_SCOPE | CHARACTER VARYING(1) | 1 |
| 85 | FATCA_FLAG | CHARACTER VARYING(1) | 1 |
| 86 | CRS_FLAG | CHARACTER VARYING(1) | 1 |