Tables Used to Move Data From Planning and Budgeting Back to Source Systems
After you have exported the data out of the planning model, you can use the ETL tool to move the data from Planning and Budgeting back to the source systems.
See Understanding Exporting General Ledger Budget Data from the Planning Model.
See Export to HR Page.
Records Used To Send Data Back to Financial Management System
|
Planning and Budgeting OWE Record |
Description |
FMS Record |
|---|---|---|
|
PS_BP_LEDGER_BDEXP |
Budget ledger data (standard, Project Costing, Commitment Control). |
PS_BP_LEDGER_BDEXP |
|
Note: There is no OWE Source Record, but rather a view that is used by the ETL job to move the budget ledger data attribute information to general ledger for processing (PS_BP_LEDG_DTL_VW). |
Attributes for budget ledger data. |
PS_BP_LEDG_DTL_EXP |
Records Used to Send Data Back to Human Resources Management System
|
Planning and Budgeting OWE Record |
Description |
HRMS Record |
|---|---|---|
|
PS_BP_POSITION_F00 |
Position data |
PS_BP_POSITION_EXP |
|
PS_BP_JOB_F00 |
Job data. |
PS_BP_JOB_EXP |
|
PS_BP_COMP_F00 |
Compensation distribution for HR data (salary, benefits, earnings, taxes). |
PS_BP_SAL_DIS_EXP PS_BP_BNFT_DIS_EXP PS_BP_EARN_DIS_EXP PS_BP_TAX_DIS_EXP |
Note: For the PS_BP_COMP_F00 source record in the OWE for Planning and Budgeting, the ETL jobs to export data to HRMS use views to extract compensation distributions by category, they include: PS_BP_SAL_DIS_VW, PS_BP_BNFT_DIS_VW, PS_BP_EARN_DIS_VW, and PS_BP_TAX_DIS_VW.