Table Detail Report

KIA_EVENT_SET_CODE_SNP



Column Section Top of Page


Table-level Detail

Description: Event Set snapshot
Definition: Event Set snapshot. - This table is a copy of the V500_Event_set_code table
Table Type: ACTIVITY





Column Detail - KIA_EVENT_SET_CODE_SNP


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.Column
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.Column
EVENT_SET_CD_DEFINITION VARCHAR(100) Y definition of the event set.Column
EVENT_SET_CD_DESCR VARCHAR(60) Y description of the event set.Column
EVENT_SET_CD_DISP VARCHAR(40) Y display of event setColumn
EVENT_SET_CD_DISP_KEY VARCHAR(40) Y key of the event set displayColumn
EVENT_SET_COLOR_NAME VARCHAR(16) Y not currently usedColumn
EVENT_SET_ICON_NAME VARCHAR(16) Y not currently usedColumn
EVENT_SET_NAME VARCHAR(40) N name of the event setColumn
EVENT_SET_NAME_KEY VARCHAR(40) Y name key of the event setColumn
EVENT_SET_STATUS_CD DOUBLE N authentication status of the event setColumn
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
LEAF_EVENT_CD_COUNT DOUBLE Y not currently usedColumn
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 usedColumn
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.
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.


KIA_EVENT_SET_CODE_VALUE_SNP



Column Section Top of Page


Table-level Detail

Description: KIA EVENT SET CODE_VALUE SNAPSHOT
Definition: This request is to create new snapshot table for code_value (code set 93 only).
Table Type: REFERENCE





Column Detail - KIA_EVENT_SET_CODE_VALUE_SNP


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME Y Same as in CODE_VALUE table
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.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ACTIVE_TYPE_CD DOUBLE N Same as in CODE_VALUE table
BEGIN_EFFECTIVE_DT_TM DATETIME Y Same as in CODE_VALUE table
CDF_MEANING VARCHAR(12) Y Same as in CODE_VALUE table
CKI VARCHAR(255) Y Same as in CODE_VALUE table
CODE_SET DOUBLE N Same as in CODE_VALUE table
CODE_VALUE DOUBLE N Same as in CODE_VALUE table
COLLATION_SEQ DOUBLE Y Same as in CODE_VALUE table
CONCEPT_CKI VARCHAR(255) Y Same as in CODE_VALUE table
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
DEFINITION VARCHAR(100) Y Same as in CODE_VALUE table
DESCRIPTION VARCHAR(60) Y Same as in CODE_VALUE table
DISPLAY VARCHAR(40) Y Same as in CODE_VALUE table
DISPLAY_KEY VARCHAR(40) Y Same as in CODE_VALUE table
DISPLAY_KEY_A_NLS VARCHAR(160) Y Same as in CODE_VALUE table
DISPLAY_KEY_NLS VARCHAR(255) Y NO LONGER USED
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
INACTIVE_DT_TM DATETIME Y Same as in CODE_VALUE table
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.


KIA_EVENT_SET_EXPLODE_SNP



Column Section Top of Page


Table-level Detail

Description: KIA EVENT SET EXPLODE SNP
Definition: Event set hierarchy snapshot
Table Type: ACTIVITY





Column Detail - KIA_EVENT_SET_EXPLODE_SNP


Column Name Type Null? Definition
EVENT_CD DOUBLE N A unique identifier for this table.Column
EVENT_SET_CD DOUBLE N A 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.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.


LOCATOR_AREA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Locator Area
Definition: Defines the placement and style of a location in the Locator application.
Table Type: REFERENCE





Column Detail - LOCATOR_AREA


Column Name Type Null? Definition
ALERT_TIME DOUBLE Y Amount of time before this location is flagged as wait time being exceeded.
BOTTOM DOUBLE Y Used to calculate height of locator area.
CAPTION VARCHAR(50) Y Not Used.
LEFT DOUBLE Y X coordinate of locator area.
LOCATION_CD DOUBLE N Unique identifier for the location the locator area represents.
LOCATOR_AREA_ID DOUBLE N Unique identifier for the locator area.
MAX_ITEMS DOUBLE Y Not Used.
RIGHT DOUBLE Y Used to calculate width of locator area.
STYLE DOUBLE Y Identifies the style of the location¿s display 0 = icon view 1 = column view.
TOP DOUBLE Y Y coordinate of locator area.
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 - LOCATOR_AREA




Parent Column in LOCATOR_AREA (PK) Child Table Name Child Column Name
Children: LOCATOR_AREA_ID LOCATOR_VIEW_AREA_R LOCATOR_AREA_ID


LOCATOR_VIEW_AREA_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Locator View Area Relation
Definition: The Locator View Area Relation table relates the locator areas with a user-defined view.
Table Type: REFERENCE





Column Detail - LOCATOR_VIEW_AREA_R


Column Name Type Null? Definition
LOCATOR_AREA_ID DOUBLE N Unique identifier from the LOCATOR_AREA table.
LOCATOR_VIEW_AREA_ID DOUBLE N Unique identifier for the table.
LOCATOR_VIEW_CD DOUBLE N Code value for the locator view.
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 - LOCATOR_VIEW_AREA_R


Child Column in LOCATOR_VIEW_AREA_R(FK) Parent Table Name Parent Column Name
Parents: LOCATOR_AREA_ID LOCATOR_AREA LOCATOR_AREA_ID