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 |