Table Detail Report

BLOT_BATCH_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blot Batch Result
Definition: Relates an order to the Blot Batch and HLA molecular typing blot selected for testing.
Table Type: ACTIVITY





Column Detail - BLOT_BATCH_RESULT


Column Name Type Null? Definition
AMPLIFICATION_GEL VARCHAR(20) Y Name or number of the Gel that was used to amplify the DNA with primers used in the Blot testing.
BLOT_BATCH_ID DOUBLE N Identifies the inventory lot of the Molecular Blot being used. It is a foreign key reference to the primary key of the lot_number_info table.
ORDER_ID DOUBLE N Relates results for the Molecular Blot 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 Defines the column on a Blot Batch that an order is placed on.
Y_POS DOUBLE N Defines the row on a Blot Batch that an order is placed on.



Relationship Detail - BLOT_BATCH_RESULT


Child Column in BLOT_BATCH_RESULT(FK) Parent Table Name Parent Column Name
Parents: BLOT_BATCH_ID BLOT_BATCH BLOT_BATCH_ID
ORDER_ID ORDERS ORDER_ID




Parent Column in BLOT_BATCH_RESULT (PK) Child Table Name Child Column Name
Children: BLOT_BATCH_ID BLOT_ALLELE_PATTERN_MATCH BLOT_BATCH_ID
ORDER_ID BLOT_ALLELE_PATTERN_MATCH ORDER_ID
X_POS BLOT_ALLELE_PATTERN_MATCH X_POS
Y_POS BLOT_ALLELE_PATTERN_MATCH Y_POS
BLOT_BATCH_ID BLOT_POSITIVE_PROBE BLOT_BATCH_ID
ORDER_ID BLOT_POSITIVE_PROBE ORDER_ID
X_POS BLOT_POSITIVE_PROBE X_POS
Y_POS BLOT_POSITIVE_PROBE Y_POS
BLOT_BATCH_ID BLOT_SPEC_PATTERN_MATCH BLOT_BATCH_ID
ORDER_ID BLOT_SPEC_PATTERN_MATCH ORDER_ID
X_POS BLOT_SPEC_PATTERN_MATCH X_POS
Y_POS BLOT_SPEC_PATTERN_MATCH Y_POS


BLOT_POSITIVE_PROBE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blot Positive Probe
Definition: Indicates whether a positive reaction occured for a specific probe number in an HLA molecular typing blot.
Table Type: ACTIVITY





Column Detail - BLOT_POSITIVE_PROBE


Column Name Type Null? Definition
BLOT_BATCH_ID DOUBLE N Identifies the blot batch of the Molecular Blot being used to arrive at the results. It is a foreign key reference to the primary key of the blot batch table.
ORDER_ID DOUBLE N Relates results for the Molecular Blot to a specific order. It is a foreign key reference to the primary key of the orders table.
PROBE_NUMBER DOUBLE N Number of the molecular blot probe which had a positive reaction
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 Defines the column on a Blot Batch that an order is placed on.
Y_POS DOUBLE N Defines the row on a Blot Batch that an order is placed on.



Relationship Detail - BLOT_POSITIVE_PROBE


Child Column in BLOT_POSITIVE_PROBE(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_SPECIFICITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blot Specificity
Definition: Defines a specific allele and specificity for which an HLA molecular testing blot will be used to test for.
Table Type: REFERENCE





Column Detail - BLOT_SPECIFICITY


Column Name Type Null? Definition
ALLELE_CD DOUBLE N The code for an allele which this Molecular Blot tests for.
LOCI_CD DOUBLE Y The code for a specific HLA Loci that the Molecular Blot tests for.
LOT_NUMBER_ID DOUBLE N Relates the molecular blot allele to the inventory lot and related blot. It is a foreign key reference to the primary key of the lot_number_info table.
SPECIFICITY_CD DOUBLE Y The code for an specificity which this Molecular Blot tests for.
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_SPECIFICITY


Child Column in BLOT_SPECIFICITY(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID MOLECULAR_BLOT LOT_NUMBER_ID




Parent Column in BLOT_SPECIFICITY (PK) Child Table Name Child Column Name
Children: ALLELE_CD POSITIVE_PROBES ALLELE_CD
LOT_NUMBER_ID POSITIVE_PROBES LOT_NUMBER_ID


BLOT_SPEC_PATTERN_MATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blot Specificity Pattern Match
Definition: Records the specificities 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_SPEC_PATTERN_MATCH


Column Name Type Null? Definition
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 specificity to a specific order. It is a foreign key reference to the primary key of the orders table.
SPECIFICITY_CD DOUBLE N The code for an specificity identified as a result of testing using an HLA molecular typing blot.
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 that the order was placed.
Y_POS DOUBLE N The row on the Blot Batch that the order was placed.



Relationship Detail - BLOT_SPEC_PATTERN_MATCH


Child Column in BLOT_SPEC_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_STRIP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blot Strip
Definition: Defines the strips which make up a molecular blot test. The temparature and probe number range for each strip is specified.
Table Type: REFERENCE





Column Detail - BLOT_STRIP


Column Name Type Null? Definition
ENDING_PROBE DOUBLE Y Ending probe number of the range of probes included on the strip.
LOT_NUMBER_ID DOUBLE N Relates the blot strip to the inventory lot and related blot. It is a foreign key reference to the primary key of the lot_number_info table.
STARTING_PROBE DOUBLE Y Beginning probe number of the range of probes included on the strip.
STRIP_SEQ DOUBLE N Arbitrarily assigned number to make each record unique. This is necessary since strip temperature is alpha numeric. Also determines the order of display.
STRIP_TEMPERATURE VARCHAR(20) Y Temperature at which the blot strip is incubated during testing.
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_STRIP


Child Column in BLOT_STRIP(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID MOLECULAR_BLOT LOT_NUMBER_ID