ssdb_site_cdc

Pipelined Data Sets > Symitar > ssdb_site_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
sitekey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
sitenumber	This field stores a credit union-defined code identifying a site to which a vendor delivers cash orders	NULLABLE	INTEGER
sitename	This field stores a descriptive name for the site	NULLABLE	STRING
extraaddress	This field stores an extra address line for the site's deliveries	NULLABLE	STRING
street	This field stores the street address for the site's deliveries	NULLABLE	STRING
city	This field stores the city for the site's delivery address	NULLABLE	STRING
state	This field stores the state for the site's delivery address	NULLABLE	STRING
zipcode	This field stores the ZIP Code for the site's delivery address	NULLABLE	STRING
closedate	This field stores the date the site was closed	NULLABLE	DATE
faxphone	This field stores the phone number for the site's fax machine	NULLABLE	STRING
sitecontactname	This field stores the name of the contact person for this site	NULLABLE	STRING
contactphone	This field stores the phone number of the site's contact person	NULLABLE	STRING
siteid	This field stores the identifier the BillMe system uses to uniquely identify a site	NULLABLE	STRING
sitesettleshareid	This field stores the ID of the share that the corporate interface debits for the total amount of the cash order	NULLABLE	STRING
locator	This field stores a unique number within each Preference record set that can be used as a unique identification of this record	NULLABLE	INTEGER
recordchangedate	This field stores the system date in this field when you create, change, or save the Site record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record	NULLABLE	DATE

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