ssdb_agreement_transaction_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_agreement_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 | |
| agreementtransactionkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| agreementkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| participationkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| poolnumber | The system updates this field with the value in the Participation Number field in the Participation record that is associated with this transaction. You cannot access this field for file maintenance | NULLABLE | STRING | |
| id | The system updates this field with the value in the Agreement ID field in the Agreement record that is associated with this transaction | NULLABLE | STRING | |
| commentflag | This field stores a comment when the Action Code field is set to Comment | NULLABLE | INTEGER | |
| consolenumber | The system stores the console number of the console that was used to perform the transaction | NULLABLE | INTEGER | |
| sequencenumber | This field contains a unique number for each sequence date, and the system assigns this number automatically. You cannot change the value of this field | NULLABLE | INTEGER | |
| effectivedate | This field stores the effective date of the transaction | NULLABLE | DATE | |
| postdate | This field stores the date the record was created. You cannot change the value of this field | NULLABLE | DATE | |
| posttime | The system updates this field with the system time when you OK the transaction | NULLABLE | INTEGER | |
| usernumber | The system updates this field with the user 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 an override for the transaction, if an override was necessary | NULLABLE | INTEGER | |
| branch | The system updates this field with the branch number associated with the console that initiated the transaction | NULLABLE | INTEGER | |
| memberbranch | This field is reserved for future use | NULLABLE | STRING | |
| 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 the Close Day Processing batch program to move to a new day | NULLABLE | INTEGER | |
| activitydate | The system updates this field with the value in the Activity Date field in the Loan Transaction record, or with the current system date if no Loan Transaction record is involved | NULLABLE | DATE | |
| accountnumber | This field stores the value in the Account record Account Number field that is associated with the loan involved in the transaction | NULLABLE | STRING | |
| slid | This field stores the two- or four-character loan ID from the Loan record that is affected by the transaction | NULLABLE | STRING | |
| sltransequencenumber | If this Agreement Transaction record is created as a result of a loan transaction, this field contains the value in the Loan Transaction record Sequence Number field that is associated with the loan. Together with the Orig Post Date, this provides a unique key to the original Loan Transaction record | NULLABLE | INTEGER | |
| sltranpostdate | If this Agreement Transaction record is created as a result of a loan transaction, this field contains the Loan Transaction record Post Date field that is associated with the loan. Together with the Orig Sequence Number field, this field provides a unique key to the original Loan Transaction record | NULLABLE | DATE | |
| actioncode | This field identifies the action performed by the transaction | NULLABLE | STRING | |
| sourcecode | This field identifies the source of the transaction | NULLABLE | STRING | |
| description | This field contains a system-defined description of the transaction | NULLABLE | STRING | |
| balancechange | The system updates this field with the amount of the transaction that is allocated as principal for this agreement | NULLABLE | INTEGER | |
| interest | The system updates this field with the amount of the transaction that is allocated as interest for this agreement | NULLABLE | INTEGER | |
| fees | The system updates this field with the amount of the transaction that is allocated to service fees for this agreement | NULLABLE | INTEGER | |
| newbalance | This field stores the new value in the Agreement record Agreement Balance field | NULLABLE | INTEGER | |
| newparticipantbalance | This field stores the new value in the Participant record Balance field | NULLABLE | INTEGER | |
| loanbalance | This field stores the value in the Loan record Loan Balancefield | NULLABLE | INTEGER | |
| loaninterestunpaid | The system updates this field with the value in the Loan record Interest Unpaid field when you select (2) Accrual Percentage at the Participation record Interest Calc Method field. In that case, this field contains the denominator for the ratio the system uses to determine the portion of interest due to the participant | NULLABLE | INTEGER | |
| agreementintunpaid | The system updates this field with the value in the Agreement record Interest Unpaid field (the portion of the loan owned by the agreement) when you select (2) Accrual Percentage at the Participation record Interest Calc Method field. In that case, this field contains the numerator for the ratio the system uses to determine the portion of interest due to the participant | NULLABLE | INTEGER | |
| comment | This field stores a comment that was entered using the transaction wizard | NULLABLE | STRING | |
| latechrg | When the system distributes late charges or lease termination fees to the participant from the member's payment, it stores the distributed amount in this field | NULLABLE | INTEGER | |
| subactioncode | The value of this field indicates whether or not 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