| 1 |
SUBMISSION_ID |
CHARACTER VARYING(100) |
100 |
| 2 |
FACILITY_ID |
CHARACTER VARYING(104) |
104 |
| 3 |
LOAN_ACCOUNT_NUMBER |
CHARACTER VARYING(204) |
204 |
| 4 |
CUSTOMER_ID |
CHARACTER VARYING(204) |
204 |
| 5 |
CUSTOMER_NAME |
CHARACTER VARYING(2549) |
2549 |
| 6 |
LOAN_AMOUNT |
DOUBLE PRECISION |
8 |
| 7 |
FACILITY_AMOUNT |
DOUBLE PRECISION |
8 |
| 8 |
SUBMISSION_AMOUNT |
DOUBLE PRECISION |
8 |
| 9 |
SETTLEMENT_DATE |
CHARACTER VARYING(200) |
200 |
| 10 |
TRANSACTION_DATE |
CHARACTER VARYING(200) |
200 |
| 11 |
TRANSACTION_TYPE |
CHARACTER VARYING(100) |
100 |
| 12 |
DATA_ENTRY_OFFICER |
CHARACTER VARYING(40) |
40 |
| 13 |
VERIFIED_BY |
CHARACTER VARYING(500) |
500 |
| 14 |
SUBMISSION_ENTRY_OFFICER |
CHARACTER VARYING(254) |
254 |
| 15 |
SUBMISSION_REVIEW_OFFICER |
CHARACTER VARYING(40) |
40 |
| 16 |
DATA_ENTRY_BRANCH_NUMBER |
CHARACTER VARYING(10) |
10 |
| 17 |
SETTLEMENT_BRANCH_NUMBER |
CHARACTER VARYING(10) |
10 |
| 18 |
BROKER_ID |
CHARACTER VARYING(20) |
20 |
| 19 |
BROKER_NAME |
CHARACTER VARYING(250) |
250 |
| 20 |
SALES_OFFICER_CODE |
CHARACTER VARYING(254) |
254 |
| 21 |
SALES_OFFICER_NAME |
CHARACTER VARYING(203) |
203 |
| 22 |
SOURCE |
CHARACTER VARYING(13) |
13 |
| 23 |
SOURCED_BY |
CHARACTER VARYING(10) |
10 |
| 24 |
PURPOSE_DESCRIPTION |
CHARACTER VARYING(400) |
400 |
| 25 |
LOAN_SUB_PURPOSE |
CHARACTER VARYING(10) |
10 |
| 26 |
LVR |
DOUBLE PRECISION |
8 |
| 27 |
EMPLOYMENT_TYPE_1 |
CHARACTER VARYING(13) |
13 |
| 28 |
EMPLOYMENT_TYPE_2 |
CHARACTER VARYING(13) |
13 |
| 29 |
COLLATERAL_TYPE |
CHARACTER VARYING(50) |
50 |
| 30 |
COLLATERAL_CATEGORY |
CHARACTER VARYING(50) |
50 |
| 31 |
VALUATION_TYPE |
CHARACTER VARYING(3) |
3 |
| 32 |
AREA_OF_LAND |
DOUBLE PRECISION |
8 |
| 33 |
YEAR_BUILD |
DOUBLE PRECISION |
8 |
| 34 |
VACANT_LAND |
CHARACTER VARYING(1) |
1 |
| 35 |
CONSTRUCTION |
CHARACTER VARYING(1) |
1 |
| 36 |
NEIGHBOURHOOD |
CHARACTER VARYING(20) |
20 |
| 37 |
LAND |
CHARACTER VARYING(20) |
20 |
| 38 |
ENVIRONMENT_ISSUES |
CHARACTER VARYING(20) |
20 |
| 39 |
IMPROVEMENTS |
CHARACTER VARYING(20) |
20 |
| 40 |
REDUCED_VAL_NEXT_YEAR |
CHARACTER VARYING(20) |
20 |
| 41 |
MARKET_VOLATILITY |
CHARACTER VARYING(20) |
20 |
| 42 |
LOCAL_ECONOMY_IMPACT |
CHARACTER VARYING(20) |
20 |
| 43 |
MARKET_SEGMENT_CONDITION |
CHARACTER VARYING(20) |
20 |
| 44 |
TITLE_SEARCH_CHECKER_NAME |
CHARACTER VARYING(254) |
254 |
| 45 |
COLL_EVAL_CHECKER_NAME |
CHARACTER VARYING(254) |
254 |
| 46 |
STRUCT_SOLN_CONFIRM_DATE |
DATE |
4 |
| 47 |
DISBURSE_UID |
CHARACTER VARYING(1) |
1 |
| 48 |
DISBURSE_DT |
CHARACTER VARYING(1) |
1 |
| 49 |
PRODUCT_GROUP_CODE |
CHARACTER VARYING(50) |
50 |
| 50 |
OFFER_ID |
CHARACTER VARYING(40) |
40 |
| 51 |
STAFF_PARTNER_INDICATOR_FLAG |
CHARACTER(1) |
1 |
| 52 |
EMP_BENEFITS |
CHARACTER VARYING(1) |
1 |
| 53 |
MARGIN |
CHARACTER VARYING(1) |
1 |
| 54 |
PACKAGED |
CHARACTER(1) |
1 |
| 55 |
IS_LMI_APPLICABLE |
CHARACTER VARYING(1) |
1 |
| 56 |
AGGREGATE_LIMIT |
DOUBLE PRECISION |
8 |
| 57 |
BANK_HAIRCUT_VALUE |
SMALLINT |
2 |