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. |