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