OCH24_S_CONTACT
Description
Synonyms
SDSNZP05_BANK..CBP_OCH_S_CONTACT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ROW_ID | CHARACTER VARYING(15) | 15 |
| 2 | CREATED | TIMESTAMP | 8 |
| 3 | CREATED_BY | CHARACTER VARYING(15) | 15 |
| 4 | LAST_UPD | TIMESTAMP | 8 |
| 5 | LAST_UPD_BY | CHARACTER VARYING(15) | 15 |
| 6 | DCKING_NUM | NUMERIC(22,7) | 19 |
| 7 | MODIFICATION_NUM | BIGINT | 8 |
| 8 | CONFLICT_ID | CHARACTER VARYING(15) | 15 |
| 9 | PAR_ROW_ID | CHARACTER VARYING(15) | 15 |
| 10 | ACTIVE_FLG | CHARACTER(1) | 1 |
| 11 | BU_ID | CHARACTER VARYING(15) | 15 |
| 12 | COURT_PAY_FLG | CHARACTER(1) | 1 |
| 13 | DISA_CLEANSE_FLG | CHARACTER(1) | 1 |
| 14 | DISP_IMG_AUTH_FLG | CHARACTER(1) | 1 |
| 15 | EMAIL_SR_UPD_FLG | CHARACTER(1) | 1 |
| 16 | EMP_FLG | CHARACTER(1) | 1 |
| 17 | FST_NAME | CHARACTER VARYING(50) | 50 |
| 18 | INVSTGTR_FLG | CHARACTER(1) | 1 |
| 19 | LAST_NAME | CHARACTER VARYING(50) | 50 |
| 20 | ONDEMAND_SYNC_FLG | CHARACTER(1) | 1 |
| 21 | PERSON_UID | CHARACTER VARYING(100) | 100 |
| 22 | PO_PAY_FLG | CHARACTER(1) | 1 |
| 23 | PRIV_FLG | CHARACTER(1) | 1 |
| 24 | PROSPECT_FLG | CHARACTER(1) | 1 |
| 25 | PTSHP_CONTACT_FLG | CHARACTER(1) | 1 |
| 26 | PTSHP_KEY_CON_FLG | CHARACTER(1) | 1 |
| 27 | SEND_SURVEY_FLG | CHARACTER(1) | 1 |
| 28 | SPEAKER_FLG | CHARACTER(1) | 1 |
| 29 | SUPPRESS_EMAIL_FLG | CHARACTER(1) | 1 |
| 30 | SUPPRESS_FAX_FLG | CHARACTER(1) | 1 |
| 31 | SUSPECT_FLG | CHARACTER(1) | 1 |
| 32 | SUSP_WTCH_FLG | CHARACTER(1) | 1 |
| 33 | VETERAN_FLG | CHARACTER(1) | 1 |
| 34 | AGENT_FLG | CHARACTER(1) | 1 |
| 35 | ENTERPRISE_FLAG | CHARACTER(1) | 1 |
| 36 | MEMBER_FLG | CHARACTER(1) | 1 |
| 37 | OK_TO_SAMPLE_FLG | CHARACTER(1) | 1 |
| 38 | PROVIDER_FLG | CHARACTER(1) | 1 |
| 39 | PR_REP_DNRM_FLG | CHARACTER(1) | 1 |
| 40 | PR_REP_MANL_FLG | CHARACTER(1) | 1 |
| 41 | PR_REP_SYS_FLG | CHARACTER(1) | 1 |
| 42 | SEND_FIN_FLG | CHARACTER(1) | 1 |
| 43 | SEND_NEWS_FLG | CHARACTER(1) | 1 |
| 44 | SEND_PROMOTES_FLG | CHARACTER(1) | 1 |
| 45 | SUPPRESS_CALL_FLG | CHARACTER(1) | 1 |
| 46 | SUPPRESS_MAIL_FLG | CHARACTER(1) | 1 |
| 47 | AGE | NUMERIC(22,7) | 19 |
| 48 | ANNL_INCM_AMT | NUMERIC(22,7) | 19 |
| 49 | ANNL_INCM_EXCH_DT | TIMESTAMP | 8 |
| 50 | ASGN_DT | TIMESTAMP | 8 |
| 51 | ASGN_EXCLD_FLG2 | CHARACTER(1) | 1 |
| 52 | ASGN_REQUIRED_FLG2 | CHARACTER(1) | 1 |
| 53 | ASGN_USR_EXCLD_FLG | CHARACTER(1) | 1 |
| 54 | BIRTH_DT | TIMESTAMP | 8 |
| 55 | CALL_FLG | CHARACTER(1) | 1 |
| 56 | CONSUMER_FLG | CHARACTER(1) | 1 |
| 57 | CON_CREATED_DT | TIMESTAMP | 8 |
| 58 | CREDIT_SCORE | NUMERIC(22,7) | 19 |
| 59 | CUST_END_DT | TIMESTAMP | 8 |
| 60 | CUST_SINCE_DT | TIMESTAMP | 8 |
| 61 | DB_LAST_UPD | TIMESTAMP | 8 |
| 62 | DEATH_DT | TIMESTAMP | 8 |
| 63 | DEDUP_DATACLNSD_DT | TIMESTAMP | 8 |
| 64 | DEDUP_KEY_UPD_DT | TIMESTAMP | 8 |
| 65 | DEDUP_LAST_MTCH_DT | TIMESTAMP | 8 |
| 66 | HARD_TO_REACH | CHARACTER(1) | 1 |
| 67 | INVES_START_DT | TIMESTAMP | 8 |
| 68 | INV_ORG_ST_DT | TIMESTAMP | 8 |
| 69 | LAST_CREDIT_DT | TIMESTAMP | 8 |
| 70 | LATITUDE | NUMERIC(22,7) | 19 |
| 71 | LONGITUDE | NUMERIC(22,7) | 19 |
| 72 | LST_EMLADR_UPD_TS | TIMESTAMP | 8 |
| 73 | MARITAL_STAT_DT | TIMESTAMP | 8 |
| 74 | MGMNT_FLG | CHARACTER(1) | 1 |
| 75 | NUM_HARD_BNCE | BIGINT | 8 |
| 76 | NUM_SOFT_BNCE | BIGINT | 8 |
| 77 | SEMINAR_INVIT_FLG | CHARACTER(1) | 1 |
| 78 | ACTIVE_CTI_CFG_ID | CHARACTER VARYING(15) | 15 |
| 79 | ACTIVE_TELESET_ID | CHARACTER VARYING(15) | 15 |
| 80 | AIA_INTEG1_ID | CHARACTER VARYING(500) | 500 |
| 81 | AIA_INTEG_ID | CHARACTER VARYING(150) | 150 |
| 82 | ALIAS_NAME | CHARACTER VARYING(50) | 50 |
| 83 | ALT_EMAIL_ADDR | CHARACTER VARYING(50) | 50 |
| 84 | ALT_EMAIL_LOC_CD | CHARACTER VARYING(30) | 30 |
| 85 | ALT_PH_NUM | CHARACTER VARYING(40) | 40 |
| 86 | ANNL_INCM_CURCY_CD | CHARACTER VARYING(20) | 20 |
| 87 | APPROVAL_STATUS_CD | CHARACTER VARYING(30) | 30 |
| 88 | AREA_ID | CHARACTER VARYING(15) | 15 |
| 89 | ASST_PH_NUM | CHARACTER VARYING(40) | 40 |
| 90 | CALL_FREQUENCY | CHARACTER VARYING(30) | 30 |
| 91 | CELL_PH_NUM | CHARACTER VARYING(40) | 40 |
| 92 | CITIZENSHIP_CD | CHARACTER VARYING(30) | 30 |
| 93 | COMMENTS | CHARACTER VARYING(255) | 255 |
| 94 | COMPLEXION_CD | CHARACTER VARYING(30) | 30 |
| 95 | CONSUMER_REF_ID | CHARACTER VARYING(15) | 15 |
| 96 | CON_ASST_NAME | CHARACTER VARYING(50) | 50 |
| 97 | CON_ASST_PER_ID | CHARACTER VARYING(15) | 15 |
| 98 | CON_CD | CHARACTER VARYING(30) | 30 |
| 99 | CON_EXPER_CD | CHARACTER VARYING(30) | 30 |
| 100 | CON_IMAGE_ID | CHARACTER VARYING(15) | 15 |
| 101 | CON_INFLUNC_ID | CHARACTER VARYING(15) | 15 |
| 102 | CON_MANAGER_NAME | CHARACTER VARYING(50) | 50 |
| 103 | CON_MANAGER_PER_ID | CHARACTER VARYING(15) | 15 |
| 104 | CORP_PTRNL_LSTNAME | CHARACTER VARYING(50) | 50 |
| 105 | COUNTRY_TEMPLATE | CHARACTER VARYING(15) | 15 |
| 106 | CREATOR_LOGIN | CHARACTER VARYING(50) | 50 |
| 107 | CREDIT_AGENCY | CHARACTER VARYING(30) | 30 |
| 108 | CSN | CHARACTER VARYING(50) | 50 |
| 109 | CURR_PRI_LST_ID | CHARACTER VARYING(15) | 15 |
| 110 | CUST_STAT_CD | CHARACTER VARYING(30) | 30 |
| 111 | CUST_VALUE_CD | CHARACTER VARYING(30) | 30 |
| 112 | DB_LAST_UPD_SRC | CHARACTER VARYING(50) | 50 |
| 113 | DEATH_CERT_NUM | CHARACTER VARYING(30) | 30 |
| 114 | DECISION_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 115 | DEDUP_TOKEN | CHARACTER VARYING(100) | 100 |
| 116 | DEGREE | CHARACTER VARYING(30) | 30 |
| 117 | DFLT_ORDER_PROC_CD | CHARACTER VARYING(30) | 30 |
| 118 | EMAIL_ADDR | CHARACTER VARYING(100) | 100 |
| 119 | EMAIL_LOC_CD | CHARACTER VARYING(30) | 30 |
| 120 | EMAIL_STATUS_CD | CHARACTER VARYING(30) | 30 |
| 121 | EMPLMNT_STAT_CD | CHARACTER VARYING(30) | 30 |
| 122 | EMP_ID | CHARACTER VARYING(15) | 15 |
| 123 | EMP_NUM | CHARACTER VARYING(30) | 30 |
| 124 | EMP_WORK_LOC_NAME | CHARACTER VARYING(50) | 50 |
| 125 | ETHNICITY_CD | CHARACTER VARYING(30) | 30 |
| 126 | EYE_COLOR | CHARACTER VARYING(30) | 30 |
| 127 | FAX_PH_NUM | CHARACTER VARYING(40) | 40 |
| 128 | FURI_PTRNL_LSTNAME | CHARACTER VARYING(50) | 50 |
| 129 | HAIR_COLOR | CHARACTER VARYING(30) | 30 |
| 130 | HEIGHT | CHARACTER VARYING(20) | 20 |
| 131 | HEIGHT_UOM_CD | CHARACTER VARYING(30) | 30 |
| 132 | HOME_PH_NUM | CHARACTER VARYING(40) | 40 |
| 133 | INDUST_ID | CHARACTER VARYING(15) | 15 |
| 134 | INTEGRATION_ID | CHARACTER VARYING(30) | 30 |
| 135 | JOB_TITLE | CHARACTER VARYING(75) | 75 |
| 136 | LEFT_EYE_CLR_CD | CHARACTER VARYING(30) | 30 |
| 137 | LOGIN | CHARACTER VARYING(50) | 50 |
| 138 | MAIDEN_NAME | CHARACTER VARYING(50) | 50 |
| 139 | MARITAL_STAT_CD | CHARACTER VARYING(30) | 30 |
| 140 | MED_SPEC_ID | CHARACTER VARYING(15) | 15 |
| 141 | MID_NAME | CHARACTER VARYING(50) | 50 |
| 142 | MOTHER_MAIDEN_NAME | CHARACTER VARYING(50) | 50 |
| 143 | MSTR_CASE_ID | CHARACTER VARYING(15) | 15 |
| 144 | NATIONALITY | CHARACTER VARYING(30) | 30 |
| 145 | NEW_USER_RESP_NAME | CHARACTER VARYING(50) | 50 |
| 146 | NICK_NAME | CHARACTER VARYING(50) | 50 |
| 147 | OCCUPATION | CHARACTER VARYING(50) | 50 |
| 148 | OD_LAST_UPD_BY | CHARACTER VARYING(125) | 125 |
| 149 | OU_ID | CHARACTER VARYING(15) | 15 |
| 150 | OU_MAIL_STOP | CHARACTER VARYING(30) | 30 |
| 151 | OWNER_LOGIN | CHARACTER VARYING(50) | 50 |
| 152 | OWNER_PER_ID | CHARACTER VARYING(15) | 15 |
| 153 | PAGER_COMPANY_ID | CHARACTER VARYING(15) | 15 |
| 154 | PAGER_NUM | CHARACTER VARYING(40) | 40 |
| 155 | PAGER_PH_NUM | CHARACTER VARYING(40) | 40 |
| 156 | PAGER_PIN | CHARACTER VARYING(40) | 40 |
| 157 | PAGER_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 158 | PASSWORD | CHARACTER VARYING(20) | 20 |
| 159 | PATERNAL_LAST_NAME | CHARACTER VARYING(50) | 50 |
| 160 | PER_TITLE | CHARACTER VARYING(15) | 15 |
| 161 | PER_TITLE_SUFFIX | CHARACTER VARYING(15) | 15 |
| 162 | PLACE_OF_BIRTH | CHARACTER VARYING(100) | 100 |
| 163 | PLACE_OF_DEATH | CHARACTER VARYING(50) | 50 |
| 164 | POSTN_CD | CHARACTER VARYING(30) | 30 |
| 165 | PRACTICE_TYPE | CHARACTER VARYING(30) | 30 |
| 166 | PREF_COMM_MEDIA_CD | CHARACTER VARYING(30) | 30 |
| 167 | PREF_COMM_METH_CD | CHARACTER VARYING(30) | 30 |
| 168 | PREF_LANG_ID | CHARACTER VARYING(15) | 15 |
| 169 | PREF_LOCALE_ID | CHARACTER VARYING(15) | 15 |
| 170 | PREF_SALE_DLR_ID | CHARACTER VARYING(15) | 15 |
| 171 | PRESENCE_URI | CHARACTER VARYING(100) | 100 |
| 172 | PRIVACY_CD | CHARACTER VARYING(30) | 30 |
| 173 | PR_ACT_ID | CHARACTER VARYING(15) | 15 |
| 174 | PR_AFFL_ID | CHARACTER VARYING(15) | 15 |
| 175 | PR_ALT_PH_NUM_ID | CHARACTER VARYING(15) | 15 |
| 176 | PR_ASSET_ID | CHARACTER VARYING(15) | 15 |
| 177 | PR_BL_PER_ADDR_ID | CHARACTER VARYING(15) | 15 |
| 178 | PR_CLIENT_OU_ID | CHARACTER VARYING(15) | 15 |
| 179 | PR_COMM_LANG_ID | CHARACTER VARYING(15) | 15 |
| 180 | PR_CON_ADDR_ID | CHARACTER VARYING(15) | 15 |
| 181 | PR_CST_ACCNT_ID | CHARACTER VARYING(15) | 15 |
| 182 | PR_CTI_CFG_ID | CHARACTER VARYING(15) | 15 |
| 183 | PR_DEPT_OU_ID | CHARACTER VARYING(15) | 15 |
| 184 | PR_DRVR_LICENSE_ID | CHARACTER VARYING(15) | 15 |
| 185 | PR_EMAIL_ADDR_ID | CHARACTER VARYING(15) | 15 |
| 186 | PR_FACILITY_ID | CHARACTER VARYING(15) | 15 |
| 187 | PR_GRP_OU_ID | CHARACTER VARYING(15) | 15 |
| 188 | PR_HELD_POSTN_ID | CHARACTER VARYING(15) | 15 |
| 189 | PR_IMAGE_ID | CHARACTER VARYING(15) | 15 |
| 190 | PR_INDUST_ID | CHARACTER VARYING(15) | 15 |
| 191 | PR_MKT_SEG_ID | CHARACTER VARYING(15) | 15 |
| 192 | PR_NOTE_ID | CHARACTER VARYING(15) | 15 |
| 193 | PR_OPTY_ID | CHARACTER VARYING(15) | 15 |
| 194 | PR_OU_ADDR_ID | CHARACTER VARYING(15) | 15 |
| 195 | PR_PER_ADDR_ID | CHARACTER VARYING(15) | 15 |
| 196 | PR_PER_PAY_PRFL_ID | CHARACTER VARYING(15) | 15 |
| 197 | PR_PHONE_ID | CHARACTER VARYING(15) | 15 |
| 198 | PR_POSTN_ID | CHARACTER VARYING(15) | 15 |
| 199 | PR_PROD_ID | CHARACTER VARYING(15) | 15 |
| 200 | PR_PROD_LN_ID | CHARACTER VARYING(15) | 15 |
| 201 | PR_REGION_ID | CHARACTER VARYING(15) | 15 |
| 202 | PR_RESP_ID | CHARACTER VARYING(15) | 15 |
| 203 | PR_SECURITY_ID | CHARACTER VARYING(15) | 15 |
| 204 | PR_SH_PER_ADDR_ID | CHARACTER VARYING(15) | 15 |
| 205 | PR_SPECIALTY_ID | CHARACTER VARYING(15) | 15 |
| 206 | PR_STATE_LIC_ID | CHARACTER VARYING(15) | 15 |
| 207 | PR_SYNC_USER_ID | CHARACTER VARYING(15) | 15 |
| 208 | PR_TERR_ID | CHARACTER VARYING(15) | 15 |
| 209 | PR_USERROLE_ID | CHARACTER VARYING(15) | 15 |
| 210 | RACE | CHARACTER VARYING(30) | 30 |
| 211 | RATING | CHARACTER VARYING(30) | 30 |
| 212 | REGION_ID | CHARACTER VARYING(15) | 15 |
| 213 | REGL_STAT_CD | CHARACTER VARYING(30) | 30 |
| 214 | RELIABILITY_CD | CHARACTER VARYING(30) | 30 |
| 215 | RESIDENT_STAT_CD | CHARACTER VARYING(30) | 30 |
| 216 | RIGHT_EYE_CLR_CD | CHARACTER VARYING(30) | 30 |
| 217 | ROUTE | CHARACTER VARYING(30) | 30 |
| 218 | SEC_ANSWR | CHARACTER VARYING(50) | 50 |
| 219 | SEC_QUEST_CD | CHARACTER VARYING(30) | 30 |
| 220 | SEX_MF | CHARACTER VARYING(30) | 30 |
| 221 | SOC_SECURITY_NUM | CHARACTER VARYING(20) | 20 |
| 222 | SPOUSE_LAST_NAME | CHARACTER VARYING(50) | 50 |
| 223 | SRC_ID | CHARACTER VARYING(15) | 15 |
| 224 | STATUS_CD | CHARACTER VARYING(30) | 30 |
| 225 | STAT_REASON_CD | CHARACTER VARYING(30) | 30 |
| 226 | STOCK_PORTFOLIO | CHARACTER VARYING(500) | 500 |
| 227 | SUB_SPEC_ID | CHARACTER VARYING(15) | 15 |
| 228 | SVC_BRANCH_ID | CHARACTER VARYING(15) | 15 |
| 229 | TIMEZONE_ID | CHARACTER VARYING(15) | 15 |
| 230 | TMZONE_CD | CHARACTER VARYING(30) | 30 |
| 231 | WEATHR_LOC_PREF | CHARACTER VARYING(75) | 75 |
| 232 | WEB_REGION_ID | CHARACTER VARYING(15) | 15 |
| 233 | WEIGHT | CHARACTER VARYING(20) | 20 |
| 234 | WEIGHT_UOM_CD | CHARACTER VARYING(30) | 30 |
| 235 | WORK_PH_NUM | CHARACTER VARYING(40) | 40 |
| 236 | X_CCN | CHARACTER VARYING(30) | 30 |
| 237 | X_CONSENT_VERIFIED | CHARACTER(1) | 1 |
| 238 | X_CREDIT_SCORE | CHARACTER VARYING(22) | 22 |
| 239 | X_CREDIT_SCORE_DT | TIMESTAMP | 8 |
| 240 | X_CRS_MODELTYPE | CHARACTER VARYING(40) | 40 |
| 241 | X_CRS_VERSION | CHARACTER VARYING(10) | 10 |
| 242 | X_DEGREE | CHARACTER VARYING(30) | 30 |
| 243 | X_DISPUTE_DENIAL | CHARACTER(1) | 1 |
| 244 | X_DOMICILE_BRANCH | CHARACTER VARYING(10) | 10 |
| 245 | X_EXIST_CUST | CHARACTER(1) | 1 |
| 246 | X_EXT_CREATED_DT | TIMESTAMP | 8 |
| 247 | X_INDUSTRY | CHARACTER VARYING(30) | 30 |
| 248 | X_KYC_STATUS_CD | CHARACTER VARYING(30) | 30 |
| 249 | X_KYC_TS | TIMESTAMP | 8 |
| 250 | X_KYC_VER_STAGE | CHARACTER VARYING(30) | 30 |
| 251 | X_LAST_UPD_DT | TIMESTAMP | 8 |
| 252 | X_LEGACY_ID | CHARACTER VARYING(30) | 30 |
| 253 | X_LINK_ERROR_MSG | CHARACTER VARYING(500) | 500 |
| 254 | X_LINKED | CHARACTER(1) | 1 |
| 255 | X_MATCH_CALL | CHARACTER(1) | 1 |
| 256 | X_MESSAGE_ID_PUB | CHARACTER VARYING(100) | 100 |
| 257 | X_MESSAGE_ID_SYNC | CHARACTER VARYING(100) | 100 |
| 258 | X_NAB_STAFF | CHARACTER(1) | 1 |
| 259 | X_NEWS_PAPER | CHARACTER VARYING(30) | 30 |
| 260 | X_PLATFORM | CHARACTER VARYING(30) | 30 |
| 261 | X_SEC_ANS | CHARACTER VARYING(100) | 100 |
| 262 | X_SEC_PURPOSE | CHARACTER(1) | 1 |
| 263 | X_SEC_QUES | CHARACTER VARYING(100) | 100 |
| 264 | X_SEGMENT_CD | CHARACTER VARYING(50) | 50 |
| 265 | X_SHARED_INFO | CHARACTER(1) | 1 |
| 266 | X_SRC_CODE | CHARACTER VARYING(40) | 40 |
| 267 | X_STAFF_PARTNER_FLAG | CHARACTER(1) | 1 |
| 268 | X_STAFF_USER_ID | CHARACTER VARYING(30) | 30 |
| 269 | X_SYS_OF_ORIGIN | CHARACTER VARYING(50) | 50 |
| 270 | X_TAX_IDEN_NUM | CHARACTER VARYING(20) | 20 |
| 271 | X_TFN_EXEMPT_DT | TIMESTAMP | 8 |
| 272 | X_USE_COUNT | BIGINT | 8 |
| 273 | X_USR_DEF_QUES | CHARACTER VARYING(100) | 100 |
| 274 | X_VALUE_GROUP | CHARACTER VARYING(50) | 50 |
| 275 | X_WORKPLACE | CHARACTER VARYING(50) | 50 |
| 276 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 277 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 278 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 279 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |
| 280 | X_DELETED_CHILD | CHARACTER VARYING(100) | 100 |
| 281 | X_BATCH_PUBLISH | CHARACTER(1) | 1 |
| 282 | X_LAST_UPD_SYS | CHARACTER VARYING(100) | 100 |
| 283 | X_STFF_PARTNER_FLG | CHARACTER(1) | 1 |
| 284 | X_STFF_USER_ID | CHARACTER VARYING(30) | 30 |
| 285 | X_DOMICILE_NAME | CHARACTER VARYING(100) | 100 |