CustDetail

ODI Extracts > Core Director > CustDetail

Extract to provide customer master file information

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

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.

Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Fri Feb 21 2025