Table Detail Report

GEL_LOADING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Gel Loading
Definition: Identifies a specific molecular gel which is related to an order.
Table Type: ACTIVITY





Column Detail - GEL_LOADING


Column Name Type Null? Definition
GEL_BATCH_ID DOUBLE N Identifies which gel batch this gel is associated with. It is a foreign key reference to the primary key of the gel_batch table.
GEL_NUMBER DOUBLE N Identifies a gel which is related to an order. It is a foreign key reference to the primary key of the Gel table.
ORDER_ID DOUBLE N Relates the gel to a specific order. It is a foreign key reference to the primary key of the orders 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 - GEL_LOADING


Child Column in GEL_LOADING(FK) Parent Table Name Parent Column Name
Parents: GEL_NUMBER GEL GEL_NUMBER
GEL_BATCH_ID GEL_BATCH GEL_BATCH_ID
ORDER_ID ORDERS ORDER_ID




Parent Column in GEL_LOADING (PK) Child Table Name Child Column Name
Children: GEL_BATCH_ID ALLELE_PATTERN_MATCH GEL_BATCH_ID
GEL_NUMBER ALLELE_PATTERN_MATCH GEL_NUMBER
ORDER_ID ALLELE_PATTERN_MATCH ORDER_ID
GEL_BATCH_ID GEL_LOADING_POSN GEL_BATCH_ID
GEL_NUMBER GEL_LOADING_POSN GEL_NUMBER
ORDER_ID GEL_LOADING_POSN ORDER_ID
GEL_BATCH_ID SPEC_PTRN_MATCH GEL_BATCH_ID
GEL_NUMBER SPEC_PTRN_MATCH GEL_NUMBER
ORDER_ID SPEC_PTRN_MATCH ORDER_ID


GEL_LOADING_POSN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Gel Loading Position
Definition: Identifies the position a tube from an HLA molecular primer kit was placed on a specific gel for an order. Also records whether a positive reaction occured in this position.
Table Type: ACTIVITY





Column Detail - GEL_LOADING_POSN


Column Name Type Null? Definition
GEL_BATCH_ID DOUBLE N Identifies which gel batch this gel is associated with. It is a foreign key reference to the primary key of the gel_batch table.
GEL_NUMBER DOUBLE N Identifies the gel to which the placed aliquotted primer kit tube is related. It is a foreign key reference to the primary key of the orders table.
LOT_NUMBER_ID DOUBLE N Identifies the inventory lot of the aliquotted primer kit the tube which was placed came from. It is a foreign key reference to the primary key of the lot_number_info table.
ORDER_ID DOUBLE N Relates the placed aliquotted primer kit tube to an order. It is a foreign key reference to the primary key of the orders table.
POSITIVE_IND DOUBLE Y Indicates whether there was a positive reaction in the gel lane.
TUBE_NUMBER DOUBLE Y Number of the aliquotted primer kit tube which was placed on the gel at this position.
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_POS DOUBLE N Horizontal coordinate where the aliquotted primer kit tube was placed.
Y_POS DOUBLE N Vertical coordinate where the aliquotted primer kit tube was placed.



Relationship Detail - GEL_LOADING_POSN


