Inbound Combination Edit Spreadsheet Upload (GLI084)
  • 29 May 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Inbound Combination Edit Spreadsheet Upload (GLI084)

  • Dark
    Light
  • PDF

Article summary

Interface Description

The Inbound Combination Edit Spreadsheet upload gives Agencies the ability to upload in mass, combination edit rule configurations instead of having to manually maintain the rules using the online Combination Edit pages.

Click below to view the interface file layout and sample data file.

Business Process Model

This interface can be found in the following business processes:

Interface Selection Criteria

The interface data selection criteria includes the following:

Data Field

Data Field Details

SetID

Required

Combination

Required

File Layout

The layout of the interface is listed below.  

Data FieldRecord TypeData Field Description
Agency Business UnitDetailDesignate the Agency Business unit to which the new combo rule will be established.
Process GroupDetailDesignates the process group the combination edit rule is assigned to in Florida PALM configuration
Combination RuleDetailDesignates the Combination Edit Rule that is configured in Florida PALM.
Seq NbrDetailSequence Number establish how many combinations is/are to be loaded.
OrganizationDetailOrganization ChartField tracks information according to a breakdown of your organization.
AccountDetailProvides functionality to capture detailed transactional data. Can be specified as a balance sheet account or operating account.
Fund CodeDetailSegregates and captures specific activities or classifies certain objectives in accordance with special regulations, restrictions, or limitations.
Budget EntityDetailBudget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program.
CategoryDetailCategory ChartField represents both appropriation categories and revenue source codes.
State ProgramDetailStores Chart of Accounts information and provides the basic structure to segregate and categorize transactional and budget data.
GrantDetailGrant ChartField is used for tracking grants funding.
ContractDetailContract ChartField captures expenditure and revenue transactions for two party agreements.
OA1DetailOA1 tracks optional organization reporting, cost pools, expenditures, revenues, or other specific use.
OA2DetailOA2 tracks optional organization reporting, cost pools, expenditures, revenues, or other specific use.
PC Business UnitDetailProject Costing Business Unit.
ProjectDetailProject ChartField is used to capture a planned undertaking of something to be accomplished or produced, having a beginning and ending date, for which expenditures/costs and revenues are to be tracked.
ActivityDetailTracks specific tasks that make up a Project and records transactional details; a Project must have at least one associated Activity ID.
PC Source TypeDetailSource types identify the purpose or origin of a transaction.
PC CategoryDetailProject Category provides more flexibility and granularity in tracking and analyzing costs; not required.
PC SubcategoryDetailSubcategories provides more flexibility and granularity in tracking and analyzing costs; not required.

Version History

Date

Revision Description

12/01/2023

Original Version





Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.