user_fmhistory_raw
Pipelined Data Sets
>
Symitar
>
user_fmhistory_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| institutionid | This field stores the JH Platform institution identifier | REQUIRED | STRING | |
| eventtime | Internal use only | NULLABLE | INTEGER | |
| sourcetype | Internal use only; SSDB field | NULLABLE | STRING | |
| operation | Internal use only; SSDB field | NULLABLE | STRING | |
| extractdate | Internal use only | NULLABLE | DATE | |
| processdatetime | Internal use only; SSDB field | NULLABLE | TIMESTAMP | |
| usernumber | This field stores the user number | NULLABLE | STRING | |
| userfmhistorykey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| symdate | Internal use only; SSDB field | NULLABLE | INTEGER | |
| systemcreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odscreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sym | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odsdeleteflag | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountnumber | This field stores the Symitar account number (membership account number) | NULLABLE | STRING | |
| idtype | NULLABLE | INTEGER | ||
| id | NULLABLE | STRING | ||
| sequencenumber | NULLABLE | INTEGER | ||
| postdate | NULLABLE | DATE | ||
| posttime | NULLABLE | INTEGER | ||
| useroverride | NULLABLE | INTEGER | ||
| securitylevels | NULLABLE | INTEGER | ||
| branch | NULLABLE | INTEGER | ||
| fmtype | NULLABLE | INTEGER | ||
| lastfmdate | NULLABLE | DATE | ||
| recordtype | NULLABLE | INTEGER | ||
| fieldnumber | NULLABLE | INTEGER | ||
| subfieldnumber | NULLABLE | INTEGER | ||
| datatype | NULLABLE | INTEGER | ||
| oldnumber | NULLABLE | INTEGER | ||
| newnumber | NULLABLE | INTEGER | ||
| oldcharacter | NULLABLE | STRING | ||
| newcharacter | NULLABLE | STRING | ||
| oldmoney | NULLABLE | NUMERIC | ||
| newmoney | NULLABLE | NUMERIC | ||
| olddate | NULLABLE | DATE | ||
| newdate | NULLABLE | DATE | ||
| oldrate | NULLABLE | NUMERIC | ||
| newrate | NULLABLE | NUMERIC | ||
| consolenumber | NULLABLE | INTEGER | ||
| batchsequence | NULLABLE | INTEGER | ||
| processoruser | NULLABLE | INTEGER | ||
| confirmationseq | NULLABLE | INTEGER |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
- Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.
Did this page help you?
Last updated Tue Sep 15 2026