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