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 |