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