Source, Staging and Target Tables for PeopleSoft Financial Management Data
This section lists the source PeopleSoft Financial Management Solutions (FMS) tables, and PeopleSoft EPM Warehouse Staging (OWS) and target Operational Warehouse Enriched (OWE) tables for financial management-related data. The use of target tables here refers to the records and tables that are used by the Planning and Budgeting application. In some cases, you might use online maintenance pages to access and update the data. The list is organized by:
General ledger records.
Dimension (ChartField) records.
Multiple currency records.
Asset budgeting records.
Commitment Control records.
Combination edit records.
General Ledger Records
Financial Management Solutions Source Table |
Description |
Staging (OWS) Table |
Target (OWE) Table |
---|---|---|---|
PS_BU_LED_COMB_TBL |
Ledger group combo edit definition |
PS_S_BU_LED_CB_TBL |
PS_BU_LED_COMB_TBL |
PS_BU_LED_GRP_TBL |
Ledger group for business unit definition |
PS_S_BU_LED_GR_TBL |
PS_BU_LED_GRP_TBL |
PS_BUS_UNIT_TBL_GL |
General ledger business units |
PS_S_BUS_UNIT_GL |
PS_BUS_UNIT_TBL_GL |
PS_BUS_UNIT_TBL_FS |
Financial business units |
PS_S_BUS_UNIT_FS |
PS_BUS_UNIT_TBL_FS |
PS_CAL_BP_TBL |
Calendars for Commitment Control budget periods |
PS_S_CAL_BP_TBL |
PS_CAL_BP_TBL |
PS_CAL_DEFN_TBL |
Detail and budget period calendar definition |
PS_S_CAL_DEFN_TBL |
PS_CAL_DEFN_TBL |
PS_CAL_DETP_TBL |
Detail calendar period details |
PS_S_CAL_DETP_TBL |
PS_CAL_DETP_TBL |
PS_LED_DEFN_TBL |
Detail ledger definition |
PS_S_LED_DEFN_TBL |
PS_PF_LED_DEFN_TBL |
PS_LED_GRP_LED_TBL |
Ledger group / detail ledger definition |
PS_S_LEDGRPLEDTBL |
PS_PF_LED_GRP_LED |
PS_LED_GRP_TBL |
Ledger group definition |
PS_S_LED_GRP_TBL |
PS_PF_LED_GRP_TBL |
PS_LEDGER |
Actuals ledger |
PS_LEDGER |
PS_LEDGER_F00 |
PS_LEDGER_BUDG |
Standard budget ledger |
PS_LEDGER_BUDG |
PS_BP_LED_BUDG_F00 |
PS_LEDGER_PROJ |
Project budget ledger |
PS_LEDGER_PROJ |
PS_BP_LED_PROJ_F00 |
Note: There are no ETL jobs or maps for the Ledger Template records (PS_PF_TMPLT_TBL, PS_BP_TMPLT_TBL, and PS_GC_TMPLT_TBL) which are delivered as system data. If your organization uses different names, you can create new ledger template definitions in the EPM database.
Note: PeopleSoft Planning and Budgeting provides portal navigation that takes you directly to the Ledger For A Unit page within PeopleSoft Financial Management Solutions (FMS) where you can view setup information. Edit access in FMS is only allowed if your security permits it, but any changes would require you to rerun the map for the PS_BU_LED_GRP_TBL record.
This page does not exist in the EPM database, but the data is used in PeopleSoft Planning and Budgeting and is brought over during the ETL process. Use the Ledger For A Unit (FMS) link to view and understand data relationships; for example, if you are using combination editing and need to understand valid combination edit groups, scroll down to the budgeting ledger for your business unit, and then click Journal Edit Options. You can then determine the Combination Edit Process Groups that will be validated for that ledger. To access the Ledger For A Unit (FMS) link, navigate from menu. You must have single sign on set up to use this link.
Dimension (ChartField) Records
FMS SourceTable |
Description |
Staging (OWS) Table |
Target (OWE) Table |
---|---|---|---|
PS_ADJUST_TYPE_TBL |
Adjust Type |
PS_S_ADJ_TYPE_TBL |
PS_ADJUST_TYPE_TBL |
PS_ALTACCT_TBL |
Alternate account |
PS_S_ALTACCT_TBL |
PS_ALTACCT_TBL |
PS_BD_SCENARIO_TBL |
Scenario-Budget |
PS_S_BD_SCEN_TBL |
PS_BD_SCENARIO_TBL |
PS_BOOK_CODE_TBL |
Book code |
PS_S_BOOK_CODE_TBL |
PS_BOOK_CODE_TBL |
PS_BUD_REF_TBL |
Budget reference |
PS_S_BUD_REF_TBL |
PS_BUD_REF_TBL |
PS_CHARTFIELD1_TBL |
ChartField 1 |
PS_S_CF1_TBL |
PS_CHARTFIELD1_TBL |
PS_CHARTFIELD2_TBL |
ChartField 2 |
PS_S_CF2_TBL |
PS_CHARTFIELD2_TBL |
PS_CHARTFIELD3_TBL |
ChartField 3 |
PS_S_CF3_TBL |
PS_CHARTFIELD3_TBL |
PS_CLASS_CF_TBL |
Class field |
PS_S_CLASS_CF_TBL |
PS_CLASS_CF_TBL |
PS_DEPT_TBL |
Department |
PS_DEPT_TBL |
PS_DEPARTMENT_TBL |
PS_FUND_TBL |
Fund code |
PS_S_FUND_TBL |
PS_FUND_TBL |
PS_FS_ACTIVITY_TBL |
Activity |
PS_FS_ACTVTY_TBL |
PS_FS_ACTIVITY_TBL |
PS_GL_ACCOUNT_TBL |
Account |
PS_S_GL_ACCT_TBL |
PS_GL_ACCOUNT_TBL |
PS_OPER_UNIT_TBL |
Operating unit |
PS_OPER_UNIT_TBL |
PS_OPER_UNIT_D00 |
PS_PC_INT_TMPL_GL |
Integration template GL (used for Project Costing integration) |
PS_S_PC_INT_TML_GL |
PS_PC_INT_TMPL_GL |
PS_PRODUCT_TBL |
Product |
PS_S_PRODUCT_TBL |
PS_PRODUCT_TBL |
PS_PROGRAM_TBL |
Program code |
PS_S_PROGRAM_TBL |
PS_PROGRAM_TBL |
PS_PROJECT |
Project |
PS_PROJECT |
PS_PROJECT_D00 |
PS_PROJ_ACTIVITY |
Project activity |
PS_S_PROJ_ACTIVITY |
PS_PROJ_ACTIVITY |
PS_PROJ_ANTYPE_TBL |
Analysis type |
PS_S_PROJ_ANTP_TBL |
PS_PROJ_ANTYPE_TBL |
PS_PROJ_CATG_TBL |
Resource category |
PS_S_PROJ_CATG_TBL |
PS_PROJ_CATG_TBL |
PS_PROJ_RES_TYPE |
Resource type |
PS_S_PROJ_RES_TYPE |
PS_PROJ_RES_TYPE |
PS_STAT_TBL |
Statistics code |
PS_S_STAT_TBL |
PS_STAT_TBL |
PS_PROJ_SUBCAT_TBL |
Resource subcategory |
PS_S_PROJ_SCAT_TBL |
PS_PROJ_SUBCAT_TBL |
Note: You must ensure that the department data you load into the OWE target table (PS_DEPARTMENT_TBL) in the Enterprise Performance Management (EPM) database is the data that you want to use for planning and budgeting purposes. The ETL map you use to populate the PS_DEPARTMENT_TBL table with PeopleSoft HRMS department data is the same one used to populate the table with PeopleSoft Financial Management department data. This is because the respective ETL jobs for source HRMS and Financial Management department data store data in the same OWS table.
When the departments are the same in your HRMS and Financial Management source, choose one source to run your ETL job.
When the departments are unique for your HRMS and Financial Management source, run the ETL jobs from each source. Since the departments are unique, you will not be required to use Dimension Mapper.
Note: Planning and Budgeting does not use the PF_SCENARIO_DFN page or ETL maps; instead it supports scenarios from the PS_BD_SCENARIO_TBL source and target table, and any scenarios defined within the EPM database on the Scenario-Budget maintenance page.
Note: The budget ledgers used by Planning and Budgeting include three additional dimensions called Dimension 1, Dimension 2, and Dimension 3. These fields in the budget ledgers have no source record, are not stored in the source budget ledgers, and don't have any maintenance page; therefore, no ETL jobs are delivered for these dimensions. These fields (DIMENSION1, DIMENSION2, and DIMENSION3) can only be found in the following budget ledger records: PS_BP_LED_BUDG_F00, PS_BP_LED_PROJ_F00, and PS_BP_LED_KK_F00.
See Configuring Dimensions for Planning and Budgeting.
See Setting Up Single Sign On.
Note: PeopleSoft Planning and Budgeting uses the PS_PRODUCT_TBL table within the application, which is referred to as the Product-General Ledger menu item for maintenance. Planning and Budgeting does not use the PRODUCT_ID field in the PS_PRODUCT_D00 table in the EPM database.
Multiple Currency Records
FMS Source Table |
Description |
Staging (OWS) Table |
Target (OWE) Table |
---|---|---|---|
PS_RT_INDEX_TBL |
Rate index |
PS_S_RT_INDEX_TBL |
PS_RT_INDEX_TBL |
PS_RT_RATE_TBL |
Market rate |
PS_S_RT_RATE_TBL |
PS_RT_RATE_TBL |
Asset Budgeting Records
FMS Source Table |
Description |
Staging (OWS) Table |
Target (OWE) Table |
---|---|---|---|
PS_BD_ASSET |
Assets |
PS_S_BD_ASSET |
PS_BD_ASSET |
PS_BD_ASSET_DEPR |
Actual budget depreciation |
PS_S_BD_ASSET_DEPR |
PS_BD_ASSET_DEPR |
PS_BD_ASSET_ITEMS |
Asset catalog |
PS_S_BD_ASSET_ITEM |
PS_BP_ASSET_ITEMS |
PS_BU_BOOK_TBL |
Asset book |
PS_S_BU_BOOK_TBL |
PS_BU_BOOK_TBL |
PS_BUS_UNIT_TBL_AM |
Business units related to assets |
PS_S_BUS_UNIT_AM |
PS_BUS_UNIT_TBL_AM |
PS_CAP |
Capital acquisition plans |
PS_S_CAP |
PS_CAP |
PS_CAP_DET |
Capital acquisition plan details |
PS_S_CAP_DET |
PS_CAP_DET |
PS_CAP_TYPE_TBL |
Capital acquisition plan types |
PS_S_CAP_TYPE_TBL |
PS_CAP_TYPE_TBL |
Commitment Control Records
FMS Source Table |
Description |
Staging (OWS) Table |
Target (OWE) Table |
---|---|---|---|
PS_BUL_CNTL_BUD |
Commitment Control ledger group definition |
PS_S_BUL_CNTL_BUD |
PS_BUL_CNTL_BUD |
PS_KK_ACT_TYPE_SET |
Commitment Control type |
PS_S_KK_ACT_TYPE_S |
PS_KK_ACT_TYPE_SET |
PS_KK_BD_DFLT_ACCT |
Commitment Control default accounts |
PS_S_KK_BD_DFLT_AC |
PS_KK_BD_DFLT_ACCT |
PS_KK_BD_SETID |
Commitment Control SetID |
PS_S_KK_BD_SETID |
PS_KK_BD_SETID |
PS_KK_BUDGET_TYPE |
Commitment Control budget type |
PS_S_KK_BUDGET_TYP |
PS_KK_BUDGET_TYPE |
PS_KK_CF_VALUE |
Commitment Control ChartField values |
PS_S_KK_CF_VALUE |
PS_KK_CF_VALUE |
PS_KK_EX_ACCT_TYPE |
Commitment Control excluded account types |
PS_S_KK_EX_ACCT_TY |
PS_KK_EX_ACCT_TYPE |
PS_KK_EX_ACCT_VAL |
Commitment Control excluded account values |
PS_S_KK_EX_ACCT_VL |
PS_KK_EX_ACCT_VAL |
PS_KK_FILTER |
Commitment Control budget subtype filter |
PS_S_KK_FILTER |
PS_KK_FILTER |
PS_KK_KEY_CF |
Commitment Control keys |
PS_S_KK_KEY_CF |
PS_KK_KEY_CF |
PS_KK_SUBTYPE |
Commitment Control budget subtype |
PS_S_KK_SUBTYPE |
PS_KK_SUBTYPE |
PS_LEDGER_KK |
Commitment Control budget ledger |
PS_LEDGER_KK |
PS_BP_LED_KK_F00 |
Combination Edit Records
FMS Source Table |
Description |
Staging (OWS) Table |
Target (OWE) Table |
---|---|---|---|
PS_COMBO_CF_DEFN |
Combination edit definitions |
PS_S_COMBO_CF_DEFN |
PS_COMBO_CF_DEFN |
PS_COMBO_CF_TBL |
Combination edit tables |
PS_S_COMBO_CF_TBL |
PS_COMBO_CF_TBL |
PS_COMBO_CF2_REQ |
Nonanchor ChartFields |
PS_S_COMBO_CF2_REQ |
PS_COMBO_CF2_REQ |
PS_COMBO_CF2_TBL |
Combination edit tables |
PS_S_COMBO_CF2_TBL |
PS_COMBO_CF2_TBL |
PS_COMBO_DATA_BDP |
Combination edit data table |
PS_S_COMBO_DAT_BDP |
PS_COMBO_DATA_BDP |
PS_COMBO_DATA_BUDG |
Combination edit data table |
PS_S_COMBO_DAT_BUD |
PS_COMBO_DATA_BUDG |
PS_COMBO_EDIT_TMPL |
Combination edit template |
PS_S_COMBO_EDIT_TPL |
PS_COMBO_EDIT_TMPL |
PS_COMBO_FLDS_TBL |
Combination edit ChartFields |
PS_S_COMBO_FLDS |
PS_COMBO_FLDS_TBL |
PS_COMBO_GROUP_TBL |
Combination edit groups |
PS_S_COMBO_GROUP |
PS_COMBO_GROUP_TBL |
PS_COMBO_GRRUL_TBL |
Combination edit group rules |
PS_S_COMBO_GRRUL |
PS_COMBO_GRRUL_TBL |
PS_COMBO_RULE_TBL |
Combination edit rules |
PS_S_COMBO_RULE |
PS_COMBO_RULE_TBL |
PS_COMBO_SEL_01 through PS_COMBO_SEL_30 |
Main selector tables |
PS_S_COMBO_SEL_01 through PS_S_COMBO_SEL_30 |
PS_COMBO_SEL_01 through PS_COMBO_SEL_30 |
PS_COMBO_VAL2_TBL |
Combination edit tables |
PS_S_COMBO_VAL2_TBL |
PS_COMBO_VAL2_TBL |