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