jhoffr_raw
Core Schemas
>
Silverlake
>
jhoffr_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| __op | Contains the operation type. Values are I for insert, U for update, D for delete. | REQUIRED | STRING | |
| __op_ts | operation timestamp added by export code | REQUIRED | TIMESTAMP | |
| __uid | The Unique ID of this entry. Data, UUID, or GUID | REQUIRED | STRING | |
| __ver | Mapping and Schema Version | REQUIRED | INTEGER | |
| jhooff | Officer code | CHAR(6) | NULLABLE | STRING | 6 |
| jhoxrfnbr | Cross Ref Number | DEC(4,0) | NULLABLE | INTEGER | 4 |
| jhonam | Officer name | CHAR(30) | NULLABLE | STRING | 30 |
| jhosna | Officer short name | CHAR(15) | NULLABLE | STRING | 15 |
| jhotit | Officer title | CHAR(30) | NULLABLE | STRING | 30 |
| jhophn | Officer phone number | DEC(10,0) | NULLABLE | INTEGER | 10 |
| jhopex | Officer ext. number | DEC(4,0) | NULLABLE | INTEGER | 4 |
| jhoslmt | Officer Secured Limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| jhoulmt | Officer Unsecured Limit | DEC(11,0) | NULLABLE | INTEGER | 11 |
| jhoprnt | Officer Default Printer | CHAR(10) | NULLABLE | STRING | 10 |
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 Thu Dec 12 2024