INT_SHRD_SUB_APPLN_MASTER_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_SHRD_SUB_APPLN_MASTER

Columns
# Name Data Type Length
1 VALUE_DATE DATE 4
2 SUBMISSION_ID CHARACTER VARYING(50) 50
3 APPLICATION_ID CHARACTER VARYING(50) 50
4 PARTY_ID CHARACTER VARYING(40) 40
5 EXTERNAL_PARTY_ID CHARACTER VARYING(40) 40
6 BANK_CODE CHARACTER VARYING(4) 4
7 BANKING_TYPE CHARACTER VARYING(6) 6
8 BUSINESS_UNIT CHARACTER VARYING(7) 7
9 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
10 APPLICANT_ID CHARACTER VARYING(50) 50
11 IS_PRIMARY_APPLICANT CHARACTER(1) 1
12 PARTY_TYPE CHARACTER VARYING(50) 50
13 ENTITY_STATUS CHARACTER VARYING(1) 1
14 APPLICATION_BRANCH CHARACTER VARYING(10) 10
15 APPLICATION_STATUS CHARACTER VARYING(50) 50
16 APPLICATION_CREATION_DATE TIMESTAMP 8
17 SUBMISSION_CREATION_DATE TIMESTAMP 8
18 APPLICATION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
19 DECISION_DATE TIMESTAMP 8
20 DECISION_ID CHARACTER VARYING(50) 50
21 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
22 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
23 SUBMISSION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
24 SUBMISSION_CREATED_BY CHARACTER VARYING(254) 254
25 SUBMISSION_BRANCH CHARACTER VARYING(10) 10
26 SUBMISSION_DATE TIMESTAMP 8
27 SUBMISSION_STATUS CHARACTER VARYING(50) 50
28 WORKFLOW_ACTION CHARACTER VARYING(50) 50
29 WORKFLOW_STATUS CHARACTER VARYING(50) 50
30 OFFER_ID CHARACTER VARYING(40) 40
31 PRODUCT_CODE CHARACTER VARYING(50) 50
32 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
33 CCY_CODE CHARACTER VARYING(3) 3
34 SUBMISSION_LAST_UPDATED_BY CHARACTER VARYING(254) 254
35 CDTL_APPROVAL_DATE TIMESTAMP 8
36 UNCDTL_APPROVAL_DATE TIMESTAMP 8
37 CDTL_APPROVED_OFFICER CHARACTER VARYING(254) 254
38 UNCDTL_APPROVED_OFFICER CHARACTER VARYING(254) 254
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
41 CDC_RECORD_TYPE CHARACTER VARYING(6) 6
42 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3