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 |