Table Detail Report

TRACK_SENSOR



Column Section Top of Page


Table-level Detail

Description: TRACK SENSOR
Definition: Table used to define the tracking sensors and their locations
Table Type: REFERENCE





Column Detail - TRACK_SENSOR


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ASSIGN_IND DOUBLE Y Assignment IndicatorColumn
LOCATION_CD DOUBLE N Location Code where the sensor existsColumn
MANUF_SENSOR VARCHAR(30) Y Manufacture SensorColumn
MANUF_TYPE_CD DOUBLE N Manufacture type codeColumn
TRACK_SENSOR_ID DOUBLE N Unique identifier used to identify the tracking sensorColumn
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


TRACK_TRIGGERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACK TRIGGERS
Definition: This table has all the trigger information
Table Type: REFERENCE





Column Detail - TRACK_TRIGGERS


Column Name Type Null? Definition
ACTION_TYPE VARCHAR(50) N This column stores what action needs to be performedColumn
ACTION_VALUE VARCHAR(50) N This stores what action valuesColumn
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.
CONVERSATION_ID DOUBLE N This stores the pm conversation identifier with the firstnet taskColumn
FREQUENCY VARCHAR(5) Y This stores whether the trigger should happen once or alwaysColumn
PRIORITY_SEQUENCE DOUBLE Y priority sequence
REGISTRATION_KEY_TXT VARCHAR(255) N this stores the registration key
STATUS VARCHAR(50) Y This is used for event statuses.Column
TRACK_GROUP DOUBLE N This stores the tracking_groupColumn
TRACK_TRIGGER_ID DOUBLE N auto generated key for the tableColumn
TRIGGER_KEY VARCHAR(200) N this stores the trigger key from the conversationColumn
TRIGGER_VALUE VARCHAR(50) N this stores the trigger value.Column
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 - TRACK_TRIGGERS




Parent Column in TRACK_TRIGGERS (PK) Child Table Name Child Column Name
Children: TRACK_TRIGGER_ID TRACK_TRIGGER_ACTIVITY TRACK_TRIGGER_ID


TRACK_TRIGGER_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACK TRIGGER ACTIVITY
Definition: This table stores the patients trigger activities
Table Type: ACTIVITY





Column Detail - TRACK_TRIGGER_ACTIVITY


Column Name Type Null? Definition
ACTION_TYPE VARCHAR(50) N what action type triggers this actionColumn
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
NEW_VALUE VARCHAR(50) Y What value got stored due to the trigger action.Column
OLD_VALUE VARCHAR(50) Y what was before the trigger actionColumn
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
TRACKING_ID DOUBLE N Tracking Id of the patientColumn
TRACK_TRIGGER_ACTIVITY_ID DOUBLE N auto generated key for the tableColumn
TRACK_TRIGGER_ID DOUBLE N from track_triggers table to validate the trigger actionColumn
TRIGGER_DT_TM DATETIME N when the trigger happened.Column
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
USER_ID VARCHAR(50) Y who triggered this actionColumn



Relationship Detail - TRACK_TRIGGER_ACTIVITY


Child Column in TRACK_TRIGGER_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
TRACKING_ID TRACKING_ITEM TRACKING_ID
TRACK_TRIGGER_ID TRACK_TRIGGERS TRACK_TRIGGER_ID


TRACK_VIEW_FIELD_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking View Field List
Definition: Stores display configuration and the list of fields that will be displayed in a tracking view.
Table Type: REFERENCE





Column Detail - TRACK_VIEW_FIELD_LIST


Column Name Type Null? Definition
BACK_COLOR DOUBLE N Background color for the tracking view
FONT_COLOR DOUBLE N Font color for view
FONT_FACE VARCHAR(64) N Font face for view
FONT_SIZE DOUBLE N Font size for view
FONT_STYLE DOUBLE N Font Style for view
FREEZE_FIELD DOUBLE N Field after which the spreadsheet will scroll
GROUP_BACK_COLOR DOUBLE N The background color for grouper rows
GROUP_FONT_COLOR DOUBLE N The font color for grouper rows
GROUP_FONT_FACE VARCHAR(64) N The font face for grouper rows
GROUP_FONT_SIZE DOUBLE N The font size for grouper rows
GROUP_FONT_STYLE DOUBLE N Bitmask of font styles, BOLD = 1, ITALIC = 2
GROUP_HEADER_TXT VARCHAR(64) N Indicates what the rows are being grouped by.
GROUP_MAX_ROW_CNT DOUBLE N max row count for group
GROUP_ROWS_IND DOUBLE N Stores whether this tracking view will group rows according to the first sorted field or not.
LIST_TYPE_FLAG DOUBLE N Not Specified = 0, Group List = 1, Bed List = 2, Location List = 4, Provider List = 8, Case Tracking List = 16
SOLUTION_FLAG DOUBLE N Flag that specifies for which solution this tracking view field list is valid. FirstNet, SurgiNet, etc.
TRACK_VIEW_FIELD_LIST_ID DOUBLE N Primary Key
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VIEW_NAME VARCHAR(64) N View Name for tracking view



Relationship Detail - TRACK_VIEW_FIELD_LIST




Parent Column in TRACK_VIEW_FIELD_LIST (PK) Child Table Name Child Column Name
Children: TRACK_VIEW_FIELD_LIST_ID TRACK_FIELD_SPEC TRACK_VIEW_FIELD_LIST_ID
TRACK_LIST TRACK_VIEW_FIELD_LIST_ID