INT_OBP_LOAN_ORIG_PIT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_OBP_LOAN_ORIG_PIT_V

Columns
# Name Data Type Length
1 FACILITY_DIM_ID BIGINT 8
2 PERIOD_DIM_ID BIGINT 8
3 SOURCE_SYSTEM_DIM_ID INTEGER 4
4 FACILITY_STATUS_DIM_ID BIGINT 8
5 APPLICATION_DIM_ID BIGINT 8
6 ACCOUNT_DIM_ID BIGINT 8
7 CDTL_APPROVAL_PERIOD_DIM_ID BIGINT 8
8 UNCDTL_APPROVAL_PERIOD_DIM_ID BIGINT 8
9 CLIENT_ACCEPTED_PERIOD_DIM_ID BIGINT 8
10 CLIENT_ADVISED_PERIOD_DIM_ID BIGINT 8
11 SETTLED_PERIOD_DIM_ID BIGINT 8
12 FINANCED_PERIOD_DIM_ID BIGINT 8
13 SOURCE_PRODUCT_DIM_ID BIGINT 8
14 BALANCE_SHEET_INDICATOR CHARACTER VARYING(5) 5
15 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
16 LOAN_PURPOSE_DIM_ID BIGINT 8
17 BILL_TYPE_DIM_ID BIGINT 8
18 ACCOUNT_SECURITY_DIM_ID BIGINT 8
19 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
20 INTEREST_RATE_DIM_ID INTEGER 4
21 CHANNEL_DIM_ID BIGINT 8
22 GCIS_CUSTOMER_DIM_ID BIGINT 8
23 CUSTOMER_DIM_ID BIGINT 8
24 CUST_CLASSIFIER_DIM_ID BIGINT 8
25 ANZSIC_DIM_ID BIGINT 8
26 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
27 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
28 INTEREST_RATE_TERM_DIM_ID BIGINT 8
29 ORIG_LOAN_VALUE_RATIO_DIM_ID BIGINT 8
30 MATERIALITY_DIM_ID INTEGER 4
31 FACILITY_DECISION_DIM_ID BIGINT 8
32 LND_POLICY_GL_TYPE_DIM_ID BIGINT 8
33 OF_PRODUCT_SID BIGINT 8
34 OF_COST_CENTRE_SID BIGINT 8
35 TOTAL_LOAN_AMOUNT DOUBLE PRECISION 8
36 TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
37 TOTAL_CAPITALISED_FEE_AMOUNT DOUBLE PRECISION 8
38 TOTAL_CAPITALISED_INS_AMOUNT DOUBLE PRECISION 8
39 NEW_LOAN_AMOUNT INTEGER 4
40 NEW_COMMIT_AMOUNT DOUBLE PRECISION 8
41 NEW_COMMIT_COUNT INTEGER 4
42 BUSINESS_LOAD_DATE TIMESTAMP 8
43 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
44 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
45 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
46 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
47 DISBURSED_AMT DOUBLE PRECISION 8
48 FACILITY_TYPE CHARACTER VARYING(3) 3
49 CURRENT_INTEREST_RATE DOUBLE PRECISION 8
50 OFFER_ID CHARACTER VARYING(40) 40
51 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
52 PERIOD_DT TIMESTAMP 8
53 SNPT_EOD_TS TIMESTAMP 8
54 SOURCE_PRODUCT_CODE CHARACTER VARYING(105) 105
55 PRODUCT_CODE CHARACTER VARYING(50) 50
56 OBP_PARTY_ID CHARACTER VARYING(40) 40
57 APPLICATION_ID_OBP CHARACTER VARYING(50) 50
58 FACILITY_ID_OBP CHARACTER VARYING(40) 40