eft_addendainfo_raw
Pipelined Data Sets
>
Symitar
>
eft_addendainfo_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 | |
| eftaddendainfouuid | This field stores a JH Platform unique identifier for an eft addend ainfo | NULLABLE | STRING | |
| accountnumber | This field stores the Symitar account number (membership account number) | NULLABLE | STRING | |
| eftlocator | This field stores the eft locator | NULLABLE | STRING | |
| eftaddendainfokey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| eftkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | 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 | |
| type | This field stores the addenda information type of (0) Standard. This is the only option for this field | NULLABLE | INTEGER | |
| locator | The system stores a unique number within each member account in this field that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| info_1 | This field stores up to 40 characters of additional information about the parent EFT record | NULLABLE | STRING | |
| info_2 | This field stores up to 40 more characters of additional information about the parent EFT record | NULLABLE | STRING | |
| recordchangedate | The system stores the system date this field when you create, change, or save the EFT Addenda Info record. There are times when the system updates this field because the record was saved, even though there may not be any actual changes in the record | NULLABLE | DATE |
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