Jordan School District Expenses 2018

opendata.utah.gov | Last Updated 13 Sep 2019

This Dataset contains Transparency data from the Transparency website for local governmental entities in the State of Utah.

This dataset has the following 66 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
ididnumberTransaction ID assigned by the Transparency website
posting_dateposting_datecalendar_dateThe posting date of the transaction (not necessarily the General Ledger date)
FISCAL_PERIODfiscal_periodnumberNo fiscal period is currently available
FISCAL_PERIOD_DATEfiscal_period_datecalendar_dateNo fiscal period date is currently available
AmountamountnumberTransaction amount
ENTITY_IDentity_idnumberEntity ID number assigned by the Transparency website
Entity Nameentity_nametextName of the entity
GOVT_LVLgovt_lvltextGovernment level of the entity (Cities and Towns, Counties, etc.)
batch_idbatch_idnumberBatch file number associated with a group of transactions
fiscal_yearfiscal_yearnumberFiscal year of the transaction (not necessarily the calendar year of the transaction)Fiscal year of the transaction (not necessarily the calendar year of the transaction)
entity_trans_identity_trans_idtextTransaction ID assigned by the entity
DescriptiondescriptiontextGeneral description of the transaction
ref_idref_idtextAnother reference associated with the transaction
typetypenumber1 = Expense, 2 = Revenue, 3 = Annual Payroll
contract_namecontract_nametextContract name associated with the transaction
contract_numbercontract_numbertextContract number associated with the transaction
Organizationorg1textOrganization Level 1 (required)
Sub Org 1org2textOrganization Level 2 (optional)
org3org3textOrganization Level 3 (optional)
org4org4textOrganization Level 4 (optional)
org5org5textOrganization Level 5 (optional)
org6org6textOrganization Level 6 (optional)
org7org7textOrganization Level 7 (optional)
org8org8textOrganization Level 8 (optional)
org9org9textOrganization Level 9 (optional)
org10org10textOrganization Level 10 (optional)
Expense Categorycat1textCategory Level 1 (required)
Expense Detailcat2textCategory Level 2 (optional)
cat3cat3textCategory Level 3 (optional)
cat4cat4textCategory Level 4 (optional)
cat5cat5textCategory Level 5 (optional)
cat6cat6textCategory Level 6 (optional)
cat7cat7textCategory Level 7 (optional)
Fund 1fund1textFund Level 1 (required)
Fund 2fund2textFund Level 2 (optional)
fund3fund3textFund Level 3 (optional)
fund4fund4textFund Level 4 (optional)
Programprogram1textProgram Level 1 (optional); usually associated with the Utah State Board of Education (USBE) chart of accounts
Program 2program2textProgram Level 2 (optional); usually associated with the USBE chart of accounts
Program 3program3textProgram Level 3 (optional); usually associated with the USBE chart of accounts
program4program4textProgram Level 4 (optional); usually associated with the USBE chart of accounts
program5program5textProgram Level 5 (optional)
program6program6textProgram Level 6 (optional)
program7program7textProgram Level 7 (optional)
Functionfunction1textFunction Level 1 (optional); usually associated with the Utah State Board of Education (USBE) chart of accounts
Function 2function2textFunction Level 2 (optional); usually associated with the USBE chart of accounts
Function 3function3textFunction Level 3 (optional); usually associated with the USBE chart of accounts
function4function4textFunction Level 4 (optional); usually associated with the USBE chart of accounts
function5function5textFunction Level 5 (optional)
function6function6textFunction Level 6 (optional)
function7function7textFunction Level 7 (optional)
account_numberaccount_numbertextUniform Chart of Account Coding Block; used where applicable for the Uniform Chart of Accounts of the Office of the Utah State Auditor or the Utah State Board of Education chart of accounts
vendor_idvendor_idnumberVendor ID assigned to a vendor by the Transparency website
Vendor Namevendor_nametextVendor name
RESERVE_1reserve_1textReserved for future use
RESERVE_2reserve_2textReserved for future use
RESERVE_3reserve_3textReserved for future use
RESERVE_4reserve_4textReserved for future use
RESERVE_5reserve_5textReserved for future use
RESERVE_6reserve_6textReserved for future use
RESERVE_7reserve_7textReserved for future use
RESERVE_8reserve_8textReserved for future use
RESERVE_9reserve_9textReserved for future use
RESERVE_10reserve_10textReserved for future use
RESERVE_11reserve_11textReserved for future use
RESERVE_12reserve_12textReserved for future use