Table Detail Report

HLA_TYP_RES_TRAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Typing Result Tray
Definition: Relates an order to the inventory lot and HLA typing tray map selected for testing.
Table Type: ACTIVITY





Column Detail - HLA_TYP_RES_TRAY


Column Name Type Null? Definition
COMMENT_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record where HLA Typing 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 typing tray.
LOT_NUMBER_ID DOUBLE N Identifies the inventory lot of the HLA Typing 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 typing tray.
ORDER_ID DOUBLE N Relates results for the HLA Typing tray to a specific order. It is a foreign key reference to the primary key of the orders table.
PLATED_DT_TM DATETIME Y Date the HLA typing tray was plated.
PLATED_PRSNL_ID DOUBLE N Id of the person who plated the HLA typing tray.
READ_DT_TM DATETIME Y Date the HLA typing tray was reviewed.
READ_PRSNL_ID DOUBLE N Id of the person who read the HLA typing tray.
SEPARATED_DT_TM DATETIME Y Date the cells were separated for the HLA typing tray.
SEPARATED_PRSNL_ID DOUBLE N Id of the person who separated the cells for the HLA typing 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 typing tray.



Relationship Detail - HLA_TYP_RES_TRAY


Child Column in HLA_TYP_RES_TRAY(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID HLA_TYP_TRAY_MAP LOT_NUMBER_ID
COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PLATED_PRSNL_ID PRSNL PERSON_ID
READ_PRSNL_ID PRSNL PERSON_ID
SEPARATED_PRSNL_ID PRSNL PERSON_ID




Parent Column in HLA_TYP_RES_TRAY (PK) Child Table Name Child Column Name
Children: LOT_NUMBER_ID HLA_TYP_TRAY_WELL_SCORE LOT_NUMBER_ID
ORDER_ID HLA_TYP_TRAY_WELL_SCORE ORDER_ID


HLA_TYP_TRAY_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Typing Tray Map
Definition: Further defines an inventory lot as being an HLA typing tray and specifies the dimensions of the tray.
Table Type: REFERENCE





Column Detail - HLA_TYP_TRAY_MAP


Column Name Type Null? Definition
LOT_NUMBER_ID DOUBLE N Identifies the inventory lot of the HLA Typing 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 typing tray.
TRAY_ABBREVIATION CHAR(20) Y The abbreviation given an HLA Tying tray . This abbreviation will be used to identify the tray when it used in testing.
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 Typing tray should be represented as characters.
X_DIM DOUBLE Y Horizontal dimension of the HLA Typing tray.
Y_ALPHA_IND DOUBLE Y Indicates whether the vertical coordinates of the HLA Typing tray should be represented as characters.
Y_DIM DOUBLE Y Vertical dimension of the HLA Typing tray.



Relationship Detail - HLA_TYP_TRAY_MAP


Child Column in HLA_TYP_TRAY_MAP(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID




Parent Column in HLA_TYP_TRAY_MAP (PK) Child Table Name Child Column Name
Children: LOT_NUMBER_ID HLA_TYP_RES_TRAY LOT_NUMBER_ID
HLA_TYP_TRAY_WELL LOT_NUMBER_ID


HLA_TYP_TRAY_WELL



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Typing Tray Well
Definition: Defines what is contained in a single tray well located on a specific HLA typing tray.
Table Type: REFERENCE





Column Detail - HLA_TYP_TRAY_WELL


Column Name Type Null? Definition
LOT_NUMBER_ID DOUBLE N Relates the HLA Typing 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.
MANUFACTURER_CD DOUBLE N No longer used.
SERUM_ID DOUBLE N Identifies in conjunction with manufacturer the unique serum contained in an HLA Typing tray well. Serum_id and manufacturer_cd are a foreign key reference to the primary key of the hla_tray_well_serum table.
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 Typing tray being defined.
Y_POS DOUBLE N The vertical coordinate of a well on the HLA Typing tray being defined.



Relationship Detail - HLA_TYP_TRAY_WELL


Child Column in HLA_TYP_TRAY_WELL(FK) Parent Table Name Parent Column Name
Parents: SERUM_ID HLA_TRAY_WELL_SERUM SERUM_ID
LOT_NUMBER_ID HLA_TYP_TRAY_MAP LOT_NUMBER_ID


HLA_TYP_TRAY_WELL_SCORE



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Typing Tray Well Score
Definition: Records the individual well scores as part of the raw result data specific to HLA typing for an order.
Table Type: ACTIVITY





Column Detail - HLA_TYP_TRAY_WELL_SCORE


Column Name Type Null? Definition
FALSE_NEG_IND DOUBLE Y Indicates whether the well was falsely scored as negative based on the antigens identified in the interpretation of the HLA Tping tray. NOT CURRENTLY IMPLEMENTED.
FALSE_POS_IND DOUBLE Y Indicates whether the well was falsely scored as positive based on the antigens identified in the interpretation of the HLA Tping tray. NOT CURRENTLY IMPLEMENTED.
LOT_NUMBER_ID DOUBLE N Identifies the inventory lot of the HLA Typing tray for which the well score is being recorded. It is a foreign key reference to the primary key of the lot_number_info table.
ORDER_ID DOUBLE N Relates well scores for the HLA Typing tray to a specific order. It is a foreign key reference to the primary key of the orders table.
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 Typing 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_TYP_TRAY_WELL_SCORE


Child Column in HLA_TYP_TRAY_WELL_SCORE(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID HLA_TYP_RES_TRAY LOT_NUMBER_ID
ORDER_ID HLA_TYP_RES_TRAY ORDER_ID


HLA_XM_HISTORY_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Crossmatch History Map
Definition: Provides for the mapping of discrete task assay results for a specific orderable procedure to appropriate fields in the Person HLA Crossmatch record. This mapping is used to create these records when the results are released for charting.
Table Type: REFERENCE





Column Detail - HLA_XM_HISTORY_MAP


Column Name Type Null? Definition
B_CELL_RESULT_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the B-Cell Reactive result. It is a foreign key reference to the primary key of the discrete_task_assay table.
CATALOG_CD DOUBLE N The code referencing the order catalog procedure from which the Crossmatch history record(s) will be built. It is a foreign key reference to the primary key of the order_catalog table.
INTERPRETATION_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the Interpretation result. It is a foreign key reference to the primary key of the discrete_task_assay table.
MONO_CELL_RESULT_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the Monocyte Cell Reactive result. It is a foreign key reference to the primary key of the discrete_task_assay table.
TB_CELL_RESULT_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the T/B-Cell Reactive result. It is a foreign key reference to the primary key of the discrete_task_assay table.
T_CELL_RESULT_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the T-Cell Reactive result. It is a foreign key reference to the primary key of the discrete_task_assay table.
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_TYPE_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the crossmatch type result. It is a foreign key reference to the primary key of the discrete_task_assay table.
XM_TYPE_NOM_ID DOUBLE N Identifies the nomenclature entry to use for crossmatch type in creating an crossmatch history record. It is a foreign key reference to the primary key of the nomenclature table.



Relationship Detail - HLA_XM_HISTORY_MAP


Child Column in HLA_XM_HISTORY_MAP(FK) Parent Table Name Parent Column Name
Parents: B_CELL_RESULT_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
INTERPRETATION_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
MONO_CELL_RESULT_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
TB_CELL_RESULT_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
T_CELL_RESULT_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
XM_TYPE_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
XM_TYPE_NOM_ID NOMENCLATURE NOMENCLATURE_ID