Developer Programs

Learn

Docs

ssdb_eft_addenda_info_cdc

Pipelined Data Sets > Symitar > ssdb_eft_addenda_info_cdc

Column nameDescriptionModeTypeLength
institutionidThis field stores the JH Platform institution identifierREQUIREDSTRING
sourceeventtimeThe timestamp of the change event from the source system (e.g., Debezium's ts_ms field).NULLABLEINTEGER
sourceeventdateThe UTC date of the change event, derived from sourceeventtime.NULLABLEDATE
operationThe type of operation that caused the change event (e.g., 'c' for create/insert, 'u' for update, 'd' for delete, 'r' for read). This corresponds to Debezium's 'op' field.NULLABLESTRING
eftaddendainfokeyInternal use only; SSDB fieldNULLABLEINTEGER
deleteidThis field stores a soft delete flag where 0=not deleted, 1=deletedNULLABLEINTEGER
eftkeyInternal use only; SSDB fieldNULLABLEINTEGER
accountkeyInternal use only; SSDB fieldNULLABLEINTEGER
sortrankInternal use only; SSDB fieldNULLABLEINTEGER
typeThis field stores the addenda information type of (0) Standard. This is the only option for this fieldNULLABLEINTEGER
locatorThe system stores a unique number within each member account in this field that can be used as a unique identification of this recordNULLABLEINTEGER
info_1This field stores up to 40 characters of additional information about the parent EFT recordNULLABLESTRING
info_2This field stores up to 40 more characters of additional information about the parent EFT recordNULLABLESTRING
recordchangedateThe 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 recordNULLABLEDATE


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