Table Detail Report
HLA_X_SPECIMEN_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | HLA Cross Specimen Analysis Detail |
Definition: | Stores detail information related to a cross specimen antibody screen analysis. |
Table Type: | ACTIVITY |
Column Detail - HLA_X_SPECIMEN_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
BATCH_ID | DOUBLE | N | Identifies the tray selected for use in the cross specimen analysis. |
CROSS_SPECIMEN_DETAIL_ID | DOUBLE | N | A column used to create a unique identifier for the HLA__X_SPECIMEN_DETAIL table. |
CROSS_SPECIMEN_ID | DOUBLE | N | Relates information to a saved cross specimen analysis. |
ORDER_ID | DOUBLE | N | The order id that is related to the tray used in the cross specimen analysis. |
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 - HLA_X_SPECIMEN_DETAIL
Child Column in HLA_X_SPECIMEN_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BATCH_ID | HLA_AB_SCREEN_BATCH | BATCH_ID |
CROSS_SPECIMEN_ID | HLA_X_SPECIMEN_ANALYSIS | CROSS_SPECIMEN_ID | |
ORDER_ID | ORDERS | ORDER_ID |
ITEM_ITEM_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Item to Item Cross Reference |
Definition: | Relates two item definitions in inventory as parent-child. Used in HLA to show the relationship between molecular primer kits and aliquotted molecular primer kits. |
Table Type: | REFERENCE |
Column Detail - ITEM_ITEM_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_ITEM_ID | DOUBLE | N | An aliquotted primer kit inventory item which is related to a specific non-aliquotted primer kit inventory item. It is a foreign key reference to the primary key of the item_definition table. |
PARENT_ITEM_ID | DOUBLE | N | A non-aliquotted primer kit inventory item which is related to one or more aliquotted primer kit inventory items. It is a foreign key reference to the primary key of the item_definition 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 - ITEM_ITEM_XREF
Child Column in ITEM_ITEM_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHILD_ITEM_ID | ITEM_DEFINITION | ITEM_ID |
PARENT_ITEM_ID | ITEM_DEFINITION | ITEM_ID |
MOLECULAR_BLOT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Molecular Blot |
Definition: | Further defines an inventory lot as being an HLA molecular testing blot. |
Table Type: | REFERENCE |
Column Detail - MOLECULAR_BLOT
Column Name | Type | Null? | Definition |
---|---|---|---|
BLOT_ABBREVIATION | CHAR(20) | Y | The abbreviation given an HLA molecular blot. This abbreviation will be used to identify the blot when it is used in testing. |
FILL_COLUMN_IND | DOUBLE | N | Indicator to enable batches to be filled by column in Blot Batch Build0 = fill by row1 = fill by column |
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. |
NORMAL_BLOT_IND | DOUBLE | Y | Indicates whether the Molecular Blot is a Normal Dot Blot or Reverse Dot Blot. 0 = Reverse, 1 = Normal. |
PROBE_COUNT | DOUBLE | Y | The number of probes contained in the blot. |
QC_IND | DOUBLE | Y | Indicates whether or not quality control procedures have been performed on the molecular 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_ALPHA_IND | DOUBLE | Y | Indicates whether the horizontal coordinates of the Molecular Blot should be represented as characters. |
X_DIM | DOUBLE | Y | Horizontal dimension of the Molecular Blot |
Y_ALPHA_IND | DOUBLE | Y | Indicates whether the vertical coordinates of the Molecular Blot should be represented as characters. |
Y_DIM | DOUBLE | Y | Vertical dimension of the Molecular Blot. |
Relationship Detail - MOLECULAR_BLOT
Child Column in MOLECULAR_BLOT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOT_NUMBER_ID | LOT_NUMBER_INFO | LOT_NUMBER_ID |
Parent Column in MOLECULAR_BLOT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LOT_NUMBER_ID | BLOT_SPECIFICITY | LOT_NUMBER_ID |
BLOT_STRIP | LOT_NUMBER_ID | ||
PROBE_INFORMATION | LOT_NUMBER_ID |
NMDP_ALLELE_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | NMDP Allele XRef |
Definition: | Cross Reference table that relates generated NMDP Codes to the Allele Cd's that make up the NMDP Code group. |
Table Type: | ACTIVITY |
Column Detail - NMDP_ALLELE_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
ALLELE_CD | DOUBLE | N | Code Value for the Allele that makes up part of the NMDP Code generated. |
NMDP_CD | DOUBLE | N | Code Value for the NMDP code that was generated for a specific set of alleles. |
NMDP_CODE_ID | DOUBLE | N | Foreign key reference to the generated NMDP Code for the list of Alleles that are contained within the code. |
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 - NMDP_ALLELE_XREF
Child Column in NMDP_ALLELE_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NMDP_CODE_ID | NMDP_CODE | NMDP_CODE_ID |
NMDP_CODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | NMDP Code |
Definition: | Contains the NMDP Codes that are generated from the NMDP Codes and HLA Alleles that have been entered. |
Table Type: | ACTIVITY |
Column Detail - NMDP_CODE
Column Name | Type | Null? | Definition |
---|---|---|---|
NMDP_CODE_DESC | VARCHAR(255) | Y | The description of the generated NMDP Code. |
NMDP_CODE_ID | DOUBLE | N | This is the value of the unique primary identifier of the nmdp_code table. It is an internal system assigned number. |
NMDP_SUFFIX_ID | DOUBLE | N | Relates this NMDP Code to a NMDP Suffix. It is a foreign key reference to the primary key of the NMDP Suffix 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 - NMDP_CODE
Child Column in NMDP_CODE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NMDP_SUFFIX_ID | NMDP_SUFFIX | NMDP_SUFFIX_ID |
Parent Column in NMDP_CODE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | NMDP_CODE_ID | NMDP_ALLELE_XREF | NMDP_CODE_ID |