Table Detail Report
HLA_XM_RES_TRAY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | HLA Crossmatch Result Tray |
Definition: | Relates an inventory lot and HLA crossmatch tray map selected for testing. |
Table Type: | ACTIVITY |
Column Detail - HLA_XM_RES_TRAY
Column Name | Type | Null? | Definition |
---|---|---|---|
BATCH_DESC | VARCHAR(30) | Y | The description given an HLA Crossmatch result tray . This description will be used to identify the tray when selecting it. |
COMMENT_LONG_TEXT_ID | DOUBLE | N | Relates this record to a specific long_text record where HLA Crossmatch tray result comments are stored. It is a foreign key reference to the primary key of the long_text table. |
COMPLEMENT | VARCHAR(20) | Y | Complement lot number or other information pertaining to the complement used on an HLA crossmatch tray. |
DONOR_ID | DOUBLE | N | Id of the donor of the HLA crossmatch tray. |
HLA_XM_RES_TRAY_ID | DOUBLE | N | A sequentially assigned number which uniquely identifies a HLA crossmatch tray record. |
LOT_NUMBER_ID | DOUBLE | N | Identifies the inventory lot of the HLA crossmatch tray being used. It is a foreign key reference to the primary key of the lot_number_info table. |
MAGNETIC_BEADS | VARCHAR(20) | Y | Magnetic beads lot number or other information pertaining to the magnetic beads used on an HLA crossmatch tray. |
ORDER_ID | DOUBLE | N | ID of the order that the donor is associated to |
PLATED_DT_TM | DATETIME | Y | The Date the HLA crossmatch tray was plated. |
PLATED_PRSNL_ID | DOUBLE | N | Id of the person who plated the HLA crossmatch tray. |
READ_DT_TM | DATETIME | Y | The date the HLA crossmatch tray was reviewed. |
READ_PRSNL_ID | DOUBLE | N | Id of the person who read the HLA crossmatch tray. |
SEPARATED_DT_TM | DATETIME | Y | Date the cells were separated for the HLA crossmatch tray. |
SEPARATED_PRSNL_ID | DOUBLE | N | Id of the person who separated the cells for the HLA crossmatch tray. |
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. |
VIABILITY | DOUBLE | Y | Viability percentage for the cells placed on an HLA crossmatch tray. |
WORKLIST_ID | DOUBLE | N | Identifies the worklist associated to the HLA crossmatch tray being used. It is a foreign key reference to the primary key of the worklist table. |
Relationship Detail - HLA_XM_RES_TRAY
Child Column in HLA_XM_RES_TRAY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOT_NUMBER_ID | HLA_XM_TRAY_MAP | LOT_NUMBER_ID |
COMMENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
ORDER_ID | ORDERS | ORDER_ID | |
DONOR_ID | PERSON | PERSON_ID | |
PLATED_PRSNL_ID | PRSNL | PERSON_ID | |
READ_PRSNL_ID | PRSNL | PERSON_ID | |
SEPARATED_PRSNL_ID | PRSNL | PERSON_ID | |
WORKLIST_ID | WORKLIST | WORKLIST_ID |
Parent Column in HLA_XM_RES_TRAY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | HLA_XM_RES_TRAY_ID | HLA_XM_TRAY_WELL_SCORE | HLA_XM_RES_TRAY_ID |
PERSON_HLA_XM | HLA_XM_RES_TRAY_ID |
HLA_XM_TRAY_MAP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | HLA Crossmatch Tray Map |
Definition: | Further defines an inventory lot as being an HLA crossmatch tray and it specifies the dimensions of the tray. |
Table Type: | REFERENCE |
Column Detail - HLA_XM_TRAY_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
LOT_NUMBER_ID | DOUBLE | N | Identifies the inventory lot of the HLA Crossmatch tray for which the mapping is being defined. It is a foreign key reference to the primary key of the lot_number_info table. |
QC_IND | DOUBLE | Y | Indicates whether or not quality control procedures have been performed on the crossmatch tray. |
READING_PATTERN_CD | DOUBLE | N | Specifies the default reading pattern the tray is scored. |
TRAY_ABBREVIATION | CHAR(20) | Y | The abbreviation given an HLA Crossmatch tray . This abbreviation will be used to identify the tray when it used in testing. |
TRAY_COUNT | DOUBLE | Y | The number of trays grouped together for one result. |
TRAY_ORIENTATION_CD | DOUBLE | N | Specifies the default direction the tray is rotated when placed on the microscope. |
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. |
X_ALPHA_IND | DOUBLE | Y | Indicates whether the horizontal coordinates of the HLA Crossmatch tray should be represented as characters. |
X_DIM | DOUBLE | Y | Horizontal dimension of the HLA Crossmatch tray. |
Y_ALPHA_IND | DOUBLE | Y | Indicates whether the vertical coordinates of the HLA Crossmatch tray should be represented as characters. |
Y_DIM | DOUBLE | Y | Vertical dimension of the HLA Crossmatch tray. |
Relationship Detail - HLA_XM_TRAY_MAP
Child Column in HLA_XM_TRAY_MAP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOT_NUMBER_ID | LOT_NUMBER_INFO | LOT_NUMBER_ID |
Parent Column in HLA_XM_TRAY_MAP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LOT_NUMBER_ID | HLA_XM_RES_TRAY | LOT_NUMBER_ID |
HLA_XM_TRAY_WELL | LOT_NUMBER_ID |
HLA_XM_TRAY_WELL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | HLA Crossmatch Tray Well |
Definition: | Defines what is contained in a single tray well located on a specific HLA crossmatch tray. |
Table Type: | ACTIVITY |
Column Detail - HLA_XM_TRAY_WELL
Column Name | Type | Null? | Definition |
---|---|---|---|
DILUTION_CD | DOUBLE | N | The code for the dilution that used for the order at this batch placement. |
HLA_AB_SCREEN_ID | DOUBLE | N | The ID of the Antibody Screen that is placed in a Crossmatch Inventory item at a specific tray position. It is only used for Antibody Screens that are manually entered or uploaded from a contributor system and not for those associated with an order. It is a foreign key reference to the primary key of the Person HLA Ab Screen table. |
LOT_ID | DOUBLE | N | Contains a reference to the Control Lot table. |
LOT_NUMBER_ID | DOUBLE | N | Relates the HLA Crossmatch tray well to the inventory lot and related map. It is a foreign key reference to the primary key of the lot_number_info table. |
METHODOLOGY_CD | DOUBLE | N | The code for the methodology that used for the order at this batch placement. |
ORDER_ID | DOUBLE | N | The ID of the Order that is placed in a Crossmatch batch at a specific tray position. It is a foreign key reference to the primary key of the orders table. |
QC_ACCESSION_ID | DOUBLE | N | The ID of the QC Accession related to a QC Control that is placed in a Crossmatch Inventory item at a specific tray position. It is a foreign key reference to the primary key of the Accession table. |
TRAY_NUMBER | DOUBLE | N | The tray of a well on the HLA Crossmatch tray being 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. |
X_POS | DOUBLE | N | The horizontal coordinate of a well on the HLA Crossmatch tray being defined. |
Y_POS | DOUBLE | N | The vertical coordinate of a well on the HLA Crossmatch tray being defined. |
Relationship Detail - HLA_XM_TRAY_WELL
Child Column in HLA_XM_TRAY_WELL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | QC_ACCESSION_ID | ACCESSION | ACCESSION_ID |
LOT_ID | CONTROL_LOT | LOT_ID | |
LOT_NUMBER_ID | HLA_XM_TRAY_MAP | LOT_NUMBER_ID | |
LOT_NUMBER_ID | LOT_NUMBER_INFO | LOT_NUMBER_ID | |
ORDER_ID | ORDERS | ORDER_ID | |
HLA_AB_SCREEN_ID | PERSON_HLA_AB_SCREEN | HLA_AB_SCREEN_ID |
HLA_XM_TRAY_WELL_SCORE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | HLA Crossmatch Tray Well Score |
Definition: | Records the individual well scores as part of the raw result data specific to HLA crossmatch for an order. |
Table Type: | ACTIVITY |
Column Detail - HLA_XM_TRAY_WELL_SCORE
Column Name | Type | Null? | Definition |
---|---|---|---|
DILUTION_CD | DOUBLE | N | The code for the dilution that used for the order at this batch placement. |
HLA_AB_SCREEN_ID | DOUBLE | N | The ID of the Antibody Screen that is placed in a Crossmatch Inventory item at a specific tray position. It is only used for Antibody Screens that are manually entered or uploaded from a contributor system and not for those associated with an order. It is a foreign key reference to the primary key of the Person HLA Ab Screen table. |
HLA_XM_RES_TRAY_ID | DOUBLE | N | Relates the HLA Crossmatch tray well to the inventory lot and related map. It is a foreign key reference to the primary key of the hla_xm_res_tray table. |
LOT_ID | DOUBLE | N | Contains a reference to the CONTROL_LOT table. |
METHODOLOGY_CD | DOUBLE | N | The code for the methodology that used for the order at this batch placement. |
ORDER_ID | DOUBLE | N | The ID of the Order that is placed in a Crossmatch batch at a specific tray position. It is a foreign key reference to the primary key of the orders table. |
QC_ACCESSION_ID | DOUBLE | N | The ID of the QC Accession related to a QC Control that is placed in a Crossmatch batch at a specific tray position. It is a foreign key reference to the primary key of the Accession table. |
TRAY_NUMBER | DOUBLE | N | The tray of a well on the HLA Crossmatch tray being 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. |
WELL_SCORE_CD | DOUBLE | N | The code for the well score given to this HLA crossmatch tray well. |
X_POS | DOUBLE | N | Horizontal coordinate of the well being scored. |
Y_POS | DOUBLE | N | Vertical coordinate of the well being scored. |
Relationship Detail - HLA_XM_TRAY_WELL_SCORE
Child Column in HLA_XM_TRAY_WELL_SCORE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | QC_ACCESSION_ID | ACCESSION | ACCESSION_ID |
LOT_ID | CONTROL_LOT | LOT_ID | |
HLA_XM_RES_TRAY_ID | HLA_XM_RES_TRAY | HLA_XM_RES_TRAY_ID | |
ORDER_ID | ORDERS | ORDER_ID | |
HLA_AB_SCREEN_ID | PERSON_HLA_AB_SCREEN | HLA_AB_SCREEN_ID |
HLA_X_SPECIMEN_ANALYSIS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | HLA Cross Specimen Analysis |
Definition: | Stores information related to a saved cross specimen analysis. |
Table Type: | ACTIVITY |
Column Detail - HLA_X_SPECIMEN_ANALYSIS
Column Name | Type | Null? | Definition |
---|---|---|---|
CROSS_SPECIMEN_DESC | VARCHAR(250) | N | Entered user-text of the analysis. |
CROSS_SPECIMEN_DT_TM | DATETIME | N | Date and time when the analysis was saved to the database. |
CROSS_SPECIMEN_ID | DOUBLE | N | Identifier of the information related to a saved cross specimen analysis. |
PERSON_ID | DOUBLE | N | The related patient of the cross specimen analysis. |
POSSIBLE_ABS | VARCHAR(250) | N | User-entered text during the cross specimen analysis. |
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 - HLA_X_SPECIMEN_ANALYSIS
Child Column in HLA_X_SPECIMEN_ANALYSIS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
Parent Column in HLA_X_SPECIMEN_ANALYSIS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CROSS_SPECIMEN_ID | HLA_SCREEN_ANALYSIS | CROSS_SPECIMEN_ID |
HLA_X_SPECIMEN_DETAIL | CROSS_SPECIMEN_ID |