ssdb_loan_app_schedule_cdc

Pipelined Data Sets > Symitar > ssdb_loan_app_schedule_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
loanappschedulekey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
loanappkey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
id	The system uses this field to keep the Schedule records in order visually. The order of the Schedule records imported into the Loan record is actually based on the Beginning Date field	NULLABLE	STRING
beginningdate	This field stores the date when this particular Schedule record becomes effective	NULLABLE	DATE
expiration	This field stores the date when this particular Schedule record should expire	NULLABLE	DATE
paymentcalctype	While the selection is valid, this field is generally not used for credit card loan types	NULLABLE	INTEGER
payment	An entry in this field is required	NULLABLE	INTEGER
paymenttype	The amount applied to the loan principal changes each period, since the amount of interest due each period depends on the loan balance and the number of days in the loan period. This is the normal option for most daily interest loans	NULLABLE	INTEGER
dqcalculationmethod		NULLABLE	INTEGER
interesttype		NULLABLE	INTEGER
repeatcode	This field stores the code indicating how often you want the system to import the Schedule record	NULLABLE	INTEGER
dueday1	This stores the day of the month (1-31) on which the first payment is due for semimonthly loans, or the day of the month on which all loan payments are due for annual, semiannual, quarterly, or monthly loans	NULLABLE	INTEGER
dueday2	This stores the day of the month (2-31) on which the second payment is due for semimonthly payment loans. This field is not used for annual, semiannual, quarterly, monthly, or biweekly loans	NULLABLE	INTEGER
recordchangedate	This field contains the system date from the last time any changes were made to this record. When a record is first created, this field carries the system date on which the record is created	NULLABLE	DATE
exceedlevelpmtamt		NULLABLE	INTEGER
billingmethod		NULLABLE	INTEGER
billingdefaultdays		NULLABLE	INTEGER
billingnotice		NULLABLE	INTEGER
applyasbilled		NULLABLE	INTEGER
percentprincipal		NULLABLE	INTEGER
levelpaymentamt		NULLABLE	INTEGER
levelprincipalamt		NULLABLE	INTEGER
minimumpayment		NULLABLE	INTEGER
billingnoticemin		NULLABLE	INTEGER
useratechangeprocessing	When you run the Rate Change Processing batch program, the value in this field determines whether the system updates the Payment field value for this Schedule record	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