| # |
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 |