Atlas
— Initial Database Tables (Data-Admin-DB-Table)
|
|
When initially installed, V6.1 contains around ninety database table (Data-Admin-DB-Table) data instances, linked to 66 database tables and 7 views in the PegaRULES database.
For example, the database table instance named
Data-Admin-Operator-ID is linked to the
pr_operators relational table. The database table instance
named Data-Admin- references a different relational table
pr_data, a catch-all table that contains rows for instances
of concrete classes derived from Data- that are not contained in other
tables.
This table lists the PegaRULES database tables and an example of a
concrete class that maps to that table. No classes are initially mapped
to the pr_other table, the default catch-all table for
instances of classes not explicitly mapped.
Assign-
database table mappings
Database Table Instance |
PegaRULES table |
Additional information |
| Assign- | pr_assign
|
Tables for assignments |
| Assign-External | pr_assignPROJ-404 TASK-676
|
Tables for assignments |
| Assign-WorkBasket | pc_assign_workbasket
|
Tables for assignments |
| Assign-Worklist | pc_assign_worklist
|
Tables for assignments |
Database Table Instance |
PegaRULES table |
Additional information |
| Data- | pr_data
|
Tables for data objects |
| Data-Admin- | pr_data_admin
|
Tables for data objects |
| Data-Admin-Connect- | pi_data_connect
|
Tables for data objects |
| Data-Admin-DB- | pr4_base
|
Table and column basics |
| Data-Admin-Operator-ID | pr_operators
|
Tables for data objects |
| Data-Assignment-Summary | pcv4_assignment_summary
|
Views and indexes |
| Data-Assignment-WBSummary | pcv4_assignmentwb_summary
|
Views and indexes |
| Data-Autotest-Result-Case | pr_data_autotest
|
Tables for data objects |
| Data-Autotest-Result-Suite | pr_data_autotest
|
Tables for data objects |
| Data-Circumstance-Duplicates | pwbv4_circumstance_duplicates
|
Views and indexes |
| Data-Rule-Locking | pwbv4_rule_locking
|
Views and indexes |
| Data-Rule-Overrides | pwbv4_rule_overrides
|
Views and indexes |
| Data-Rule-Summary | pr4_rule_vw
|
Views and indexes |
| Data-UniqueID | pc_data_uniqueid
|
Tables for data objects |
| Data-Work-History | pcv4_work_history
|
Views and indexes |
| Data-WorkAttach- | pc_data_workattach
|
Tables for data objects |
History-
database table mappings
Database Table Instance |
PegaRULES table |
Additional information |
| History- | pr_history
|
Tables for history |
| History-Data- | pr_history_data
|
Tables for history |
| History-PegaAccel | pc_history_work
|
Tables for history |
| History-PegaSample | pc_history_work
|
Tables for history |
| History-Rule | pr4_history_rule
|
Tables for history |
| History-Work- | pc_history_work
|
Tables for history |
Index- database table mappings
Database Table Instance |
PegaRULES table |
Additional information |
| Index- | pr_index
|
Link- and Index- tables |
| Index-AccessGroupRoles | pr_indexaccessgrouproles
|
Link- and Index- tables |
| Index-AccessGroupWorkPools | pr_indexaccessgroupwkpools
|
Link- and Index- tables |
| Index-AssignmentSkills | pr_indexassignmentskills
|
Link- and Index- tables |
| Index-CircumstanceDefinition | pr_index_circumstance-def
|
Link- and Index- tables |
| Index-CustomFields | pr_index_customfields
|
Link- and Index- tables |
| Index-FlowRef | pc_index_flowref
|
Link- and Index- tables |
| Index-Operator | pc_index_flowref
|
Link- and Index- tables |
| Index-OperatorSkills | pr_index_operatorskills
|
Link- and Index- tables |
| Index-Reference | pr_index_reference
|
Link- and Index- tables |
| Index-UpdateAccessUsers | pc_index_accel
|
Link- and Index- tables |
| Index-Warning | pr_index_warnings
|
Link- and Index- tables |
| Index-WorkPartyURI | pc_index_workparty
|
Link- and Index- tables |
Database Table Instance |
PegaRULES table |
Additional information |
| Link- | pr_link
|
Link- and Index- tables |
| Link-Attachment | pc_link_attachment
|
Link- and Index- tables |
| Link-Folder | pc_link_folder
|
Link- and Index- tables |
| Link-Requirement | pr_link_usecase
|
Link- and Index- tables |
| Link-UseCase | pr_link_usecase
|
Link- and Index- tables |
Database Table Instance |
PegaRULES table |
Additional information |
| Log- | pr_log
|
Log and miscellaneous tables |
| Log-DataAccessAudit5.5 | pr_log_dataaccessaudit
|
Log and miscellaneous tables |
| Log-License-Parameters | pr_license_parameters
|
Log and miscellaneous tables |
| Log-License-Usage-Daily | pr_daily_usage
|
Log and miscellaneous tables |
| Log-License-Usage-Hourly | pr_hourly_usage
|
Log and miscellaneous tables |
| Log-License-Usage-Summary | pr_usage_summary
|
Log and miscellaneous tables |
| Log-RuleUsage B-24820 | pr4_log_rule_usage
|
Log and miscellaneous tables |
| Log-RuleUsage-Details | pr4_log_rule_usage_details
|
Log and miscellaneous tables |
| Log-Usage | pr_perf_stats
|
Log and miscellaneous tables |
Database Table Instance |
PegaRULES table |
Additional information |
| Rule- | pr4_rule
|
Tables for rules |
| Rule-Category | pr4_rule_shortcut
|
Tables for rules |
| Rule-AutoTest- | pr4_rule_autotest
|
Tables for rules |
| Rule-File- | pr4_rule_file
|
Tables for rules |
| Rule-Generated-Activity | pr4_rule_sysgen
|
Tables for rules |
| Rule-Obj-Class | pr4_base
|
Tables for data objects |
| Rule-Obj-FieldValue | pr4_fieldvalue
|
Tables for rules |
| Rule-Obj-Flow | pr4_rule_flow
|
Tables for rules |
| Rule-Obj-Property | pr4_rule_property
|
Tables for rules |
| Rule-Shortcut | pr4_rule_shortcut
|
Tables for rules |
| Rule-System-Generated-Access | pr4_rule_sysgen
|
Tables for rules |
System-
database table mappings
Database Table Instance |
PegaRULES table |
Additional information |
| System-Cache-Dependency | pr_sys_cache_dep
|
System tables |
| System-Cache-Entry | pr_sys_cache_entry
|
System tables |
| System-Cache-Implementation | pr_sys_cache_impl
|
System tables |
| System-CachedConclusion | pr4_rule_sysgen
|
Tables for rules |
| System-Declare-Changes | pr_sys_decchgPROJ-30
|
System tables |
| System-Locks | pr_sys_locks
|
System tables |
| System-Queue- | pr_sys_queue5.4
|
System tables |
| System-Queue-ExecutionRequest-Connect- | pr_sys_queue_execreq_conn
|
System tables |
| System-Queue-ExecutionRequest-Service | pr_sys_queue_execreq_svc
|
System tables |
| System-Queue-StartingFlows | pr_sys_queue_startflows
|
System tables |
| System-Requestor-Context | pr_sys_context
|
System tables |
| System-SavedPages | pr_page_store
|
System tables |
| System-Status-Nodes | pr_sys_statusnodes
|
System tables |
| System-Updates-Cache | pr_sys_updatescache
|
System tables |
| System-User- | pr_sys_user
|
System tables |
| System-Work-Indexer | pr_sys_workindexer_queue
|
System tables |
Work- and
miscellaneous tables
Database Table Instance |
PegaRULES table |
Additional information |
| Work- | pc_work
|
Tables for work objects |
| PegaAccel- | pc_work_accel BUG-2667
|
Tables for work objects |
| Pega-Event | pc_events 6.1 | Tables for work objects |
| Pega-Portal- | pr_portal_state
|
System tables |
| PegaSample | pc_work
|
Tables for work objects |
| PegaForecaster | pc_work
|
Tables for work objects |
pegaam_alert
|
Part of AES. Unused unless AES is installed. | |
pegaam_log_usage
|
Part of AES. Unused unless AES is installed. | |
| (none) | pr_other
|
Table of last resort. |
|
Working
with the PegaRULES database
Working with the PegaRULES database — Common data management tasks |
About Database Table data instances
Atlas — Initial
Data Instances
