OBP24_HST_FLX_LM_PROPOSED_FACILITY_B
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_HST_FLX_LM_PROPOSED_FACILITY_B
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ID | CHARACTER VARYING(40) | 40 |
| 2 | FACILITY_TYPE | CHARACTER VARYING(3) | 3 |
| 3 | DESCRIPTION | CHARACTER VARYING(2000) | 2000 |
| 4 | CCY_CODE | CHARACTER VARYING(3) | 3 |
| 5 | FACILITY_CATEGORY_CODE | CHARACTER VARYING(50) | 50 |
| 6 | BORR_ENTITY_ID | CHARACTER VARYING(16) | 16 |
| 7 | PARENT_FACILITY_ID | CHARACTER VARYING(40) | 40 |
| 8 | PRODUCT_GRP_CODE | CHARACTER VARYING(16) | 16 |
| 9 | BUSINESS_UNIT | CHARACTER VARYING(40) | 40 |
| 10 | MARKET_ENTITY_CODE | CHARACTER VARYING(40) | 40 |
| 11 | SANCTIONED_AMOUNT | DOUBLE PRECISION | 8 |
| 12 | LIMIT_AMOUNT | DOUBLE PRECISION | 8 |
| 13 | BRANCH_CODE | CHARACTER VARYING(10) | 10 |
| 14 | INTERNAL_REMARKS | CHARACTER VARYING(255) | 255 |
| 15 | AVAILABILITY_FLAG | CHARACTER VARYING(1) | 1 |
| 16 | START_DATE | TIMESTAMP | 8 |
| 17 | EXPIRY_DATE | TIMESTAMP | 8 |
| 18 | EFFECTIVE_DATE | TIMESTAMP | 8 |
| 19 | LENDING_CATEGORY_CODE | CHARACTER VARYING(16) | 16 |
| 20 | LOAN_TO_VALUE_RATIO_MV | DOUBLE PRECISION | 8 |
| 21 | LOAN_TO_VALUE_RATIO_BV | DOUBLE PRECISION | 8 |
| 22 | AVAILMENT_EXPIRY_DATE | TIMESTAMP | 8 |
| 23 | LAST_AVAILMENT_EXPIRY_DATE | TIMESTAMP | 8 |
| 24 | REVOLVING_FACILITY_FLAG | CHARACTER VARYING(1) | 1 |
| 25 | AMT_BASIS_TYPE | CHARACTER VARYING(3) | 3 |
| 26 | APPROVAL_TYPE | CHARACTER VARYING(3) | 3 |
| 27 | APPROVER_ID | CHARACTER VARYING(50) | 50 |
| 28 | APPROVER_NAME | CHARACTER VARYING(50) | 50 |
| 29 | LOAN_APPROVAL_ID | CHARACTER VARYING(25) | 25 |
| 30 | REVIEW_REQD_FLAG | CHARACTER VARYING(1) | 1 |
| 31 | AUTO_REVIEW_REQD_FLAG | CHARACTER VARYING(1) | 1 |
| 32 | PERIODICITY_TYPE | CHARACTER VARYING(3) | 3 |
| 33 | FREQUENCY_TYPE | CHARACTER VARYING(3) | 3 |
| 34 | FIXED_DATE | TIMESTAMP | 8 |
| 35 | PROGRESSIVE_CR_FLAG | CHARACTER VARYING(1) | 1 |
| 36 | LOWDOC_FLAG | CHARACTER VARYING(1) | 1 |
| 37 | CAPITAL_SUB_FLG | CHARACTER VARYING(1) | 1 |
| 38 | RURAL_FLAG | CHARACTER VARYING(1) | 1 |
| 39 | EMPLOYEE_FLAG | CHARACTER VARYING(1) | 1 |
| 40 | APPR_NUMBER_OF_YEARS | DOUBLE PRECISION | 8 |
| 41 | APPR_NUMBER_OF_MONTHS | DOUBLE PRECISION | 8 |
| 42 | REQ_NUMBER_OF_YEARS | DOUBLE PRECISION | 8 |
| 43 | REQ_NUMBER_OF_MONTHS | DOUBLE PRECISION | 8 |
| 44 | REQ_LIMIT_AMOUNT | DOUBLE PRECISION | 8 |
| 45 | MAKER_NAME | CHARACTER VARYING(254) | 254 |
| 46 | MAKER_DATE | TIMESTAMP | 8 |
| 47 | CHECKER_NAME | CHARACTER VARYING(254) | 254 |
| 48 | CHECKER_DATE | TIMESTAMP | 8 |
| 49 | RECORD_STATUS_TYPE | CHARACTER VARYING(1) | 1 |
| 50 | VERSION_NUM | DOUBLE PRECISION | 8 |
| 51 | BROKER_ID | CHARACTER VARYING(20) | 20 |
| 52 | INTRODUCER_ID | CHARACTER VARYING(20) | 20 |
| 53 | EXPIRY_NOTICE_DAYS | DOUBLE PRECISION | 8 |
| 54 | GROUP_LVR_MV | DOUBLE PRECISION | 8 |
| 55 | GROUP_LVR_BV | DOUBLE PRECISION | 8 |
| 56 | GRAPH_ID | CHARACTER VARYING(64) | 64 |
| 57 | BRANCH_DATE | TIMESTAMP | 8 |
| 58 | DECISION_LVR_BV | DOUBLE PRECISION | 8 |
| 59 | DECISION_LVR_MV | DOUBLE PRECISION | 8 |
| 60 | MANUAL_FLAG | CHARACTER VARYING(1) | 1 |
| 61 | MANUAL_DECISION_LVR_FLAG | CHARACTER VARYING(1) | 1 |
| 62 | MANUAL_ALLOC_REQ_STATUS | CHARACTER VARYING(3) | 3 |
| 63 | IPA_FACILITY_FLAG | CHARACTER VARYING(1) | 1 |
| 64 | FLEXIBLE_CREDIT_FACILITY | CHARACTER VARYING(1) | 1 |
| 65 | NOTICE_DAYS | DOUBLE PRECISION | 8 |
| 66 | ORIG_REQ_LIMIT_AMOUNT | DOUBLE PRECISION | 8 |
| 67 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 68 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 69 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 70 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |