INT_SHRD_SUB_APPLN_FAC_MASTER

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_SHRD_SUB_APPLN_FAC_MASTER_V

Columns
# Name Data Type Length
1 VALUE_DATE DATE 4
2 SUBMISSION_ID CHARACTER VARYING(50) 50
3 FACILITY_CREATION_DATE TIMESTAMP 8
4 SUBMISSION_CREATION_DATE TIMESTAMP 8
5 SUBMISSION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
6 SUBMISSION_CREATED_BY CHARACTER VARYING(254) 254
7 SUBMISSION_BRANCH CHARACTER VARYING(10) 10
8 SUBMISSION_DATE TIMESTAMP 8
9 SUBMISSION_STATUS CHARACTER VARYING(50) 50
10 WORKFLOW_STATUS CHARACTER VARYING(50) 50
11 PARTY_ID CHARACTER VARYING(40) 40
12 EXTERNAL_PARTY_ID CHARACTER VARYING(40) 40
13 APPLICANT_ID CHARACTER VARYING(50) 50
14 IS_PRIMARY_APPLICANT CHARACTER(1) 1
15 APPLICANT_SERIAL_NUMBER CHARACTER VARYING(2) 2
16 ENTITY_STATUS CHARACTER VARYING(1) 1
17 PARTY_TYPE CHARACTER VARYING(50) 50
18 APPLICATION_ID CHARACTER VARYING(50) 50
19 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
20 APPLICATION_BRANCH CHARACTER VARYING(10) 10
21 APPLICATION_STATUS CHARACTER VARYING(50) 50
22 APPLICATION_CREATION_DATE TIMESTAMP 8
23 APPLICATION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
24 FACILITY_ID CHARACTER VARYING(40) 40
25 PROD_GRP_SERIAL_NO BYTEINT 1
26 BORR_ENTITY_ID CHARACTER VARYING(50) 50
27 LOAN_PURPOSE CHARACTER VARYING(40) 40
28 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
29 BASE_LOAN_AMOUNT DOUBLE PRECISION 8
30 TOTAL_CAPITALISED_FEE_AMOUNT DOUBLE PRECISION 8
31 TOTAL_CAPITALISED_INS_AMOUNT DOUBLE PRECISION 8
32 TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
33 TOTAL_LOAN_AMOUNT DOUBLE PRECISION 8
34 OFFER_ID CHARACTER VARYING(40) 40
35 PRODUCT_CODE CHARACTER VARYING(50) 50
36 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
37 CCY_CODE CHARACTER VARYING(3) 3
38 BRANCH_CODE CHARACTER VARYING(10) 10
39 PRODUCT_GRP_CODE CHARACTER VARYING(16) 16
40 FACILITY_TYPE CHARACTER VARYING(3) 3
41 FACILITY_CATEGORY_CODE CHARACTER VARYING(50) 50
42 APPROVAL_TYPE CHARACTER VARYING(3) 3
43 APPROVER_ID CHARACTER VARYING(50) 50
44 APPROVER_NAME CHARACTER VARYING(50) 50
45 BUSINESS_UNIT CHARACTER VARYING(40) 40
46 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
47 LENDING_CATEGORY_CODE CHARACTER VARYING(16) 16
48 LOWDOC_FLAG CHARACTER VARYING(1) 1
49 CD_APPLICATION_ID CHARACTER VARYING(50) 50
50 DECISION_DATE TIMESTAMP 8
51 DECISION_ID CHARACTER VARYING(50) 50
52 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
53 APPROVED_AMT DOUBLE PRECISION 8
54 FIRST_DISBURSEMENT_DATE TIMESTAMP 8
55 ACCOUNT_ID CHARACTER VARYING(40) 40
56 ACCOUNT_OPENING_DATE TIMESTAMP 8
57 SCHEDULE_CODE CHARACTER VARYING(40) 40
58 CDTL_APPROVAL_DATE TIMESTAMP 8
59 UNCDTL_APPROVAL_DATE TIMESTAMP 8
60 CDTL_APPROVED_OFFICER CHARACTER VARYING(254) 254
61 UNCDTL_APPROVED_OFFICER CHARACTER VARYING(254) 254
62 WORKFLOW_ACTION CHARACTER VARYING(50) 50
63 SIMULATION_ID CHARACTER VARYING(50) 50
64 OFFER_SERIAL_NUMBER BYTEINT 1
65 IS_SUBSEQUENT_ACCT CHARACTER(1) 1
66 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
67 BANK_CODE CHARACTER VARYING(4) 4
68 BANKING_TYPE CHARACTER VARYING(6) 6
69 IS_FEE_CAPITALIZED CHARACTER VARYING(1) 1
70 IS_CCI_CAPITALIZED CHARACTER VARYING(1) 1
71 TERM_MONTHS BIGINT 8
72 APPLN_REQ_TYPE CHARACTER VARYING(20) 20
73 APPLN_TYPE CHARACTER VARYING(20) 20
74 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
75 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
76 CDC_RECORD_TYPE CHARACTER VARYING(6) 6
77 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3