ssdb_reserve_plan_loan_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_reserve_plan_loan_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 | |
| reserveplanloankey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| reserveplankey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| dealerkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountnumber | This field stores the unique 10-digit account number assigned to the account to which the dealer made an indirect loan | NULLABLE | STRING | |
| loanid | This field stores the two or four-digit ID that identifies the Indirect Loan record | NULLABLE | STRING | |
| lastfmdate | The system stores the date in this field of the last file maintenance to the record | NULLABLE | DATE | |
| opendate | The system stores the system date in this field on which it created this Dealer Reserve Plan Loan record | NULLABLE | DATE | |
| closedate | This field stores the date when you close, pay off, or charge off a loan | NULLABLE | DATE | |
| locator | This field stores a unique number within each Dealer Reserve Plan Loan record set that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| vin | The system stores the Vehicle Identification Number (VIN) for the vehicle purchased with the loan in this field | NULLABLE | STRING | |
| recordchangedate | The system stores the system date in this field when you create, change, or save the Dealer Reserve Plan Loan 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 |
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