Table Detail Report
REF_DATASTATS_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Reference Data Statistics History |
Definition: | Defines a historical record of statistical measures for a particular range on a growth chart. |
Table Type: | REFERENCE |
Column Detail - REF_DATASTATS_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | N | Action Date 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. |
BOX_COX_POWER_VALUE | DOUBLE | Y | This is the 'power in the Box-Cox transformation' for the population as given by the source of the chart information. (This is the L in the CDC's LMS parameters.) |
CHART_DEFINITION_ID | DOUBLE | N | This is the foreign key to the CHART_DEFINITION table. Each data point belongs to exactly one dataset. |
COEFFNT_VAR_VALUE | DOUBLE | Y | This is the generalized coefficient of variation value for the population as given by the source of the chart information. (This is the S in the CDC's LMS parameters.) |
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. |
MEAN_VALUE | DOUBLE | Y | This is the mean value for the population as given by the source of the chart information. |
MEDIAN_VALUE | DOUBLE | Y | This is the median value for the population as given by the source of the chart information. (This is the M in the CDC's LMS parameters.) |
REF_DATASTATS_ID | DOUBLE | N | This will be the table's primary key. Foreign Key from REF_DATASTATS |
STD_DEV_VALUE | DOUBLE | Y | This is the standard deviation for the population as given by the source of the chart information. |
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. |
X_MAX_VAL | DOUBLE | N | This is the maximum val on the X axis for which the stats apply. Units are in the unit_cd of the X axis on the CHART_DEFINITION table. |
X_MIN_VAL | DOUBLE | N | This is the minimum val on the X axis for which the stats apply. Units are in the unit_cd of the X axis on the CHART_DEFINITION table. |
Relationship Detail - REF_DATASTATS_HIST
Child Column in REF_DATASTATS_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REF_DATASTATS_ID | REF_DATASTATS | REF_DATASTATS_ID |
SEAL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Seal |
Definition: | This table contains a list of seals. Seals are a method of access control, that determine whether the seal participant is granted or restricted access to an entity. |
Table Type: | ACTIVITY |
Column Detail - SEAL
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. |
COMMENT_TXT | VARCHAR(300) | Y | This will be used to store a comment for the group of DOA. If this field is empty, a comment was not entered. |
CREATED_BY_ID | DOUBLE | N | Identifies the user who created the seal. |
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. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It identifies what patient the seal applies. |
REASON_CD | DOUBLE | N | Reason for the Denial of Access |
SEAL_ID | DOUBLE | N | Unique identifier generated for each row of data in the seal table. |
SEAL_TYPE_CD | DOUBLE | N | Identifies the type of seal. For example, Denial of Access seal. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - SEAL
Child Column in SEAL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
Parent Column in SEAL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SEAL_ID | SEAL_PARTICIPANT | SEAL_ID |
SEAL_PARTICIPANT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Seal_participant |
Definition: | Identifies the personnel associated with a seal. |
Table Type: | ACTIVITY |
Column Detail - SEAL_PARTICIPANT
Column Name | Type | Null? | Definition |
---|---|---|---|
PRSNL_ID | DOUBLE | N | This is the value of the unique primary identifier of the prsnl table. It identifies what user the seal is applied. |
SEAL_ID | DOUBLE | N | Foreign Key from the SEAL table which identifies the SEAL for this participant. |
SEAL_PARTICIPANT_ID | DOUBLE | N | Unique identifier generated for each row of data in the seal_participant 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 - SEAL_PARTICIPANT
Child Column in SEAL_PARTICIPANT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SEAL_ID | SEAL | SEAL_ID |
TOC_DEFAULT_VIEW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TOC DEFAULT VIEW |
Definition: | The table defines the default chart view per TOC (Table of Content) filter per user within PowerChart and clones |
Table Type: | ACTIVITY |
Column Detail - TOC_DEFAULT_VIEW
Column Name | Type | Null? | Definition |
---|---|---|---|
APPLICATION_NUMBER | DOUBLE | N | Solution Specific Application Number |
DISPLAY_SEQ | DOUBLE | N | The order in which the tab will display |
PRSNL_ID | DOUBLE | N | ID for the User - FK value from the PERSON_ID on the PRSNL table. |
TOC_DEFAULT_VIEW_ID | DOUBLE | N | Primary Key - a unique generated number that identifies a unique row on the table |
TOC_FILTER_CD | DOUBLE | N | TOC (Table of Content) Filters from code set 4001984 |
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. |
VIEW_CAPTION | VARCHAR(256) | N | The display name of the tab, as it is seen in PowerChart and clones. |
Relationship Detail - TOC_DEFAULT_VIEW
Child Column in TOC_DEFAULT_VIEW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_ID | PRSNL | PERSON_ID |
VIEW_COMP_PREFS
Column Section | Top of Page |
Table-level Detail
Description: | This table contains view component preferences for the Power |
Definition: | This table contains view component preferences for the PowerChart application. It is structured so that other applications can use it. |
Table Type: | REFERENCE |
Column Detail - VIEW_COMP_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 | The application number that the preferences are being stored for. |
COMP_NAME | VARCHAR(12) | Y | The name of the component. |
COMP_SEQ | DOUBLE | Y | The sequence of the component. Will be valued at 1 unless a component is used multiple times on a view. |
POSITION_CD | DOUBLE | N | Will be valued with a code value from the position table if the preferences are at a position level. |
PRSNL_ID | DOUBLE | N | Will be valued with a user's person_id if the preferences are at a user level. |
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. |
VIEW_COMP_PREFS_ID | DOUBLE | N | The unique identifier of a row on this table. |
VIEW_NAME | VARCHAR(12) | Y | The name of the view that this component is on. |
VIEW_SEQ | DOUBLE | Y | The sequence of the view that this component is on. Will be valued at 1 unless a view is used multiple times in an application. |