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