COSC_ATT_E_Requirments.xlsx

XLSX spreadsheet 129 KB Posted

Attached to
Enterprise Resource Planning (ERP) Software and Implementation Services State and local contract opportunity
Solicitation number
2026-027
Issued by
Polk County, Florida

About this file

Summary of City of St. Cloud ERP Functional Requirements Document

This document is a comprehensive functional requirements spreadsheet for the City of St. Cloud, Florida's Enterprise Resource Planning (ERP) system procurement, containing 1,623 detailed system requirements across Finance, Human Resources, Procurement, and Capital Asset Management modules. The City seeks an integrated ERP solution with tight integration between Finance and HR/Payroll functions to replace its legacy AS 400-based Central Square system (in use since 2005) and several ancillary systems including OpenGov (budget), Cognos (reporting), HRIS, ExecuTime (timekeeping), and NeoGov (recruitment). The RFP was released on April 19, 2026, with a non-mandatory pre-response conference scheduled for May 4, 2026, a question submission deadline of May 18, 2026, and a proposal response deadline of June 9, 2026, at 10:00 a.m. submitted electronically through the City's e-Procurement portal. Committee evaluation commences June 15, 2026, with interviews and software demonstrations scheduled for the weeks of July 20, August 3, and August 10, 2026. A Notice of Intent to Award is anticipated by August 28, 2026, with contract negotiations expected between September and October 2026. Implementation is targeted to begin in November 2026, with a go-live date of October 2028.

The functional requirements document outlines specific system capabilities across 19 functional areas, including general ledger setup, budget control, journal entries, financial reporting, vendor management, invoice processing, accounts payable and receivable, asset management, human resources administration, benefits management, payroll processing, time entry and approval, procurement workflows, capital improvement planning, and treasury management. The requirements specify integration points with retained systems including Operative IQ (fire department assets), CityWorks (work orders), RecTrac (facility rentals), WasteWorks (utilities), and LaserFiche (document storage). Data conversion requirements span multiple modules with estimated record volumes ranging from 10 to 100,000 records. The City, with an annual budget of approximately $214.8 million and approximately 730 permanent and seasonal staff, does not disclose a specific award value or budget range. All proposers must demonstrate financial stability, provide current insurance certificates, and comply with federal requirements under 2 CFR Part 200 Uniform Guidance and Florida statutory requirements regarding public entity crimes, E-Verify compliance, drug-free workplace certification, and debarment standards. Multi-vendor proposals are permitted with clearly defined roles and responsibilities.

View the file

Other files for this state and local contract opportunity

