DCP_INTERP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Base table to drive interpretation of a result based on the value of other resul
Definition: Base table to drive interpretation of a result based on the value of other results.
Table Type: REFERENCE





Column Detail - DCP_INTERP


Column Name Type Null? Definition
AGE_FROM_MINUTES DOUBLE N beginning age for reference range.
AGE_TO_MINUTES DOUBLE N Ending age for reference range.
DCP_INTERP_ID DOUBLE N Unique identifier for interp table.
SERVICE_RESOURCE_CD DOUBLE N Service Resource Cd for reference range.
SEX_CD DOUBLE N Sex Cd for reference range.
TASK_ASSAY_CD DOUBLE N Task Assay Cd for which interpretation is defined.
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_INTERP




Parent Column in DCP_INTERP (PK) Child Table Name Child Column Name
Children: DCP_INTERP_ID DCP_INTERP_COMPONENT DCP_INTERP_ID
DCP_INTERP_STATE DCP_INTERP_ID


DCP_INTERP_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP INTERP COMPONENT
Definition: Stores components used to interpret a result.
Table Type: REFERENCE





Column Detail - DCP_INTERP_COMPONENT


Column Name Type Null? Definition
COMPONENT_ASSAY_CD DOUBLE N Task Assay Cd of the component. The component helps determine the value for the interp.
COMPONENT_SEQUENCE DOUBLE N Sequence number of the component.
DCP_INTERP_COMPONENT_ID DOUBLE N Unique Identifier
DCP_INTERP_ID DOUBLE N Id of interp that this component is for.
DESCRIPTION VARCHAR(200) Y Description of component.
FLAGS DOUBLE Y Flags which identify properties of the component 1 - Numeric Component
LOOK_AHEAD_MINUTES DOUBLE Y The amount of time in minutes to look ahead from the documentation time of an interpretation for using a result as a contributor.
LOOK_BACK_MINUTES DOUBLE Y The amount of time in minutes to look back from the documentation time of an interpretation for using a result as a contributor.
LOOK_TIME_DIRECTION_FLAG DOUBLE Y Identifies to use look_back_minutes and look_ahead_minutes in an order. 0: Look back first and then look ahead; 1: Look ahead first and then look back.
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_INTERP_COMPONENT


Child Column in DCP_INTERP_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: DCP_INTERP_ID DCP_INTERP DCP_INTERP_ID


DCP_INTERP_STATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP INTERP STATE
Definition: Transition States for interpretations.
Table Type: REFERENCE





Column Detail - DCP_INTERP_STATE


Column Name Type Null? Definition
DCP_INTERP_ID DOUBLE N Id of interpretation
DCP_INTERP_STATE_ID DOUBLE N unique identifier
FLAGS DOUBLE N flags 1 - Numeric Component
INPUT_ASSAY_CD DOUBLE N Task Assay Code of input.
NOMENCLATURE_ID DOUBLE N nomenclature id of input corresponding to transition_assay_cd
NUMERIC_HIGH DOUBLE Y numeric high value
NUMERIC_LOW DOUBLE Y numeric low value
RESULTING_STATE DOUBLE N Next state as a result of current input
RESULT_NOMENCLATURE_ID DOUBLE N Nomenclature Id that should be returned as result.
RESULT_VALUE DOUBLE Y Numeric Value that should be returned as a result.
STATE DOUBLE N identifier of the state
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_INTERP_STATE


Child Column in DCP_INTERP_STATE(FK) Parent Table Name Parent Column Name
Parents: DCP_INTERP_ID DCP_INTERP DCP_INTERP_ID


DTA_OFFSET_MIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discrete Task Assay Offset Minute
Definition: Stores the types of offset minutes and the number of minutes that need to be considered for a DTA.
Table Type: REFERENCE





Column Detail - DTA_OFFSET_MIN


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.
DTA_OFFSET_MIN_ID DOUBLE N Unique, generated number that identifies a row on the DTA_OFFSET_MIN 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.
OFFSET_MIN_NBR DOUBLE N Look Back/Forward minutes based on the type to tell how far back/forward to look
OFFSET_MIN_TYPE_CD DOUBLE N The type of minutes that need to be looked at.
TASK_ASSAY_CD DOUBLE N The task assay that these minutes pertain to.
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 - DTA_OFFSET_MIN


Child Column in DTA_OFFSET_MIN(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD


DTA_VERSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: DTA Version
Definition: DTA Version
Table Type: REFERENCE





Column Detail - DTA_VERSION


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.
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_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
DTA_VERSION_ID DOUBLE N DTA Version identifier
LONG_BLOB_ID DOUBLE N Foreign key to the Long_Blob table
TASK_ASSAY_CD DOUBLE N Foreign key to discrete_task_assay
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_FROM_DT_TM DATETIME N The date and time that this row became valid.
VALID_UNTIL_DT_TM DATETIME N Date row is valid until
VERSION_IN_USE DOUBLE N version in use
VERSION_NUMBER DOUBLE N version number



Relationship Detail - DTA_VERSION


Child Column in DTA_VERSION(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID