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. |