Table Detail Report

LAB_EXT_IDENTIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lab External Identifier
Definition: Table to store external identifiers used within interoperability.
Table Type: ACTIVITY





Column Detail - LAB_EXT_IDENTIFIER


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.
AP_EXT_DATA_ID DOUBLE Y Unique identifier from the ap external data table to which this identifier is associated.
ENCNTR_ID DOUBLE N Encounter associated to the parent of this identifier. Included to facilitate crawling needs.
EVENT_ID DOUBLE N The identiifer for the clinical event to which this identifier is associated
GEN_LAB_EXT_DATA_ID DOUBLE N Unique identifier from the general lab external data table to which this identifier is associated.
LAB_EXT_IDENTIFIER_ID DOUBLE N Unique generated number that identifies a single row on the LAB_EXT_IDENTIFIER table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MICRO_SEQ_NBR DOUBLE Y Specifc for Microbiology, Used for uniqueness in cases where there are multiple micro records
MIC_EXT_DATA_ID DOUBLE Y Uniquely identifies the related row on the MIC_EXT_DATA table.
PERSON_ID DOUBLE N Person associated to the parent of this identifier. Included to facilitate crawling needs.
SYSTEM_URI VARCHAR(80) N The URI of the system that assigned the value. If value is not null then the combo of system and value is unique.
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.
VALUE_TXT VARCHAR(200) Y The value of the identifier. May be null if Rendered Value is not null. If valued, is unique when combined with system.



Relationship Detail - LAB_EXT_IDENTIFIER


