Table Detail Report

PRIMER_KIT_SPECIFICITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Primer Kit Specificity
Definition: Defines a specific allele and specificity for which an HLA molecular testing primer kit will be used to test for.
Table Type: REFERENCE





Column Detail - PRIMER_KIT_SPECIFICITY


Column Name Type Null? Definition
ALLELE_CD DOUBLE N The code for an allele which this Aliquotted Primer Kit tests for.
LOT_NUMBER_ID DOUBLE N Relates the Aliquotted Primer Kit allele to the inventory lot and related map. It is a foreign key reference to the primary key of the lot_number_info table.
SPECIFICITY_CD DOUBLE N The code for the specificity of the allele this Aliquotted Primer Kit tests for.
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 - PRIMER_KIT_SPECIFICITY


Child Column in PRIMER_KIT_SPECIFICITY(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID ALIQUOTTED_PRIMER_KIT LOT_NUMBER_ID




Parent Column in PRIMER_KIT_SPECIFICITY (PK) Child Table Name Child Column Name
Children: ALLELE_CD POSITIVE_TUBES ALLELE_CD
LOT_NUMBER_ID POSITIVE_TUBES LOT_NUMBER_ID


PROBE_INFORMATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Probe Information.
Definition: Additional information about an HLA molecular testing blot probe.
Table Type: REFERENCE





Column Detail - PROBE_INFORMATION


Column Name Type Null? Definition
LOT_NUMBER_ID DOUBLE N Relates the Blot probe information to the inventory lot and related map. It is a foreign key reference to the primary key of the lot_number_info table.
PROBE_DESC VARCHAR(255) Y Additional information about a specific probe in an molecular blot.
PROBE_NUMBER DOUBLE N Number of the molecular blot probe.
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 - PROBE_INFORMATION


Child Column in PROBE_INFORMATION(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID MOLECULAR_BLOT LOT_NUMBER_ID


RECIPIENT_SEARCH_LOCI_DEFAULT



Column Section Top of Page


Table-level Detail

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





Column Detail - RECIPIENT_SEARCH_LOCI_DEFAULT


Column Name Type Null? Definition
LOCI_CD DOUBLE N The code for the specific HLA Loci to display for recipient phenotypes as the defaults in the Recipient Search application.
LOCI_SEQ DOUBLE N Arbitrarily assigned number to make each record unique and to determine the order the loci are displayed for recipient phenotypes as the defaults in the Recipient Search application.
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.


RES_REVIEWER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Result Reviewer
Definition: Defines a specific user or personnel group which belongs to a certain level and group of a review hierarchy.
Table Type: REFERENCE





Column Detail - RES_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 orders reviewed using this hierarchy. NOT CURRENTLY IMPLEMENTED.
NOTIFY_IND DOUBLE Y Indicates that the reviewer should be notified via email when an item is added to their queue. NOT CURRENTLY IMPLEMENTED.
PRSNL_GROUP_ID DOUBLE N Identifies the personnel group which is responsible for the review. Either a group or an individual, not both, must be assigned as a reviewer.
PRSNL_ID DOUBLE N Identifies the user who is responsible for the review. Either a group or an individual, not both, must be assigned as a reviewer.
REVIEWER_ID DOUBLE N A sequentially assigned number which uniquely identifies a Reviewer record.
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_HIERARCHY_ID DOUBLE N Identifies the review hierarchy to which this reviewer belongs. It is a foreign key reference to the primary key of the res_review_hierarchy table.
REVIEW_LEVEL_CD DOUBLE N The code for the review level. Reviews can be built with 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.
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 - RES_REVIEWER


Child Column in RES_REVIEWER(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID
REVIEW_GROUP_ID RES_REVIEW_GROUP REVIEW_GROUP_ID
REVIEW_HIERARCHY_ID RES_REVIEW_HIERARCHY REVIEW_HIERARCHY_ID


RES_REVIEW_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Result Review Group
Definition: Defines a review group used in building review hierarchies. There are 3 types of review groups -- All, One and FYI -- which require all, one or no reviewers assigned to the group to approve the result before the review process can continue.
Table Type: REFERENCE





Column Detail - RES_REVIEW_GROUP


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.
REVIEW_GROUP_DESC VARCHAR(20) Y The description of the Review Group. Unique identifier the user gives the review group.
REVIEW_GROUP_ID DOUBLE N A sequentially assigned number which uniquely identifies a Review Group record.
REVIEW_TYPE_CD DOUBLE N The code for the type of review group. Valid types are All, One and FYI.
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 - RES_REVIEW_GROUP




Parent Column in RES_REVIEW_GROUP (PK) Child Table Name Child Column Name
Children: REVIEW_GROUP_ID RES_REVIEWER REVIEW_GROUP_ID
TEST_REVIEWER REVIEW_GROUP_ID