ssdb_savings_transaction_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_savings_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 | |
| savingstransactionkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| savingskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| balsegcount | This field counts the number of balance segments used by the Transaction record | NULLABLE | INTEGER | |
| accountnumber | This field identifies the account affected by the transaction | NULLABLE | STRING | |
| id | This field stores the ID of the Share record (if the ID Type field is set to 0) or the Loan record (if the ID Type field is set to 1) affected by the transaction | NULLABLE | STRING | |
| idtype | This field indicates whether the transaction affected a Share or Loan record | NULLABLE | INTEGER | |
| commentcode | This field indicates whether the transaction includes a comment | NULLABLE | INTEGER | |
| transfercode | This field stores a code that indicates whether the transaction includes a transfer | NULLABLE | INTEGER | |
| adjustmentcode | This field stores a code that indicates whether the transaction includes an adjustment | NULLABLE | INTEGER | |
| regecode | This field stores a code that indicates if the transaction was a Reg E transaction | NULLABLE | INTEGER | |
| regdcheckcode | This field indicates whether Reg D transactions have occurred on an account | NULLABLE | INTEGER | |
| regdtransfercode | This field indicates whether a Reg D transfer transaction occurred on an account | NULLABLE | INTEGER | |
| voidcode | This field indicates whether the transaction included a void | NULLABLE | INTEGER | |
| subactioncode | This field stores a code that indicates the type of transaction that occurred | NULLABLE | STRING | |
| sequencenumber | This field stores a number that the system assigns in sequence to each transaction posted on a specific day | NULLABLE | INTEGER | |
| effectivedate | This field stores the effective date of the transaction | NULLABLE | DATE | |
| postdate | This field stores the current system date when the transaction is completed | NULLABLE | DATE | |
| posttime | This field stores the current system time when the transaction is completed | NULLABLE | INTEGER | |
| usernumber | This field stores the user number of the person who or the batch ID of the batch program that initiated the transaction | NULLABLE | INTEGER | |
| useroverride | This field stores the user number of the person who provided the override for the transaction | NULLABLE | INTEGER | |
| securitylevels | This field stores the Security Parameters security level assigned to this type of transaction | NULLABLE | INTEGER | |
| description | This field stores a description of the transaction | NULLABLE | STRING | |
| actioncode | This field identifies the action performed by the transaction | NULLABLE | STRING | |
| sourcecode | This field identifies the source of the transaction | NULLABLE | STRING | |
| balancechange | This field stores the amount of the transaction the teller designates as principal if the transaction affects a Loan record | NULLABLE | INTEGER | |
| interest | This field stores the amount of the transaction the teller designates as interest (if the transaction affects a Loan record) or penalty (if the transaction affects a Share record) | NULLABLE | INTEGER | |
| newbalance | This field stores the sum of the Balance Change field and the Balance field from the Share record | NULLABLE | INTEGER | |
| feeamount | This field stores late charges and lease termination fees on Loan Payment (LP) transactions | NULLABLE | INTEGER | |
| escrowamount | This field stores the amount of a payment that the teller applies to an escrow Share record | NULLABLE | INTEGER | |
| lasttrandate | This field stores the value from the Share or Loan record Last Transaction Date field before this transaction posts to the Share or Loan record | NULLABLE | DATE | |
| maturityloanduedate | This field stores the value from the Share record Maturity Date field if this is a share transaction, or it stores the value from the Loan record Due Date field if this is a loan transaction | NULLABLE | DATE | |
| comment | This field stores the text of a comment transaction | NULLABLE | STRING | |
| branch | This field stores the branch number associated with the console that initiated the transaction | NULLABLE | INTEGER | |
| consolenumber | This field stores the console number (0-8999) if the transaction is performed from a console; otherwise, it stores 9999 | NULLABLE | INTEGER | |
| batchsequence | This field stores a number that the system assigns in sequence to each batch job that runs throughout the day, to uniquely identify each transaction with a specific batch job | NULLABLE | INTEGER | |
| salestaxamount | The amount of sales tax is stored in this field when a payment is applied that includes sales tax, such as for lease loans | NULLABLE | INTEGER | |
| activitydate | This field stores the value from the Activity Date field in the Share or Loan record, depending on the type of transaction | NULLABLE | DATE | |
| billedfeeamount | This field stores the amount of a partial payment the system applies against the billed fee when a loan has an amount in the Billed Fee Unpaid field | NULLABLE | INTEGER | |
| processoruser | This field stores information saved from the SymXchange Processor User field or from the optional SymConnect User field in the SymConnect message | NULLABLE | INTEGER | |
| memberbranch | This field is only used by corporate credit unions; it can be blank to indicate that a transaction does not have a member branch number, or you can enter a four-digit number to indicate the branch where the transaction took place | NULLABLE | STRING | |
| prevavailbalance | This field stores the available credit as calculated at the time the transaction was processed, before it was posted | NULLABLE | INTEGER | |
| subsource | This field stores a code that specifies the transaction fee | NULLABLE | INTEGER | |
| confirmationseq | This field stores a number that is generated during posting or memo mode posting to be provided to SymConnect when requested | NULLABLE | INTEGER | |
| micracctnum | This field stores the value in the Exception Item record Processor Account field when the draft is an exception, unless custom coding requires it to store a different value | NULLABLE | STRING | |
| micrrt | This field stores the routing and transit (R&T) number when a transaction within a share draft file becomes an exception | NULLABLE | STRING | |
| recurringtran | This field indicates whether the transaction is recurring (based on indicators provided by the network or merchant) | NULLABLE | INTEGER | |
| feeexmtcrtsyamt | This field stores the courtesy pay amount applied at the time as an overdrawn transaction if the ODT Auth/Fee Option field for the source code of the transaction is set to 2, 3, 6, or 7 on the Share record | NULLABLE | INTEGER | |
| escrowunpaidbalchg | This field displays the amount that the Loan record Escrow Unpaid field has changed | NULLABLE | INTEGER | |
| escrowappliedbalchg | This field displays the amount that the Loan record Escrow Applied field has changed during a single loan payment. If the amount decreases, the transaction history shows this as a negative amount and an increase shows as a positive amount | NULLABLE | INTEGER | |
| unappliedpartialpmtchg | This field stores the transaction activity for each loan payment affecting the Unapplied Partial Payment field and displays the amount in the expanded Transaction record field | NULLABLE | INTEGER | |
| feecountby | The system advances this counter field for NSF or Courtesy Pay fees | NULLABLE | INTEGER | |
| latechgwaivedamt | This field tracks the amount of uncollected late charges that have been waived during a loan payment transaction. It lets the system handle adjustments to late charge activity when a previously waived late charge transaction is voided or reversed | NULLABLE | INTEGER | |
| latechgunpaidchgamt | This field stores the amount that the Loan record Late Charge Unpaid field has changed during a single loan payment transaction submitted through teller transactions, batch posting, or an online transaction | NULLABLE | INTEGER | |
| prevlatechgdate | The system updates this field with the value of the Loan record's Late Charge Date field when a loan transaction occurs | NULLABLE | DATE | |
| prevlatechgaccrued | This field only applies to a Loan record with the Late Charge Formula parameter set to (5) Wisconsin, and it displays the amount in the Loan record Late Charge Accrued field in before a loan payment transaction takes place | NULLABLE | INTEGER | |
| latechgfieldsvalid | This field determines whether to display late charge transaction fields | NULLABLE | INTEGER | |
| balsegid_1 | This field stores the segment record ID associated with the Loan Segment Transfer (LG), Loan Advance (LA), or New Loan (LN) transaction performed through Teller Transactions for a SymChoice loan | NULLABLE | STRING | |
| balsegpmtchangedate_1 | This field stores the payment change date for the segment ID when a Loan Segment Transfer (LG), Loan Advance (LA), or New Loan (LN) transaction is performed through Teller Transactions for a SymChoice loan | NULLABLE | DATE | |
| inteffectdate | This field stores the date to which interest is calculated when processing a transaction | NULLABLE | DATE | |
| balsegprevfirstpmtdate_1 | This field stores the value of the Segment record's First Payment Date field at time of transaction | NULLABLE | DATE | |
| draftnumber | This field stores the draft number | NULLABLE | STRING | |
| tracernumber | This field stores the tracer number | NULLABLE | STRING | |
| dispositionfee | This field stores the disposition fee when you apply a payment that includes a disposition fee for lease loans | NULLABLE | INTEGER | |
| terminationfee | This field stores the termination fee when you apply a payment that includes a termination fee for lease loans | NULLABLE | INTEGER | |
| miscexpenseamount | This field records the transaction activity for each Loan Balance Payment (LB) or Loan Balance Transfer (BG) transaction that affects a Loan Bankruptcy PrePetition Bal record with the Amount Code field set to (6) Misc Expense | NULLABLE | INTEGER | |
| dto | NULLABLE | BYTES |
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