﻿_id	Field Name	Field Type	Description	Notes
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	""
