Outbound Budget Detail Extract (KKI009)
  • 12 Jul 2024
  • 5 Minutes to read
  • Dark
    Light
  • PDF

Outbound Budget Detail Extract (KKI009)

  • Dark
    Light
  • PDF

Article summary

Interface Description

This Interface provides Agency Business Systems with all Budget Detail Activity details from Florida PALM in a Flat File format output. This interface will create separate data files for each Agency Business Unit based on run control parameters. The interface will be available for a variety of selection criteria including but not limited to:

  • Commitment Control (KK) Budget Ledger groups (Appropriations, Releases, Reserves, Projects, Allotments and Revenue).
  • Budget Journal Status: budget journals that are not yet edited, not yet submitted for approval, approved but not yet posted, posted, or in error.

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 FieldData Field Details
Business UnitRequired
Ledger GroupRequired
Budget Header StatusOptional
Journal Date FromRequired
Journal Date ToRequired

File Layout

The layout of the interface is listed below. 

Data Field
Record Type
Data Field Description
Field NameRecord TypeDescription
Record CodeJournal HeaderRecord Code identifying the information on the record.
Business UnitJournal HeaderUsed to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions.
 
 Legacy Mapping: Operating Level Organization (OLO)
Journal IDJournal HeaderIdentifies a journal entry, consisting of a header and one or more lines.  The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
Journal DateJournal HeaderSpecifies the date the journal was created.
System SourceJournal Header

Shows how the budget journal was entered into Florida PALM.

System sources for KKI009, which are informational only for agencies to note how the budget journal was entered into Florida PALM.

    PNL - Online Journal Entry Page

    SCP - Journal Copy

Budget Header StatusJournal HeaderShows the budget status of the journal.
Ledger GroupJournal HeaderA ledger consists of posted balances that represents a set of books for a business unit.
Journal Header AmountJournal HeaderShows the total amount for the budget journal, debits plus credits.
Journal Header DescriptionJournal HeaderUsed to give a short description of the purpose of the journal
Filler1Journal HeaderThis field is reserved for future use in Florida PALM.
Filler2Journal HeaderThis field is reserved for future use in Florida PALM.
Filler3Journal HeaderThis field is reserved for future use in Florida PALM.
Filler4Journal HeaderThis field is reserved for future use in Florida PALM.
Filler5Journal HeaderThis field is reserved for future use in Florida PALM.
Record CodeJournal LineRecord Code identifying the information on the record.
Business UnitJournal LineUsed to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions.
 
 Legacy Mapping: Operating Level Organization (OLO)
Journal IDJournal LineIdentifies a journal entry, consisting of a header and one or more lines.  The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
Journal DateJournal LineSpecifies the date the journal was created.
Journal LineJournal LineIdentifies the individual lines on the budget journal
Budget PeriodJournal LineBudget Period (Appropriation year).
Organization
Journal LineTracks information according to a breakdown of the organization.
AccountJournal LineProvides functionality to capture detailed transactional data.
FundJournal LineUsed to segregate and capture specific activities or classify certain objectives in accordance with special regulations, restrictions, or limitations (e.g., restricted fund).
Budget EntityJournal LineRepresents organizations and/or functions to which appropriations are made and typically represents a program.
Category
Journal LineCategory ChartField represents both appropriation categories and revenue source codes.
State ProgramJournal LineStores Chart of Accounts information and provides the basic structure to segregate and categorize transactional and budget data.
GrantJournal LineGrant ID value used to track financial assistance that provides support or stimulation to accomplish a public purpose. 
ContractJournal LineContract ChartField captures expenditure and revenue transactions for two party agreements.
OA1Journal LineService Location. It used to identify specific appropriations.
OA2Journal LineStores Chart of Accounts information and provides the basic structure to segregate and categorize transactional and budget data.
PC Business UnitJournal LineProject Costing Business Unit
ProjectJournal LineProject 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.
ActivityJournal LineTracks specific tasks that make up a Project and records transactional details; a Project must have at least one associated Activity ID.
PC Source TypeJournal LinePC Source Type identifies the purpose or origin of a transaction.
Line AmountJournal LineShows the amount for the individual lines on the budget journal
Journal ClasssJournal LineIdentified the type of reserve amount.
Budget Line StatusJournal LineIdentifies the budget status of the line
Filler1Journal LineThis field is reserved for future use in Florida PALM.
Filler2Journal LineThis field is reserved for future use in Florida PALM.
Filler3Journal LineThis field is reserved for future use in Florida PALM.
Filler4Journal LineThis field is reserved for future use in Florida PALM.
Filler5Journal LineThis field is reserved for future use in Florida PALM.
Filler6Journal LineThis field is reserved for future use in Florida PALM.
Filler7Journal LineThis field is reserved for future use in Florida PALM.
Filler8Journal LineThis field is reserved for future use in Florida PALM.
Filler9Journal LineThis field is reserved for future use in Florida PALM.
Filler10Journal LineThis field is reserved for future use in Florida PALM.

Version History

DateRevision Description
12/01/2023Original Version
05/24/2024Update System Source Field Description




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.