| View Name: | session_status_view |
| View Number: | 5974 |
| Group: | Analytics |
| Description: | Retrieves all Sessions, Analysis and it's data. Used in hierarchy_tree.jsp |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | se_session | objid | Internal record number of se_session | 3 (UNIQUE) |
| name | se_session | name | Name of the session | |
| user_objid | user | objid | Internal record number of user | |
| gbstelm_title | gbst_elm | title | Name of the item/element | |
| gbstelm_rank | gbst_elm | rank | Position of the item in the list; important in tracking scheduled/unscheduled and config time for service interuption report | |
| an_objid | dm_analysis | objid | Internal record number of dm_analysis |
| Join From | Join To |
|---|---|
| (se_session).session_owner2user | (user).owner2se_session |
| (se_session).session2gbst_elm | (gbst_elm).state2se_session |
| (se_session).session2dm_analysis | (dm_analysis).dm_analysis2se_session |
| session_status_view | |||