OBP24_FLX_LM_CREDIT_FACILITY_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_FLX_LM_CREDIT_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 GROUP_LVR_MV DOUBLE PRECISION 8
23 GROUP_LVR_BV DOUBLE PRECISION 8
24 GRAPH_ID CHARACTER VARYING(64) 64
25 AVAILMENT_EXPIRY_DATE TIMESTAMP 8
26 LAST_AVAILMENT_EXPIRY_DATE TIMESTAMP 8
27 BRANCH_DATE TIMESTAMP 8
28 REVOLVING_FACILITY_FLAG CHARACTER VARYING(1) 1
29 AMT_BASIS_TYPE CHARACTER VARYING(3) 3
30 APPROVAL_TYPE CHARACTER VARYING(3) 3
31 NPA_STATUS CHARACTER VARYING(5) 5
32 NPA_CODE CHARACTER VARYING(5) 5
33 NPA_STATUS_MOD_DATE TIMESTAMP 8
34 APPROVER_ID CHARACTER VARYING(50) 50
35 APPROVER_NAME CHARACTER VARYING(50) 50
36 LOAN_APPROVAL_ID CHARACTER VARYING(30) 30
37 REVIEW_REQD_FLAG CHARACTER VARYING(1) 1
38 AUTO_REVIEW_REQD_FLAG CHARACTER VARYING(1) 1
39 PROGRESSIVE_CR_FLAG CHARACTER VARYING(1) 1
40 NEXT_REVIEW_DATE TIMESTAMP 8
41 REVIEWED_DATE TIMESTAMP 8
42 EXTENDED_UPTO_DATE TIMESTAMP 8
43 REVIEWED_TYPE CHARACTER VARYING(3) 3
44 CONDUCT CHARACTER VARYING(3) 3
45 PERIODICITY_TYPE CHARACTER VARYING(3) 3
46 FREQUENCY_TYPE CHARACTER VARYING(3) 3
47 FIXED_DATE TIMESTAMP 8
48 DELINQUENT_FLAG CHARACTER VARYING(1) 1
49 DELINQUENCY_REASON CHARACTER VARYING(255) 255
50 INCOLLECTION_FLG CHARACTER VARYING(1) 1
51 INCOLLECTION_REASON CHARACTER VARYING(50) 50
52 LOWDOC_FLAG CHARACTER VARYING(1) 1
53 CAPITAL_SUB_FLG CHARACTER VARYING(1) 1
54 RURAL_FLAG CHARACTER VARYING(1) 1
55 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
56 APPR_NUMBER_OF_YEARS DOUBLE PRECISION 8
57 APPR_NUMBER_OF_MONTHS DOUBLE PRECISION 8
58 REQ_NUMBER_OF_YEARS DOUBLE PRECISION 8
59 REQ_NUMBER_OF_MONTHS DOUBLE PRECISION 8
60 REQ_LIMIT_AMOUNT DOUBLE PRECISION 8
61 BROKER_ID CHARACTER VARYING(20) 20
62 INTRODUCER_ID CHARACTER VARYING(20) 20
63 EXPIRY_NOTICE_DAYS DOUBLE PRECISION 8
64 MAKER_NAME CHARACTER VARYING(254) 254
65 MAKER_DATE TIMESTAMP 8
66 CHECKER_NAME CHARACTER VARYING(254) 254
67 CHECKER_DATE TIMESTAMP 8
68 RECORD_STATUS_TYPE CHARACTER VARYING(1) 1
69 VERSION_NUM DOUBLE PRECISION 8
70 MANUAL_FLAG CHARACTER VARYING(1) 1
71 STAGE_TYPE CHARACTER VARYING(50) 50
72 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
73 CLOSURE_FLAG CHARACTER VARYING(1) 1
74 EXPIRY_EXTENT_COUNTER DOUBLE PRECISION 8
75 FLEXIBLE_CREDIT_FACILITY CHARACTER VARYING(1) 1
76 NOTICE_DAYS DOUBLE PRECISION 8
77 ORIG_REQ_LIMIT_AMOUNT DOUBLE PRECISION 8
78 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
79 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
80 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
81 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8