Table Detail Report

ORD_RQSTN_ORD_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Requisition Order Relation
Definition: Relates the request to a specific order.
Table Type: ACTIVITY





Column Detail - ORD_RQSTN_ORD_R


Column Name Type Null? Definition
ORDER_ID DOUBLE N Uniquely defines the order related to this request.
ORD_RQSTN_ID DOUBLE N Uniquely identifies the request related to this order.
ORD_RQSTN_ORD_R_ID DOUBLE N Uniquely identifies a relationship between an order and a request.
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 - ORD_RQSTN_ORD_R


Child Column in ORD_RQSTN_ORD_R(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
ORD_RQSTN_ID ORD_RQSTN ORD_RQSTN_ID


PCS_CHARGE_MOD_ABN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Common Services Charge Modification ABN
Definition: This table tracks charges which have met their charge points and their ABN status has been modified in PathNet.
Table Type: ACTIVITY





Column Detail - PCS_CHARGE_MOD_ABN


Column Name Type Null? Definition
AS_OF_DT_TM DATETIME N The date and time that the charges ABN status changed.
CHARGE_ITEM_ID DOUBLE N Unique identifier for the charge used to references the Charge table.
CHARGE_MOD_ABN_ID DOUBLE N This field is the unique identifier for the PCS_CHARGE_MOD_ABN.
CHARGE_STATUS_CD DOUBLE N The code for the status of the charge.
ORGANIZATION_ID DOUBLE N The encounters organization at the time the ABN was modified for this charge.
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_CHARGE_MOD_ABN


Child Column in PCS_CHARGE_MOD_ABN(FK) Parent Table Name Parent Column Name
Parents: CHARGE_ITEM_ID CHARGE CHARGE_ITEM_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PCS_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: PCS CRITERIA
Definition: Stores the criteria used for a specific Review Criteria for Clinical Validation.
Table Type: REFERENCE





Column Detail - PCS_CRITERIA


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.
AND_GROUPING_DISPLAY VARCHAR(25) N Pattern name for Microbiology pattern matching.
AND_GROUPING_NBR DOUBLE N Signifies that the relationship between two selected criteria is now an AND instead of the default OR
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.
CRITERIA_ID DOUBLE N Contains the internal identification code that uniquely identifies the criteria.
CRITERIA_TYPE_CD DOUBLE N Code value of selected criteria type (i.e. Service Resource, Result Flag, ¿). Code set 29161.
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.
PARENT_ENTITY_ID DOUBLE N id number of the selected criteria located on table .
PARENT_ENTITY_NAME VARCHAR(30) N Table name where selected criteria is stored. Valid names include:CODE_VALUE, PRSNL, ORDER_CATALOG, LOCATION, SERVICE_RESOURCE
REVIEW_CRITERIA_ID DOUBLE N Contains the foreign key to the pcs_review_criteria table.
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_CRITERIA


Child Column in PCS_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: REVIEW_CRITERIA_ID PCS_REVIEW_CRITERIA REVIEW_CRITERIA_ID




Parent Column in PCS_CRITERIA (PK) Child Table Name Child Column Name
Children: CRITERIA_ID PCS_QUALIFYING_CRITERIA CRITERIA_ID
PCS_SUB_CRITERIA CRITERIA_ID


PCS_DEMOGRAPHIC_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: PathNet Demographic Fields
Definition: Cerner defined reference data. Contains definitions for fields available in the customizable demographics display.
Table Type: REFERENCE





Column Detail - PCS_DEMOGRAPHIC_FIELD


Column Name Type Null? Definition
COLLATION_NAME VARCHAR(60) N Specifies the name used in a sorted list.
CURRENT_FIELD_CD DOUBLE N For historical fields, this specifies the corresponding current field. May be 0 if there is no corresponding current field. For current fields, this is always 0.The data model also allows for an "historic" field that does not have a corresponding current field. In this case, HISTORICAL_IND would be "1", but CURRENT_FIELD_CD would be "0".
DEFAULT_LABEL_TEXT VARCHAR(60) Y Default Label text field
FIELD_CD DOUBLE N The field this row corresponds to.
HISTORICAL_IND DOUBLE N two demographic fields that contain similar information, except the one represents the "current" value, and one represents the "historic" value. For example, one row in the table will be "Patient Name", and another row will be "Historical Patient Name". Logic requires that we do some special handling when this kind of relationship exists. We represent this by having the "Historical" row point to the "Current" row using the CURRENT_FIELD_CD. In this case the "HISTORICAL_IND will = 1.
PREVIEW_TEXT VARCHAR(200) Y Canned text to be displayed as data for this field when previewing layout.
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_DEMOGRAPHIC_FIELD


Child Column in PCS_DEMOGRAPHIC_FIELD(FK) Parent Table Name Parent Column Name
Parents: CURRENT_FIELD_CD CODE_VALUE CODE_VALUE
FIELD_CD CODE_VALUE CODE_VALUE


PCS_FILTER_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Selected filter items.
Definition: This table stores the specific filter items for a given personal filter.
Table Type: REFERENCE





Column Detail - PCS_FILTER_ITEM


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.
FILTER_DT_TM DATETIME Y Holds the date and time that is associated with a given filter.
FILTER_ID DOUBLE N Contains the internal identification code that uniquely identifies the personal filter. This field is used to join to other tables such as PCS_PRSNL_FILTER table.
FILTER_TYPE_CD DOUBLE N Defines the type of filter select (i.e. order catalog code, queue review status, etc.) Filter types are defined in code set 29244
FILTER_VALUE DOUBLE N Holds a double that is associated with the given filter.
PARENT_ENTITY_ID DOUBLE N id number of the selected criteria located on table .
PARENT_ENTITY_NAME VARCHAR(30) N Table name where selected criteria is stored. Valid names include:CODE_VALUE, ORDER_CATALOG
SELECTED_ITEM_ID DOUBLE N Contains the internal identification code that uniquely identifies a selected filter 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.



Relationship Detail - PCS_FILTER_ITEM


Child Column in PCS_FILTER_ITEM(FK) Parent Table Name Parent Column Name
Parents: FILTER_ID PCS_PRSNL_FILTER FILTER_ID