FCT_BNK_QRM_DAILY_MASTER_TD_INSIGHT
Description
OBP extract with select Term 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 | DEPOSIT_NUMBER | DOUBLE PRECISION | 8 |
| 6 | ACCT_STATUS | CHARACTER VARYING(40) | 40 |
| 7 | BRANCH_NO | CHARACTER VARYING(10) | 10 |
| 8 | COST_CENTER | CHARACTER VARYING(150) | 150 |
| 9 | DT_CLOSED | CHARACTER VARYING(200) | 200 |
| 10 | DT_OPENED | CHARACTER VARYING(200) | 200 |
| 11 | TERM | INTEGER | 4 |
| 12 | TERM_CODE | CHARACTER VARYING(1) | 1 |
| 13 | CURRENT_MATURITY_DATE | CHARACTER VARYING(200) | 200 |
| 14 | FINAL_MATURITY_DATE | CHARACTER VARYING(200) | 200 |
| 15 | OFFICER | CHARACTER VARYING(254) | 254 |
| 16 | ORIGINAL_BRANCH | CHARACTER VARYING(10) | 10 |
| 17 | SALE_OFF_CD | CHARACTER VARYING(254) | 254 |
| 18 | SECONDARY_OFFICER | CHARACTER VARYING(1) | 1 |
| 19 | SHORT_NAME | CHARACTER VARYING(500) | 500 |
| 20 | SIC_OCCUPATION_CD | CHARACTER VARYING(5) | 5 |
| 21 | SUB_PRDCT_CD | CHARACTER VARYING(30) | 30 |
| 22 | OF_PRODUCT_CODE | CHARACTER VARYING(150) | 150 |
| 23 | CURR_BAL | DOUBLE PRECISION | 8 |
| 24 | UNCOLLECTED_BALANCE | DOUBLE PRECISION | 8 |
| 25 | DATE_OD | CHARACTER VARYING(10) | 10 |
| 26 | INTEREST_RATE_ANNUAL | DOUBLE PRECISION | 8 |
| 27 | AVG_BAL_MTD | DOUBLE PRECISION | 8 |
| 28 | AGG_PLUS_BAL_MTD | DOUBLE PRECISION | 8 |
| 29 | AGG_PLUS_DAYS_MTD | BIGINT | 8 |
| 30 | AGG_OD_DAYS_MTD | INTEGER | 4 |
| 31 | INT_PAY_CYCLE_CD | CHARACTER VARYING(40) | 40 |
| 32 | INT_PAY_METHOD | CHARACTER VARYING(6) | 6 |
| 33 | INT_XFER_ACCT | CHARACTER VARYING(73) | 73 |
| 34 | XFER_BSB | CHARACTER VARYING(32) | 32 |
| 35 | PRINC_XFER_ACCT | CHARACTER VARYING(40) | 40 |
| 36 | REN_CDE | CHARACTER VARYING(1) | 1 |
| 37 | REN_TERM | INTEGER | 4 |
| 38 | REN_ADD_AMT | DOUBLE PRECISION | 8 |
| 39 | REN_ADD_ACCT | CHARACTER VARYING(40) | 40 |
| 40 | REN_PART_PAY_AMT | INTEGER | 4 |
| 41 | BREAK_DATE | CHARACTER VARYING(200) | 200 |
| 42 | CURRENT_ISSUE_DATE | CHARACTER VARYING(200) | 200 |
| 43 | INT_CD | CHARACTER VARYING(128) | 128 |
| 44 | FILE_DATE | CHARACTER VARYING(200) | 200 |