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 |