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 |