Table Detail Report

DRUG_CLASS_INT_CUSTOM



Column Section Relationship Section Top of Page


Table-level Detail

Description: DRUG CLASS CUSTOM INTERACTIONS
Definition: Store identifiers for class to class, class to drug custom interactions.
Table Type: REFERENCE





Column Detail - DRUG_CLASS_INT_CUSTOM


Column Name Type Null? Definition
COMBO_IND DOUBLE N This would store 0 or 1 to represent the customization includes combination drugs (1) or not (0)
CUSTOM_INTERACTION_FLAG DOUBLE N Custom Interaction type. 1 - Drug/Drug Interaction 2 - Drug/Allergy Interaction 3 - Drug/Food Interaction 4 - Duplicate Therapy Interaction
CUSTOM_TYPE_FLAG DOUBLE N CUSTOM TYPE FLAG - 0 - dnum to dnum 1 - class to dnum 2 - class to class
DRUG_CLASS_INT_CUSTOM_ID DOUBLE N PRIMARY KEY
ENTITY1_DISPLAY VARCHAR(255) N DISPLAY FIELD TEXT
ENTITY1_IDENT VARCHAR(40) N Entity Identifier 1
ENTITY2_DISPLAY VARCHAR(255) N DISPLAY FIELD TEXT
ENTITY2_IDENT VARCHAR(40) N Entity Identifier 2
LONG_TEXT_ID DOUBLE N FK value from the LONG_TEXT 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 - DRUG_CLASS_INT_CUSTOM


Child Column in DRUG_CLASS_INT_CUSTOM(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in DRUG_CLASS_INT_CUSTOM (PK) Child Table Name Child Column Name
Children: DRUG_CLASS_INT_CUSTOM_ID DRUG_CLASS_INT_CSTM_ENTITY_R DRUG_CLASS_INT_CUSTOM_ID


ICD10_EXTENSION



Column Section Top of Page


Table-level Detail

Description: ICD10 EXTENSION
Definition: Additional attributes for ICD-10 vocabulary used to drive functionality.
Table Type: REFERENCE





Column Detail - ICD10_EXTENSION


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME 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_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_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ACTIVITY_REQUIRED_IND DOUBLE Y Indicates whether or not an Activity when Injured Code is required when this code is used.
AGE_CHECK_IND DOUBLE Y Indicates whether an age check is available.
AGE_HIGH DOUBLE Y High age value stored in days.Column
AGE_LOW DOUBLE Y Low age value stored in days.Column
AGE_TYPE_EDIT_FLAG DOUBLE Y All age-flagged codes will require an age type edit.
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.
BLOCK_NBR_TXT VARCHAR(10) Y The block number is used to group icd10-am procedures together.
CANCER_NOTIFICATION_IND DOUBLE Y Indicates whether a cancer notification form is to be completed for this diagnosis. 0 = Not required; 1 = Required.
CODE_FORM_FLAG DOUBLE Y Indicates the 'form' of a code.
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.
EXTERNAL_CAUSE_FLAG DOUBLE Y Indicates whether an external cause code is required for use with this code.
ICD10_EXTENSION_ID DOUBLE N Primary key identifier for the ICD10_Extension table.
OCCURRENCE_LOC_REQUIRED_IND DOUBLE Y Indicates whether or not a Place of Occurrence Code is required when this code is used.
PRIMARY_DIAG_IND DOUBLE Y Indicates whether the code is unacceptable for use as a Principal Diagnosis
RARE_DIAG_IND DOUBLE Y An edit flag to indicate whether the code pertains to a rare and / or notifiable disease. 0 = Not rare; 1 = Rare
SEX_FLAG DOUBLE Y An edit flag to indicate whether the code is valid for a particular sex.
SEX_TYPE_EDIT_FLAG DOUBLE Y All sex-flagged codes require a sex type edit.
SOURCE_IDENTIFIER VARCHAR(50) N Source identifier from the nomenclature table.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.


ICD9CM_EXTENSION



Column Section Top of Page


Table-level Detail

Description: ICD-9-CM Extension
Definition: Contains ICD-9-CM vocabulary specific data.
Table Type: REFERENCE





Column Detail - ICD9CM_EXTENSION


Column Name Type Null? Definition
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.
AGE_FLAG_DESC CHAR(1) Y Indicates Age specific edits for the code. A-adult (15 yo+) M-maternity (12-55 yo woman) P-pediatric (0-17 yo) N-newborn (0 yo)
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CONTRIBUTOR_SOURCE_CD DOUBLE N Contributor Source Code
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.
ICD9CM_EXTENSION_ID DOUBLE N Identifies the row as unique in the table.
SEX_FLAG_DESC CHAR(1) Y Indicates Sex edits for the code. M-male F-female
SOURCE_IDENTIFIER VARCHAR(50) N The ICD-9-CM 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.
VALID_FLAG_DESC CHAR(1) Y Indicates whether a code is billable. Y-billable N-not billable


KIA_EVENT_CODE_SNP



Column Section Relationship Section Top of Page


Table-level Detail

Description: KIA EVENT CODE SNP
Definition: Event Code snapshot
Table Type: ACTIVITY





Column Detail - KIA_EVENT_CODE_SNP


Column Name Type Null? Definition
CODE_STATUS_CD DOUBLE N describes the event code status.Column
COLLATING_SEQ DOUBLE N defines an ordering of sections within an mdoc..Column
DEF_DOCMNT_ATTRIBUTES VARCHAR(255) Y describes the attributes of the default document.Column
DEF_DOCMNT_FORMAT_CD DOUBLE N code for the default document format.Column
DEF_DOCMNT_STORAGE_CD DOUBLE N code for the default document storage.Column
DEF_EVENT_CLASS_CD DOUBLE N code for the default event class.Column
DEF_EVENT_CONFID_LEVEL_CD DOUBLE N code for the default event confidence level.Column
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.Column
EVENT_CD DOUBLE N it is the code that identifies the most basic unit of storage.Column
EVENT_CD_DEFINITION VARCHAR(100) Y definition of the event code.Column
EVENT_CD_DESCR VARCHAR(60) Y description of the event code.Column
EVENT_CD_DISP VARCHAR(40) Y event code display name key.Column
EVENT_CD_DISP_KEY VARCHAR(40) Y defines the key to the event code display name.Column
EVENT_CHG_ACCESS_IND DOUBLE Y flag to indicate events of this type can be changed by powerchart.Column
EVENT_CODE_STATUS_CD DOUBLE N code for the event code status.Column
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.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.



Relationship Detail - KIA_EVENT_CODE_SNP


Child Column in KIA_EVENT_CODE_SNP(FK) Parent Table Name Parent Column Name
Parents: EVENT_CD CODE_VALUE CODE_VALUE


KIA_EVENT_SET_CANON_SNP



Column Section Top of Page


Table-level Detail

Description: KIA EVENT SET CANON SNP
Definition: EVENT SET HIERARCHY SNAPSHOT
Table Type: ACTIVITY





Column Detail - KIA_EVENT_SET_CANON_SNP


Column Name Type Null? Definition
EVENT_SET_CD DOUBLE N Child event set codeColumn
EVENT_SET_COLLATING_SEQ DOUBLE Y The sequence number of the child event set within the parent event set.Column
EVENT_SET_EXPLODE_IND DOUBLE Y Defines the explode of the event set.Column
EVENT_SET_STATUS_CD DOUBLE N Code to describe the status of the event set.Column
PARENT_EVENT_SET_CD DOUBLE N Code to describe the parent 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.