Table Detail Report
PCS_QUALIFYING_CRITERIA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table holds the information on why this item was marked for review. |
Definition: | Clinical Validation Qualifying Criteria |
Table Type: | ACTIVITY |
Column Detail - PCS_QUALIFYING_CRITERIA
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CRITERIA_ID | DOUBLE | N | Foreign key to the pcs_criteria table. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
QUALIFYING_CRITERIA_ID | DOUBLE | N | Primary key |
REVIEW_ID | DOUBLE | N | Foreign key to the pcs_review_item table. |
SUB_CRITERIA_ID | DOUBLE | N | Foreign key to the pcs_sub_ 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 - PCS_QUALIFYING_CRITERIA
Child Column in PCS_QUALIFYING_CRITERIA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CRITERIA_ID | PCS_CRITERIA | CRITERIA_ID |
REVIEW_ID | PCS_REVIEW_ITEM | REVIEW_ID | |
SUB_CRITERIA_ID | PCS_SUB_CRITERIA | SUB_CRITERIA_ID |
PCS_QUEUE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores the queues used for Clinical Validation. |
Definition: | Stores the queues used for Clinical Validation. A queue consists of a group of individuals. Clinical results are routed to a queue and then validated by the assigned individuals. |
Table Type: | REFERENCE |
Column Detail - PCS_QUEUE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
QUEUE_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the queue. |
QUEUE_NAME | VARCHAR(100) | N | Stores the display name of the queue. |
QUEUE_NAME_KEY | VARCHAR(100) | N | Stores the key of the queue display name. |
QUEUE_NAME_KEY_A_NLS | VARCHAR(400) | Y | QUEUE_NAME_KEY_A_NLS column |
QUEUE_NAME_KEY_NLS | VARCHAR(202) | Y | Stores the key of the queue display name. |
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 - PCS_QUEUE
Parent Column in PCS_QUEUE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | QUEUE_ID | PCS_HIERARCHY_QUEUE_RELTN | QUEUE_ID |
PCS_QUEUE_ASSIGNMENT | QUEUE_ID | ||
PCS_QUEUE_PRSNL_RELTN | QUEUE_ID |
PCS_QUEUE_ASSIGNMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores the assignment of review items to queues for Clinical Validation. |
Definition: | Stores the assignment of review items to queues used for Clinical Validation. A review item can be assigned to multiple queues. Review items will be reviewed by individuals assigned to the corresponding queue. |
Table Type: | ACTIVITY |
Column Detail - PCS_QUEUE_ASSIGNMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
COMPLETED_DT_TM | DATETIME | Y | Contains date the assignment was completed. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
FROM_PRSNL_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the personnel. Provides tracking to whom forwarded this assignment. This field is used to join to other tables such as PRSNL. |
FROM_QUEUE_REVIEW_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the assignment of queue and review item. Provides tracking from which assignment the current assignment was forwarded. This field is used to join to other tables such as PCS_QUEUE_ASSIGNMENT. |
ORDER_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the review hierarchy. This field is used to join to other tables such as PCS_HIERARCHY. |
PENDING_DT_TM | DATETIME | N | Contains date the assignment was initiated. |
QUEUE_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the queue. This field is used to join to other tables such as PCS_QUEUE. |
QUEUE_REVIEW_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the assignment of queue and review item. |
RETURN_TO_SENDER_IND | DOUBLE | Y | Indicates if assignment should be forwarded back to the sender indicated in from_queue_review_id and from_prsnl_id upon approval. |
REVIEW_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies a review item. This field is used to join to other tables such as PCS_REVIEW_ITEM. |
REVIEW_LEVEL_SEQ | DOUBLE | N | The level or sequence within the assignment that the review item / queue relationship is located. |
REVIEW_STATUS_CD | DOUBLE | N | The current status of a single review item in this queue. Code set 29161 |
REVIEW_TYPE_CD | DOUBLE | N | This is the type of review: ALL, ONE, FYI. Code set 28961. |
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 - PCS_QUEUE_ASSIGNMENT
Child Column in PCS_QUEUE_ASSIGNMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
QUEUE_ID | PCS_QUEUE | QUEUE_ID | |
FROM_QUEUE_REVIEW_ID | PCS_QUEUE_ASSIGNMENT | QUEUE_REVIEW_ID | |
REVIEW_ID | PCS_REVIEW_ITEM | REVIEW_ID | |
FROM_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in PCS_QUEUE_ASSIGNMENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | QUEUE_REVIEW_ID | PCS_QUEUE_ASSIGNMENT | FROM_QUEUE_REVIEW_ID |
PCS_REVIEW_HISTORY | QUEUE_REVIEW_ID |
PCS_QUEUE_PRSNL_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PCS QUEUE PRSNL RELTN |
Definition: | Stores the personnel who are assigned to specific queues. |
Table Type: | REFERENCE |
Column Detail - PCS_QUEUE_PRSNL_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PRSNL_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the personnel. This field is used to join to other tables such as PRSNL. |
QUEUE_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the queue. This field is used to join to other tables such as PCS_QUEUE. |
QUEUE_PRSNL_RELTN_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the queue / prsnl relation. |
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 - PCS_QUEUE_PRSNL_RELTN
Child Column in PCS_QUEUE_PRSNL_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | QUEUE_ID | PCS_QUEUE | QUEUE_ID |
PRSNL_ID | PRSNL | PERSON_ID |
PCS_REVIEW_CRITERIA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PCS REVIEW CRITERIA |
Definition: | Stores the review criteria for clinical validation. |
Table Type: | REFERENCE |
Column Detail - PCS_REVIEW_CRITERIA
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CORR_PREF_FLAG | DOUBLE | Y | Indicates the corrections preference of this review item. Values are: 0 - Apply to verified, 1 = Apply to corrected, 2 = Apply to both. |
CRITERIA_NAME | VARCHAR(100) | N | Contains the display name of the review criteria |
CRITERIA_NAME_KEY | VARCHAR(100) | N | Display key of the review criteria display name. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
HIERARCHY_ID | DOUBLE | N | Contains the foreign key to the pcs_hierarchy table. Defines where the result is sent upon qualifying |
HOLIDAY_SCHEDULE_CD | DOUBLE | N | The schedule associated with this instrument for autoverification and clinical validatin. |
PRECEDENCE_NBR | DOUBLE | N | Within each PathNet product, there is a specific order or precedence that the review criteria must be checked. It will be up to the clients to build the criteria from most restrictive to least restrictive. For example, if a result is 'Abnormal', it will be sent to Dr. Ruth Strong for review unless it came from 'Instrument A', 'Bench B' - in which case, the first review criteria would qualify and send the result to the Chemistry Hierarchy |
PRODUCT_TYPE_CD | DOUBLE | N | Code value of product associated with this criteria (Gen Lab, Micro, ...). Code set 28961. |
RESULT_POST_PREF_FLAG | DOUBLE | Y | Indicates the result posting personnel preferences of this review item. When a review item is approved this flag will determine whether the verifying personnel will be used to post the verified/corrected results. |
REVIEW_CRITERIA_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the review criteria. |
ROUTE_PREF_FLAG | DOUBLE | Y | Flag value to indicate the route preference of this review item. Flag values are: 0 - Micro Task 1 = Order Level Route2 = All Assay Level Route3 = Assay Level Route |
SCHEDULE_CD | DOUBLE | N | The schedule associated with this instrument for autoverification and clinical validation. |
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 - PCS_REVIEW_CRITERIA
Child Column in PCS_REVIEW_CRITERIA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HIERARCHY_ID | PCS_HIERARCHY | HIERARCHY_ID |
Parent Column in PCS_REVIEW_CRITERIA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | REVIEW_CRITERIA_ID | PCS_CRITERIA | REVIEW_CRITERIA_ID |
PCS_REVIEW_ITEM | REVIEW_CRITERIA_ID |