Table Detail Report

PCS_LAYOUT_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Layout Group
Definition: This table identifies groups of events to be filled in sequence withing the result layout.
Table Type: REFERENCE





Column Detail - PCS_LAYOUT_GROUP


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.
FILL_ORDER_FLAG DOUBLE N Indicates the positioning of result events within the format that is applied to the result layout. 0 - Best Fit; 1 - Adjacent
GROUP_SEQUENCE_NBR DOUBLE N The sequence in which the result sets for the fill group is added to the result layout.
PCS_LAYOUT_GROUP_ID DOUBLE N Uniquely identifies a group of events to be filled in sequence within the result layout.
PCS_RSLT_LAYOUT_ID DOUBLE N Uniquely identifies the related result layout.
PREV_PCS_LAYOUT_GROUP_ID DOUBLE N Used to track versions of the PCS Layout Group 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.
SEPARATOR_IND DOUBLE Y Indicates whether a separator is needed between this fill group and the next in the formatting applied to the result layout.
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_LAYOUT_GROUP


Child Column in PCS_LAYOUT_GROUP(FK) Parent Table Name Parent Column Name
Parents: PCS_RSLT_LAYOUT_ID PCS_RSLT_LAYOUT PCS_RSLT_LAYOUT_ID




Parent Column in PCS_LAYOUT_GROUP (PK) Child Table Name Child Column Name
Children: PCS_LAYOUT_GROUP_ID PCS_LAYOUT_GROUP_EVENT PCS_LAYOUT_GROUP_ID


PCS_LAYOUT_GROUP_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Layout Group Event
Definition: This table identifies event codes contained within a fill gorup and the sequence they are filled within the result layout.
Table Type: REFERENCE





Column Detail - PCS_LAYOUT_GROUP_EVENT


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.
EVENT_CD DOUBLE N Uniquely identifies the event code to fill into the result layout.
EVENT_SEQUENCE_NBR DOUBLE N The sequence in which the event code will appear within a result set for the fill group it is in.
PCS_LAYOUT_GROUP_EVENT_ID DOUBLE N Uniquely identifies event codes contained within a fill group and the sequence they are filled within the result layout.
PCS_LAYOUT_GROUP_ID DOUBLE N Uniquely identifies the result layout fill group the event code is in.
PREV_PCS_LAYOUT_GROUP_EVENT_ID DOUBLE N Used to track versions of the PCS Layout Group Event 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_LAYOUT_GROUP_EVENT


Child Column in PCS_LAYOUT_GROUP_EVENT(FK) Parent Table Name Parent Column Name
Parents: PCS_LAYOUT_GROUP_ID PCS_LAYOUT_GROUP PCS_LAYOUT_GROUP_ID


PCS_LOT_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PCS_LOT_DEFINITION


Column Name Type Null? Definition
ACTIVITY_TYPE_CD DOUBLE N This field allows the lot definitions to be grouped and filtered by the type of activity the lot will be used for (i.e. Microbiology, Blood Bank, etc.
AVAILABLE_IND DOUBLE N This field indicates when a lot 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 lot definition comment text.
KIT_DEFINITION_ID DOUBLE N This field contains the unique identifier of the associated kit definition.
LOT_DEFINITION_ID DOUBLE N This field contains the unique value that identifies a lot definition
MANUFACTURER_CD DOUBLE N This field contains the unique identifier of the manufacturer associated with the lot definition.
PARENT_ENTITY_ID DOUBLE N This field contains the unique identifier for the component associated with the lot definition.
PARENT_ENTITY_NAME CHAR(30) N This field contains the name of the table that the parent_entity_id is associated with.
SERVICE_RESOURCE_CD DOUBLE N This field contains the unique identifier of the service resource associated with the lot 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_LOT_DEFINITION


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




Parent Column in PCS_LOT_DEFINITION (PK) Child Table Name Child Column Name
Children: LOT_DEFINITION_ID PCS_LOT_INFORMATION LOT_DEFINITION_ID


PCS_LOT_INFORMATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Lot Information
Definition: This table stores the individual lot information for all lots received into inventory.
Table Type: ACTIVITY





Column Detail - PCS_LOT_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 lot comment text.
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.
EXEMPT_IND DOUBLE N This field indicates whether a lot is exempt from QC testing.
EXPIRE_DT_TM DATETIME N This field contains the date and time that a lot is scheduled to expire.
KIT_INFORMATION_ID DOUBLE N This field contains the unique identifier of the associated PCS_KIT_INFORMATION row. This field will only be used if the lot was built as part of a kit.
LOT_DEFINITION_ID DOUBLE N This field contains the unique identifier of the associated PCS_LOT_DEFINITION row.
LOT_IDENT VARCHAR(40) N This field contains the user-defined lot "number" as defined by the supplier.
LOT_INFORMATION_ID DOUBLE N This field contains the unique identifier of the specific lot information.
LOT_SOURCE_ID DOUBLE N This field contains the unique identifier to the original PCS_LOT_INFORMATION row associated with the lot. This allows history to be tracked for a given lot.
RECEIVED_DT_TM DATETIME N This field contains the date/time the lot was received.
RECEIVED_PERSONNEL_ID DOUBLE N This field contains the unique identifier of the personnel that received the lot.
RECEIVED_QTY_NBR DOUBLE N This field contains the number of items received in the associated lot.
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_LOT_INFORMATION


Child Column in PCS_LOT_INFORMATION(FK) Parent Table Name Parent Column Name
Parents: KIT_INFORMATION_ID PCS_KIT_INFORMATION KIT_INFORMATION_ID
LOT_DEFINITION_ID PCS_LOT_DEFINITION LOT_DEFINITION_ID
RECEIVED_PERSONNEL_ID PRSNL PERSON_ID




Parent Column in PCS_LOT_INFORMATION (PK) Child Table Name Child Column Name
Children: LOT_INFORMATION_ID BB_QC_GRP_REAGENT_LOT LOT_INFORMATION_ID
MIC_BIOCHEMICAL_TEST_RESULT GROUP_LOT_INFORMATION_ID
MIC_BIOCHEMICAL_TEST_RESULT LOT_INFORMATION_ID
MIC_MEDIA_LOT_RELTN LOT_INFORMATION_ID
MIC_QC_RESULT ITEM_LOT_INFO_ID
MIC_QC_RESULT_SCHEDULE COMPNT_LOT_INFO_ID
MIC_SUS_MED_RESULT LOT_INFORMATION_ID
RESULT LOT_INFORMATION_ID


PCS_LOT_ITEM_CHECKLIST



Column Section Top of Page


Table-level Detail

Description: PathNet Common Services Lot Item Checklist
Definition: This table stores the checklist items for each individual lot.
Table Type: ACTIVITY





Column Detail - PCS_LOT_ITEM_CHECKLIST


Column Name Type Null? Definition
CHECKLIST_ITEM_CD DOUBLE N This field contains the unique identifier of the checklist item.
COMPLETE_IND DOUBLE N This field indicates whether or not the checklist item has been completed.
LOT_INFORMATION_ID DOUBLE N This filed contains the unique identifier of the PCS_LOT_INFORMATION row that the checklist item is associated with.
LOT_ITEM_CHECKLIST_ID DOUBLE N This field contains the unique identifier for the specific checklist item.
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.