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