CustDetail
ODI Extracts
>
Core Director
>
CustDetail
Extract to provide customer master file information
| Provider | Element | Element Description | Reference File | Reference Field | Field Type | Length | Digits | 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.
Did this page help you?
Last updated Fri Feb 21 2025