ENCNTR_EVENT_SET_IO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Event Set Inputs Outputs
Definition: Maintains hidden categories to be displayed on the I&O Flowsheet for a given patient and encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_EVENT_SET_IO


Column Name Type Null? Definition
ENCNTR_EVENT_SET_IO_ID DOUBLE N Unique identifier for row.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EVENT_SET_NAME VARCHAR(40) N The name of the event set to be displayed on the I&O Flowsheet.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - ENCNTR_EVENT_SET_IO


Child Column in ENCNTR_EVENT_SET_IO(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


WORKING_VIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: WORKING VIEW
Definition: Specifies the working views that are applicable for a given position/location.
Table Type: REFERENCE





Column Detail - WORKING_VIEW


Column Name Type Null? Definition
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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CURRENT_WORKING_VIEW DOUBLE Y Current Working ViewColumn
DISPLAY_NAME VARCHAR(40) N The display name of this working view.
END_EFFECTIVE_DT_TM DATETIME Y 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.
LOCATION_CD DOUBLE N Specifies the location associated to a working view.
POSITION_CD DOUBLE N Specifies the position associated to a working 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.
VERSION_NUM DOUBLE N The version number of this working view.
WORKING_VIEW_ID DOUBLE N Primary Key.



Relationship Detail - WORKING_VIEW




Parent Column in WORKING_VIEW (PK) Child Table Name Child Column Name
Children: WORKING_VIEW_ID CNT_WV_KEY DCP_WV_REF_ID
WORKING_VIEW_PERSON WORKING_VIEW_ID
WORKING_VIEW_SECTION WORKING_VIEW_ID


WORKING_VIEW_FREQ_INTERVAL



Column Section Top of Page


Table-level Detail

Description: WORKING VIEW FREQ INTERVAL
Definition: Specifies the frequency intervals that are applicable for a given position.
Table Type: REFERENCE





Column Detail - WORKING_VIEW_FREQ_INTERVAL


Column Name Type Null? Definition
POSITION_CD DOUBLE N Specifies which position the interval is associated to.
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.
WORKING_VIEW_FREQ_INTERVAL_ID DOUBLE N Unique Identifier
WORKING_VIEW_INTERVAL_CD DOUBLE N A frequency interval from code set 6043.


WORKING_VIEW_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Working View Item
Definition: Specifies the items for working views that are applicable for a given position/location.
Table Type: REFERENCE





Column Detail - WORKING_VIEW_ITEM


Column Name Type Null? Definition
FALLOFF_VIEW_MINUTES DOUBLE N Specifies when to remove the item if it hasn't been documented on within the working view
INCLUDED_IND DOUBLE N Specifies whether the primitive event set is included on the working view.
PARENT_EVENT_SET_NAME VARCHAR(40) N Specifies the primitive event set parents associated to a working view section.
PRIMITIVE_EVENT_SET_NAME VARCHAR(40) N Specifies the primitive event sets associated to a working view section.
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.
WORKING_VIEW_ITEM_ID DOUBLE N Unique identifier.
WORKING_VIEW_SECTION_ID DOUBLE N FK from the working_view_section table.



Relationship Detail - WORKING_VIEW_ITEM


Child Column in WORKING_VIEW_ITEM(FK) Parent Table Name Parent Column Name
Parents: WORKING_VIEW_SECTION_ID WORKING_VIEW_SECTION WORKING_VIEW_SECTION_ID




Parent Column in WORKING_VIEW_ITEM (PK) Child Table Name Child Column Name
Children: WORKING_VIEW_ITEM_ID CNT_WV_ITEM_KEY DCP_WV_ITEM_REF_ID


WORKING_VIEW_PERSON



Column Section Relationship Section Top of Page


Table-level Detail

Description: WORKING VIEW PERSON
Definition: Specifies the working views that are applicable for a given patient encounter.
Table Type: ACTIVITY





Column Detail - WORKING_VIEW_PERSON


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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.
WORKING_VIEW_ID DOUBLE N The working view id that links this person centric content to the view content defined for a given position/location.
WORKING_VIEW_PERSON_ID DOUBLE N Primary Key.



Relationship Detail - WORKING_VIEW_PERSON


Child Column in WORKING_VIEW_PERSON(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
WORKING_VIEW_ID WORKING_VIEW WORKING_VIEW_ID




Parent Column in WORKING_VIEW_PERSON (PK) Child Table Name Child Column Name
Children: WORKING_VIEW_PERSON_ID WORKING_VIEW_PERSON_SECT WORKING_VIEW_PERSON_ID