ssdb_agreement_cdc

Pipelined Data Sets > Symitar > ssdb_agreement_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
agreementkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
participationkey	Internal use only; SSDB field	NULLABLE	INTEGER
id	This field contains a unique numeric identifier for the agreement within the participation	NULLABLE	STRING
participantnumber	This field contains an identifier of the financial institution participant associated with this agreement	NULLABLE	STRING
certificatenumber	You can optionally enter the certificate number for the agreement in this field	NULLABLE	STRING
lastfmdate	This field stores the date file maintenance was last performed on the Agreement record. Whenever you revise the Agreement record, the system updates this field with the system date	NULLABLE	DATE
opendate	This field stores the creation date for the agreement	NULLABLE	DATE
closedate	This field stores the date the agreement was closed out	NULLABLE	DATE
lastpurgedate	This field stores the date of the last purge for agreement transactions	NULLABLE	DATE
feecalcmethod	The system calculates participation service fees based on your selection in this field	NULLABLE	INTEGER
fundingseqnum	This field indicates the order in which the system applies funding to the participant for participation loans containing single loans	NULLABLE	INTEGER
ownershippercent	This field stores the percentage of the participation owned by this agreement	NULLABLE	INTEGER
interestrate	This field stores the interest rate for the agreement	NULLABLE	INTEGER
fixedfeepercent	This field stores the percentage of the fee charged	NULLABLE	INTEGER
fundingmaxamount	This field indicates the maximum funding for the participant	NULLABLE	INTEGER
principalpaid	This field stores the total amount of principal paid to the agreement for the life of the agreement	NULLABLE	INTEGER
interestpaid	This field stores the total amount of interest paid to the participant of this agreement for the life of the agreement	NULLABLE	INTEGER
feespaid	This field stores the total amount of service fees paid on the agreement for the life of the agreement	NULLABLE	INTEGER
balance	This field stores the balance of the portion of the loan included in the agreement	NULLABLE	INTEGER
principalfunded	This field stores the total principal funded by the participant through the life of the agreement	NULLABLE	INTEGER
interestdate	This field stores the most recent date through which interest was accrued for the portion of the loan owned by the agreement	NULLABLE	DATE
interestunpaid	This field stores the unpaid interest for the portion of the loan owned by the agreement	NULLABLE	INTEGER
fundingdate	The system sets this field to the current system date when the agreement is funded. Under normal circumstances, you should not revise this field	NULLABLE	DATE
owneraccrinterest	This field contains the amount of interest due for the associated loan as of the date the agreement is funded	NULLABLE	INTEGER
distlatechg	This field determines whether to distribute late charges collected from the member to the participant	NULLABLE	INTEGER
proratefund	When an agreement is added to a participation and funded, the associated member loans may be in mid-cycle of their payment. This field controls whether the participant should get the full interest or if that interest should be prorated	NULLABLE	INTEGER
latechgpaid	When the system distributes late charges or lease termination fees to the participant from the member's payment, it adds the amount distributed to this field	NULLABLE	INTEGER
chgoffamt	When the system posts GL entries for charged-off loans, it adds the amount distributed to this field. This field holds the total amount charged off for the life of the agreement	NULLABLE	INTEGER
chgoffrecovered	When the system receives a payment on a charged-off loan, it adds the amount of principal applicable to the agreement to this field	NULLABLE	INTEGER
chgoffremoved	When the system removes a charged-off loan from the participation, it adds the amount of principal applicable to the agreement to this field	NULLABLE	INTEGER
origfeepercent	This field contains the percentage value the system uses to calculate all or a portion of the one-time origination fee assessed to the participant	NULLABLE	INTEGER
origfeeamt	This field contains the fixed amount the system uses to calculate all or a portion of the one-time origination fee assessed to the participant	NULLABLE	INTEGER
origfeepd	This field contains the calculated origination fee value the system uses to assess the fee to the participant when funding an agreement	NULLABLE	INTEGER
recordchangedate	The system stores the system date in this field when you create, change, or save the Agreement record	NULLABLE	DATE
distloanadv	This field specifies whether loan advances should be distributed to participants	NULLABLE	INTEGER
distribroundmethod	This field determines the distribution rounding calculation method for participation loan payments and advances	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