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