Table Detail Report
PCA_OUTCOME
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Power Chart Analytics Outcome |
Definition: | Defines Outcomes that may be related to Quality Measures. This table may serve as a dimension table for certain fact tables containing aggregations related to an Outcome. |
Table Type: | REFERENCE |
Column Detail - PCA_OUTCOME
Column Name | Type | Null? | Definition |
---|---|---|---|
CONTRAINDICATION_IND | DOUBLE | N | Indicates that this outcome represents a contraindication. This may be used in the denominator on performance calculations which allow contra-indicated records to be excluded from the general population. |
DESCRIPTION_TXT | VARCHAR(255) | Y | Comment which provides additional meaning or context to the Outcome. |
DISPLAY_TXT | VARCHAR(60) | Y | The textual displayed description for this Outcome. |
EXPECTATION_MET_IND | DOUBLE | N | Indicates that this outcome represents an expectation which has been met. This may be used in the numerator of performance calculations. |
OUTCOME_CD | DOUBLE | N | The CODE VALUE record which identifies the Outcome. |
PCA_OUTCOME_ID | DOUBLE | N | Unique, generated number that identifies a single row on the PCA_OUTCOME table. |
PCA_SOURCE_ID | DOUBLE | N | The source that supplied this Outcome. |
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 - PCA_OUTCOME
Child Column in PCA_OUTCOME(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PCA_SOURCE_ID | PCA_SOURCE | PCA_SOURCE_ID |
Parent Column in PCA_OUTCOME (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PCA_OUTCOME_ID | PCA_ENCNTR_MEASURE_OUTCOME | PCA_OUTCOME_ID |
PCA_MEASURE_OUTCOME_RELTN | PCA_OUTCOME_ID | ||
PCA_PERSON_MEASURE_OUTCOME | PCA_OUTCOME_ID |
PCA_PCP_STATS
Column Section | Top of Page |
Table-level Detail
Description: | Power Chart Analytics Primary Care Physician Statistics |
Definition: | Provides outcome measure statistics at the PCP/Group grain. |
Table Type: | ACTIVITY |
Column Detail - PCA_PCP_STATS
Column Name | Type | Null? | Definition |
---|---|---|---|
MEAS_CONTRAINDCT_CNT | DOUBLE | N | Count of those measures that were contraindicated for this PCP/Outcome. |
MEAS_EXPCTN_MET_CNT | DOUBLE | N | Count of the outcomes that were met for this PCP/Measure/Outcome. |
MEAS_EXPCTN_NOT_MET_CNT | DOUBLE | N | Count of the outcomes that were not met for this PCP/Measure/Outcome. |
MEAS_MEDCR_CONTRAINDCT_CNT | DOUBLE | N | Count of those outcomes that were contraindicated for this PCP/Measure/Outcome for persons identified as Medicare Part B. |
MEAS_MEDCR_EXPCTN_MET_CNT | DOUBLE | N | Count of those outcomes that were met for this PCP/Measure/Outcome for persons identified as Medicare Part B. |
MEAS_MEDCR_EXPCTN_NOT_MET_CNT | DOUBLE | N | Count of those outcomes that were not met for this PCP/Measure/Outcome for persons identified as Medicare Part B. |
MEAS_MEDCR_OUTCOME_CNT | DOUBLE | N | Count of the total number of outcomes for this PCP/Measure/Outcome for persons identified as Medicare Part B. |
MEAS_NAME | VARCHAR(60) | N | Textual display value of the quality measure. |
MEAS_OUTCOME_CNT | DOUBLE | N | Count of the total number of outcomes for this PCP/Measure/Outcome. |
MEAS_OUTCOME_NAME | VARCHAR(60) | N | Textual display value for the outcome. |
MEAS_PCP_GROUP_ID | DOUBLE | N | The identifier for the Primary Care Physician group. |
MEAS_PCP_GROUP_NAME | VARCHAR(60) | N | The textual display value for the name of the Primary Care Physician group. |
MEAS_PCP_ID | DOUBLE | N | The identifier for the Primary Care Physician. |
MEAS_PCP_NAME | VARCHAR(60) | N | Textual display value for the primary care provider. |
MEAS_PCP_NPI_TXT | VARCHAR(200) | N | NPI of the primary care provider. |
MEAS_PCP_ORG_NAME | VARCHAR(100) | N | Organization of the primary care provider. |
MEAS_PCP_TAXID_TXT | VARCHAR(200) | N | Tax ID of the primary care provider. |
PCA_PCP_STATS_ID | DOUBLE | N | Unique, generated number that identifies a single row on the PCA_PCP_STATS table. |
TOPIC_NAME | VARCHAR(60) | N | Textual display value of the quality topic. |
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. |
PCA_PERSON_MEASURE_OUTCOME
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PowerChart Analytics Person Measure Outcome |
Definition: | Contains a snapshot which provide information about persons being tracked as part of a Quality Topic, specifically the outcomes for various measures associated with the Topic. |
Table Type: | ACTIVITY |
Column Detail - PCA_PERSON_MEASURE_OUTCOME
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
MEASURE_PROCESS_FLAG | DOUBLE | N | Indicates that this record needs some type of processing to fill the PCA_OUTCOME_ID field. |
PCA_OUTCOME_ID | DOUBLE | N | The outcome of this quality measure for this person. |
PCA_PERSON_MEASURE_OUTCOME_ID | DOUBLE | N | Unique, generated number that identifies a single row on the PCA_PERSON_MEASURE_OUTCOME table. |
PCA_QUALITY_MEASURE_ID | DOUBLE | N | The Quality Measure being tracked for this person. |
PERSON_ID | DOUBLE | N | The unique identifier of the person being tracked as part of a Quality Topic. |
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 - PCA_PERSON_MEASURE_OUTCOME
Child Column in PCA_PERSON_MEASURE_OUTCOME(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PCA_OUTCOME_ID | PCA_OUTCOME | PCA_OUTCOME_ID |
PCA_QUALITY_MEASURE_ID | PCA_QUALITY_MEASURE | PCA_QUALITY_MEASURE_ID | |
PERSON_ID | PERSON | PERSON_ID |
PCA_PERSON_TOPIC_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PowerChart Analytics Person Topic Relation |
Definition: | Contains a snapshot which provides information about persons being tracked as part of a quality Topic. |
Table Type: | ACTIVITY |
Column Detail - PCA_PERSON_TOPIC_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
PCA_PERSON_TOPIC_RELTN_ID | DOUBLE | N | Unique, generated number that identifies a single row on the PCA_PERSON_TOPIC_RELTN table. |
PCA_QUALITY_TOPIC_ID | DOUBLE | N | The Quality Topic that is associated with this person. |
PERSON_ID | DOUBLE | N | The unique identifier for the person being tracked as part of this Quality Topic. |
PUBLISH_IND | DOUBLE | N | States whether the item in this record is viewable via "normal" applications. (e.g. on-line inquiries, etc.) Audit and/or administrative applications would be able to view non-publishable results. 1 means that all data has been processed and is available for viewing. |
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 - PCA_PERSON_TOPIC_RELTN
Child Column in PCA_PERSON_TOPIC_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PCA_QUALITY_TOPIC_ID | PCA_QUALITY_TOPIC | PCA_QUALITY_TOPIC_ID |
PERSON_ID | PERSON | PERSON_ID |
PCA_QUALITY_MEASURE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Power Chart Analytics Quality Measure |
Definition: | Details the procedures that have been determined as measurements of some Topic. This table may serve as a dimension table for certain fact tables containing aggregations related to this Quality Measure. |
Table Type: | REFERENCE |
Column Detail - PCA_QUALITY_MEASURE
Column Name | Type | Null? | Definition |
---|---|---|---|
CALC_SCRIPT_NAME | VARCHAR(40) | Y | The Discern Explorer program object which does the processing on the data that was qualified for this Quality Measure. |
DESCRIPTION_TXT | VARCHAR(255) | Y | Comment which provides additional meaning or context to the Quality Measure. |
DISPLAY_TXT | VARCHAR(60) | N | The textual displayed description for this Quality Measure. |
MEASURE_CD | DOUBLE | N | The CODE VALUE record which identifies the Quality Measure. |
MEASURE_TYPE_FLAG | DOUBLE | N | Indicates the type of measure being created. 0 = Person Measure, 1 = Visit measure |
PCA_QUALITY_MEASURE_ID | DOUBLE | N | Unique, generated number that identifies a single row on the PCA_QUALITY_MEASURE table. |
PCA_SOURCE_ID | DOUBLE | N | The source that supplied this Quality Measure. |
PREP_SCRIPT_NAME | VARCHAR(40) | Y | The Discern Explorer program which is used to prepare the associated activity tables for data associated with this quality measure. |
QUAL_SCRIPT_NAME | VARCHAR(40) | Y | The Discern Explorer program object which is used to determine which data needs to be processed for this quality measure. |
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 - PCA_QUALITY_MEASURE
Child Column in PCA_QUALITY_MEASURE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PCA_SOURCE_ID | PCA_SOURCE | PCA_SOURCE_ID |
Parent Column in PCA_QUALITY_MEASURE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PCA_QUALITY_MEASURE_ID | BR_ELIG_PROV_MEAS_RELTN | PCA_QUALITY_MEASURE_ID |
PCA_ENCNTR_MEASURE_OUTCOME | PCA_QUALITY_MEASURE_ID | ||
PCA_MEASURE_OUTCOME_RELTN | PCA_QUALITY_MEASURE_ID | ||
PCA_PERSON_MEASURE_OUTCOME | PCA_QUALITY_MEASURE_ID | ||
PCA_TOPIC_MEASURE_RELTN | PCA_QUALITY_MEASURE_ID |