ssdb_pstransaction_history_cdc

Pipelined Data Sets > Symitar > ssdb_pstransaction_history_cdc

Column name	Description	Mode	Type
institutionid	This field stores the JH Platform institution identifier	REQUIRED	STRING
sourceeventtime	The timestamp of the change event from the source system (e.g., Debezium's ts_ms field).	NULLABLE	INTEGER
sourceeventdate	The UTC date of the change event, derived from sourceeventtime.	NULLABLE	DATE
operation	The 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.	NULLABLE	STRING
pstransactionhistorykey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
transactionhistoryid		NULLABLE	INTEGER
transactiontypeid		NULLABLE	INTEGER
transactionid		NULLABLE	STRING
institution		NULLABLE	STRING
symid		NULLABLE	STRING
branchid		NULLABLE	STRING
consoleid		NULLABLE	STRING
approvalstatus		NULLABLE	STRING
supervisorid		NULLABLE	STRING
supervisorname		NULLABLE	STRING
supervisorcomments		NULLABLE	STRING
tellerid		NULLABLE	STRING
tellername		NULLABLE	STRING
tellercomments		NULLABLE	STRING
memberaccountnumber		NULLABLE	STRING
membername		NULLABLE	STRING
memberemail		NULLABLE	STRING
securitycode		NULLABLE	INTEGER
securitydesc		NULLABLE	STRING
device		NULLABLE	STRING
txndatetime		NULLABLE	INTEGER
responsetimestamp		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.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026