About this Dataset

Purchase Card (PCard) - Fiscal Year 2013

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:53.036368
Tags: 2013, fiscal-year-2013, pcard, purchase-card

Tables

Data - Purchase Card (PCard) - Fiscal Year 2013

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2013_bc93d.data_purchase_card_pcard_fiscal_year_2013

9.46 MB
441,781 rows
11 columns

CREATE TABLE data_purchase_card_pcard_fiscal_year_2013 (
  "year_month" BIGINT,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "card_holder_last_name" VARCHAR,
  "card_holder_first_name" VARCHAR,
  "description" VARCHAR,
  "amount" VARCHAR,
  "vendor" VARCHAR,
  "transaction_date" VARCHAR,
  "posted_date" VARCHAR,
  "merchant_category_code_mcc" VARCHAR  -- Merchant Category Code (MCC)
);