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 |