Baselight

Purchase Card (PCard) - Fiscal Year 2013

State of Oklahoma

@usgov.state_of_oklahoma_purchase_card_pcard_fiscal_year_2013_bc93d

Loading...
Loading...

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.02 MB
  • 441781 rows
  • 11 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.