Table Detail Report

V500_EVENT_SET_CANON



Column Section Top of Page


Table-level Detail

Description: V500 EVENT SET CANON
Definition: Reference table describing the parent/child relationship between event sets.
Table Type: REFERENCE





Column Detail - V500_EVENT_SET_CANON


Column Name Type Null? Definition
EVENT_SET_CD DOUBLE N Child event set code
EVENT_SET_COLLATING_SEQ DOUBLE Y The sequence number of the child event set within the parent event set.
EVENT_SET_EXPLODE_IND DOUBLE Y Defines the explode of the event set.
EVENT_SET_STATUS_CD DOUBLE N Code to describe the status of the event set.
PARENT_EVENT_SET_CD DOUBLE N Code to describe the parent event set.
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.


V500_EVENT_SET_CODE



Column Section Top of Page


Table-level Detail

Description: V500 event set code table
Definition: Contains extra fields for event sets not stored in the code_value table
Table Type: REFERENCE





Column Detail - V500_EVENT_SET_CODE


Column Name Type Null? Definition
ACCUMULATION_IND DOUBLE Y Display the accumulation of the numeric data element as it occurs in the flowsheet. i.e. 25/25, 5/30, 15/45 ...
CATEGORY_FLAG DOUBLE Y User defined level indicating the level of grouping for the event set 7 '1' Flowsheet level 7 '2' Category level 7 '3' Section level 7 '4' Group level
CODE_STATUS_CD DOUBLE N data status code of this row
COMBINE_FORMAT VARCHAR(200) Y Defines the format for composite fields. i.e. (bp dia / bp sys)
DISPLAY_ASSOCIATION_IND DOUBLE N The grouping of Event codes can be accomplished by setting the display_association_ind for the primitive + 1 level to allow for grouping all of the primitives below this group into a single flowsheet cell. Front end applications will handle the grouping as required.
EVENT_SET_CD DOUBLE N unique primary key for this table
EVENT_SET_CD_DEFINITION VARCHAR(100) Y Definition of event set
EVENT_SET_CD_DESCR VARCHAR(60) Y Description of the event set
EVENT_SET_CD_DISP VARCHAR(40) Y Display of event set
EVENT_SET_CD_DISP_KEY VARCHAR(40) Y Key of event set display
EVENT_SET_COLOR_NAME VARCHAR(16) Y Not currently used
EVENT_SET_ICON_NAME VARCHAR(16) Y Not currently used
EVENT_SET_NAME VARCHAR(40) N Name of the event set
EVENT_SET_NAME_KEY VARCHAR(40) Y Name key of the event set
EVENT_SET_NAME_UPPER_VC VARCHAR(40) Y Uppercase version of EVENT_SET_NAME
EVENT_SET_STATUS_CD DOUBLE N Authentication status of event set
GROUPING_RULE_FLAG DOUBLE Y Defines rules on how to display data for an event set when there are more than one result in the cell 7 '1' First result in the valid cell range 7 '2' Last result in the valid cell range 7 '3' Sum of all results 7 '4' Average of all results 7 '5' Median 7 '6' Count
LEAF_EVENT_CD_COUNT DOUBLE Y Not currently used
OPERATION_DISPLAY_FLAG DOUBLE Y Determines how to display the calculated result 7 '1' Before the first event set 7 '2' After the last event set 7 '3' Only display the calculated results but not the individual event sets
OPERATION_FORMULA VARCHAR(200) Y A string of characters that describes the formula for a calculation i.e. (bp dia + bp sys)/2, Sum(IV), etc.
PRIMITIVE_EVENT_SET_COUNT DOUBLE Y Not currently used
SHOW_IF_NO_DATA_IND DOUBLE Y Determines if the data element ought to be displayed if it does not contain any data within the flowsheet valid time range
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.


V500_EVENT_SET_CODE_MODS



Column Section Top of Page


Table-level Detail

Description: V500 Event Set Code Modifications
Definition: Stores a reference to a subset of changes on V500_EVENT_SET_CODE.
Table Type: ACTIVITY





Column Detail - V500_EVENT_SET_CODE_MODS


Column Name Type Null? Definition
EVENT_SET_CD DOUBLE N Refers to the event set in V500_EVENT_SET_CODE that is being tracked.
LOGICAL_CNT DOUBLE N A logical counter of changes for the lifetime of the table
LOGICAL_CNT_INDEX_SEQ DOUBLE N The window/tracking mechanism for when values should be inserted or overridden, this basically is the pointer to the next entry in the array.
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.
V500_EVENT_SET_CODE_MODS_ID DOUBLE N Unique generated number that identifies a single row on the V500_EVENT_SET_CODE_MODS table.


V500_EVENT_SET_EXPLODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: V500 EVENT SET EXPLODE
Definition: Reference table defining relationships between event sets and event codes.
Table Type: REFERENCE





Column Detail - V500_EVENT_SET_EXPLODE


Column Name Type Null? Definition
EVENT_CD DOUBLE N A unique identifier for this table.
EVENT_SET_CD DOUBLE N A foreign key to the v500_event_set_code table.
EVENT_SET_LEVEL DOUBLE Y The number of event sets between the event code and the event set of the row. For a primitive event set the number would be zero, for the next event set the number would be one and the value will increase so on as it heads towards ALLOCFRESULTS.
EVENT_SET_STATUS_CD DOUBLE N Describes the status of the event set.
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.



Relationship Detail - V500_EVENT_SET_EXPLODE


Child Column in V500_EVENT_SET_EXPLODE(FK) Parent Table Name Parent Column Name
Parents: EVENT_CD V500_EVENT_CODE EVENT_CD