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_DTLOBJ_HISTORY

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
ACCOUNTING_PERIOD Calendar Year and Month defining Accounting Period (YYYYMM)
FISCAL_YEAR Fiscal Year (4 digits; FY 1999-2000 represented by 2000)
SUMMARY_OBJECT Summary/Budgeted Object Code (Revenue or Expenditure)
DETAIL_OBJECT Detail Object Code (Revenue or Expenditure)
PERIOD_ACTUAL Actual Revenue or Expenditures for the Accounting Period
FY_ACTUAL Actual Revenue or Expenditures for the Fiscal Year at the end of the Accounting Period
CURR_OBLIGATION Obligated Encumbrance at the end of the Accounting Period:
     Purchase Orders, Travel Authorities, Honoraria
CURR_COMMITMENT Committed Encumbrance at the end of the Accounting Period:
     Purchase Requests
CURR_ENCUMBRANCE Encumbrance at the end of the Accounting Period (Obligation + Commitment)
PROJ_LIFE_ACTUAL Actual Revenue or Expenditures over the life of a sponsored account (across fiscal years) at the end of the Accounting Period
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