Table Detail Report

TUBE_INFORMATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tube Information
Definition: Additional information about an HLA molecular testing primer kit tube.
Table Type: REFERENCE





Column Detail - TUBE_INFORMATION


Column Name Type Null? Definition
LOT_NUMBER_ID DOUBLE N Relates the Aliquotted Primer Kit tube information to the inventory lot and related map. It is a foreign key reference to the primary key of the lot_number_info table.
TUBE_DESC VARCHAR(255) Y Additional information about a specific tube in an aliquotted primer kit.
TUBE_NUMBER DOUBLE N Number of the aliquotted primer kit tube.
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 - TUBE_INFORMATION


Child Column in TUBE_INFORMATION(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID ALIQUOTTED_PRIMER_KIT LOT_NUMBER_ID


WELL_CELL_ANTIGEN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Well Cell Antigen
Definition: Defines a single antigen which is present in a specific donor's cells used in building an HLA antibody screen or screens.
Table Type: REFERENCE





Column Detail - WELL_CELL_ANTIGEN


Column Name Type Null? Definition
ANTIGEN_CD DOUBLE N The code for the antigen included in the HLA Antibody Screen well cell definition.
ANTIGEN_SEQ DOUBLE N Specifies the sequence of the antigen included in the HLA Antibody Screen well cell definition.
CELL_ID DOUBLE N Identifies in conjunction with manufacturer the unique cells contained in an Antibody Screen tray well. Cell_id and manufacturer_cd are a foreign key reference to the primary key of the hla_ab_scrn_well_cell table.
MANUFACTURER_CD DOUBLE N No longer used.
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 - WELL_CELL_ANTIGEN


Child Column in WELL_CELL_ANTIGEN(FK) Parent Table Name Parent Column Name
Parents: CELL_ID HLA_AB_SCRN_WELL_CELL CELL_ID


WELL_SERUM_AB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Well Serum Antibody
Definition: Defines a single antibody which is present in a specific donor's serum used in building an HLA typing tray or trays.
Table Type: REFERENCE





Column Detail - WELL_SERUM_AB


Column Name Type Null? Definition
ANTIBODY_CD DOUBLE N The code for the antibody included in the HLA Typing tray well serum definition.
ANTIBODY_SEQ DOUBLE N Specifies the sequence of the antibody included in the HLA Typing tray well serum definition.
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.



Relationship Detail - WELL_SERUM_AB


Child Column in WELL_SERUM_AB(FK) Parent Table Name Parent Column Name
Parents: SERUM_ID HLA_TRAY_WELL_SERUM SERUM_ID