Developer Programs

Learn

Docs

ssdb_activity_cdc

Pipelined Data Sets > Symitar > ssdb_activity_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
activitykeyInternal use only; SSDB fieldNULLABLEINTEGER
deleteidThis field stores a soft delete flag where 0=not deleted, 1=deletedNULLABLEINTEGER
userkeyInternal use only; SSDB fieldNULLABLEINTEGER
usernumberThis field is the identification number assigned to this user (0-9999)NULLABLEINTEGER
dateThis field stores the current date whenever a user touches or visits a system access point (a prompt with a related help file)NULLABLEDATE
timeThis field stores the current time whenever a user touches or visits a system access point (a prompt with a related help file)NULLABLEINTEGER
consoleThis field stores the console number at which a user is working whenever that user touches or visits a system access point (a prompt with a related help file)NULLABLEINTEGER
branchThis field stores the branch number at which a user is working whenever that user touches or visits a system access point (a prompt with a related help file)NULLABLEINTEGER
sessionThis field stores the terminal session in which a user is working whenever that user touches or visits a system access point (a prompt with a related help file)NULLABLEINTEGER
helpcodeThis field stores the help code for the prompts a user touches or visits while using the systemNULLABLEINTEGER
userinputThis field stores the entry a user makes at a prompt with a related help codeNULLABLESTRING


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