Interfaces

Scenario Copy Screen

Overview

The Scenario Copy Interface allows for movements of Budget Versions and related Budget Plans across different Scenario’s. This interface can be used at the start of each Fiscal Period to begin the budgeting process for a new budget cycle as it enables the Budget Manager to copy previous year’s information such as business parameters, Budget Ceilings, Budget Structures and Budget Versions to the new Scenario.

 

Navigation

Budget Planning ► Interfaces ► Scenario Copy Screen

 

Scenario Copy Screen Fields

Field

Description

Source Scenario

Scenario ID, selected by users, from the list of Scenarios allowed by the user security.

Source Scenario Name

Brief description of the source scenario selected by the user.

Destination Scenario Type

Type of Scenario Copy.  Default is “Copy to New Scenario”.  Possible values are “Copy to new Scenario”, and “Copy to existing Scenarios”.

Destination Scenario ID

Destination Scenario ID manually entered by the user if the System Parameter Generate Scenario ID is set to false and Destination Scenario Type is set to “Copy to new scenario”.

Destination Scenario Name

Brief description of the destination scenario, entered by users.  This field is only required if Destination Scenario Type is set to “Copy to new scenario”.

Destination Scenario

Scenario selected by the user, if Destination Scenario Type is set to “Copy to existing scenario”.

Copy Parameters

If checked, the Copy Scenario Process will copy all active records of the Scenario Parameter that correspond to the Source Scenario.

Copy Ceilings

Possible values are: “No”, “From Budget Ceilings”, “From Budget Lines”. If set to “No”, the Budget Ceilings are not copied from the Source Scenario. If set to “From Budget Ceilings”, the Copy Scenario Process will copy all active records of Budget Ceilings from the Source Scenario. If set to “From Budget Lines”, the Copy Scenario Process will create Budget Ceilings from the Budget Lines of the selected Source Budget Plans.

Ceilings Source COA Group

COA Group with “Apply for Ceilings” set to True, from the Source Scenario. This field is only visible if Copy Ceiling is set to “From Budget Lines”.

Ceilings Source Budget Version

Budget Version selected from the Source Scenario, if Copy Ceiling is set to “From Budget Lines”.

Ceilings Destination COA Group

For each Source COA Group, a Destination COA Group should be specified, from the list of COA Groups of the Destination Scenario, if Destination Scenario Type is set to “Copy to existing Scenario”, or from the list of COA Groups of the Source Scenario, if Destination Scenario Type is set to “Copy to new Scenario”.

Copy Budget Plan Structure

If checked, the Copy Scenario Process will copy all records of Budget Plan Structure, associated to the selected Source Scenario. This field is only visible if Destination Scenario Type is set to “Copy to a new Scenario”.

Copy Budget Versions

If checked, the Copy Scenario Process will copy the selected Budget Versions, and Budget Plans that belong to the selected Budget Version(s).

Copy Budget Plan

If checked, the Copy Scenario Process will copy the selected Budget Plans from the Source Fiscal Year to the Destination Fiscal Year.  This field is only visible if Destination Scenario Type is set to “Copy to Existing Scenario”.

Allow Copy Between Different Budget Plan Structures

If checked, the user will need to specify the Source COA Group and the Destination COA Group for the Budget Plan Structure.  This field is only visible if Destination Scenario Type is set to “Copy to existing Scenario”, and Copy Budget Plan Structure is set to False.

Source Budget Versions Tab

Users could select one or more Budget Version, associated with the Source Scenario. This information is required if Copy Budget Versions is set to True, or Copy Budget Plans is set to “True”.

Copy All Fiscal Years

If checked, the Copy Scenario Process will copy all Fiscal Years of the Source Budget Version, for a specified Destination Budget Version. This field is only visible if Copy Budget Versions is set to TRUE, or Copy Budget Plans is set to True.

Copy all Source Fiscal Years for all Budget Versions

If checked, the Copy Scenario Process will copy all Fiscal Years, from all Source Budget Versions. This field is only visible if Copy Budget Versions is set to TRUE, or Copy Budget Plans is set to True.

Ceilings Source Budget Plans Tab

From the Budget Version listed under Ceilings Source Budget Version", the system allows the selection of one(1) or more Budget Plans associated with the "Ceilings Source COA Group" selected.

Source and Destination Coa Groups Tab

This allows users to select a Source COA group from a list showing all COA groups attached to the Source Scenario and a Destination COA Group from a list showing all COA groups attached to the Destination Scenario. This information is required if Allow Copy Between Different Budget Plan Structures is set to True.

