ssdb_atm_mgr_lg_caf_cdc

Pipelined Data Sets > Symitar > ssdb_atm_mgr_lg_caf_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
atmmgrlgcafkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
atmmgritemkey	Internal use only; SSDB field	NULLABLE	INTEGER
addrline_1		NULLABLE	STRING
addrline_2		NULLABLE	STRING
city		NULLABLE	STRING
state		NULLABLE	STRING
zip		NULLABLE	STRING
altaddrline		NULLABLE	STRING
acctnumber		NULLABLE	STRING
pinoffset		NULLABLE	STRING
cardholdername		NULLABLE	STRING
capturecode		NULLABLE	STRING
acctcount		NULLABLE	INTEGER
accttype_1		NULLABLE	STRING
accttype_2		NULLABLE	STRING
accttype_3		NULLABLE	STRING
accttype_4		NULLABLE	STRING
accttype_5		NULLABLE	STRING
accttype_6		NULLABLE	STRING
accttype_7		NULLABLE	STRING
accttype_8		NULLABLE	STRING
accttype_9		NULLABLE	STRING
accttype_10		NULLABLE	STRING
accttype_11		NULLABLE	STRING
accttype_12		NULLABLE	STRING
accttype_13		NULLABLE	STRING
accttype_14		NULLABLE	STRING
accttype_15		NULLABLE	STRING
accttype_16		NULLABLE	STRING
accttype_17		NULLABLE	STRING
accttype_18		NULLABLE	STRING
accttype_19		NULLABLE	STRING
accttype_20		NULLABLE	STRING
acctacctnumslid_1		NULLABLE	STRING
acctacctnumslid_2		NULLABLE	STRING
acctacctnumslid_3		NULLABLE	STRING
acctacctnumslid_4		NULLABLE	STRING
acctacctnumslid_5		NULLABLE	STRING
acctacctnumslid_6		NULLABLE	STRING
acctacctnumslid_7		NULLABLE	STRING
acctacctnumslid_8		NULLABLE	STRING
acctacctnumslid_9		NULLABLE	STRING
acctacctnumslid_10		NULLABLE	STRING
acctacctnumslid_11		NULLABLE	STRING
acctacctnumslid_12		NULLABLE	STRING
acctacctnumslid_13		NULLABLE	STRING
acctacctnumslid_14		NULLABLE	STRING
acctacctnumslid_15		NULLABLE	STRING
acctacctnumslid_16		NULLABLE	STRING
acctacctnumslid_17		NULLABLE	STRING
acctacctnumslid_18		NULLABLE	STRING
acctacctnumslid_19		NULLABLE	STRING
acctacctnumslid_20		NULLABLE	STRING
acctprimaryflag_1		NULLABLE	STRING
acctprimaryflag_2		NULLABLE	STRING
acctprimaryflag_3		NULLABLE	STRING
acctprimaryflag_4		NULLABLE	STRING
acctprimaryflag_5		NULLABLE	STRING
acctprimaryflag_6		NULLABLE	STRING
acctprimaryflag_7		NULLABLE	STRING
acctprimaryflag_8		NULLABLE	STRING
acctprimaryflag_9		NULLABLE	STRING
acctprimaryflag_10		NULLABLE	STRING
acctprimaryflag_11		NULLABLE	STRING
acctprimaryflag_12		NULLABLE	STRING
acctprimaryflag_13		NULLABLE	STRING
acctprimaryflag_14		NULLABLE	STRING
acctprimaryflag_15		NULLABLE	STRING
acctprimaryflag_16		NULLABLE	STRING
acctprimaryflag_17		NULLABLE	STRING
acctprimaryflag_18		NULLABLE	STRING
acctprimaryflag_19		NULLABLE	STRING
acctprimaryflag_20		NULLABLE	STRING
acctfundingflag_1		NULLABLE	STRING
acctfundingflag_2		NULLABLE	STRING
acctfundingflag_3		NULLABLE	STRING
acctfundingflag_4		NULLABLE	STRING
acctfundingflag_5		NULLABLE	STRING
acctfundingflag_6		NULLABLE	STRING
acctfundingflag_7		NULLABLE	STRING
acctfundingflag_8		NULLABLE	STRING
acctfundingflag_9		NULLABLE	STRING
acctfundingflag_10		NULLABLE	STRING
acctfundingflag_11		NULLABLE	STRING
acctfundingflag_12		NULLABLE	STRING
acctfundingflag_13		NULLABLE	STRING
acctfundingflag_14		NULLABLE	STRING
acctfundingflag_15		NULLABLE	STRING
acctfundingflag_16		NULLABLE	STRING
acctfundingflag_17		NULLABLE	STRING
acctfundingflag_18		NULLABLE	STRING
acctfundingflag_19		NULLABLE	STRING
acctfundingflag_20		NULLABLE	STRING
acctdescription_1		NULLABLE	STRING
acctdescription_2		NULLABLE	STRING
acctdescription_3		NULLABLE	STRING
acctdescription_4		NULLABLE	STRING
acctdescription_5		NULLABLE	STRING
acctdescription_6		NULLABLE	STRING
acctdescription_7		NULLABLE	STRING
acctdescription_8		NULLABLE	STRING
acctdescription_9		NULLABLE	STRING
acctdescription_10		NULLABLE	STRING
acctdescription_11		NULLABLE	STRING
acctdescription_12		NULLABLE	STRING
acctdescription_13		NULLABLE	STRING
acctdescription_14		NULLABLE	STRING
acctdescription_15		NULLABLE	STRING
acctdescription_16		NULLABLE	STRING
acctdescription_17		NULLABLE	STRING
acctdescription_18		NULLABLE	STRING
acctdescription_19		NULLABLE	STRING
acctdescription_20		NULLABLE	STRING
acctavailbal_1		NULLABLE	INTEGER
acctavailbal_2		NULLABLE	INTEGER
acctavailbal_3		NULLABLE	INTEGER
acctavailbal_4		NULLABLE	INTEGER
acctavailbal_5		NULLABLE	INTEGER
acctavailbal_6		NULLABLE	INTEGER
acctavailbal_7		NULLABLE	INTEGER
acctavailbal_8		NULLABLE	INTEGER
acctavailbal_9		NULLABLE	INTEGER
acctavailbal_10		NULLABLE	INTEGER
acctavailbal_11		NULLABLE	INTEGER
acctavailbal_12		NULLABLE	INTEGER
acctavailbal_13		NULLABLE	INTEGER
acctavailbal_14		NULLABLE	INTEGER
acctavailbal_15		NULLABLE	INTEGER
acctavailbal_16		NULLABLE	INTEGER
acctavailbal_17		NULLABLE	INTEGER
acctavailbal_18		NULLABLE	INTEGER
acctavailbal_19		NULLABLE	INTEGER
acctavailbal_20		NULLABLE	INTEGER
actexpdate		NULLABLE	STRING

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