Table Detail Report

REF_CD_MAP_HEADER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference Code Mapping Header
Definition: Header table used to store associations betwen results (events, orders, etc.) and reference codes (nomenclature_ids).
Table Type: ACTIVITY





Column Detail - REF_CD_MAP_HEADER


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N The encounter financial id for the result.
EVENT_ID DOUBLE N The clinical_event for the result associated with a reference code.
PERSON_ID DOUBLE N The person the result pertains to.
REF_CD_MAP_HEADER_ID DOUBLE N Unique, generated number that identifies a single row on the REF_CD_MAP_HEADER 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.



Relationship Detail - REF_CD_MAP_HEADER


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




Parent Column in REF_CD_MAP_HEADER (PK) Child Table Name Child Column Name
Children: REF_CD_MAP_HEADER_ID REF_CD_MAP_DETAIL REF_CD_MAP_HEADER_ID


RES_CD_ARG_QUEUE



Column Section Top of Page


Table-level Detail

Description: Result Code Argument Queue
Definition: Additional arbitrary data needed to accommodate reference code assignment.
Table Type: ACTIVITY





Column Detail - RES_CD_ARG_QUEUE


Column Name Type Null? Definition
ARG_GROUP_SEQ DOUBLE N The sequence of this argument group in relation to a particular contributor system and reference number.
ARG_NAME VARCHAR(30) N The name of the argument which describes what the argument value is defining.
ARG_SEQ DOUBLE N The sequence of this argument in relation to a particular contributor system and reference number.
ARG_VALUE DOUBLE Y The value of the argument. The meaning of the argument is described by the argument name.
ASSIGNMENT_METHOD_CD DOUBLE N Assignment method which was used to make the reference code assignment.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
REFERENCE_NBR_TXT VARCHAR(100) N The combination of the reference number and the contributor system code provides a unique identifier to the origin of the data.
RES_CD_ARG_QUEUE_ID DOUBLE N Uniquely identifies data needed to accommodate reference code assignment.
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.


SUCCESSION_TYPE_CD



Column Section Top of Page


Table-level Detail

Description: SUCCESSION TYPE CODE
Definition: SUCCESSION TYPE CODE VALUES TABLE
Table Type: REFERENCE





Column Detail - SUCCESSION_TYPE_CD


Column Name Type Null? Definition
CODE_DEFINITION VARCHAR(40) Y Code Definition
CODE_DESCR VARCHAR(20) Y Code Description
CODE_DISP VARCHAR(12) Y Code Display
CODE_DISP_KEY VARCHAR(12) N Code Display Key
CODE_STATUS_CD DOUBLE N Code Status Code
COLLATING_SEQ DOUBLE Y Collating Sequence
SUCCESSION_TYPE_CD DOUBLE N Succession Type Code
SUCCN_CLASS_CD DOUBLE N Succession Class Code
SUCCN_PRIORITY DOUBLE Y Succession Priority
SUCCN_STATUS_CD DOUBLE N Succession Status Code
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_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference table storing clincial event codes.
Definition: Reference table storing clincial event codes. One to one mapping with code set 72.
Table Type: REFERENCE





Column Detail - V500_EVENT_CODE


Column Name Type Null? Definition
CODE_STATUS_CD DOUBLE N Describes the event code status.
COLLATING_SEQ DOUBLE N Defines an ordering of sections within an MDOC.
DEF_DOCMNT_ATTRIBUTES VARCHAR(255) Y Describes the attributes of the default document.
DEF_DOCMNT_FORMAT_CD DOUBLE N Code for the default document format.
DEF_DOCMNT_STORAGE_CD DOUBLE N Code for the default document storage.
DEF_EVENT_CLASS_CD DOUBLE N Code for the default event class.
DEF_EVENT_CONFID_LEVEL_CD DOUBLE N Code for the default event confidence level.
DEF_EVENT_LEVEL DOUBLE Y The default value for the view_level field in the clinical_event table if one is not specified in the ensure. The view level controls the viewability of a clinical_event row in the flowsheet, where a value of 0 would not be viewable, 1 would be viewable at the lowest granularity of time, and 9 would be viewable at the highest granularity of time.
EVENT_ADD_ACCESS_IND DOUBLE Y Flag to indicate if events of this type can be added by PowerChart.
EVENT_CD DOUBLE N It is the code that identifies the most basic unit of storage.
EVENT_CD_DEFINITION VARCHAR(100) Y Definition of the event code.
EVENT_CD_DESCR VARCHAR(60) Y Description of the event code.
EVENT_CD_DISP VARCHAR(40) Y Event code display name key.
EVENT_CD_DISP_KEY VARCHAR(40) Y Defines the key to the event code display name.
EVENT_CD_SUBCLASS_CD DOUBLE N Obsolete field
EVENT_CHG_ACCESS_IND DOUBLE Y Flag to indicate of events of this type can be changed by PowerChart.
EVENT_CODE_STATUS_CD DOUBLE N Code for the event code status.
EVENT_SET_NAME VARCHAR(40) Y A foreign key to the v500_event_set_code table to define hierarchy, display rules, calculation rules, etc.
RETENTION_DAYS DOUBLE Y Number of days events with this event code should exist before being purged.
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.



Relationship Detail - V500_EVENT_CODE




Parent Column in V500_EVENT_CODE (PK) Child Table Name Child Column Name
Children: EVENT_CD OUTCOME_ACTIVITY EVENT_CD
OUTCOME_CATALOG EVENT_CD
V500_EVENT_SET_EXPLODE EVENT_CD


V500_EVENT_CODE_MODS



Column Section Top of Page


Table-level Detail

Description: V500 Event Code Modifications
Definition: Stores a reference to a subset of changes on V500_EVENT_CODE.
Table Type: ACTIVITY





Column Detail - V500_EVENT_CODE_MODS


Column Name Type Null? Definition
EVENT_CD DOUBLE N It is the code that identifies the most basic unit of storage.
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_CODE_MODS_ID DOUBLE N Unique generated number that identifies a single row on the V500_EVENT_CODE_MODS table.