DCP_MP_PATIENT_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP MP PATIENT LIST
Definition: Stores the lists created for Dynamic Worklist
Table Type: ACTIVITY





Column Detail - DCP_MP_PATIENT_LIST


Column Name Type Null? Definition
DCP_MP_PATIENT_LIST_ID DOUBLE N Unique generated number that identifies a single row on the table
DEFAULT_LIST_IND DOUBLE N Indicator for using Default List
DESCRIPTION VARCHAR(100) N description of the patient list. should include the type of list as well as description of the filters applied to the list.
NAME VARCHAR(50) N name of the patient list. should be relatively short to maintain a nice display within applications.
OWNER_PRSNL_ID DOUBLE N the id of the user that owns this list.
PATIENT_LIST_TYPE_CD DOUBLE N *** OBSOLETE ****
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_MP_PATIENT_LIST


Child Column in DCP_MP_PATIENT_LIST(FK) Parent Table Name Parent Column Name
Parents: OWNER_PRSNL_ID PRSNL PERSON_ID




Parent Column in DCP_MP_PATIENT_LIST (PK) Child Table Name Child Column Name
Children: DCP_MP_PATIENT_LIST_ID DCP_MP_PL_CUSTOM_ENTRY DCP_MP_PATIENT_LIST_ID
DCP_PL_ARGUMENT DCP_MP_PATIENT_LIST_ID
DCP_PL_RELTN DCP_MP_PATIENT_LIST_ID


DCP_MP_PL_CUSTOM_ENTRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP MPage Patient List Custom Entry
Definition: Stores the list of patients associated to a list for Dynamic Worklist
Table Type: ACTIVITY





Column Detail - DCP_MP_PL_CUSTOM_ENTRY


Column Name Type Null? Definition
DCP_MP_PATIENT_LIST_ID DOUBLE N Identification of the custom patient list the entry is for.
DCP_MP_PL_CUSTOM_ENTRY_ID DOUBLE N Unique generated number that identifies a single row on the DCP_MP_PL_CUSTOM_ENTRY table.
ENCNTR_ID DOUBLE N The encounter this entry in the custom list pertains to.
LAST_ACTION_DESC VARCHAR(100) Y Describes the last qualifying action relevant to the custom entry.
LAST_ACTION_DT_TM DATETIME Y Identifies the date/time of the last qualifying action relevant to the custom entry.
NEW_PATIENT_IND DOUBLE N *** OBSOLETE ****
PERSON_ID DOUBLE N The person that this entry in the custom list pertains to.
PERSON_PRIORITY_NBR DOUBLE Y Allows the user to assign a priority to the person_ids within a patient list.
PRSNL_GROUP_ID DOUBLE N The group that owns the list of patients. So either the list of patients belongs to the patient_list_id or the prsnl_group_id.
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_MP_PL_CUSTOM_ENTRY


Child Column in DCP_MP_PL_CUSTOM_ENTRY(FK) Parent Table Name Parent Column Name
Parents: DCP_MP_PATIENT_LIST_ID DCP_MP_PATIENT_LIST DCP_MP_PATIENT_LIST_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


DCP_PATIENT_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PATIENT LIST
Definition: Maintains the patient lists created by each user within PowerChart.
Table Type: ACTIVITY





Column Detail - DCP_PATIENT_LIST


Column Name Type Null? Definition
DESCRIPTION VARCHAR(100) Y Description of the patient list. Should include the type of list as well as description of the filters applied to the list.
NAME VARCHAR(50) N Name of the patient list. Should be relatively short to maintain a nice display within applications.
OWNER_PRSNL_ID DOUBLE N The id of the user that owns this list.
PATIENT_LIST_ID DOUBLE N Unique identifier of patient list.
PATIENT_LIST_TYPE_CD DOUBLE N Identifies the type of 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_PATIENT_LIST


Child Column in DCP_PATIENT_LIST(FK) Parent Table Name Parent Column Name
Parents: OWNER_PRSNL_ID PRSNL PERSON_ID




Parent Column in DCP_PATIENT_LIST (PK) Child Table Name Child Column Name
Children: PATIENT_LIST_ID BH_GROUP_DOC PATIENT_LIST_ID
DCP_PL_ARGUMENT PATIENT_LIST_ID
DCP_PL_CUSTOM_ENTRY PATIENT_LIST_ID
DCP_PL_ENCNTR_FILTER PATIENT_LIST_ID
DCP_PL_PRIORITIZATION PATIENT_LIST_ID
DCP_PL_RELTN PATIENT_LIST_ID
DCP_PL_STATISTICS PATIENT_LIST_ID


DCP_PL_ARGUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PL ARGUMENT
Definition: Defines the arguments for each patient list with the name of argument and value of argument defined during creation of patient list
Table Type: ACTIVITY





Column Detail - DCP_PL_ARGUMENT


Column Name Type Null? Definition
ARGUMENT_ID DOUBLE N Unique identifier for argument.
ARGUMENT_NAME VARCHAR(50) Y Name of argument
ARGUMENT_VALUE VARCHAR(255) Y Value of argument
DCP_MP_PATIENT_LIST_ID DOUBLE N Identifier of alternate patient list argument defines.
PARENT_ENTITY_ID DOUBLE N Referenced ID value.
PARENT_ENTITY_NAME VARCHAR(100) Y Name of parent entity identified within the PARENT_ENTITY_ID field.
PATIENT_LIST_ID DOUBLE N Identifier of patient list argument defines.
SEQUENCE DOUBLE Y Argument Sequence.
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_ARGUMENT


Child Column in DCP_PL_ARGUMENT(FK) Parent Table Name Parent Column Name
Parents: DCP_MP_PATIENT_LIST_ID DCP_MP_PATIENT_LIST DCP_MP_PATIENT_LIST_ID
PATIENT_LIST_ID DCP_PATIENT_LIST PATIENT_LIST_ID


DCP_PL_CUSTOM_ENTRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PL CUSTOM ENTRY
Definition: Stores the information of patient encounter for each custom patient list created within PowerChart.
Table Type: ACTIVITY





Column Detail - DCP_PL_CUSTOM_ENTRY


Column Name Type Null? Definition
CUSTOM_ENTRY_ID DOUBLE N Unique identifier for custom patient list entry.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
PATIENT_LIST_ID DOUBLE N Identification of custom patient list entry is for.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRSNL_GROUP_ID DOUBLE N This is the value of the unique primary identifier of the personnel group table. It is an internal system assigned number.
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_CUSTOM_ENTRY


Child Column in DCP_PL_CUSTOM_ENTRY(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
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID