FCT_BNK_QRM_DAILY_MASTER_CS_INSIGHT
Description
OBP extract with select CASA Deposit details consumed by QRM
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACTION_CODE | CHARACTER VARYING(1) | 1 |
| 2 | KEY_COID | CHARACTER VARYING(10) | 10 |
| 3 | KEY_PROD | CHARACTER VARYING(30) | 30 |
| 4 | KEY_ACCT | CHARACTER VARYING(40) | 40 |
| 5 | ACCT_STATUS | CHARACTER VARYING(20) | 20 |
| 6 | APPROVAL_OFF_CD | CHARACTER VARYING(1) | 1 |
| 7 | BRANCH_NO | CHARACTER VARYING(10) | 10 |
| 8 | BROKER_CD | CHARACTER VARYING(1) | 1 |
| 9 | COST_CENTER | CHARACTER VARYING(150) | 150 |
| 10 | CURR_BAL | DOUBLE PRECISION | 8 |
| 11 | DATE_IN_EXCESS | CHARACTER VARYING(200) | 200 |
| 12 | DB_AMT_INT_ACC_CTD | DOUBLE PRECISION | 8 |
| 13 | DT_CLOSED | CHARACTER VARYING(200) | 200 |
| 14 | DT_OPENED | CHARACTER VARYING(200) | 200 |
| 15 | INTEREST_RATE_DEBIT | INTEGER | 4 |
| 16 | LAST_CUST_DEP_DATE | CHARACTER VARYING(200) | 200 |
| 17 | OD_APPL_BRANCH | CHARACTER VARYING(1) | 1 |
| 18 | OD_DOC_TYPE | CHARACTER VARYING(1) | 1 |
| 19 | OD_LIMIT | CHARACTER VARYING(1) | 1 |
| 20 | OD_REVIEW_DATE | CHARACTER VARYING(1) | 1 |
| 21 | OD_START_DATE | CHARACTER VARYING(1) | 1 |
| 22 | OFFICER | CHARACTER VARYING(40) | 40 |
| 23 | ORIGINAL_BRANCH | CHARACTER VARYING(10) | 10 |
| 24 | SALE_OFF_CD | CHARACTER VARYING(254) | 254 |
| 25 | SECONDARY_OFFICER | CHARACTER VARYING(1) | 1 |
| 26 | SHORT_NAME | CHARACTER VARYING(100) | 100 |
| 27 | SIC_OCCUPATION_CD | CHARACTER VARYING(5) | 5 |
| 28 | SUB_PRDCT_CD | CHARACTER VARYING(40) | 40 |
| 29 | OF_PRODUCT_CODE | CHARACTER VARYING(150) | 150 |
| 30 | TEMP_OD_EXPIRY_DATE | CHARACTER VARYING(200) | 200 |
| 31 | TEMP_OD_LIMIT | DOUBLE PRECISION | 8 |
| 32 | WRITE_OFF_CODE | CHARACTER VARYING(1) | 1 |
| 33 | WRITE_OFF_DATE | CHARACTER VARYING(1) | 1 |
| 34 | BALANCE_BEFORE_CLOSING | DOUBLE PRECISION | 8 |
| 35 | SECURITISATION_STATUS_CODE | CHARACTER VARYING(1) | 1 |
| 36 | SECURITISATION_POOL_ID | CHARACTER VARYING(1) | 1 |
| 37 | SECURITISATION_START_DATE | CHARACTER VARYING(1) | 1 |
| 38 | REPURCHASE_REASON_CODE | CHARACTER VARYING(1) | 1 |
| 39 | REPURCHASE_DATE | CHARACTER VARYING(1) | 1 |
| 40 | DAYS_PAST_DUE | CHARACTER VARYING(1) | 1 |
| 41 | PAST_DUE_AMT | CHARACTER VARYING(1) | 1 |
| 42 | INS_EXPIRY_DTE | CHARACTER VARYING(1) | 1 |
| 43 | INS_TYPE_CDE | CHARACTER VARYING(1) | 1 |
| 44 | INS_COMPANY_CODE | CHARACTER VARYING(1) | 1 |
| 45 | OD_INSURED_IND | CHARACTER VARYING(1) | 1 |
| 46 | INTEREST_RATE_CREDIT | DOUBLE PRECISION | 8 |
| 47 | MORTGAGE_OFFSET_ACCOUNT | CHARACTER VARYING(1) | 1 |
| 48 | INT_PAY_CYCLE_CD | CHARACTER VARYING(40) | 40 |
| 49 | DB_INT_PAY_CYCLE_CD | CHARACTER VARYING(1) | 1 |
| 50 | AGG_PLUS_BAL_MTD | DOUBLE PRECISION | 8 |
| 51 | AGG_PLUS_DAYS_MTD | BIGINT | 8 |
| 52 | AGG_OD_BAL_MTD | CHARACTER VARYING(1) | 1 |
| 53 | AGG_OD_DAYS_MTD | CHARACTER VARYING(1) | 1 |
| 54 | START_DATE | CHARACTER VARYING(1) | 1 |
| 55 | PCR_N_DATE | CHARACTER VARYING(1) | 1 |
| 56 | INT_CD | CHARACTER VARYING(128) | 128 |
| 57 | ICC_INT_RATE | DOUBLE PRECISION | 8 |
| 58 | ORIG_LVR | CHARACTER VARYING(1) | 1 |
| 59 | ACCRED_BRKR_CDE | CHARACTER VARYING(1) | 1 |
| 60 | OD_SECURED_FLAG | CHARACTER VARYING(1) | 1 |
| 61 | FILE_DATE | CHARACTER VARYING(200) | 200 |