Table Detail Report
RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Result |
Definition: | Stores the current result status for a discrete task assay that is associated with a given patient's order. |
Table Type: | ACTIVITY |
Column Detail - RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
BB_CONTROL_CELL_CD | DOUBLE | N | A unique code value that identifies a specific control cell or the ID of the product of the antibody or antigen test. Blood bank-specific attribute. |
BB_GROUP_ID | DOUBLE | N | This field stores the unique identifier of the Blood Bank group (rack) used for testing. |
BB_RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that is used to group the results for a product or a control cell. Blood bank-specific attribute. |
BIOLOGICAL_CATEGORY_CD | DOUBLE | N | Denotes the origin of the sequence of the part of the DNA or RNA being tested and the species of the organism being tested (animal, bacteria, or virus). |
CALL_BACK_IND | DOUBLE | Y | Indicates whether a result needs to be called back to the area requesting the procedure to be performed. (Currently not implemented) |
CATALOG_CD | DOUBLE | N | A unique code value that identifies a specific order catalog procedure associated with a result. |
CHARTABLE_FLAG | DOUBLE | Y | Defines if the result should be used for charting/posting to Clinical Events. (Currently not implemented) |
COMMENT_IND | DOUBLE | Y | Indicates whether a result comment is associated with the result. A value of 0 means there is not a chartable comment attached to the result. A value of 1 means there is a chartable comment attached to the result. (Currently not implemented) |
CONCEPT_CKI | VARCHAR(255) | N | Concept CKI is the functional Concept Identifier; it is the codified means within Millennium to identify key medical concepts to support information processing, clinical decision support, executable knowledge and knowledge presentation. Composed of a source and an identifier. For example, if the concept source is "SNOMED" and the concept identifier is "123", then the CKI is "SNOMED!123". |
DISPLAY_SEQUENCE_NBR | DOUBLE | N | Defines the sequence in which the result will be displayed in result entry applications. This attribute is originally derived from the profile_task_r table when the result row is inserted. |
EVENT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific event ID that relates the result to the clinical event tables. (Currently not implemented) |
LOT_INFORMATION_ID | DOUBLE | N | This field stores the unique identifier of the reagent lot used for testing. |
NC_COMMENT_IND | DOUBLE | Y | Indicates whether a result footnote is associated with the result. A value of 0 indicates there are no non-chartable footnotes for the result. A value of 1 indicates there are non-chartable footnotes for the result. (Currently not implemented) |
ORDER_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific order. Creates a relationship to the orders table. |
PENDING_IND | DOUBLE | N | Indicates whether this result must be performed before the order it is associated with should be considered complete. This attribute is originally derived from the profile_task_r table when the result row is written. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PRIMARY_IND | DOUBLE | N | The result chosen as most accurate among all results for a given assay concept. Determines what displays in the person level viewer for inherited results. |
REPEAT_NUMBER | DOUBLE | Y | Defines the number of times the procedure has been repeated to produce a result. (Currently not implemented) |
RESTRICT_DISPLAY_IND | DOUBLE | N | Restricts the display of the result in result entry to only those that have results associated with them. This attribute is originally derived from the profile_task_r table when the result row is written. |
RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific result. |
RESULT_PROCESSING_CD | DOUBLE | N | A unique code value used to determine result processing. For Helix result entry applications, this field determines the column in which the result appears. |
RESULT_STATUS_CD | DOUBLE | N | A unique code value that identifies the current status of the result, such as performed, verified, corrected, and so on. |
SECURITY_LEVEL_CD | DOUBLE | N | A unique code value that identifies a specific security level for the result. (Currently not implemented) |
TASK_ASSAY_CD | DOUBLE | N | A unique code value that identifies a specific discrete task assay associated with the result. |
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
Child Column in RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BB_GROUP_ID | BB_QC_GROUP | GROUP_ID |
ORDER_ID | ORDERS | ORDER_ID | |
LOT_INFORMATION_ID | PCS_LOT_INFORMATION | LOT_INFORMATION_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in RESULT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RESULT_ID | ABO_TESTING | RESULT_ID |
BB_EXCEPTION | RESULT_ID | ||
INSTRUMENT_IMAGE | RESULT_ID | ||
PERFORM_RESULT | RESULT_ID | ||
PERSON_ABORH_RESULT | RESULT_ID | ||
PERSON_ANTIBODY | RESULT_ID | ||
PERSON_ANTIGEN | RESULT_ID | ||
PERSON_RH_PHENOTYPE | RESULT_ID | ||
PERSON_RH_PHENO_RESULT | RESULT_ID | ||
RESULT_COMMENT | RESULT_ID | ||
SPECIAL_TESTING_RESULT | RESULT_ID | ||
UCM_REPORT_FIELD | RESULT_ID |
RESULT_COMMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Result Comment |
Definition: | Table defines the relationship for chartable and non-chartable text for a result. |
Table Type: | ACTIVITY |
Column Detail - RESULT_COMMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_SEQUENCE | DOUBLE | N | Starts at one and is incremented for each version of a comment that is stored in the table. Used for tracking the different versions of comments entered into the system. |
COMMENT_DT_TM | DATETIME | Y | Defines the date and time the comment was entered in the system. |
COMMENT_PRSNL_ID | DOUBLE | N | A unique internal system assigned number that identifies a specific person/user who entered the comment information. Creates a relationship to the personnel (prsnl) table. |
COMMENT_TYPE_CD | DOUBLE | N | A unique code value that identifies a specific type of comment as either chartable or non-chartable. |
COMMENT_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
LONG_TEXT_ID | DOUBLE | N | A unique internal system assigned number that identifies a specific comment text. Creates a relationship to the long text table. |
RESULT_ID | DOUBLE | N | A unique internal system assigned number that identifies a specific result that the comment applies to. Creates a relationship to the result table. |
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_COMMENT
Child Column in RESULT_COMMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | COMMENT_PRSNL_ID | PRSNL | PERSON_ID |
RESULT_ID | RESULT | RESULT_ID |
RESULT_EVENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Result Event |
Definition: | Defines what result events have taken place for a given discrete task assay. |
Table Type: | ACTIVITY |
Column Detail - RESULT_EVENT
Column Name | Type | Null? | Definition |
---|---|---|---|
CALLED_BACK_IND | DOUBLE | Y | Indicates whether the result was called back for this event. (Currently not implemented) |
EVENT_DT_TM | DATETIME | Y | Defines the date and time the event took place. |
EVENT_PERSONNEL_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific person who performed the event on a result. Creates a relationship to the person table. |
EVENT_REASON | VARCHAR(100) | Y | Defines the purpose for the event being created. |
EVENT_SEQUENCE | DOUBLE | N | Starts at one and is incremented by one when multiple result events are completed at the same time. For example, when the user enters and verifies a result, the actions cause the system to execute perform and verify events at the same time. |
EVENT_TYPE_CD | DOUBLE | N | A unique code value that identifies the specific action of the event that took place on the result. |
PERFORM_RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific result has been performed. Creates a relationship to the perform result table. |
RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific result. Creates a relationship to the result table. |
SIGNATURE_LINE_IND | DOUBLE | Y | Indicates whether a signature line should be added to the result. |
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_EVENT
Child Column in RESULT_EVENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EVENT_PERSONNEL_ID | PRSNL | PERSON_ID |
ROUND_ROBIN_COMMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Round Robin Comment |
Definition: | Comments for a Round Robin template, accession, service resource. |
Table Type: | ACTIVITY |
Column Detail - ROUND_ROBIN_COMMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific accession number associated with a round robin comment. |
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. |
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. |
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. |
LONG_TEXT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific storage location for the text of the comment. Creates a relationship to the long text table. |
ROUND_ROBIN_REF_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific round robin template associated with the comment. Creates a relationship to the round robin reference table. |
SEQUENCE | DOUBLE | N | Defines the sequence of changes made to a given round robin comment. When a comment is updated, the previous sequence is inactivated and a new row is added with the next sequence number. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies the specific service resource (i.e. instrument, bench, etc.) associated with the round robin comment. |
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 - ROUND_ROBIN_COMMENT
Child Column in ROUND_ROBIN_COMMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
ACCESSION_ID | RR_ACCESSION_R | ACCESSION_ID | |
ROUND_ROBIN_REF_ID | RR_ACCESSION_R | ROUND_ROBIN_REF_ID |
ROUND_ROBIN_REF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Round Robin Reference |
Definition: | Stores round robin template(s) information |
Table Type: | REFERENCE |
Column Detail - ROUND_ROBIN_REF
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. |
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. |
DISPLAY | VARCHAR(40) | Y | Defines the display value for the name of the round robin template. |
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. |
ROUND_ROBIN_REF_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific round robin template. This number is new each time a template is updated. |
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 - ROUND_ROBIN_REF
Parent Column in ROUND_ROBIN_REF (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ROUND_ROBIN_REF_ID | RR_ACCESSION_R | ROUND_ROBIN_REF_ID |
RR_ASSAY_R | ROUND_ROBIN_REF_ID |