HomeMy WebLinkAboutExhibit 7Attachment B
Point of Sale Deliverables
The scope of the deliverables will be consistent with CORE's responses to the request for proposal.
Deliverables which are not specifically included within the request for proposal, desired deliverables will be
addressed during the discovery process. Desired deliverables which materially change the scope of the
project may or may not require a change order as defined in sections 4.7 and 7.3 of the Professional Services
Agreement.
RFP
Reference
1
Inquire by many data elements, such as but not limited to: Name, Account #, Address, Etc, as defined
during the discovery process.
IV 23
2
Unique check endorsements for each department.
IV 27, 34
3
Connecting to the credit card processor, which is still to be determined.
IV 73
4
Documentation of system and processes, such as Installation guide, training guides, quick reference
guides, system specification documentation.
V 53
5
Reports (both Electronic and hard copy) -to include any and all custom reports as defined during
discovery process.
IV64 — IV81
6
Report generator tools as well as training to use the tool.
7
Security Levels that provide administrative functionality.
V 32 - 38
8
Ability to centralize and control the updating of host systems.
9
Internal controls in place as defined during discovery.
10
Preservation of audit trails as defined during discovery.
IV 83-93
11
Ability to close a date (no other cashier can enter a closed date) after all activity for a given day has
been balanced.
IV 57
12
Access to deposit information as well as the ability to drill down to the transactions that constitute the
deposit.
13
Miscellaneous cash receipting process — to receipt miscellaneous cash receipts with a live validation
point to GL Chart of accounts structure.
IV 8
14
Ability to use the following tender types (and any others defined during the discovery process):
IV 32, 37,55
Cash
Check
Credit Card (GIS wilpay convenience fees)
On Account - ability to create Oracle Invoices for specific customers.
15
Able to take credit card payment.
VIII 1-17
16
Able to take web transactions
VI 9
17
The system will perform the distributions and provide daily reports, as defined during discovery.
IV 65
18
The system shall create output in Clark County I.S. requested format to update the Financial
Management System (FMS) in batch mode.
1
Live inquiry into CATS.
IV 23, VI 6
2
Live inquiry to CATS derog file for any pending payments and provide appropriate messages on
screen.
IV 46
3
Creation of integrated excise tax and recording process which will allow for the capture of data and
creation of data.
IV 53
4
The POS will check for any pending payments and provide appropriate messages on screen.
IV 46
Clark County, Washington
Page 1 of 3
5
At the end of day the POS shall provide a CATS update file as specified by CCIS in order to post
payments to tax records.
6
The system shall provide a transaction receipt with amount paid along with pertinent details as
generated by the CATS Cashier.
IV 25, 26
7
The system shall provide all the reports — End of the Day, Transactions by Cashier Id and other reports
currently provided by the CATS cashier system.
IV 65
p
_\:.
1
Live inquiry for Oracle AIR, as defined during the discovery process.
VI 1
2
Update to Oracle AIR , as defined during the discovery process.
VI 1
3
Update to Oracle G/L , as defined during the discovery process.
4
Cross validation rules that are synchronized with Oracle FMS
5
Creation of cashier refund file for Oracle A/P.
IV 20
6
Creation of warrant file for Oracle Cash Management.
VI 15, 16,18
1
GIS products and services revenues must be automatically assigned to the correct report code in FMS.
VI 18
2
GIS will be able to use a barcode scanner for selecting transaction types.
V 43
3
Track products purchased by customers.
4
Selection of a customer, from a customer database, when the payment is made:
GIS currently uses two distinct customer databases.
1. A very small subset of the FMS database of customers approved for monthly invoices.
2. The GIS customer database that is used to track regular customer's purchases and subscriptions.
The GIS customer database is stored in a custom SQL Server database.
Details of this inquiry and update routine will be defined during the discovery process.
5
GIS will be able to track the number of units sold of each product type by date range and customer.
Managers without full Core licensess willl be able to run these reports.
V 65 - 73
�(�I
1
Receipt that includes all items paid for within a case with the amount paid along with pertinent details
as generated by the TM Cashier,, including listing the description and fee amount.
IV 25
2
Trust Accounting System that has:
IV 40
a. Multiple types of trust accounts
b. Smart Account Numbers
c. Ability to limit use of trust accounts to certain types of transactions.
d. Ability to deny use of trust account if it would become overdrawn.
e. Reports on account balance and activity within time parameters.
3
POS has live interface in both directions with Tidemark.
VI 2
4
Receipts numbers that are sequential to DCD (Dept of Community Development).
IV 6 , 24-26
5
Reports: End of Day
IV 65 -73
a. For all transactions made through Tidemark.
b. For all transactions that were made OUTSIDE of Tidemark.
c. On all transactions with distribution account to G/L, separating out non -cash trust accounts.
d. On all transactions with Non -Cash Trust accounts.
6
Invoices created in Oracle when using Billing accounts.
VI 1
7
The Point of Sale system shall replace the existing TM Tools database.
8
Point of Sale system shall replace the existing Tidemark Cashier system.
Clark County, Washington
Page 2 of 3
1
Real time integration between the Point of Sale (POS) and the Recording host system.
IV 22, VI 3
To include
Accepting data from tables in the host system
On Account customer codes
Document title codes
Fee schedules
Revenue codes fees to appropriate funding code)
_(splitting
Regular customer information codes
2
Ability to accept Auditors File Number (AFN) number from the host system to be included on the
receipt.
3
Receipt needs to include date, unique sequential receipt number, time, cashier ID, transaction type and
assigned AFN if applicable, amount for each item, sub -total for each host system, grand total at
bottom of receipt, tender type, and check number if applicable or customer account the receipt is
applied to.
IV 24, 25
4
Ability to amend a receipt after it has been completed, such as page count and then amend dollar
amount to correspond and total amount receipted without altering any other information on the receipt
that was not amended.
If a document code is amended which requires different codes, the revenue codes should automatically
be amended by the system.
IV 5
5
Once the receipting process is complete and is printing, the POS should trigger the host system to
produce the document labels.
6
The system must have the ability to accept from the host system a no fee transaction.
IV 41, VI 3
1
The system shall allow Citizens and Contractors to query their account balances via Clark County's
Website.
2
If they decide to make a payment, the system must accept Credit card, Debit card and EFT
transactions via Web and post the payments to Tidemark instantaneously. This real-time update shall
allow them to schedule inspections on their projects immediately after making the payment.
3
CORE shall discuss all the security features of the Web transactions in detail with Clark County
Information Services (CCIS) before implementation.
4
CORE will provide access to the host system interface controls developed within the scope of the One -
Step implementation.
Clark County, Washington
Page 3 of 3