Other files attached to Enterprise Resource Planning (ERP) Software and Implementation Services, newest first.
File Type Posted
Enterprise_Resource_Planning_(ERP)_Software_and_Implementation_Services_(Addendum_#3_Revision).pdf PDF
Enterprise_Resource_Planning_(ERP)_Software_and_Implementation_Services_(Addendum_#1_Revision).pdf PDF
Enterprise_Resource_Planning_(ERP)_Software_and_Implementation_Services.pdf PDF
I_COSC_ATT_I_Cost.xlsx XLSX spreadsheet
I_COSC_ATT_I_Cost.xlsx XLSX spreadsheet
COSC_ATT_H_Conversions.xlsx XLSX spreadsheet
COSC_ATT_H_Conversions.xlsx XLSX spreadsheet
COSC_ATT_G_Interface_List.xlsx XLSX spreadsheet
COSC_ATT_G_Interface_List.xlsx XLSX spreadsheet
COSC_ATT_F_Project_Staffing.xlsx XLSX spreadsheet
COSC_ATT_F_Project_Staffing.xlsx XLSX spreadsheet
COSC_ATT_E_Requirments.xlsx XLSX spreadsheet
COSC_ATT_D_Project_Expectations.docx DOCX document
COSC_ATT_D_Project_Expectations.docx DOCX document
COSC_ATT_C_Technology_Deployment.docx DOCX document
COSC_ATT_C_Technology_Deployment.docx DOCX document
COSC_ATT_B_Prof_Svcs_Reference.docx DOCX document
COSC_ATT_B_Prof_Svcs_Reference.docx DOCX document
COSC_ATT_A_Prof_Svcs_Background.docx DOCX document
COSC_ATT_A_Prof_Svcs_Background.docx DOCX document
Show all 20

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Functional Requirements City of St. Cloud, FL

Attachment E: Functional Requirements
Column E: Available Responses
YRequirement Met and Proposed (Standard features in the generally available product)
Y-NDRequirement Met and Proposed (Features that are not offered as a generally available product or require custom development)
NRequirement Not Met with Proposal
INeed More Information/Discussion
Column F: Available Responses
SRequirement and Feature Supported by Software Developer
TPSRequirement and Feature Supported by Third Party
NSRequirement and Feature Not Supported
NOTE:All exceptions and assumptions should be listed in the comments field
Req.#FunctionProcessRequirementImplementation ResponseSupport ResponseModule / SystemComments
1ACCGeneral Ledger Set UpSystem will provide a chart of account structure with multiple independent segments
2ACCGeneral Ledger Set UpSystem will provide a chart of account structure that accommodates project/grant tracking
3ACCGeneral Ledger Set UpSystem will provide budgeting capabilities that are directly integrated to the General Ledger and all accounting structures
4ACCGeneral Ledger Set UpSystem will provide general and project ledgers that use alpha numeric chart of account segments
5ACCGeneral Ledger Set UpSystem will provide a validation process of segment combinations on system transactions
6ACCGeneral Ledger Set UpSystem will provide two-way feeds with real-time information for its General, Budget, and Projects/Grants Ledgers
7ACCGeneral Ledger Set UpSystem will provide Chart of Accounts segments for "Programs" that can extend across the entire organization (as needed)
8ACCGeneral Ledger Set UpSystem will provide grant ledgers for tracking grants
9ACCGeneral Ledger Set UpSystem will provide project ledgers, or similar, for tracking project details
10ACCGeneral Ledger Set UpSystem will enable segments of the Chart of Accounts to be grouped on a user-defined basis into multiple reporting hierarchies (by object for fund)
11ACCGeneral Ledger Set UpSystem will designate an account as active (available for posting, budgeting)
12ACCGeneral Ledger Set UpSystem will designate an account as inactive (not available for posting and budgeting)
13ACCGeneral Ledger Set UpSystem will only allow transactions to post to active accounts within any open period
14ACCGeneral Ledger Set UpSystem will restrict certain types of activity from posting to accounts (e.g., can't use PO against salary account)
15ACCGeneral Ledger Set UpSystem will prevent accounts from being deleted if any activity is posted to them
16ACCGeneral Ledger Set UpSystem will enable department requests for changes/additions to the Chart of Accounts
17ACCGeneral Ledger Set UpSystem will provide a different review and approval process based on the structure, or segment, of the requested change (e.g., Grant request to Grants office)
18ACCBudget ControlSystem will provide a budget control soft error setting (e.g., Warn user but allow)
19ACCBudget ControlSystem will provide a budget hard error setting (e.g., Do not allow user)
20ACCBudget ControlSystem will provide budgeting at one level while controlling at a different level (Example: budget by account/object but conduct budget control at program level)
21ACCBudget ControlSystem will enable budget control at summary roll up of account/object
22ACCBudget ControlSystem will enable budget control at summarized roll up categories
23ACCBudget ControlSystem will enable departments to track detail at a lower level than budget control is established in a segment
24ACCBudget ControlSystem will provide budget control for project and grant ledgers
25ACCJournal EntrySystem will enable journal entries to be entered by departments and routed through workflow for review, approval and posting
26ACCJournal EntrySystem will provide journal entries that are posted in real time and are available for reporting
27ACCJournal EntrySystem will run reports separately on posted or unposted journal entries
28ACCJournal EntrySystem will enable multiple line items for journal entries (please indicate any limitations in the notes column)
29ACCJournal EntrySystem will ensure that journal entries record the source of the transaction (e.g., manual entry or automated entry from another module)
30ACCJournal EntrySystem will ensure that journal entries are validated against the chart of account structure for valid accounts
31ACCJournal EntrySystem will ensure that journal entries are validated against available funds (budget check or cash availability check)
32ACCJournal EntrySystem will provide approved overrides for budget checks and restrictions (i.e. Finance)
33ACCJournal EntrySystem will validate journal entries against balancing entries (making sure all entries balance)
34ACCJournal EntrySystem will enable users to import journal entries from spreadsheets or text files (e.g., Microsoft Excel, Text)
35ACCJournal EntrySystem will ensure imported journal entries from interfaced systems go through budget and edit checks for each transaction
36ACCJournal EntrySystem will ensure imported transactions from spreadsheets are validated using the same business rules as transactions made in the system
37ACCJournal EntrySystem will batch post journal entries
38ACCJournal EntrySystem will provide “segregation-of-duties” checks so that users cannot post journal entries they created to the General Ledger
39ACCJournal EntrySystem will enable creating journal entries from previously entered journal entry formats (copy journal) by line item
40ACCJournal EntrySystem will enable creating journal entries from previously entered journal entry formats (copy journal) by entire journal entry
41ACCJournal EntrySystem will enable users to reverse journal entries with appropriate security and approvals
42ACCJournal EntrySystem will provide scheduled auto-reversals (deferrals at year-end)
43ACCJournal EntrySystem will provide "required" data fields for journal entries and will prevent transactions from posting until all "required" fields are completed
44ACCJournal EntrySystem will enable users to attach files to journal entries with a predefined retention period
45ACCJournal EntrySystem will enable the posting of transactions for multiple fiscal years at the same time (with proper permissions)
46ACCJournal EntrySystem will provide security that restricts the accounts users can post journal entries to
47ACCJournal EntrySystem will prevent duplicate journal entries and will provide effective dating for journal entries and scheduling (e.g., posting does not occur until effective date).
48ACCJournal EntrySystem will automatically balance journal entry by cash
49ACCRecurring Journal EntrySystem will provide templates and notifications for recurring journal entries
50ACCRecurring Journal EntrySystem will provide templates and notifications for recurring journal entries with the same dollar value
51ACCRecurring Journal EntrySystem will provide templates and notifications for recurring journal entries with varying dollar amounts
52ACCRecurring Journal EntrySystem will provide setting recurring journal entries occur at regular frequencies (e.g., setting start and stop dates)
53ACCRecurring Journal EntrySystem will enable journal entries to be scheduled (e.g., lease/debt schedules)
54ACCRecurring Journal EntrySystem will provide the ability to process a “trial post” Journal Entry, without truly posting to the GL, so the users can see the impact of the JE, and if there is a mistake before they finalize
55ACCMonth End CloseSystem will provide closing of months
56ACCMonth End CloseSystem will provide a month-end checklist noting needed actions (e.g., pulling in investment revenue) to help users complete all necessary tasks.
57ACCInternal TransfersSystem will create automated "due to/due from" transactions
58ACCInternal TransfersSystem will create inter-entity billings based on direct transaction costs
59ACCInternal TransfersSystem will create inter-entity billings based on indirect transaction costs
60ACCInternal TransfersSystem will create inter-entity billings based on cost allocations
61ACCInternal TransfersSystem will ensure all inter-entity transactions are self-balancing
62ACCInternal TransfersSystem will ensure all inter-entity transactions are facilitated by departmental approvals
63ACCAnnual CloseSystem will provide an annual closing process
64ACCAnnual CloseSystem will provide the capability to accrue payables/receivables to the proper period
65ACCAnnual CloseSystem will provide multiple periods, beyond 12, for adjusting entries and annual reporting (please specify how many periods the system can support)
66ACCAnnual CloseSystem will roll encumbrances to next year carrying forward budget
67ACCAnnual CloseSystem will roll encumbrances to next year carrying forward encumbrance
68ACCAnnual CloseSystem will remove any unspent funds and carries forward the budget when rolled purchase orders are closed in the new year
69ACCAnnual CloseSystem will provide multiple types of period closes (i.e., Year-End, Month End, Quarter-End)
70ACCAnnual CloseSystem will provide internal controls that can limit access (e.g., only allow the Finance department to make adjustments after the financial period is closed).
71ACCFinancial ReportingSystem will provide a flexible reporting and query capability on any segment(s) within the financial structure
72ACCFinancial ReportingSystem will provide an inquiry function that can drill down (or across) from summaries to details within the financial structure
73ACCFinancial ReportingSystem will provide Statement of Revenues and Expenditures
74ACCFinancial ReportingSystem will provide annual financial report: Government-Wide Statements: Statement of Net Assets
75ACCFinancial ReportingSystem will provide annual financial report : Government-Wide Statements: Statement of Activities
76ACCFinancial ReportingSystem will provide annual financial report : Balance Sheet - All Governmental Funds
77ACCFinancial ReportingSystem will provide reconciliation of Balance sheet - Governmental funds to statement of net assets.
78ACCFinancial ReportingSystem will provide narrative drafting capability for annual financial report (Management's Discussion & Analysis, Transmittal Letter, Notes, Statistical Section) with the ability to link to data from financial statements
79ACCFinancial ReportingSystem will provide annual financial report : Statement of Revenues, Expenditures, and Changes in Fund Balances - Governmental Funds
80ACCFinancial ReportingSystem will provide annual financial report : Statement of Revenues, Expenditures, and Changes in Fund Balances - Budget to Actual - by Governmental Funds
81ACCFinancial ReportingSystem will provide annual financial report : Statement of Net Assets - Proprietary Funds
82ACCFinancial ReportingSystem will provide annual financial report : Statement of Revenues, Expenses, and changes in net assets - proprietary funds by fund
83ACCFinancial ReportingSystem will provide annual financial report : Statement of Revenues, Expenses, and changes in net assets - proprietary funds by function
84ACCFinancial ReportingSystem will provide annual financial report : Statement of Cash Flows - Proprietary Funds
85ACCFinancial ReportingSystem will provide annual financial report : Statement of Net Assets
86ACCFinancial ReportingSystem will provide annual financial report : Statement of Activities by function
87ACCFinancial ReportingSystem will provide annual financial report: Schedule of Revenue, Expenditures, and Changes in Fund Balance - Budget to Actual
88ACCFinancial ReportingSystem will provide accruals conversion to support GASB reporting standards
89ACCFinancial ReportingSystem will enable report scheduling for distribution to specific system users
90ACCFinancial ReportingSystem will enable the import/export of Microsoft Office documents (i.e. Word, Excel, PDF) for appending to reports for distribution throughout the system
91ACCFinancial ReportingSystem will enable conversion entries to ensure funds balance (e.g., to get the data to a place where staff can create a government wide-statement in the “ACFR Builder” systems)
92ACCFinancial ReportingSystem will provide monthly interim reports (budget/actual information)
93ACCFinancial ReportingSystem will provide reconciliation of the Statement of Revenue, Expenditures, and Changes in Fund Balances of Governmental Funds to the Statement of Activities
94ACCFinancial ReportingSystem will generate a report that shows the City's cash position.
95APVendor FileSystem will use one vendor file for purchasing, accounts payable, and credit cards
96APVendor FileSystem will provide multiple telephone numbers (types), and multiple email addresses
97APVendor FileSystem will link vendor files to customer files for accounts receivable
98APVendor FileSystem will prevent duplicate vendors using multi-field checks (e.g., Tax ID, legal name, other identifiers)
99APVendor FileSystem will prevent duplicate vendors by identifying duplicate vendor EINs
100APVendor FileSystem will prompt users to collect additional information from vendors when necessary
101APVendor FileSystem will enable users with security access to temporarily deactivate vendors
102APVendor FileSystem will deactivate vendors that have not been used within a City-defined timeframe
103APVendor FileSystem will enable users with security access to merge two vendors, including each vendor's history
104APVendor FileSystem will provide parent-child relationships between vendor records
105APVendor FileSystem will maintain multiple address types
106APVendor FileSystem will maintain multiple location addresses for each vendor
107APVendor FileSystem will maintain foreign addresses
108APVendor FileSystem will identify default payment remittance addresses
109APVendor FileSystem will identify 1099 vendors
110APVendor FileSystem will maintain multiple types of 1099 vendors
111APVendor FileSystem will identify cumulative purchase history by vendor to identify common vendors
112APVendor FileSystem will maintain different types of vendors (onetime, ongoing, etc.) and report based on the “type” of vendor
113APVendor FileSystem will enable users to place all vendor payments on hold
114APVendor FileSystem will store vendor payment preferences (e.g., ACH, check, or virtual pay)
115APVendor FileSystem will identify vendor-specific terms and conditions for purchase orders
116APVendor FileSystem will confirm that vendors are not City employees
117APVendor FileSystem will store vendors' Certificate of Insurance
118APVendor FileSystem will auto-populate vendors' information based on W-9s
119APVendor FileSystem will track MBE/WBE designations
120APVendor Self-ServiceSystem will enable vendors to upload related documents to match POs
121APVendor Self-ServiceSystem will enable vendors to register with the City as a prospective vendor
122APVendor Self-ServiceSystem will enable vendors to update contact information
123APVendor Self-ServiceSystem will enable vendors to classify goods/services using City commodity codes and NIGP codes
124APVendor Self-ServiceSystem will enable vendors to upload W-9 and other documentation through self-service
125APVendor Self-ServiceSystem will enable vendors to access purchase orders and submit invoices
126APVendor Self-ServiceSystem will enable vendors to access and submit bids/quotes
127APVendor Self-ServiceSystem will enable vendors to access payment status
128APVendor PerformanceSystem will track vendor performance information and include a comment field
129APVendor PerformanceSystem will enable users to place vendors in debarment status
130APInvoice ProcessingSystem will be configured to add differing levels of approvers
131APInvoice ProcessingSystem will scan and process invoices for approval
132APInvoice ProcessingSystem will provide automated approval workflows
133APInvoice ProcessingSystem will generate status notifications
134APInvoice ProcessingSystem will fill information for invoices from purchase orders
135APInvoice ProcessingSystem will enable users to enter direct claims without purchase orders
136APInvoice ProcessingSystem will provide approval workflows for invoices from purchase orders and invoices without purchase orders
137APInvoice ProcessingSystem will route invoices for approval based on amount
138APInvoice ProcessingSystem will route invoices for approval based on point of entry (entered by department vs. AP)
139APInvoice ProcessingSystem will route invoices for approval based on PO vs no PO
140APInvoice ProcessingSystem will route invoices for approval based on chart of account information
141APInvoice ProcessingSystem will enable users to make partial invoice payments
142APInvoice ProcessingSystem will apply credit memos to invoices for incorrect invoices or POs
143APInvoice ProcessingSystem will enable payment of multiple purchase orders from one invoice
144APInvoice ProcessingSystem will enable multiple invoices to be received and processed for one purchase order
145APInvoice ProcessingSystem will automatically check for and prevent duplicate invoice numbers for the same vendor to avoid double-payment
146APInvoice ProcessingSystem will enable files to be attached to invoices (e.g., scanned image of invoice)
147APInvoice ProcessingSystem will provide OCR of scanned invoices
148APInvoice ProcessingSystem will not limit characters on invoice numbers (Please note limitations, e.g., special characters, formatting, etc.)
149APInvoice ProcessingSystem will enable users to check status of submitted invoices
150APInvoice ProcessingSystem will enable users to search invoice by project code, item description, or creator
151APInvoice ProcessingSystem will process payments to one-time customers
152APCredit MemoSystem will process refunds to one-time customers
153APCredit MemoSystem will enable users to upload refund payments from other systems/third-party applications
154APCredit MemoSystem will enable users to apply credit memos to invoices
155APCredit MemoSystem will set a minimum dollar amount checks can be issued for
156APMatchingSystem will provide 2 way matching (e.g., purchase order, invoice)
157APMatchingSystem will provide 3 way matching (e.g., purchase order, receiving document, invoice)
158APMatchingSystem will provide matching at the line-item level
159APMatchingSystem will enable limits on PO and invoice prices for matching based on percentages and limits (e.g., invoice can't be greater than 105% of purchase order or $5 [whichever is greater])
160APMatchingSystem will exclude freight and shipping charges from matching requirements
161APMatchingSystem will provide notifications when there is not a match
162APPayment ProcessSystem will enable the creation of templates for recurring AP invoices with pre-defined account distribution
163APPayment ProcessSystem will schedule approved invoices using configurable drivers (e.g., invoice date, user-entered date, grouped by department)
164APPayment ProcessSystem will print checks on pre-printed check stock
165APPayment ProcessSystem will print checks with MICR encoding
166APPayment ProcessSystem will print checks with electronic signatures
167APPayment ProcessSystem will pay vendors electronically (e.g., ACH, wire transfer, etc.) using standard NACHA formats (ctx)
168APPayment ProcessSystem will enable printing of checks without any impact on other users in system
169APPayment ProcessSystem will print checks based on regular schedule (pay cycle)
170APPayment ProcessSystem will print on-demand checks (single check printing)
171APPayment ProcessSystem will create/sort checks based upon chart of account information (e.g., fund or department)
172APPayment ProcessSystem will create/sort checks based upon vendor
173APPayment ProcessSystem will create/sort checks based upon payment type (e.g., employee reimbursement, one time vendors, etc.)
174APPayment ProcessSystem will automatically save check images
175APPayment ProcessSystem will send electronic remittance advice for EFT payments to vendor through email
176APPayment ProcessSystem will enable users to issue multiple checks to one vendor in a single check run
177APPayment ProcessSystem will enable users to issue one check for multiple invoices in a single check run
178APPayment ProcessSystem will itemize invoices (including the vendor invoice number) on the remittance advice
179APPayment ProcessSystem will enable users to place payments on hold
180APPayment ProcessSystem will enable users to broadcast messages that will appear on all AP check stubs
181APPayment ProcessSystem will enable users to enter messages for specific vendors that appear on their specific check stubs
182APPayment ProcessSystem will provide positive pay (Status and Vendor Name - Payee Positive)
183APPayment ProcessSystem will provide a service date field on invoices
184APPayment ProcessSystem will ensure the General Ledger records transactions according to GAAP standards
185APPayment ProcessSystem will enable users to download records from the system/cloud while ensuring data security
186APEmployee ReimbursementSystem will enable employees to enter pre-travel and travel advance requests
187APEmployee ReimbursementSystem will provide pre-travel (advance request) approval workflows
188APEmployee ReimbursementSystem will provide GSA per diem and mileage amounts for travel
189APEmployee ReimbursementSystem will provide self-service reimbursement requests with receipt/document upload abilities in one process
190APEmployee ReimbursementSystem will link employee reimbursement requests with travel advances
191APEmployee ReimbursementSystem will ensure all expense reimbursements follow approval workflows
192APEmployee ReimbursementSystem will track and reimburse multiple types of reimbursements (e.g., travel, training, mileage, uniform, etc.)
193APEmployee ReimbursementSystem will include per diem travel amounts in employees' paychecks (not a separate check)
194APRetainageSystem will automatically calculate retention amounts and remove them from invoices
195APRetainageSystem will automatically apply retention amounts to invoice payments from vendor files, contracts, and purchase orders
196APRetainageSystem will release retainage by selected payments, based on user-defined approval
197APRetainageSystem will release retention by amount
198APVoid and CancelSystem will enable users to cancel warrants, and will automatically correct all accounting entries to reverse payment, including contract balances
199APVoid and CancelSystem will enable users to void checks and re-issue replacement checks
200APVoid and CancelSystem will enable users to cancel prior years' checks, only void current year checks, and will automatically credit back designated accounts
201ATGeneral RequirementsSystem will provide drill-down capabilities for recruitment candidates' profiles
202ATGeneral RequirementsSystem will track performance management records and provide role-based security for accessibility
203ATGeneral RequirementsSystem will purge records based on user-defined timeframes
204ATJob AnnouncementSystem will create job announcements to fill any open positions and job classifications
205ATJob AnnouncementSystem will create job announcements that contains all City required data (data may be different for each job announcement)
206ATJob AnnouncementSystem will classify pre-requisite information as either mandatory or desired
207ATJob AnnouncementSystem will create job posting announcements with position module information and will enable users to add/edit unique information
208ATJob AnnouncementSystem will include salary/comp ranges for positions job postings
209ATJob AnnouncementSystem will route job announcements through approval workflows prior to posting
210ATJob AnnouncementSystem will track posting dates for job announcements
211ATJob AnnouncementSystem will provide automatic job postings (post-approval) to third party sites (please list the job boards that the postings will automatically post to in the comments)
212ATJob AnnouncementSystem will restrict users access to recruitment based on their business criteria (e.g. PD, Fire, City)
213ATJob AnnouncementSystem will integrate with social media for application pool/recruiting (e.g. Linked In, etc.)
214ATJob AnnouncementSystem will provide text communications throughout the recruitment process
215ATJob AnnouncementSystem will provide digital signature functionality
216ATJob AnnouncementSystem will enable authorized users to import/export data from the system
217ATJob AnnouncementSystem will be accessible in multiple languages
218ATJob AnnouncementSystem will be ADA compliant
219ATJob AnnouncementSystem will process information in real-time
220ATJob AnnouncementSystem will feed job postings (system-created) to other third-party systems
221ATJob AnnouncementSystem will pull job postings created in other third-party systems
222ATJob ApplicationSystem will manage different application templates for different recruitment types (e.g., temporary, internal, full time, etc.)
223ATJob ApplicationSystem will include job application templates that contain Citywide questions and standard information
224ATJob ApplicationSystem will enable users to add position-specific questions to the job application templates
225ATJob ApplicationSystem will enable applicants to save multiple resumes
226ATJob ApplicationSystem will enable applicants to create and save profiles/applications, even if they are not ready to apply for a specific job at that time
227ATJob ApplicationSystem will enable applicants to apply to more than one position, and/or allow City staff to recommend the applicant to other jobs besides the one they originally applied for
228ATJob ApplicationSystem will accept applications for volunteers and/or non-compensated positions such as Boards, Committees, etc.
229ATJob ApplicationSystem will prompt applicants in the application pool to update their resume after a user-defined space of time
230ATRecruitment PlanSystem will purge/remove applications that are in the application pool after a user-defined space of time
231ATRecruitment PlanSystem will query applicant pool for certain characteristics (e.g., certifications)
232ATRecruitment PlanSystem will enable staff to analyze minimum qualifications against job classification characteristics and qualifications
233ATRecruitment PlanSystem will provide detailed reporting metrics for the City’s user-defined recruitment goals
234ATRecruitment PlanSystem will extract and analyze data from job descriptions, candidate applications, and current employee pay structures within the same grade to produce fair and data-supported compensation recommendations for all scenarios
235ATRecruitment PlanSystem will confirm vacant positions at the time of recruitment
236ATApplicant Self-ServiceSystem will enable users to apply for positions via the web
237ATApplicant Self-ServiceSystem will send automatic notifications when applications are completed, submitted by applicant, and received
238ATApplicant Self-ServiceSystem will enable applicants to upload files to web application (e.g., resume, certification, etc.)
239ATApplicant Self-ServiceSystem will enable users to create profiles and apply to multiple jobs without re-entering information
240ATApplicant Self-ServiceSystem will track interview dates
241ATApplicant Self-ServiceSystem will enable applicants to review where they are in the hiring process
242ATApplicant Self-ServiceSystem will enable applicants to schedule and confidentially track assessments, interviews, screenings, pre-employment medicals/fitness exams, etc.
243ATEEO ReportingSystem will track all EEO information
244ATEEO ReportingSystem will manage EEO questionnaires
245ATEEO ReportingSystem will hide EEO data from non-authorized users via role-based access (including recruiting managers)
246ATApplicant TrackingSystem will pre-screen applicants to determine eligibility based on key requirements
247ATApplicant TrackingSystem will retain applications for durations required by law
248ATApplicant TrackingSystem will track the application process
249ATApplicant TrackingSystem will enable users to add comments about application status
250ATApplicant TrackingSystem will identify applicants as past or current employees
251ATApplicant TrackingSystem will prevent unauthorized users from viewing confidential information (criminal history, medical info, etc.)
252ATApplicant TrackingSystem will notify applicants when positions have been filled or pulled
253ATApplicant TrackingSystem will notify departments when positions have been filled or pulled
254ATApplicant TrackingSystem will notify departments when applicant statuses have changed (e.g. 'hired' or 'offer accepted' or 'declined')
255ATApplicant TrackingSystem will track employee history and applicant's application history (track the number of jobs an applicant has applied for by department)
256ATApplicant TrackingSystem will track the history of applicants, including reasons they weren't hired or didn't proceed in the application process (not hired, failed PT test)
257ATApplicant TrackingSystem will track exam/assessment scores from third party systems where exams were taken
258ATEligibility ListsSystem will enable users to manually add to or remove applicants from eligibility lists
259ATEligibility ListsSystem will route eligibility lists for approval (e.g., certification by City Manager)
260ATEligibility ListsSystem will maintain referral lists (i.e., applicants that are a good fit for the position)
261ATEligibility ListsSystem will track dates for adding/removing applicants from eligibility lists
262ATEligibility ListsSystem will enable the administration of separate eligibility lists for each job classification
263ATEligibility ListsSystem will enable users to override the system-generated eligibility list
264ATEligibility ListsSystem will manage rolling eligibility lists (list stays active but applicant drops off list after set period of time)
265ATEligibility ListsSystem will maintain multiple eligibility lists for each classification including a main list
266ATNew Hire (Onboarding)System will enable new hires to receive and acknowledge City policies and the employee handbook during onboarding
267ATNew Hire (Onboarding)System will manage personal and City emails for applicants/new hires
268ATNew Hire (Onboarding)System will include an onboarding portal/page for welcome notices, etc.
269ATNew Hire (Onboarding)System will manage pre-requisite new hire training
270ATNew Hire (Onboarding)System will automatically report through/with E-Verify
271ATNew Hire (Onboarding)System will track when level 2 fingerprinting expire
272ATNew Hire (Onboarding)System will assign Employee ID numbers
273ATNew Hire (Onboarding)System will generate notifications when benefits selections are completed
274ATNew Hire (Onboarding)System will change new hire status
275BUDGeneralSystem will provide comparative reporting and inquiries throughout the budget process
276BUDGeneralSystem will provide an automated iterative communication process throughout budget development (e.g., for changes and updates to budget structures and values)
277BUDGeneralSystem will provide unlimited versions (or levels) of the budget both for departmental and city wide requests
278BUDGeneralSystem will provide multiple year budgeting and reporting
279BUDGeneralSystem will provide multiple year budgeting for projects/grants
280BUDGeneralSystem will integrate with MS Excel and MS Word for analysis and documentation
281BUDGeneralSystem will provide analysis tools for trend analyses based on budget history
282BUDGeneralSystem will integrate with project and grant accounting to provide data for capital budget development and tracking
283BUDGeneralSystem will provide multi-year funding source budgeting
284BUDGeneralSystem will provide revenue budgeting
285BUDGeneralSystem will provide parallel operating and capital budget development processes
286BUDGeneralSystem will warn users when budget lines are projected to exceed budget
287BUDGeneralSystem will manage line-item budget requests and versioning
288BUDGeneralSystem will track multiple funding sources for a single line item
289BUDGeneralSystem will enable changes to funding sources after their initial selection
290BUDGeneralSystem will translate budget data using visualization tools
291BUDGeneralSystem will manage decision-making variables (e.g., FTEs') related to budgeting
292BUDGeneralSystem will split revenue between multiple departments and make allocations based on user-defined percentages
293BUDGeneralSystem will track budget requests at the line-item level
294BUDGeneralSystem will use AI (machine learning) for financial reporting (Explain functionality in comments)
295BUDGeneralSystem will use AI (machine learning) for reporting recurring journal entries (Explain functionality in comments)
296BUDGeneralSystem will use AI (generative) for reporting unusual/non-recurring journal entries (Explain functionality in comments)
297BUDGeneralSystem will use AI (generative) for reporting recurring journal entries (Explain functionality in comments)
298BUDBudget RequestsSystem will accommodate entering departmental budget details (by accounting structure within a department)
299BUDBudget RequestsSystem will enable departments to include narratives in their budget requests
300BUDBudget RequestsSystem will maintain versioning, identifying who makes changes in the system
301BUDBudget RequestsSystem will enable users to maintain version history while promoting one version for submission to budget development process
302BUDBudget RequestsSystem will enable users see prior years actuals and prior year budgets in the budget module
303BUDBudget RequestsSystem will provide ad-hoc and dashboard reporting
304BUDBudget RequestsSystem will integrate with the HR/payroll system to provide staffing budget data, and FTEs
305BUDBudget RequestsSystem will provide workflow approvals
306BUDBudget RequestsSystem will enable entering budget details for project budgets (over multiple years - up to life of project)
307BUDBudget RequestsSystem will pre-populate budget entry fields with the previous year's adopted budget
308BUDBudget RequestsSystem will pre-populate budget entry fields based on various user preferences
309BUDBudget RequestsSystem will prepare budgets for revenues and expenses
310BUDBudget RequestsSystem will enable departments enter budget requests, including requested budget amounts
311BUDBudget RequestsSystem will enable departments enter budget requests, including changes/additions/deletions of positions
312BUDBudget RequestsSystem will enable departments enter narrative information with budget requests (E.g., department goals, challenges, highlights of major changes, etc.)
313BUDBudget RequestsSystem will enable departments attach documentation when entering budget requests
314BUDBudget RequestsSystem will group budget requests into decision packages (e.g., multiple line items that go together)
315BUDBudget RequestsSystem will enable budget requests to be identified as supplemental requests
316BUDBudget RequestsSystem will prioritize budget requests (decision packages)
317BUDBudget RequestsSystem will enable users to create different budget projections/scenarios (e.g., what if 5% cut?)
318BUDBudget RequestsSystem will enable users to apply percentages, fixed amounts, or other formula-driven increases/decreases to budgeted figures on a line-by-line basis
319BUDBudget RequestsSystem will enable users to flag one-time budget events that it automatically removes from the next years' budget
320BUDBudget RequestsSystem will integrate with the contracts module to ensure future year costs for multi-year contracts are included in departmental budget requests
321BUDBudget RequestsSystem will manage multi-year contracts that renew every year (please explain functionality in the comments)
322BUDBudget RequestsSystem will enable users create multiple versions of budget requests for "what if" scenario simulation
323BUDBudget RequestsSystem will lock the requested budget based on the object code
324BUDProgram BudgetingSystem will enable users to prepare budgets by program (can be across multiple departments)
325BUDProgram BudgetingSystem will prioritize program budgets
326BUDProgram BudgetingSystem will link project budgets to strategic goals
327BUDProgram BudgetingSystem will track performance measures on each program
328BUDProgram BudgetingSystem will track program narrative and goals for each program
329BUDBudget DevelopmentSystem will automatically roll department worksheets into the organization-wide master budget
330BUDBudget DevelopmentSystem will maintain history of multiple budget versions (e.g., requested, recommended, adopted, revised, etc.)
331BUDBudget DevelopmentSystem will enable users modify all departmental budget worksheets, via security and workflow approvals
332BUDBudget DevelopmentSystem will provide revenue and expenditure forecasting with scenario modeling capabilities
333BUDBudget DevelopmentSystem will provide forecasting based on benefits costs and collective bargaining/known future benefit changes
334BUDBudget DevelopmentSystem will forecast debt scenarios
335BUDBudget DevelopmentSystem will create exportable budget books from entered data
336BUDBudget DevelopmentSystem will automate budget book updates based on changes during budget development
337BUDCapital BudgetingSystem will facilitate the development of a multi-year capital improvement plan, up to 10 years
338BUDCapital BudgetingSystem will prioritize capital projects by year
339BUDCapital BudgetingSystem will roll up project budgets to create departmental capital budgets and the overall capital improvement plan
340BUDCapital BudgetingSystem will provide multi-year capital project budgeting
341BUDCapital BudgetingSystem will utilize multiple funding sources to develop capital budgets
342BUDCapital BudgetingSystem will identify spending information on bond related issues, especially for bonds that fund multiple projects
343BUDCapital BudgetingSystem will feed individual capital project budgets into the budget module
344BUDCapital BudgetingSystem will enable users to identify ongoing operating costs for each capital project
345BUDCapital BudgetingSystem will enable users to reconcile and report against project accounting and General Ledger
346BUDPersonnel BudgetingSystem will project and budget tax and benefit costs based on current employee salary and current benefit elections
347BUDPersonnel BudgetingSystem will project and budget tax and benefit costs based on position salary range and default benefit elections
348BUDPersonnel BudgetingSystem will enable users request new positions in proposed budgets
349BUDPersonnel BudgetingSystem will enable proposing changing position statuses as part of budget development (e.g., funded - unfunded positions)
350BUDPersonnel BudgetingSystem will enable users to propose salary amount changes based on security and permissions (i.e., reclassification )
351BUDPersonnel BudgetingSystem will automatically adjust benefits/tax amounts with changes to salary amounts
352BUDPersonnel BudgetingSystem will enable allocation of position costs to multiple segments of the Chart of Accounts (e.g., organizational codes, programs, projects, grants, etc.)
353BUDPersonnel BudgetingSystem will calculate personnel based on FTE
354BUDPersonnel BudgetingSystem will provide different fixed cost distribution based on percentage allocation to a department
355BUDPersonnel BudgetingSystem will mirror personnel budget with position control structure in the HR module
356BUDPersonnel BudgetingSystem will project equipment costs (i.e., vehicles, software, hardware) associated with new requested positions
357BUDPersonnel BudgetingSystem will project ongoing maintenance equipment costs associated with new requested positions
358BUDPersonnel BudgetingSystem will notify internal service departments of new positions requested by operating departments so they can increase their budgets for equipment and maintenance based on system projections
359BUDBudget ProjectionsSystem will calculate budget estimates to project spending during the remainder of the fiscal year
360BUDBudget ProjectionsSystem will project revenues and expenses
361BUDBudget ProjectionsSystem will provide budget projections based on user-defined parameters
362BUDBudget ProjectionsSystem will provide straight-line projections
363BUDBudget ProjectionsSystem will provide projection methods based on last year actuals
364BUDMulti-Year BudgetingSystem will manage a two-year budget, roll the change, and adjust for the second year within the system.
365BUDMulti-Year BudgetingSystem will roll dates (e.g. benefit allocations) from one year to the next.
366BUDMulti-Year BudgetingSystem will provide different scenarios for years one and two
367BUDBudget AdjustmentsSystem will enable departments to propose internal budget transfers, via workflow approvals and notifications, for capital and operating budgets
368BUDBudget AdjustmentsSystem will provide workflows based on transferring party and receiver (e.g., within department/division or between department/division)
369BUDBudget AdjustmentsSystem will provide workflows based on transfers within or between budget categories (e.g., salary/supplies/materials/etc.)
370BUDBudget AdjustmentsSystem will enable departments to propose additional budget requests (after the budget is approved)
371BUDBudget AdjustmentsSystem will validate and enforce rules that all budget amendments and transfers must balance
372BUDBudget AdjustmentsSystem will provide funds availability check when entering budget amendments
373BUDBudget AdjustmentsSystem will enable users to view workflow status of a pending budget adjustment request
374BUDBudget ProjectionsSystem will track KPIs/Performance (especially non-numeric values)
375BUDBudget AdjustmentsSystem will generate a summary of changes in the dashboard
376BUDBudget AdjustmentsSystem will provide an exclusive executive-level dashboard
377BUDCapital BudgetingSystem will enable users to drill down and view detailed Pcard/expense information
378BUDCapital BudgetingSystem will incorporate scoring criteria to prioritize capital projects.
379BUDCapital BudgetingSystem will track and show contingencies for capital projects
380BUDCapital BudgetingSystem will enable departments to view capital project requests
381BUDCapital BudgetingSystem will track revenue and expenditures in a subledger
382BUDCapital BudgetingSystem will enable users to monitor both hard and soft costs for a project
383CAAsset Set UpSystem will track capitalized items
384CAAsset Set UpSystem will sort assets by funding type (e.g., grants)
385CAAsset Set UpSystem will track non-capitalized items (items valued below the depreciation threshold amount) and is able to differentiate these items from capital assets
386CAAsset Set UpSystem will identify assets based on capitalization threshold
387CAAsset Set UpSystem will enable different capitalization thresholds for each asset type
388CAAsset Set UpSystem will integrate asset functionality with all other system-based financial functions (e.g., procurement and payables, project/grant accounting and budget/GL)
389CAAsset Set UpSystem will enable assets to have multiple account distributions (including multiple funds)
390CAAsset Set UpSystem will track infrastructure assets in bulk (e.g., roads, pipes, apertures, etc.)
391CAAsset Set UpSystem will automatically generate a unique asset number for each city asset
392CAAsset Set UpSystem will enable multiple unique IDs for a single asset (e.g., Asset ID, Department ID, or ID from another application)
393CAAsset Set UpSystem will generate tags for attaching to assets
394CAAsset Set UpSystem will track asset information including description, dates, relevant numbers (VIN, serial, barcode, etc.), location, method of acquisition, etc.
395CAAsset Set UpSystem will track asset disposal information
396CAAsset Set UpSystem will track the Catalog of Federal Domestic Assistance (CFDA) number to the asset
397CAAsset Set UpSystem will enable users to attach pictures and documents to assets
398CAAsset Set UpSystem will track and identify the finance sources of assets
399CAAsset Set UpSystem will track leased assets in compliance with GASB 87, 96, and any other legal or industry requirements
400CAAsset Set UpSystem will track subscription-based software
401CAAsset Set UpSystem will provide barcode technology for asset identification and inventory
402CAAsset Set UpSystem will manage barcode, image recognition, and RFID technology for asset inventory management (e.g., smart phone readers, barcode, etc.) (Please provided all available options in the comments)
403CAAsset Set UpSystem will integrate with the City's GIS platform for asset location and/or descriptions
404CAAsset Set UpSystem will provide parent-child relationships for assets
405CAAsset Set UpSystem will reference old assets to replacement assets
406CAAsset Set UpSystem will enable assets in the "Construction in Progress" phase to be held in a CIP account and not placed in service until completed/officially accepted
407CAAsset Set UpSystem will identify assets from the CIP file
408CAAsset Set UpSystem will track asset acquisition dates
409CAAsset Set UpSystem will track asset expiration dates
410CAAsset Set UpSystem will track asset warranty information
411CAAsset Set UpSystem will track software licenses in compliance with GASB 96 and all relevant GASB standards
412CAAsset Set UpSystem will enable assets to be owned by multiple funds (governmental and enterprise) by a percentage share
413CAAsset Set UpSystem will identify asset custodians (e.g., cell phone identifies user)
414CAAsset Set UpSystem will flag assets that have restrictions (e.g., bond-funded or grant-funded assets)
415CAAsset Set UpSystem will flag assets per allowable and unallowable users
416CAAsset Set UpSystem will identify multiple assets from a requisition, purchase order, or invoice
417CAAsset Set UpSystem will communicate between departmental stakeholders
418CAAsset AcquisitionSystem will provide approval workflows for adding new assets
419CAAsset AcquisitionSystem will provide effective date posting for asset acquisitions
420CAAsset AcquisitionSystem will identify potential fixed assets from the purchasing module (purchase order) by chart of accounts (purchased from capital account)
421CAAsset AcquisitionSystem will identify potential fixed assets from the budgeting module by chart of accounts (purchased with approved project)
422CAAsset AcquisitionSystem will identify potential fixed assets from the purchasing module by dollar amount
423CAAsset AcquisitionSystem will enable users to manually identify/flag potential fixed assets from the purchasing module
424CAAsset AcquisitionSystem will identify potential fixed assets from the accounts payable module by chart of accounts (payment from capital account)
425CAAsset AcquisitionSystem will identify potential fixed assets from the accounts payable module by dollar amount
426CAAsset AcquisitionSystem will enable the manual creation of assets that do not flow through purchasing or accounts payable (e.g., assets below threshold or donated assets)

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .