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 |