Table Detail Report

PCS_ORDER_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Order Group
Definition: Stores a group identifier for linking patient orders.
Table Type: ACTIVITY





Column Detail - PCS_ORDER_GROUP


Column Name Type Null? Definition
ACCESSION_CLASS_CD DOUBLE N Uniquely identifies the accession class related to this row.
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.
CREATE_DT_TM DATETIME N The date/time this entry was created.
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.
GROUP_ACCESSION_ID DOUBLE N Uniquely identifies the accession number associated with the group identifier.
GROUP_NAME VARCHAR(40) N Contains the group name display value.
GROUP_NAME_KEY VARCHAR(40) N Uniquely identifies the name of a given group used for linking patient orders. The format is in uppercase with spaces and special characters removed.
GROUP_NAME_KEY_A_NLS VARCHAR(160) Y GROUP_NAME_KEY_A_NLS column
GROUP_NAME_KEY_NLS VARCHAR(82) N Stores the name of the group in corresponding non-English character set values.
GROUP_STATUS_CD DOUBLE N Uniquely identifies the status of the group identifier. For example: open, closed, etc.
PCS_ORDER_GROUP_ID DOUBLE N Uniquely identifies a group identifier for linking patient orders.
PREV_PCS_ORDER_GROUP_ID DOUBLE N Used to track version of the order group. 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.
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_ORDER_GROUP


Child Column in PCS_ORDER_GROUP(FK) Parent Table Name Parent Column Name
Parents: GROUP_ACCESSION_ID ACCESSION ACCESSION_ID




Parent Column in PCS_ORDER_GROUP (PK) Child Table Name Child Column Name
Children: PCS_ORDER_GROUP_ID PCS_ORDER_GROUP_R PCS_ORDER_GROUP_ID


PCS_ORDER_GROUP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Order Group Relationship
Definition: Stores the relationships between a group identifier for linking of patient orders and the associated orders.
Table Type: ACTIVITY





Column Detail - PCS_ORDER_GROUP_R


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.
ORDER_ID DOUBLE N Uniquely identifies the order related to this row.
PCS_ORDER_GROUP_ID DOUBLE N Relates this row to a specific group identifier created for linking of patient orders.
PCS_ORDER_GROUP_R_ID DOUBLE N Uniquely identifies a relationship between a group identifier for linking patient orders and associated orders.
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_ORDER_GROUP_R


Child Column in PCS_ORDER_GROUP_R(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PCS_ORDER_GROUP_ID PCS_ORDER_GROUP PCS_ORDER_GROUP_ID


PCS_PRSNL_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personal Filters for PathNet applications
Definition: Different applications within PathNet may use filters. For example, users of the Review Queue application can filter on order catalog code and review status. These tables provide a common area to store personal filters.
Table Type: REFERENCE





Column Detail - PCS_PRSNL_FILTER


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.
APPLICATION_TYPE_CD DOUBLE N Stores which application this filter pertains to.
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.
FILTER_ID DOUBLE N Contains the internal identification code that uniquely identifies a personal filter.
FILTER_NAME VARCHAR(40) N Contains the name of the filter.
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.
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_PRSNL_FILTER


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




Parent Column in PCS_PRSNL_FILTER (PK) Child Table Name Child Column Name
Children: FILTER_ID PCS_FILTER_ITEM FILTER_ID


PCS_QC_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Quality Control Filter
Definition: This table contains the filter templates for PathNet Common Services
Table Type: REFERENCE





Column Detail - PCS_QC_FILTER


Column Name Type Null? Definition
DISPLAY_SEQ_NBR DOUBLE N The order in which the filters were added to this template or filter set.
FILTER_CD DOUBLE N This is the filter the user has chosen to associate with this filter set number.
FILTER_ID DOUBLE N ID which makes each PCS_QC_FILTER row unique.
FILTER_SET_NBR DOUBLE N This is the filter set number for the chosen template this row is associated with.
TEMPLATE_CD DOUBLE N This references back to the code value table to determine which template this row is associated with.
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_QC_FILTER




Parent Column in PCS_QC_FILTER (PK) Child Table Name Child Column Name
Children: FILTER_ID PCS_QC_FILTER_DEFAULT FILTER_ID


PCS_QC_FILTER_DEFAULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Quality Control Filter Default
Definition: Contains PathNet Common Services QC Template Filter Defaults
Table Type: REFERENCE





Column Detail - PCS_QC_FILTER_DEFAULT


Column Name Type Null? Definition
FILTER_DEFAULT_ID DOUBLE N Identifier which makes each row in PCS_QC_FILTER_DEFAULT unique.
FILTER_DEFAULT_SEQ_NBR DOUBLE N Keeps each row on the table unique.
FILTER_ID DOUBLE N Provides a reference back to the row on the PCS_QC_FILTER table.
FILTER_NBR DOUBLE N Stores the numeric value for the filter selected. i.e. This value will be equal to the number of days when the "number of days prior to date" filter has been selected.
PARENT_ENTITY_ID DOUBLE N Sores the value for the filter selected. This value will hold either a control_id, code_value, lot_type or zero.
PARENT_ENTITY_NAME CHAR(30) N Name of the table that this row references.
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_QC_FILTER_DEFAULT


Child Column in PCS_QC_FILTER_DEFAULT(FK) Parent Table Name Parent Column Name
Parents: FILTER_ID PCS_QC_FILTER FILTER_ID