ssdb_atm_mgr_pps_caf_c_cdc

Pipelined Data Sets > Symitar > ssdb_atm_mgr_pps_caf_c_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
atmmgrppscafckey	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
street		NULLABLE	STRING
city		NULLABLE	STRING
state		NULLABLE	STRING
country		NULLABLE	STRING
zip		NULLABLE	STRING
xtraaddress		NULLABLE	STRING
pinoffset		NULLABLE	STRING
activedate		NULLABLE	DATE
warnexpdate		NULLABLE	DATE
fraudnote_1		NULLABLE	STRING
fraudnote_2		NULLABLE	STRING
fraudnote_3		NULLABLE	STRING
fraudnote_4		NULLABLE	STRING
fraudnote_5		NULLABLE	STRING
fraudnote_6		NULLABLE	STRING
fraudnoteexp		NULLABLE	DATE
namefirst_1		NULLABLE	STRING
namefirst_2		NULLABLE	STRING
namemiddle_1		NULLABLE	STRING
namemiddle_2		NULLABLE	STRING
namelast_1		NULLABLE	STRING
namelast_2		NULLABLE	STRING
nametitle_1		NULLABLE	STRING
nametitle_2		NULLABLE	STRING
namesuffix_1		NULLABLE	STRING
namesuffix_2		NULLABLE	STRING
homephone		NULLABLE	STRING
workphone		NULLABLE	STRING
workphoneext		NULLABLE	STRING
mobilephone		NULLABLE	STRING
ssn		NULLABLE	STRING
birthdate		NULLABLE	STRING
maidenname		NULLABLE	STRING
email		NULLABLE	STRING
usecardsuffix		NULLABLE	STRING
prevcardnum		NULLABLE	STRING
vacationstartdate		NULLABLE	DATE
vacationenddate		NULLABLE	DATE
vacationflag		NULLABLE	STRING
vacationnotes_1		NULLABLE	STRING
vacationnotes_2		NULLABLE	STRING
vacationstate_1		NULLABLE	STRING
vacationstate_2		NULLABLE	STRING
vacationstate_3		NULLABLE	STRING
vacationstate_4		NULLABLE	STRING
vacationstate_5		NULLABLE	STRING
vacationcountry_1		NULLABLE	STRING
vacationcountry_2		NULLABLE	STRING
vacationcountry_3		NULLABLE	STRING
vacationcountry_4		NULLABLE	STRING
vacationcountry_5		NULLABLE	STRING
fraudnotestartdate		NULLABLE	DATE
auoptout		NULLABLE	STRING
bonusawards		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