Table Detail Report

NMDP_SUBTYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: NMDP Subtype
Definition: Defines the various allele subtypes that make up an NMDP Code group.
Table Type: REFERENCE





Column Detail - NMDP_SUBTYPE


Column Name Type Null? Definition
NMDP_SUFFIX_ID DOUBLE N Relates the subtype to a specific NMDP Suffix. It is a foreign key reference to the primary key of the NMDP_SUFFIX table.
SUBTYPE_DESC VARCHAR(255) Y The allele subtype that is part of the NMDP Code group.
SUBTYPE_SEQUENCE DOUBLE N Arbitrarily assigned number to make each record unique. This is necessary since Subtype Description is not numeric and therefore cannot be part of the primary key.
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_SUBTYPE


Child Column in NMDP_SUBTYPE(FK) Parent Table Name Parent Column Name
Parents: NMDP_SUFFIX_ID NMDP_SUFFIX NMDP_SUFFIX_ID


NMDP_SUFFIX



Column Section Relationship Section Top of Page


Table-level Detail

Description: NMDP Suffix
Definition: Defines the NMDP Code used as the suffix to an HLA allele to designate a group of alleles.
Table Type: REFERENCE





Column Detail - NMDP_SUFFIX


Column Name Type Null? Definition
EXAMPLE_SUBTYPE VARCHAR(255) Y An example set of Alleles that could make up the NMDP Code.
GENERATED_IND DOUBLE Y Indicates whether the NMDP Code as been generated.
NMDP_SEQUENCE DOUBLE Y Defines the order the NMDP Codes.
NMDP_SUFFIX_DESC CHAR(10) Y The description assigned to the NMDP Code. Unique identifier the user gives the NMDP Code.
NMDP_SUFFIX_ID DOUBLE N A sequentially assigned number which uniquely identifies a NMDP Suffix record.
REMOVED_IND DOUBLE Y Indicates whether the NMDP Code as been removed.
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_SUFFIX




Parent Column in NMDP_SUFFIX (PK) Child Table Name Child Column Name
Children: NMDP_SUFFIX_ID NMDP_CODE NMDP_SUFFIX_ID
NMDP_SUBTYPE NMDP_SUFFIX_ID


ORDER_THERMOCYCLER_RACK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Thermocycler Rack
Definition: Associates a specific thermocycler rack to an order.
Table Type: ACTIVITY





Column Detail - ORDER_THERMOCYCLER_RACK


Column Name Type Null? Definition
GEL_BATCH_ID DOUBLE N Identifies the gel batch that this order is located on
ORDER_ID DOUBLE N Relates a thermocycler rack to a specific order for which is being used. It is a foreign key reference to the primary key of the orders table.
RACK_ID DOUBLE N Identifies the thermocycler rack being used for HLA molecular typing. It is a foreign key reference to the primary key of the thermocycler_rack 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 - ORDER_THERMOCYCLER_RACK


Child Column in ORDER_THERMOCYCLER_RACK(FK) Parent Table Name Parent Column Name
Parents: GEL_BATCH_ID GEL_BATCH GEL_BATCH_ID
ORDER_ID ORDERS ORDER_ID


PERSON_HLA_AB_SCN_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person HLA Antibody Screen Audit
Definition: Provides an audit trail of the Person HLA Antibody Screen table whenever a record is modified.
Table Type: ACTIVITY





Column Detail - PERSON_HLA_AB_SCN_AUDIT


Column Name Type Null? Definition
ANTIBODIES VARCHAR(200) Y A comma delimited string containing all of the antibody display values related to the codes from the person_hla_ab_spec table for to the order for which the audit trail was written. Done to save space by eliminating an audit child table.
ANTIBODY_DT_TM DATETIME Y Date and time that the original person_hla_ab_sceen record was created.
AUDIT_DT_TM DATETIME Y Date and time that the audit record was created.
B_CELL_PRA DOUBLE Y B-Cell percentage Panel Reactive Antibody.
CHARTED_IND DOUBLE Y Indicator to signify whether the row has been charted.
COMMENT_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record where Antibody Screen history audit trail comments are stored. It is a foreign key reference to the primary key of the long_text table.
COMPLETE_DT_TM DATETIME Y Date and time that the HLA antibody screen results were completed.
DILUTION_NOM_ID DOUBLE N Identifies the nomenclature entry for the dilution used in the Antibody Screen.
FLAG_IND DOUBLE Y Indicates that the Antibody Screen has been marked (flagged) as a special or unique specimen.
HLA_AB_SCN_AUDIT_ID DOUBLE N A sequentially assigned number which uniquely identifies an HLA Antibody Screen history audit record.
HLA_AB_SCREEN_ID DOUBLE N Relates this audit record to the current Antibody Screen History record. It is a foreign key reference to the primary key of the person_hla_ab_screen table.
METHODOLOGY_NOM_ID DOUBLE N Identifies the nomenclature entry for the methodology used in the Antibody Screen.
OD_RATIO_VALUE DOUBLE N Holds the od ratio value for antibody screen history.
OD_VALUE DOUBLE N Holds the od value for antibody screen history.
OUTSIDE_SCREEN_IND DOUBLE Y Indicates that the Antibody Screen was performed by an external laboratory.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSSIBLE_AB_STRING VARCHAR(255) Y Free-text string of possible antibodies entered for the order for which the audit trail was written.
PRSNL_ID DOUBLE N Identifies the user who updated the person_hla_ab_screen record which resulted in the creation of this audit record.
REACTION_NOM_ID DOUBLE N Identifies the nomenclature entry for the reaction of the Antibody Screen.
SPECIMEN_TYPE_CD DOUBLE N The code for the specimen type used for the antibody screen.
STORAGE_IND DOUBLE Y Indicates that a specimen related to the Antibody Screen is in storage. This field is only applicable to manually entered records or those uploaded from a contributor system.
T_CELL_PRA DOUBLE Y T-Cell percentage Panel Reactive Antibody.
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 - PERSON_HLA_AB_SCN_AUDIT


