ssdb_collateral_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_collateral_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 | |
| collateralkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| type | This field stores a credit union-defined code identifying the type of collateral | NULLABLE | INTEGER | |
| lastfmdate | This field stores the current system date whenever there is any file maintenance of a Collateral record | NULLABLE | DATE | |
| fmlastpurgedate | This field stores the date through which file maintenance history for the value in the Collateral Type field was last purged by the Purge Transaction Processing batch program | NULLABLE | DATE | |
| createdate | This field stores the current system date when you create the Collateral record | NULLABLE | DATE | |
| expiredate | This field stores the date the Collateral record expires | NULLABLE | DATE | |
| valuedate | This field stores the date that the value in the Collateral Value field was obtained | NULLABLE | DATE | |
| number | This field stores a unique identifier defined when you create a Collateral record | NULLABLE | STRING | |
| collateralowner | This field stores the name of the collateral owner | NULLABLE | STRING | |
| description | This field stores the description of the collateral defined in the Collateral Type Parameters for the type of collateral | NULLABLE | STRING | |
| valuesource | This field stores the source used to value the collateral | NULLABLE | STRING | |
| value | This field stores the dollar value of the collateral described in the Collateral record | NULLABLE | INTEGER | |
| userchar1 | This field can store the first custom information defined for the Collateral record | NULLABLE | STRING | |
| userchar2 | This field can store the second custom information defined for the Collateral record | NULLABLE | STRING | |
| userchar3 | This field can store the third custom information defined for the Collateral record | NULLABLE | STRING | |
| userchar4 | This field can store the fourth custom information defined for the Collateral record | NULLABLE | STRING | |
| userchar5 | This field can store the fifth custom information defined for the Collateral record | NULLABLE | STRING | |
| userchar6 | This field can store the sixth custom information defined for the Collateral record | NULLABLE | STRING | |
| requireddocumentlist | This field stores the list of required documents for the collateral for the corresponding collateral type defined in the Collateral Type parameters | NULLABLE | STRING | |
| recordchangedate | This field stores the system date in this field when you create, change, or save the Collateral 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