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 |