Enterprise Performance Management (EPM) uses tables to display information. This article lists key information about refresh schedules, table joins, and more. Select from the list below to learn more.
- Bi-weekly table refresh schedule (PDF) - Most EPM tables are refreshed nightly, Sunday through Friday. Some payroll tables are refreshed on a bi-weekly schedule.
Table joins
- Joining tables (XLS) - Provides an example of how to join tables on indexes.
- Financials table joins (XLS) - Graphical chart listing which Financials tables can be joined and which indexes to use.
- Human capital management (HCM) table joins (XLS) - Graphical chart listing which HCM tables can be joined and which indexes to use.
- PC CA table joins (XLS) - Graphical chart listing which Project Costing and Contract tables can be joined and which indexes to use.
Table types
- Partitioned tables (PDF) - Lists Core-CT EPM partitioned table fields to use in query selection
- Reporting table to role mapping (XLS) - Find your EPM reporting table or security access node. Find which access group you are assigned.
- Table indexes (XLS) - Lists EPM reporting table indexes to be used in query joins, criteria, and sorting.
More Resources