dealer_tracking_raw
Pipelined Data Sets
>
Symitar
>
dealer_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 | |
| dealertrackinguuid | This field stores a JH Platform unique identifier for a dealer tracking record | NULLABLE | STRING | |
| dealeruuid | This field stores a JH Platform unique identifier for a dealer | NULLABLE | STRING | |
| dealernumber | This field stores the dealer number | NULLABLE | STRING | |
| dealertrackingkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| dealerkey | 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 indicates how you use the Dealer Tracking record. You can define Dealer Tracking Type 30 to Dealer Tracking Type 99 in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| id | This field stores the ID number of the Tracking record. This field is not used for Application Tracking | NULLABLE | STRING | |
| idtype | This field stores the user number of the user who created the Tracking record. The system updates this field automatically. Under normal circumstances, you should not revise this field. This field is not used for Application Tracking | NULLABLE | INTEGER | |
| userid | This field stores the user number of the user who created this Dealer 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 you last performed file maintenance on the Dealer Tracking record. The system updates this field with the system date whenever you perform file maintenance of this record. You cannot revise this field | NULLABLE | DATE | |
| creationdate | The system updates this field with the current system date when you create the Dealer 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 Dealer 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 Dealer Tracking record | NULLABLE | DATE | |
| trackingcode | This field stores a user-defined code (0-99) to further identify the purpose of the Dealer Tracking record. This field is for informational purposes only. The system does not use this field | NULLABLE | INTEGER | |
| usernumber1 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber2 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber3 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber4 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber5 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber6 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber7 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber8 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber9 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber10 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| userchar1 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar2 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar3 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar4 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar5 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar6 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar7 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar8 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar9 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar10 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| useramount1 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount2 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount3 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount4 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount5 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount6 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount7 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount8 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount9 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount10 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| usercode1 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode2 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode3 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode4 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode5 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode6 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode7 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode8 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode9 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode10 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| userdate1 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate2 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate3 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate4 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate5 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate6 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate7 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate8 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate9 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate10 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userrate1 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate2 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate3 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate4 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate5 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate6 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate7 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate8 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate9 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate10 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| locator | This field stores the locator | NULLABLE | INTEGER | |
| usernumber11 | You can use these fields to store any number value you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber12 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber13 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber14 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber15 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber16 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber17 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber18 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber19 | You can use these fields to store any number value you defined in the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usernumber20 | You can use these fields to store any number value you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| userchar11 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar12 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar13 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar14 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar15 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar16 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar17 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar18 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar19 | You can use these fields to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| userchar20 | You can use this field to store any character data you defined with the Dealer File Tracking Type Parameters | NULLABLE | STRING | |
| useramount11 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount12 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount13 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount14 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount15 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount16 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount17 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount18 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount19 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| useramount20 | You can use these fields to store any money amount you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| usercode11 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode12 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode13 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode14 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode15 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode16 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode17 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode18 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode19 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| usercode20 | You can use these fields to store any user-defined code (0000-9999) data you defined with the Dealer File Tracking Type Parameters | NULLABLE | INTEGER | |
| userdate11 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate12 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate13 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate14 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate15 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate16 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate17 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate18 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate19 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userdate20 | You can use these fields to store any dates you defined with the Dealer File Tracking Type Parameters | NULLABLE | DATE | |
| userrate11 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate12 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate13 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate14 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate15 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate16 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate17 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate18 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate19 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| userrate20 | You can use these fields to store any rates you defined with the Dealer File Tracking Type Parameters | NULLABLE | NUMERIC | |
| recordchangedate | 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