ent_logon
- Last UpdatedNov 12, 2024
- 1 minute read
The ent_logon table defines the list of entities that a given user is logged onto for a given session. Used by Operator when a user controls one or more entities.
|
Field |
Datatype |
PK |
Nulls |
Description |
|---|---|---|---|---|
|
session_id |
int32 |
Y |
N |
Identify the session |
|
ent_id |
int32 |
Y |
N |
Identify entity logged onto |
|
user_id |
string40 |
Y |
N |
Identify user logged on to each entity |
|
start_time |
tdatetime |
N |
N |
Datetime this logon occurred in UTC |
|
cur_lab_cd |
string40 |
N |
Y |
Default labor code for this user/entity |
|
pct_lab_to_apply |
tfloat |
N |
Y |
% of labor time to apply, if logged on to > 1 entity at a time |
|
cur_lab_dept_id |
string40 |
N |
Y |
Current labor dept. (cost center) |
|
cur_lab_usage_log_id |
int32 |
N |
Y |
Current active row in labor_usage table. (Not reliable if there is more than one job_exec per entity.) |
|
row_id |
ID0 |
N |
N |
Unique row identifier, for audit trail |
FK from session_id to session. (Cascade delete)
FK from ent_id to ent. (Inhibit delete)
FK from user_id to user_name. (Inhibit delete)
FK from cur_lab_cd to labor_cat. (Inhibit delete)
FK from cur_lab_dept_id to labor_dept. (Inhibit delete)
FK from cur_lab_usage_log_id to labor_usage. (Inhibit delete)