Child Column in GEL_LOADING_POSN(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID ALIQUOTTED_PRIMER_KIT LOT_NUMBER_ID
GEL_BATCH_ID GEL_LOADING GEL_BATCH_ID
GEL_NUMBER GEL_LOADING GEL_NUMBER
ORDER_ID GEL_LOADING ORDER_ID
ORDER_ID ORDERS ORDER_ID


GEL_RESULT_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Gel Result Comment
Definition: Records the comments associated with a gel.
Table Type: ACTIVITY





Column Detail - GEL_RESULT_COMMENT


Column Name Type Null? Definition
GEL_BATCH_ID DOUBLE N Identifies which gel batch this gel is associated with. It is a foreign key reference to the primary key of the gel_batch table.
GEL_NUMBER DOUBLE N A number which identifies the gel to which the specificity result relates. It is a foreign key reference to the primary key of the gel table.
LONG_TEXT_ID DOUBLE N Relates the comment to a specific long_text record. It is a foreign key reference to the primary key of the long_text table.
ORDER_ID DOUBLE N Relates the comment to a specific order and gel. It is a foreign key reference to the primary key of the orders 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 - GEL_RESULT_COMMENT


Child Column in GEL_RESULT_COMMENT(FK) Parent Table Name Parent Column Name
Parents: GEL_NUMBER GEL GEL_NUMBER
GEL_BATCH_ID GEL_BATCH GEL_BATCH_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID


HAPLOTYPE_CHART



Column Section Relationship Section Top of Page


Table-level Detail

Description: Haplotype Chart
Definition: Records the haplotype of the potential recipient and comments about the haplotype chart as a whole.
Table Type: ACTIVITY





Column Detail - HAPLOTYPE_CHART


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
COMMENT_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record where haplotype chart comments are stored. It is a foreign key reference to the primary key of the long_text table.
HAPLOTYPE VARCHAR(255) Y Text string representing the Antigens which make up the first of a recipient's two haplotypes.
HAPLOTYPE2 VARCHAR(255) Y Text string representing the Antigens which make up the second of a recipient's two haplotypes.
HAPLOTYPE2_ASSIGNMENT_CD DOUBLE N Identifier for the second of a recipient's haplotypes. Used as an alias to the haplotype to more easily denote that persons have identical haplotypes.
HAPLOTYPE_ASSIGNMENT_CD DOUBLE N Identifier for the first of a recipient's haplotypes. Used as an alias to the haplotype to more easily denote that persons have identical haplotypes.
HAPLOTYPE_CHART_ID DOUBLE N This is the value of the unique primary identifier of the haplotype_chart table. It is an internal system assigned number.
MATERNAL_DEDUCED_IND DOUBLE Y No longer used.
PARENTAL_IND DOUBLE Y No longer used.
PATERNAL_DEDUCED_IND DOUBLE Y No longer used.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person 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 - HAPLOTYPE_CHART


Child Column in HAPLOTYPE_CHART(FK) Parent Table Name Parent Column Name
Parents: COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID




Parent Column in HAPLOTYPE_CHART (PK) Child Table Name Child Column Name
Children: HAPLOTYPE_CHART_ID HAPLOTYPE_DONOR HAPLOTYPE_CHART_ID
PHENOTYPE_LOCI HAPLOTYPE_CHART_ID


HAPLOTYPE_DONOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Haplotype Donor
Definition: Records the potential donors related to the potential recipient's haplotype chart, the haplotype of each of these donors and comments about each of these donors.
Table Type: ACTIVITY





Column Detail - HAPLOTYPE_DONOR


Column Name Type Null? Definition
COMMENT_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record where comments for a haplotype chart donor are stored. It is a foreign key reference to the primary key of the long_text table.
CREATED_DT_TM DATETIME Y The date and time this donor was added to the haplotype chart.
HAPLOTYPE VARCHAR(255) Y Text string representing the Antigens which make up the first of a donor's two haplotypes.
HAPLOTYPE2 VARCHAR(255) Y Text string representing the Antigens which make up the second of a donor's two haplotypes.
HAPLOTYPE2_ASSIGNMENT_CD DOUBLE N Identifier for the second of a donor's haplotypes. Used as an alias to the haplotype to more easily denote that persons have identical haplotypes.
HAPLOTYPE_ASSIGNMENT_CD DOUBLE N Identifier for the first of a donor's haplotypes. Used as an alias to the haplotype to more easily denote that persons have identical haplotypes.
HAPLOTYPE_CHART_ID DOUBLE N Relates this haplotype donor to a haplotype chart for a specific potential recipient. It is a foreign key reference to the primary key of the Haplotype Chart table.
HAPLOTYPE_DONOR_ID DOUBLE N This is the value of the unique primary identifier of the haplotype_donor table. It is an internal system assigned number.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REMOVED_DT_TM DATETIME Y The date and time this donor was removed from the haplotype chart. Haplotype_donor record are not deleted so that an audit trail can be kept.
REMOVED_IND DOUBLE Y Indicates that this donor was removed from the haplotype chart.
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 - HAPLOTYPE_DONOR


Child Column in HAPLOTYPE_DONOR(FK) Parent Table Name Parent Column Name
Parents: HAPLOTYPE_CHART_ID HAPLOTYPE_CHART HAPLOTYPE_CHART_ID
COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID