About this Dataset

County (Pcard) Purchase Card 2022 - 2024

This dataset contains information on purchases made through the purchase card programs administered by the Oklahoma Counties.
Organization: State of Oklahoma
Last updated: 2022-04-28T05:07:42.715470

Tables

2024.05 County P-card Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2024_05_county_p_card_spend_report

21.54 kB
264 rows
11 columns

CREATE TABLE n_2024_05_county_p_card_spend_report (
  "calendar_year" BIGINT,
  "month" BIGINT,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "ch_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "purchase_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_description" VARCHAR
);

2024.06 County P-card Spend Report

@usgov.state_of_oklahoma_county_pcard_purchase_card.n_2024_06_county_p_card_spend_report

22 kB
280 rows
11 columns

CREATE TABLE n_2024_06_county_p_card_spend_report (
  "calendar_year" BIGINT,
  "month" BIGINT,
  "business_unit" VARCHAR,
  "last_name" VARCHAR,
  "ch_initial" VARCHAR,
  "item_description" VARCHAR,
  "amount" VARCHAR,
  "merchant" VARCHAR,
  "purchase_date" TIMESTAMP,
  "post_date" TIMESTAMP,
  "mcc_description" VARCHAR
);