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 |