Cust_OffCodeDetail
ODI Extracts
>
Silverlake
>
Cust_OffCodeDetail
Extract to provide a list of officers tied to CustId and/or Account records
| Provider | Element | Element Description | Reference File | Reference Field | Field Type | Length | Digits | Decimal Places |
|---|---|---|---|---|---|---|---|---|
| Silverlake | Dlt | Delete Record Flag | String | 1 | 0 | 0 | ||
| Silverlake | SrcKey | Unique Record Key | String | 32 | 0 | 0 | ||
| Silverlake | FornKey | Customer Level | String | 7 | 0 | 0 | ||
| Silverlake | OffDesc | Officer name | JHOFFR | JHONAM | String | 30 | 0 | 0 |
| Silverlake | OffPhoneNum | Officer phone number | JHOFFR | JHOPHN | Integer | 6 | 10 | 0 |
| Silverlake | OffPhoneExt | Officer ext. number | JHOFFR | JHOPEX | Integer | 3 | 4 | 0 |
| Silverlake | CustId | Customer Id | String | 7 | 0 | 0 | ||
| Silverlake | AcctId | Account number | Integer | 9 | 16 | 0 | ||
| Silverlake | AcctType | Account type | String | 1 | 0 | 0 | ||
| Silverlake | OffCodeText | Officer Code Text | String | 19 | 0 | 0 | ||
| Silverlake | OffCode | Officer Code | String | 6 | 0 | 0 | ||
| Silverlake | OffEmailAddr | Officer Email | String | 60 | 0 | 0 | ||
| Silverlake | OffTitle | Officer title | String | 30 | 0 | 0 |
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 Mon Oct 27 2025