Table Detail Report

DCP_PL_QUERY_TEMP_ACCESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PL QUERY TEMP ACCESS
Definition: Defines which users or groups of users (User Group) have access to utilize a query template.
Table Type: REFERENCE





Column Detail - DCP_PL_QUERY_TEMP_ACCESS


Column Name Type Null? Definition
POSITION_CD DOUBLE N The position that is to be granted access to the specified template.
PROVIDER_GROUP_ID DOUBLE N The id of the provider group that is to be granted access to the specified template.
PROVIDER_ID DOUBLE N Provider IdentifierColumn
TEMPLATE_ACCESS_ID DOUBLE N Unique identifier for access definition.
TEMPLATE_ID DOUBLE N The id of the template that the specified user\position\or group is to be granted access to.
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_TEMP_ACCESS


Child Column in DCP_PL_QUERY_TEMP_ACCESS(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_ID DCP_PL_QUERY_TEMPLATE TEMPLATE_ID
PROVIDER_ID PRSNL PERSON_ID
PROVIDER_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


DCP_PL_QUERY_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PL QUERY VALUE
Definition: "Defines the value of parameters in created query based patient list."
Table Type: REFERENCE





Column Detail - DCP_PL_QUERY_VALUE


Column Name Type Null? Definition
PARAMETER_ID DOUBLE N Unique identifier for parameter
PARAMETER_SEQ DOUBLE N Sequence which identifies for which parameter the value is defined for.
PARENT_ENTITY_ID DOUBLE N Id of the parent entity.
PARENT_ENTITY_NAME VARCHAR(30) Y Name of the parent entity table
PATIENT_LIST_ID DOUBLE N Unique identifier of patient list.Column
QUERY_VALUE_ID DOUBLE N Unique identifier for value
TEMPLATE_ID DOUBLE N Identifier for query template for which this value is defined.
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.
VALUE_DT DATETIME Y The date value.
VALUE_NAME VARCHAR(25) N The name of the value.
VALUE_SEQ DOUBLE N Sequence of the value for those that have multiple values.
VALUE_STRING VARCHAR(100) Y The textual value.



Relationship Detail - DCP_PL_QUERY_VALUE


Child Column in DCP_PL_QUERY_VALUE(FK) Parent Table Name Parent Column Name
Parents: PATIENT_LIST_ID DCP_PL_QUERY_LIST PATIENT_LIST_ID
PARAMETER_ID DCP_PL_QUERY_PARAMETER PARAMETER_ID
TEMPLATE_ID DCP_PL_QUERY_TEMPLATE TEMPLATE_ID


DCP_PL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PL RELTN
Definition: Makes patient lists available to other related users with defined proxy access (MAINTAIN, OWNER,READ)..
Table Type: ACTIVITY





Column Detail - DCP_PL_RELTN


Column Name Type Null? Definition
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.
DCP_MP_PATIENT_LIST_ID DOUBLE N Identifies the list from the DCP_MP_PATIENT_LIST table that is being shared.
END_EFFECTIVE_DT_TM DATETIME N 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.
LIST_ACCESS_CD DOUBLE N Defines what level of access the user(s) will have for this patient list.
PATIENT_LIST_ID DOUBLE N The identifier of the patient list to be related.
PRSNL_GROUP_ID DOUBLE N The prsnl group id that is to be granted access to the patient list.
PRSNL_ID DOUBLE N The identifier of the user to be granted access to the list.
RELTN_ID DOUBLE N The unique identifier of the patient list relationship.
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_RELTN


Child Column in DCP_PL_RELTN(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
PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


DCP_PL_STATISTICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Holds statistics related to patient list response time to be used to troubleshoo
Definition: "Holds statistics related to patient list response time to be used to troubleshoot system problems.And also holds the Organization security and Confididential security information at the time of execution."
Table Type: ACTIVITY





Column Detail - DCP_PL_STATISTICS


Column Name Type Null? Definition
CONFID_IND DOUBLE N Indicates whether confidentiality security was active when the patient list was executed.
PATIENT_LIST_ID DOUBLE N The id of the patient list that was executed
PATIENT_LIST_TYPE VARCHAR(12) N The type of patient list that was executed.
QUAL DOUBLE N The number of patients that were qualified by the patient list
RESPONSE DOUBLE N The number of seconds spent identifying the patients that qualified for the patient list.
SECURITY_IND DOUBLE N Indicates whether organization security was active when the patient list was executed.
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_STATISTICS


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