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 |