Child Column in PERSON_HLA_AB_SCN_AUDIT(FK) Parent Table Name Parent Column Name
Parents: COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
DILUTION_NOM_ID NOMENCLATURE NOMENCLATURE_ID
METHODOLOGY_NOM_ID NOMENCLATURE NOMENCLATURE_ID
REACTION_NOM_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID
HLA_AB_SCREEN_ID PERSON_HLA_AB_SCREEN HLA_AB_SCREEN_ID
PRSNL_ID PRSNL PERSON_ID


PERSON_HLA_AB_SCREEN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person HLA Antibody Screen
Definition: Defines a person's permanent HLA antibody screen history over time.
Table Type: ACTIVITY





Column Detail - PERSON_HLA_AB_SCREEN


Column Name Type Null? Definition
ACCESSION CHAR(20) Y An accession number identifies an order or a group of orders. Relates the Crossmatch History to the order from which it was derived. Not populated when history is manually entered.
ANTIBODY_DT_TM DATETIME Y Date and time that the record was created.
B_CELL_PRA DOUBLE Y B-Cell percentage Panel Reactive Antibody which was derived from Antibody Screen results or entered manually into history.
CHARTED_IND DOUBLE Y Indicates whether or not a manually entered HLA antibody screen results have been sent to the OCF Clinical Event tables for charting.
COMMENT_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record where Antibody Screen history comments are stored. It is a foreign key reference to the primary key of the long_text table. Either derived from Antibody Screen order comments or entered manually.
COMPLETE_DT_TM DATETIME Y Date and time that the HLA antibody screen results were completed.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DILUTION_NOM_ID DOUBLE N Identifies the nomenclature entry for the dilution used in the Antibody Screen. Either derived from Antibody Screen results or entered manually into history.
FLAG_IND DOUBLE Y Indicates that the Antibody Screen has been marked (flagged) as a special or unique specimen.
HLA_AB_SCREEN_ID DOUBLE N A sequentially assigned number which uniquely identifies an HLA Antibody Screen history record.
MAP_SEQ_NUMBER DOUBLE Y Reference to seq_number on the hla_ab_screen_history_map table. This records the mapping record used when creating the person_hla_ab_screen record.
METHODOLOGY_NOM_ID DOUBLE N Identifies the nomenclature entry for the methodology used in the Antibody Screen. Either derived from Antibody Screen results or entered manually into history.
OD_RATIO_VALUE DOUBLE N Holds the od ratio value for antibody screen history.
OD_VALUE DOUBLE N Holds the od value for antibody screen history.
ORDER_ID DOUBLE N Relates the Antibody Screen History to the order from which it was derived. Not populated when history is manually entered. It is a foreign key reference to the primary key of the orders table.
OUTSIDE_SCREEN_IND DOUBLE Y Indicates that the Antibody Screen was performed by an external laboratory.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSSIBLE_AB_STRING VARCHAR(255) Y Free-text sting of antibodies that might be contained in the specimen. For non-manual records this field is populated from the possible_antibodies table for the order when it is completed.
PRSNL_ID DOUBLE N Identifies the user who last updated the person_hla_ab_screen record or the person who performed the testing for history which is derived from Antibody Screen results.
REACTION_NOM_ID DOUBLE N Identifies the nomenclature entry for the reaction of the Antibody Screen. Either derived from Antibody Screen results or entered manually into history.
REMOVED_DT_TM DATETIME Y The date and time this record was removed from HLA history.
REMOVED_IND DOUBLE Y Indicates that the record has been removed from HLA history. Records are not deleted so that a complete audit trail can be kept.
SPECIMEN_TYPE_CD DOUBLE N The code for the specimen type used for the antibody screen.
STORAGE_IND DOUBLE Y Indicates that a specimen related to the Antibody Screen is in storage. This field is only applicable to manually entered records or those uploaded from a contributor system.
T_CELL_PRA DOUBLE Y T-Cell percentage Panel Reactive Antibody which was derived from Antibody Screen results or entered manually into history.
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 - PERSON_HLA_AB_SCREEN


Child Column in PERSON_HLA_AB_SCREEN(FK) Parent Table Name Parent Column Name
Parents: COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
DILUTION_NOM_ID NOMENCLATURE NOMENCLATURE_ID
METHODOLOGY_NOM_ID NOMENCLATURE NOMENCLATURE_ID
REACTION_NOM_ID NOMENCLATURE NOMENCLATURE_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID




Parent Column in PERSON_HLA_AB_SCREEN (PK) Child Table Name Child Column Name
Children: HLA_AB_SCREEN_ID HLA_SERA_QUERY_SERUM HLA_AB_SCREEN_ID
HLA_XM_TRAY_WELL HLA_AB_SCREEN_ID
HLA_XM_TRAY_WELL_SCORE HLA_AB_SCREEN_ID
PERSON_HLA_AB_SCN_AUDIT HLA_AB_SCREEN_ID
PERSON_HLA_AB_SPEC HLA_AB_SCREEN_ID