Table Detail Report

INTERP_TASK_ASSAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interpretation Task Assay
Definition: The procedure defined as being an interpretation of the results entered for other procedures.
Table Type: REFERENCE





Column Detail - INTERP_TASK_ASSAY


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.
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 Y 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.
GENERATE_INTERP_FLAG DOUBLE Y Determines if interp is automatically entered (system generated) by the system or if the user is to fill out the interp value but the system validates the entered result.
INTERP_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of each row on this table.
INTERP_OPTION_CD DOUBLE N Determines if the result can be modified, read-only, or non-viewable.
INTERP_TYPE_CD DOUBLE N Determines the type of result. Possible choices can be alpha, textual, numerical, and codeset list.
ORDER_CAT_CD DOUBLE N Used to store the internal code for the order catalog item
PHASE_CD DOUBLE N Field no longer used
SERVICE_RESOURCE_CD DOUBLE N A unique internal identifier for this service resource
TASK_ASSAY_CD DOUBLE N The code value for the 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.



Relationship Detail - INTERP_TASK_ASSAY


Child Column in INTERP_TASK_ASSAY(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
ORDER_CAT_CD ORDER_CATALOG CATALOG_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in INTERP_TASK_ASSAY (PK) Child Table Name Child Column Name
Children: INTERP_ID INTERP_COMPONENT INTERP_ID
INTERP_RANGE INTERP_ID
INTERP_RESULT INTERP_ID
RESULT_HASH INTERP_ID


PHASE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Phase Group
Definition: A reference of the user-defined groups of test phases, to be used in the Result Entry application.
Table Type: REFERENCE





Column Detail - PHASE_GROUP


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.
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 Y 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.
PHASE_GROUP_CD DOUBLE N The code value that represents the group of phases to be accessed during the Result Entry application (ex. "Warm Phases").
PHASE_GROUP_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensures the uniqueness of each row.
REQUIRED_IND DOUBLE Y Indicates whether the system should require the user to result this phase.
SEQUENCE DOUBLE Y Defines the sequence in which each test phase should display within result entry.
TASK_ASSAY_CD DOUBLE N The discrete task assay (the phase itself) that was built within this group of phases to be chosen by the user in the Result Entry application.
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 - PHASE_GROUP


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


RESULT_HASH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Result Hash
Definition: A reference table of any results of components of interpretations, and their corresponding hash mark to be used in creating the interpretation pattern.
Table Type: REFERENCE





Column Detail - RESULT_HASH


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.
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 Y 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.
BIOHAZARD_IND DOUBLE N This column will indicate whether or not the interpretation hash will set a donor product to a biohazard.
DAYS_INELIGIBLE DOUBLE N This field will be used for donor interpretations only. It will be used to indicate on temporary deferrals how long the deferral period should be.
DONOR_ELIGIBILITY_CD DOUBLE N This field is used to identify the donor's eligibility based on interpretation of the hash results. It is only used for blood bank donor product interpretations.
DONOR_REASON_CD DOUBLE N This is the reason that will post to the donor's record for the specific result. It will be used to further explain the donor's eligibility status. This field is only utilized by blood bank donor product orders.
FROM_RESULT_RANGE DOUBLE Y The lowest number in the range of numeric results for which this hash mark applies. This column only applies to numeric results.
INCLUDED_ASSAY_CD DOUBLE N The discrete task assay for which this hash mark applies.
INTERP_DETAIL_ID DOUBLE N The primary key of the INTERP_DETAIL table. An internal system-assigned number. On this table, it provides a link from the interpretation detail procedure to the hash marks for the results.
INTERP_ID DOUBLE N The primary key to the interp_component table. An internal system-assigned number. On this table, it provides a link to the interp_component row for the result hash defined.
INTERP_RANGE_ID DOUBLE N The primary key of the interp_range table. An internal system-assigned number. On this table, it provides a link to the interp_range row.
NOMENCLATURE_ID DOUBLE N The primary key of the NOMENCLATURE table. An internal system-assigned number. On this table, it represents the medical nomenclature response for which the hash mark is defined.
RESULT_CD DOUBLE N Not currently used.
RESULT_HASH VARCHAR(25) Y The actual hash mark used to represent this result within the interpretation pattern (ex. "0", "1", "2", etc.)
RESULT_HASH_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensure the uniqueness of each row.
SEQUENCE DOUBLE Y The sequence in which this assay's hash mark should be placed, in order to make up the interpretation pattern.
TO_RESULT_RANGE DOUBLE Y The highest number in the range of numeric results for which this hash mark applies. This column only applies to numeric results.
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 - RESULT_HASH


Child Column in RESULT_HASH(FK) Parent Table Name Parent Column Name
Parents: INCLUDED_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
INTERP_DETAIL_ID INTERP_COMPONENT INTERP_DETAIL_ID
INTERP_RANGE_ID INTERP_RANGE INTERP_RANGE_ID
INTERP_ID INTERP_TASK_ASSAY INTERP_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID