INT_OBP_H_ORIGINATION_FACILITY_DECISION_LN

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_OBP_H_ORIGINATION_FACILITY_DECISION_LN_V

Columns
# Name Data Type Length
1 FACILITY_ID CHARACTER VARYING(40) 40
2 FACILITY_DIM_ID BIGINT 8
3 FACILITY_TYPE CHARACTER VARYING(3) 3
4 LIMIT_AMOUNT DOUBLE PRECISION 8
5 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
6 REQ_LIMIT_AMOUNT DOUBLE PRECISION 8
7 PRODUCT_GRP_CODE CHARACTER VARYING(16) 16
8 APPROVER_ID CHARACTER VARYING(50) 50
9 APPROVER_NAME CHARACTER VARYING(50) 50
10 APPROVAL_TYPE CHARACTER VARYING(3) 3
11 APPROVAL_TYPE_DESCRIPTION CHARACTER VARYING(22) 22
12 BRANCH_CODE CHARACTER VARYING(10) 10
13 FACILITY_CATEGORY_CODE CHARACTER VARYING(50) 50
14 LENDING_CATEGORY_CODE CHARACTER VARYING(16) 16
15 BUSINESS_UNIT CHARACTER VARYING(40) 40
16 ACCREDITED_BROKER_ID CHARACTER VARYING(20) 20
17 BROKER_CODE CHARACTER VARYING(40) 40
18 LOWDOC_FLAG CHARACTER VARYING(1) 1
19 REQ_NUMBER_OF_YEARS DOUBLE PRECISION 8
20 REQ_NUMBER_OF_MONTHS DOUBLE PRECISION 8
21 APPR_NUMBER_OF_YEARS DOUBLE PRECISION 8
22 APPR_NUMBER_OF_MONTHS DOUBLE PRECISION 8
23 APPLICATION_ID CHARACTER VARYING(50) 50
24 CD_APPLICATION_ID CHARACTER VARYING(50) 50
25 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
26 FACILITY_DECISION_DATE TIMESTAMP 8
27 FACILITY_DECISION_ID CHARACTER VARYING(50) 50
28 FACILITY_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
29 APPROVED_AMOUNT DOUBLE PRECISION 8
30 LOAN_VALUE_RATIO DOUBLE PRECISION 8
31 LVR_GROUP CHARACTER VARYING(50) 50
32 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
33 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
37 FACILITY_ACTIVE_OR_CLOSED CHARACTER VARYING(1) 1
38 FAC_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
39 FAC_DSN_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
40 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
41 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
42 BUSINESS_END_OF_DAY_DATE DATE 4
43 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
44 IS_CURRENT CHARACTER VARYING(1) 1