Table Detail Report
CLINICAL_VALIDATION_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Clinical Validation Detail |
Definition: | This table stores the chronological ranges for which clinical data is valid for different age groups. |
Table Type: | REFERENCE |
Column Detail - CLINICAL_VALIDATION_DETAIL
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. |
AGE_MAX_UNIT_CD | DOUBLE | N | The unit of measure associated with the maximum age value. |
AGE_MAX_VALUE | DOUBLE | N | The maximum age contained within this range. |
AGE_MIN_UNIT_CD | DOUBLE | N | The unit of measure associated with the minimum age value. |
AGE_MIN_VALUE | DOUBLE | N | The minimum age contained within this range. |
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. |
CLINICAL_VALIDATION_DETAIL_ID | DOUBLE | N | Unique generated number that identifies a single row on the Validation_Detail table. |
CLINICAL_VALIDATION_ID | DOUBLE | N | The primary key on the Clinical_Validation table |
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. |
RANGE_UNIT_CD | DOUBLE | N | The duration code value associated with the range. |
RANGE_VALUE | DOUBLE | N | The amount of time to subtract from now to determine if a clinical event is valid. |
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 - CLINICAL_VALIDATION_DETAIL
Child Column in CLINICAL_VALIDATION_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLINICAL_VALIDATION_ID | CLINICAL_VALIDATION | CLINICAL_VALIDATION_ID |
CLINICAL_VALIDATION_FAC_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Clinical Validation Facility Relationship |
Definition: | This table stores the facility code relation between Clinical_Validation and Code_Value. |
Table Type: | REFERENCE |
Column Detail - CLINICAL_VALIDATION_FAC_R
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. |
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. |
CLINICAL_VALIDATION_FAC_R_ID | DOUBLE | N | Unique generated number that identifies a single row on the Clinical_Validation_Fac_R table. |
CLINICAL_VALIDATION_ID | DOUBLE | N | Foreign key from the Clinical_vallidation table. Relates a facility code to a clinical validation. |
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. |
FACILITY_CD | DOUBLE | N | The Facility associated with this row. A zero value indicates all facilities. |
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 - CLINICAL_VALIDATION_FAC_R
Child Column in CLINICAL_VALIDATION_FAC_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLINICAL_VALIDATION_ID | CLINICAL_VALIDATION | CLINICAL_VALIDATION_ID |
CS_COMPONENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores the components that make up a CareSet or CarePlan. |
Definition: | Stores information about every component of a CareSet or a CarePlan |
Table Type: | REFERENCE |
Column Detail - CS_COMPONENT
Column Name | Type | Null? | Definition |
---|---|---|---|
AV_OPTIONAL_INGREDIENT_IND | DOUBLE | Y | Indicates if an ingredient is optional for auto-verification consideration. 0 = Required, 1 = Optional |
CATALOG_CD | DOUBLE | N | This field contains the code from the Order Catalog table for which this entry is a component of. |
COMP_ID | DOUBLE | N | This field contains the id for external tables for which this component has data on. (i.e. Long Text ID, Synonym_ID) |
COMP_LABEL | VARCHAR(255) | Y | The display value for the component. |
COMP_MASK | DOUBLE | Y | component mask |
COMP_REFERENCE | VARCHAR(255) | Y | Text or link to text containing information about this component. |
COMP_SEQ | DOUBLE | N | The sequence of the components within this CarePlan or CareSet. |
COMP_TYPE_CD | DOUBLE | N | This field defines what type of component it is. |
COMP_TYPE_MEAN | VARCHAR(15) | Y | A textual string defining what type of component it is. |
CP_COL_CAT_CD | DOUBLE | N | This field defines where in the CarePlan grid this component resides in, specifically the column category. |
CP_ROW_CAT_CD | DOUBLE | N | This field defines where in the CarePlan grid the component resides in, specifically the row category. |
INCLUDE_EXCLUDE_IND | DOUBLE | Y | An indicator on whether this optional component should be defaulted as included or excluded. |
INDEX_TYPE_CD | DOUBLE | Y | Defines what type of index to use for lookup. |
LINKED_DATE_COMP_SEQ | DOUBLE | Y | This field contains the sequence of another component whose start date will control the start date of this field. |
LOCKDOWN_DETAILS_FLAG | DOUBLE | Y | Determines whether the IV Ingredient's details can be altered manually by the user (not locked down)or populated via an order sentence only (locked down). |
LONG_TEXT_ID | DOUBLE | N | This field contains the id from the Long Text table where components of type 'NOTE' information is stored. |
ORDER_SENTENCE_ID | DOUBLE | N | The id from the Order Sentence table that contains the default order parameters for this order. |
ORD_COM_TEMPLATE_LONG_TEXT_ID | DOUBLE | Y | Used to relate an order comment template to the component. |
OUTCOME_PAR_COMP_SEQ | DOUBLE | Y | This field contains the sequence number of the parent component which this outcome component is related to. |
PARENT_COMP_SEQ | DOUBLE | Y | The sequence of the parent component of this component. |
REQUIRED_IND | DOUBLE | Y | An indicator on whether or not this orderable component is required for this CareSet/CarePlan |
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. |
VARIANCE_FORMAT_ID | DOUBLE | N | The format id for variances to a component. |
Relationship Detail - CS_COMPONENT
Child Column in CS_COMPONENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
ORD_COM_TEMPLATE_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
COMP_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID | |
ORDER_SENTENCE_ID | ORDER_SENTENCE | ORDER_SENTENCE_ID |
DCP_ENTITY_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DCP ENTITY RELATIONSHIP |
Definition: | Table is used to store the relationship between any two _id or _cd entities in the system. |
Table Type: | REFERENCE |
Column Detail - DCP_ENTITY_RELTN
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. |
BEGIN_EFFECTIVE_DT_TM | DATETIME | Y | The beginning effective date of this relationship. |
DCP_ENTITY_RELTN_ID | DOUBLE | N | The id of this relationship. |
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. |
ENTITY1_DISPLAY | VARCHAR(100) | Y | The display value for entity 1 of the relationship. |
ENTITY1_ID | DOUBLE | N | The id of entity 1 of the relationship. |
ENTITY1_NAME | CHAR(32) | Y | First entity name |
ENTITY2_DISPLAY | VARCHAR(100) | Y | The display value of entity2 of the relationship. |
ENTITY2_ID | DOUBLE | N | The id of the second entity in the relationship. |
ENTITY2_NAME | CHAR(32) | Y | Second entity name |
ENTITY3_DISPLAY | VARCHAR(100) | Y | The display value of entity3 of the relationship. |
ENTITY3_ID | DOUBLE | Y | The id of entity 3 of the relationship. |
ENTITY3_NAME | VARCHAR(32) | Y | Third entity name. |
ENTITY_RELTN_MEAN | VARCHAR(12) | Y | The meaning of the relationship that is used to identify the source of entity1 and entity2. |
RANK_SEQUENCE | DOUBLE | Y | A sequence number to place the relationships in a hierarchy. |
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 - DCP_ENTITY_RELTN
Parent Column in DCP_ENTITY_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DCP_ENTITY_RELTN_ID | ALERT_AUDIT_ALLERGY | DCP_ENTITY_RELTN_ID |
ALERT_AUDIT_DRUG | DCP_ENTITY_RELTN_ID | ||
ALERT_AUDIT_DUP | DCP_ENTITY_RELTN_ID | ||
ALERT_AUDIT_FOOD | DCP_ENTITY_RELTN_ID | ||
DRUG_CLASS_INT_CSTM_ENTITY_R | DCP_ENTITY_RELTN_ID |
DCP_FLEX_PRINTER
Column Section | Top of Page |
Table-level Detail
Description: | DCP FLEX PRINTER |
Definition: | Defines printer flexing |
Table Type: | REFERENCE |
Column Detail - DCP_FLEX_PRINTER
Column Name | Type | Null? | Definition |
---|---|---|---|
DCP_FLEX_DEST_ID | DOUBLE | N | Destination of req |
DCP_FLEX_PRINTER_ID | DOUBLE | N | Printer flexing |
DCP_FLEX_RTG_ID | DOUBLE | N | Flex of routing |
DCP_OUTPUT_ROUTE_ID | DOUBLE | N | Output route |
PRINTER_CD | DOUBLE | N | Printer code |
PRINTER_NAME | VARCHAR(50) | Y | Printer name |
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. |