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