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.