Table Detail Report

PCS_FRMT_VRSN_ELEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Format Version Element
Definition: This table identifies elements that are embedded in a result layout format.
Table Type: REFERENCE





Column Detail - PCS_FRMT_VRSN_ELEMENT


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.
ELEMENT_CD DOUBLE N Uniquely identifies the element code embedded in the result layout format.
ELEMENT_SEARCH_TEXT VARCHAR(100) N Provides the ability to match the element in the result layout format.
ELEMENT_SEQUENCE_NBR DOUBLE N The unique sequential identifier of the element within the element list.
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.
PCS_FRMT_VRSN_ELEMENT_ID DOUBLE N Uniquely identifies elements that are embedded in a result layout format.
PCS_RSLT_FRMT_VRSN_ID DOUBLE N Uniquely identifies the version of the result layout format related to this element.
PREV_PCS_FRMT_VRSN_ELEMENT_ID DOUBLE N Used to track versions of the PCS Format Version Element 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.
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_FRMT_VRSN_ELEMENT


Child Column in PCS_FRMT_VRSN_ELEMENT(FK) Parent Table Name Parent Column Name
Parents: PCS_RSLT_FRMT_VRSN_ID PCS_RSLT_FRMT_VRSN PCS_RSLT_FRMT_VRSN_ID


PCS_HIERARCHY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the hierarchies used for Clinical Validation.
Definition: Stores the hierarchies used for Clinical Validation. A hierarchy consists of assigned queues in a specific order (referred to as levels). Clinical results are routed to a hierarchy. Once in approved in the first queue, they are sent to each subsequent queue until fully approved.
Table Type: REFERENCE





Column Detail - PCS_HIERARCHY


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.
HIERARCHY_ID DOUBLE N Contains the internal identification code that uniquely identifies the hierarchy.
HIERARCHY_NAME VARCHAR(100) N Stores the display name of the hierarchy.
HIERARCHY_NAME_KEY VARCHAR(100) N Stores the key of the hierarchy display name.
HIERARCHY_NAME_KEY_A_NLS VARCHAR(400) Y HIERARCHY_NAME_KEY_A_NLS column
HIERARCHY_NAME_KEY_NLS VARCHAR(202) Y Stores the key of the hierarchy display name.
PRODUCT_TYPE_CD DOUBLE N Product (i.e. General Laboratory, Microbiology, ¿) associated with this hierarchy. 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_HIERARCHY




Parent Column in PCS_HIERARCHY (PK) Child Table Name Child Column Name
Children: HIERARCHY_ID PCS_HIERARCHY_QUEUE_RELTN HIERARCHY_ID
PCS_REVIEW_CRITERIA HIERARCHY_ID
PCS_REVIEW_ITEM HIERARCHY_ID


PCS_HIERARCHY_QUEUE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PCS HIERARCHY QUEUE RELTN
Definition: Relationship table between the pcs_hierarchy and pcs_queue table
Table Type: REFERENCE





Column Detail - PCS_HIERARCHY_QUEUE_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.
HIERARCHY_ID DOUBLE N Contains the internal identification code that uniquely identifies the hierarchy. This field is used to join to other tables such as PCS_HIERARCHY
HIERARCHY_QUEUE_RELTN_ID DOUBLE N Contains the internal identification code that uniquely identifies the hierarchy / queue relation.
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
REVIEW_LEVEL_SEQ DOUBLE N The level or sequence within the hierarchy that the hierarchy / queue relationship is located.
REVIEW_TYPE_CD DOUBLE N Code set 28960. Denotes the review type (All, Read or One).
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_HIERARCHY_QUEUE_RELTN


Child Column in PCS_HIERARCHY_QUEUE_RELTN(FK) Parent Table Name Parent Column Name
Parents: HIERARCHY_ID PCS_HIERARCHY HIERARCHY_ID
QUEUE_ID PCS_QUEUE QUEUE_ID


PCS_KIT_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Kit Definition
Definition: This table stores the static definition information for a PathNet kit.
Table Type: ACTIVITY





Column Detail - PCS_KIT_DEFINITION


Column Name Type Null? Definition
ACTIVITY_TYPE_CD DOUBLE N This field allows the kit definitions to be grouped and filtered by the type of activity the kit will be used for (i.e. Microbiology, Blood Bank, etc.)
AVAILABLE_IND DOUBLE N This field indicates when a kit definition is ready to be put into use for patient results.
COMMENT_TEXT_ID DOUBLE N This field contains the unique identifier of the LONG_TEXT row that contains the kit definition comment text.
CROSS_COMPONENT_LOT_IND DOUBLE N This field indicates whether or not a component lot of the kit can be used outside of the kit.
KIT_DEFINITION_ID DOUBLE N This field contains the unique value that identifies a kit definition.
KIT_DEFINITION_NAME CHAR(40) N This field contains the user-defined name for the kit definition.
MANUFACTURER_CD DOUBLE N This field contains the unique identifier of the manufacturer associated with the kit definition.
SERVICE_RESOURCE_CD DOUBLE N This field contains the unique identifier of the service resource associated with the kit definition.
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_KIT_DEFINITION




Parent Column in PCS_KIT_DEFINITION (PK) Child Table Name Child Column Name
Children: KIT_DEFINITION_ID PCS_KIT_INFORMATION KIT_DEFINITION_ID
PCS_LOT_DEFINITION KIT_DEFINITION_ID


PCS_KIT_INFORMATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Kit Information
Definition: This table stores the individual kit information for all kits received into inventory.
Table Type: ACTIVITY





Column Detail - PCS_KIT_INFORMATION


Column Name Type Null? Definition
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.
COMMENT_TEXT_ID DOUBLE N This field contains the unique identifier of the LONG_TEXT row that contains the kit comment text.
END_EFFECTIVE_DT_TM DATETIME N 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.
EXPIRE_DT_TM DATETIME N This field contains the date/time that a kit is scheduled to expire.
KIT_DEFINITION_ID DOUBLE N This field contains the unique identifier of the associated PCS_KIT_DEFINITION row.
KIT_IDENT VARCHAR(40) N This field contains the user-defined kit "number" as defined by the supplier.
KIT_INFORMATION_ID DOUBLE N This field contains the unique identifier of the specific kit information.
KIT_SOURCE_ID DOUBLE N This field contains the unique identifier of the original PCS_KIT_INFORMATION row associated with the kit. This allows history to be tracked for a given kit.
RECEIVED_DT_TM DATETIME N This field contains the date/time that a kit is scheduled to expire.
RECEIVED_PERSONNEL_ID DOUBLE N This field contains the unique identifier of the personnel that received the kit.
RECEIVED_QTY_NBR DOUBLE N This field contains the number of items received in the associated kit.
STATUS_CD DOUBLE N This field contains the unique identifier of the status associated with the lot.
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_KIT_INFORMATION


Child Column in PCS_KIT_INFORMATION(FK) Parent Table Name Parent Column Name
Parents: KIT_DEFINITION_ID PCS_KIT_DEFINITION KIT_DEFINITION_ID




Parent Column in PCS_KIT_INFORMATION (PK) Child Table Name Child Column Name
Children: KIT_INFORMATION_ID PCS_LOT_INFORMATION KIT_INFORMATION_ID