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