FCT_OBP_CL_CS_PH_INSIGHT
Description
OBP Customer Layer CASA Account detils with product offer channel open and close dates channel broker bundle and rates 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 | PRODUCT_SYSTEM_PRODUCT_CODE | CHARACTER VARYING(40) | 40 |
| 5 | SERV_CHRG_CALC_METH_CODE | CHARACTER VARYING(1) | 1 |
| 6 | SERV_CHRG_WAIVER_CODE | CHARACTER VARYING(1) | 1 |
| 7 | SERV_CHRG_CYC_CODE | CHARACTER VARYING(1) | 1 |
| 8 | BANK_CODE | CHARACTER VARYING(10) | 10 |
| 9 | PRODUCT_ID | CHARACTER VARYING(30) | 30 |
| 10 | PRODUCT_DESCRIPTION | CHARACTER VARYING(120) | 120 |
| 11 | OFFER_ID | CHARACTER VARYING(40) | 40 |
| 12 | OFFER_DESCRIPTION | CHARACTER VARYING(120) | 120 |
| 13 | SOURCE_PRODUCT_CODE | CHARACTER VARYING(71) | 71 |
| 14 | BRAND_CODE | CHARACTER VARYING(3) | 3 |
| 15 | BANKING_TYPE | CHARACTER VARYING(6) | 6 |
| 16 | APPLICATION_CHANNEL | CHARACTER VARYING(10) | 10 |
| 17 | PRIMARY_OBP_PARTY_ID | CHARACTER VARYING(40) | 40 |
| 18 | ACCOUNT_TITLE | CHARACTER VARYING(500) | 500 |
| 19 | ACCOUNT_INTEREST_TYPE_FLAG | CHARACTER VARYING(1) | 1 |
| 20 | CREDIT_INT_RATE | DOUBLE PRECISION | 8 |
| 21 | DEBIT_INT_RATE | CHARACTER VARYING(1) | 1 |
| 22 | STMT_FREQUENCY | CHARACTER VARYING(20) | 20 |
| 23 | DEBIT_INTEREST_PAYMENT_CYC_CODE | CHARACTER VARYING(1) | 1 |
| 24 | COST_CENTRE_CODE | CHARACTER VARYING(150) | 150 |
| 25 | ACCOUNT_CREATION_DATE | TIMESTAMP | 8 |
| 26 | ACCOUNT_OPENING_DATE | TIMESTAMP | 8 |
| 27 | ACCOUNT_CLOSURE_DATE | TIMESTAMP | 8 |
| 28 | CURRENCY_ID | CHARACTER VARYING(10) | 10 |
| 29 | STAFF_ACCOUNT_FLAG | CHARACTER(1) | 1 |
| 30 | APPLICATION_CREATED_BY | CHARACTER VARYING(254) | 254 |
| 31 | SERVICE_BRANCH_CODE | CHARACTER VARYING(10) | 10 |
| 32 | BROKER_ID | CHARACTER VARYING(1) | 1 |
| 33 | MOBILE_BANKING_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 34 | INTERNET_BANKING_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 35 | PHONE_BANKING_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 36 | ATM_BANKING_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 37 | ATM_CARD_FLAG | CHARACTER(1) | 1 |
| 38 | POINT_OF_SALE_ALLOWED_FLAG | CHARACTER(1) | 1 |
| 39 | BUNDLE_ID | CHARACTER VARYING(40) | 40 |
| 40 | BUNDLE_NAME | CHARACTER VARYING(40) | 40 |
| 41 | OFFSET_ASSOCIATED_ACCT_NUM | CHARACTER VARYING(1) | 1 |
| 42 | PNDG_OFFSET_DATE | CHARACTER VARYING(1) | 1 |
| 43 | SERVICE_FEE_WAIVE_APPLIED_DATE | CHARACTER VARYING(1) | 1 |
| 44 | SERVICE_FEE_WAIVE_EXPIRY_DATE | CHARACTER VARYING(1) | 1 |
| 45 | WRITE_OFF_AMT | CHARACTER VARYING(1) | 1 |
| 46 | WRITE_OFF_REASON_CODE | CHARACTER VARYING(1) | 1 |
| 47 | BALANCE_POSTING_TYPE_CODE | CHARACTER VARYING(1) | 1 |
| 48 | PROMOTIONAL_BONUS_INTEREST_RATE | CHARACTER VARYING(1) | 1 |
| 49 | PROMOTIONAL_BONUS_START_DATE | CHARACTER VARYING(1) | 1 |
| 50 | PROMOTIONAL_BONUS_END_DATE | CHARACTER VARYING(1) | 1 |
| 51 | ACCOUNT_LAST_UPDATED_TIMESTAMP | TIMESTAMP | 8 |
| 52 | EFFECTIVE_FROM_TIMESTAMP | TIMESTAMP | 8 |
| 53 | EFFECTIVE_TO_TIMESTAMP | TIMESTAMP | 8 |
| 54 | CHANGE_END_OF_DAY_DATE | DATE | 4 |
| 55 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 56 | IS_EOD_RECORD | CHARACTER VARYING(1) | 1 |
| 57 | IS_CURRENT | CHARACTER VARYING(1) | 1 |