INT_MR_EFS_LOAN_PRICING_MONTHLY_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PORTFOLIO_DATE | TIMESTAMP | 8 |
| 2 | ACCOUNT_ID_NUMBER | CHARACTER VARYING(50) | 50 |
| 3 | ACCOUNT_NUMBER | CHARACTER VARYING(50) | 50 |
| 4 | SOURCE_SYSTEM_GROUP | CHARACTER VARYING(2) | 2 |
| 5 | ACCOUNT_SOURCE_SYSTEM | CHARACTER VARYING(4) | 4 |
| 6 | SETTLEMENT_DATE | TIMESTAMP | 8 |
| 7 | LAST_REPRICE_DATE | TIMESTAMP | 8 |
| 8 | NEXT_REPRICE_DATE | TIMESTAMP | 8 |
| 9 | QRM_ACCOUNT | CHARACTER VARYING(75) | 75 |
| 10 | SOURCE_PRODUCT_CODE | CHARACTER VARYING(15) | 15 |
| 11 | ORACLE_GL_PRODUCT | CHARACTER VARYING(10) | 10 |
| 12 | EOM_PORTFOLIO_BALANCE | NUMERIC(19,4) | 19 |
| 13 | AVERAGE_MONTHLY_BALANCE | NUMERIC(15,2) | 19 |
| 14 | DEPOSIT_OFFSET_BALANCE | NUMERIC(15,2) | 19 |
| 15 | DEPOSIT_OFFSET_AVERAGE_BALANCE | NUMERIC(15,2) | 19 |
| 16 | OFFSET_IMPACT | NUMERIC(36,18) | 19 |
| 17 | GROSS_CUST_RT_AMT | NUMERIC(38,14) | 19 |
| 18 | OFFSET_ADJ_CUST_RT_AMT | NUMERIC(38,32) | 19 |
| 19 | GROSS_BASE_RT_AMT | NUMERIC(38,14) | 19 |
| 20 | OFFSET_ADJ_BASE_RT_AMT | NUMERIC(38,32) | 19 |
| 21 | GROSS_ADDON_AMT | NUMERIC(38,14) | 19 |
| 22 | OFFSET_ADJ_ADDON_AMT | NUMERIC(38,32) | 19 |
| 23 | GROSS_FC_ALLOC_AMT | NUMERIC(38,14) | 19 |
| 24 | OFFSET_ADJ_FC_ALLOC_AMT | NUMERIC(38,32) | 19 |
| 25 | BASIS_COST_AMT | NUMERIC(38,14) | 19 |
| 26 | EST_LIQUIDITY_RT | NUMERIC(38,6) | 19 |
| 27 | EST_LIQUIDITY_AMT | NUMERIC(38,6) | 19 |
| 28 | COST_OF_FUNDS_AMT | NUMERIC(38,32) | 19 |
| 29 | OFFSET_ADJ_CUST_RT | NUMERIC(38,6) | 19 |
| 30 | COST_OF_FUNDS_RT | NUMERIC(38,6) | 19 |