ssdb_collateral_coll_hold_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_collateral_coll_hold_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 | |
| collateralcollholdkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| collateralkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| effectivedate | Enter the date the hold should take effect or the date the hold was created | NULLABLE | DATE | |
| idtype | The system copies this field from the Pledge record. This field defines whether the Collateral Hold record relates to an account, loan, or application | NULLABLE | INTEGER | |
| locator | This field does not appear in the system. This Locator field value in each record is unique within each Collateral record set. This means that the Locator can be used as a unique identifier for a specific record. The system automatically assigns the Locator value when the record is created, and you cannot change it. The value is a positive number greater than zero and up to about two billion | NULLABLE | INTEGER | |
| accountnumber | This field stores the account number associated with the originating loan. If the system automatically creates the Collateral Hold record, the default is the account number where the loan originated. If manually entered, the default is blank | NULLABLE | STRING | |
| id | This field stores the ID associated with the originating loan, account, or application. If the system automatically creates the Collateral Hold record and the ID Type field is set to (1) Loan or (4) Application, the default is the ID from the Pledge record that is associated with the loan or application. Otherwise, the default is blank | NULLABLE | STRING | |
| amount | This field identifies the amount of the Collateral Hold record | NULLABLE | INTEGER | |
| recordchangedate | The system stores the system date in the Record Change Date field when you create, change, or save the Collateral Hold record and updates this field whenever the record is saved, even if there are not 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