Table Detail Report
PERSON_HLA_XM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person HLA Crossmatch. |
Definition: | Defines a person's permanent HLA crossmatch history over time. |
Table Type: | ACTIVITY |
Column Detail - PERSON_HLA_XM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION | CHAR(20) | Y | An accession number identifies an order or a group of orders. Relates the Crossmatch History to the order from which it was derived. Not populated when history is manually entered. |
B_CELL_RESULT_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the B-Cell Result used in the Crossmatch. Either derived from Crossmatch results or entered manually into history. |
CHARTED_IND | DOUBLE | Y | Indicates whether or not a manually entered HLA crossmatch results have been sent to the OCF Clinical Event tables for charting. |
COMMENT_LONG_TEXT_ID | DOUBLE | N | Relates this record to a specific long_text record where Crossmatch history comments are stored. It is a foreign key reference to the primary key of the long_text table. Either derived from Crossmatch order comments or entered manually. |
COMPLETE_DT_TM | DATETIME | Y | Date and time that the HLA crossmatch results were completed. |
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_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. This is the person crossmatched against this records person_id. |
HLA_XM_ID | DOUBLE | N | A sequentially assigned number which uniquely identifies an HLA Crossmatch history record. |
HLA_XM_RES_TRAY_ID | DOUBLE | N | Relates the Crossmatch History to the crossmatch result tray from which it was derived. Not populated when history is manually entered. It is a foreign key reference to the primary key of the hla_xm_res_tray table. |
INTERPRETATION_LONG_TEXT_ID | DOUBLE | N | Relates this record to a specific long_text record where Interpretation comments are stored. It is a foreign key reference to the primary key of the long_text table. Either derived from Crossmatch orders or entered manually. |
MONO_CELL_RESULT_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the Monocyte Cell Result used in the Crossmatch. Either derived from Crossmatch results or entered manually into history. |
ORDER_ID | DOUBLE | N | Relates the Crossmatch History to the order from which it was derived. Not populated when history is manually entered. It is a foreign key reference to the primary key of the orders table. |
OUTSIDE_XM_IND | DOUBLE | Y | Indicates that the HLA Crossmatch was performed by an external laboratory. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PRSNL_ID | DOUBLE | N | Identifies the user who last updated the person_hla_xm record or the person who performed the testing for history which is derived from Crossmatch results. |
REMOVED_DT_TM | DATETIME | Y | The date and time this record was removed from HLA history. |
REMOVED_IND | DOUBLE | Y | Indicates that the record has been removed from HLA history. Records are not deleted so that a complete audit trail can be kept. |
TB_CELL_RESULT_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the T and B Cell result used in the Crossmatch. Either derived from Crossmatch results or entered manually into history. |
T_CELL_RESULT_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the T-Cell result used in the Crossmatch. Either derived from Crossmatch results or entered manually into history. |
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. |
XM_DT_TM | DATETIME | Y | Date and time that the record was created. |
XM_TYPE_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the HLA Type used in the Crossmatch. Either derived from Crossmatch results or entered manually into history. |
Relationship Detail - PERSON_HLA_XM
Child Column in PERSON_HLA_XM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HLA_XM_RES_TRAY_ID | HLA_XM_RES_TRAY | HLA_XM_RES_TRAY_ID |
COMMENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
INTERPRETATION_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
B_CELL_RESULT_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
MONO_CELL_RESULT_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
TB_CELL_RESULT_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
T_CELL_RESULT_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
XM_TYPE_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
ORDER_ID | ORDERS | ORDER_ID | |
DONOR_ID | PERSON | PERSON_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in PERSON_HLA_XM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | HLA_XM_ID | PERSON_HLA_XM_AUDIT | HLA_XM_ID |
PERSON_HLA_XM_AUDIT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person HLA Crossmatch Audit |
Definition: | Provides an audit trail of the Person HLA Crossmatch table whenever a record is modified. |
Table Type: | ACTIVITY |
Column Detail - PERSON_HLA_XM_AUDIT
Column Name | Type | Null? | Definition |
---|---|---|---|
AUDIT_DT_TM | DATETIME | Y | Date and time that the audit record was created. |
B_CELL_RESULT_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the B-Cell result which is part of the HLA Crossmatch. |
CHARTED_IND | DOUBLE | Y | Indicator to signify whether the row has been charted. |
COMMENT_LONG_TEXT_ID | DOUBLE | N | Relates this record to a specific long_text record where HLA Crossmatch history audit trail comments are stored. It is a foreign key reference to the primary key of the long_text table. |
COMPLETE_DT_TM | DATETIME | Y | Date and time that the HLA crossmatch results were completed. |
DONOR_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. This is the person crossmatched against this records person_id. |
HLA_XM_AUDIT_ID | DOUBLE | N | A sequentially assigned number which uniquely identifies an HLA Crossmatch Audit history record. |
HLA_XM_ID | DOUBLE | N | Relates this audit record to the current HLA Crossmatch History record. It is a foreign key reference to the primary key of the person_hla_xm table. |
INTERPRETATION_LONG_TEXT_ID | DOUBLE | N | Relates this record to a specific long_text record where Interpretation comments are stored. It is a foreign key reference to the primary key of the long_text table. Either derived from Crossmatch orders or entered manually. |
MONO_CELL_RESULT_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the Monocyte cell result which is part of the HLA Crossmatch. |
OUTSIDE_XM_IND | DOUBLE | Y | Indicates that the HLA Crossmatch was performed by an external laboratory. |
PRSNL_ID | DOUBLE | N | Identifies the user who updated the person_hla_xm record which resulted in the creation of this audit record. |
TB_CELL_RESULT_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the T and B cell result which is part of the HLA Crossmatch. |
T_CELL_RESULT_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the T-Cell result which is part of the HLA Crossmatch. |
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. |
XM_DT_TM | DATETIME | Y | Date and time that the original person_hla_xm record was created. |
XM_TYPE_NOM_ID | DOUBLE | N | Identifies the nomenclature entry for the Crossmatch Type which is part of the HLA Crossmatch. |
Relationship Detail - PERSON_HLA_XM_AUDIT
Child Column in PERSON_HLA_XM_AUDIT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | COMMENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
INTERPRETATION_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
B_CELL_RESULT_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
MONO_CELL_RESULT_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
TB_CELL_RESULT_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
T_CELL_RESULT_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
XM_TYPE_NOM_ID | NOMENCLATURE | NOMENCLATURE_ID | |
DONOR_ID | PERSON | PERSON_ID | |
HLA_XM_ID | PERSON_HLA_XM | HLA_XM_ID | |
PRSNL_ID | PRSNL | PERSON_ID |
PERSON_ORGAN_DONOR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Organ Donor |
Definition: | Identifies a person as an organ donor and defines the type of organ, the conditions for donation and other relevant information. |
Table Type: | ACTIVITY |
Column Detail - PERSON_ORGAN_DONOR
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. |
COMMENT_LONG_TEXT_ID | DOUBLE | N | Relates this record to a specific long_text record where Organ Donor comments are stored. It is a foreign key reference to the primary key of the long_text table. |
CURRENT_DRUG_THERAPY | VARCHAR(255) | Y | Text describing the current drug therapy for the person. |
DONATION_DT_TM | DATETIME | Y | Date and time that the organ was donated. |
DONATION_IND | DOUBLE | Y | Indicates that the organ has been donated. |
DONOR_TYPE_CD | DOUBLE | N | The code for the type of organ donation. Specifies when the organ is or will be available (e.g. living donation, upon death, or deceased and available). |
INTL_ALIAS_ID | DOUBLE | N | International Alias ID. Additional fields for alias capture (alias person type). |
NMDP_ALIAS_ID | DOUBLE | N | Relates this record to a specific person_alias record where the NMDP id is stored. It is a foreign key reference to the primary key of the person_alias table. |
NMDP_ASSIGNED_IND | DOUBLE | Y | Indicates that the donor has been assigned an id from the National Marrow Donor Program. |
OPO_ALIAS_ID | DOUBLE | N | OPO Alias ID. Additional fields for alias capture (alias person type). |
ORGAN_SIZE | DOUBLE | Y | The size of the organ to be donated (if applicable). |
ORGAN_TYPE_CD | DOUBLE | N | The code for the type of organ to be donated. |
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_ORGAN_ID | DOUBLE | N | A sequentially assigned number which uniquely identifies an Organ Donor record. |
UNOS_ALIAS_ID | DOUBLE | N | Relates this record to a specific person_alias record where the UNOS id is stored. It is a foreign key reference to the primary key of the person_alias table. |
UNOS_ASSIGNED_IND | DOUBLE | Y | Indicates that the donor has been assigned an id from the United Network of Organ Sharing. |
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_ORGAN_DONOR
Child Column in PERSON_ORGAN_DONOR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | COMMENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
PERSON_ID | PERSON | PERSON_ID | |
INTL_ALIAS_ID | PERSON_ALIAS | PERSON_ALIAS_ID | |
NMDP_ALIAS_ID | PERSON_ALIAS | PERSON_ALIAS_ID | |
OPO_ALIAS_ID | PERSON_ALIAS | PERSON_ALIAS_ID | |
UNOS_ALIAS_ID | PERSON_ALIAS | PERSON_ALIAS_ID |
PERSON_TRANSPLANT_CANDIDATE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Transplant Candidate |
Definition: | Identifies a person as a candidate for transplantation and defines their need and other relevant information. |
Table Type: | ACTIVITY |
Column Detail - PERSON_TRANSPLANT_CANDIDATE
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. |
COMMENT_LONG_TEXT_ID | DOUBLE | N | Relates this record to a specific long_text record where Transplant Candidate comments are stored. It is a foreign key reference to the primary key of the long_text 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. |
CRITICALITY_CD | DOUBLE | N | The code for the recipient criticality. |
CURRENT_DRUG_THERAPY | VARCHAR(255) | Y | Text describing the current drug therapy for the person. |
DIAGNOSIS | VARCHAR(255) | Y | Text describing the transplant candidiates diagnosis. |
DIALYSIS_CLINIC_CD | DOUBLE | N | The code value to the Dialysis Clinic for the organ |
HIC_ALIAS_ID | DOUBLE | N | HIC Alias ID. Additional field for alias capture (alias person type) |
NMDP_ALIAS_ID | DOUBLE | N | Relates this record to a specific person_alias record where the NMDP id is stored. It is a foreign key reference to the primary key of the person_alias table. |
NMDP_ASSIGNED_IND | DOUBLE | Y | Indicates that the donor has been assigned an id from the National Marrow Donor Program. |
OPO_ALIAS_ID | DOUBLE | N | OPO Alias ID. Additional field for alias capture (alias person type) |
ORGAN_SIZE | DOUBLE | Y | The size of the organ to be donated (if applicable). |
ORGAN_TYPE_CD | DOUBLE | N | The code for the type of organ needed. |
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_TRANSPLANT_ID | DOUBLE | N | A sequentially assigned number which uniquely identifies a Transplant Candidate record. |
PREV_TRANSPLANT_DT_TM | DATETIME | Y | Date and time of the most recent previous transplant (if any). |
PREV_TRANSPLANT_IND | DOUBLE | Y | Indicates that the person has previously been transplaneted with this type of organ. |
PRIORITY_CD | DOUBLE | N | The code for the tranplant priority. |
PX_ALIAS_ID | DOUBLE | N | PX Alias ID. Additional field for alias capture (alias person type) |
TRANSPLANT_CENTER_CD | DOUBLE | N | The code value to the Transplant Center for the organ. |
TRANSPLANT_DT_TM | DATETIME | Y | Date and time the transplant this record refers to took place. |
TRANSPLANT_IND | DOUBLE | Y | Indicates that the transplant this record refers to has taken place. |
UNOS_ALIAS_ID | DOUBLE | N | Relates this record to a specific person_alias record where the UNOS id is stored. It is a foreign key reference to the primary key of the person_alias table. |
UNOS_ASSIGNED_IND | DOUBLE | Y | Indicates that the donor has been assigned an id from the United Network of Organ Sharing. |
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_TRANSPLANT_CANDIDATE
Child Column in PERSON_TRANSPLANT_CANDIDATE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | COMMENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
PERSON_ID | PERSON | PERSON_ID | |
HIC_ALIAS_ID | PERSON_ALIAS | PERSON_ALIAS_ID | |
NMDP_ALIAS_ID | PERSON_ALIAS | PERSON_ALIAS_ID | |
OPO_ALIAS_ID | PERSON_ALIAS | PERSON_ALIAS_ID | |
PX_ALIAS_ID | PERSON_ALIAS | PERSON_ALIAS_ID |
PHENOTYPE_LOCI
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Phenotype Loci |
Definition: | Specifies the loci for which HLA typings should be displayed when the patient and related potential donors are listed in the Haplotype Chart application for a specific potential recipient. |
Table Type: | ACTIVITY |
Column Detail - PHENOTYPE_LOCI
Column Name | Type | Null? | Definition |
---|---|---|---|
HAPLOTYPE_CHART_ID | DOUBLE | N | Relates the loci to be displayed for recipient and related donor phenotypes to a specific haplotype chart. |
LOCI_CD | DOUBLE | N | The code for the specific HLA Loci to display for recipient and related donor phenotypes. |
LOCI_SEQ | DOUBLE | N | Arbitrarily assigned number to make each record unique and to determine the order the loci are displayed for recipient and related donor phenotypes. |
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 - PHENOTYPE_LOCI
Child Column in PHENOTYPE_LOCI(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HAPLOTYPE_CHART_ID | HAPLOTYPE_CHART | HAPLOTYPE_CHART_ID |