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