ssdb_loan_app_pledge_cdc

Pipelined Data Sets > Symitar > ssdb_loan_app_pledge_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
loanapppledgekey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
loanappkey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
type	This field stores a code that identifies the purpose of the Application Pledge record	NULLABLE	INTEGER
accountnumber	The field stores the account number associated with the application, if any	NULLABLE	STRING
id	The field stores the value in the ID field of the loan in the account associated with the application, if any	NULLABLE	STRING
collateralcode	The field stores the value in the Collateral Code field of the associated Application record	NULLABLE	INTEGER
percent	The field is not used for Application Pledge records	NULLABLE	INTEGER
amount	The field is not used for Application Pledge records	NULLABLE	INTEGER
locator	This field stores a unique number within each member account that can be used as a unique identification of this record	NULLABLE	INTEGER
collateralnumber	This field stores the reference to the Collateral record associated with this Application Pledge record	NULLABLE	STRING
priority	This field stores a code that indicates the priority of the collateral associated with this Application Pledge record	NULLABLE	INTEGER
effectivedate	This field stores the creation date of the Application Pledge record or, if entered manually, the date this Pledge record can be used	NULLABLE	DATE
expirationdate	This field stores the date this Application Pledge record should expire	NULLABLE	DATE
recordchangedate	This field stores the system date in this field when you create, change, or save the Application Pledge 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