FCT_OBP_SLN_APP_FAC_CURRENT_UPL_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_SLN_APP_FAC_CURRENT_UPL

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 APPLICATION_ID CHARACTER VARYING(20) 20
3 BROKER_CODE CHARACTER VARYING(5) 5
4 ACCREDITED_BROKER_CODE CHARACTER VARYING(7) 7
5 SALES_BRANCH_CODE CHARACTER VARYING(5) 5
6 SETTLE_BRANCH CHARACTER VARYING(5) 5
7 LENDER_ID CHARACTER VARYING(100) 100
8 SUPPORT_OFFICE_ID CHARACTER VARYING(100) 100
9 CURRENT_OPERATOR_ID CHARACTER VARYING(100) 100
10 QUALITY_MEASURES_USER_ID CHARACTER VARYING(100) 100
11 CONDITIONAL_APPROVED_OFFICER CHARACTER VARYING(254) 254
12 UNCONDITIONAL_APPROVED_OFFICER CHARACTER VARYING(254) 254
13 APP_BASE_LOAN_AMOUNT DOUBLE PRECISION 8
14 APP_TOTAL_LOAN_AMOUNT DOUBLE PRECISION 8
15 APP_TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
16 FACILITY_ID CHARACTER VARYING(40) 40
17 PRODUCT_CODE CHARACTER VARYING(50) 50
18 PURPOSE_CODE CHARACTER VARYING(40) 40
19 SUB_PURPOSE_CODE CHARACTER VARYING(255) 255
20 UPFRONT_REBATE_AUTH_USER_ID CHARACTER VARYING(254) 254
21 ONGOING_REBATE_AUTH_USER_ID CHARACTER VARYING(254) 254
22 FAC_LOAN_AMOUNT DOUBLE PRECISION 8
23 FAC_TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
24 FAC_BORROWER_CONTRIBUTION INTEGER 4
25 CC_BALANCE_TRANSFER_AMOUNT1 INTEGER 4
26 CC_BALANCE_TRANSFER_AMOUNT2 INTEGER 4
27 CC_BALANCE_TRANSFER_AMOUNT3 INTEGER 4
28 EVENT_ID CHARACTER VARYING(20) 20
29 PROCESS_TYPE CHARACTER VARYING(100) 100
30 PROCESS_STATUS CHARACTER VARYING(50) 50
31 ACTION_TYPE CHARACTER VARYING(50) 50
32 DATE_OCCURED CHARACTER VARYING(200) 200
33 TRIGGERED_BY_USER_ID CHARACTER VARYING(254) 254
34 ASSIGNED_TO_USER_ID CHARACTER VARYING(254) 254
35 LENDER_HR_ID BIGINT 8
36 CURRENT_OPERATOR_HR_ID BIGINT 8
37 CONDITIONAL_APRV_OFCR_HR_ID BIGINT 8
38 UNCONDITIONAL_APRV_OFCR_HR_ID BIGINT 8
39 SUPPORT_OFFICE_HR_ID BIGINT 8
40 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
41 CDC_RECORD_TYPE CHARACTER VARYING(6) 6
42 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
43 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8