INT_OBP_FLX_PI_PARTIES_B_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

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