Request #17-1472

 
Closed

This is a public records act request for all P-Card (procurement credit card) expense reports filed by all employees of the City of San Diego dated between January 1, 2015 and present day. I request the data in .csv, .txt or another excel-readable form.

The report(s) should include the following information, which I know to be collected by the city, based on the examination of previous records requests and their responsive documents (CPRA 2014-097, 17-745 and 17-746):

  • Cardholder Name
  • Department Name
  • Transaction Number
  • Purchase/Transaction Date
  • Transaction Amount
  • Name of who reviewed the expense
  • Reviewer Sign-Off Date
  • Name of who approved the expense
  • Approver Sign-Off Date
  • Description of Item Purchased
  • Merchant Name
  • Merchant Address
  • Merchant City
  • Merchant State/Province
  • Merchant ZIP
  • Merchant Tax ID

If the data cannot be compiled into one database, please include "Transaction Number" column in all reports so a cross match can be made.

If possible, please also provide a guide or explanation to each column title in the provided data, as well as descriptions of entries that are not self-explanatory.

Please reach out if you have any questions or need clarification on this request. Thank you!

p.s. If it helps, previously-released records indicate the City Comptroller's payment services division/disbursements has all of the information I am requesting.


Received

June 9, 2017 via web


Departments

City Comptroller, Public Records Administration

Staff

Point of Contact

Lea Fields-Bernard

Request Published Public
June 22, 2017, 4:29pm
Request Closed Public

02. Released

All responsive documents have been released pursuant to the California Public Records Act.

June 19, 2017, 4:23pm by Lea Fields-Bernard, Public Records Administration Manager
Document(s) Released Public
PRA 17-1472_PCard Transactions.xlsx
June 19, 2017, 4:22pm by Lea Fields-Bernard, Public Records Administration Manager
Department Assignment Public
Added: Public Records Administration , City Comptroller.
June 9, 2017, 4:37pm by Lea Fields-Bernard, Public Records Administration Manager
Show All History Items