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