ssdb_loan_rate_change_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_loan_rate_change_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 | |
| loanratechangekey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| loankey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| ratechangedate | This field stores the date a new interest rate goes into effect | NULLABLE | DATE | |
| id | The ID field stores the value of the parent Loan record Loan ID field. The system updates the ID field automatically. You cannot perform file maintenance on this field. The field does not appear in the Rate Change record, but is accessible through PowerOn and EasyWriter | NULLABLE | STRING | |
| locator | The value for the Locator field is unique within each Rate Change record. So, you can use the Locator field's value as a unique identification for that record. The system automatically assigns a value to the Locator field when you or the system creates a Rate Change record. The value is a positive number from 1 billion to about 2 billion. You cannot change this value | NULLABLE | INTEGER | |
| creationdate | You cannot perform file maintenance on this field | NULLABLE | DATE | |
| recordchangedate | The system stores the system date in the Record Change Date field when you create, revise, or save the Rate Change record | NULLABLE | DATE | |
| paymentchangedate | NULLABLE | DATE | ||
| interestrate | This field stores the interest rate in effect for the loan as of the date set in the Rate Change Date field as calculated by the Rate Change Processing batch program | NULLABLE | INTEGER | |
| indexrate | This field stores the index rate value that the system used to calculate the value set in the Rate Change record Interest Rate field | NULLABLE | INTEGER | |
| reamortizedpayment | The Reamortized Payment field stores the payment amount calculated by the Rate Processing batch program when you select Yes at the Perform Payment Reamortization prompt The amount represents one periodic payment of principal, interest, and escrow | NULLABLE | INTEGER | |
| periodicstartrate | The Periodic Cap Start Rate field stores the value that the system uses in the Loan record Periodic Cap Start Rate field when the rate change takes place | NULLABLE | INTEGER | |
| periodicstartdate | The Periodic Cap Start Date field stores the value the system uses in the Loan record Periodic Cap Start Date field when the rate change takes place | 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