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 |