INT_OBP_HST_FLX_PI_PARTIES_B_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_OBP_HST_FLX_PI_PARTIES_B

Columns
# Name Data Type Length
1 PARTY_ID CHARACTER VARYING(40) 40
2 PARTY_TYPE CHARACTER(3) 3
3 ONBOARDING_DATE TIMESTAMP 8
4 ALTERNATE_PARTY_ID CHARACTER VARYING(40) 40
5 INCOME_TAX_NUMBER CHARACTER VARYING(40) 40
6 EMAIL_ID CHARACTER VARYING(120) 120
7 WEB_SITE CHARACTER VARYING(360) 360
8 BANKRUPTCY_FLAG CHARACTER(1) 1
9 COUNTRY_OF_ORIGIN_ID CHARACTER VARYING(90) 90
10 PHONE_COUNTRY_CODE CHARACTER VARYING(10) 10
11 PHONE_AREA_CODE CHARACTER VARYING(10) 10
12 PHONE_NUMBER CHARACTER VARYING(20) 20
13 PHONE_EXTENSION CHARACTER VARYING(10) 10
14 ONBOARDING_CHANNEL_ID CHARACTER VARYING(40) 40
15 INFORMATION_SOURCE_TXT CHARACTER VARYING(255) 255
16 BIRTH_PLACE CHARACTER VARYING(60) 60
17 LANGUAGE_ID CHARACTER VARYING(30) 30
18 BIRTH_DATE TIMESTAMP 8
19 GENDER_TYPE CHARACTER(3) 3
20 DOMICILE CHARACTER VARYING(50) 50
21 NATIONALITY_ID CHARACTER VARYING(30) 30
22 INCOME_CATEGORY_ID CHARACTER VARYING(30) 30
23 MOBILE_COUNTRY_CODE CHARACTER VARYING(10) 10
24 MOBILE_NUMBER CHARACTER VARYING(45) 45
25 NON_RESIDENT_FLAG CHARACTER(1) 1
26 DISABLED_FLAG CHARACTER(1) 1
27 FLG_BANK_EMPLOYEE CHARACTER(1) 1
28 DEMISE_DATE TIMESTAMP 8
29 HEIGHT_IN_CM DOUBLE PRECISION 8
30 WEIGHT_IN_KG DOUBLE PRECISION 8
31 BLOOD_GROUP_TYPE CHARACTER VARYING(4) 4
32 DISEASES_DESC CHARACTER VARYING(120) 120
33 DISEASES CHARACTER VARYING(120) 120
34 MOTHER_MAIDEN_NAME CHARACTER VARYING(120) 120
35 INDUSTRY_TYPE CHARACTER VARYING(50) 50
36 OCCUPATION_TYPE CHARACTER VARYING(50) 50
37 ETHNICITY CHARACTER VARYING(30) 30
38 RACE CHARACTER VARYING(30) 30
39 RELIGION CHARACTER VARYING(30) 30
40 SWIFT_ID CHARACTER VARYING(30) 30
41 BIC_ID CHARACTER VARYING(30) 30
42 INCORPORATION_DATE TIMESTAMP 8
43 COMMENCEMENT_DATE TIMESTAMP 8
44 HOLDING_PATTERN_TYPE CHARACTER(3) 3
45 PLACE_OF_INCORPORATION CHARACTER VARYING(90) 90
46 COUNTRY_INCORPORATION CHARACTER VARYING(90) 90
47 EMPLOYEE_STRENGTH CHARACTER VARYING(15) 15
48 BUSINESS_CATEGORY_ID CHARACTER VARYING(30) 30
49 NO_YEARS_IN_BUSINESS DOUBLE PRECISION 8
50 NO_OF_CUSTOMERS DOUBLE PRECISION 8
51 NO_OF_VENDORS DOUBLE PRECISION 8
52 COUNTRIES_EXPOSED_TO_TXT CHARACTER VARYING(120) 120
53 BUSINESS_DESC CHARACTER VARYING(120) 120
54 CONTACT_PERSON_NAME CHARACTER VARYING(360) 360
55 CONTACT_PERSON_DESIG CHARACTER VARYING(120) 120
56 CONTACT_PERSON_EMAIL CHARACTER VARYING(360) 360
57 CONTACT_PERSON_MOBILENO CHARACTER VARYING(45) 45
58 CONTACT_PERSON_LANDLINENO CHARACTER VARYING(120) 120
59 SMOKING_INDICATOR CHARACTER(1) 1
60 IS_BLACKLISTED CHARACTER(1) 1
61 TRUSTEE_TYPE CHARACTER(3) 3
62 NUMBER_OF_TRUSTEES SMALLINT 2
63 NUMBER_OF_DIRECTORS SMALLINT 2
64 HAS_LISTED_SECRETARY CHARACTER(1) 1
65 NO_OF_SHARES_HELD BIGINT 8
66 FLG_STARTUP_BUSINESS CHARACTER(1) 1
67 FLG_OWNER_ATLEAST_TWO_YEARS CHARACTER(1) 1
68 FLG_SHARE_HOLDER_OF_BANK CHARACTER(1) 1
69 OWNERSHIP_PERCENTAGE BIGINT 8
70 CREATED_BY CHARACTER VARYING(254) 254
71 CREATION_DATE TIMESTAMP 8
72 LAST_UPDATED_BY CHARACTER VARYING(254) 254
73 LAST_UPDATE_DATE TIMESTAMP 8
74 OBJECT_VERSION_NUMBER INTEGER 4
75 OBJECT_STATUS_FLAG CHARACTER(1) 1
76 DETERMINANT_VALUE CHARACTER VARYING(40) 40
77 RETIREMENT_DATE TIMESTAMP 8
78 EMERGENCY_CONTACT_DETAILS CHARACTER VARYING(300) 300
79 FLG_CUST_DELINQUENT CHARACTER(1) 1
80 FLG_IN_COLLECTIONS CHARACTER(1) 1
81 FLG_FINANCIAL_HARDSHIP CHARACTER(1) 1
82 RELIEF_EXPIRY_DATE TIMESTAMP 8
83 RESIDENT_STATUS_ID CHARACTER VARYING(10) 10
84 NO_OF_FINANCIAL_DEPENDENTS CHARACTER(2) 2
85 HONORS CHARACTER VARYING(80) 80
86 ADDRESS_TYPE CHARACTER(5) 5
87 RELATIONSHIP_MANAGER_ID CHARACTER VARYING(30) 30
88 RELATIONSHIP_MANAGER_NAME CHARACTER VARYING(255) 255
89 PREFERRED_CONTACT_FREQUENCY CHARACTER VARYING(20) 20
90 PREFERRED_CONTACT CHARACTER VARYING(30) 30
91 WORK_PHONE_NUMBER CHARACTER VARYING(45) 45
92 ORGANIZATION_TYPE CHARACTER VARYING(10) 10
93 ORGANIZATION_STATUS CHARACTER VARYING(50) 50
94 ABN_STATUS_INDICATOR CHARACTER VARYING(50) 50
95 ORGANIZATION_DESCRIPTION CHARACTER VARYING(50) 50
96 IND_CLASSIFICATION_CODE_DESC CHARACTER VARYING(500) 500
97 ESTABLISHMENT_DATE TIMESTAMP 8
98 COUNTRY_OF_ESTABLISHMENT CHARACTER VARYING(50) 50
99 CGUID CHARACTER VARYING(50) 50
100 IND_CLASSIFICATION_CODE CHARACTER VARYING(50) 50
101 CORPORATE_TYPE CHARACTER(10) 10
102 CONTRACT_DETAILS CHARACTER VARYING(120) 120
103 VALUATION_TYPE_CODE CHARACTER VARYING(120) 120
104 VALUATION_ASSET_TYPE CHARACTER VARYING(120) 120
105 CONTRACT_START_DATE TIMESTAMP 8
106 CONTRACT_END_DATE TIMESTAMP 8
107 NO_OF_BRANCHES DOUBLE PRECISION 8
108 DISCLOSE_RES_DTLS_FLAG CHARACTER(1) 1
109 RESIDENCY_CHNG_DATE TIMESTAMP 8
110 FOREIGN_COUNTRY_FOR_TAX CHARACTER VARYING(90) 90
111 FOREIGN_COUNTRY_TIN CHARACTER VARYING(40) 40
112 PARTY_STATUS CHARACTER VARYING(20) 20
113 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
114 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
115 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
116 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8