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 |