Overview:
Navigation:
Human Capital ►Payroll and Financial ►Budget Import ► Budget
Budget screen fields:
Fields | Description |
COA Group | Read-only. The COA Group for Budget Entry. It will display the active COA Group for Budget Preparation Level. |
CodingBlock | Refers to the Coding Block associated to the Budget |
Language | Select the language used in the screen. |
Description | Description of the budget. |
Initial Budget | Initial amount of the Budget. The amount is the sum of the Initial budget entered in the Details Tab. This field is Readonly |
Revised Budget | Revised amount of the budget. The amount is the sum of the revised Budget entered in the Details Tab. This field is Readonly. |
Budget Details Tab | Displays the details of the budget per fiscal period. |
Budget Items
Fields | Description |
Accounting Period | Accounting Fiscal Period |
Initial Budget | Initial Budget |
Revised Budget | Updated when the Budget Import selected is 'Revised Only' |
Overview
Budget Import features the ability to upload budget transactions into the Human Capital module from the financial system.
Once the budget extract file has been created, the budget information can be imported into Human Capital using the Budget Import menu option.
Navigation
Human Capital ► Payroll and Financial ► Budget Import ► Budget Import
Budget Import Screen Fields
Fields | Description |
Budget Import Type | Options are: Initial and Revised or Revised Only |
Upload file | A field to upload the Budget Import txt File. |
Overview
Navigation
Human Capital ► Payroll and Financial ► Budget Import ► Budget Import Log
Budget Import Log screen Fields
Fields | Description |
Application Id | Unique identifier of the Log, generated by the system. |
File Name | Name of the imported file. |
Log Date Time | Date and Time at which the file was imported, generated by the system. |
Imported By | Automatically populated by the system. Corresponds to the User who imported the file. |
Transactions Received (Nbr) | Number of body transactions in the imported files. |
Transactions Received (Revised Amount) | Monetary value of all transaction lines contained in the imported file (Revised Amount). |
Transactions Loaded (Nbr) | Number of body transactions successfully Imported in HcBudget and HcBudgetDetail from the imported file. |
Transactions Loaded (Revised Amount) | Monetary value of all transaction lines successfully Imported in HcBudget and HcBudgetDetail from the imported file (Revised Amount) |
Transactions Rejected (Nbr) | Number of body transactions rejected and not imported in HcBudget and HcBudgetDetail from the imported file. |
Transactions Rejected (Revised Amount) | Monetary value of all transaction lines rejected and not imported in HcBudget and HcBudgetDetail from the imported file (Revised Amount) |
Interface | Interface to which the Budget Import Log Applies (BudgetImport). |
Budget Import Log Detail Tab | This tab includes detailed information on the Budget Import file. It contains the status of each Budget Transaction line imported. |
Overview
This entity is executed from the Commitments Export form.
Navigation
Human Capital ► Payroll and Financial ► Commitments Export ► Commitments Export
Commitments Export Screen Fields
Fields | Description |
Interface | Drop down list displays the interface definition name. |
Export Type | |
Transaction Type | Drop down list displays the transaction type possible values are "summarized", "Detailed" |
Filename to Export |
Overview
It includes the Generated Commitments Details from the Employee Assignment(s) included in the Commitment Generation Calculation.
Navigation
Human Capital ►Payroll and financial ►Commitments Generation ►Generated Commitment
Generated Commitment screen Fields
Fields | Description |
Code | Unique Identification Code for each record |
Commitment ID | Commitments Generation Definition unique identifier generated by the system. |
Fiscal Year | It contains the different fiscal years registered within the system |
Is Soft Commitment | Generated indicator of Soft Commitment. |
Employee ID | Display the unique identifier code of the employee. |
Employee Last Name | Display the last name of the employee. |
Employee First Name | Display the first name of the employee. |
Commitment Coding Block | It displays the Collection of 1 or many elements (including the sequence) that conform the commitment coding block. |
Institution | This is an organization unit. Security is driven by this field depending which institution is granted to the user in the user security. |
Generated Amount | Calculated Commitment Amount for the Commitment ID. |
Adjustment Amount | Commitment adjustment amount, entered by the user. |
Adjustment Description | Short description of Commitment Adjustment. |
Commitment Amount | It is calculated by the summation of generated amount and adjustment amount. |
Excluded From Export | If checked the user, this Commitment will be excluded from the Commitment Export. |
Reference Date | Reference Date of the Commitment Generation |
Generation Date | Commitments Generation Date, generated by the system. |
Generation Time | Commitments Generation Time, generated by the system. |
Last Export Amount | Calculated last Commitments Export Amount for Generated Commitment. |
Last Export Date | Last Commitments Export Date, for Generated Commitment. |
Active | If unchecked, the Generated Commitments is not available. |
Action | Action taken by the Commitments Generation Process. Possible values are "Add", "Delete" and "Modify". |
Overview
Generated commitment log includes the list of Generated commitments exported.
Navigation
Human Capital ►Payroll and financial ►Commitments Generation ►Generated Commitment Log
Generated Commitment Log screen Fields
Fields | Description |
Code | Unique Identification Code for each record |
Generation Date | Corresponds to the date of last generation. |
Export Date | Date at which the file was exported, generated by the system. |
Number of Transactions | Number of transactions in the exported files. |
Value | This field corresponds to the monetary value of all transaction lines that are exported or sent to Financials corresponds to commitment amount of Generated Commitment. |
Status | Current status of the file. Possible values are:"In Process", "Exported", and "Cancelled". "In Process" implies that the file is currently being executed. "Exported" implies that the file was exported. |
Active | If unchecked the Log is not available. |
Overview
This entity includes the method of calculation and roll-up concepts used. Only one Commitments Generation Definition is allowing per fiscal year.
Navigation
Human Capital ► Payroll and Financial ►Commitment Generation ► Support Entities ►Commitment Generation Definition
Commitment Generation Definition screen Fields
Fields | Description |
Code | Unique Identification Code for each record |
Fiscal Year | It is important to notice that only one Fiscal Year can have Current Fiscal Year for Budget Execution as true. Such Fiscal Year will be defaulted by the system in every transaction where Fiscal Year is needed. User can temporary change the Fiscal Year that needs to work on (when for some reason there is more than one Fiscal Year Open for Budget Execution), but it can be done only through a specific process and such change will remain only for that specific user and only for that specific session. |
Method Of Calculation | Method of Calculation for Commitments Generation. Possible values are: "Accruals + Forecasts to Year-End", "Full-Year Forecasts", "Actual Expenditures + Forecasts to Year-End", and "Forecasts to Year-End". |
Accruals Method Of Calculation | Possible values are “Accruals Between – 2 Dates”,” Accruals Cumulative”, ”Accruals Generation in Situation”, ”Accruals in Reports in Situation” |
Include Global Costs | Default is false implying that the Global Costs are not included in the Commitments calculation. If set to true, by the user, the Global Costs will be included in the Commitments calculation. |
Group By | Selected from the list of concept that belongs to COA Group define for Commitment & Obligation. |
Commitment ID Prefix | Prefix used for the Commitment ID. The default prefix is SAL. |
Commitment ID Length | Length of the Commitment ID, including the Prefix. |
Maximum FCB Lines | Maximum number of FCB Lines for unique coding combination, per Commitment ID, as commitment calculations is based on assignment details. |
Active | If unchecked, the Commitments Generation Definition is not available. |
Reference Date | Reference Date of the Commitments Generation, entered by the user, under the Commitments Generation Screen. |
Last Generation Date | As generated by the system, of the last Commitments Generation. |
Last Reference Date | Reference Date of the last Commitments Generation. |
Last Commitments Amount | Calculated Total Commitments Amount of the last Commitments Generation. |
Overview
This entity is executed from the Forecasts Export form.
Navigation
Human Capital ► Payroll and Financial ► Forecasts Export ► Forecasts Export
Forecasts Export Screen Fields
Fields | Description |
Interface | Drop down list display interface definition name |
Export Type | Two options are available in the Export Type: "Pay Data" and "Manually Created JV's". The default should be "Pay Data" |
Transaction Type | Drop down list displays the transaction type |
Filename to Export | Pay Entitlement Code. The size is as per the size of the External Field corresponding to External Field Entitlement. |
Overview
This entity includes generated forecasts.
Navigation
Human Capital ► Payroll and Financial ► Forecasts Generation ► Generated Forecasts
Generated Forecasts Screen Fields
Fields | Description |
Application Id | Generated Forecasts unique identifier generated by the system. |
Fiscal Year | Read Only and hidden attribute.Generated by the Forecasts Generation Process. |
Coding Block | Coding Block Information |
Institution | User can change the value by selecting an Institution from the list of Institutions with Is Budget Office Organization Unit set to True. |
Employee | Read Only and populated by Employee ID, for Employee from HCS Employee Employee Assignment |
Last Name | Read Only. Employee Last Name. |
First Name | Read Only. Employee First Name. |
Generated Amount | Calculated Forecast Amount |
Adjustment Amount | Forecast adjustment amount, entered by the user. A positive or negative amount can be entered. The default amount is zero |
Adjustment Description | Forecast Adjustment Description/rationale entered by the user. |
Forecast Amount | Calculated (Read-only) Forecast Amount |
Excluded From Export | Default is False. If set to True by the user, this Forecast will be excluded from the Forecast Export. |
Reference Date | Read-only Reference Date of the Forecast Generation, as entered under Forecasts Generation Definition |
Generation Date | Read-only Forecasts Generation Date, generated by the system. Generated by the Forecasts Generation Process. |
Last Export Amount | Calculated (read-only) last Forecasts Export Amount for this Forecast. |
Overview
This Entity includes information (date, number of transactions and total amount) of the forecasts generation and export/send to financials.
Navigation
Human Capital ► Payroll and Financial ► Forecasts Generation ► Generated Forecasts Export Logs
Generated Forecasts Export Logs Screen Fields
Fields | Description |
Log Id | Unique identifier of the Log, generated by the system. |
Generation Date | Read-only field. Corresponds to the date of the last generation. |
Export Date | Date at which the file was exported, generated by the system. |
Number of Transactions | Number of transactions in the exported files. |
Value | Read-only field. For the forecasts send to execution functionality, this field corresponds to the monetary value of all transaction lines that are exported or sent to Execution |
From Batch No | Batch Numbers are attributed sequentially to all export lines. This field indicates the first batch number used for this export file. |
To Batch No | Only applicable if export files are used.This field indicates the last batch number used for the export file. |
Status | Current status of the file. Possible values are:"In Process", "Exported", and "Cancelled". "In Process" implies that the file is currenlty being executed. "Exported" implies that the files was exported. |
Overview
This entity includes forecasts generation definition.
Navigation
Human Capital ► Payroll and Financial ► Forecasts Generation ► Support Entities ► Forecasts Generation Definition
Forecasts Generation Definition Screen Fields
Fields | Description |
Application Id | Forecasts Generation Definition unique identifier generated by the system. |
Method of Calculation | Method of Calculation for Forecasts Generation. Possible values are: "Accruals + Forecasts to Year-End", "Full-Year Forecasts", "Actuals Expenditures + Forecasts to Year-End", and "Forecasts to Year-End". |
Include Global Cost | Default is false implying that the Global Costs are not included in the Forecasts calculation. If set to true, by the user, the Global Costs will be included in the Forecasts calculation. |
Group By | Selected from the list of COA Groups of the active COA. |
Active | Default is True. If set to false, the Forecasts Generation Definition is not available. |
Reference Date | Reference Date of the Forecasts Generation, entered by the user, under the Forecasts Generation Screen. |
Last Generation Date | Read-only date, as generated by the system, of the last Forecasts Generation. |
Last Reference Date | Read-only reference Date of the last Forecasts Generation. |
Last Forecasts Amount | Calculated Total Forecast Amount (read-only) of the last Forecasts Generation. |
Overview
Interface Definitions entity contains all general information related with Invoices uploaded for suppliers.
Navigation
Human Capital► Payroll and Financial ► Interface Definition
Interface Definition Screen Fields
Fields | Description |
Code | Unique identification code, this is automatically generated based on parameters. |
Type | Possible Values are: PayImportS, PayImportE, JVImport, PayExportS, PayExportE, AccrualExportS, AccrualExportE, and BankImport. |
Language | Select the Language used to register the description and name. |
Name | Name of the Interface Definition |
Import/Export | Values are: Import Internal, Import External, and External. |
Identification Header ID | The Header is identified with a specific number. Possible values are: Record Type1, Header Record Type. |
Identification Body ID | The Header is identified with a specific number. Possible values are: Record Type1, Record Type. |
Header ID | The Header is identified with a specific number. |
Body Type | The Body is identified with a specific number. |
Footer ID | The Footer is identified with a specific number. |
Active | Default is true. If set to false, Interface Definition is not available. |
Distribution | Default is true. |
Generation | Default is true. |
Include Header | Default is true implying that the File contains a Header. |
Include Footer | Default is true implying that the File contains Footer. |
Cancel Cheque Option | Cancel Cheque Option Activation Indicator. |
Generate Month End Accruals | It is implying that Year-End Reversals are generated when Year-Accruals are generated, for the last Accounting Month of the Fiscal Year. |
Fields | Description |
Active | Default is true. If set to false, the Financial Code Mapping is not available. |
Code | Unique Code, manually entered by user. |
External Field | Reference to an External Field associated with the Financial Coding Block segment. |
Default Value | Default value is null. If required, a default value must be entered by the user, and is allowed only if Identification Field is null. The size of Default Value is as per the size of the Identification Field. |
External=Internal | Default value is false. If the value is set to true by the user and if the coding from the pay import file and the Forecasting Module differs, the pay transaction will be rejected, during the payroll process, with an error indicating that the coding of the assignment is different to the coding of the imported file. |
Use Forecasting Module Field | If the value is set to true by the user, the coding provided by the Forecasting module will have priority over the coding supplied by the import file. When set to false, the coding supplied in the import file will be maintained unless manually overridden by the user. |
Overview
This Entity includes the specifications for the pay import and process.
Navigation
Human Capital ► Payroll and Financial ► JV Import ► JV Import/Process
JV Import/Process screen Fields
Fields | Description |
Interface Definition | Unique identifier of the Log, generated by the system. |
Filename | Choose the file to upload. |
Error | Error type generated during Calculation of Accruals. |
Action | generated during Calculation of Accruals. |
Suspended | The User will select from the List of elements within The Concept selected. |
Overview
Navigation
Human Capital ► Payroll and Financial ► JV Import ► JV Import Log
JV Import Log screen Fields
Fields | Description |
Application Id | Unique identifier of the Log, generated by the system. |
File Name | Name of the imported file. |
Log Date Time | Date and Time at which the file was imported, generated by the system. |
Number Transactions | Number of body transactions in the JV imported file. Set by the system to the sum of Record Count (if populated) for the JV imported file, otherwise, the sum of Harsh Total. |
Amount Transactions | Monetary value of all transaction lines contained in the JV imported file. Set by the system to the sum of Batch Total Amount for the JV imported file. |
Status | Current status of the file. Possible values are:” Importing”, "Imported", “Import Cancelled”, “Processed “, “RollBack”. |
Interface | Interface to which the ForeCastingJVLog applies. |
Imported By | Corresponds to the User who imported the JV File. |
JV Transaction Header | Collection of 1 to many ForeCastingJVTransactionHeader. The name of the tab should be: "JV Transaction Header" |
JV Import Log Details | Collection of 1 to many ForeCastingJVLogDetail. The name of the tab should be" "JV Import Log Details". |
Overview
Navigation
Human Capital ► Payroll and Financial ► Link Financials Journal Voucher to Employee ► Link Financials Journal Voucher to Employee
Link Financials Journal Voucher to Employee Screen Fields
Fields | Description |
Code | Unique identification code for each record. |
Active | The default is checked. If it is unchecked the transaction is not available. |
Employee | Entitlement.oyee that the User will select from the list of active Employees under HCS Employee |
Journal Voucher | Every time a transaction is created in the system, the system automatically creates a corresponding journal voucher for control purposes. Since the system employs the double entry accounting principle, each journal voucher will contain the proper debit and credit amounts. |
Journal Voucher Item | User can select journal voucher item from the drop-down. |
Overview
Manual Journal Voucher includes the manually created Journal Vouchers and reversed Journal Vouchers. Manual Journal Vouchers should be created from the Journal Voucher screen. The Journal Voucher screen includes the attributes of Entities Manual Journal Voucher, and Journal Voucher Details.
Navigation
Human Capital ►Payroll and financial ►Manual Journal Voucher ►Manual Journal Voucher
Manual Journal Voucher screen Fields
Fields | Description |
Code | Unique Identifier for each record |
Active | If unchecked the Manual Journal Vocher not available. |
Is Excluded From Export | Excluded from Export. |
Is Exported | Default is False. Set to True by the system during Export to Financials. Note: Additional Workflow Processes Status will be displayed In EDIT and SEARCH MODE. |
Total Amount | Total amount of the transactions calculated by the application. |
Work From | Work From Date of the Journal Voucher. Default is date of creation of the JV. |
Work To | For the pay export functionality, this field corresponds to the monetary value of all transaction lines that are exported. |
Post Date | Post Date of the Journal Voucher. Default is date of creation of the JV. |
Approved By | User who approved the JV, populated by the system. Note: The user’s security profile must include permission to approve and reject journal vouchers. Note: The user must have access to all the JV entry lines. Note: The JV must show the status Ready for Approval. |
Approval Date | Date at which the JV was approved, generated by the system. |
Created By | User who created the JV populated by the system. |
Created Date | Date at which the JV was created, generated by the system. |
Completed By | User who will complete the JV, entered manually. |
Completed Date | Date at which the JV was completed, generated by the system. |
Institution | This attribute contains an Institution catalogue, which could be used among other Entities on the System. |
Status | It shows the status of the Manual Journal Voucher. It is automatically updated by the system as per the approval process completed. The possible values are "Created", "Approval Requested", "Approved" etc. |
Transaction Source | Transaction Source of the Journal Voucher, as generated by Process. Default is "JV created manually". Possible values are "JV created manually" and "Reversed JV". |
Reversal/Reversed Journal Voucher | Read-only field. Associated Reversal or Reversed Journal Voucher ID, created by the reversal functionality. |
Language | Language chosen as required. |
Comments | Comment/explanation related to the creation of the JV. |
Manual Journal Voucher Detail Tab | It allows the user to enter the manual journal voucher details. |
Overview
This tab is associated with the Manual Journal Vouche.
Manual Journal Voucher Detail Screen Fields
Fields | Description |
Serial Number | Unique Financial Coding Block generated by the system. |
Coding Block | The coding block with the structure (number of elements and order of concepts) of the Group. |
Employee | It contains all employees of the government. It displayed the Employee to whom the JV applies. |
Total Amount | Total amount of the line items. |
Transaction Type | The allows the user to select the Transaction Type from the drop-down list. It can be Debit or Credit. |
Is Protected Data | By default it is unchecked. If user meke it checked, then the transaction is visible only to authorized users under the Human Capital Expenditures Window. |
Entitlement Code | Entitlement Code, entered manually by the user, or selected from the list of configured Entitlement Codes, from Entity. |
Employee Assignment | Assignment ID of the Assignment associated to the Employee specified under Employee, as generated by the application. |
Cost Item | Cost Item associated to the transaction, as generated by the system using the Cost Item Attribution. |
Batch Number | It is displayed by the export to Financial. |
Created By | User who created the transaction. The system automatically fetches the user data. |
Overview
This entity includes the mapping between the Cost Items and the Line Object Codes.
Navigation
Human Capital ► Payroll and Financial ► Manual Journal Voucher ► Support Entities ► Cost Item Attribution
Cost Item Attribution screen Fields
Fields | Description |
Active | Unique identifier code for each record |
CoA | If unchecked, Process Action and Error Catalogue is not available. |
Concept | A concept within the COA represents a collection of elements, as an example: line items, district, fund source, institution, and main category. |
Element | An element of the COA is the single value of each concept. As an example, the concept Line Item can have the following elements: 6001 Salary, 6002. |
Cost Item | Cost Item associated to the Element. The Cost Item ID and Name should be displayed on the form. |
Overview
Once the accruals have been generated, the transactions may be exported to the financial system. This process will convert all detailed accruals information for the specified fiscal period into summary data.
Monthly Accruals Export screen fields
Fields | Description |
Interface | Select the Export Accruals Interface. |
Export Type | Accruals for Monthly Accruals Export. |
Filename to Export | The filename of the file to Export to be entered by the user. This field is displayed only if the System parameter “Generation of JVs or Generation of Export file for Pay Export” is set to the Generation of Pay Export. This means that the financial system is not FreeBalance financials. |
Selection Tab | Allows the user to select the fiscal period for which the transactions should be exported. |
Fiscal Period | Fiscal Period associated to the accrual’s transaction. |
Load Related Files | This button displays the accruals files for the selected Fiscal Period ready to be exported. |
Note: Once the Accruals transactions are generated, you are ready to do the Accruals Export.
Note: Users must ensure to respect the departmental file naming convention when creating export files.
Overview
Navigation
Human Capital ► Payroll and Financial ► Monthly Accruals Generation ► Monthly Accruals Generation
Monthly Accruals Generation screen Fields
Fields | Description |
Fiscal Period | The fiscal period for which the accruals will be generated. |
Fiscal Period Filter | Filters the transactions under the Suspended Tab, by Fiscal Period. If a Fiscal Period is selected, only the transactions in suspense for that specific fiscal period will be displayed under the Suspended tab. |
Error | Filters the transactions under the Suspended Tab, by Error. If an Error is selected, only the transactions in suspense with this error will be displayed under the Suspended tab. |
Action | Filters the transactions under the Suspended Tab, by Action. If an Action is selected, only the transactions in suspense with this action will be displayed under the Suspended tab. |
Suspended Tab | Displays the transactions in suspense that correspond to the filter. More than one filter can be used simultaneously to filter the Suspended Tab (Accrual Generation Fiscal Period, Error, and Action). |
Note 1: If the fiscal period is closed it will not be possible to generate accruals.
Note 2: If the fiscal period is closed with restrictions, the wording Restricted (closed with exceptions) will appear next to the selected fiscal Period. Only user profiles with the required privileges to generate accruals for restricted fiscal periods will be able to generate the accruals.
Note: The user can only perform the Monthly Accruals Generation once per month; otherwise, the system will display an unexpected error, as following.
Overview
Displays the transactions in suspense that correspond to the filter. More than one filter can be used simultaneously to filter the Suspended Tab (Accrual Generation Fiscal Period, Error, and Action).
Modify Distribution screen fields
Fields | Description |
Final Distribution | Does not Apply to Accruals Generation. |
Do Not Associate with Assignments | Does not Apply to Accruals Generation. |
Manual PAYE | Does not Apply to Accruals Generation. |
Transaction(s) Total | Displays the combined monetary value of all selected transactions. |
Distribution Total | Displays the monetary value of the distribution specified in this window. |
Variance | Displays the monetary value of the undistributed transaction(s). Note that this value must be $0.00 in order to accept the overall distribution. |
Number of Transactions Selected | Indicates the number of transactions selected. These transactions will be applied the FCB distribution supplied in this window. |
Overview
Navigation
Human Capital ► Payroll and Financial ► Monthly Accruals Generation ► Monthly Accruals Logs
Monthly Accruals Logs screen Fields
Fields | Description |
Fiscal Period | Fiscal Period for this log |
Log Date | Date at which the accruals were generated, generated by the system. |
Number of Transactions | For all Accruals Generations, except Year-End Accruals, this attribute corresponds to the total number of transactions generated, as part of the accruals generation, including the successfully generated transactions OR the successfully generated reversals. |
Value | For all Accruals Generations, except Year-End Accruals, this attribute corresponds to the total value of the transactions successfully generated OR the associated reversal transactions, in the following Accounting Fiscal Period. |
Status | Current status of Accruals Generation. Possible values are:”Generating ”, "Generated", “Generation Cancelled”, “Exported “, “RollBack”, and **Added: "Export_Rollback". |
Total | Calculated total amount of the transaction, from the Accruals Generation. |
Overview
This Entity includes the specification of Pay Export and JV export. The Pay and JV Export window should include 2 filters (Interface and Export type) and a selection tab.
Navigation
Human Capital ► Payroll and Financial ► Payroll Export ► Hc Pay And JV Export
Hc Pay And JV Export screen Fields
Fields | Description |
Interface | Allows selecting the interface for which the export is performed. |
Export Type | Two options are available in the Export Type: "Pay Data" and "Manually Created JV's". The default should be "Pay Data" |
Filename to Export | Pay Entitlement Code. The size is as per the size of the External Field corresponding to External Field Entitlement. |
Selection Tab | The User will select from the List of elements within The Concept selected. |
Fiscal Period | It includes the Employee Classes use during Pay Process. |
Transaction Type | Two options are available in the transaction type: Summarized and Detailed |
Total Selected | The amount will be displayed |
Overview
This Entity includes the list of Pay Export, for the current fiscal year, if the interface as selected under the Pay and JV Export screen are Export Pay. This Entity includes the list of Pay Export, for the current fiscal year, if the interface as selected under the Pay and JV Export screen are Export Pay.
Navigation
Human Capital ► Payroll and Financial ► Payroll Export ► Hc Pay And JV Export Log
Fields | Description |
Id | Unique identifier of the Log, generated by the system. |
File Name | Corresponds to the name of the file to be exported. |
Created Journal Voucher | Every time a transaction is created in the system, the system automatically creates a corresponding journal voucher for control purposes. Since the system employs the double entry accounting principle, each journal voucher will contain the proper debit and credit amounts. |
From Batch No | Batch Numbers are attributed sequentially to all export lines. This field indicates the first batch number used for this export file. |
To Batch No | Only applicable if export files are used. This field indicates the last batch number used for the export file. |
Export Date | Date at which the file was exported, generated by the system. |
No. of Transactions | Number of transactions in the exported files. |
Value | For the pay export functionality, this field corresponds to the monetary value of all transaction lines that are exported. |
Status | Current status of the file. Possible values are:"In Process", "Exported", "Rollback", and "Cancelled". "In Process" implies that the file is currently being executed. "Exported" implies that the file was exported, and "Rollback" indicates that the export was reversed using the Rollback icon. |
Transactions from JV Tab | Information fetch from JV transactions. |
Forecasting Pay Transaction Tab | This tab includes additional information on the distribution of the transactions contained in the payroll file after all Process Filters (File Name, Import/Generate, Action, Error and Other Selection) are applied. |
Overview
Payroll Export Log includes the list of Pay Export, for the current fiscal year, if the interface as selected under the Pay and JV Export screen is Export Pay.
Navigation
Human Capital ► Payroll and Financial ► Payroll Export ► Payroll Export Log
Payroll Export Log screen Fields
Fields | Description |
Id | Unique Identifier for each record |
Active | If unchecked the Log is not available. |
Export Date | Date at which the file was exported, generated by the system. |
Journal Voucher | Every time a transaction is created in the system, the system automatically creates a corresponding journal voucher for control purposes. Since the system employs the double entry accounting principle, each journal voucher will contain the proper debit and credit amounts. |
File Name | Corresponds to the name of the file to be exported. |
From Batch No | Batch Numbers are attributed sequentially to all export lines. This field indicates the first batch number used for this export file. |
To Batch No | Only applicable if export files are used. This field indicates the last batch number used for the export file. |
No Of Transactions | Number of transactions in the exported files. |
Value | For the pay export functionality, this field corresponds to the monetary value of all transaction lines that are exported. |
Status | Current status of the file. Possible values are:"In Process", "Exported", "Rollback", and "Cancelled". "In Process" implies that the file is currently being executed. "Exported" implies that the file was exported, and "Rollback" indicates that the export was reversed using the Rollback icon. |
Overview
Navigation
Human Capital ► Payroll and Financial ► Payroll Export ►Support Entities ► External System Definition
Fields | Description |
External System Definition ID | This is a unique value, generated by the system. |
Language | As per the country language. |
Description | Short Description of the External System Definition Group. |
Export Interface | Pay Export Interface Definition selected from a list of Interface Definition with the set to "PayExportS" or "PayExportE". |
Data Source | Data Source for the Export Interface selected from a list of Interface Definition with the set to "PayImportS" or "PayImportE". |
Active | Default is True. If set to false, the External System Definition is not available. |
Overview
Navigation
Human Capital ► Payroll and Financial ► Payroll Export ►Support Entities ► Link Organizations to Financial Codes
Link Organizations to Financial Codes Screen Fields
Fields | Description |
Application Id | This is a unique value, generated by the system. |
Active | Default is True. If set to False, the record cannot be used in transactions. |
Concept | The Concept of COA from which the element will be selected |
Element | The element that will be used as the trigger point for the Multiple Offset functionality, selected from the list of elements from the Concept. |
Department | Department ID associated to the Element under the Pay Import File. The Department ID will be entered by the user. |
Overview
This entity includes the Offset Codes for the Journal Voucher created under Financials if Generation of JVs or Generation of Export File for Pay Export is set to "Generation of JVs. Different Offset Codes can be specified for different COA Elements if System Parameter Use Multiple Offset is set to True.
Navigation
Human Capital ► Payroll and Financial ► Payroll Export ►Support Entities ► Offset Codes for Created JVs
Fields | Description |
Application Id | This is a unique value, generated by the system. |
Active | Default is True. If set to False, the record cannot be used in transactions. |
Concept | The Concept of COA from which the element will be selected |
Element | The element that will be used as the trigger point for the Multiple Offset functionality, selected from the list of elements from the Concept. |
Pay Transactions Offset Code | Offset code for the JV created by the Pay Process, that the user will select from the list of Offset Codes under Transaction Group Offset Code. |
Journal Voucher Offset Code | The default is Offset Code specified under Offset code for the JV created by the Manual JV process, that the user will select from the list of Offset Codes under Transaction Group Offset Code. |
Month-End Accruals Offset Code | The default is Offset Code specified under Offset code for the JV created by the Month-End Accruals Process, that the user will select from the list of Offset Codes under Transaction Group Offset Code. |
Accruals Reversal Offset Code | The default is Offset Code specified under Offset code for the JV created by the Accruals Reversal Process, that the user will select from the list of Offset Codes under Transaction Group Offset Code. |
Liabilities Offset Code | Offset code for the JV created by the Banks and Liabilities Process, that the user will select from the list of Offset Codes under Transaction Group Offset Code. |
Paye Offset Code | Offset code for the PAYE created by the PAYE Export (in Previous Fiscal Year), that the user will select from the list of Offset Codes under Transaction Group Offset Code. |
Overview
Navigation
Human Capital ► Payroll and Financial ► Payroll Export ►Support Entities ► Pay Export Validations
Fields | Description |
Pay Export Validation ID | Unique Pay Export Validation ID generated by the system. |
Interface ID | Should be a drop-down list showing the Interface Name from Interface Definition attribute with the set to "PayExportS" or "PayExportE". or "AccrualsExportS", or "AccrualsExportE". |
External Field ID | External Field from the Interface Definition of the Pay Export, selected from the list of External Fields for the selected Interface ID. |
Calculated Value | Identifies a possible value against which the External Field will be validated. |
isActive | Default is True. if set to false, the Validation is not available. |
Overview
This entity includes the specifications for the pay import and process.
Navigation
Human Capital ► Payroll and Financial ► Pay Import and Process ►Payroll Import ► Pay Import
Pay Import/Process Screen Fields
Fields | Description |
Interface Definition | Unique identifier of the Log, generated by the system. |
Filename | Choose the file to upload. |
Filename | Corresponds to the name of the file to be exported. |
Error | Possible values are: No Assignment covers “From” & “To” dates; Accounting period closed with exceptions; Assignment Account <> imported file account; Assignment without cost; Coding Mandatory; Combination not respected; Date outside the current year; Employee does not exist in Human Capital; Inactive Coding; Manual P.A.Y.E Transaction; No assignment before expenditures’ work to date; No expenditure related to cancel cheque; Validation rules not respected; The Accounting period is closed; Value does not exist in Human Capital |
Action | Possible values are: Distribute against Assignment Excluding some Distribution Rules; Distribute on Current Fiscal Year's 1st Assignment; Distribute on Default Account Excluding Distribution Rules; Distribute against Assignment; Distribute as is; Distribute on Default Account; Distribute on Most Recent Assignment; Exclude Data from Human Capital, Keep in Waiting, Distribute on Specific Account |
Suspended | The User will select from the List of elements within The Concept selected. |
Overview
Navigation
Human Capital ► Payroll and Financial ► Pay Import and Process ►Payroll Import ► Payroll Import Log
Pay Import Log Screen Fields
Fields | Description |
File Name | Name of the imported file. |
Log Date | The date on which the file is imported, it is generated by the system. |
Imported By | Automatically populated by the system. Corresponds to the User who imported the file. |
Number Transactions | The number of body transactions in the imported files. |
Amount Transactions | The monetary value of all transaction lines contained in the imported file. |
Number Transaction Generated | Number of Transactions generated on the process. |
Amount Transaction Generated | Monetary Value of transactions generated on the process of Pay Import. |
Pay Log Status | Possible values are:"Importing", "Imported", "Imported", "Import Cancelled", "Processed", "Rollback" |
Pay Log Status Export | Possible values are: 'NotGenerated', 'Generated', 'Rollback'. |
Interface | Interface to which the ForeCasting Pay Log Applies. |
Header1 | From the Pay Import File-Header External Field: HeaderField1 |
Header2 | From the Pay Import File-Header External Field: HeaderField2 |
Header3 | From the Pay Import File-Header External Field: HeaderField3 |
Header4 | From the Pay Import File-Header External Field: HeaderField4 |
Header5 | From the Pay Import File-Header External Field: HeaderField5 |
Transaction | Collection of 1 or more ForeCasting Pay Transaction |
Log Detail | Collection of 1 or more Forecasting Pay Log Detail |
Overview
This Entity includes the Employee Classes use during Pay Process.
Navigation
Human Capital ► Payroll and Financial ►Payroll Import and Process ► Support Entities ► Employee Class
Employee Class screen Fields
Fields | Description |
Code | Unique identifier code for each record |
Employee Class Code | Employee Class Short Description. |
Language | Select the Language used to register the description and name. |
Description | A detailed description for Employee Class. |
Overview
This tab is associated with Interface Definition.
FCB Maps screen Fields
Fields | Description |
Active | If unchecked, the Financial Code Mapping is not available. |
Code | Unique Identifier for each record |
External Field | Reference to an External Field associated with the Financial Coding Block segment. |
Default Value | Default value is null. If required, a default value must be entered by the user, and is allowed only if Identification Field is null. The size of Default Value is as per the size of the Identification Field. |
Order | Order of the Financial Coding Block segment. Must be unique, for each Interface Definition. |
External/Internal | Default value is false. If the value is set to true by the user and if the coding from the pay import file and the Forecasting Module differs, the pay transaction will be rejected, during the payroll process, with an error indicating that the coding of the assignment is different to the coding of the imported file. |
Use Forecasting Module Fields | If the value is set to true by the user, the coding provided by the Forecasting module will have priority over the coding supplied by the import file. When set to false, the coding supplied in the import file will be maintained unless manually overridden by the user. |
Overview
Forecasting Imported Data Generation Definition entity includes the definition of fringe benefits based on entitlement code percentage. Based on this definition, additional payroll expenditures can be generated based on the percentage of selected imported transactions, if Generation is set to true.
Navigation
Human Capital ► Payroll and Financial ►Support Entities ► Forecasting Imported Data Generation Definition
Forecasting Imported Data Generation Definition screen Fields
Fields | Description |
Code | Unique identifier code for each record |
Active | If unchecked indicates the Forecasting Imported Data Generation Definition is not available |
External Field | Possible Values are: Employee ID, FCB1, FCB2, FCB3, FCB4, FCB5, FCB6, FCB7, FCB8, FCB9, FCB10, FCB11, FCB12, FCB13, FCB14, FCB15, Expenditure Date, Amount, Work From, Work To, Field1, Field2, Field3, Field4, Field5, Field6, Field7, Field8, Field9, Field10, Field11, Field12, Field13, Field14, Field15, Requisition ID, Reference Nb, Entitlement Code, Accounting Period, Pay Period. As defined for External Fields of Pay and JV Files. |
Generated Value | Value to be displayed, for all generated transactions, in the External Field. |
Rate | Multiplying factor to be used to generate expenditures. |
Interface | Interface to which the Specific Distribution Rule applies. |
Overview
Forecasting Rule includes the condition used for the definition of the Forecasting Rule. The conditions are based on any external field of the Import/Export file.
Navigation
Human Capital ► Payroll and Financial ►Support Entities ► Forecasting Rule
Forecasting Rule screen Fields
Fields | Description |
Code | Unique Identifier for each record |
Rule Code | Possible Values are: Exclude Data, Imported Data Generation and Pass On. |
Logical Operator | Default is AND. Possible values are: AND, OR. Logical Operator between Rules conditions. |
Forecasting Interface Definition | Only Import Interfaces should be available for selection. |
Active | If unchecked, Exclude Data from Pay Import is not available. |
Order | Processing Order to be used to manage the precedence of rules, when a transaction meets more than one criterion. |
Overview
This defines the rules to be implemented on Forecasting Import/Export Processes.
Rule Condition screen Fields
Fields | Description |
Active | If checked, the Rule Condition is available |
Sequence | Unique identifier generated by the system. |
Operator | Default is AND. Possible values are: AND, OR. Logical Operator between Rules conditions. |
External Field | This represents a weekday schedule definition belonging to a schedule definition entity. |
Overview
Pay Entitlement Cost Item includes the Entitlement Codes and associated cost items. Entitlement Codes are set of values used to identify types of payroll transactions.
Navigation
Human Capital ► Payroll and Financial ►Support Entities ► Pay Entitlement Cost Item
Pay Entitlement screen Fields
Fields | Description |
Id | Unique identifier code for each record |
Active | If checked indicates the Pay Entitlement Cost Item is available |
Central Cost | If checked indicates the Central Cost is available |
Supplementary Pay | If checked indicates the Supplementary Pay is available |
Entitlement Code | Unique Identifier code for the Pay Entitlement. |
Language | Language as chosen. |
Description | Short Description of the Pay Entitlement. |
Cost Item | HC Cost Item associated to the Entitlement Code selected from HC Cost Item. |
Default Cost Item | Default Cost Item associated to the Entitlement Code selected from HC Cost Item. The default HC Cost Item is used during Pay Process when the HC Cost Item is not included in the assignment. |
Overview
This includes the Entitlement Codes and associated financial coding, per Employee Class. Entitlement Codes are set of values used to identify types of payroll transactions
Navigation
Human Capital ► Payroll and Financial ►Support Entities ► Pay Entitlement Employee Class
Pay Entitlement Employee Class screen Fields
Fields | Description |
Code | Unique identifier code for each record |
Active | If unchecked, Pay Entitlement - Employee Class Matrix is not available. |
Entitlement Code | Pay Entitlement Code. The size is as per the size of the External Field corresponding to External Field Entitlement. |
Replacement Value | The User will select from the List of elements within The Concept selected. |
Concept | A concept within the COA represents a collection of elements, as an example: line items, district, fund source, institution, and main category. |
Employee Class | It includes the Employee Classes use during Pay Process. |
Overview
This entity includes the Entitlement Codes and associated financial coding, per Employee Class. Entitlement Codes are set of values used to identify types of payroll transactions.
Navigation
Human Capital ► Payroll and Financial ► Pay Import and Process ►Support Entities ► Pay Entitlement Employee Class Matrix
Pay Entitlement Employee Class Matrix Screen Fields
Fields | Description |
Code | Unique identifier code for each record |
Active | If unchecked, Pay Entitlement - Employee Class Matrix is not available. |
Entitlement Code | Pay Entitlement Code. The size is as per the size of the External Field corresponding to External Field Entitlement. |
Employee Class | It includes the Employee Classes use during Pay Process. |
Concept | A concept within the COA represents a collection of elements, as an example: line items, district, fund source, institution, and main category. |
Replacement Value | The User will select from the List of elements within The Concept selected. |
Overview
This entity includes the Specific Distribution Rule (s) (SDR). The SDR allows assigning financial coding to transactions according to predefined conditions. Depending on the type of SDR, the coding validation process will vary and will be applied at the different stage of the payroll function.
Navigation
Human Capital ► Payroll and Financial ►Payroll Import and Process ►Support Entities ► Pay Specific Distribution Rule
Fields | Description |
Code | Unique identifier generated by the system. |
Interface | to which the Specific Distribution Rule applies. The Interface is identified by the Pay Import Interface from JV Import. |
Type | Specific Distribution Rule Type. There are 4 possible types: Distribution, Override, Manual Distribution, Final Override, and P.A.Y.E. LATER. |
Processing Order | Processing Order to be used to manage the precedence of rules, when a transaction meets more than one criterion. |
Is Active | If checked, Pay specific Distribution Rule is available. |
Coding Block | This field has the information of every coding block with the structure (number of elements and order of concepts) of the Group. |
Logical Operator | Logical Operator to be used between the Conditions. Possible Values are OR, AND. |
Overview
Fields | Description |
Active | Default is checked if unchecked specific distribution rule condition will not be available. |
Sequence | System generated unique identification number for forecasting rule. |
Operator | Possible operators are equal to, greater than, less than, T, F etc., Operator should be set “=” if rule code is set ImportedDataGeneration. |
External Field | As defined for External Fields of Pay and JV Files, as defined under Interface Definition. |
Overview
This Entity includes the list of available Processing Actions used by the Pay Import and Process.
Navigation
Human Capital ► Payroll and Financial ►Support Entities ► Process Action and Error Catalogue
Process Action and Error Catalogue screen Fields
Fields | Description |
Code | Unique identifier code for each record |
Active | If unchecked, Process Action and Error Catalogue is not available. |
Processing Action | The User will select from the List of elements within each Action. Possible Values are: Distribute against Assignment Excluding some Distribution Rules; Distribute on Current Fiscal Year's 1st Assignment; Distribute on Default Account Excluding Distribution Rules; Distribute against Assignment; Distribute as is; Distribute on Default Account; Distribute on Most Recent Assignment; Exclude Data from SMS Human Capital, Keep in Waiting, Distribute on Specific Account |
Processing Error | By default, it is Active. If the user switches it to inactive, the user cannot select it anymore. The User will select from the List of elements within each Error: No umber of Assignment covers “From” & “To” dates; Accounting period closed with exceptions; Assignment Account <> imported file account; Assignment without cost; Coding Mandatory; Combination not respected; Date outside the current year; Employee does not exist in SMS Human Capital; Inactive Coding; Manual P.A.Y.E Transaction; No umber of assignment before expenditures’ work to date; No umber of expenditure related to cancel cheque; Validation rules not respected; The Accounting period is closed. |
Overview
This entity includes the list of automatically applied next actions upon occurrence of specific errors.
Navigation
Human Capital ► Payroll and Financial ►Support Entities ► Processing Action Configuration
Processing Action Configuration screen Fields
Fields | Description |
Code | Unique identifier code for each record |
Active | If checked indicates the Processing Action Configuration is available |
Forecasting Interface Definition | Forecasting Interface Defination to which processing action configuration applies. |
Processing Action | Previous Processing Action applied to a transaction for which a new action has to be applied, from the Pay Import Processing Actions Catalogue, if Interface is the Pay/JV Import according to parameter. |
Processing Error | Error message that will require applying a new Processing Action, from the Forecasting Process Error Catalogue, if Interface is the Pay/JV Import according to parameters. |
New Action | New Action that will be applied to a transaction for which the specified Processing Action had been previously applied and resulted in the Error message specified, from the Pay/JV Import Processing Actions Catalogue. |
Overview
This entity includes the condition used for the definition of the Forecasting Rule. The conditions are based on an external field of the Import/Export file.
Navigation
Human Capital ► Payroll and Financial ►Payroll Import and Process ►Support Entities ► Processing Rule
Fields | Description |
Code | Unique identifier generated by the system. |
Rule Code | Possible Values are: Exclude Data, Imported Data Generation and Pass On. |
Order | Processing Order to be used to manage the precedence of rules, when a transaction meets more than one criterion. |
Interface | Only Import Interfaces should be available for selection. |
Is Active | Default is true. If set to false, Exclude Data from Pay Import is not available. |
Logical Operator | Default is AND. Possible values are: AND, OR. Logical Operator between Rules conditions. |
Rule Condition Tab screen Fields
Fields | Description |
Active | Shift Schedule Weekday that organizes shift hours with the number of working days per week. |
Sequence | Unique identifier generated by the system. |
Operator | Default is AND. Possible values are: AND, OR. Logical Operator between Rules conditions. |
External Field | This represents a weekday schedule definition belonging to a schedule definition entity. |
Overview
The entity includes the overriding rules of the default system action at the time of the import.
Navigation
Human Capital ► Payroll and Financial ►Support Entities ► Specific Application Rule
Specific Application Rule screen Fields
Fields | Description |
Code | The unique identification code. It is automatically generated by the system. |
Active | By default, it is checked. If the user makes it unchecked then the Specific Application Rule would be not available. |
Rule | Processing Action to apply, from the Processing Actions Catalogue. One to One. Must be a Rule according to the Interface. |
Forecasting Interface | Forecasting Interface to which the Specific Distribution Rule applies. |
External Field | Possible Values are: Employee ID, FCB1, FCB2, FCB3, FCB4, FCB5, FCB6, FCB7, FCB8, FCB9, FCB10, FCB11, FCB12, FCB13, FCB14, FCB15, Expenditure Date, Amount, Work From, Work To, Field1, Field2, Field3, Field4, Field5, Field6, Field7, Field8, Field9, Field10, Field11, Field12, Field13, Field14, Field15, Requisition ID, Reference Nb, Entitlement Code, Accounting Period, Pay Period. |