Source and Destination Fiscal Year Tab

This allows the user to select one Destination Fiscal Year for each Source Fiscal Year. This tab is only visible if Copy All Fiscal Years is set to False.

 

Source Budget Versions

Overview

Users could select one or more Budget Version, associated with the Source Scenario. This information is required if Copy Budget Versions is set to True, or Copy Budget Plans is set to “True”.

 

Source Budget Versions Tab screen Fields

FieldDescription
Source Budget VersionUnique identification code representing the source budget version.
Source Budget Version NameUnique identification code representing the source budget version name.
LanguageCountry specific language to be used.
Destination Budget VersionFor each Source Budget Version, Users should select a Destination Budget Version of the Destination Scenario.
Destination Budget Version nameDestination Budget Version Name of the selected Destination Budget Version.
Source Budget Plans TabFor each Source Budget Version, users should select Budget Plans. The user can select only Budget Plans that that user has access to, within the selected Budget Version.

 

Source and Destination Fiscal Year

Overview

This allows the user to select one Destination Fiscal Year for each Source Fiscal Year. This tab is only visible if Copy All Fiscal Years is set to False.

 

Source and Destination Fiscal Year Tab screen Fields

FieldDescription
Source Fiscal YearUsers can select one (1) or more Fiscal Years for each selected Budget Version, from the list of Fiscal Years of the Source Budget Version
Destination Fiscal YearFor each Source Fiscal Year, Users should select the corresponding Destination Fiscal Year, from the list of Fiscal Years of the selected Destination Budget Version.

 

Planning To Planning

Overview

The Planning to Planning Interface is used to copy Budget information from one version to another. This interface is used throughout the lifecycle of the budget preparation process to copy information from one version to another to maintain full traceability of the evolution of the budget. For Instance, when a Budget Version has been completed (or Frozen), the Budget Manager or Officer could copy its content to a new Version using the Planning to Planning Interface to prepare for the next phase of the budget cycle.

 

Naviagation

Budget Planning ► Interfaces ► Planning to Planning

 

Planning To Planning screen Fields

Field

Description

Budget Version

The Budget Version from which users wants to copy the budget records.

Destination Budget Version ID

Identifier code for each Destination Budget Version.

Destination Budget Version Name

Destination Budget Version Name to be entered by users within same Scenario as the Source Budget Version. The name is to be entered manually if the Budget Version is new, only.

Destination Budget Version

The Budget Version of the Destination Budget Version, if existing, should be selected from the list of Budget Version within the same scenario as the Source Budget Version.

Copy Budget Version only

If this box is checked it creates a new Budget Version record under the Budget Version Entity, without copying the Budget Plan(s).

Copy/Modify Budget Plan(s)

Possible values are 'None', 'All', 'Specific Budget Plan(s)' for the Source Budget Version and the Source Fiscal Year, as defined by the Configuration Matrix.

Copy to same COA groups as source COA groupsIndicates if same CoA Group will be copied as source CoA Groups.

Copy Comments

If this box is checked, the comments in Budget Line related to each budget line, will be copied to the destination lines.

 

Import Budget Execution To Planning

Overview

The Import Budget Execution to Planning enables Budget Managers to copy Budget Execution details to a Budget Version. This can avoid significant data entry by automatically creating Budget Plans based on Budget Execution data. Execution data can be used to either create new records or modify existing ones by either using Actual Expenditures (AE), AE with Commitments or AE with Obligations, Current Amount or Original.

 

Navigation

Budget Planning ► Interfaces ► Import Budget Execution to Planning

 

Import Budget Execution To Planning screen Fields

Field

Description

Budget Control Type

A drop down menu displaying the list of Budget Control Type from Budget Distribution Control.

Fiscal Year

A drop down menu displaying the list of Fiscal Years.

Type Definition

Users could modify the default selection (all coding blocks) to select one or more Coding Block Expression.

Budget Plan Modification or Creation Option

Possible values are “Modification of an Existing Budget Plan(s)”, “Creation of a new Budget Plan within an existing Budget Version”, and “Creation of a new Budget Version”. Default is “Modification of Existing Budget Plan(s)”.

Budget Execution Data to Import

Possible Values are “YTD Actuals”, “YTD Actuals + Obligations” or “YTD Actuals + Commitments”, or "Current Amount", or "Original Amount".

Override Budget Lines Amount

