Table Detail Report

PHENOTYPE_LOCI_DEFAULT



Column Section Top of Page


Table-level Detail

Description: Phenotype Loci Default
Definition: Specifies the default loci for which HLA typings should be displayed when the patient and related potential donors are listed in the Haplotype Chart application.
Table Type: REFERENCE





Column Detail - PHENOTYPE_LOCI_DEFAULT


Column Name Type Null? Definition
LOCI_CD DOUBLE N The code for the specific HLA Loci to display for recipient and related donor phenotypes as the defaults when a new haplotype chart is created.
LOCI_SEQ DOUBLE N Arbitrarily assigned number to make each record unique and to determine the order the loci are displayed for recipient and related donor phenotypes as the defaults when a new haplotype chart is created.
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.


POSITIVE_PROBES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Positive Probes
Definition: Indicates which probes in an HLA molecular testing blot require a positive reaction to conclude that a particular HLA allele or specificity is present.
Table Type: REFERENCE





Column Detail - POSITIVE_PROBES


Column Name Type Null? Definition
ALLELE_CD DOUBLE N The code for the allele which this Molecular Blot tests for that requires or a positive reaction for this probe.
LOT_NUMBER_ID DOUBLE N Relates the Molecular Blot positive probes to the inventory lot and related blot. It is a foreign key reference to the primary key of the lot_number_info table.
PROBE_NUMBER DOUBLE N The number of the probe on the Molecular Blot which is being defined as positive for this allele.
REACTION_SYMBOL_CD DOUBLE N The code for the reaction symbol used to indicate the probes requires or may have a positive reaction to indicate the presence of the related allele.
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 - POSITIVE_PROBES


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


POSITIVE_PROBE_RESULT



Column Section Top of Page


Table-level Detail

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





Column Detail - POSITIVE_PROBE_RESULT


Column Name Type Null? Definition
LOT_NUMBER_ID DOUBLE N Identifies the inventory lot of the Molecular Blot being used to arrive at the results. 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.
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.


POSITIVE_TUBES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Positive Tubes
Definition: Indicates which tubes in an aliquotted HLA molecular testing primer kit require a positive reaction to conclude that a particular HLA allele or specificity is present.
Table Type: REFERENCE





Column Detail - POSITIVE_TUBES


Column Name Type Null? Definition
ALLELE_CD DOUBLE N The code for the allele which this Aliquotted Primer Kit tests for that requires or may have a positive reaction in this tube.
LOT_NUMBER_ID DOUBLE N Relates the Aliquotted Primer Kit positive tubes to the inventory lot and related map. It is a foreign key reference to the primary key of the lot_number_info table.
REACTION_SYMBOL_CD DOUBLE N The code for the reaction symbol used to indicate the tube requires or may have a positive reaction to indicate the presence of the related allele.
TUBE_NUMBER DOUBLE N The number of the tube in the Aliquotted Primer Kit which is being defined as positive for this allele.
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 - POSITIVE_TUBES


Child Column in POSITIVE_TUBES(FK) Parent Table Name Parent Column Name
Parents: ALLELE_CD PRIMER_KIT_SPECIFICITY ALLELE_CD
LOT_NUMBER_ID PRIMER_KIT_SPECIFICITY LOT_NUMBER_ID


POSSIBLE_ANTIBODIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Possible Antibodies
Definition: Store possible antibodies for ordered specimen.
Table Type: ACTIVITY





Column Detail - POSSIBLE_ANTIBODIES


Column Name Type Null? Definition
ANTIBODY_STRING VARCHAR(255) Y The string of possible antibodies contained in the specimen.
ORDER_ID DOUBLE N Relates possible antibodies 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 - POSSIBLE_ANTIBODIES


Child Column in POSSIBLE_ANTIBODIES(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID