Table Detail Report

DCP_UNIT_MEASURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP UNIT MEASURE
Definition: This table contains the unit of measures for each component in an equation
Table Type: REFERENCE





Column Detail - DCP_UNIT_MEASURE


Column Name Type Null? Definition
DCP_COMPONENT_ID DOUBLE N The unique identifier for a single component in an equation.Column
DCP_EQUATION_ID DOUBLE N This is the unique identifier for the parent equationColumn
DEFAULT_IND DOUBLE Y This indicator is used to determine whether a not this unit of measure is the defaulted unit of measure
EQUATION_DEPENDENT_UNIT_IND DOUBLE Y This indicator is used to determine which unit of measure the equation depends on for this component
UNIT_MEASURE_CD DOUBLE N This is the unique identifier for the unit of measureColumn
UNIT_MEASURE_MEANING VARCHAR(12) Y This contains the cdf meaning of the chosen unit of measure
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 - DCP_UNIT_MEASURE


Child Column in DCP_UNIT_MEASURE(FK) Parent Table Name Parent Column Name
Parents: DCP_COMPONENT_ID DCP_EQUA_COMPONENT DCP_COMPONENT_ID
DCP_EQUATION_ID DCP_EQUA_COMPONENT DCP_EQUATION_ID


DCP_VIRTUAL_PRIVACY



Column Section Top of Page


Table-level Detail

Description: Patient Privacy for INet Virtual Call
Definition: Specifies the patient's privacy for an INet Virtual Call
Table Type: ACTIVITY





Column Detail - DCP_VIRTUAL_PRIVACY


Column Name Type Null? Definition
AUDIO_OVERRIDE_IND DOUBLE Y Specifies whether the privacy is eligible for audio override
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.
DCP_VIRTUAL_PRIVACY_ID DOUBLE N Primary KeyColumn
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.
FREETEXT_COMMENT VARCHAR(255) Y Specifies the Free Text Comment
PERSON_ID DOUBLE N Specifies the Person the privacy is set for
PRIVACY_CD DOUBLE N Specifies the type of privacy set
PRIVACY_COMMENT_CD DOUBLE N Specifies the comment type
TEMPORARY_IND DOUBLE Y Specifies whether the privacy is permanent (no expiration) or temporary. 0 = Permanent, 1 = Temporary
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.
VIDEO_OVERRIDE_IND DOUBLE Y Specifies whether the privacy is eligible for video override


DOSING_WEIGHT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dosing Weight
Definition: This table will maintain the dosing weights per person per documentation time that are used during IV drip titration calculations.
Table Type: ACTIVITY





Column Detail - DOSING_WEIGHT


Column Name Type Null? Definition
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.
DOSING_WEIGHT_ID DOUBLE N Primary Key from Sequence CARENET_SEQ
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.
EVENT_ID DOUBLE N Event_id of the weight used for the person_id at the documentation time (begin_effective_dt_tm)
PERSON_ID DOUBLE N The person that the weight (event_id) was used for
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 - DOSING_WEIGHT


Child Column in DOSING_WEIGHT(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


EVENTSET_TASK_RLTN



Column Section Top of Page


Table-level Detail

Description: EVENTSET TASK RLTN
Definition: Table to map event sets to tasks
Table Type: REFERENCE





Column Detail - EVENTSET_TASK_RLTN


Column Name Type Null? Definition
EVENTSET_TASK_RLTN_ID DOUBLE N unique sequence numberColumn
GROUP_EVENT_SET_CD DOUBLE N Event set code of the groupColumn
POSITION_CD DOUBLE N Position codeColumn
REFERENCE_TASK_ID DOUBLE N Task type from the order_task tableColumn
REQUIRED_IND DOUBLE N Indicates whether task_assay_cd is requiredColumn
SPECIALTY_EVENT_SET_CD DOUBLE N Event set code of the specialty flowsheetColumn
TASK_ASSAY_CD DOUBLE N The code value for the discrete task assayColumn
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.


IO_TOTAL_START_TIME



Column Section Relationship Section Top of Page


Table-level Detail

Description: IO_Total_Start_Time
Definition: Clinical
Table Type: ACTIVITY





Column Detail - IO_TOTAL_START_TIME


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.
ENCNTR_ID DOUBLE N Encounter ID
EVENT_CD DOUBLE N Event cd of IO total
IO_TOTAL_START_TIME_ID DOUBLE N Primary Key
PERSON_ID DOUBLE N person identifier
TOTAL_START_DT_TM DATETIME N Currently selected start time for the IO total.
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 - IO_TOTAL_START_TIME


Child Column in IO_TOTAL_START_TIME(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID