FCT_SDW_TSLNF_APP_FAC_CURRENT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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 FACILITY_ID CHARACTER VARYING(20) 20
12 PRODUCT_CODE CHARACTER VARYING(6) 6
13 PURPOSE_CODE CHARACTER VARYING(60) 60
14 SUB_PURPOSE_CODE CHARACTER VARYING(60) 60
15 EVENT_ID CHARACTER VARYING(20) 20
16 TRIGGER_BY_USED_ID CHARACTER VARYING(100) 100
17 ASSIGNED_TO_USER_ID CHARACTER VARYING(100) 100
18 CONDITIONAL_APPROVED_OFFICER CHARACTER VARYING(12) 12
19 UNCONDITIONAL_APPROVED_OFFICER CHARACTER VARYING(12) 12
20 APP_BASE_LOAN_AMOUNT NUMERIC(15,2) 19
21 APP_TOTAL_LOAN_AMOUNT NUMERIC(15,2) 19
22 APP_TOTAL_FUNDING_AMOUNT NUMERIC(15,2) 19
23 UPFRONT_REBATE_AUTH_USER_ID CHARACTER VARYING(12) 12
24 ONGOING_REBATE_AUTH_USER_ID CHARACTER VARYING(12) 12
25 FAC_LOAN_AMOUNT NUMERIC(13,2) 19
26 FAC_TOTAL_FUNDING_AMOUNT NUMERIC(14,2) 19
27 FAC_BORROWER_CONTRIBUTION NUMERIC(14,2) 19
28 CC_BALANCE_TRANSFER_AMOUNT1 NUMERIC(13,2) 19
29 CC_BALANCE_TRANSFER_AMOUNT2 NUMERIC(13,2) 19
30 CC_BALANCE_TRANSFER_AMOUNT3 NUMERIC(13,2) 19
31 PROCESS_TYPE CHARACTER VARYING(100) 100
32 PROCESS_STATUS CHARACTER VARYING(100) 100
33 ACTION_TYPE CHARACTER VARYING(100) 100
34 DATE_OCCURED TIMESTAMP 8
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(4) 4
41 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
42 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
43 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8