|
Financial Information Systems |
| a division of Enterprise Information Technology Services | |
Mrs. Sharon Burch, Interim Director
(706) 542-5305
Query Table - QUERY.ACC_SUMOBJ_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) |
| PERIOD_ACTUAL | Actual Revenue or Expenditures for the Accounting Period |
| 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 | Budget at the end of the Accounting Period: Original + Approved + Pending (represents budget across fiscal years for sponsored accounts) |
| 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 OR Outstanding Salary Encumbrance for Filled Budget Positions |
| 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 |
| FY_BUDGET | Budget for the Fiscal Year at the end of the Accounting Period (for sponsored accounts, represents the portion of the budget applicable to the current FY) |
| BUDGET_BALANCE | Uncommitted funds (Budget minus Actual and Encumbrance) 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 |