INT_SHRD_LOAN_ORIG_FAC_MASTER_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 VALUE_DATE DATE 4
2 FACILITY_ID CHARACTER VARYING(40) 40
3 SUBMISSION_ID CHARACTER VARYING(50) 50
4 APPLICATION_ID CHARACTER VARYING(50) 50
5 PROD_GRP_SERIAL_NO BYTEINT 1
6 BEST_ROW_PER_FAC_IND BIGINT 8
7 FIRST_DISBURSEMENT_DATE DATE 4
8 LAST_DISBURSEMENT_DATE DATE 4
9 ACCOUNT_ID CHARACTER VARYING(40) 40
10 BORR_ENTITY_ID CHARACTER VARYING(50) 50
11 PARTY_ID CHARACTER VARYING(40) 40
12 EXTERNAL_PARTY_ID CHARACTER VARYING(40) 40
13 BANK_CODE CHARACTER VARYING(4) 4
14 BANKING_TYPE CHARACTER VARYING(6) 6
15 BRANCH_CODE CHARACTER VARYING(10) 10
16 ACCOUNT_OPENING_DATE TIMESTAMP 8
17 LOAN_PURPOSE CHARACTER VARYING(40) 40
18 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
19 OFFER_ID CHARACTER VARYING(40) 40
20 PRODUCT_CODE CHARACTER VARYING(50) 50
21 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
22 PRODUCT_GRP_CODE CHARACTER VARYING(16) 16
23 FACILITY_TYPE CHARACTER VARYING(3) 3
24 FACILITY_CATEGORY_CODE CHARACTER VARYING(50) 50
25 SUBMISSION_CREATION_DATE TIMESTAMP 8
26 FACILITY_CREATION_DATE TIMESTAMP 8
27 CDTL_APPROVAL_DATE TIMESTAMP 8
28 UNCDTL_APPROVAL_DATE TIMESTAMP 8
29 SETTLED_YN CHARACTER VARYING(1) 1
30 OFFER_ACCEPTED_DATE DATE 4
31 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
32 APPLICANT_ID CHARACTER VARYING(50) 50
33 IS_PRIMARY_APPLICANT CHARACTER VARYING(1) 1
34 PARTY_TYPE CHARACTER VARYING(50) 50
35 APPLICATION_BRANCH CHARACTER VARYING(10) 10
36 APPLICATION_STATUS CHARACTER VARYING(50) 50
37 APPLN_REQ_TYPE CHARACTER VARYING(20) 20
38 APP_OBJECT_STATUS CHARACTER(1) 1
39 APPROVAL_TYPE CHARACTER VARYING(3) 3
40 APPROVER_ID CHARACTER VARYING(50) 50
41 APPROVER_NAME CHARACTER VARYING(50) 50
42 BUSINESS_UNIT CHARACTER VARYING(40) 40
43 CCY_CODE CHARACTER VARYING(3) 3
44 APPLICATION_CREATION_DATE TIMESTAMP 8
45 APPLICATION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
46 SUBMISSION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
47 DECISION_DATE TIMESTAMP 8
48 DECISION_ID CHARACTER VARYING(50) 50
49 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
50 DEC_STATUS_TYPE_FAC CHARACTER VARYING(50) 50
51 AUTH_DEC_STATUS_SUB CHARACTER VARYING(50) 50
52 MAN_DEC_STATUS_SUB CHARACTER VARYING(50) 50
53 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
54 LENDING_CATEGORY_CODE CHARACTER VARYING(16) 16
55 LOWDOC_FLAG CHARACTER VARYING(1) 1
56 RSN_CODE CHARACTER VARYING(1212) 1212
57 SCHEDULE_CODE CHARACTER VARYING(40) 40
58 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
59 SUBMISSION_CREATED_BY CHARACTER VARYING(254) 254
60 SUBMISSION_BRANCH CHARACTER VARYING(10) 10
61 SUBMISSION_DATE TIMESTAMP 8
62 SUBMISSION_STATUS CHARACTER VARYING(50) 50
63 APPROVED_AMOUNT DOUBLE PRECISION 8
64 BASE_LOAN_AMOUNT DOUBLE PRECISION 8
65 TOTAL_CAPITALISED_FEE_AMOUNT DOUBLE PRECISION 8
66 TOTAL_CAPITALISED_INS_AMOUNT DOUBLE PRECISION 8
67 TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
68 TOTAL_LOAN_AMOUNT DOUBLE PRECISION 8
69 LOAN_VALUE_RATIO DOUBLE PRECISION 8
70 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
71 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
72 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
73 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
74 PIT_EVENT_DATE DATE 4
75 NEXT_PIT_EVENT_DATE DATE 4
76 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
77 FIXED_TERM_MONTHS DOUBLE PRECISION 8
78 FV_FLAG CHARACTER VARYING(1) 1
79 FIXED_RATE_TERM_MONTHS BIGINT 8
80 SIMULATION_ID CHARACTER VARYING(50) 50
81 SOURCE_PRODUCT_CODE CHARACTER VARYING(105) 105
82 DECISION_BY CHARACTER VARYING(40) 40
83 REQUESTED_TENOR_MONTHS DOUBLE PRECISION 8
84 REQUESTED_TENOR_YEARS DOUBLE PRECISION 8
85 REQUEST_AMOUNT DOUBLE PRECISION 8
86 BORROWER_CONTRIBUTION_AMOUNT DOUBLE PRECISION 8
87 SIMULATION_TYPE CHARACTER VARYING(20) 20
88 OFFER_XREF_ACCOUNT_NUMBER CHARACTER VARYING(40) 40