Default is checked meaning that the Budget Line Amount of the Budget Lines with the same coding block as the source Budget Control will be overwritten. This parameter should only be visible if Budget Plan Modification or Creation Option is set to “Modification of an Existing Budget Plan”.

Budget Planning Scenario

The Scenario to which the Budget Execution information is imported.

Destination Scenario COA Group

Users should select one Destination COA Group, from the list of Scenario COA groups.

Budget Version ID

The Budget Version ID to which the Budget Execution information will be copied, selected from a drop­down menu displaying the Budget Version(s) with Status “In Budget Planning” of the Destination Scenario, if Budget Plan Modification or Creation Option is set to “Modification of existing Budget Plan” or “Creation of a new Budget Plan within an Existing Budget Version”.  The Budget Version ID is entered manually if Budget Plan Modification or Creation Option is set to “Creation of a new Budget Version”, if system parameter “Generate Budget Version ID is set to “False”.

Budget Version Name

The Budget Version Name associated to the selected Destination Budget Version ID or entered manually, if Budget Plan Modification or Creation Option is set to “Creation of a new Budget Version”.

Institution Tab

Users should select one or more Institutions from the list of Institutions from the Budget Plan Structure(s) of the Destination Scenario.

Budget Plan Tab

The Budget Plan to which the Budget Execution information will be copied, selected from a drop­down menu displaying the Budget Plan(s) with Status “Open”, and with the same COA group as the Destination Scenario COA Group, of the Destination Budget Version. This Tab is only required if Budget Plan Modification or Creation Option is set to “Modify an Existing Budget Plan”.

 

Budget Plan

Overview

The Budget Plan to which the Budget Execution information will be copied, selected from a drop­down menu displaying the Budget Plan(s) with Status.

 

Budget Plan Tab screen Fields

Field

Description

Code

Unique identification code representing the Budget Plan.

Status

Possible values are Open (by default), Completed, Under Analysis, Closed, Partially Sent for Execution, Fully Sent for Execution.

 

Institution

Overview

Users should select one or more Institutions from the list of Institutions from the Budget Plan Structure of the Destination Scenario.   This Tab is only required if Budget Plan Modification or Creation Option is set to “Creation of a New Budget Version” or “Creation of a new Budget Plan within an Existing Budget Version”.

 

Institution Tab screen Fields

Field

Description

Code

Unique identification code representing the Institution.

Description

Description of the Institution.

 

Import/ Copy Process Log

Overview

Import/Copy Process Log includes the Import and Copy Processes along with their execution status and list of rejected and successful transactions. It enables Budget Managers or Budget Officers to analyze import logs to identify the outcome of the transactions (Success, Rejected or Aborted).

 

Navigation

Budget Planning ► Interfaces ► Import/Copy Process Log

 

Import/Copy Process Log screen Fields

Field

Description

Serial Number

Unique identification code automatically assigned by the system.

Import/Copy Process

Possible values are: Budget Execution to Planning, Planning to Planning and Scenario Calculation.

Execution Status

The type of result. Possible Values are: "Successful Execution", "Execution with Rejected Transactions", "Aborted Execution".

Execution Date and Time

This represents the execution date and time.

User

Application User who performed the import/copy process.

Transaction Details Tab

Collection of 1 to N transactions, from the last Execution with rejected transactions or successful execution.

Comments Per Fiscal Year Parameter Tab

This includes the list of comments required during scenario calculation, when scenario parameters are applied.

 

Comments Per Fiscal Year Parameter

Overview

This includes the list of comments required during scenario calculation, when scenario parameters are applied.

 

Comments Per Fiscal Year Parameter Tab screen Fields

Field

Description

Serial Number

Application Number automatically assigned by the system.

Fiscal Year

User should select a Fiscal Year to which this parameter information will be used for.

Budget Planning Scenario Parameter

Displays the Scenario Parameter ID.

Budget Planning Scenario

Displays the Scenario ID.

 

Transaction Details

Overview

Collection of 1 to N transactions, from the last Execution with rejected transactions or successful execution.

 

Transaction Details Tab screen Fields

Field

Description

Serial Number

Application Number automatically assigned by the system.

Budget Version

Destination Budget Version ID.

Budget Version Name

Destination Budget Version Name.

Budget Plan

Destination Budget Plan ID.

Budget Plan Description

Destination Budget Plan Description.

Budget Line

Destination Budget Line ID.

Budget Line Description

Destination Budget Line Description.

Coding Block

Destination Budget Line Coding Block.

Other Message

Message assigned by the system to indicate successful completion.

Error Message

Error message assigned by the system.