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.