ssdb_sales_tax_rate_cdc

Pipelined Data Sets > Symitar > ssdb_sales_tax_rate_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
salestaxratekey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
state		NULLABLE	STRING
statetaxrate_1		NULLABLE	INTEGER
statetaxrate_2		NULLABLE	INTEGER
statetaxrate_3		NULLABLE	INTEGER
statetaxrate_4		NULLABLE	INTEGER
statetaxrate_5		NULLABLE	INTEGER
stateeffectdate_1		NULLABLE	DATE
stateeffectdate_2		NULLABLE	DATE
stateeffectdate_3		NULLABLE	DATE
stateeffectdate_4		NULLABLE	DATE
stateeffectdate_5		NULLABLE	DATE
stateexpiredate_1		NULLABLE	DATE
stateexpiredate_2		NULLABLE	DATE
stateexpiredate_3		NULLABLE	DATE
stateexpiredate_4		NULLABLE	DATE
stateexpiredate_5		NULLABLE	DATE
county		NULLABLE	STRING
countytaxrate_1		NULLABLE	INTEGER
countytaxrate_2		NULLABLE	INTEGER
countytaxrate_3		NULLABLE	INTEGER
countytaxrate_4		NULLABLE	INTEGER
countytaxrate_5		NULLABLE	INTEGER
countyeffectdate_1		NULLABLE	DATE
countyeffectdate_2		NULLABLE	DATE
countyeffectdate_3		NULLABLE	DATE
countyeffectdate_4		NULLABLE	DATE
countyeffectdate_5		NULLABLE	DATE
countyexpiredate_1		NULLABLE	DATE
countyexpiredate_2		NULLABLE	DATE
countyexpiredate_3		NULLABLE	DATE
countyexpiredate_4		NULLABLE	DATE
countyexpiredate_5		NULLABLE	DATE
city		NULLABLE	STRING
citytaxrate_1		NULLABLE	INTEGER
citytaxrate_2		NULLABLE	INTEGER
citytaxrate_3		NULLABLE	INTEGER
citytaxrate_4		NULLABLE	INTEGER
citytaxrate_5		NULLABLE	INTEGER
cityeffectdate_1		NULLABLE	DATE
cityeffectdate_2		NULLABLE	DATE
cityeffectdate_3		NULLABLE	DATE
cityeffectdate_4		NULLABLE	DATE
cityeffectdate_5		NULLABLE	DATE
cityexpiredate_1		NULLABLE	DATE
cityexpiredate_2		NULLABLE	DATE
cityexpiredate_3		NULLABLE	DATE
cityexpiredate_4		NULLABLE	DATE
cityexpiredate_5		NULLABLE	DATE
zipcode		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