Table Detail Report

PCA_QUALITY_TOPIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Power Chart Analytics Quality Topic
Definition: Contains the high-level topics that require measurements to be taken to indicate performance level. This table may serve as a dimension table for certain fact tables containing aggregations related to this Quality Topic.
Table Type: REFERENCE





Column Detail - PCA_QUALITY_TOPIC


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 Topic.
DESCRIPTION_TXT VARCHAR(255) Y Comment which provides additional meaning or context to the Topic.
DISPLAY_TXT VARCHAR(60) N The textual displayed description for this Quality Topic.
MEASUREMENT_PERIOD_NBR DOUBLE N The length of the defined measurement period for this quality topic. Used in conjunction with MEASUREMENT_PERIOD_UNIT_CD.
MEASUREMENT_PERIOD_UNIT_CD DOUBLE N The time period for which this Quality Topic is being measured. E.G. 'day' or 'month'. Used in conjunction with MEASUREMENT_PERIOD_NBR.
PCA_QUALITY_TOPIC_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_QUALITY_TOPIC table.
PCA_SOURCE_ID DOUBLE N The source that supplied this Quality Topic.
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 topic.
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 topic.
TOPIC_CD DOUBLE N The CODE VALUE record which identifies the Quality Topic. Populated on shipped rows only.
TOPIC_TYPE_FLAG DOUBLE N Indicates the type of topic that is being measured.
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_TOPIC


Child Column in PCA_QUALITY_TOPIC(FK) Parent Table Name Parent Column Name
Parents: PCA_SOURCE_ID PCA_SOURCE PCA_SOURCE_ID




Parent Column in PCA_QUALITY_TOPIC (PK) Child Table Name Child Column Name
Children: PCA_QUALITY_TOPIC_ID PCA_ENCNTR_TOPIC_RELTN PCA_QUALITY_TOPIC_ID
PCA_PERSON_TOPIC_RELTN PCA_QUALITY_TOPIC_ID
PCA_QUALITY_TOPIC_CONTROL PCA_QUALITY_TOPIC_ID
PCA_TOPIC_MEASURE_RELTN PCA_QUALITY_TOPIC_ID


PCA_QUALITY_TOPIC_CONTROL



Column Section Relationship Section Top of Page


Table-level Detail

Description: PowerChart Analytics Quality Topic Control
Definition: Contains data that controls the data population of Quality Topics.
Table Type: ACTIVITY





Column Detail - PCA_QUALITY_TOPIC_CONTROL


Column Name Type Null? Definition
EXECUTION_CNT DOUBLE N The number of times that the Quality Topic has been executed.
HISTORICAL_ACTIVE_IND DOUBLE N Indicates that historical extractions will be performed for this Quality Topic.
HISTORICAL_QUAL_FROM_DT_TM DATETIME Y The date/time which will be used as the lower limit during the qualification phase of a historical extraction.
HISTORICAL_QUAL_TO_DT_TM DATETIME Y The date/time which will be used as the upper limit during the qualification phase of a historical extraction.
INCREMENTAL_ACTIVE_IND DOUBLE N Indicates that incremental extractions will be performed for this Quality Topic.
INCREMENTAL_QUAL_FROM_DT_TM DATETIME Y The date/time which will be used as the lower limit during the qualification phase of the next incremental extraction. This is also the upper limit of the previous incremental extraction.
PCA_QUALITY_TOPIC_CONTROL_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_QUALITY_TOPIC_CONTROL table.
PCA_QUALITY_TOPIC_ID DOUBLE N The Quality Topic that is associated with this record.
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_TOPIC_CONTROL


Child Column in PCA_QUALITY_TOPIC_CONTROL(FK) Parent Table Name Parent Column Name
Parents: PCA_QUALITY_TOPIC_ID PCA_QUALITY_TOPIC PCA_QUALITY_TOPIC_ID


PCA_SOURCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Power Chart Analytics Source
Definition: Defines who provided the content for a Quality Topic.
Table Type: REFERENCE





Column Detail - PCA_SOURCE


Column Name Type Null? Definition
DEFINED_BY_FLAG DOUBLE N Identifies the group that provided this Quality Source.
DESCRIPTION_TXT VARCHAR(255) Y Comment which provides additional meaning or context to the Source.
DISPLAY_TXT VARCHAR(60) N The textual display for this Source.
PCA_SOURCE_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_SOURCE table.
SOURCE_CD DOUBLE N The CODE VALUE record which identifies the source. This field will only be used for base Sources shipped. Will contain zeros for client added rows.
SOURCE_URL_TXT VARCHAR(255) Y A URL address associated with the Source.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PCA_SOURCE




Parent Column in PCA_SOURCE (PK) Child Table Name Child Column Name
Children: PCA_SOURCE_ID PCA_OUTCOME PCA_SOURCE_ID
PCA_QUALITY_MEASURE PCA_SOURCE_ID
PCA_QUALITY_TOPIC PCA_SOURCE_ID


PCA_TOPIC_MEASURE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Power Chart Analytics Topic Measure Relation
Definition: Defines the measures that pertain to a given topic.
Table Type: REFERENCE





Column Detail - PCA_TOPIC_MEASURE_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.
PCA_QUALITY_MEASURE_ID DOUBLE N The measurement that pertains to this topic.
PCA_QUALITY_TOPIC_ID DOUBLE N The Quality Topic that this Measure pertains to.
PCA_TOPIC_MEASURE_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_TOPIC_MEASURE_RELTN table.
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_TOPIC_MEASURE_RELTN


Child Column in PCA_TOPIC_MEASURE_RELTN(FK) Parent Table Name Parent Column Name
Parents: PCA_QUALITY_MEASURE_ID PCA_QUALITY_MEASURE PCA_QUALITY_MEASURE_ID
PCA_QUALITY_TOPIC_ID PCA_QUALITY_TOPIC PCA_QUALITY_TOPIC_ID




Parent Column in PCA_TOPIC_MEASURE_RELTN (PK) Child Table Name Child Column Name
Children: PCA_TOPIC_MEASURE_RELTN_ID PCA_TOPIC_MEASURE_TARGET PCA_TOPIC_MEASURE_RELTN_ID


PCA_TOPIC_MEASURE_TARGET



Column Section Relationship Section Top of Page


Table-level Detail

Description: PowerChart Analytics Topic Measure Target
Definition: Contains the values that will be used to measure adherence to Quality Topics and Quality Measures.
Table Type: REFERENCE





Column Detail - PCA_TOPIC_MEASURE_TARGET


Column Name Type Null? Definition
PCA_TOPIC_MEASURE_RELTN_ID DOUBLE N The quality topic and quality measure associated with this target.
PCA_TOPIC_MEASURE_TARGET_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_TOPIC_MEASURE_TARGET table.
TARGET_PCT DOUBLE N The actual target value, expressed as an integer value.
TARGET_TYPE_CD DOUBLE N The type of target represented by the record. For example, a standard target vs. a client-defined target.
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_TOPIC_MEASURE_TARGET


Child Column in PCA_TOPIC_MEASURE_TARGET(FK) Parent Table Name Parent Column Name
Parents: PCA_TOPIC_MEASURE_RELTN_ID PCA_TOPIC_MEASURE_RELTN PCA_TOPIC_MEASURE_RELTN_ID