{
  "fields": [{"id":"_id","type":"int"},{"id":"Field Name","type":"text"},{"id":"Field Type","type":"text"},{"id":"Description","type":"text"},{"id":"Notes","type":"text"}],
  "records": [
    [1,"Agency ID","Varchar(5)","Agency code, 5 digit number","Ex. 00060; Business Unit represents an agency (see Agency Name note)"],
    [2,"Agency Name","Varchar(40)","Name of agency","References a state agency under the Executive branch, a separately elected official, or the divisions within the Legislative and Judicial branches of government.  Agency may references a subdivision of an agency; Ex. Department of Corrections has several facilities that are classified in the state's accounting system as an agency.  "],
    [3,"Fiscal Year","Varchar(4)","Fiscal year of transaction","The state operates on a fiscal year beginning July 1 and ending June 30"],
    [4,"Last Updated","TIMESTAMP","Date of latest data extraction from source data",""],
    [5,"Merchant Category Code","Varchar(40)","Merchant category code as assigned by Visa",""],
    [6,"Merchant Name","Varchar(40)","Merchant name",""],
    [7,"Pcard or Tcard","Varchar(5)","Type of card","The state utilizes separate purchasing cards (procurement cards) and travel cards "],
    [8,"Source","Varchar(25)","Data location","Ex. PeopleSoft Financials, the state's financial operating system; PeopleSoft HR, the state's human resource operating system; HEA 1001, the Budget Bill, or other sources. "],
    [9,"Transaction Amount","Decimal(26,3)","Transaction amount",""],
    [10,"Transaction Date","Date","Date of transaction",""],
    [11,"Transaction ID","Varchar(24)","Transaction identification number",""]
]}