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 |