OCH24_S_CONTACT_FNX
Description
Synonyms
SDSNZP05_BANK..CBP_OCH_S_CONTACT_FNX
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 | MODIFICATION_NUM | BIGINT | 8 |
| 7 | CONFLICT_ID | CHARACTER VARYING(15) | 15 |
| 8 | PAR_ROW_ID | CHARACTER VARYING(15) | 15 |
| 9 | ADDR_VERIFY_FLG | CHARACTER(1) | 1 |
| 10 | ATTRNY_FLG | CHARACTER(1) | 1 |
| 11 | CHK_TRUNC_RCV_FLG | CHARACTER(1) | 1 |
| 12 | GRAND_CHILD_FLG | CHARACTER(1) | 1 |
| 13 | HLTHCR_ATTRNY_FLG | CHARACTER(1) | 1 |
| 14 | LIAB_PROVD_FLG | CHARACTER(1) | 1 |
| 15 | OBLG_PAST_DUE_FLG | CHARACTER(1) | 1 |
| 16 | POST_NUPTL_AGR_FLG | CHARACTER(1) | 1 |
| 17 | PRE_NUPTL_AGR_FLG | CHARACTER(1) | 1 |
| 18 | PROSRV_INTRACT_FLG | CHARACTER(1) | 1 |
| 19 | STMT_PREP_PROF_FLG | CHARACTER(1) | 1 |
| 20 | TRUST_EXECUTE_FLG | CHARACTER(1) | 1 |
| 21 | WILL_EXECUTE_FLG | CHARACTER(1) | 1 |
| 22 | WILL_FLG | CHARACTER(1) | 1 |
| 23 | WIRE_ACTIVE_FLG | CHARACTER(1) | 1 |
| 24 | ACCSS_FRD_FILE_FLG | CHARACTER(1) | 1 |
| 25 | AGENT_NUM | BIGINT | 8 |
| 26 | AGNT_CONTRACT_DT | TIMESTAMP | 8 |
| 27 | AMS_CAPABILITY_LVL | BIGINT | 8 |
| 28 | ANNL_INCOME | NUMERIC(22,7) | 19 |
| 29 | ANNL_INCOME_DT | TIMESTAMP | 8 |
| 30 | ANNL_REVENUE | NUMERIC(22,7) | 19 |
| 31 | ARCH_REQST_FLG | CHARACTER(1) | 1 |
| 32 | BK_BNK_FEE_AMT | NUMERIC(22,7) | 19 |
| 33 | BK_CLAIM_AMT | NUMERIC(22,7) | 19 |
| 34 | BK_CLAIM_DT | TIMESTAMP | 8 |
| 35 | BK_DSCLOSR_DT | TIMESTAMP | 8 |
| 36 | BK_FILED_DT | TIMESTAMP | 8 |
| 37 | BK_GRANT_AMT | NUMERIC(22,7) | 19 |
| 38 | BK_HEARING_DT | TIMESTAMP | 8 |
| 39 | BK_LGL_FEE_AMT | NUMERIC(22,7) | 19 |
| 40 | BK_PETITION_DT | TIMESTAMP | 8 |
| 41 | BK_RCVD_AMT | NUMERIC(22,7) | 19 |
| 42 | BK_REAFFRM_AMT | NUMERIC(22,7) | 19 |
| 43 | BK_REAFFRM_DT | TIMESTAMP | 8 |
| 44 | BK_REMAING_AMT | NUMERIC(22,7) | 19 |
| 45 | BK_SEC_DEP_AMT | NUMERIC(22,7) | 19 |
| 46 | BK_STIPLATN_DT | TIMESTAMP | 8 |
| 47 | BL_OUTPYMNT_AMT | NUMERIC(22,7) | 19 |
| 48 | BRLOC_ATTRIB03 | NUMERIC(22,7) | 19 |
| 49 | BRLOC_ATTRIB08 | CHARACTER(1) | 1 |
| 50 | BRLOC_ATTRIB09 | CHARACTER(1) | 1 |
| 51 | BRLOC_ATTRIB10 | CHARACTER(1) | 1 |
| 52 | BRLOC_ATTRIB11 | CHARACTER(1) | 1 |
| 53 | BRLOC_ATTRIB12 | CHARACTER(1) | 1 |
| 54 | BRLOC_ATTRIB13 | CHARACTER(1) | 1 |
| 55 | CASH_AMT | NUMERIC(22,7) | 19 |
| 56 | CBR_SERVICE_LVL | BIGINT | 8 |
| 57 | CLEAR_DUP_AUTH_FLG | CHARACTER(1) | 1 |
| 58 | CLEAR_FRD_AUTH_FLG | CHARACTER(1) | 1 |
| 59 | CMNUTY_PRPTY_DT | TIMESTAMP | 8 |
| 60 | COB_FLG | CHARACTER(1) | 1 |
| 61 | COMP_OWNER_FLG | CHARACTER(1) | 1 |
| 62 | CRDT_SCRE_OVRD_FLG | CHARACTER(1) | 1 |
| 63 | CREDIT_BUR_HIT_NUM | BIGINT | 8 |
| 64 | CREDIT_SCORE | NUMERIC(22,7) | 19 |
| 65 | CRRPT_REQ_FLG | CHARACTER(1) | 1 |
| 66 | DB_LAST_UPD | TIMESTAMP | 8 |
| 67 | DECEASED_FLG | CHARACTER(1) | 1 |
| 68 | DLR_TLR_OVRD_FLG | CHARACTER(1) | 1 |
| 69 | DR_LICENSE_EXP_DT | TIMESTAMP | 8 |
| 70 | EBPP_ENRL_FLG | CHARACTER(1) | 1 |
| 71 | EBP_ENRL_FLG | CHARACTER(1) | 1 |
| 72 | EBP_PAYMT_LIMIT | NUMERIC(22,7) | 19 |
| 73 | EMPL_START_DT | TIMESTAMP | 8 |
| 74 | ENTRD_REGN_FLG | CHARACTER(1) | 1 |
| 75 | FINPLAN_COMPL_DT | TIMESTAMP | 8 |
| 76 | FST_AUTO_INS_DT | TIMESTAMP | 8 |
| 77 | HLTCR_POA_UPD_DT | TIMESTAMP | 8 |
| 78 | HOLD_PYMT_FLG | CHARACTER(1) | 1 |
| 79 | IDEN2_EXP_DT | TIMESTAMP | 8 |
| 80 | IDEN_EXP_DT | TIMESTAMP | 8 |
| 81 | INS_NEED_REV_DT | TIMESTAMP | 8 |
| 82 | IRR_INSTRST_UPD_DT | TIMESTAMP | 8 |
| 83 | IRR_TRST_UPD_DT | TIMESTAMP | 8 |
| 84 | JOBS_FIVE_YRS | BIGINT | 8 |
| 85 | LAST_CONTACTED_DT | TIMESTAMP | 8 |
| 86 | LAST_MARRIAGE_DT | TIMESTAMP | 8 |
| 87 | LIVE_TRUST_DT | TIMESTAMP | 8 |
| 88 | LIVE_WILL_UPD_DT | TIMESTAMP | 8 |
| 89 | LOAN_FORECLSURE_DT | TIMESTAMP | 8 |
| 90 | LST_WILL_UPD_DT | TIMESTAMP | 8 |
| 91 | MAX_RQST_PRTY_LVL | BIGINT | 8 |
| 92 | MTH_OBLG_AMT | NUMERIC(22,7) | 19 |
| 93 | NO_YRS_SCHOOL | NUMERIC(22,7) | 19 |
| 94 | NUM_DEPENDS | NUMERIC(22,7) | 19 |
| 95 | NUM_EST_DEPOSIT | NUMERIC(22,7) | 19 |
| 96 | NUM_VAC_DAYS | BIGINT | 8 |
| 97 | NUM_VISIT_RESD | BIGINT | 8 |
| 98 | NUM_VISIT_WORK | BIGINT | 8 |
| 99 | OFAC_FST_ACCESS_DT | TIMESTAMP | 8 |
| 100 | OFAC_LST_ACCESS_DT | TIMESTAMP | 8 |
| 101 | OVRD_AUTO_VAL_FLG | CHARACTER(1) | 1 |
| 102 | PASSPORT_EXP_DT | TIMESTAMP | 8 |
| 103 | PASSPORT_ISSUE_DT | TIMESTAMP | 8 |
| 104 | PERM_RESIDENT_FLG | CHARACTER(1) | 1 |
| 105 | PERSIST_RATIO | NUMERIC(22,7) | 19 |
| 106 | POA_UPD_DT | TIMESTAMP | 8 |
| 107 | POST_NUPTL_AGR_DT | TIMESTAMP | 8 |
| 108 | PRE_NUPTL_AGR_DT | TIMESTAMP | 8 |
| 109 | RECV_TRUST_UPD_DT | TIMESTAMP | 8 |
| 110 | RESDNCE_VAL | NUMERIC(22,7) | 19 |
| 111 | RESDNCE_YRS | BIGINT | 8 |
| 112 | RETIRED_FLG | CHARACTER(1) | 1 |
| 113 | REVOC_TRST_UPD_DT | TIMESTAMP | 8 |
| 114 | SCR_RPT_OVRD_FLG | CHARACTER(1) | 1 |
| 115 | SELF_EMPL_FLG | CHARACTER(1) | 1 |
| 116 | SPOUSE_BIRTH_DT | TIMESTAMP | 8 |
| 117 | STATE_IDEN_DT | TIMESTAMP | 8 |
| 118 | STG_RTE_OVRD_FLG | CHARACTER(1) | 1 |
| 119 | TAX_BRACKET | NUMERIC(22,7) | 19 |
| 120 | TOTAL_ASSET | NUMERIC(22,7) | 19 |
| 121 | TOTAL_LIABILITY | NUMERIC(22,7) | 19 |
| 122 | TRUST_AGREE_DT | TIMESTAMP | 8 |
| 123 | TURNDOWN_AUTH_FLG | CHARACTER(1) | 1 |
| 124 | US_CITIZEN_FLG | CHARACTER(1) | 1 |
| 125 | WED_ANVRSRY_DT | TIMESTAMP | 8 |
| 126 | YEARS_EMPLYMT | BIGINT | 8 |
| 127 | YL_LAST_LOGIN_TS | TIMESTAMP | 8 |
| 128 | YL_LAST_UPD_TS | TIMESTAMP | 8 |
| 129 | YL_START_UPD_TS | TIMESTAMP | 8 |
| 130 | ACCESS_LVL_CD | CHARACTER VARYING(30) | 30 |
| 131 | ANNL_REV_CURCY_CD | CHARACTER VARYING(20) | 20 |
| 132 | ATTRITION_RISK_CD | CHARACTER VARYING(30) | 30 |
| 133 | AUTH_TEXT | CHARACTER VARYING(250) | 250 |
| 134 | BEHAVIOUR_CD | CHARACTER VARYING(30) | 30 |
| 135 | BEST_CALLTM_CD | CHARACTER VARYING(30) | 30 |
| 136 | BILL_PAY_MTHD_CD | CHARACTER VARYING(30) | 30 |
| 137 | BIRTH_PLACE | CHARACTER VARYING(50) | 50 |
| 138 | BK_CASE_NUM | CHARACTER VARYING(10) | 10 |
| 139 | BK_CHPTR_CD | CHARACTER VARYING(30) | 30 |
| 140 | BK_COURT_NAME | CHARACTER VARYING(50) | 50 |
| 141 | BK_REF_ASSET_ID | CHARACTER VARYING(15) | 15 |
| 142 | BK_REF_ASSET_NAME | CHARACTER VARYING(50) | 50 |
| 143 | BRLOC_ATTRIB01 | CHARACTER VARYING(50) | 50 |
| 144 | BRLOC_ATTRIB02 | CHARACTER VARYING(30) | 30 |
| 145 | BRLOC_ATTRIB04 | CHARACTER VARYING(30) | 30 |
| 146 | BRLOC_ATTRIB05 | CHARACTER VARYING(10) | 10 |
| 147 | BRLOC_ATTRIB06 | CHARACTER VARYING(30) | 30 |
| 148 | BRLOC_ATTRIB07 | CHARACTER VARYING(30) | 30 |
| 149 | COM_PREFERENCE | CHARACTER VARYING(30) | 30 |
| 150 | CRRPT_FMT_CD | CHARACTER VARYING(30) | 30 |
| 151 | CURR_FUNDS_MGD | CHARACTER VARYING(250) | 250 |
| 152 | DB_LAST_UPD_SRC | CHARACTER VARYING(50) | 50 |
| 153 | DEAR_NAME | CHARACTER VARYING(50) | 50 |
| 154 | DEBT_FEEL_CD | CHARACTER VARYING(30) | 30 |
| 155 | DEPENDS_DESC | CHARACTER VARYING(50) | 50 |
| 156 | DEPT_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 157 | DR_LICENSE_NUM | CHARACTER VARYING(40) | 40 |
| 158 | DR_LICENSE_STATE | CHARACTER VARYING(30) | 30 |
| 159 | EBP_IDEN_NUM | CHARACTER VARYING(30) | 30 |
| 160 | EDUCATION | CHARACTER VARYING(250) | 250 |
| 161 | EDU_CD | CHARACTER VARYING(30) | 30 |
| 162 | EMPLOYER_NAME | CHARACTER VARYING(250) | 250 |
| 163 | EVAL_STAT_CD | CHARACTER VARYING(30) | 30 |
| 164 | EVIDENCE_REASON | CHARACTER VARYING(250) | 250 |
| 165 | GOALS | CHARACTER VARYING(250) | 250 |
| 166 | HEIGHT | CHARACTER VARYING(20) | 20 |
| 167 | HIST_FUNDS_MGD | CHARACTER VARYING(250) | 250 |
| 168 | HOBBY_CD | CHARACTER VARYING(30) | 30 |
| 169 | IDEN2_NUM | CHARACTER VARYING(40) | 40 |
| 170 | IDEN2_STATE_CD | CHARACTER VARYING(30) | 30 |
| 171 | IDEN2_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 172 | IDEN_NUM | CHARACTER VARYING(40) | 40 |
| 173 | IDEN_STATE_CD | CHARACTER VARYING(30) | 30 |
| 174 | IDEN_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 175 | INCOME_RANGE_CD | CHARACTER VARYING(30) | 30 |
| 176 | INFO_SOURCE_CD | CHARACTER VARYING(30) | 30 |
| 177 | INS_CVRG_CD | CHARACTER VARYING(30) | 30 |
| 178 | INTERESTS_TEXT | CHARACTER VARYING(250) | 250 |
| 179 | INTR_CHG_IMP_CD | CHARACTER VARYING(30) | 30 |
| 180 | INTR_RATE_SRVEY_CD | CHARACTER VARYING(30) | 30 |
| 181 | INVST_EXPR_CD | CHARACTER VARYING(30) | 30 |
| 182 | INVST_HORIZ_CD | CHARACTER VARYING(30) | 30 |
| 183 | INVST_KNWLDG_CD | CHARACTER VARYING(30) | 30 |
| 184 | INVST_OBJ_CD | CHARACTER VARYING(30) | 30 |
| 185 | INVST_PROFILE_CD | CHARACTER VARYING(30) | 30 |
| 186 | INVST_RISK_CD | CHARACTER VARYING(30) | 30 |
| 187 | ISSUE_DESC | CHARACTER VARYING(250) | 250 |
| 188 | LAST_CONTACTED_BY | CHARACTER VARYING(15) | 15 |
| 189 | LIFE_EVENT_CD | CHARACTER VARYING(30) | 30 |
| 190 | LIQUDTY_SRVEY_CD | CHARACTER VARYING(30) | 30 |
| 191 | LOB_REFER_SRC_CD | CHARACTER VARYING(30) | 30 |
| 192 | MEMBER_NUM | CHARACTER VARYING(50) | 50 |
| 193 | MGR_TENURE | CHARACTER VARYING(20) | 20 |
| 194 | MRKT_CAP_PREF_CD | CHARACTER VARYING(30) | 30 |
| 195 | NET_WORTH_CD | CHARACTER VARYING(30) | 30 |
| 196 | NET_WRTHVALMTHD_CD | CHARACTER VARYING(30) | 30 |
| 197 | NET_WRTHVALTYPE_CD | CHARACTER VARYING(30) | 30 |
| 198 | NET_WRTH_SRC_CD | CHARACTER VARYING(30) | 30 |
| 199 | NOT_VERIFIED_REASN | CHARACTER VARYING(250) | 250 |
| 200 | NPI_NUM | CHARACTER VARYING(30) | 30 |
| 201 | OFAC_STAT_CD | CHARACTER VARYING(30) | 30 |
| 202 | PANEL_CD | CHARACTER VARYING(30) | 30 |
| 203 | PEEVES_TEXT | CHARACTER VARYING(250) | 250 |
| 204 | PERF_EXPECT_CD | CHARACTER VARYING(30) | 30 |
| 205 | PHLNTRPHY_OBJTV_CD | CHARACTER VARYING(30) | 30 |
| 206 | POST_RETIREMENT_CD | CHARACTER VARYING(30) | 30 |
| 207 | PRACTICE_CD | CHARACTER VARYING(30) | 30 |
| 208 | PREV_BANK_BRANCH | CHARACTER VARYING(50) | 50 |
| 209 | PREV_BANK_PH_NUM | CHARACTER VARYING(40) | 40 |
| 210 | PRONUNCIATION | CHARACTER VARYING(100) | 100 |
| 211 | PR_METRP_STAT_AREA | CHARACTER VARYING(10) | 10 |
| 212 | PURCH_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 213 | REFER_SRC_CD | CHARACTER VARYING(30) | 30 |
| 214 | REGION_CD | CHARACTER VARYING(30) | 30 |
| 215 | RESDNCE_CATG_CD | CHARACTER VARYING(30) | 30 |
| 216 | RESDNCE_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 217 | RESIDENCY_INSTN | CHARACTER VARYING(50) | 50 |
| 218 | RISK_RATING_INFO | CHARACTER VARYING(50) | 50 |
| 219 | RSRCH_CHNL_PREF_CD | CHARACTER VARYING(30) | 30 |
| 220 | SALUTATION_CD | CHARACTER VARYING(30) | 30 |
| 221 | SERVICE_GUIDELINE | CHARACTER VARYING(250) | 250 |
| 222 | SHOW_APPL_CHOICE | CHARACTER VARYING(100) | 100 |
| 223 | STATUS_CD | CHARACTER VARYING(30) | 30 |
| 224 | STMT_FORMAT_CD | CHARACTER VARYING(30) | 30 |
| 225 | STMT_FREQ_CD | CHARACTER VARYING(30) | 30 |
| 226 | TECH_IMP_CD | CHARACTER VARYING(30) | 30 |
| 227 | TLR_INTG_MSG | CHARACTER VARYING(250) | 250 |
| 228 | TLR_INTG_RET_CD | CHARACTER VARYING(30) | 30 |
| 229 | UPIN_NUM | CHARACTER VARYING(30) | 30 |
| 230 | WEIGHT | CHARACTER VARYING(20) | 20 |
| 231 | WILL_PREP_LOC | CHARACTER VARYING(50) | 50 |
| 232 | YL_ENCRPKEY_REF | CHARACTER VARYING(30) | 30 |
| 233 | YL_LASTUPD_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 234 | YL_LAST_ERR_MSG | CHARACTER VARYING(250) | 250 |
| 235 | YL_LAST_UPD_STATUS | CHARACTER VARYING(50) | 50 |
| 236 | YL_LOGIN | CHARACTER VARYING(50) | 50 |
| 237 | YL_PASSWD | CHARACTER VARYING(90) | 90 |
| 238 | YL_STATUS | CHARACTER VARYING(40) | 40 |
| 239 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 240 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 241 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 242 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |