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. |