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 select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers 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