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 |