About this Dataset

Purchase Card (PCard) - Fiscal Year 2012

This dataset contains information on purchases made through the purchase card programs administered by the state and higher ed institutions. The purchase card information will be updated monthly after the end of the month. For example, July information will be added in August.
Organization: State of Oklahoma
Last updated: 2021-08-07T14:56:44.494151
Tags: 2012, fiscal-year-2012, pcard, purchase-card

Tables

Data - Purchase Card (PCard) - Fiscal Year 2012

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2012_7bf75.data_purchase_card_pcard_fiscal_year_2012

9.75 MB
442,184 rows
11 columns

CREATE TABLE data_purchase_card_pcard_fiscal_year_2012 (
  "year_month" VARCHAR,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "cardholder_last_name" VARCHAR,
  "cardholder_first_initial" VARCHAR,
  "description" VARCHAR,
  "amount" VARCHAR,
  "vendor" VARCHAR,
  "transaction_date" VARCHAR,
  "posted_date" VARCHAR,
  "merchant_category_code_mcc" VARCHAR  -- Merchant Category Code (MCC)
);