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 |