| Record Number |
The unique record number for each transaction (often times a row number) |
TEXT |
Yes |
|
R120 |
| Fiscal Year |
The fiscal year associated with the transaction |
INTEGER |
Yes |
Between 2009-Current FY |
2024 |
| Entity Name |
The name of the local government or entity submitting the report. |
STRING |
Yes |
|
Salt Lake City |
| Fund 1 |
This is the top level in the fund hierarchy. A fund is a series of self-balancing accounts and may
match the
funds shown in your financial statements |
STRING |
Yes |
|
Capital Projects Fund |
| Fund 2 |
Second level in the fund heirarchy |
STRING |
No |
|
Transportation |
| Fund 3 |
Third level in the fund heirarchy |
STRING |
No |
|
Streets & Roads |
| Fund 4 |
Fourth level in the fund heirarchy |
STRING |
No |
|
Historic Main Street |
| Org 1 |
This is the top level in the organization hierarchy. It would typically be the next level down from
the
Entity. |
STRING |
Yes |
|
County Clerk |
| Org 2 |
This is the second level in the organization hierarchy. |
STRING |
No |
|
Elections |
| Org 3 |
This is the third level in the organization hierarchy. |
STRING |
No |
|
Voter Services |
| Org 4 |
This is the fourth level in the organization hierarchy. |
STRING |
No |
|
Poll Workers |
| Org 5 |
This is the Fifth level in the organization hierarchy. |
STRING |
No |
|
|
| Org 6 |
This is the sixth level in the organization hierarchy. |
STRING |
No |
|
|
| Org 7 |
This is the seventh level in the organization hierarchy. |
STRING |
No |
|
|
| Org 8 |
This is the eighth level in the organization hierarchy. |
STRING |
No |
|
|
| Org 9 |
This is the nineth level in the organization hierarchy. |
STRING |
No |
|
|
| Org 10 |
This is the tenth level in the organization hierarchy. |
STRING |
No |
|
|
| Transaction Type |
Defines the type of monies being reported and entered as capital letters. |
STRING |
Yes |
Expenditures = EX, Revenue = RV |
RV |
| Category 1 |
This is the top level in the category hierarchy. It further defines the transaction type.. |
STRING |
Yes |
|
Revenue |
| Category 2 |
This is the second level in the category hierarchy. |
STRING |
No |
|
Taxes |
| Category 3 |
This is the third level in the category hierarchy. |
STRING |
No |
|
Sales and Use Tax |
| Category 4 |
This is the fourth level in the category hierarchy. |
STRING |
No |
|
Alcoholic Beverage Tax |
| Category 5 |
This is the fifth level in the category hierarchy. |
STRING |
No |
|
|
| Category 6 |
This is the sixth level in the category hierarchy. |
STRING |
No |
|
|
| Category 7 |
This is the seventh level in the category hierarchy. |
STRING |
No |
|
|
| Payee/Vendor Name |
The payee, customer or vendor name. For transactions without a payee, customer or vendor the value
is "Not Applicable". For transactions that are private (protected by GRAMA, HIPPA, FERPA, etc.) and
will always remain private, enter "REDACTED". Otherwise the name is put in.
|
STRING |
Yes |
|
Office Max |
| Payee/Vendor DBA Name |
"Doing Business As" name
|
STRING |
No |
|
Example Company Inc. |
| Vendor Id Code |
Vendor ID code is used by the website to properly summarize transactions.
|
STRING |
Yes, if name is "Not Provided" or Redacted. This allows the database to
summarize transactions by
unique vendor |
|
Example Company Inc. |
| Posting Date |
The date the financial transaction
was posted to the entity’s general ledger
|
DATE |
Yes |
mm/dd/yyyy |
07/01/2024 |
| Transaction Description |
Used to further describe the
transaction. Do not include private information. We
recommend using the lowest category name if
actual description contains private information.
|
STRING |
Yes |
least 2 characters in length |
Alcoholic Beverage Tax Revenue |
| Transaction Id |
The tranaction ID from the entity’s general ledger system. Must be
unique. If you do not have a general ledger, then this can be the row
number.
|
STRING |
Yes |
|
RV186jBidk39 |
| Transaction Reference Id |
If transactions are related to each
other (reversals, corrections, etc.) this ID
connects them. If populated, there should also
be a record with this field as the Transaction ID.
|
STRING |
No |
|
RV186jBidk39 |
| Contract Name |
The contract name
|
STRING |
if record is for a payment on a contract |
|
|
| Contract Number |
The contract number
|
STRING |
if record is for a payment on a contract |
|
|
| Position Title |
The employee's position or job title
|
STRING |
No (only for compensation report) |
|
|
| Hourly Rate |
The employee's hourly rate. 0 if salaried
|
NUMERIC |
No (only for compensation report) |
two decimal places |
|
| Gender |
The employee's gender
|
STRING |
No (only for compensation report) |
Must be a 1-2 character value. M=Male, F=Female, TM=Trans Man, TW=Trans Woman, NB=Non-Binary or
NG=No Gender
|
|
| Amount |
The money amount associated with the transaction. Positive unless it is a reversal.
|
NUMERIC |
Yes |
Two decimal places. No commas or dollar sign. |
123.45 |
| Protection Indicator |
Should the Revenue/Expense's Vendor Name be protected? NOTE: We request that if a name is protected
you put the value "REDACTED" in the vendor name instead of relying on this column for hiding the
protected information.
|
TEXT |
No |
"P" if protected, null otherwise |
P |
| Uniform Chart of Accounts Code |
Coding block per Uniform Chart of Accounts from the Office of the Utah State Auditor for local
entities OR coding block per Utah State Board Education ("USBE") chart of accounts for school
districts and charter schools. Please check the USBE chart of accounts at this website: https://schools.utah.gov/financialoperations/reporting and click
"Chart of Accounts". Numbers separated by dashes ("-").
|
TEXT |
Yes |
|
123-123456-12345678 |
| Program 1 |
USBE chart of Account Program level 1 code and description for public education entities. Can also
be used by other local entities. |
STRING |
Yes, if Local Education Agency |
|
|
| Program 2 |
USBE chart of Account Program level 2 code and description for public education entities. Can also
be used by other local entities. |
STRING |
No |
|
|
| Program 3 |
USBE chart of Account Program level 3 code and description for public education entities. Can also
be used by other local entities. |
STRING |
No |
|
|
| Program 4 |
USBE chart of Account Program level 4 code and description for public education entities. Can also
be used by other local entities. |
STRING |
No |
|
|
| Program 5 |
USBE chart of Account Program level 5 code and description for public education entities. Can also
be used by other local entities. |
STRING |
No |
|
|
| Program 6 |
USBE chart of Account Program level 6 code and description for public education entities. Can also
be used by other local entities. |
STRING |
No |
|
|
| Program 7 |
USBE chart of Account Program level 7 code and description for public education entities. Can also
be used by other local entities. |
STRING |
No |
|
|
| Function 1 |
USBE chart of Account Function level 1 code and description for public education entities. Can also
be used by other local entities.
|
STRING |
Yes, if Local Education Agency |
|
|
| Function 2 |
USBE chart of Account Function level 2 code and description for public education entities. Can also
be used by other local entities.
|
STRING |
No |
|
|
| Function 3 |
USBE chart of Account Function level 3 code and description for public education entities. Can also
be used by other local entities.
|
STRING |
No |
|
|
| Function 4 |
USBE chart of Account Function level 4 code and description for public education entities. Can also
be used by other local entities.
|
STRING |
No |
|
|
| Function 5 |
USBE chart of Account Function level 5 code and description for public education entities. Can also
be used by other local entities.
|
STRING |
No |
|
|
| Function 6 |
USBE chart of Account Function level 6 code and description for public education entities. Can also
be used by other local entities.
|
STRING |
No |
|
|
| Function 7 |
USBE chart of Account Function level 7 code and description for public education entities. Can also
be used by other local entities.
|
STRING |
No |
|
|