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