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 |