| 1 |
PORTFOLIO_DATE |
TIMESTAMP |
8 |
| 2 |
CONTRACTUAL_RUNOFF_MONTH |
DATE |
4 |
| 3 |
GROWTH_DRIVER |
CHARACTER VARYING(18) |
18 |
| 4 |
ORACLE_GL_PRODUCT |
CHARACTER VARYING(10) |
10 |
| 5 |
QRM_ACCOUNT |
CHARACTER VARYING(75) |
75 |
| 6 |
SOURCE_SYSTEM |
CHARACTER VARYING(4) |
4 |
| 7 |
LIQUIDITY_RUNOFF_PERCENTAGE |
NUMERIC(8,4) |
19 |
| 8 |
TP_LIQUIDITY_RUNOFF_CATEGORY |
CHARACTER VARYING(50) |
50 |
| 9 |
BALANCE_VALUE_TIER |
CHARACTER VARYING(5) |
5 |
| 10 |
LOW_COST_DEPOSIT_FLAG |
CHARACTER VARYING(1) |
1 |
| 11 |
ORACLE_GL_COST_CENTRE |
BIGINT |
8 |
| 12 |
FLEXIRATE_FLAG |
CHARACTER VARYING(1) |
1 |
| 13 |
BONUS_INTEREST_FLAG |
CHARACTER VARYING(1) |
1 |
| 14 |
TERM_TIER_DESCRIPTION |
CHARACTER VARYING(150) |
150 |
| 15 |
TERM_TIER_SORT |
BIGINT |
8 |
| 16 |
HOGAN_ORIG_PEOPLESOFT_BRANCH |
CHARACTER VARYING(20) |
20 |
| 17 |
STEPPED_LT_10K |
NUMERIC(38,4) |
19 |
| 18 |
STEPPED_LT_100K |
NUMERIC(38,4) |
19 |
| 19 |
STEPPED_GT_100K |
NUMERIC(38,4) |
19 |
| 20 |
EOM_BAL_PORTION_OFFSET |
NUMERIC(38,0) |
19 |
| 21 |
AVG_BAL_PORTION_OFFSET |
NUMERIC(38,0) |
19 |
| 22 |
NON_OFFSET_EOM_BAL |
NUMERIC(38,4) |
19 |
| 23 |
NON_OFFSET_EOM_AVG_BAL |
NUMERIC(38,2) |
19 |
| 24 |
QRM_RECORDS_COUNT |
NUMERIC(38,0) |
19 |
| 25 |
TRUE_OFFSET_QRM_RECORDS_COUNT |
NUMERIC(38,0) |
19 |
| 26 |
PORTFOLIO_BALANCE |
NUMERIC(38,4) |
19 |
| 27 |
AVERAGE_MONTHLY_BALANCE |
NUMERIC(38,2) |
19 |
| 28 |
BONUS_INTEREST_MONTHLY_AMT |
NUMERIC(38,0) |
19 |
| 29 |
AVGBAL_X_ADJ_CUST_RT |
NUMERIC(38,14) |
19 |
| 30 |
AVGBAL_X_TP_BASE_RT |
NUMERIC(38,14) |
19 |
| 31 |
AVGBAL_X_TP_ADDON_RT |
NUMERIC(38,14) |
19 |
| 32 |
AVGBAL_X_LIQ_ADDON_RT |
NUMERIC(38,14) |
19 |
| 33 |
OFFSET_AVGBAL_X_LIQ_ADDON_RT |
NUMERIC(38,0) |
19 |
| 34 |
AVGBAL_X_FC_ALLOC_RT |
NUMERIC(38,14) |
19 |
| 35 |
OFFSET_AVGBAL_X_FC_ALLOC_RT |
NUMERIC(38,0) |
19 |