activity_raw
Pipelined Data Sets
>
Symitar
>
activity_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 | |
| activityuuid | This field stores a JH Platform unique identifier for an activity | NULLABLE | STRING | |
| useruuid | This field stores a JH Platform unique identifier for a user | NULLABLE | STRING | |
| usernumber | This field is the identification number assigned to this user (0-9999) | NULLABLE | STRING | |
| activitykey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| userkey | 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 | |
| date | This field stores the current date whenever a user touches or visits a system access point (a prompt with a related help file) | NULLABLE | DATE | |
| time | This field stores the current time whenever a user touches or visits a system access point (a prompt with a related help file) | NULLABLE | INTEGER | |
| console | This field stores the console number at which a user is working whenever that user touches or visits a system access point (a prompt with a related help file) | NULLABLE | INTEGER | |
| branch | This field stores the branch number at which a user is working whenever that user touches or visits a system access point (a prompt with a related help file) | NULLABLE | INTEGER | |
| session | This field stores the terminal session in which a user is working whenever that user touches or visits a system access point (a prompt with a related help file) | NULLABLE | INTEGER | |
| helpcode | This field stores the help code for the prompts a user touches or visits while using the system | NULLABLE | INTEGER | |
| userinput | This field stores the entry a user makes at a prompt with a related help code | NULLABLE | STRING |
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