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 |