EITS Simple Logo

Financial Information Systems

a division of Enterprise Information Technology Services

Mrs. Sharon Burch, Interim Director
(706) 542-5305

Query Table - QUERY.ACC_SUM_OBJ_ORG

Column Name Definition
ACCOUNT Account Number
FUND Fund Group Number
FUNCTION Function Number
OPERATION Operation Code
ACTIVITY Activity Code
DEPARTMENT Department Number
PROJECT Project Number
FISCAL_YEAR Fiscal Year (4 digits; FY 1999-2000 represented by 2000)
SUMMARY_OBJECT Summary/Budgeted Object Code (Revenue or Expenditure)
ORIGINAL_BUDGET Original Budget for the Fiscal Year (zero for sponsored accounts)
APPROVED_BUDGET Approved Amendments to the Original Budget  OR
Total Budget (across fiscal years) for Sponsored Accounts
PENDING_BUDGET Pending Amendments to the Original Budget (zero for sponsored accounts)
AMENDED_BUDGET Current Budget:  Original + Approved + Pending (represents budget across fiscal years for sponsored accounts)
PROJ_LIFE_ACTUAL Actual Revenue or Expenditures over the life of a sponsored account (across fiscal years)
FY_BUDGET Current Budget for the Fiscal Year (for sponsored accounts, represents the portion of the budget applicable to the current FY)
FY_ACTUAL Actual Revenue or Expenditures for the Fiscal Year
CURR_OBLIGATION Current Obligated Encumbrance:
     Purchase Orders, Travel Authorities, Honoraria OR
     Outstanding Salary Encumbrance for Filled Budget Positions
CURR_COMMITMENT Current Committed Encumbrance:  Purchase Requests
CURR_ENCUMBRANCE Current Encumbrance (Obligation + Commitment)
SALARY_ENCUMBRANCE Total Salary Encumbrance for Filled Budget Positions
BUDGET_BALANCE Uncommitted funds (Budget minus Actual and Encumbrance)
MAJOR_UNIT_CODE Major Organizational Unit Code (President, VP)
MAJOR_UNIT_DESC Major Organizational Unit Description (President, VP)
INTER_UNIT_CODE Intermediate Organizational Unit Code (College, School, Division)
INTER_UNIT_DESC Intermediate Organizational Unit Description (College, School, Division)
ACCOUNT_DESC Account Description or Name
FUND_DESC Fund Group Number Description
FUNC_ACTIVITY_DESC Function/Activity Description
OPERATION_DESC Operation Code Description
DEPARTMENT_DESC Department Description or Name
PROJECT_DESC Project Description or Name
AGENCY Sponsoring Agency Code
AGENCY_DESC Sponsoring Agency Description or Name
COLLEGE_DESC College Description or Name
MAJ_FUNCTION_DESC Major Function Type Description
FUND_BAL_FUND_NO Fund Balance Fund Group Number for Restricted (Sponsored) Accounts


Access Services            Enterprise Information Technology Services            The University of Georgia