PCA_BATCH_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: PowerChrt Analytics Batch Schedule
Definition: Contains scheduling information for populating Quality Topics.
Table Type: REFERENCE





Column Detail - PCA_BATCH_SCHED


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.
DAYS_OF_WEEK VARCHAR(8) N Indicates the days of the week this item should execute. E.g. 1=Sunday, 7 = Saturday so '145' indicates that the item should run on Sunday, Wednesday, and Thursday.
DAY_OF_MONTH_NBR DOUBLE N Indicates the day of month that this item is intended to execute.
EXPECTED_END_RUN_DT_TM DATETIME Y The last date/time that this item will execute.
FREQ_NBR DOUBLE N Together with RECURRENCE_FLAG, indicates how often this scheduled item will be executed. Indicates the frequency, e.g. "Every 2".
PARENT_ENTITY_ID DOUBLE N A foreign key from the table whose record is being associated with a schedule.
PARENT_ENTITY_NAME VARCHAR(32) Y The name of the table whose record is being associated with a schedule.
PCA_BATCH_SCHED_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_BATCH_SCHED table.
PROCESS_SEQ DOUBLE N Used to determine order for processing scheduled topics.
RECURRENCE_FLAG DOUBLE N Together with FREQ_NBR, indicates how frequently this scheduled item will be executed. Indicates the granularity, e.g. Daily, Weekly, Monthly, etc.
TIME_OF_DAY_TXT VARCHAR(10) Y Indicates the time of day this item is scheduled to execute.
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_BATCH_SCHED




Parent Column in PCA_BATCH_SCHED (PK) Child Table Name Child Column Name
Children: PCA_BATCH_SCHED_ID PCA_BATCH_SCHED_CONTROL PCA_BATCH_SCHED_ID


PCA_BATCH_SCHED_CONTROL



Column Section Relationship Section Top of Page


Table-level Detail

Description: PowerChart Analytics Batch Schedule Control
Definition: Contains information about the past and future execution of the job that populates Quality Topics.
Table Type: ACTIVITY





Column Detail - PCA_BATCH_SCHED_CONTROL


Column Name Type Null? Definition
LAST_RUN_DT_TM DATETIME Y The last date/time that this scheduled item executed.
NEXT_CALC_RUN_DT_TM DATETIME Y The date that this batch schedule should next run.
PCA_BATCH_SCHED_CONTROL_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_BATCH_SCHED_CONTROL table.
PCA_BATCH_SCHED_ID DOUBLE N The batch schedule that these controls pertain 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 - PCA_BATCH_SCHED_CONTROL


Child Column in PCA_BATCH_SCHED_CONTROL(FK) Parent Table Name Parent Column Name
Parents: PCA_BATCH_SCHED_ID PCA_BATCH_SCHED PCA_BATCH_SCHED_ID


PCA_ENCNTR_MEASURE_OUTCOME



Column Section Relationship Section Top of Page


Table-level Detail

Description: Power Chart Analytics Encounter Measure Outcome
Definition: Contains a snapshot which provides information about encounters being tracked as part of a Quality Topic, specifically the outcomes for various measures associated with the topic.
Table Type: ACTIVITY





Column Detail - PCA_ENCNTR_MEASURE_OUTCOME


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N The encounter being tracked as part of a Quality Topic.
MEASURE_PROCESS_FLAG DOUBLE N Indicates that this record needs some type of processing to fill it's PCA_OUTCOME_ID field.0
PCA_ENCNTR_MEASURE_OUTCOME_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_ENCNTR_MEASURE_OUTCOME table.
PCA_OUTCOME_ID DOUBLE N The unique identifier of the Quality Measure's Outcome.
PCA_QUALITY_MEASURE_ID DOUBLE N The unique identifier for the Quality Measure being tracked as part of the Quality Topic.
PERSON_ID DOUBLE N The person_id of the encounter that is 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_ENCNTR_MEASURE_OUTCOME


Child Column in PCA_ENCNTR_MEASURE_OUTCOME(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
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_ENCNTR_TOPIC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Power Chart Analytics Encounter Topic Relation
Definition: Contains a snapshot which provides information about encounters being tracked as part of a Quality Topic.
Table Type: ACTIVITY





Column Detail - PCA_ENCNTR_TOPIC_RELTN


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N The encounter being tracked as part of a Quality Topic.
PCA_ENCNTR_TOPIC_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_ENCNTR_TOPIC_RELTN table.
PCA_QUALITY_TOPIC_ID DOUBLE N The unique identifier for the Quality Topic associated with the encounter.
PERSON_ID DOUBLE N The person associated to the encounter being tracked as part of a 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.
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_ENCNTR_TOPIC_RELTN


Child Column in PCA_ENCNTR_TOPIC_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PCA_QUALITY_TOPIC_ID PCA_QUALITY_TOPIC PCA_QUALITY_TOPIC_ID
PERSON_ID PERSON PERSON_ID


PCA_MEASURE_OUTCOME_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Power Chart Analytics Measure Outcome Relation
Definition: Defines the possible outcomes for a given measure.
Table Type: REFERENCE





Column Detail - PCA_MEASURE_OUTCOME_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_MEASURE_OUTCOME_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the PCA_MEASURE_OUTCOME_RELTN table.
PCA_OUTCOME_ID DOUBLE N The possible outcomes for a given Quality Measure.
PCA_QUALITY_MEASURE_ID DOUBLE N The Quality Measure that pertains to 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_MEASURE_OUTCOME_RELTN


Child Column in PCA_MEASURE_OUTCOME_RELTN(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