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 |