Table Detail Report

RES_REVIEW_HIERARCHY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Result Review Hierarchy
Definition: Defines a unique name for a review hierarchy. Review hierarchies are comprised of reviewers at one or more levels and in one or more groups which must approve results according to the rules of the hierarchy for the results to be released to charting.
Table Type: REFERENCE





Column Detail - RES_REVIEW_HIERARCHY


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_HIERARCHY_DESC VARCHAR(20) Y The description of the Review Hierarchy. Unique identifier the user gives the review hierarchy.
REVIEW_HIERARCHY_ID DOUBLE N A sequentially assigned number which uniquely identifies a Review Hierarchy 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.



Relationship Detail - RES_REVIEW_HIERARCHY




Parent Column in RES_REVIEW_HIERARCHY (PK) Child Table Name Child Column Name
Children: REVIEW_HIERARCHY_ID ORDER_CATALOG REVIEW_HIERARCHY_ID
RES_REVIEWER REVIEW_HIERARCHY_ID


REVIEW_QUEUE_ACCESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Review Queue Access
Definition: Defines other users that a specific user has granted review queue access to.
Table Type: REFERENCE





Column Detail - REVIEW_QUEUE_ACCESS


Column Name Type Null? Definition
GRANT_TO_PRSNL_ID DOUBLE N Identifies the user who has been granted access to another user's queue. It is a foreign key reference to the primary key of the personnel table.
PRSNL_ID DOUBLE N Identifies the user who is granting review queue access to another user. It also identifies the review queue for which the access is granted. It is a foreign key reference to the primary key of the personnel 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 - REVIEW_QUEUE_ACCESS


Child Column in REVIEW_QUEUE_ACCESS(FK) Parent Table Name Parent Column Name
Parents: GRANT_TO_PRSNL_ID PRSNL PERSON_ID
PRSNL_ID PRSNL PERSON_ID


REVIEW_QUEUE_FILTER_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Review Queue Filter Criteria
Definition: Defines a unique name for a specific user's review queue filter. Users can create review queue filter to limit the display in their review queue to specific review status and/or specific orderable procedures.
Table Type: REFERENCE





Column Detail - REVIEW_QUEUE_FILTER_CRITERIA


Column Name Type Null? Definition
FILTER_ID DOUBLE N A sequentially assigned number which uniquely identifies a Review Queue Filter record.
FILTER_NAME VARCHAR(20) Y The name of the Review Queue Filter. Unique identifier the user gives the filter.
PRSNL_ID DOUBLE N Identifies the users who created the filter. Only this user may use the filter.
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 - REVIEW_QUEUE_FILTER_CRITERIA


Child Column in REVIEW_QUEUE_FILTER_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID




Parent Column in REVIEW_QUEUE_FILTER_CRITERIA (PK) Child Table Name Child Column Name
Children: FILTER_ID REV_Q_FILT_CRIT_ORD_PROC FILTER_ID
PRSNL_ID REV_Q_FILT_CRIT_ORD_PROC PRSNL_ID
FILTER_ID REV_Q_FILT_CRIT_REV_STAT FILTER_ID
PRSNL_ID REV_Q_FILT_CRIT_REV_STAT PRSNL_ID


REV_Q_FILT_CRIT_ORD_PROC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Review Queue Filter Criteria Ordered Procedure
Definition: Defines the ordered procedure to be displayed in the Review Queue application when a specific review queue filter is applied. Filters are defined by user.
Table Type: REFERENCE





Column Detail - REV_Q_FILT_CRIT_ORD_PROC


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The code referencing the order catalog procedure which is part of a review queue filter. Only ordered procedures which match those in the filter will be displayed in the queue. It is a foreign key reference to the primary key of the order_catalog table.
FILTER_ID DOUBLE N Identifies the filter of which the order catalog procedure is a part. Persnl_id and filter_id are a foreign key reference to the primary key of the review_queue_filter_criteria table.
PRSNL_ID DOUBLE N Identifies the users who created the filter. Only this user may use the filter. Persnl_id and filter_id are a foreign key reference to the primary key of the review_queue_filter_criteria 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 - REV_Q_FILT_CRIT_ORD_PROC


Child Column in REV_Q_FILT_CRIT_ORD_PROC(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
FILTER_ID REVIEW_QUEUE_FILTER_CRITERIA FILTER_ID
PRSNL_ID REVIEW_QUEUE_FILTER_CRITERIA PRSNL_ID


REV_Q_FILT_CRIT_REV_STAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Review Queue Filter Criteria Review Status
Definition: Defines the review statuses to be displayed in the Review Queue application when a specfic review queue filter is applied. Filters are defined by user.
Table Type: REFERENCE





Column Detail - REV_Q_FILT_CRIT_REV_STAT


Column Name Type Null? Definition
FILTER_ID DOUBLE N Identifies the filter of which the review status is a part. Persnl_id and filter_id are a foreign key reference to the primary key of the review_queue_filter_criteria table.
PRSNL_ID DOUBLE N Identifies the users who created the filter. Only this user may use the filter. Persnl_id and filter_id are a foreign key reference to the primary key of the review_queue_filter_criteria table.
REVIEW_STATUS_CD DOUBLE N The code referencing the review status which is part of a review queue filter. Only queue entries with statuses which match those in the filter will be displayed in the queue.
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 - REV_Q_FILT_CRIT_REV_STAT


Child Column in REV_Q_FILT_CRIT_REV_STAT(FK) Parent Table Name Parent Column Name
Parents: FILTER_ID REVIEW_QUEUE_FILTER_CRITERIA FILTER_ID
PRSNL_ID REVIEW_QUEUE_FILTER_CRITERIA PRSNL_ID