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 |