ssdb_participation_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_participation_cdc
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| 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 | |
| participationkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| number | This field stores a number to uniquely identify the participation | NULLABLE | STRING | |
| poolname | This field stores the name of the participation | NULLABLE | STRING | |
| type | This field stores a numeric group identifier for the participation. You can assign each participation its own unique type to use when you purge file maintenance history | NULLABLE | INTEGER | |
| lastfmdate | This field stores the date of the last file maintenance of the Participation record | NULLABLE | DATE | |
| opendate | This field stores the date the Participation record was created | NULLABLE | DATE | |
| closedate | This field stores the date a participation was closed out | NULLABLE | DATE | |
| intcalcmethod | This field stores the method used to calculate interest, late charge, and lease termination fee distributions to participants | NULLABLE | INTEGER | |
| princalcmethod | This field stores the principal calculation method for the participation | NULLABLE | INTEGER | |
| fundingseqnum | This field indicates the order in which Symitar Quest applies funding to the owner for participations containing single loans. This field is used only if there is a single loan in the participation | NULLABLE | INTEGER | |
| retentionpercent | The owning credit union retains this amount of the participation. Symitar Quest does not sell this percentage of the loan | NULLABLE | INTEGER | |
| fundingmaxamount | This field indicates the maximum funding for the owner if the owner funds a loan before the participants, based on the Funding Seq Number | NULLABLE | INTEGER | |
| fmlastpurgedate | This field stores the date through which you last purged file maintenance history for the participation type with the Purge Transaction Processing batch program | NULLABLE | DATE | |
| poolcode | This field stores a code that indicates whether this participation contains a single loan or a pool of loans | NULLABLE | INTEGER | |
| allowchargeoff | The value in this field determines whether or not you can charge off loans placed in this participation without first removing the loan | NULLABLE | INTEGER | |
| recordchangedate | This field stores the system date when you create, change, or save the Participation record. There are times when Symitar Quest updates this field because the record was saved, even though there may not be any actual changes in the record | NULLABLE | DATE | |
| allowaddloantopool | This field indicates whether you allow new loans to be added to funded pooled participations | 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.
Did this page help you?
Last updated Tue Sep 15 2026