|
|
Atlas — Initial Database Tables (Data-Admin-DB-Table) 
When initially installed, V6.3 contains around 110 database table (Data-Admin-DB-Table) data instances, linked to about 105 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.
To see the databases, database tables, and database indexes in your system, and the schema changes that have occurred, select 
> System > Database > Schema Change Tracking.
Assign- database table mappings
Database Table Instance |
PegaRULES table |
Additional information |
| Assign- | pr_assign
|
Tables for assignments |
| Assign-External | pr_assign
|
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-Admin-Products-Restore- | pr_data_restore
|
Tables for data objects |
| Data-Admin-Products-Installed- | pr_data_products
|
Tables for data objects |
| Data-Admin-System-Settings | pr_data_admin
|
Tables for data objects |
| Data-Assignment-AllAssignments | pc_AllAssignments
|
Views and indexes |
| 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-Content-Image | pr_data_file
|
Tables for data objects |
| Data-Project-Task | pr_data_pmf_worklist
|
Tables for data objects |
| Data-Report-Category | pr_data_category
|
not used in V6.1SP2+ |
| Data-Report-Shortcut | pr_data_shortcut
|
not used in V6.1SP2+ |
| Data-Rule-ClassAncestor | pr_class_ancestors
|
Tables for data objects |
| 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-Social-Tag | pr_data_tag
|
Tables for data objects |
| Data-UIGallery-RepeatingLayouts-CompanyDetails | pr_data_sample_uidetails
|
Tables for data objects |
| Data-UIGallery-RepeatingLayouts-EmployeeDetails | pr_data_sample_uidetails
|
Tables for data objects |
| Data-UIGallery-RepeatingLayouts-PlantDetails | pr_data_sample_uidetails
|
Tables for data objects |
| 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
|
Index- tables |
| Index-AccessGroupRoles | pr_index_accessgrouproles
|
Index- tables |
| Index-AccessGroupWorkPools | pr_index_accessgroupwkpools
|
Index- tables |
| Index-ApplicationBranch | pr_app_branch_idx
|
Index- tables |
| Index-AssignmentDeps | pr_index_assignmentdeps
|
Index- tables |
| Index-AssignmentSkills | pr_indexassignmentskills
|
Index- tables |
| Index-CircumstanceDefinition | pr_index_circumstance_def
|
Index- tables |
| Index-CSS | pr_index_css
|
Index- tables |
| Index-CustomFields | pr_index_customfields
|
Index- tables |
| Index-FlowRef | pc_index_flowref
|
Index- tables |
| Index-Operator | pc_index_operators
|
Index- tables |
| Index-OperatorSkills | pr_index_operatorskills
|
Index- tables |
| Index-Pega-Scheduled-Task | pr_index_scheduledtask
|
Index- tables |
| Index-Reference | pr_index_reference
|
Index- tables |
| Index-UpdateAccessUsers | pc_index_accel
|
Index- tables |
| Index-Warning | pr_index_warnings
|
Index- tables |
| Index-WorkPartyURI | pc_index_workparty
|
Index- tables |
Database Table Instance |
PegaRULES table |
Additional information |
| Link- | pr_link
|
Link- tables |
| Link-Attachment | pc_link_attachment
|
Link- tables |
| Link-Folder | pc_link_folder
|
Link- tables |
| Link-Project | pr_link_pmf_rulechanges
|
Link-tables |
| Link-Requirement | pr_link_usecase
|
Link- tables |
| Link-Tag | pr_link_work_tag
|
Link- tables |
| Link-TopCase | pc_link_topcase
|
Link- tables |
| Link-UseCase | pr_link_usecase
|
Link- tables |
Database Table Instance |
PegaRULES table |
Additional information |
| Log- | pr_log
|
Log and miscellaneous tables |
| Log-DataAccessAudit | 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-ReportStatistics | pr_log_reportstats
|
Log and miscellaneous tables |
| Log-RuleUsage | pr4_log_rule_usage
|
Log and miscellaneous tables |
| Log-RuleUsage-Details | pr4_log_rule_usage_details
|
Log and miscellaneous tables |
| Log-SecurityAudit | pr_log_securityaudit
|
Log and miscellaneous tables |
| Log-System- | pr_changelog
|
Log and miscellaneous tables |
| Log-Usage | pr_perf_stats
|
Log and miscellaneous tables |
Database Table Instance |
PegaRULES table |
Additional information |
| Pega-CEP-Subscription | pr_cep_user_subscriptions
|
Log and miscellaneous tables |
| Pega-CEP-CEPEventsLookup | pr_cep_eventslookup
|
Log and miscellaneous tables |
| Pega-Event | pc_events
|
Log and miscellaneous tables |
| Pega-Event-System | pc_cep_events_repository
|
Log and miscellaneous tables |
| Pega-Event-System-Action | pc_cep_events_repository
|
Log and miscellaneous tables |
| Pega-Portal- | pr_portal_state
|
Log and miscellaneous tables |
Database Table Instance |
PegaRULES table |
Additional information |
| Rule- | pr4_rule
|
Tables for rules |
| Rule-Application-Requirement | pr4_rule_requirement
|
Tables for rules |
| Rule-Application-UseCase | pr4_rule_usecase
|
Tables for rules |
| Rule-AutoTest- | pr4_rule_autotest
|
Tables for rules |
| Rule-Category | pr4_rule_shortcut
|
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-RuleSet- | pr4_rule_ruleset
|
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-AppCentric-Cache-Dependency | pr_sys_appcache_dep
|
System tables
|
| System-AppCentric-Cache-Entry | pr_sys_appcache_entry
|
System tables
|
| System-AppCentric-Cache-Shortcut | pr_sys_appcache_shortcut
|
System tables
|
| System-ApplicationRuleSetIndex | pr_sys_app_ruleset_index
|
System tables
|
| 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_decchg
|
System tables
|
| System-Job-PropertyOptimization | pr_sysjobs
|
System tables
|
| System-Locks | pr_sys_locks
|
System tables
|
| System-Queue- | pr_sys_queue
|
System tables
|
| System-Queue-ColumnPopulation | pr_sys_queue_col_pop
|
System tables
|
| System-Queue-Events | pr_cep_events_queue
|
Log and miscellaneous 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-ServiceLevel | pr_sys_queue_sla
|
System tables
|
| System-Queue-StartingFlows | pr_sys_queue_startflows
|
System tables
|
| System-Queue-TestSuite | pr_sys_queue_autotest
|
System tables
|
| System-Requestor-Context | pr_sys_context
|
System tables
|
| System-RuleSet-Index | pr_sys_ruleset_index
|
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 items |
| Work-ProcessEmail | pc_Work_ProcessEmail
|
Tables for work items |
| Pega-DM-Batch-Work | pc_work_dsm_batch
|
Tables for work items |
| PegaAccel- | pc_work_accel
|
Tables for work items |
| Pega-Event | pc_events | Tables for work items |
| Pega-Portal- | pr_portal_state
|
System tables |
| PegaSample | pc_work
|
Tables for work items |
| PegaForecaster | pc_work
|
(Not used) |
pegaam_alert
|
Part of AES. Unused unless AES is installed. | |
pegaam_log_usage
|
Part of AES. Unused unless AES is installed. | |
| Pega-CEP-Subscription | pr_cep_user_subscriptions
|
Tables for Business Event Definition subscriptions |
| Pega-Event-System | pc_cep_events_repository
|
Tables for Business Event Definitions |
| Pega-Event-System-Action | pc_cep_events_repository
|
Tables for actions related to Business Event Definitions |
| Pega-ScheduledTask | pc_schedule_task
|
scheduled task, Tables for work items |
| Pega-DM-Batch-Work | pc_work_dsm_batch
|
Table for DSM work objects. See Decisioning category — Batch runs landing page. |
| (none) | pr_other
|
Table of last resort. |
|
Working with the PegaRULES database
Working with the PegaRULES database — Common data management tasks Working with the PegaRULES database — Schema changes |
About Database Table data instances
Atlas — Initial Data Instances