Table Detail Report
PCS_REVIEW_HISTORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores historical information for review items used in Clinical Validation. |
Definition: | Stores status changes for review items used in Clinical Validation. Maintaining status changes for review items will provide a historical representation of life cycle of a review item. |
Table Type: | ACTIVITY |
Column Detail - PCS_REVIEW_HISTORY
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_REVIEW_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies queue assignment item. This field is used to join to other tables such as PCS_QUEUE_ASSIGNMENT. |
REVIEW_HISTORY_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies a review history item. |
REVIEW_STATUS_CD | DOUBLE | N | Status in relation to a specific user (Approved, Routed, Pending, ...). Code set 29161. |
STATUS_DT_TM | DATETIME | N | Date and time the status was changed. |
STATUS_PRSNL_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the personnel initiating the status update. If a user is acting as a proxy, the prsnl_id will contain the original user id while this field will contain the proxy user id. |
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_HISTORY
Child Column in PCS_REVIEW_HISTORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | QUEUE_REVIEW_ID | PCS_QUEUE_ASSIGNMENT | QUEUE_REVIEW_ID |
PRSNL_ID | PRSNL | PERSON_ID | |
STATUS_PRSNL_ID | PRSNL | PERSON_ID |
PCS_REVIEW_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores review items for Clinical Validation. |
Definition: | Stores the review items that are assigned to queues used for Clinical Validation. A review item may be an order, a specific task assay or a Microbiology task. |
Table Type: | ACTIVITY |
Column Detail - PCS_REVIEW_ITEM
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. |
BB_COMPLETE_ORDER_IND | DOUBLE | N | Indicates whether the order status should be updated to complete when a blood bank order has reached final approval. This option is applicable to Blood Bank Antibody ID and Antigen ID orders that have the blood bank result entry preference set to prompt the user to determine if the order should be completed. Valid values are: 0 = Don't update order to complete on final approval, 1 = User answered yes to the complete order prompt. Update order to complete on final approval. |
BB_RH_PHENO_DEMOG_IND | DOUBLE | N | Indicates whether the person or product demographic Rh Phenotype should be changed. This option is applicable to Blood Bank Rh Phenotype Order when Result Entry prompt user whether to update demographic Rh Phenotype. Valid values are: 0 = Don't update demographic Rh Phenotype, 1 = Update demographic Rh Phenotype |
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 entire review was completed. |
CURRENT_USER_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies personnel. This field is used to indicate if the review item is currently being reviewed essentially locking it. |
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 internal identification code that uniquely identifies an order. This field is used to join to other tables such as ORDERS. |
MICRO_TASK_TYPE_CD | DOUBLE | N | This is for MICRO to indicate whether this is a preliminary, final, or amended report. |
ORDER_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies an order. This field is used to join to other tables such as ORDERS. |
PARENT_ENTITY_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the row on the table named in parent_entity_name field. This field is used to join to other tables such as DISCRETE_TASK_ASSAY. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Contains table name for parent_entity_id field. Valid table names include:RESULT, ORDER, MIC_TASK_LOG |
PENDING_DT_TM | DATETIME | Y | The date/time this row went into a pending status. |
REVIEW_CRITERIA_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies review criteria. This field is used to join to other tables such as PCS_REVIEW_CRITERIA. |
REVIEW_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies a review item. |
REVIEW_STATUS_CD | DOUBLE | N | This is the status of the review item. Code set 29161. |
ROUTE_PREF_FLAG | DOUBLE | Y | Route preference of the qualifying criteria at the time the review item qualified for review. Flag values are: 0 - Micro Task; 1 = Order Level Route; 2 = All Assay Level Route; 3 = Assay Level Route |
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_ITEM
Child Column in PCS_REVIEW_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
HIERARCHY_ID | PCS_HIERARCHY | HIERARCHY_ID | |
REVIEW_CRITERIA_ID | PCS_REVIEW_CRITERIA | REVIEW_CRITERIA_ID |
Parent Column in PCS_REVIEW_ITEM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | REVIEW_ID | PCS_QUALIFYING_CRITERIA | REVIEW_ID |
PCS_QUEUE_ASSIGNMENT | REVIEW_ID |
PCS_RSLT_FRMT_VRSN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PathNet Common Services Result Format Version |
Definition: | This table identifies a version of the presentation format of a result layout. |
Table Type: | REFERENCE |
Column Detail - PCS_RSLT_FRMT_VRSN
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. |
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. |
NO_RSLT_FOUND_IND | DOUBLE | Y | Indicates that additional text should be included if no result is found for the fill group event. |
NO_RSLT_FOUND_TEXT | VARCHAR(40) | Y | Defines the text to use when no result is found for the fill group event. |
PCS_RESULT_FORMAT_CD | DOUBLE | N | The unique identifier for the result layout format code. |
PCS_RSLT_FRMT_VRSN_ID | DOUBLE | N | Uniquely identifies a version of the presentation format of a result layout. |
PREV_PCS_RSLT_FRMT_VRSN_ID | DOUBLE | N | Used to track versions of the PCS result format version information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times. |
REVISION_DT_TM | DATETIME | N | The revision date and time for the result layout format. |
RSLT_FRMT_VRSN_DESC | VARCHAR(100) | N | Contains the description of the result format version. |
RSLT_LAYOUT_FOOTER_TEXT_ID | DOUBLE | N | Uniquely identifies the long text record containing the formatted text that defines the format footer. |
RSLT_LAYOUT_HEADER_TEXT_ID | DOUBLE | N | Uniquely identifies the long text row containing the formatted text that defines the format header. |
RSLT_SET_FOOTER_TEXT_ID | DOUBLE | N | Uniquely identifies the long text row containing the formatted text that that defines the result set footer. |
RSLT_SET_HEADER_TEXT_ID | DOUBLE | N | Uniquely identifies the long text row containing the formatted text that defines the result set header. |
RSLT_SET_ROW_TEXT_ID | DOUBLE | N | Uniquely identifies the long text row containing the formatted text that defines the result set row. |
TABLE_WIDTH_NBR | DOUBLE | N | Indicates the width required for the table. |
TEXT_RSLT_IND | DOUBLE | Y | Indicates that when a textual result is found for a fill gourp event replacement text should be included in the result cell. |
TEXT_RSLT_TEXT | VARCHAR(40) | Y | Defines the text to use in the result cell when a text result is found for a fill group event. |
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_RSLT_FRMT_VRSN
Parent Column in PCS_RSLT_FRMT_VRSN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PCS_RSLT_FRMT_VRSN_ID | PCS_FRMT_VRSN_ELEMENT | PCS_RSLT_FRMT_VRSN_ID |
PCS_RSLT_TMPLT_DFLT | PCS_RSLT_FRMT_VRSN_ID | ||
WP_TEMPLATE_TEXT | PCS_RSLT_FRMT_VRSN_ID |
PCS_RSLT_LAYOUT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PathNet Common Services Result Layout |
Definition: | This table identifies a result layout which contains a list of event codes, lookback scope and optional formatting for retrieving patient results. |
Table Type: | REFERENCE |
Column Detail - PCS_RSLT_LAYOUT
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. |
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. |
CUSTOM_SCRIPT_NAME | VARCHAR(100) | Y | This is used to save the custom script name which is entered from template. There can be different script for each different template. The custom script will be executed from pcs_get_grid_pat_rslts and the output will be displayed in a report. |
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. |
LOOKBACK_DAYS_NBR | DOUBLE | N | The number of days to look back when performing the result query. (Numeric value between 1 and 999) |
MAX_RESULTS_NBR | DOUBLE | N | The maximum number of result sets to return for each layout group. (Numeric value between 1 and 9) |
PCS_RSLT_LAYOUT_ID | DOUBLE | N | Uniquely identifies a result layout which contains a list of event codes, lookback scope, and optional formatting for retrieving patient results. |
PREV_PCS_RSLT_LAYOUT_ID | DOUBLE | N | Used to track versions of the PCS Result Layout information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times. |
RSLT_LAYOUT_DESC | VARCHAR(100) | N | The description of what the result layout contains. |
RSLT_LAYOUT_NAME | VARCHAR(100) | N | Contains the Name of the Result Layout. |
RSLT_LAYOUT_NAME_KEY | VARCHAR(100) | N | Contains the name of the result layout in all capitals and all special characters removed. |
SORT_ORDER_FLAG | DOUBLE | N | Defines how the result sets will be sorted within each layout group. 0 = Ascending; 1 = Descending |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - PCS_RSLT_LAYOUT
Parent Column in PCS_RSLT_LAYOUT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PCS_RSLT_LAYOUT_ID | PCS_LAYOUT_GROUP | PCS_RSLT_LAYOUT_ID |
PCS_RSLT_TMPLT_DFLT | PCS_RSLT_LAYOUT_ID | ||
WP_TEMPLATE_TEXT | PCS_RSLT_LAYOUT_ID |
PCS_RSLT_TMPLT_DFLT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PathNet Common Services Result Template Default |
Definition: | This table identifies defaults to be applied to word processing templates that include the result layout. |
Table Type: | REFERENCE |
Column Detail - PCS_RSLT_TMPLT_DFLT
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. |
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. |
NO_RESULTS_TEXT | VARCHAR(250) | N | Text defined to display if no results are found for the result layout. |
NO_RESULTS_TEXT_IND | DOUBLE | N | Indicates whether text has been defined to include if no results are found for the result layout. |
PCS_RSLT_FRMT_VRSN_ID | DOUBLE | N | Defines the default format version that will be applied to the result layout in the word processing template. |
PCS_RSLT_LAYOUT_ID | DOUBLE | N | Uniquely identifies the related result layout. |
PCS_RSLT_TMPLT_DFLT_ID | DOUBLE | N | Uniquely identifies the defaults to be applied to word processing templates that include the result layout. |
PREV_PCS_RSLT_TMPLT_DFLT_ID | DOUBLE | N | Used to track versions of the PCS Result Template Default information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times. |
TEXT_DISPLAY_ID | DOUBLE | N | Uniquely identifies the text to display for the result layout within the word processing template. |
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_RSLT_TMPLT_DFLT
Child Column in PCS_RSLT_TMPLT_DFLT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TEXT_DISPLAY_ID | LONG_TEXT | LONG_TEXT_ID |
PCS_RSLT_FRMT_VRSN_ID | PCS_RSLT_FRMT_VRSN | PCS_RSLT_FRMT_VRSN_ID | |
PCS_RSLT_LAYOUT_ID | PCS_RSLT_LAYOUT | PCS_RSLT_LAYOUT_ID |