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 |