Table Detail Report

CREG



Column Section Relationship Section Top of Page


Table-level Detail

Description: CREG - Cross Reactive Group
Definition: Defines the unique identifier of a cross reactive group (CREG).
Table Type: REFERENCE





Column Detail - CREG


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CREG_DESC CHAR(10) Y The description of the Cross Reactive Group (CREG). Unique identifier the user gives the CREG.
CREG_ID DOUBLE N This is the value of the unique primary identifier of the CREG table. It is an internal system assigned number.
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 - CREG




Parent Column in CREG (PK) Child Table Name Child Column Name
Children: CREG_ID CREG_SPECIFICITY CREG_ID
HLA_SCREEN_ANALYSIS_DETAIL CREG_ID


CREG_SPECIFICITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CREG Specificity
Definition: Defines the HLA specificities included in a particular cross reactive group (CREG).
Table Type: REFERENCE





Column Detail - CREG_SPECIFICITY


Column Name Type Null? Definition
CREG_ID DOUBLE N Relates the specificity to a specific Cross Reactive Group (CREG). It is a foreign key reference to the primary key of the CREG table.
CREG_SEQUENCE DOUBLE N Arbitrarily assigned number to make each record unique. This is necessary since HLA Type is not numeric and therefore cannot be part of the primary key.
HLA_TYPE VARCHAR(20) Y An HLA specificity contained within the CREG.
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 - CREG_SPECIFICITY


Child Column in CREG_SPECIFICITY(FK) Parent Table Name Parent Column Name
Parents: CREG_ID CREG CREG_ID


DONOR_SEARCH_LOCI_DEFAULT



Column Section Top of Page


Table-level Detail

Description: Donor Search Loci Default
Definition: Specifies the default loci for which HLA typings should be displayed when potential donors are listed in the Donor Search application.
Table Type: REFERENCE





Column Detail - DONOR_SEARCH_LOCI_DEFAULT


Column Name Type Null? Definition
LOCI_CD DOUBLE N The code for the HLA Loci which is a default for the Donor Search application.
LOCI_SEQ DOUBLE N Arbitrarily assigned number to make each record unique. This is necessary since the same Loci Code may be used more than once as a default. Also determines the order of display.
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.


GEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Gel
Definition: Identifies a molecular gel and its dimensions. The the gel may be related to one or more orders.
Table Type: ACTIVITY





Column Detail - GEL


Column Name Type Null? Definition
GEL_NUMBER DOUBLE N A sequentially assigned number which uniquely identifies a gel.
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_DIM DOUBLE Y Horizontal dimension of the HLA molecular typing gel.
Y_DIM DOUBLE Y Vertical dimension of the HLA molecular typing gel.



Relationship Detail - GEL




Parent Column in GEL (PK) Child Table Name Child Column Name
Children: GEL_NUMBER GEL_LOADING GEL_NUMBER
GEL_RESULT_COMMENT GEL_NUMBER


GEL_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Gel Batch
Definition: Used to store information about a batch process for gels
Table Type: ACTIVITY





Column Detail - GEL_BATCH


Column Name Type Null? Definition
GEL_BATCH_DESC VARCHAR(30) Y The description of the Gel Batch
GEL_BATCH_ID DOUBLE N Unique Identifier for the Gel Batch
GEL_BATCH_IND DOUBLE N Indicates whether or not this is a true batch (instead of a just a single gel).
PREPARED_DT_TM DATETIME N The Date the rack was prepared
PREPARED_PRSNL_ID DOUBLE N The user id of the person who created the batch.
RACK_ID DOUBLE N A foreign key reference to the rack used for the batch.
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 - GEL_BATCH


Child Column in GEL_BATCH(FK) Parent Table Name Parent Column Name
Parents: PREPARED_PRSNL_ID PRSNL PERSON_ID
RACK_ID THERMOCYCLER_RACK RACK_ID




Parent Column in GEL_BATCH (PK) Child Table Name Child Column Name
Children: GEL_BATCH_ID GEL_LOADING GEL_BATCH_ID
GEL_RESULT_COMMENT GEL_BATCH_ID
ORDER_THERMOCYCLER_RACK GEL_BATCH_ID