ssdb_loan_billing_cdc

Pipelined Data Sets > Symitar > ssdb_loan_billing_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
loanbillingkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
loankey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
duedate		NULLABLE	DATE
id		NULLABLE	STRING
locator	This field stores the locator	NULLABLE	INTEGER
recordchangedate		NULLABLE	DATE
billeddate		NULLABLE	DATE
lastpaymentdate		NULLABLE	DATE
payment		NULLABLE	INTEGER
princintbilled		NULLABLE	INTEGER
principalbilled		NULLABLE	INTEGER
interestbilled		NULLABLE	INTEGER
escrowbilled		NULLABLE	INTEGER
latechargebilled		NULLABLE	INTEGER
feesbilled		NULLABLE	INTEGER
salestaxbilled		NULLABLE	INTEGER
princintremain		NULLABLE	INTEGER
principalremain		NULLABLE	INTEGER
interestremain		NULLABLE	INTEGER
escrowremain		NULLABLE	INTEGER
latechargeremain		NULLABLE	INTEGER
feesremain		NULLABLE	INTEGER
salestaxremain		NULLABLE	INTEGER
latechargeperiod		NULLABLE	INTEGER
escrowperiod		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