Table Detail Report

DCP_CONFIG_COMP_TREE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Configuration Component Tree Structure
Definition: This table contains data to form a tree structure using configuration components from the dcp_config_comp table
Table Type: REFERENCE





Column Detail - DCP_CONFIG_COMP_TREE


Column Name Type Null? Definition
COMP_SEQUENCE DOUBLE Y describes the order in which the sibling domain/sub-domain/component/sub-component are grouped under the parent
DCP_CONFIG_COMP_ID DOUBLE N Identifier for a Component in config_components table
DCP_CONFIG_COMP_TREE_ID DOUBLE N PRIMARY KEY
PARENT_COMP_ID DOUBLE N Identifies the parent of each domain/sub-domain/component(points to another row in the same 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 - DCP_CONFIG_COMP_TREE


Child Column in DCP_CONFIG_COMP_TREE(FK) Parent Table Name Parent Column Name
Parents: DCP_CONFIG_COMP_ID DCP_CONFIG_COMP DCP_CONFIG_COMP_ID
PARENT_COMP_ID DCP_CONFIG_COMP DCP_CONFIG_COMP_ID


DCP_CONFIG_SETTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Configuration Setting
Definition: This table contains details about a single configuration setting
Table Type: REFERENCE





Column Detail - DCP_CONFIG_SETTING


Column Name Type Null? Definition
CONFIG_DESC VARCHAR(2000) Y Long description about a configuration that provides user with extra information about a configuration
CONFIG_DISPLAY VARCHAR(140) N Name of a configuration that is displayed to user
CONFIG_DOMAIN VARCHAR(32) N Specifies what type of domain setting it is (preference, privileges,application groups etc.)
CONFIG_NAME VARCHAR(256) N Unique name assigned to a configuration setting(e.g.: pvc_name, priv_name)
CONFIG_TYPE VARCHAR(32) N Defines what type of domain setting a configuration is (view,detail, viewcomp, message center etc.)
DCP_CONFIG_SETTING_ID DOUBLE N PRIMARY KEY
REFURL_TXT VARCHAR(256) Y Link to the help page that provides extra information about a configuration
STANDARD_IND DOUBLE N Indicator that tells whether a configuration has a standard or not (1-standard,0 : non-standard)
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 - DCP_CONFIG_SETTING




Parent Column in DCP_CONFIG_SETTING (PK) Child Table Name Child Column Name
Children: DCP_CONFIG_SETTING_ID DCP_CONFIG_COMP_RELTN DCP_CONFIG_SETTING_ID


DCP_CUSTOM_COLS_SORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP CUSTOM COLS SORT
Definition: This table holds the sort dialog informaiton that is used within PowerChart
Table Type: REFERENCE





Column Detail - DCP_CUSTOM_COLS_SORT


Column Name Type Null? Definition
COLUMN_CD DOUBLE N This is the unique identifier to the column from codeset 6023Column
COLUMN_DESCRIPTION VARCHAR(12) Y displays the cdfMeaning of the column_cd if it is a custom sortColumn
COLUMN_SORT_ID DOUBLE N This is the unique identifier to the table.Column
POSITION_CD DOUBLE N This is the code_value from codeset 88 for which the record is written.Column
PRSNL_ID DOUBLE N This is an identifier that maps to the prsnl table for which this record is written.
SORT_DIRECTION_IND DOUBLE Y Tells whether the sort is ascending or descending
SORT_LEVEL_FLAG DOUBLE Y Tells if the sort is primary, secondary, or tertiaryColumn
SORT_TYPE_FLAG DOUBLE Y Tells if it is a default, rounds, or custom sortColumn
SPREAD_TYPE_CD DOUBLE N This maps to the value from codeset 6022 to identify which type of spreadsheet within PowerChart is going to use this sort 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.



Relationship Detail - DCP_CUSTOM_COLS_SORT


Child Column in DCP_CUSTOM_COLS_SORT(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


DCP_CUSTOM_COLUMNS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP CUSTOM COLUMNS
Definition: This table holds the custom column informaiton that is used within PowerChart
Table Type: REFERENCE





Column Detail - DCP_CUSTOM_COLUMNS


Column Name Type Null? Definition
CAPTION VARCHAR(40) N This fields holds the custom defined caption for a column that has been changed by an end user.
CUSTOM_COLUMN_CD DOUBLE N This is the unique identifier to the column from codeset 6023
CUSTOM_COLUMN_MEANING VARCHAR(12) N This is the meaning of the custom column code
POSITION_CD DOUBLE N This is the code_value from codeset 88 for which the record is written.
PRSNL_ID DOUBLE N This is an identifier that maps to the prsnl table for which this record is written.
SEQUENCE_IND DOUBLE N This is used to identify which order the columns listed on this table go when displaying the information on one of the PC spreadsheets.
SPREAD_COLUMN_ID DOUBLE N This is the unique identifier to the table.
SPREAD_TYPE_CD DOUBLE N This maps to the value from codeset 6022 to identify which type of spreadsheet within PowerChart is going to use this defined custom column 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.



Relationship Detail - DCP_CUSTOM_COLUMNS


Child Column in DCP_CUSTOM_COLUMNS(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


DETAIL_PREFS



Column Section Top of Page


Table-level Detail

Description: This table contains detail level preferences for the PowerCh
Definition: This table contains detail level preferences for the PowerChart application. The table is structured so that other applications can use it.
Table Type: REFERENCE





Column Detail - DETAIL_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 This column contains the application number that the detail preferences are associated with.
COMP_NAME VARCHAR(12) Y This column contains the component name that this set of detail preferences is associated with.
COMP_SEQ DOUBLE Y This column contains the component sequence that this row is associated with. The value will be 1 unless the same component is on a view multiple times.
DETAIL_PREFS_ID DOUBLE N This is the unique identifier of a row on this table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSITION_CD DOUBLE N This row will contain a code_value from the position table if the detail preferences are stored at a position level.
PRSNL_ID DOUBLE N This column will contain a person id for a user if the detail preferences were defined 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_NAME VARCHAR(12) Y This column will contain the name of the view that the component details are associated with.
VIEW_SEQ DOUBLE Y This column will contain the sequence of the view that the component detail preferences are associated with. It will be valued at 1 unless the same view is being viewed more than once in the application.