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 |