ssdb_dealer_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_dealer_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 | |
| dealerkey | 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 the unique number you entered when you created this record | NULLABLE | STRING | |
| name | This field stores the name of the dealer | NULLABLE | STRING | |
| vendornumber | This field stores the vendor identification used for payments paid through check and ACH origination | NULLABLE | STRING | |
| achtrancodeout | This field stores a translation code used when you send a payment via ACH (Automated Clearing House) origination | NULLABLE | INTEGER | |
| opendate | The system stores the system date on which you created this Dealer record in this field | NULLABLE | DATE | |
| closedate | This field stores the date when you are closing this Dealer record | NULLABLE | DATE | |
| lastfmdate | The field stores the date of the last file maintenance to the record | NULLABLE | DATE | |
| fmlastpurgedate | The system stores the date in this field through which you last purged file maintenance history for this dealer with the Purge Transaction Processing batch program | NULLABLE | DATE | |
| statementdate | The system stores the effective date in this field of the Dealer Statement Cutoff Processing batch run | NULLABLE | DATE | |
| statementprevdate | This field stores the date the system produced the previous statement for this dealer | NULLABLE | DATE | |
| statementgroup | This field stores a code that categorizes dealer statement by groups | NULLABLE | INTEGER | |
| paymentmethod | This field stores a code that describes how your credit union makes payments to the dealer after funding a new loan | NULLABLE | INTEGER | |
| balance | The system stores the current balance for the dealer in this field | NULLABLE | INTEGER | |
| lastpurgedate | The system stores the date of the last purge for Purge Transaction Processing or Purge Miscellaneous Files batch program | NULLABLE | DATE | |
| lastdisbursaldate | This field stores the date of the last payment or disbursal from your credit union to the dealer | NULLABLE | DATE | |
| type | This field stores a code that indicates if this record is for participant or dealer | NULLABLE | INTEGER | |
| subtype | This field stores a credit union-defined reference code to define dealer types such as Automobile, Marine, or Motorcycle | NULLABLE | INTEGER | |
| totalreserveaccrual | The system does not currently use or display this field | NULLABLE | INTEGER | |
| buckets_1 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_2 | These fields each store the total amount of dealer payments on all loans for this dealer during a single period (usually each previous month) | NULLABLE | INTEGER | |
| buckets_3 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_4 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_5 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_6 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_7 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_8 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_9 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_10 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_11 | This field stores the total amount of dealer payments on all loans for the most recent period this year | NULLABLE | INTEGER | |
| buckets_12 | These fields each store the total amount of dealer payments on all loans for this dealer during a single period (usually each previous month) | NULLABLE | INTEGER | |
| paymentslastyear | This field stores the calculated amount of total payments to the dealer for the previous year | NULLABLE | INTEGER | |
| paymentsltd | This field stores the calculated amount of total payments life-to-date for this dealer | NULLABLE | INTEGER | |
| legacycode | This field stores any legacy system number, that is, an identification code from your previous indirect loan system | NULLABLE | STRING | |
| branch | This field stores the branch number associated with the dealer | NULLABLE | INTEGER | |
| reservepaymentmethod | This field stores a code that identifies how the system should process the dealer's monthly payments | NULLABLE | INTEGER | |
| userchar1 | These fields can store any character data you define with the Dealer User Field Names parameters | NULLABLE | STRING | |
| userchar2 | These fields can store any character data you define with the Dealer User Field Names parameters | NULLABLE | STRING | |
| userchar3 | These fields can store any character data you define with the Dealer User Field Names parameters | NULLABLE | STRING | |
| useramount1 | These fields can store any amounts you define with the Dealer User Field Names parameters | NULLABLE | INTEGER | |
| useramount2 | These fields can store any amounts you define with the Dealer User Field Names parameters | NULLABLE | INTEGER | |
| usernumber1 | This field can store any numeric value you define with the Dealer User Field Names parameters | NULLABLE | INTEGER | |
| userrate1 | This field can store any percentage you define with the Dealer User Field Names parameters | NULLABLE | INTEGER | |
| userdate1 | This field can store any date you define with the Dealer User Field Names parameters | NULLABLE | DATE | |
| usercode1 | This field can store any information with code options you define in the Dealer User Field Names parameters | NULLABLE | INTEGER | |
| recordchangedate | The system stores the system date in this field when you create, change, or save the Dealer record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record | NULLABLE | DATE | |
| beginningballs | This field stores the beginning balance amount used in the last statement | NULLABLE | INTEGER | |
| upfrontrsrvls | This field stores the upfront reserve amount used in the last statement | NULLABLE | INTEGER | |
| chargebackls | This field stores the amount of the chargeback total used in the last statement | NULLABLE | INTEGER | |
| feesls | This field stores the total fees amount used in the last statement | NULLABLE | INTEGER | |
| adjls | This field stores the total adjustments amount used in the last statement | NULLABLE | INTEGER | |
| holdbackls | This field stores the holdback amount used in the last statement | NULLABLE | INTEGER | |
| paymentsytd | This field stores the total amount of dealer payments on all loans for this dealer during the past year as a rolling 12-month balance | 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