ssdb_collateral_document_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_collateral_document_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 | |
| collateraldocumentkey | 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 | |
| type | This field stores a credit union-defined code identifying the type of document being tracked | NULLABLE | INTEGER | |
| locator | This field stores a unique number within each Collateral record set that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| number | This field stores a unique identifier defined when you create a Collateral Document record | NULLABLE | STRING | |
| description | This field stores the description of the document defined in Document Defaults in the Default Manager for this type of document | NULLABLE | STRING | |
| location | This field stores the description of the physical location where the document is stored | NULLABLE | STRING | |
| accountnumber | This field stores the account number associated with the originating loan | NULLABLE | STRING | |
| slid | This field stores the ID associated with the originating loan or account | NULLABLE | STRING | |
| slidtype | This field stores a code that defines whether the Collateral Document record relates to an account or a loan and is used to determine where all document exception notices are mailed, using standard address logic | NULLABLE | INTEGER | |
| documentdate | This field stores the date of a particular document, if any | NULLABLE | DATE | |
| receiveddate | This field stores the date the credit union received the document | NULLABLE | DATE | |
| expiredate | This field stores the date the document expires or is stale-dated | NULLABLE | DATE | |
| statusdate | This field stores the date that the Status field was changed to the current status in the Document record | NULLABLE | DATE | |
| excpnoticedate | This field stores the date the latest document exception notice was generated during batch processing | NULLABLE | DATE | |
| status | This field stores a code that indicates the status of the document being tracked | NULLABLE | INTEGER | |
| excpnoticecount | This field stores the total number of document exception notices generated for the Collateral Document record | NULLABLE | INTEGER | |
| officercode | This field stores a credit union-defined code to identify the loan officer who either originated the loan that relates to the document being tracked or is charged with servicing the loan | NULLABLE | INTEGER | |
| branch | This field stores a credit union-defined code to identify the branch related to the document | NULLABLE | INTEGER | |
| excpnoticeoption | This field stores a code that indicates whether to create document exception notices or not | NULLABLE | INTEGER | |
| userchar1 | This field can store the first custom information defined for the Collateral Document record | NULLABLE | STRING | |
| userchar2 | This field can store the second custom information defined for the Collateral Document record | NULLABLE | STRING | |
| userchar3 | This field can store the third custom information defined for the Collateral Document record | NULLABLE | STRING | |
| userchar4 | This field can store the fourth custom information defined for the Collateral Document record | NULLABLE | STRING | |
| userchar5 | This field can store the fifth custom information defined for the Collateral Document record | NULLABLE | STRING | |
| userchar6 | This field can store the sixth custom information defined for the Collateral Document record | NULLABLE | STRING | |
| excpnoticecountcpwork | This field stores a code to specify when the system should generate a Document Exception Work Card | NULLABLE | INTEGER | |
| recordchangedate | This field stores the system date in this field when you create, change, or save the Collateral Document 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 | |
| lastfmdate | This field stores the current system date whenever there is any file maintenance affecting this Collateral Document 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