Table Detail Report

DCP_PL_ENCNTR_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PL ENCNTR FILTER
Definition: Stores the information about encounter type and encounter class for patients in given patient list.
Table Type: ACTIVITY





Column Detail - DCP_PL_ENCNTR_FILTER


Column Name Type Null? Definition
ENCNTR_CLASS_CD DOUBLE N Encounter class defines how this encounter row is being used in relation to the person table.
ENCNTR_FILTER_ID DOUBLE N Unique identifier for encounter type filter.
ENCNTR_TYPE_CD DOUBLE N Encounter type code to be included within the patient list.
PATIENT_LIST_ID DOUBLE N Identifier of patient list filter is for.
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 - DCP_PL_ENCNTR_FILTER


Child Column in DCP_PL_ENCNTR_FILTER(FK) Parent Table Name Parent Column Name
Parents: PATIENT_LIST_ID DCP_PATIENT_LIST PATIENT_LIST_ID


DCP_PL_PRIORITIZATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PL PRIORITIZATION
Definition: Identifies priority of a patient in the context of a given patient list.
Table Type: ACTIVITY





Column Detail - DCP_PL_PRIORITIZATION


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N The encounter that will no longer be displayed on the PowerChart patient list.
PATIENT_LIST_ID DOUBLE N identifier of patient list.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRIORITY DOUBLE Y Patient priority.
PRIORITY_ID DOUBLE N unique identifier.
REMOVE_DT_TM DATETIME Y Date and time this encounter information was removed from the PowerChart patient list.
REMOVE_IND DOUBLE N Indicates removed encounter information on the PowerChart patient list. If remove ind is set to 1, encounter will no longer display on the powerchart patient list.
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 - DCP_PL_PRIORITIZATION


Child Column in DCP_PL_PRIORITIZATION(FK) Parent Table Name Parent Column Name
Parents: PATIENT_LIST_ID DCP_PATIENT_LIST PATIENT_LIST_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


DCP_PL_QUERY_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PL QUERY LIST
Definition: Stores the user¿s based query patient list with template id and execution status.
Table Type: ACTIVITY





Column Detail - DCP_PL_QUERY_LIST


Column Name Type Null? Definition
EXECUTION_DT_TM DATETIME Y The date & time of the last execution of the query.
EXECUTION_STATUS_CD DOUBLE N Identifies the status of the query whether it is executing, completed or has never been run.
PATIENT_LIST_ID DOUBLE N Unique identifier for the query based patient list.
TEMPLATE_ID DOUBLE N The id of the template that the query based patient list was built from.
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 - DCP_PL_QUERY_LIST


Child Column in DCP_PL_QUERY_LIST(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_ID DCP_PL_QUERY_TEMPLATE TEMPLATE_ID




Parent Column in DCP_PL_QUERY_LIST (PK) Child Table Name Child Column Name
Children: PATIENT_LIST_ID DCP_PL_QUERY_VALUE PATIENT_LIST_ID


DCP_PL_QUERY_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PL QUERY PARAMETER
Definition: Defines the parameters available for query types.
Table Type: REFERENCE





Column Detail - DCP_PL_QUERY_PARAMETER


Column Name Type Null? Definition
MULTIPLICITY_IND DOUBLE Y Indicates whether the parameter supports multiple values.
PARAMETER_DESC VARCHAR(255) N Textual description and instructions for the parameter.
PARAMETER_ID DOUBLE N Unique identifier for parameter
PARAMETER_NAME VARCHAR(50) N The name of the parameter
PARAMETER_SEQ DOUBLE N The sequence of the parameter for the specified query type.
PARAMETER_TYPE_CD DOUBLE N They type of parameter.
QUERY_TYPE_CD DOUBLE N They type of query that the parameter is defined for.
REQUIRED_IND DOUBLE Y Indicates whether the parameter requires a value to be specified.
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 - DCP_PL_QUERY_PARAMETER




Parent Column in DCP_PL_QUERY_PARAMETER (PK) Child Table Name Child Column Name
Children: PARAMETER_ID DCP_PL_QUERY_VALUE PARAMETER_ID


DCP_PL_QUERY_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Defines a template query that can be used to build a query based patient list.
Definition: Defines a template query that can be used by users to build a query based patient list.
Table Type: REFERENCE





Column Detail - DCP_PL_QUERY_TEMPLATE


Column Name Type Null? Definition
QUERY_TYPE_CD DOUBLE N The type of query this template is for.
TEMPLATE_ID DOUBLE N Unique identifier for the template.
TEMPLATE_NAME VARCHAR(50) N The name of the template.
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 - DCP_PL_QUERY_TEMPLATE




Parent Column in DCP_PL_QUERY_TEMPLATE (PK) Child Table Name Child Column Name
Children: TEMPLATE_ID DCP_PL_QUERY_LIST TEMPLATE_ID
DCP_PL_QUERY_TEMP_ACCESS TEMPLATE_ID
DCP_PL_QUERY_VALUE TEMPLATE_ID