Scenarios

Budget Planning Scenario

Overview

This is a container that allows to have several budget versions, sharing same ceiling structure (data can be different) and also same budget parameters.

A Budget Planning Scenario can be used for budget planning and also for forecasting purposes. A Budget Planning Scenario contains information about Budget Planning Scenario Fiscal Year that has the collection (one to many) of fiscal years allowed to each Scenario which can be used for scenario forecasting and also to accommodate concepts such as MTBF (Medium Term Budget Framework). It also contains a Budget Planning Scenario CoA Group that has the collection (one to many) of CoA groups allowed in each Scenario which will be used to establish the different levels of budget plans within the COA hierarchy.

 

Navigation

Budget Planning ► Support Entities ► Scenarios ► Budget Planning Scenario

 

Budget Planning Scenario Screen Fields and Tabs

Field

Description

Code

This is a unique identifier that is automatically assigned by the system, if the system parameter Generate Scenario ID is set to True, or manually entered by the user if the system parameter Generate Scenario ID is set to false.

Active

This field is true by default. If user switches this to FALSE then this scenario cannot be used in future transactions.

CoA

The User must select the CoA which is going to be used for this scenario.

Administrator

This is the user who acts as an administrator for this scenario who will have the permissions to manage administration functions related to the scenario.

Consolidated Amounts Distribution Type

This attribute will define type of propagation of changes of consolidated amounts.  Possible values are ‘Manual’ or ‘Automatic’. If this parameter is set to “Manual”, each budget plan responsible user will need to update the budget plan amounts, after a consolidated amount is modified. If the parameter is set to “Automatic”, the system will automatically propagate the changes of consolidated amounts to lower levels budget plans.

Fiscal Period Distribution Needed

The default value is FALSE. If this value is switched to true then the system will allow entering information at the fiscal period level. This distribution can be done in any moment of the budget planning process.

Rounding Value

Rounding value applied to Budget LIne Domestic Amount, Budget Line Foreign Amount and Budget Line Distribution Amount. 

Method of Rounding

Method of rounding.

Language

Country specific language that is used to describe the Budget Planning Scenario.

Name

The name of the Budget Planning Scenario.

Description

This contains the full description of the scenario.

Budget Planning Scenario Fiscal Year Tab

This contains the collection (one to many) of fiscal years allowed to each Scenario that can be used for scenario forecasting and also to accommodate concepts, such as MTBF (Medium Term Budget Framework).

Budget Planning Scenario CoA Group Tab

This contains the collection (one to many) of CoA groups allowed to each Scenario that will be used to establish the different levels of budget plans, with the COA hierarchy.

Fiscal Period Distribution Tab

This contains the collection of coding block expressions used for distribution if Fiscal Period Distribution Method is “Automatic Uniform” of “Automatic Weighted”, as well as the percentages used by the “Automatic Weighted” method.

Attachments Tab

This attribute is used to attach one or more files to detail features of the Scenario.

 

Budget Planning Scenario Fiscal Year

Overview

This contains the collection (one to many) of fiscal years allowed to each Scenario that can be used for scenario forecasting and also to accommodate concepts, such as MTBF (Medium Term Budget Framework).

 

Budget Planning Scenario Fiscal Year Tab screen Fields

Field

Description

Fiscal Year

This attribute will contain the Fiscal Year that is to be allowed in the Scenario.

Apply for Budget Planning

This is False by default. If it is switched to true then the fiscal year will be used for budget planning and also for forecasting purpose.

Budget Plans Read Only

If checkbox is not selected, Budget Line Detail Data Entry can be done for this Scenario Fiscal Year, otherwise the Budget Line Detail information is read-only.

Apply CeilingsThis is False by default.  If set to true,  the system will verify that each budget line entered manually or automatically is associated to a Budget Ceiling and Budget Line Coding Block should be validated when inserting a new Budget Line.

 

Budget Planning Scenario CoA Group

Overview

This contains the collection (one to many) of CoA groups allowed to each Scenario that will be used to establish the different levels of budget plans, with the COA hierarchy.

 

Budget Planning Scenario CoA Group Tab screen Fields

Field

Description

CoA Group

This is the reference to the CoA Group that is to be allowed in the Scenario.

Apply For Ceilings

The default value of this attribute is true. If this checkbox is not ticked, this CoA Group level won't be used for ceilings definition and validation, it will only be used for budget planning data entry.

