Schedule of Allotment Balance Report (KKR008)

Data Field

Data Field Details

Report Request Parameters

Business Unit (BU)

• Business Unit Security
• Prompt table edit
• Prompt table values
  • % - (Report data will include all BU values user has BU security access to view)
  • Single Business Unit value (report data will be for a single BU value)

Required

Date From

• Calendar prompt/edit

Required

Date To

• Calendar prompt/edit

Required

ChartField (CF) Selection

Organization

• Include CF Check box is always selected and grayed out.
• User can provide range of Organization, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status of Organization.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Organization values.

Optional

Account

• Include CF Check box is always selected and grayed out.
• User can provide range of Account, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status Account.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Account values.

Optional

Fund

• Include CF Check box is always selected and grayed out.
• User can provide range of Fund, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status Fund.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Fund values.

Optional

Budget Entity

• Include CF Check box is always selected and grayed out.
• User can provide range of Budget Entity, ‘Value’ and ‘Value To’ Prompts.
• Both prompts allow user to select active and inactive status Budget Entity.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Budget Entity values.

Optional

Category

• Include CF Check box is always selected and grayed out.
• User can provide range of Organization, "Value" and "Value To" Prompts.
• Both prompts allow user to select active and inactive status Organization.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Organization values.

Optional

State Program

• Include CF Check box is always un-selected and editable.
• User can select State Program ChartField to display on the report.
• User can provide range of State Program, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status State Program.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all State Program values.

Optional

Grant

• Include CF Check box is always un-selected and editable.
• User can select Grant ChartField to display on the report.
• User can provide range of Grant, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status Grant.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Grant values.

Optional

Contract

• Include CF Check box is always un-selected and editable.
• User can select Contract ChartField to display on the report.
• User can provide range of Contract, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status Contract.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Contract values.

Optional

OA1

• Include CF Check box is always un-selected and editable.
• User can select OA1 ChartField to display on the report.
• User can provide range of OA1, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status OA1.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all OA1values.

Optional

OA2

• Include CF Check box is always un-selected and editable.
• User can select OA2 ChartField to display on the report.
• User can provide range of OA2, "Value" and "Value To" Prompts.
• Both prompts allow user to select active and inactive status OA2.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all OA2 values.

Optional

PC Business Unit

• Include CF Check box is always un-selected and editable.
• User can select PC Business Unit ChartField to display on the report.
• User can provide range of PC Business Unit, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status PC Business Unit.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all PC Business Unit values.

Optional

Project

• Include CF Check box is always un-selected and editable.
• User can select Project ChartField to display on the report.
• User can provide range of Project, "Value" and "Value To" Prompts.
• Both prompts allow user to select active and inactive status Project.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Project values.

Optional

Activity

• Include CF Check box is always un-selected and editable.
• User can select Activity ChartField to display on the report.
• User can provide range of Activity, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status Activity.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Activity values.

Optional

PC Source Type

• Include CF Check box is always un-selected and editable.
• User can select PC Source Type ChartField to display on the report.
• User can provide range of PC Source Type, "Value," and "Value To" Prompts.
• Both prompts allow user to select active and inactive status PC Source Type.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all PC Source Type values.

Optional

Data Field

Florida PALM RECORD.FIELD mapping

Report Header

Business Unit

Run Control Page value

Date From

Run Control Page value

Date To

Run Control Page value

Organization

Run Control Page value

Account

Run Control Page value

Fund

Run Control Page value

Budget Entity

Run Control Page value

Category

Run Control Page value

State Program

Run Control Page value

Grant

Run Control Page value

Contract

Run Control Page value

OA1

Run Control Page value

OA2

Run Control Page value

PC Business Unit

Run Control Page value

Project

Run Control Page value

Activity

Run Control Page value

PC Source Type

Run Control Page value

Report Sub-Header Section

Business Unit

Run Control Page value

Organization

Run Control Page value

Fund

Run Control Page value

Budget Entity

Run Control Page value

Report Detail

Organization

KK_ACTIVITY_LOG.DEPTID

Account

KK_ACTIVITY_LOG.ACCOUNT

Account Description

Account ChartField description

Fund

KK_ACTIVITY_LOG.FUND_CODE

Budget Entity

KK_ACTIVITY_LOG.BUDGET_REF

Category

KK_ACTIVITY_LOG.PRODUCT

State Program

KK_ACTIVITY_LOG.CHARTFIELD2

Grant

KK_ACTIVITY_LOG.PROGRAM_CODE

Contract

KK_ACTIVITY_LOG.CHARTFIELD1

OA1

KK_ACTIVITY_LOG.CLASS_FLD

OA2

KK_ACTIVITY_LOG.CHARTFIELD3

PC Business Unit

KK_ACTIVITY_LOG.BUSINESS_UNIT_PC

Project

KK_ACTIVITY_LOG.PROJECT_ID

Activity

KK_ACTIVITY_LOG.ACTIVITY_ID

PC Source Type

KK_ACTIVITY_LOG.RESOURCE_TYPE

Allotments

• Sum of Budget balance from KK_ACTIVITY_LOG for allotment detail Budget ledger for provided date range on the run control page.
• KK_TRAN_DT Between Date From and Date To
• Multiply calculated balance by -1.

Expenditures (MTD)

• Sum of Expense balance from KK_ACTIVITY_LOG for allotment detail Expense ledger for provided date range on the run control page.
• KK_TRAN_DT Between Date From and Date To

Expenditures (YTD)

• Sum of Expense balance YTD from KK_ACTIVITY_LOG for allotment detail Expense ledger.
• KK_TRAN_DT Between ‘07/01/20XX’ and Date To. Where XX is a fiscal year derived from ‘To Date’ value.

Encumbrances

• Sum of Encumbrance balance from KK_ACTIVITY_LOG for allotment detail Encumbrance ledger for provided date range on the run control page.
• KK_TRAN_DT Between Date From and Date To.

Allotment Balances

(Allotment - Expenditures (YTD) – Encumbrance) * -1

Date

Revision Description

12/01/2023

Original Version