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