Table Detail Report

PW_PT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway PowerTrial Relation
Definition: This table holds the relationship between a PowerPlan and PowerTrial.
Table Type: REFERENCE





Column Detail - PW_PT_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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
MINIMUM_ENROLLMENT_STATUS_FLAG DOUBLE N Minimum enrollment status of the PowerTrial needed in order for the PowerPlan to be considered. 0 - None 1 - Consent Pending 2 - Enrolled
ORDERING_POLICY_FLAG DOUBLE N The Action that should be taken when the PowerPlan is added. 0 - No Action 1 - Warn - Consent Pending 2 - Warn 3 - Stop
PATHWAY_CATALOG_ID DOUBLE N Pathway catalog identification. Unique id of the pathway catalog entry referenced by an entry on this table.
PREV_PW_PT_RELTN_ID DOUBLE N The id of the most of to date row in this table that shares the same history.
PROT_MASTER_ID DOUBLE N PowerTrial identification. Unique id of the PowerTrial entry referenced by an entry on this table.
PW_PT_RELTN_ID DOUBLE N Primary Key
REQUIRE_OVERRIDE_REASON_IND DOUBLE N Indicator for whether the user can provide an override reason when adding the PowerPlan.
SEQUENCE DOUBLE N The sequence number of the entry.
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 - PW_PT_RELTN


Child Column in PW_PT_RELTN(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID
PREV_PW_PT_RELTN_ID PW_PT_RELTN PW_PT_RELTN_ID




Parent Column in PW_PT_RELTN (PK) Child Table Name Child Column Name
Children: PW_PT_RELTN_ID PW_PT_RELTN PREV_PW_PT_RELTN_ID


PW_VARIANCE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: pw_variance_reltn
Definition: Table used to relate variance results to pathways and pathway components
Table Type: ACTIVITY





Column Detail - PW_VARIANCE_RELTN


Column Name Type Null? Definition
ACTION_CD DOUBLE N Codified action field to describe what action was taken to address the variance column. Values in this field may be from code set 30186 or 24931.
ACTION_TEXT_ID DOUBLE N Text_id of the free textaction description.Column
ACTIVE_IND DOUBLE Y 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.
CHART_DT_TM DATETIME Y Date & time the variance was charted
CHART_PRSNL_ID DOUBLE N Unique identifier of the person who charted the variance
CHART_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column
EVENT_ID DOUBLE N Event_id of the results that document the variance
NOTE_TEXT_ID DOUBLE N Text ID of the free textNote. Foreign key from LONG_TEXT table (LONG_TEXT_ID).
OUTCOME_COMP_ID DOUBLE N Id of the pathway outcome component that this variance relates to. This will only be filled out for result variances that were charted as a result of the outcome.
OUTCOME_OPERATOR_CD DOUBLE N Codified outcome operator.Column
PARENT_ENTITY_ID DOUBLE N Id of the item the variance is related to (pathway, act_pw_comp, clinical_event).
PARENT_ENTITY_NAME VARCHAR(32) Y Name of the parent entity the variance is related to.
PATHWAY_ID DOUBLE N Id of the pathway the variance is related to. This field will always be filled out if the variance is related to a pathway, act_pw_comp, or outcome result.
PW_VARIANCE_RELTN_ID DOUBLE N Id of the variance relationship entry.
REASON_CD DOUBLE N Codified reason why the variance occurred. Values in this code column may be from code set 24930 or 30185.
REASON_TEXT_ID DOUBLE N Text_id of the free text reason.Column
RESULT_UNITS_CD DOUBLE N Result units of the result_value that are used to define the outcome.Column
RESULT_VALUE DOUBLE Y Result value used to define the outcome.Column
UNCHART_DT_TM DATETIME Y Date & time the variance was uncharted
UNCHART_PRSNL_ID DOUBLE N Unique identifier of the person who uncharted the variance
UNCHART_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
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.
VARIANCE_DT_TM DATETIME Y Date and time the variance was created.Column
VARIANCE_TYPE_CD DOUBLE N Codified variance type.Column



Relationship Detail - PW_VARIANCE_RELTN


Child Column in PW_VARIANCE_RELTN(FK) Parent Table Name Parent Column Name
Parents: OUTCOME_COMP_ID ACT_PW_COMP ACT_PW_COMP_ID
NOTE_TEXT_ID LONG_TEXT LONG_TEXT_ID
PATHWAY_ID PATHWAY PATHWAY_ID


REF_DATASET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference Dataset
Definition: Defines a dataset of reference data in a growth chart
Table Type: REFERENCE





Column Detail - REF_DATASET


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CHART_DEFINITION_ID DOUBLE N This is the foreign key to the CHART_DEFINITION table. Each dataset belongs to exactly one chart definition.
DISPLAY_NAME VARCHAR(60) N This is the display name of the dataset.
DISPLAY_TYPE_CD DOUBLE N This indicates the type of line to be displayed for this dataset.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LAST_ACTION_SEQ DOUBLE N This represent the sequence number of the last entry in REF_DATASET_HIST.
REF_DATASET_ID DOUBLE N This will be the table's primary key.
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 - REF_DATASET


Child Column in REF_DATASET(FK) Parent Table Name Parent Column Name
Parents: CHART_DEFINITION_ID CHART_DEFINITION CHART_DEFINITION_ID




Parent Column in REF_DATASET (PK) Child Table Name Child Column Name
Children: REF_DATASET_ID REF_DATAPOINT REF_DATASET_ID
REF_DATASET_HIST REF_DATASET_ID


RESIDENT_SUPERVISOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Resident Supervisor
Definition: This table contains a current and historical set of relationships between resident and supervisor physicians.
Table Type: REFERENCE





Column Detail - RESIDENT_SUPERVISOR


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
RESIDENT_SUPERVISOR_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
RES_ALIAS VARCHAR(200) Y The res_alias is an identifier (I.e., SSN, medical record number, etc.) for a person. The alias may be unique or non-unique depending on the type of alias.
RES_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SUP_ALIAS VARCHAR(200) Y The res_alias is an identifier (I.e., SSN, medical record number, etc.) for a person. The alias may be unique or non-unique depending on the type of alias.
SUP_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - RESIDENT_SUPERVISOR


Child Column in RESIDENT_SUPERVISOR(FK) Parent Table Name Parent Column Name
Parents: RES_PERSON_ID PRSNL PERSON_ID