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 |