OBP24_HST_FLX_IF_PARTY_DETAILS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PARTY_CODE CHARACTER VARYING(40) 40
2 PARTY_TYPE CHARACTER VARYING(3) 3
3 SALUTATION_TYPE CHARACTER VARYING(30) 30
4 FIRST_NAME CHARACTER VARYING(50) 50
5 MIDDLE_NAME CHARACTER VARYING(50) 50
6 LAST_NAME CHARACTER VARYING(50) 50
7 GENDER_TYPE CHARACTER VARYING(20) 20
8 BIRTH_DATE TIMESTAMP 8
9 CURRENT_AGE_NUM DOUBLE PRECISION 8
10 EDUCATION_NAME CHARACTER VARYING(120) 120
11 MARITAL_STATUS CHARACTER VARYING(20) 20
12 ANNIVERSARY_DATE TIMESTAMP 8
13 AGE_ON_BOOK_NUM DOUBLE PRECISION 8
14 DEPENDENTS_NUM DOUBLE PRECISION 8
15 NATIONALITY_CODE CHARACTER VARYING(30) 30
16 BANK_CODE CHARACTER VARYING(10) 10
17 BRANCH_CODE CHARACTER VARYING(10) 10
18 CLASS_CODE CHARACTER VARYING(40) 40
19 CHANNEL_CODE CHARACTER VARYING(40) 40
20 SSN_NUM CHARACTER VARYING(30) 30
21 CLOSED_DATE TIMESTAMP 8
22 ONBOARDING_DATE TIMESTAMP 8
23 INCORPORATION_DATE TIMESTAMP 8
24 DEMISE_FLAG CHARACTER VARYING(1) 1
25 FIRST_ACCOUNT_FLAG CHARACTER VARYING(5) 5
26 CLOSED_FLAG CHARACTER VARYING(1) 1
27 NEW_CUST_FLAG CHARACTER VARYING(1) 1
28 REFERRED_FLAG CHARACTER VARYING(1) 1
29 EMPLOYER_NAME CHARACTER VARYING(120) 120
30 JOINING_AGE_NUM DOUBLE PRECISION 8
31 GROSS_INCOME_AMT DOUBLE PRECISION 8
32 EMPLOYED_START_DATE TIMESTAMP 8
33 PROFESSION_NAME CHARACTER VARYING(120) 120
34 OFFICER_CODE CHARACTER VARYING(40) 40
35 SELF_EMP_FLAG CHARACTER VARYING(1) 1
36 STAFF_FLAG CHARACTER VARYING(1) 1
37 TAX_ASSESSEE_FLAG CHARACTER VARYING(1) 1
38 DESIGNATION_TXT CHARACTER VARYING(120) 120
39 INDUSTRY_CODE CHARACTER VARYING(30) 30
40 MIS_CODE_1 CHARACTER VARYING(9) 9
41 MIS_CLASS_CODE_1 CHARACTER VARYING(9) 9
42 MIS_CODE_2 CHARACTER VARYING(9) 9
43 MIS_CLASS_CODE_2 CHARACTER VARYING(9) 9
44 MIS_CODE_3 CHARACTER VARYING(9) 9
45 MIS_CLASS_CODE_3 CHARACTER VARYING(9) 9
46 MIS_CODE_4 CHARACTER VARYING(9) 9
47 MIS_CLASS_CODE_4 CHARACTER VARYING(9) 9
48 MIS_CODE_5 CHARACTER VARYING(9) 9
49 MIS_CLASS_CODE_5 CHARACTER VARYING(9) 9
50 MIS_CODE_6 CHARACTER VARYING(9) 9
51 MIS_CLASS_CODE_6 CHARACTER VARYING(9) 9
52 MIS_CODE_7 CHARACTER VARYING(9) 9
53 MIS_CLASS_CODE_7 CHARACTER VARYING(9) 9
54 MIS_CODE_8 CHARACTER VARYING(9) 9
55 MIS_CLASS_CODE_8 CHARACTER VARYING(9) 9
56 MIS_CODE_9 CHARACTER VARYING(9) 9
57 MIS_CLASS_CODE_9 CHARACTER VARYING(9) 9
58 MIS_CODE_10 CHARACTER VARYING(9) 9
59 MIS_CLASS_CODE_10 CHARACTER VARYING(9) 9
60 RES_ADDR_LINE1_TXT CHARACTER VARYING(120) 120
61 RES_ADDR_LINE2_TXT CHARACTER VARYING(120) 120
62 RES_ADDR_LINE3_TXT CHARACTER VARYING(120) 120
63 RES_ADDR_LINE4_TXT CHARACTER VARYING(120) 120
64 RES_ADDR_LINE5_TXT CHARACTER VARYING(120) 120
65 RES_ADDR_CITY_NAME CHARACTER VARYING(105) 105
66 RES_ADDR_STATE_NAME CHARACTER VARYING(105) 105
67 RES_ADDR_COUNTRY_NAME CHARACTER VARYING(105) 105
68 RES_ADDR_ZIP_CODE CHARACTER VARYING(10) 10
69 RES_TEL_NUM CHARACTER VARYING(20) 20
70 RES_TEL_AREA_CODE CHARACTER VARYING(15) 15
71 RES_TEL_COUNTRY_CODE CHARACTER VARYING(10) 10
72 RES_FAX_NUM CHARACTER VARYING(20) 20
73 OFF_ADDR_LINE1_TXT CHARACTER VARYING(120) 120
74 OFF_ADDR_LINE2_TXT CHARACTER VARYING(120) 120
75 OFF_ADDR_LINE3_TXT CHARACTER VARYING(120) 120
76 OFF_ADDR_LINE4_TXT CHARACTER VARYING(120) 120
77 OFF_ADDR_LINE5_TXT CHARACTER VARYING(120) 120
78 OFF_ADDR_LINE6_TXT CHARACTER VARYING(120) 120
79 OFF_ADDR_LINE7_TXT CHARACTER VARYING(120) 120
80 OFF_ADDR_CITY_NAME CHARACTER VARYING(105) 105
81 OFF_ADDR_STATE_NAME CHARACTER VARYING(105) 105
82 OFF_ADDR_COUNTRY_NAME CHARACTER VARYING(105) 105
83 OFF_ADDR_ZIP_CODE CHARACTER VARYING(10) 10
84 OFF_TEL_NUM CHARACTER VARYING(20) 20
85 OFF_TEL_AREA_CODE CHARACTER VARYING(15) 15
86 OFF_TEL_COUNTRY_CODE CHARACTER VARYING(10) 10
87 OFF_FAX_NUM CHARACTER VARYING(20) 20
88 CUR_ADDR_LINE1_TXT CHARACTER VARYING(120) 120
89 CUR_ADDR_LINE2_TXT CHARACTER VARYING(120) 120
90 CUR_ADDR_LINE3_TXT CHARACTER VARYING(120) 120
91 CUR_ADDR_ZIP_CODE CHARACTER VARYING(10) 10
92 EMAIL_ADDR_TXT CHARACTER VARYING(120) 120
93 WEB_SITE_ADDR_TXT CHARACTER VARYING(255) 255
94 RESIDENCE_TYPE CHARACTER VARYING(120) 120
95 HOME_OWNERSHIP_TYPE CHARACTER VARYING(120) 120
96 REGION_CODE CHARACTER VARYING(5) 5
97 BANKRUPTCY_FLAG CHARACTER(1) 1
98 NAICS_CODE CHARACTER VARYING(6) 6
99 ATM_MAX_WTHDRWL_LIAB_ACCT DOUBLE PRECISION 8
100 FOREIGN_PUBLIC_OFFICIAL_FLAG CHARACTER(1) 1
101 RETIREMENT_YEAR DOUBLE PRECISION 8
102 HARDSHIP_IND CHARACTER(1) 1
103 LOCATION_CODE CHARACTER VARYING(20) 20
104 FRAUD_FLAG CHARACTER(1) 1
105 CUST_EMPLOYMENT_TYPE_CODE CHARACTER VARYING(20) 20
106 CUSTOMER_PARENT_GROUP_NAME CHARACTER VARYING(30) 30
107 BUSINESS_DOMAIN CHARACTER VARYING(60) 60
108 COMPENSATION_FLAG CHARACTER(1) 1
109 PWD_LAST_CHANGE_DATE TIMESTAMP 8
110 DATA_JURISDICTION CHARACTER VARYING(5) 5
111 MINOR_FLAG CHARACTER(1) 1
112 PARTNER_CODE CHARACTER VARYING(20) 20
113 FACEBOOK_ADDRESS CHARACTER VARYING(100) 100
114 HOUSEHOLD_CODE CHARACTER VARYING(20) 20
115 GOOGLEPLUS_ADDRESS CHARACTER VARYING(100) 100
116 TWITTER_ADDRESS CHARACTER VARYING(100) 100
117 FINANCIAL_STMT_DISCLOSURE_FLAG CHARACTER(1) 1
118 FOREIGN_TAX_REP_CERT_FLAG CHARACTER(1) 1
119 THIRD_PARTY_CREDIT_REP_FLAG CHARACTER(1) 1
120 DATA_ORIGIN CHARACTER VARYING(20) 20
121 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
122 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
123 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
124 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8