Speedkey Report (SDR003)

Data Field

Data Field Details

Report Request Parameter

SetID (Business Unit (BU) – SpeedKey SetID)

• Prompt table values
  • "%" for All 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)
• If value is {blank}, pop-up Error message, Field is required.
• Business Unit Security is applied

Required

Payroll Indicator

• Dropdown values
  • All
  • Non-Payroll
  • Payroll

Required

• Dropdown values
  • All
  • Non-PCard
  • PCard

Required

Line Type

• Dropdown values
  • All
  • Single Line
  • Multiple Line

Required

SpeedKey Status

• Dropdown values
  • All
  • Active
  • Inactive

Required

SpeedKey

• Prompt values
  • %
  • Single

Required

From Effective Date

Calendar prompt/edit.

Optional

To Effective Date

Calendar prompt/edit.

Optional

ChartField (CF) Section

Organization

• User can select range of Organization from "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

Account

• User can select range of Organization from "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

Fund

• User can select range of Fund from "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

• User can select range of Budget Entity in "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 ag.

Optional

Category

• User can select range of Categories from "Value" and "Value To" Prompts.
• Both prompts allow user to select active and inactive status Categories.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all Category values.

Optional

State Program

• User can select State Program ChartField to display on the report.
• User can select range of State Program from "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

• User can select Grant ChartField to display on the report.
• User can select range of Grant from "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

• 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

• 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 OA1 values.

Optional

OA2

• 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

• 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

• 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

• 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

• 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 Types.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all PS Source Type values.

Optional

PC Category

• User can select PC Category ChartField to display on the report.
• User can provide range of PC Category, "Value" and "Value To" Prompts.
• Both prompts allow user to select active and inactive status PC Category.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all PC Category values.

Optional

PC Subcategory  

• User can select PC Subcategory ChartField to display on the report.
• User can provide range of PC Subcategory, "Value" and "Value To" Prompts.
• Both prompts allow user to select active and inactive status PC Subcategory.
• If both "Value" and "Value To" prompts left {blank}, then report fetches details against all PC Subcategory values.

Optional

Data Field

Florida PALM RECORD.FIELD mapping

Report Header section

SetID (Business Unit – SpeedKey SetID)

Run Control Page value

Payroll Indicator

Run Control Page value

Line Type

Run Control Page value

SpeedKey Status

Run Control Page value

SpeedKey

Run Control Page value

From Effective Date

Run Control Page value

To Effective Date

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

PC Category

Run Control Page value

PC Subcategory  

Run Control Page value

Report Detail

SetID

FLP_SPDKEY_TBL.SetID

SpeedKey

FLP_SPDKEY_TBL. FLP_SPEEDKEY

Payroll Indicator

FLP_SPDKEY_TBL.FLP_PAYROLL_INDCTR

Line Type

Line Type FLP_SPDKEY_TBL.ACCTG_LINE_TYPE

Effective Date

Effective Date  FLP_SPDKEY_TBL.EFFDT

Effective Status

Effective Date  FLP_SPDKEY_TBL.EFFDT

Description

FLP_SPDKEY_TBL.DESCR

Total Lines

FLP_SPDKEY_TBL.TOTAL_LINES

Module

FLP_SPDKEY_TBL.MODULE

Sequence Number

TBD.SEQUENCE_NBR_6FLP_SPDKEY_TBL. SEQUENCE_NBR_6

Percentage

FLP_SPDKEY_TBL.PERCENTAGE

Organization

FLP_SPDKEY_TBL.DEPTID

Account

FLP_SPDKEY_TBL.ACCOUNT

Fund

Fund FLP_SPDKEY_TBL.FUND_CODE

Budget Entity

FLP_SPDKEY_TBL.BUDGET_REF

Category

FLP_SPDKEY_TBL.PRODUCT

State Program

FLP_SPDKEY_TBL.CHARTFIELD2

Grant

FLP_SPDKEY_TBL.PROGRAM_CODE

Contract

FLP_SPDKEY_TBL.CHARTFIELD1

OA1

FLP_SPDKEY_TBL.CLASS_FLD

OA2

FLP_SPDKEY_TBL.CHARTFIELD3

PC Business Unit

FLP_SPDKEY_TBL.BUSINESS_UNIT_PC

Project

FLP_SPDKEY_TBL.PROJECT_ID

Activity

FLP_SPDKEY_TBL.ACTIVITY_ID

PC Source Type

FLP_SPDKEY_TBL.RESOURCE_TYPE

PC Category

FLP_SPDKEY_TBL.RESOURCE_CATEGORY

PC Subcategory  

FLP_SPDKEY_TBL.RESOURCE_SUB_CAT

System Source (Online, XLS, EXT)

FLP_SPDKEY_TBL.SYSTEM_SOURCE

Create DateTime

FLP_SPDKEY_TBL.CREATEDTTM

Created By

FLP_SPDKEY_TBL.CREATEOPRID

Last Update DateTime

FLP_SPDKEY_TBL.LASTUPDTTM

Last Updated By

FLP_SPDKEY_TBL.LASTUPDOPRID

Date

Revision Description

12/01/2023

Original Version

1. Added additional bullet point of PCard and non-PCard Speedkeys under the description
2. Added PCard Indicator within the Selection Criteria
3. Added PCard Indicator within the Report Layout