Is Mandatory to Apply to All Budget LinesIt is to determine whether it will apply to all Budget Lines or not. Default value TRUE when "Apply for Ceilings?" is TRUE, otherwise FALSE. User can change to TRUE only when "Apply for Ceilings?" is TRUE.
Is Display Ceiling Amount In Validation MessageDefault is True meaning that the Ceiling Amount is included in the Ceilings Validation message. If set to False, the Ceiling Amount will not displayed in the Ceilings Validation message.

Lower Level CoA Group

This attribute is a circular reference to a different Scenario CoA Group which will be in the lower level.

Scale For Data Entry And Display Budget Ceilings
Close domain with possible values: 
"UNIT" - "1"
"TEN" - "10"
"HUNDRED" - "100"
"THOUSANDS" - "1000"
"TEN_THOUSANDS" - "10000"
"MILLION" - "1000000"
"BILLIONS" - "1000000000"
"TRILLIONS" - "1000000000000"
During data entry of Budget Ceiling, system will show scale to be used for data entry and display of Budget Ceiling amounts. If set to "THOUSAND - 1000", the Budget Ceiling Amounts will be in 1000. This is only for display, system should save in database amounts in units, and only use this parameter for data entry and display.
 

 

Attachments Tab

Overview

This attribute is used to attach one or more files to detail features of the Scenario.

 

Attachments Tab screen Fields

Field

Description

Id

An unique number auto generated by the system.

Attachment ClassificationTypes of attachment. Document Type like- PDF, Word, excel etc

Language

It represents the language of the document.

Title

Title of the document attached.

Description

This is defined by users and contains the description of the Attachment.

Attachment

The document to be attached is to be selected from the 'Browse' option.

Date Time

This shows the date and time of the last operation that has been performed on the attachment document.

DateManually enter by the user for the Attachment date.

User

This is the last user who have uploaded or updated the document.

Language

This is the language used in the attachment file.

 

Fiscal Period Distribution

Overview

This contains the collection of coding block expressions used for distribution if Fiscal Period Distribution Method is “Automatic Uniform” of “Automatic Weighted”, as well as the percentages used by the “Automatic Weighted” method.

 

Fiscal Period Distribution Tab screen Fields

Field

Description

Fiscal Year

Collection of 1 to many Scenario Fiscal Year(s).

CoA Group

This will contain a collection (one to many) of CoA groups allowed to each Scenario.

Coding Block Type Definition

Users need to enter either a coding block or an expression. Level of the mentioned coding block will be the lowest level defined in Scenario COA Group entity. A coding block expression will allow defining a group of coding blocks.

 

Distribution Concept Details

Overview

Distribution detail per each fiscal period.

 

Distribution Concept Details Tab screen Fields

Field

Description

Distribution Concept

Refers to the Distribution Concept.

Remaining

Indicates if the detail will distribute remaining amount.

Percentage

Value bewteen 1.00 to 100.00 with 2 decimals. The sum of this field for all concepts in this entity, and same scenario or Version can't exceed 100.00

 

Scenario Calculation Restricted Transfer

Overview

Restricted Transfer during Scenario Calculation.

 

Navigation

Budget Planning ► Support Entities ► Scenario ► Scenario Calculation Restricted Transfer

 

Scenario Calculation Restricted Transfer Screen Fields

Field

Description

Code

This represents the unique ID of a Scenario Transfer Restricted Transfer entity, which is generated automatically by the system or entered by the user.

CoA

Indicates whether this record is active or inactive.

Segment

Name of the Product.

Concept

A concept within the COA represents a collection of elements. Each segment must have 1 or more concepts.

Left Expression

 It will allow the user to enter an expression.

Right Expression

It will allow the user to enter an expression.

Language

Language used to describe Cost Driver Hierarchy to be selected from dropdown box.

Name

Name of the Cost Driver Hierarchy.

Description

Description of the Cost Driver Hierarchy.

 

Budget Planning Scenario Parameter

Overview

Budget Planning Scenario Parameter allows users to define scenarios with several parameters, such as Salaries, Exchange Rate, etc.

The Budget Planning Scenario Parameters is used by the scenario calculation process only. The "Application Oder" defines the order of calculation, during the scenario calculation. The parameters with Application Order set to 1 will be calculated first, then the parameters with Application Order set to 2, etc. The parameter per Fiscal Year includes the operator, and value that will be used by the calculation, for each scenario fiscal year. The Scenario Parameter per Fiscal Year includes the list of coding blocks associated to the result of the scenario calculation.

 

Navigation

Budget Planning ► Support Entities ► Scenarios ► Budget Planning Scenarios Parameter

 

Budget Planning Scenario Parameter screen Fields

Field

Description

Code

This is a unique identifier that is automatically assigned by the system.

Active

