ssdb_console_cdc

Pipelined Data Sets > Symitar > ssdb_console_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
consolekey	Internal use only; SSDB field	NULLABLE	INTEGER
consolenumber		NULLABLE	INTEGER
branch		NULLABLE	INTEGER
screentype		NULLABLE	INTEGER
screenwidth		NULLABLE	INTEGER
moneyorderprinter9_0		NULLABLE	INTEGER
moneyorderprinter9_1		NULLABLE	INTEGER
moneyorderprinter9_2		NULLABLE	INTEGER
moneyorderprinter9_3		NULLABLE	INTEGER
moneyorderprinter9_4		NULLABLE	INTEGER
moneyorderprinter9_5		NULLABLE	INTEGER
moneyorderprinter9_6		NULLABLE	INTEGER
moneyorderprinter9_7		NULLABLE	INTEGER
moneyorderprinter9_8		NULLABLE	INTEGER
moneyorderprinter9_9		NULLABLE	INTEGER
moneyorderprinter9_10		NULLABLE	INTEGER
moneyorderprinter9_11		NULLABLE	INTEGER
moneyorderprinter9_12		NULLABLE	INTEGER
moneyorderprinter9_13		NULLABLE	INTEGER
moneyorderprinter9_14		NULLABLE	INTEGER
moneyorderprinter9_15		NULLABLE	INTEGER
moneyorderprinter9_16		NULLABLE	INTEGER
moneyorderprinter9_17		NULLABLE	INTEGER
moneyorderprinter9_18		NULLABLE	INTEGER
moneyorderprinter9_19		NULLABLE	INTEGER
dimenabled		NULLABLE	BOOLEAN
bellenabled		NULLABLE	BOOLEAN
blinkenabled		NULLABLE	BOOLEAN
automaticlogofftime		NULLABLE	INTEGER
cashdispensemachine		NULLABLE	INTEGER
cashmachineorientation		NULLABLE	INTEGER
micrreader		NULLABLE	INTEGER
logonprevention		NULLABLE	INTEGER
hostcufxposteroffhost		NULLABLE	BYTES
telephonetransferdefault		NULLABLE	BOOLEAN
purposecode		NULLABLE	INTEGER
totalloanadjustmentlimit_1		NULLABLE	INTEGER
totalloanadjustmentlimit_2		NULLABLE	INTEGER
totalloanadjustmentlimit_3		NULLABLE	INTEGER
totalloanadjustmentlimit_4		NULLABLE	INTEGER
totalloanadjustmentlimit_5		NULLABLE	INTEGER
totalloanadjustmentlimit_6		NULLABLE	INTEGER
totalloanadjustmentlimit_7		NULLABLE	INTEGER
totalloanadjustmentlimit_8		NULLABLE	INTEGER
totalloanadjustmentlimit_9		NULLABLE	INTEGER
totalloanadjustmentlimit_10		NULLABLE	INTEGER
totalloanadjustmentlimit_11		NULLABLE	INTEGER
totalloanadjustmentlimit_12		NULLABLE	INTEGER
totalloanadjustmentlimit_13		NULLABLE	INTEGER
totalloanadjustmentlimit_14		NULLABLE	INTEGER
totalloanadjustmentlimit_15		NULLABLE	INTEGER
totalloanadjustmentlimit_16		NULLABLE	INTEGER
totalloanadjustmentlimit_17		NULLABLE	INTEGER
totalloanadjustmentlimit_18		NULLABLE	INTEGER
totalloanadjustmentlimit_19		NULLABLE	INTEGER
totalloanadjustmentlimit_20		NULLABLE	INTEGER
checkvalidatortype		NULLABLE	INTEGER
checkvalidatoruse		NULLABLE	INTEGER
consolesystemfailure		NULLABLE	BOOLEAN
itcscanner		NULLABLE	BOOLEAN
itcport		NULLABLE	INTEGER
slavequeuetype		NULLABLE	INTEGER
slavequeuenumber		NULLABLE	INTEGER
slavesubtype		NULLABLE	INTEGER
slavesubnumber		NULLABLE	INTEGER
slavedocumentnumber		NULLABLE	INTEGER
slaveacctnumber		NULLABLE	INTEGER
slaveprintertype		NULLABLE	INTEGER
slavelinesperpage		NULLABLE	INTEGER
slaveblanklines		NULLABLE	INTEGER
slaveforms		NULLABLE	STRING
slavecustomformat		NULLABLE	BOOLEAN
slavecheckdetaillines		NULLABLE	INTEGER
slavecompression		NULLABLE	INTEGER
session10logonmode_1		NULLABLE	INTEGER
session10logonmode_2		NULLABLE	INTEGER
session10logonmode_3		NULLABLE	INTEGER
session10logonmode_4		NULLABLE	INTEGER
session10logonmode_5		NULLABLE	INTEGER
session10logonmode_6		NULLABLE	INTEGER
session10logonmode_7		NULLABLE	INTEGER
session10logonmode_8		NULLABLE	INTEGER
session10logonmode_9		NULLABLE	INTEGER
session10logonmode_10		NULLABLE	INTEGER
session10type_1		NULLABLE	INTEGER
session10type_2		NULLABLE	INTEGER
session10type_3		NULLABLE	INTEGER
session10type_4		NULLABLE	INTEGER
session10type_5		NULLABLE	INTEGER
session10type_6		NULLABLE	INTEGER
session10type_7		NULLABLE	INTEGER
session10type_8		NULLABLE	INTEGER
session10type_9		NULLABLE	INTEGER
session10type_10		NULLABLE	INTEGER
session10number_1		NULLABLE	INTEGER
session10number_2		NULLABLE	INTEGER
session10number_3		NULLABLE	INTEGER
session10number_4		NULLABLE	INTEGER
session10number_5		NULLABLE	INTEGER
session10number_6		NULLABLE	INTEGER
session10number_7		NULLABLE	INTEGER
session10number_8		NULLABLE	INTEGER
session10number_9		NULLABLE	INTEGER
session10number_10		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