Table Detail Report
SPEC_PTRN_MATCH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Specificity Pattern Match |
Definition: | Records the specificities identified in HLA molecular gel testing as determined by pattern matching or as entered by the user for a specific order and gel. |
Table Type: | ACTIVITY |
Column Detail - SPEC_PTRN_MATCH
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. |
LOCI_CD | DOUBLE | N | The code for the HLA Loci where the specificity is located. |
LOCI_SEQ | DOUBLE | N | Arbitrarily assigned number to make each record unique. This is necessary since the same Loci Code and Specificity Code may be used more than once. Also determines the order of display. |
ORDER_ID | DOUBLE | N | Relates the specificity to a specific order. It is a foreign key reference to the primary key of the orders table. |
SPECIFICITY_CD | DOUBLE | N | The code for an specificity identified as a result of testing using an HLA molecular typing 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. |
Relationship Detail - SPEC_PTRN_MATCH
Child Column in SPEC_PTRN_MATCH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | GEL_BATCH_ID | GEL_LOADING | GEL_BATCH_ID |
GEL_NUMBER | GEL_LOADING | GEL_NUMBER | |
ORDER_ID | GEL_LOADING | ORDER_ID |
TEST_REVIEWER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Test Reviewer |
Definition: | Facilitates and records the review process for a specific order. All users or personnel groups that make up the review hierarchy are stored as separate records along with the status and other relevant information for each. |
Table Type: | ACTIVITY |
Column Detail - TEST_REVIEWER
Column Name | Type | Null? | Definition |
---|---|---|---|
ELECTRONIC_SIGNATURE_IND | DOUBLE | Y | Indicates that the reviewer's electronic signature should be attached to the chart for this order. NOT CURRENTLY IMPLEMENTED. |
NOTIFY_IND | DOUBLE | Y | Indicates that the reviewer should be notified via email when an item is added to their queue. |
ORDER_ID | DOUBLE | N | Relates the reviewer to a specific order. It is a foreign key reference to the primary key of the orders table. |
QUEUED_TO_PRSNL_GROUP_ID | DOUBLE | N | Identifies the personnel group which is responsible for the review. Either a group or an individual, not both, will have the review queued to them. |
QUEUED_TO_PRSNL_ID | DOUBLE | N | Identifies the user who is responsible for the review. Either a group or an individual, not both, will have the review queued to them. |
REVIEWED_BY_PRSNL_ID | DOUBLE | N | Identifies the user who actually performed the review. This may be the person who the review was queued to, a member of the personnel group, or an individual who was granted access to the queue by the queue owner. |
REVIEW_DT_TM | DATETIME | Y | Date and time the review was performed. |
REVIEW_GROUP_ID | DOUBLE | N | Identifies the review group to which this reviewer belongs. Review groups are used to determine what actions its members must take for the review to progress. It is a foreign key reference to the primary key of the res_review_group table. |
REVIEW_LEVEL_CD | DOUBLE | N | The code for the review level. Reviews may consist of multiple levels. All reviews at one level must be completed before reviews can be made at the subsequent level. The review process is complete when all reviews at the highest level are complete. |
REVIEW_SEQ | DOUBLE | N | Number assigned to make the record unique. This is necessary since a user can routed it to another individual and have it returned in the same level and group. It is also used to order the reviewers. |
REVIEW_STATUS_CD | DOUBLE | N | The code for the review status. Gives the current state the review is in for this reviewer. |
ROUTED_FROM_PRSNL_ID | DOUBLE | N | Identifies the user who routed the review to this reviewer. Will only be populated when a review is routed or is returned from a routing. |
ROUTE_RETURN_IND | DOUBLE | Y | Indicates that the review item should be returned to the original user if and when the user it was routed to approves it. |
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 - TEST_REVIEWER
Child Column in TEST_REVIEWER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
QUEUED_TO_PRSNL_ID | PRSNL | PERSON_ID | |
REVIEWED_BY_PRSNL_ID | PRSNL | PERSON_ID | |
ROUTED_FROM_PRSNL_ID | PRSNL | PERSON_ID | |
QUEUED_TO_PRSNL_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID | |
REVIEW_GROUP_ID | RES_REVIEW_GROUP | REVIEW_GROUP_ID |
THERMOCYCLER_RACK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Thermocycler Rack |
Definition: | Defines a unique name for a thermocycler rack and the type of the rack. |
Table Type: | REFERENCE |
Column Detail - THERMOCYCLER_RACK
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. |
RACK_DESC | VARCHAR(20) | Y | The description of the Thermocycler Rack. Unique identifier the user gives the rack. |
RACK_ID | DOUBLE | N | A sequentially assigned number which uniquely identifies a Thermocycler Rack record. |
RACK_TYPE_ID | DOUBLE | N | Identifies the rack type of the thermocycler rack. It is a foreign key reference to the primary key of the themocycler_rack_type 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 - THERMOCYCLER_RACK
Child Column in THERMOCYCLER_RACK(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RACK_TYPE_ID | THERMOCYCLER_RACK_TYPE | RACK_TYPE_ID |
Parent Column in THERMOCYCLER_RACK (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RACK_ID | GEL_BATCH | RACK_ID |
THERMOCYCLER_RACK_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Thermocycler Rack Type |
Definition: | Defines the dimensions for thermocycler racks of a particular type. |
Table Type: | REFERENCE |
Column Detail - THERMOCYCLER_RACK_TYPE
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. |
RACK_TYPE_DESC | VARCHAR(100) | Y | The description of the Thermocycler Rack Type. Unique identifier the user gives the rack type. |
RACK_TYPE_ID | DOUBLE | N | A sequentially assigned number which uniquely identifies a Thermocycler Rack Type record. |
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_ALPHA_IND | DOUBLE | Y | Indicates whether the horizontal coordinates of the Thermocycler Rack should be represented as characters. |
X_DIM | DOUBLE | Y | Horizontal dimension of the Thermocycler Rack. |
Y_ALPHA_IND | DOUBLE | Y | Indicates whether the vertical coordinates of the Thermocycler Rack should be represented as characters. |
Y_DIM | DOUBLE | Y | Vertical dimension of the Thermocycler Rack. |
Relationship Detail - THERMOCYCLER_RACK_TYPE
Parent Column in THERMOCYCLER_RACK_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RACK_TYPE_ID | THERMOCYCLER_RACK | RACK_TYPE_ID |
THERMO_RACK_PLACEMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Thermocycler Rack Placement |
Definition: | Specifies the placement of alliquotted HLA molecular primer kit tubes on a thermocycler rack for an order. |
Table Type: | ACTIVITY |
Column Detail - THERMO_RACK_PLACEMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
GEL_BATCH_ID | DOUBLE | N | Relates the placed aliquotted primer kit tube to a gel batch. It is a foreign key reference to the primary key of the gel_batch 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. |
RACK_ID | DOUBLE | N | Identifies the thermocycler rack which is being populated by aliquotted primer kit tubes. |
TUBE_NUMBER | DOUBLE | Y | Number of the aliquotted primer kit tube which was placed on the thermocycler rack 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 - THERMO_RACK_PLACEMENT
Child Column in THERMO_RACK_PLACEMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOT_NUMBER_ID | ALIQUOTTED_PRIMER_KIT | LOT_NUMBER_ID |