EITS Simple Logo

Access Services

a division of Enterprise Information Technology Services

Query Table - QUERY.BUD_POSITION

Column Name Definition
POSITION Line Item Budget Position Identifier (Home Dept/Short Title/Posn No)
HOME_DEPARTMENT Home Department Number (3 characters)
SHORT_TITLE Position Short Title (5 characters)
POSITION_NUMBER Position Number (2 characters)
POSN_OCCURRENCE Position Occurrence Code (1 character:  A, B, C, etc.)
FISCAL_YEAR Fiscal Year Identifier (4 characters:  FY 2000-2001 = 2001)
POSN_BEGIN_DATE Appointment Begin Date (MM/DD/YYYY format)
POSN_BEGIN_HOUR Appointment Begin Hour (0.0 = 8:00am; 8.0 = 5:00pm)
POSN_END_DATE Appointment End Date (MM/DD/YYYY format)
POSN_END_HOUR Appointment End Hour (0.0 = 8:00am; 8.0 = 5:00pm)
EMPLOYEE_NAME Name of Incumbent (Last, First format)
SSN Employee Identification Number (9 characters)
POSN_STATUS_CODE Position Status Code (1 character:  0=Vacant, 1=Encumbered, etc..)
POSN_STATUS_DESC Position Status Description (Vacant, Encumbered, etc.)
CONTRACT_CODE Contract Code (1 character:  N=No contract, A=9 Month Academic, etc..)
CONTRACT_DESC Contract Description (No contract, 9 Month Academic, etc..)
JOB_CLASS_CODE Job Classification Code (5 characters)
JOB_CLASS_DESC Job Classification Description
FACULTY_RANK_CODE Faculty Rank Code (5 characters)
FACULTY_RANK_DESC Faculty Rank Description
POSITION_TITLE Title
POSN_PCT_TIME Percent Time (% of each day or week; not % of year)
ANNUAL_SALARY Annual Pay
DEGREE_CODE Degree Code (7 characters)
DEGREE_DESC Degree Description or Name
SPECIAL_CHAIR_CODE Special Chair Code (2-3 characters)
SPECIAL_CHAIR_DESC Special Chair Description
COUNTY_CODE Georgia County Code (3 characters)
COUNTY_DESC Georgia County Name
POSN_ORIG_BGT Original Budget Amount
POSN_ORIG_EFT Original Budget Full Time Equivalent (1.00000 = full time)
POSN_TOTAL_BGT Amended Budget Amount
POSN_TOTAL_EFT Amended Budget Full Time Equivalent (1.00000 = full time)
LEAVE_WO_PAY_BGT Leave Without Pay Budget Amount
LEAVE_WO_PAY_EFT Leave Without Pay Budget Full Time Equivalent
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)
DEPARTMENT_DESC Department Description or Name
OCC_CATEGORY_CODE Occupational Category Code


Access Services            Enterprise Information Technology Services            The University of Georgia