ALIQUOTTED_PRIMER_KIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Aliquotted Primer Kit
Definition: Further defines an inventory lot as being an HLA molecular testing primer kit that has been aliquotted.
Table Type: REFERENCE





Column Detail - ALIQUOTTED_PRIMER_KIT


Column Name Type Null? Definition
GEL_X_DIM DOUBLE Y Default number of columns for a Gel this aliquotted primer kit placed on.
GEL_Y_DIM DOUBLE Y Default number of rows for a Gel this aliquotted primer kit placed on.
KIT_ABBREVIATION CHAR(20) Y The abbreviation given an HLA molecular primer kit. This abbreviation will be used to identify the aliquotted kit's primer tubes when they are placed in racks or on gels.
LOCI_CD DOUBLE N The code for a specific HLA Loci that the aliquotted primer kit tests for.
LOT_NUMBER_ID DOUBLE N Uniquely identifies the record. 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 aliquotted primer kit.
TUBE_COUNT DOUBLE Y The number of tubes contained in the aliquotted primer kit.
TUBE_START DOUBLE Y The starting position of the first tube in the aliquotted primer kit. Primer kits may be broken into separate aliquotted kits.
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 - ALIQUOTTED_PRIMER_KIT


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




Parent Column in ALIQUOTTED_PRIMER_KIT (PK) Child Table Name Child Column Name
Children: LOT_NUMBER_ID GEL_LOADING_POSN LOT_NUMBER_ID
PRIMER_KIT_SPECIFICITY LOT_NUMBER_ID
THERMO_RACK_PLACEMENT LOT_NUMBER_ID
TUBE_INFORMATION LOT_NUMBER_ID


ALLELE_PATTERN_MATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Allele Pattern Match
Definition: Records the alleles identified in HLA molecular gel testing as determined by pattern matching or as entered by the user for a specific order and gel.
Table Type: ACTIVITY





Column Detail - ALLELE_PATTERN_MATCH


Column Name Type Null? Definition
ALLELE_CD DOUBLE N The code for an allele identified as a result of testing using an HLA molecular typing gel.
GEL_BATCH_ID DOUBLE N Identifies which gel batch this gel is associated with. It is a foreign key reference to the primary key of the gel_batch table.
GEL_NUMBER DOUBLE N A number which identifies the gel to which the allele result relates. It is a foreign key reference to the primary key of the gel table.
LOCI_CD DOUBLE N The code for the HLA Loci where the allele is located.
LOCI_SEQ DOUBLE N Arbitrarily assigned number to make each record unique. This is necessary since the same Loci Code and Allele Code may be used more than once. Also determines the order of display.
ORDER_ID DOUBLE N Relates the allele 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.



Relationship Detail - ALLELE_PATTERN_MATCH


Child Column in ALLELE_PATTERN_MATCH(FK) Parent Table Name Parent Column Name
Parents: GEL_BATCH_ID GEL_LOADING GEL_BATCH_ID
GEL_NUMBER GEL_LOADING GEL_NUMBER
ORDER_ID GEL_LOADING ORDER_ID


ALLELE_SPECIFICITY_XREF



Column Section Top of Page


Table-level Detail

Description: Allele Specificity Cross Reference
Definition: Defines a relationship between an allele code value and a specificity code value.
Table Type: REFERENCE





Column Detail - ALLELE_SPECIFICITY_XREF


Column Name Type Null? Definition
ALLELE_CD DOUBLE N Identifies the allele code value that is related to the specificity code value.
SPECIFICITY_CD DOUBLE N Identifies the specificity code value that is related to the allele code value.
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.


BLOT_ALLELE_PATTERN_MATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blot Allele Pattern Match
Definition: Records the alleles identified in HLA molecular blot testing as determined by pattern matching or as entered by the user for a specific order and blot.
Table Type: ACTIVITY





Column Detail - BLOT_ALLELE_PATTERN_MATCH


Column Name Type Null? Definition
ALLELE_CD DOUBLE N The code for an allele identified as a result of testing using an HLA molecular typing blot.
BLOT_BATCH_ID DOUBLE N A number which identifies the blot batch to which the allele result relates. It is a foreign key reference to the primary key of the blot_batch table.
ORDER_ID DOUBLE N Relates the allele 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.
X_POS DOUBLE N The column on the Blot Batch where the order is placed.
Y_POS DOUBLE N The row on the Blot Batch where the order is placed.



Relationship Detail - BLOT_ALLELE_PATTERN_MATCH


Child Column in BLOT_ALLELE_PATTERN_MATCH(FK) Parent Table Name Parent Column Name
Parents: BLOT_BATCH_ID BLOT_BATCH_RESULT BLOT_BATCH_ID
ORDER_ID BLOT_BATCH_RESULT ORDER_ID
X_POS BLOT_BATCH_RESULT X_POS
Y_POS BLOT_BATCH_RESULT Y_POS


BLOT_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blot Batch
Definition: Relates a unique Blot Batch to the inventory lot.
Table Type: ACTIVITY





Column Detail - BLOT_BATCH


Column Name Type Null? Definition
BLOT_BATCH_DESC VARCHAR(30) Y The description of the Blot Batch.
BLOT_BATCH_ID DOUBLE N Unique Identifier for the Blot Batch
DOWNLOAD_DT_TM DATETIME Y The date and time the batch was downloaded.
DOWNLOAD_PRSNL_ID DOUBLE N The ID of the user who downloaded the batch.
FILL_COLUMN_IND DOUBLE N Indicator to record whether a blot batch was filled by column.0 - filled by row1 - filled by column
LOT_NUMBER_ID DOUBLE N Identifies the inventory lot of the Antibody Screen used for this batch. It is a foreign key reference to the primary key of the lot_number_info 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 - BLOT_BATCH


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




Parent Column in BLOT_BATCH (PK) Child Table Name Child Column Name
Children: BLOT_BATCH_ID BLOT_BATCH_RESULT BLOT_BATCH_ID