Developer Programs

Learn

Docs

ssdb_savings_analysis_group_cdc

Pipelined Data Sets > Symitar > ssdb_savings_analysis_group_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
savingsanalysisgroupkeyInternal use only; SSDB fieldNULLABLEINTEGER
deleteidThis field stores a soft delete flag where 0=not deleted, 1=deletedNULLABLEINTEGER
savingskeyInternal use only; SSDB fieldNULLABLEINTEGER
accountkeyInternal use only; SSDB fieldNULLABLEINTEGER
sortrankInternal use only; SSDB fieldNULLABLEINTEGER
accountnumberThis field stores the linked share account numberNULLABLESTRING
idThis field stores the ID of the linked shareNULLABLESTRING
comment1This field stores 40 characters of comment informationNULLABLESTRING
locatorThe system automatically assigns the Locator value when the record is created, and it cannot be changedNULLABLEINTEGER
recordchangedateThe system stores the system date in this field when you create, change, or save the Share Analysis Group 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