|
Financial Information Systems |
| a division of Enterprise Information Technology Services | |
Mrs. Sharon Burch, Interim Director
(706) 542-5305
Query Table - QUERY.ACC_OPEN_ENCUMBER
| 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 Expenditure Object Code |
| DETAIL_OBJECT | Detail Expenditure Object Code |
| ENCUMBRANCE_TYPE | Encumbrance Type Code: P=Purchase T=Travel H=Honorarium |
| ENCUMB_TYPE_DESC | Description of Encumbrance Type |
| ENCUMBRANCE_NUMBER | Encumbrance Document Number |
| ENCUMBRANCE_ID | Alphabetic suffix appended to Encumbrance Number to support the association of multiple funding accounts or multiple recommended vendors |
| VENDOR_NAME | Name of Recommended Vendor for Purchases OR Name of Travel Agency, Individual Traveler, or Honorarium recipient |
| VENDOR_NUMBER | Accounts Payable Vendor Number (SSN) associated with Travel and Honorarium encumbrances |
| VENDOR_ADDRESS | Suffix appended to Vendor Number to support multiple "pay to" address requirements |
| COMMITMENT_DATE | Date Purchase Request recorded against benefiting account |
| COMMIT_DOCU_DATE | Date on Purchase Request document |
| COMMITMENT | Dollar amount of Purchase Request |
| OBLIGATION_DATE | Date Purchase Order, Travel Authority, or Honorarium recorded against benefiting account |
| OBLIG_DOCU_DATE | Date on Purchase Order, Travel Authority, or Honorarium document |
| OBLIGATION | Dollar amount of Purchase Order, Travel Authority, or Honorarium |
| PAYMENT_DATE | Date of most recent payment against the encumbrance |
| PAYMENT | Total payments against encumbrance |
| TRAVEL_AGN_PAYMENT | Total payments to Travel Agency (for Travel encumbrances) |
| ADJUSTMENT_DATE | Date of most recent adjustment to encumbrance |
| ADJUSTMENT | Total adjustment dollars associated with encumbrance |
| ENCUMBRANCE_BAL | Outstanding (unpaid) amount of encumbrance (Commitment or Obligation minus Payments plus Adjustments) |
| PHY_PLNT_WORK_ORDER | Work Order Number associated with a Physical Plant-related encumbrance |
| PHY_PLNT_COST_CNTR | Code identifying the Physical Plant Cost Center (Shop) associated with the encumbrance |
| BLANKET_PO | Code identifying a Blanket Purchase Order |
| BLANKET_PO_DESC | Characterization of Blanket Purchase |
| FREE_BAL_OVERRIDE | Code used to override the "free balance test" and authorize an encumbrance despite a lack of available funds in the associated account |
| FREE_BAL_OVER_DESC | Description of the "free balance test" specification |
| SSN_OVERRIDE | Code used to override the validation of Traveler
or Honorarium recipient Social Security Number: Travelers must be UGA employees Honorarium recipients must not be UGA employees |
| SSN_OVERRIDE_DESC | Description of the "SSN Override" specification |
| SPECIFIC_ENC_TYPE | Code used to distinguish State Purchase Orders and Agency-Delegated (Field) Purchase Orders |
| SPEC_ENC_TYPE_DESC | Description of the Purchase Order: State or Field |
| ENCUMBRANCE_STATUS | Code used to indicate the status of the
encumbrance: 1=Active 2=Closed for one month 3=Closed for two months 4=Closed for three months 5=Closed for four months |
| ENCUMB_STATUS_DESC | Description of encumbrance status |
| AGENCY_VEND_NUMBER | Accounts Payable Vendor Number of Travel Agency |
| AGENCY_ADDRESS | Suffix appended to Travel Agency Vendor Number to support multiple "pay to" address requirements |
| EQUIPMENT_OBJECT | For encumbrances associated with liability accounts, the equipment object associated with the original (benefiting) account BEFORE the encumbrance became a liability |
| BUYER_CODE | Code used to identify the Procurement Office Buyer associated with the purchase |
| BATCH_NUMBER | Identifying number used to group related encumbrances as they were recorded by the system |
| BATCH_SUFFIX | Suffix appended to Batch Number to ensure uniqueness |
| PURCHASE_AUTHORITY | Delegated Purchase Authority Code assigned by Procurement to classify purchase encumbrances for reporting |
| PURCHASE_AUTH_DESC | Delegated Purchase Authority Description classifying a purchase encumbrance |
| OVERRIDE_REASON | Code used to specify the reason for exercising the "free balance override" option |
| OVERRIDE_RSN_DESC | Description of the reason for exercising the "free balance override" option |
| BEG_MONTH_ENC_BAL | Unpaid balance of the encumbrance as of the beginning of the current accounting period |
| BEG_FY_ENC_BAL | Unpaid balance of the encumbrance as of the beginning of the current fiscal year |
| 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 |