Table Detail Report
PERSON_RH_PHENOTYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Rh Phenotype |
Definition: | Defines the Rh Phenotype (ex. 'CDE/CDE') identified for a person through serological testing performed on a specimen of blood from the person. |
Table Type: | ACTIVITY |
Column Detail - PERSON_RH_PHENOTYPE
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 | N | 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. |
NOMENCLATURE_ID | DOUBLE | N | Represents the nomenclature of the result entered for this Rh Phenotype (ex. "CDE/CDE"). |
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 | An internal system-assigned number that ensures the uniqueness of each row on this table. |
RESULT_ID | DOUBLE | N | Defines the result entered for this Rh Phenotype (ex. "CDE/CDE"). Links this row to the row on the result table for result correction purposes. |
RH_PHENOTYPE_ID | DOUBLE | N | Links this row to the bb_rh_phenotype table where the Rh Phenotype is defined, and where its translation into specific antigens is defined. |
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_RH_PHENOTYPE
Child Column in PERSON_RH_PHENOTYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RH_PHENOTYPE_ID | BB_RH_PHENOTYPE | RH_PHENOTYPE_ID |
PERSON_ID | PERSON | PERSON_ID | |
RESULT_ID | RESULT | RESULT_ID |
Parent Column in PERSON_RH_PHENOTYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PERSON_RH_PHENOTYPE_ID | PERSON_ANTIGEN | PERSON_RH_PHENOTYPE_ID |
PERSON_RH_PHENO_RESULT | PERSON_RH_PHENOTYPE_ID |
PERSON_RH_PHENO_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Rh Phenotype Result table |
Definition: | Stores the results of a person's Rh phenotypings, all of them ever done. Related to the person_rh_phenotype table. |
Table Type: | ACTIVITY |
Column Detail - PERSON_RH_PHENO_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 | N | 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. |
DONOR_RH_PHENOTYPE_ID | DOUBLE | N | Links to a row on the Donor_Rh_Phenotype table which defines the Rh Phenotype (ex. 'CDE/CDE') identified for a donor through serological testing performed on a specimen of blood from the donor. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
NOMENCLATURE_ID | DOUBLE | N | Identifies the nomenclature (the alpha response) used to generate this Rh phenotype, ex. "CDE/CDE". |
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 | Links this row to a row on the Person_Rh_Phenotype table. |
PERSON_RH_PHENO_RS_ID | DOUBLE | N | The primary key to this table. An internal system-assigned number that ensures the uniqueness of each row. |
RESULT_ID | DOUBLE | N | Links this row to a row on the result table, for which it is the primary key. |
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_RH_PHENO_RESULT
Child Column in PERSON_RH_PHENO_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PERSON_RH_PHENOTYPE_ID | PERSON_RH_PHENOTYPE | PERSON_RH_PHENOTYPE_ID | |
RESULT_ID | RESULT | RESULT_ID |
PERSON_TRANS_REQ
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Transfusion Requirements |
Definition: | Contains the transfusion requirements for a person, as entered by the blood bank, e.g., irradiated blood needed, CMV negative blood needed, etc. |
Table Type: | ACTIVITY |
Column Detail - PERSON_TRANS_REQ
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. |
ADDED_DT_TM | DATETIME | Y | Indicates the date and time that a transfusion requireent is added for the specified person. |
ADDED_PRSNL_ID | DOUBLE | N | Uniquely identifies the personnel who added the transfusion requirement for the specidied person. |
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_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PERSON_TRANS_REQ_ID | DOUBLE | N | This is the primary key of this table. It is an internal system-assigned number that makes each row unique. |
REMOVED_DT_TM | DATETIME | Y | Indicates the date and time that a transfusion requirement is removed for the specified person. |
REMOVED_PRSNL_ID | DOUBLE | N | Uniquely identifies the personnel who removed the transfusion for the specified person. |
REQUIREMENT_CD | DOUBLE | N | Defines a requirement or restriction of transfusing this person with blood products. Something other than normal protocol that is required when dispensing any blood products to this patient, in order to keep from adversely affecting their health. Examples are: irradiation (all blood must be irradiated before being infused), CMV Negative (alll blood must be tested for being CMV negative before being infused), etc. |
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_TRANS_REQ
Child Column in PERSON_TRANS_REQ(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PERSON_ID | PERSON | PERSON_ID | |
ADDED_PRSNL_ID | PRSNL | PERSON_ID | |
REMOVED_PRSNL_ID | PRSNL | PERSON_ID |