ssdb_collateral_document_tracking_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_collateral_document_tracking_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 | |
| collateraldocumenttrackingkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| collateraldocumentkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| collateralkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| type | This field indicates how you use the Collateral Document Tracking record | NULLABLE | INTEGER | |
| id | This field is not used for Collateral Document Tracking records | NULLABLE | STRING | |
| idtype | This field is not used for Collateral Document Tracking records | NULLABLE | INTEGER | |
| userid | This field stores the user number of the user who created the Collateral Document Tracking record | NULLABLE | INTEGER | |
| fmlastdate | This field stores the date that file maintenance was last performed on the Collateral Document Tracking record | NULLABLE | DATE | |
| creationdate | This field stores the current system date when you create the Collateral Document Tracking record | NULLABLE | DATE | |
| creationtime | This field stores the current system time (HHMM) when you create the Collateral Document Tracking record | NULLABLE | INTEGER | |
| expiredate | This field stores the expiration date for the Collateral Document Tracking record | NULLABLE | DATE | |
| trackingcode | This field stores a user-defined code to further identify the purpose of the Collateral Document Tracking record | NULLABLE | INTEGER | |
| usernumber1 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber2 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber3 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber4 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber5 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber6 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber7 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber8 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber9 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber10 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| userchar1 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar2 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar3 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar4 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar5 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar6 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar7 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar8 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar9 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar10 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| useramount1 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount2 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount3 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount4 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount5 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount6 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount7 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount8 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount9 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount10 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode1 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode2 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode3 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode4 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode5 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode6 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode7 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode8 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode9 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode10 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| userdate1 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate2 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate3 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate4 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate5 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate6 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate7 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate8 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate9 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate10 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userrate1 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate2 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate3 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate4 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate5 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate6 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate7 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate8 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate9 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate10 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| locator | This field value in each record is unique for each member account | NULLABLE | INTEGER | |
| usernumber11 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber12 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber13 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber14 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber15 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber16 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber17 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber18 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber19 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| usernumber20 | These fields store any user-defined numbers for tracking types 30-99 | NULLABLE | INTEGER | |
| userchar11 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar12 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar13 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar14 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar15 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar16 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar17 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar18 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar19 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| userchar20 | These fields store any user-defined character data for tracking types 30-99 | NULLABLE | STRING | |
| useramount11 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount12 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount13 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount14 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount15 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount16 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount17 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount18 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount19 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| useramount20 | These fields store any user-defined amounts for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode11 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode12 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode13 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode14 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode15 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode16 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode17 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode18 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode19 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| usercode20 | These fields store any user-defined codes for tracking types 30-99 | NULLABLE | INTEGER | |
| userdate11 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate12 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate13 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate14 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate15 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate16 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate17 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate18 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate19 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userdate20 | These fields store any user-defined dates for tracking types 30-99 | NULLABLE | DATE | |
| userrate11 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate12 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate13 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate14 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate15 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate16 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate17 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate18 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate19 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| userrate20 | These fields store any user-defined rates for tracking types 30-99 | NULLABLE | INTEGER | |
| recordchangedate | This field stores the system date when you create, change, or save 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