ssdb_reserve_plan_cdc

Pipelined Data Sets > Symitar > ssdb_reserve_plan_cdc

Column name	Description	Mode	Type
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
reserveplankey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
dealerkey	Internal use only; SSDB field	NULLABLE	INTEGER
id	This field stores characters that uniquely identify this Reserve Plan	NULLABLE	STRING
type	This field stores the reserve plan type	NULLABLE	INTEGER
opendate	The system stores the system date in this field on which you created this Dealer Reserve Plan record	NULLABLE	DATE
closedate	This field stores the date you completely close the plan	NULLABLE	DATE
tranpurgedate	The system stores the date in this field of the last transaction history purge for this record	NULLABLE	DATE
description	This field stores the description for this type of plan	NULLABLE	STRING
lastfmdate	The system stores the date in this field of the last file maintenance to the record	NULLABLE	DATE
recordchangedate	The system stores the system date in this field when you create, change, or save the Dealer Reserve Plan 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
upfrontreservepercent	This field stores the percentage of the reserve you pay to the dealer up-front	NULLABLE	INTEGER
holdbackpercent	This field stores the percentage of the total loan amounts with this plan type to be held back	NULLABLE	INTEGER
upfrontreserveamt	This field stores the amount of the reserve you pay to the dealer up-front	NULLABLE	INTEGER
holdbackamount	This field stores the amount of money to hold back for all loans of this plan type for this dealer	NULLABLE	INTEGER
effectivedate	This field stores the date on which this Dealer Reserve Plan record should take effect	NULLABLE	DATE
expirationdate	This field stores the date you make this Dealer Reserve Plan Record inactive	NULLABLE	DATE
chargeoffdays	This field stores the number of days during which, if you must charge off the loan, the dealer is responsible for either the original total reserve paid or the remaining unearned reserve	NULLABLE	INTEGER
chargebackcooption	This field stores a code that describes the kind of reserves the system should use for determining the amount of a chargeback for charge offs on loans using this Reserve Plan	NULLABLE	INTEGER
chargeoffpmts	This field stores the number of payments that, if you must charge off the loan before this number, the system performs a chargeback to the dealer for either the original total reserve paid or the remaining unearned reserve	NULLABLE	INTEGER
earlypayoffdays	This field stores the number of days from the open date of the loan which identify an early pay off	NULLABLE	INTEGER
earlypayoffpmts	This field stores the minimum number of payments made after the open date of the loan required for the system to consider this loan paid off early	NULLABLE	INTEGER
chargebackpooption	This field stores a code that describes the kind of reserves the system should use for determining the amount of a chargeback for pay offs on loans using this Reserve Plan	NULLABLE	INTEGER
recourse	This field stores a code that indicates whether the dealer made recourse agreements with your credit union for loans using this plan	NULLABLE	INTEGER
holdbackbalance	This field stores the holdback amount calculated and stored the last time you ran the Dealer Reserve Accounting Reserve Processing batch program	NULLABLE	INTEGER
userchar1	These fields can store any character data you define with the Reserve Plan User Field Names parameters	NULLABLE	STRING
userchar2	These fields can store any character data you define with the Reserve Plan User Field Names parameters	NULLABLE	STRING
userchar3	These fields can store any character data you define with the Reserve Plan User Field Names parameters	NULLABLE	STRING
useramount1	These fields can store any amounts you define with the Reserve Plan User Field Names parameters	NULLABLE	INTEGER
useramount2	These fields can store any amounts you define with the Reserve Plan User Field Names parameters	NULLABLE	INTEGER
useramount3	These fields can store any amounts you define with the Reserve Plan User Field Names parameters	NULLABLE	INTEGER
usernumber1	This field can store any numeric value you define with the Reserve Plan User Field Names parameters	NULLABLE	INTEGER
usernumber2	This field can store any numeric value you define with the Reserve Plan User Field Names parameters	NULLABLE	INTEGER
userdate1	This field can store any dates you define with the Reserve Plan User Field Names parameters	NULLABLE	DATE
usercode1	This field can store information with code options as defined in the Reserve Plan User Field Names parameters	NULLABLE	INTEGER
userrate1	This field can store rate information as defined in the Reserve Plan User Field Names parameters	NULLABLE	INTEGER
loancountslp	This field stores the number of new loans funded this month using this plan related to this dealer	NULLABLE	INTEGER
memberfee	This field stores a code that indicates whether the system should charge the dealer a membership fee (minimum deposit amount) for the new member's account created as part of a loan using this plan	NULLABLE	INTEGER
unpaidupfrontreserve	This field stores the accrued upfront reserve from new loans using this plan and funded since Statement Cutoff was last run, but not yet paid to this dealer	NULLABLE	INTEGER
loanbalanceslp	This field stores the principal balance of new loans related to this dealer using this plan and funded since the Statement Cutoff batch program was last run	NULLABLE	INTEGER
balance	The system stores the current balance of all loans using this Reserve Plan in this field	NULLABLE	INTEGER
mbrfeeamount	This field stores the amount the system should charge the dealer when the value in the Member Fee field is (1) Yes	NULLABLE	INTEGER
holdbackbalancels	The system stores the holdback amount that the system calculated and stored the last time you ran the Dealer Statement Cutoff Processing batch program	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.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026