mbraddress_fmhistory_raw
Pipelined Data Sets
>
Symitar
>
mbraddress_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 | |
| mbraddressmbraddrnumber | NULLABLE | STRING | ||
| mbraddressfmhistorykey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| mbraddresskey | 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 | The field contains the unique identifier of the changed record (which is not always the account number). This field identifies the account affected by file maintenance to the Account record; it identifies the member affected by file maintenance to the Member record, etc | NULLABLE | STRING | |
| idtype | This field identifies the type of record affected by the file maintenance | NULLABLE | INTEGER | |
| id | This field stores the two or four-character ID of the following record types (see ID Type) affected by the transaction: | NULLABLE | STRING | |
| sequencenumber | The system assigns this number in sequence to each file maintenance transaction posted on a specific day | NULLABLE | INTEGER | |
| postdate | The system updates this field with the current system date when you accept the file maintenance transaction | NULLABLE | DATE | |
| posttime | The system updates this field with the system time when you accept the file maintenance transaction | NULLABLE | INTEGER | |
| usernumber | The system updates this field with the number of the user or the ID of the batch program that initiated the file maintenance transaction | NULLABLE | INTEGER | |
| useroverride | The system updates this field with the number of the user who provided an override for the transaction, if an override was necessary. If no override was necessary, this field contains 0999 | NULLABLE | INTEGER | |
| securitylevels | The system updates this field with the security level assigned to this type of transaction in the Security Parameters | NULLABLE | INTEGER | |
| branch | The system updates this field with the number of the branch where the file maintenance occurred, not necessarily the account branch | NULLABLE | INTEGER | |
| fmtype | This field identifies the type of file maintenance: | NULLABLE | INTEGER | |
| lastfmdate | This field stores the previous most recent transaction or FM date | NULLABLE | DATE | |
| recordtype | This field contains the type of record affected by file maintenance | NULLABLE | INTEGER | |
| fieldnumber | The system updates this field with number of the field affected by the file maintenance | NULLABLE | INTEGER | |
| subfieldnumber | The system updates this field with the subfield number (if any) of the field affected by the file maintenance | NULLABLE | INTEGER | |
| datatype | This field contains the type of data stored in the field identified by the Field Number field value, and if appropriate, by Sub Field Number: | NULLABLE | INTEGER | |
| oldnumber | If the Data Type field is set to 4 (Number), 5 (Code), or 8 (Yes/No), the system updates this field with the old value of the field before the file maintenance was performed | NULLABLE | INTEGER | |
| newnumber | If the Data Type field is set to 4 (Number), 5 (Code), or 8 (Yes/No), the system updates this field with the new value of the field after the file maintenance is performed | NULLABLE | INTEGER | |
| oldcharacter | If the Data Type field is set to 0 (Character) or 1 (Character), the system updates this field with the old value of the field before the file maintenance was performed | NULLABLE | STRING | |
| newcharacter | If the Data Type field is set to 0 (Character) or 1 (Character), the system updates this field with the new value of the field after the file maintenance is performed | NULLABLE | STRING | |
| oldmoney | If the Data Type is set to 6 (Money) or 7 (Money), the system updates this field with the old value of the field before the file maintenance was performed | NULLABLE | NUMERIC | |
| newmoney | If the Data Type field is set to 6 (Money) or 7 (Money), the system updates this field with the new value of the field after the file maintenance is performed | NULLABLE | NUMERIC | |
| olddate | If the Data Type field is set to 3 (Date), the system updates this field with the old value of the field before the file maintenance was performed | NULLABLE | DATE | |
| newdate | If the Data Type field is set to 3 (Date), the system updates this field with the new value of the field after the file maintenance is performed | NULLABLE | DATE | |
| oldrate | If the Data Type field is set to 2 (Rate), the system updates this field with the old value of the field before the file maintenance was performed | NULLABLE | NUMERIC | |
| newrate | If the Data Type field is set to 2 (Rate), the system updates this field with the new value of the field after the file maintenance is performed | NULLABLE | NUMERIC | |
| consolenumber | If the file maintenance is performed from a console, the system stores the console number (0-8999) in this field. Otherwise, the system stores 9999 in this field | NULLABLE | INTEGER | |
| batchsequence | If a record was created by a batch job, this field contains the sequence number of the batch job that created it, similar to the batch sequence field in the Transaction record. If a record was not created by a batch job, the system stores 0 in this field | NULLABLE | INTEGER | |
| processoruser | This field contains information saved from the optional SymConnect User field in the SymConnect message. The SymConnect message creator can provide specific user information in this field | NULLABLE | INTEGER | |
| confirmationseq | This number is system-generated during posting or memo posting and provided to any SymConnect transaction requesting it | 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