View the Event Log Table
In the Event Log Table, you can view common fields that can be used such as Dates, Outcomes and Enrollment information. This table also provides the fields that enable events to share common attributes such as locking ability, progress note entry and providing services (Only Events can have Services and Progress notes). With this central table, reporting and comparing this data begins with one central location.
Menu path
Setup > User Tools > Data Dictionary > All Tables
View the Event Log Table
- Navigate to the following path: Setup > User Tools > Data Dictionary > All Tables.
- In the toolbar, click > Filter Settings.
- In the filter dialog, in the Table Name row, in the Operator field, select Contains.
- In the Table Name row, in the Filter Expression field, type event_log.
- Click Apply.
- Select event_log in the list of table names.
- To view table details, click the + to expand the information.
- To view specific values, click Non-Primary Key Columns.
Field Values
|
Event_log_id |
|
People_id |
|
Group_Profile_id |
|
Groups_id |
|
Event_definition_id |
|
Is Initial |
|
Is Manual |
|
Completed |
|
Is_locked |
|
Date locked |
|
Locked by |
|
Approved by |
|
Approved Date |
|
Approve Remarks |
|
Belongs to Event |
|
Created by Event *Not intended to be touched by the agency |
|
Service Track Event id *Not intended to be touched by the agency |
|
Program Enrollment Event id |
|
Group Event Id *Not intended to be touched by the agency |
|
Actual date |
|
End Date |
|
Expiration Date |
|
Target End Date |
|
Due Date |
|
Scheduled Date |
|
Opening Reason id |
|
Closing Reason id |
|
Outcome id |
|
Staff id |
|
Program Providing Service |
|
Site Providing Service |
|
Generic remarks |