Child Column in LAB_EXT_IDENTIFIER(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
GEN_LAB_EXT_DATA_ID GEN_LAB_EXT_DATA GEN_LAB_EXT_DATA_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
MIC_EXT_DATA_ID MIC_EXT_DATA MIC_EXT_DATA_ID
PERSON_ID PERSON PERSON_ID


PERSON_ABORH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Aborh
Definition: Defines the current historical ABO/Rh of a person. Used by transfusion applications to validate the product's ABO/Rh against the patient's ABO/Rh.
Table Type: ACTIVITY





Column Detail - PERSON_ABORH


Column Name Type Null? Definition
ABO_CD DOUBLE N The historical ABO group of the person.
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.
BEGIN_EFFECTIVE_DT_TM DATETIME Y The date and time when this row became effective.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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.
LAST_VERIFIED_DT_TM DATETIME Y Indicates the date and time that a patient's ABO/Rh was last resulted from a 'HISTRY & UPD' patient ABO/Rh order with the same result as represented by the current row, i.e., patient's ABO/Rh was re-resulted and not changed.
PERSON_ABORH_ID DOUBLE N The primary key of this table. An internal system-assigned number that makes each row unique.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RH_CD DOUBLE N The historical Rh type of the person (ex. "Pos", "Neg").
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 - PERSON_ABORH


Child Column in PERSON_ABORH(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID




Parent Column in PERSON_ABORH (PK) Child Table Name Child Column Name
Children: PERSON_ABORH_ID BB_UPLOAD_PERSON_ABORH_R PERSON_ABORH_ID
BB_UPLOAD_REVIEW DEMOG_PERSON_ABORH_ID
BB_UPLOAD_REVIEW UPLOAD_PERSON_ABORH_ID
PERSON_ABORH_RESULT PERSON_ABORH_ID


PERSON_ABORH_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Aborh Result
Definition: The result of every ABO/Rh procedure performed and verified on a person, with an association to thehistorical ABO/Rh active on the person at the time of the result.
Table Type: ACTIVITY





Column Detail - PERSON_ABORH_RESULT


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.
CONTAINER_ID DOUBLE N Indicates the container for the specimen. Unique identifier from the Container table
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DONOR_ABORH_ID DOUBLE N Created from same result as PERSON_ABORH_RESULT identifying record from the DONOR_ABORH which defines the current historical ABO/Rh of a donor. Used by donor applications to validate the product's ABO/Rh against the donor's ABO/Rh.
DRAWN_DT_TM DATETIME Y Indicates the date and time that the specimen was drawn/collected, populated from the COLLECTION table.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
PERSON_ABORH_ID DOUBLE N Link to PERSON_ABORH row created from same result as PERSON_ABORH_RESULT row. Unique identifier from the PERSON_ABORH table.
PERSON_ABORH_RS_ID DOUBLE N The primary key of this table. An internal system-assigned number that makes each row unique.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RESULT_CD DOUBLE N The ABORh result verified for the person (ex. "O Pos", "A Neg", etc.).
RESULT_ID DOUBLE N This is the value of the unique primary identifier of the RESULT table. It is an internal system-assigned number. On this table, it identifies the ABORh result verified for the person.
SPECIMEN_ID DOUBLE N Uniquely identifies the specimen. Unique identifier from V500_SPECIMEN table
STANDARD_ABORH_CD DOUBLE N Stores the standard ABO/RH associated with the ABO/RH result verified for the person.
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 - PERSON_ABORH_RESULT


Child Column in PERSON_ABORH_RESULT(FK) Parent Table Name Parent Column Name
Parents: CONTAINER_ID CONTAINER CONTAINER_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PERSON_ABORH_ID PERSON_ABORH PERSON_ABORH_ID
RESULT_ID RESULT RESULT_ID
SPECIMEN_ID V500_SPECIMEN SPECIMEN_ID


PERSON_ANTIBODY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Antibody
Definition: Contains a record of every time an antibody procedure done on a patient resulted in an antibody being identified.
Table Type: ACTIVITY





Column Detail - PERSON_ANTIBODY


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.
ANTIBODY_CD DOUBLE N The antibody identified in this person's blood, confirmed through testing (ex. "Fya", "K", etc.)
BB_RESULT_ID DOUBLE N An internal system-assigned number (but not a primary key to any table). Since multiple instances of a procedure can be resulted on the same patient, same accession, and same control cell, antibody, or antigen, the BB_RESULT_ID is used to make these instances unique.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
PERSON_ANTIBODY_ID DOUBLE N The primary key to this table. An internal system-assigned number that ensure the uniqueness of each row.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REMOVAL_NOTES VARCHAR(255) Y This column will hold the comments provided by the user while deactivating the antibody.
REMOVAL_REASON_CD DOUBLE N This column will indicate the reason for deactivating the antibody.
REMOVED_DT_TM DATETIME Y Indicates the date and time that an antibody is removed for the specified person.
REMOVED_PRSNL_ID DOUBLE N Uniquely identifies the personnel who removed the Antibody for the specified person.
RESULT_ID DOUBLE N The primary key to the RESULT table. An internal system-assigned number. On this table, it links the record of a historical antibody for a certain person to the actual result that was verified with this antibody.
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 - PERSON_ANTIBODY


Child Column in PERSON_ANTIBODY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
REMOVED_PRSNL_ID PRSNL PERSON_ID
RESULT_ID RESULT RESULT_ID


PERSON_ANTIGEN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Antigen
Definition: Contains a record of every antigen result performed and verified on a person.
Table Type: ACTIVITY





Column Detail - PERSON_ANTIGEN


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.
ANTIGEN_CD DOUBLE N The antigen identified in a person's blood, confirmed through testing (ex. "Fya negative", "Kell negative", etc.)
BB_RESULT_ID DOUBLE N An internal system-assigned number (but not a primary key to any table). Since multiple instances of a procedure can be resulted on the same patient, same accession, and same control cell, antibody, or antigen, the BB_RESULT_ID is used to make these instances unique.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
PERSON_ANTIGEN_ID DOUBLE N The primary key of this table. An internal system-assigned number that makes each row unique.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_RH_PHENOTYPE_ID DOUBLE N A link to the Rh phenotype from which this antigen originated. Links this row to a row on the person_rh_phenotype table.
REMOVAL_NOTES VARCHAR(255) Y This column will hold the comments provided by the user while deactivating the antibody.
REMOVAL_REASON_CD DOUBLE N This column will indicate the reason for deactivating the antibody.
REMOVED_DT_TM DATETIME Y Indicates the date and time that an antigen is removed for the specified person.
REMOVED_PRSNL_ID DOUBLE N Uniquely identifies the personnel who removed the Antigen for the specified person.
RESULT_ID DOUBLE N This is the value of the unique primary identifier of the RESULT table. It is an internal system-assigned number. On this table, it links this row to the actual result that was verified for this person having this antigen.
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 - PERSON_ANTIGEN


Child Column in PERSON_ANTIGEN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PERSON_RH_PHENOTYPE_ID PERSON_RH_PHENOTYPE PERSON_RH_PHENOTYPE_ID
REMOVED_PRSNL_ID PRSNL PERSON_ID
RESULT_ID RESULT RESULT_ID