ssdb_user_tracking_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_user_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 | |
| usertrackingkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| userkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| type | Enter a credit union-defined code (0-99) to indicate how to use the User Tracking record | NULLABLE | INTEGER | |
| id | This field stores the ID number of the Tracking record. This field is not used in the User Tracking record | NULLABLE | STRING | |
| idtype | This field is not used in the User Tracking record and will always have a value of 0 | NULLABLE | INTEGER | |
| userid | This field stores the user number of the user who created the User Tracking record. The system updates this field automatically. Under normal circumstances, you should not revise this field | NULLABLE | INTEGER | |
| fmlastdate | This field stores the date file maintenance was last performed on the Tracking record. The system updates this field with the system date whenever you perform file maintenance of the Tracking record. You cannot perform file maintenance on this field | NULLABLE | DATE | |
| creationdate | The system updates this field with the current system date when you create the Tracking record. Under normal circumstances, you should not revise this field | NULLABLE | DATE | |
| creationtime | The system updates this field with the current system time (HHMM) when you create the Tracking record. Under normal circumstances, you should not revise this field | NULLABLE | INTEGER | |
| expiredate | You can use this field to store an expiration date for the Tracking record. Purge Account Processing can use this field to determine if this Tracking record is eligible for the purge if it meets all other purge criteria | NULLABLE | DATE | |
| trackingcode | This field stores a credit union-defined code (0-99) to further identify the purpose of the Tracking record. This field is for informational purposes only. The system does not use this field | NULLABLE | INTEGER | |
| usernumber1 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber2 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber3 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber4 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber5 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber6 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber7 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber8 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber9 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber10 | You can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userchar1 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar2 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar3 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar4 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar5 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar6 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar7 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar8 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar9 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar10 | You can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| useramount1 | You can use this field to store any credit union-defined amount. You can defined the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount2 | You can use this field to store any credit union-defined amount. You can defined the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount3 | You can use this field to store any credit union-defined amount. You can defined the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount4 | You can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount5 | You can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount6 | You can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount7 | You can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount8 | You can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount9 | You can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount10 | You can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode1 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode2 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode3 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode4 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode5 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode6 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode7 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode8 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode9 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode10 | You can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userdate1 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate2 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate3 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate4 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate5 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate6 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate7 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate8 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate9 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate10 | You can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userrate1 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate2 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate3 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate4 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate5 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate6 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate7 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate8 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate9 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate10 | You can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| locator | The Locator field value in each record is unique within each member account. This means that the Locator can be used as a unique identification of 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 | |
| usernumber11 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber12 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber13 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber14 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber15 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber16 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber17 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber18 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber19 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber20 | For Tracking Types 30-99, you can use this field to store any credit union-defined number. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userchar11 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar12 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar13 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar14 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar15 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar16 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar17 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar18 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar19 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| userchar20 | For Tracking Types 30-99, you can use this field to store any credit union-defined character data (up to 40 characters). You can define the field name with the Tracking Type Parameters | NULLABLE | STRING | |
| useramount11 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount12 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount13 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount14 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount15 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount16 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount17 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount18 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount19 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| useramount20 | For Tracking Types 30-99, which are credit union-defined, you can use this field to store any credit union-defined amount. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode11 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode12 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode13 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode14 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode15 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode16 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode17 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode18 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode19 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode20 | For Tracking Types 30-99, you can use this field to store any credit union-defined code (0-9999). You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userdate11 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate12 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate13 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate14 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate15 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate16 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate17 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate18 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate19 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userdate20 | For Tracking Types 30-99, you can use this field to store any credit union-defined date. You can define the field name with the Tracking Type Parameters | NULLABLE | DATE | |
| userrate11 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate12 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate13 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate14 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate15 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate16 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate17 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate18 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate19 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| userrate20 | For Tracking Types 30-99, you can use this field to store any credit union-defined rate. You can define the field name with the Tracking Type Parameters | NULLABLE | INTEGER | |
| recordchangedate | The system stores the system date in the Record Change Date field when you create, change, or save the record. There will be times when the system updates the Record Change Date 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