FCT_OBP_CL_TD_PH_INSIGHT
Description
OBP Customer Layer Term Deposit Account and deposit detils with product offer channel open and close dates channel broker rates renewal counter etc
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | SOURCE_SYSTEM_CODE | CHARACTER VARYING(3) | 3 |
| 2 | PRODUCT_HOLDING_NUMBER | CHARACTER VARYING(40) | 40 |
| 3 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 4 | DEPOSIT_NUMBER | DOUBLE PRECISION | 8 |
| 5 | PRODUCT_SYSTEM_PRODUCT_CODE | CHARACTER VARYING(30) | 30 |
| 6 | BANK_CODE | CHARACTER VARYING(10) | 10 |
| 7 | PRODUCT_ID | CHARACTER VARYING(30) | 30 |
| 8 | PRODUCT_DESCRIPTION | CHARACTER VARYING(120) | 120 |
| 9 | OFFER_ID | CHARACTER VARYING(30) | 30 |
| 10 | OFFER_DESCRIPTION | CHARACTER VARYING(120) | 120 |
| 11 | PRINCIPLE_ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 12 | SOURCE_PRODUCT_CODE | CHARACTER VARYING(61) | 61 |
| 13 | BRAND_CODE | CHARACTER VARYING(3) | 3 |
| 14 | BANKING_TYPE | CHARACTER VARYING(6) | 6 |
| 15 | APPLICATION_CHANNEL | CHARACTER VARYING(10) | 10 |
| 16 | APPLICATION_CHANNEL_TYPE | CHARACTER VARYING(10) | 10 |
| 17 | APPLICATION_CHANNEL_DESCRIPTION | CHARACTER VARYING(400) | 400 |
| 18 | ANZSIC_CODE | CHARACTER VARYING(4) | 4 |
| 19 | SUBMISSION_ID | CHARACTER VARYING(50) | 50 |
| 20 | APPLICATION_ID | CHARACTER VARYING(50) | 50 |
| 21 | SUBMISSION_DATE | TIMESTAMP | 8 |
| 22 | PRIMARY_OBP_PARTY_ID | CHARACTER VARYING(40) | 40 |
| 23 | ACCOUNT_TITLE | CHARACTER VARYING(500) | 500 |
| 24 | FV_FLAG | CHARACTER VARYING(1) | 1 |
| 25 | INTEREST_RATE_TYPE | CHARACTER VARYING(5) | 5 |
| 26 | STMT_FREQUENCY | CHARACTER VARYING(40) | 40 |
| 27 | SETTLEMENT_TYPE | CHARACTER VARYING(5) | 5 |
| 28 | INTEREST_PAYOUT_FREQUENCY | CHARACTER VARYING(40) | 40 |
| 29 | COST_CENTRE_CODE | CHARACTER VARYING(150) | 150 |
| 30 | DEPARTMENT | CHARACTER VARYING(240) | 240 |
| 31 | ACCOUNT_CREATION_DATE | TIMESTAMP | 8 |
| 32 | ACCOUNT_OPENING_DATE | TIMESTAMP | 8 |
| 33 | ACCOUNT_CLOSURE_DATE | TIMESTAMP | 8 |
| 34 | DEPOSIT_TERM_MNTHS | DOUBLE PRECISION | 8 |
| 35 | DEPOSIT_OPENING_DATE | TIMESTAMP | 8 |
| 36 | DEPOSIT_CLOSURE_DATE | TIMESTAMP | 8 |
| 37 | DEPOSIT_MATURITY_DATE | TIMESTAMP | 8 |
| 38 | DEPOSIT_PRINCIPLE_AMOUNT | DOUBLE PRECISION | 8 |
| 39 | CURRENCY_ID | CHARACTER VARYING(3) | 3 |
| 40 | PARENT_DEPOSIT_ID | DOUBLE PRECISION | 8 |
| 41 | RENEWAL_COUNTER | DOUBLE PRECISION | 8 |
| 42 | ACCOUNT_STATUS_CODE | CHARACTER VARYING(40) | 40 |
| 43 | DEPOSIT_STATUS_CODE | CHARACTER VARYING(40) | 40 |
| 44 | APPLICATION_BRANCH_CODE | CHARACTER VARYING(10) | 10 |
| 45 | APPLICATION_BRANCH_NAME | CHARACTER VARYING(105) | 105 |
| 46 | STAFF_ACCOUNT_FLAG | CHARACTER(1) | 1 |
| 47 | APPLICATION_CREATED_BY | CHARACTER VARYING(254) | 254 |
| 48 | SERVICE_BRANCH_CODE | CHARACTER VARYING(10) | 10 |
| 49 | BROKER_ID | CHARACTER VARYING(1) | 1 |
| 50 | MOBILE_BANKING_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 51 | INTERNET_BANKING_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 52 | PHONE_BANKING_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 53 | BRANCH_BANKING_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 54 | ATM_BANKING_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 55 | BUNDLE_REFERENCE_ID | CHARACTER VARYING(40) | 40 |
| 56 | BUNDLE_NAME | CHARACTER VARYING(40) | 40 |
| 57 | INTEREST_WITHHELD_FLAG | CHARACTER VARYING(1) | 1 |
| 58 | CURRENT_INTEREST_RATE | DOUBLE PRECISION | 8 |
| 59 | EFFECTIVE_FROM_TIMESTAMP | TIMESTAMP | 8 |
| 60 | EFFECTIVE_TO_TIMESTAMP | TIMESTAMP | 8 |
| 61 | CHANGE_END_OF_DAY_DATE | DATE | 4 |
| 62 | IS_EOD_RECORD | CHARACTER VARYING(1) | 1 |
| 63 | IS_CURRENT | CHARACTER VARYING(1) | 1 |
| 64 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 65 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |