PCMS FY05.1 Web Release — March 2005

PCMS Web 5.1 Release aim is to improve the performance of PCMS Web and to increase the amount of information displayed on screens in the application. These enhancements have been reviewed and approved by the Configuration Control Board (CCB).

For more information, on the PCMS Web 5.1 Release enhancements, refer to the sections below:

Performance Enhancements

• Create Transaction Data Archive.

Cardholder Related

Transaction Reconciliation Enhancements

• Add Date Approved Field to the Transaction Screen.
• Display Level 3 Data on Transaction Screen.
• Change Accounting Comments column title to FFIS Doc ID#.
• Highlight the selected transaction on Transaction Tab, when navigating between tabs.

Purchase Card Information Enhancements

• Add Address to Purchase Card Screen.
• Add Card Status Description to Purchase Card Screen.

Reporting Enhancements

• Add Identification to PCMS Cardholder Account Report.

APC / LAPC Related

Cardholder Setup Enhancements

• Expand the Email field on the Cardholder Account Maintenance Screen.

Audit Alert Enhancements

• Remove >30 day Reconciliation Audit Alert and No Longer Send Audit Alerts to APCs and Cardholders.
• Only allow LAPCs to change Alert Messages to "Read". Allow read only access to messages routed to APCs.

Performance Enhancements

Create Transaction Data Archive.

To reduce the size of the current PCMS database and thereby improving response time for reporting, a historical database of transactions in PCMS that meet the criteria below will be created:

• Transactions must be older than 3 years
• Transactions must have an accounting status that is not equal to N will be copied and loaded into a historical database.

These transactions will be transferred from the current database to the new historical database. Reporting on these transactions will still be possible. However users will have to run reports against the historical database rather than the current database.

Cardholder Related

Transaction Reconciliation Enhancements

Add Date Approved Field to Transaction Screen

PCMS will be modified to capture and display the date that a transaction is approved. This information will be displayed in the Card Transaction screen on the Transactions tab.

Display Level 3 Data on Transaction Screen

PCMS will be modified to display details about transactions in a new tab in the Cardholder Transaction screen called Purchase Detail. This tab will display information such as order date, sales tax, quantity, product code, purchase detail description, etc. Note this information will only be populated if the merchant has sent the information to the bank. This level of detail may not be available for all transactions.

Change Accounting Comments column title to FFIS Doc ID#

PCMS will be modified to capture the FFIS Doc ID# in a separate field, rather than storing the information in the Comments field on the Transaction Maintenance tab. This field will also be displayed on the Transaction Maintenance tab.

Highlight the Selected Transaction on Transaction tab, when navigating between tabs

PCMS will be modified so that a selected transaction will remain highlighted in the Transactions table on the Transaction tab as a user moves back and forth between the Transaction, Purchase Detail, Transaction Maintenance and Dispute Maintenance tabs.

Purchase Card Information Enhancements

Add Address to Purchase Card Screen.

PCMS will be modified to display the cardholder's address on the Purchase Card screen.

Add Card Status Description to Purchase Card Screen.

PCMS will be modified to display a description of the card status rather than the status code on the Purchase Card screen. The descriptions will be "Active", "Deleted" or "Inactive" rather than "A", "D" or "I".

Reporting Enhancements

Add Identification to PCMS Cardholder Account Report.

PCMS will be modified to include the Cardholder Name in the Cardholder Report.

APC / LAPC Related

Cardholder Setup Enhancements

Expand the Email field on the Cardholder Account Maintenance Screen.

PCMS will be modified to increase the Email field from 30 characters to 50 characters on the Cardholder Account Maintenance Screen. The expansion is for internal purposes only. The e-mail address that is sent to the bank will continue to be 30 characters so if the email address entered is greater than 30 characters, the address sent to the bank will be truncated.

Audit Alert Enhancements

Remove >30 day Reconciliation Audit Alert and No Longer Send Audit Alerts to APCs and Cardholders.

The "Transactions Not Reconciled After 30 days" audit alert will be removed at Procurement Policy Division's request. In addition, PCMS will be modified so that Audit Alert messages are no longer sent to APCs and Cardholders.

Only allow LAPCs to update Alert Messages to "Read". Allow read-only access to messages routed to APCs.

Audit Alert messages will be modified so that only LAPCs can update the Comment and Message status fields. Other users will have read-only access.