ssdb_participant_transaction_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_participant_transaction_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 | |
| participanttransactionkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| participantkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| participantnumber | The field stores the value from the Participant Number field in the Participant record. This is the number of the participant associated with this transaction | NULLABLE | STRING | |
| commentflag | This field indicates whether the transaction is monetary or simply contains a comment | NULLABLE | INTEGER | |
| consolenumber | If the transaction was performed at a console, the system stores the console number in this field; otherwise, this field contains 9999 | NULLABLE | INTEGER | |
| effectivedate | This field stores the effective date of the transaction | NULLABLE | DATE | |
| sequencenumber | This field contains a unique number for each sequence date, and the system assigns this number automatically | NULLABLE | INTEGER | |
| postdate | This field stores the date the record was created | NULLABLE | DATE | |
| posttime | The system updates this field with the system time when you approve the transaction | NULLABLE | INTEGER | |
| usernumber | The system updates this field with the number of the user or the batch ID of the batch program that initiated the transaction | NULLABLE | INTEGER | |
| useroverride | The system updates this field with the user number of the user who provided a user override for the transaction, if an override was necessary | NULLABLE | INTEGER | |
| batchsequence | The system assigns a batch sequence number to each batch job that runs throughout the day to uniquely identify each transaction with a specific batch job. The batch sequence number starts over at 1 after you run Close Day Processing to move to a new day | NULLABLE | INTEGER | |
| branch | This field stores the branch number associated with the console that initiated the transaction | NULLABLE | INTEGER | |
| memberbranch | This field is reserved for future use | NULLABLE | STRING | |
| poolnumber | The system updates this field with the Participation Number field value from the Participation record of the participation associated with this transaction | NULLABLE | STRING | |
| agid | The system updates this field with the Agreement ID field value from the Agreement record associated with this transaction | NULLABLE | STRING | |
| actioncode | This field stores the code that identifies the action performed by the transaction | NULLABLE | STRING | |
| sourcecode | This field contains the code indicating the source of the transaction | NULLABLE | STRING | |
| description | This field stores a 16-character system-defined description of the transaction | NULLABLE | STRING | |
| activitydate | The system updates this field with the Activity Date field value from the Loan Transaction record, or with the current system date if no Loan Transaction record exists | NULLABLE | DATE | |
| balancechange | The system updates this field with the amount of change in the Participant record Balance field, for this transaction | NULLABLE | INTEGER | |
| newbalance | This field stores the new value in the Balance field in the Participant record | NULLABLE | INTEGER | |
| comment | This field contains a user-entered comment | NULLABLE | STRING | |
| participanttype | This field stores a numeric group identifier for the participant. You can assign each participant its own unique type to use when you purge file maintenance history | NULLABLE | INTEGER | |
| loanid | This field stores the four-character ID of the Loan record related to the transaction | NULLABLE | STRING | |
| adjustmentflag | This field contains a code to indicate whether the transaction included an adjustment | NULLABLE | INTEGER | |
| subactioncode | This field contains a code that indicates whether the loan involved in the transaction is charged off | 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.
Did this page help you?
Last updated Tue Sep 15 2026