This is 'True' by default. If switched to 'False' then this parameter cannot be used in future transactions.

Language

The language used to describe the Budget Planning Scenario Parameter.

Name

The name of the Budget Planning Scenario Parameter.

Description

This consists of the full description of Budget Planning Scenario Parameter.

Budget Planning Scenario

Users must select the scenario to which the parameter is related with.

Institution

Institution to which the parameter applies.

CoA Group

COA Group of the Target Coding Block or Coding Block Expression.

Target Coding Block Expression

Target Coding Block Expression for which Scenario Calculation will be performed. Either Target Coding Block Expression or Budget Planning Scenario Parameter Coding Block can be specified, not both.

Application Order

This attribute indicates the order of application for this parameter during the scenario calculation.

Created By

Automatically assigned by the system with the user logged in.

Created Date

Automatically assigned by the system in which the user is logged in.

Updated by

Automatically assigned by the system with the user logged in.

Updated Date

Date when parameter is updated.

Budget Planning Scenario Parameter Per Fiscal Year Tab

The system automatically will populate one row per fiscal year of the selected scenario so then users will only enter the operator and value used for the calculation.

Comments Per Fiscal Year Parameter Tab

This contains the list of comments required during scenario calculation, if Comments required during execution is set to True.

Budget Planning Scenario Parameter Coding Block Tab

This contains the list of Source and Target coding blocks used for the scenario calculation. Either Target Coding Block Expression or Budget Planning Scenario Parameter Coding Block can be specified, not both.

 

Budget Planning Scenario Parameter Per Fiscal Year

Overview

The system automatically will populate one row per fiscal year of the selected scenario so then users will only enter the operator and value used for the calculation.

 

Budget Planning Scenario Parameter Per Fiscal Year Tab screen Fields

Field

Description

Operator

Operator to be used during the calculation. Possible values: + (addition), ­- (subtraction), * (multiplication), / (division).

Value

Value associated to the Operator.

Fiscal Year

Fiscal Year to which this parameter information will be used for.

Comment Required on ExecutionDefault value is false, if it is true then comment required on execution.

Language

Users can select the language to describe the entity.

Comment

Comment field to add information such as adjustment type, law, etc.

 

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 screen Fields

Field

Description

Serial Number

Application Number automatically assigned by the system.

Fiscal Year

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

 

Budget Planning Scenario Parameter Coding Block

Overview

This contains the list of Source and Target coding blocks used for the scenario calculation. Either Target Coding Block Expression or Budget Planning Scenario Parameter Coding Block can be specified, not both.

 

Budget Planning Scenario Parameter Coding Block Tab screen Fields

Field

Description

Serial Number

A unique number auto generated by the system.

CoA Group

This contains COA group of the Source and Target Coding Block.

Source Coding Block

Coding Block to be considered as source in the scenario calculation.

Target Coding Block

Coding Block where the scenario calculation result will be saved.

Target Parent of Partial Coding BlockFull parent coding block of pertial target coding block.

 

Calculate Scenario

Overview

Once a Budget Version is approved, it cannot be modified but can be copied to another active budget version with status as 'In preparation', using the “Planning to Planning” screen. Calculation is performed during the Budget Version Copy Process based on the parameters entered under the “Planning to Planning Screen”. If the Budget Version Status is “In Preparation” or “In Budget Planning”, a scenario calculation can be performed, by using the “Calculate Scenario” screen.

 

Navigation

Budget Planning ► Support Entities ► Scenarios ► Calculate Scenario

 

Calculate Scenario screen Fields

Field

Description

Budget Version

Users should select the Budget Version from the List of Budget Version allowed by the user security and with Status as “In Preparation” or “In Budget Planning”.

Scenario Coa Group

Users should select one Scenario COA group from the list of Scenario Groups of the Scenario of the selected Budget Version, for which calculation is done.

Create A New Budget Plan

If this is checked then a new Budget Plan will be created to save the calculated budget lines at the bottom level of the Budget Plan Structure, and the Institution Field will need to be populated by the User, from the list of Institution(s) the User has accessed to.

Show Results Before Apply

By default this is true.

Budget Plan Types

Users can select one or many Budget Plan Type(s). The Budget Plan Type is set to the selected Budget Plan Type from the calculation screen.

Scenario Parameters

Users should select one or more Scenario Parameters from a list of Scenario Parameters that user has access to and CoA Group of the Target Coding Block should be the same as the CoA Group selected.

Budget Plans

Users should select one or more Budget Plans, if Create A New Budget Plan is set to False. The Budget Plan should be selected from the list of Budget Plans belonging to the selected Budget Version.