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 |