Table Detail Report
LOGICAL_GROUPING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains locical groupings of data elements, primarily for privileges |
Definition: | This table contains locical groupings of data elements, primarily for privilege definition. Elements of the grouping are stored on the LOG_GROUP_ENTRY table. |
Table Type: | REFERENCE |
Column Detail - LOGICAL_GROUPING
Column Name | Type | Null? | Definition |
---|---|---|---|
COMP_TYPE_CD | DOUBLE | N | This row contains the code value representing the type of element that is being grouped (i.e. orders, discretes,...) |
LOGICAL_GROUP_DESC | VARCHAR(100) | Y | This column will contain a description of the logical grouping. |
LOG_GROUPING_CD | DOUBLE | N | This column contains the unique identifier of a row on this table. |
LOG_GROUPING_TYPE_CD | DOUBLE | N | This column contains a code value representing the type or the use of this logical grouping, i.e. privileges. |
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 - LOGICAL_GROUPING
Parent Column in LOGICAL_GROUPING (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LOG_GROUPING_CD | LOG_GROUP_ENTRY | LOG_GROUPING_CD |
LOG_GROUP_TYPE | LOG_GROUPING_CD | ||
PRIVILEGE | LOG_GROUPING_CD | ||
PRIV_GROUP_RELTN | LOG_GROUPING_CD |
LOG_GROUP_ENTRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains the entries of a locical grouping of data elements. |
Definition: | This table contains the entries of a locical grouping of data elements. The grouping is stored on the LOGICAL_GROUPING table. |
Table Type: | REFERENCE |
Column Detail - LOG_GROUP_ENTRY
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_SET_NAME | VARCHAR(100) | Y | This row contains the display for the item in the group. |
EXCEPTION_ENTITY_NAME | VARCHAR(40) | Y | The name of the table that the exception row is from. |
EXCEPTION_TYPE_CD | DOUBLE | N | Indicates which database this exception relates to. Could be the order catalog, an event set, etc. |
ITEM_CD | DOUBLE | N | This row contains the code value for the item in the group. |
LOG_GROUPING_CD | DOUBLE | N | This row contains the identifier of the logical group that this row is an entry in. |
LOG_GROUPING_COMP_CD | DOUBLE | N | this field contains the unique identifier of this row on this 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 - LOG_GROUP_ENTRY
Child Column in LOG_GROUP_ENTRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOG_GROUPING_CD | LOGICAL_GROUPING | LOG_GROUPING_CD |
LOG_GROUP_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Logical Grouping Type |
Definition: | Stores Exception Type data for groups which are created. Link to LOGICAL_GROUPING table by log_grouping_cd field. T |
Table Type: | REFERENCE |
Column Detail - LOG_GROUP_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
EXCEPTION_TYPE_CD | DOUBLE | N | Indicates which database this exception relates to. CodeSet: 6015 |
LOG_GROUPING_CD | DOUBLE | N | This row contains the identifier of the logical group that this row is an entry for on the logical grouping table. |
LOG_GROUP_TYPE_ID | DOUBLE | N | 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 - LOG_GROUP_TYPE
Child Column in LOG_GROUP_TYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOG_GROUPING_CD | LOGICAL_GROUPING | LOG_GROUPING_CD |
NAME_VALUE_PREFS
Column Section | Top of Page |
Table-level Detail
Description: | This table contains name-value pairs associated with PowerChart |
Definition: | This table contains name-value pairs associated with PowerChart preferences. The table is structured so that other applications can use it. |
Table Type: | REFERENCE |
Column Detail - NAME_VALUE_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. |
MERGE_ID | DOUBLE | Y | The primary id of the table that this row references. |
MERGE_NAME | VARCHAR(100) | Y | name of the table referenced by merge_id |
NAME_VALUE_PREFS_ID | DOUBLE | N | The unique identifier of a row on this table. |
PARENT_ENTITY_ID | DOUBLE | N | The primary id of the table that this row is a child of. Will either be the index to the APP_PREFS, VIEW_PREFS, VIEW_COMP_PREFS, DETAIL_PREFS or PREDEFINED_PREFS tables. |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The name of the table that the row on this table is a child of. Will either by APP_PREFS, VIEW_PREFS, VIEW_COMP_PREFS, DETAIL_PREFS or PREDEFINED_PREFS. |
PVC_NAME | VARCHAR(32) | N | The name portion of the name/value pair that is stored on a row in this table. |
PVC_VALUE | VARCHAR(256) | N | The value portion of the name/value pair that is stored on a row in this table. |
SEQUENCE | DOUBLE | Y | sequence of name value pair |
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. |
PC_ANNOUNCEMENT_TEXT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PC_ANNOUNCEMENT_TEXT |
Definition: | The table strores provider announcement text details |
Table Type: | ACTIVITY |
Column Detail - PC_ANNOUNCEMENT_TEXT
Column Name | Type | Null? | Definition |
---|---|---|---|
ANNOUNCEMENT_LONG_TEXT_ID | DOUBLE | N | Identifies a row in the long text table |
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. |
ENTITY_RELTN_MEAN_TEXT | VARCHAR(12) | N | The meaning of the relationship that is used to identify the source of announcement text |
PC_ANNOUNCEMENT_TEXT_ID | DOUBLE | N | PRIMARY KEY |
PHYSICIAN_IND | DOUBLE | N | Identifies if the row belongs to a physician |
POSITION_CD | DOUBLE | N | Identifies the Position of the user |
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 - PC_ANNOUNCEMENT_TEXT
Child Column in PC_ANNOUNCEMENT_TEXT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ANNOUNCEMENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |