SEARCH_SESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Search Session
Definition: Parent table to track search sessions (regardless if search is initiated by user interaction.
Table Type: ACTIVITY





Column Detail - SEARCH_SESSION


Column Name Type Null? Definition
APPLICATION_NBR DOUBLE N The application number, if applicable, that is initiating the search session. When the search session is initiated by an interactive workflow the application will be assigning the value. Will be 0 when the context of the application is not known.
DEVICE_LOCATION_TXT VARCHAR(255) Y The location of the device ("device_location" logical registry setting) from where the user initiated an interactive search session.
PCID_TXT VARCHAR(255) Y The pc identifier ("personmgmt:pcid" logical registry setting) from where the user initiated an interactive search session.
QUERY_IDENTIFICATION_CD DOUBLE N Identifies the query associated with the search session.
SEARCH_CONTEXT_KEY_TXT VARCHAR(255) Y The configuration path associated with the Java search session. This key uniquely defines the consuming workflow associated with the search.
SEARCH_MODE_CD DOUBLE N The search style/mode associated with the search session. this should correspond with the query_identification_cd.
SEARCH_SESSION_ID DOUBLE N Unique generated number that identifies a single row on the SEARCH_SESSION table.
SESSION_DT_TM DATETIME N The date and time the search session is initiated by an interactive workflow, service, or query.
TASK_NBR DOUBLE N The task number, if applicable, associated with the search session.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
USER_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that initiated a search.
USER_POSITION_CD DOUBLE N The position associated with the person from the personnel table (prsnl) when the search session was initiated.



Relationship Detail - SEARCH_SESSION


Child Column in SEARCH_SESSION(FK) Parent Table Name Parent Column Name
Parents: USER_ID PRSNL PERSON_ID




Parent Column in SEARCH_SESSION (PK) Child Table Name Child Column Name
Children: SEARCH_SESSION_ID SEARCH_SESSION_EVENT SEARCH_SESSION_ID
SEARCH_SESSION_OUTCOME SEARCH_SESSION_ID


SEARCH_SESSION_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Search Session Event
Definition: Tracks search data, including origination of the search criteria, and results associated with a search event (query_ triggered within a search session.
Table Type: ACTIVITY





Column Detail - SEARCH_SESSION_EVENT


Column Name Type Null? Definition
NUMBER_OF_RESULTS_TOT DOUBLE N Number of unique results (ids) returned in the search query.
RESULT_CD DOUBLE N The result of the search query.
SEARCH_DT_TM DATETIME N The date and time the search query was initiated.
SEARCH_DURATION_MSEC DOUBLE N The time, in milliseconds, it took to execute the search query.
SEARCH_SESSION_EVENT_ID DOUBLE N Unique generated number that identifies a single row on the SEARCH_SESSION_EVENT table.
SEARCH_SESSION_ID DOUBLE N Unique generated number that identifies a single row ont he parent table SEARCH_SESSION.
SEARCH_SUB_MODE_CD DOUBLE Y Identifies the Search Mode for the search session event.
SITE_CD DOUBLE N The database that is associated with the search event (what database was searched).
TYPE_CD DOUBLE N The origination of the search criteria.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SEARCH_SESSION_EVENT


Child Column in SEARCH_SESSION_EVENT(FK) Parent Table Name Parent Column Name
Parents: SEARCH_SESSION_ID SEARCH_SESSION SEARCH_SESSION_ID


SEARCH_SESSION_OUTCOME



Column Section Relationship Section Top of Page


Table-level Detail

Description: Search Session Outcome
Definition: Tracks the outcome of an interactive search session.
Table Type: ACTIVITY





Column Detail - SEARCH_SESSION_OUTCOME


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
DEVICE_MATCH_FOUND_CD DOUBLE N Indicates whether or not a match was found using the search criteria from a device input.
DEVICE_MATCH_USED_CD DOUBLE N Indicates whether or not the selected match was obtained using the search query results from the device input search criteria.
DEVICE_TYPE_USED_CD DOUBLE N The type of device input that was used during the search session, if applicable
DEVICE_USAGE_CD DOUBLE N The device input availability for use during the search session
DEVICE_USED_CD DOUBLE N Indicates whether or not device input was using during the search session.
OUTCOME_CD DOUBLE N The button click that ended the interactive search session.
SEARCH_SESSION_ID DOUBLE N Unique generated number that identifies a single row on the parent table SEARCH_SESSION.
SEARCH_SESSION_OUTCOME_ID DOUBLE N Unique generated number that identifies a single row on the SEARCH_SESSION_OUTCOME table.
SEARCH_SUB_MODE_USED_CD DOUBLE Y Identifies the search mode used to find the search result.
SELECTED_RESULT_ID DOUBLE N The value of the primary identifier associated with the selected search result if a match was selected from the search session (i.e., person_id, health_plan_id).
SELECTED_RESULT_NAME VARCHAR(30) Y The name of the object associated with the selected search result if a match was selected from the search session (i.e., person, health_plan)
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SEARCH_SESSION_OUTCOME


Child Column in SEARCH_SESSION_OUTCOME(FK) Parent Table Name Parent Column Name
Parents: SEARCH_SESSION_ID SEARCH_SESSION SEARCH_SESSION_ID