ACTIVITY_DATA_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Activity Data Relationships
Definition: Record relationships between activity data (Allergies, Orders, etc...) and other entities (Organization, Personnel, etc...)
Table Type: ACTIVITY





Column Detail - ACTIVITY_DATA_RELTN


Column Name Type Null? Definition
ACTIVITY_DATA_RELTN_ID DOUBLE N Primary key. Unique Identifier for a relationship.
ACTIVITY_ENTITY_ID DOUBLE N Activity Table Name (ALLERGY, ORDERS, etc.)
ACTIVITY_ENTITY_INST_ID DOUBLE N Instance id to activity data item instance for items that use the instance schema
ACTIVITY_ENTITY_NAME VARCHAR(30) N Activity Table Name (ALLERGY, ORDERS, etc.)
PERSON_ID DOUBLE N person whom the related order or allergy is for
RELTN_ENTITY_ALL_IND DOUBLE N Indicates if all entities of the named value have access to item.
RELTN_ENTITY_ID DOUBLE N Id to related data item. (ORGANIZATION, PRSNL, etc.)
RELTN_ENTITY_NAME VARCHAR(30) N Related Table name. (ORGANIZATION, PRSNL, etc.)
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 - ACTIVITY_DATA_RELTN


Child Column in ACTIVITY_DATA_RELTN(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


ACTIVITY_PRIVILEGE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: activity privilege relation
Definition: Stores relationships of privileges to activity_privilege_definition
Table Type: REFERENCE





Column Detail - ACTIVITY_PRIVILEGE_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.
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.
ACTIVITY_PRIVILEGE_DEF_ID DOUBLE N Foreign key to activity_privilege_definition table
ACTIVITY_PRIVILEGE_RELTN_ID DOUBLE N Primary key
PRIVILEGE_ID DOUBLE N Foreign key to privilege 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 - ACTIVITY_PRIVILEGE_RELTN


Child Column in ACTIVITY_PRIVILEGE_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_PRIVILEGE_DEF_ID ACTIVITY_PRIVILEGE_DEFINITION ACTIVITY_PRIVILEGE_DEF_ID
PRIVILEGE_ID PRIVILEGE PRIVILEGE_ID


APP_PREFS



Column Section Top of Page


Table-level Detail

Description: This table contains application level preferences for PowerC
Definition: This table contains application level preferences for PowerChart. The table is structured so that other applications should be able to use it.
Table Type: REFERENCE





Column Detail - APP_PREFS


Column Name Type Null? Definition
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.
APPLICATION_NUMBER DOUBLE N Each row in this table contains preference data for a registered application. This column contains the registered (assigned) number of the application.
APP_PREFS_ID DOUBLE N This is the unique identifier of a row on this table.
POSITION_CD DOUBLE N Application level preferences can optionally be defined at the position level. If a row contains data for preferences at a position level, this column will contain the code_value of a position from codeset 88.
PRSNL_ID DOUBLE N Application level preferences can optionally be defined at the personnel level. If a row contains data for preferences at a personnel level, this column will contain that user's person_id.
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.


CHART_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart definition
Definition: Defines a chart for pediatric growth chart.
Table Type: REFERENCE





Column Detail - CHART_DEFINITION


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 will be the tables primary key.
CHART_SOURCE_CD DOUBLE N This identifies the source for the chart.
CHART_TITLE VARCHAR(255) Y This identifies the title of the chart.
CHART_TYPE_CD DOUBLE N This identifies the type of chart.
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 CHART_DEFINITION_HIST.
MAX_AGE DOUBLE N This identifies the maximum age in days for which the chart applies.
MIN_AGE DOUBLE N This identifies the minimum age in days for which the chart applies.
SEX_CD DOUBLE N This identifies the gender for which the chart applies.
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.
VERSION VARCHAR(255) Y This is the version name associated with this chart.
X_AXIS_SECTION1_MAX_VAL DOUBLE N This is the maximum value of the first section of the X axis.
X_AXIS_SECTION1_MIN_VAL DOUBLE N This is the minimum value of the first section of the X axis.
X_AXIS_SECTION1_UNIT_CD DOUBLE N This is the unit code of the values in the first section of the X axis.
X_AXIS_SECTION2_MAX_VAL DOUBLE Y This is the maximum value of the second section of the X axis.
X_AXIS_SECTION2_MIN_VAL DOUBLE N This is the minimum value of the second section of the X axis.
X_AXIS_SECTION2_MULTIPLIER DOUBLE Y This is the multiplier to indicate how section 1 values should relate to section 2 values.
X_AXIS_SECTION2_UNIT_CD DOUBLE N This is the unit code of the values in the second section of the X axis.
X_TYPE_CD DOUBLE N This identifies the type of measurement displayed on the x axis.
Y_AXIS_MAX_VAL DOUBLE N This is the maximum value on the Y axis.
Y_AXIS_MIN_VAL DOUBLE N This is the minimum value on the Y axis.
Y_AXIS_UNIT_CD DOUBLE N This is the unit code of the values on the Y axis.
Y_TYPE_CD DOUBLE N This identifies the type of measurement displayed on the y axis.



Relationship Detail - CHART_DEFINITION




Parent Column in CHART_DEFINITION (PK) Child Table Name Child Column Name
Children: CHART_DEFINITION_ID CHART_DEFINITION_HIST CHART_DEFINITION_ID
REF_DATASET CHART_DEFINITION_ID
REF_DATASTATS CHART_DEFINITION_ID


CHART_DEFINITION_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Definition History
Definition: Defines a historical record of a chart for pediatric growth chart.
Table Type: REFERENCE





Column Detail - CHART_DEFINITION_HIST


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Action Date and Time
ACTION_SEQ DOUBLE N This represents the sequence number of this entry. Part of Primary key.
ACTION_TYPE_FLAG DOUBLE N Action Type Flag
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 will be the table's primary key. Also an FK from parent table.
CHART_SOURCE_CD DOUBLE N This identifies the source for the chart.
CHART_TITLE VARCHAR(255) Y This identifies the title of the chart.
CHART_TYPE_CD DOUBLE N This identifies the type of chart.
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.
MAX_AGE DOUBLE N This identifies the maximum age in days for which the chart applies.
MIN_AGE DOUBLE N This identifies the minimum age in days for which the chart applies.
SEX_CD DOUBLE N This identifies the gender for which the chart applies.
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.
VERSION VARCHAR(255) Y This is the version name associated with this chart.
X_AXIS_SECTION1_MAX_VAL DOUBLE N This is the maximum value of the first section of the X axis.
X_AXIS_SECTION1_MIN_VAL DOUBLE N This is the minimum value of the first section of the X axis.
X_AXIS_SECTION1_UNIT_CD DOUBLE N This is the unit code of the values in the first section of the X axis.
X_AXIS_SECTION2_MAX_VAL DOUBLE Y This is the maximum value of the second section of the X axis.
X_AXIS_SECTION2_MIN_VAL DOUBLE Y This is the minimum value of the second section of the X axis.
X_AXIS_SECTION2_MULTIPLIER DOUBLE Y This is the multiplier to indicate how section 1 values should relate to section 2 values.
X_AXIS_SECTION2_UNIT_CD DOUBLE N This is the unit code of the values in the second section of the X axis.
X_TYPE_CD DOUBLE N This identifies the type of measurement displayed on the x axis.
Y_AXIS_MAX_VAL DOUBLE N This is the maximum value on the Y axis.
Y_AXIS_MIN_VAL DOUBLE N This is the minimum value on the Y axis.
Y_AXIS_UNIT_CD DOUBLE N This is the unit code of the values on the Y axis.
Y_TYPE_CD DOUBLE N This identifies the type of measurement displayed on the y axis.



Relationship Detail - CHART_DEFINITION_HIST


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