Enterprise Solutions

CustDetail

Operational Data Integration (ODI) > ODI Extracts > Core Director > CustDetail

Extract to provide customer master file information

Core Director Dlt Delete record flag String 1 SrcKey Account Key MASTER.ISM COM_MASTER_PRIMARY_KEY 18 CustId CIF Number 9 ComName Combined Name 6 & 7 45 FirstName First Name 6 25 LastName Last Name 7 20 StreetAddr1 Address 40 StreetAddr2 Address Line 2 37 City 10 StateCode State 11 2 PostalCode Zip Code 12 13 BrCode Branch Number 16 BrDesc Branch Description USRCOD.ISM USER_DESCRIPTION DeceasedDt Date of Death 929 DateTime 8 CustOrgDt Orig Customer Date 221 BirthDt Name 1 DOB 30 OccType Occupation 313 County HMDA County Code 52 3 StdIndustCode SIC Code 53 StdIndustDesc SIC Code Description EmplName Employer 141 15 LastMainDt Date Last Change 91 Deceased Calculated based on of 929 5 TaxId SSN/EIN TINCode Tax ID Code 92 TINDesc Tax ID Description CustCode Account Ownership 65 RegPOptOutCode Customer Marketing 259 InsiderCode Employee Code 21 InsiderDesc Employee Code Description CRACenTract Census Tract 49 Decimal RiskRateCode Risk Rating 912 RiskRateDesc Risk Rating Description CertCode Intr W/H Certified? 98 CertCodeDesc Intr W/H Certified Description CRASMSACode MSA Code 50 CRASMSADesc MSA Code Description MailDirCode Mail Code MailDirDesc Mail Code Description NetWorthAmt Net Worth 158 Int64 AnnIncmAmt Salary 144 Gender 348 MiddleName Middle Name 936 CustType Customer Type Calculated based on field 5 NAICSCode NAICS Code Int32 NAICSDesc NAICS Description ReqLegalEntityType Legal Entity Type Calculated based on fields 371, 39, 5, 92 BenflOwnExclCode CDD Exempt Reason 378 BenflOwnExclDesc CDD Exempt Reason Description USERCOD.ISM

Have a Question?
Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Digital Toolkit Meetup where we answer technical Q&A from the audience.
Last updated Tue Apr 16 2024