EITS Simple Logo

Financial Information Systems

a division of Enterprise Information Technology Services

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

Query Table - QUERY.BUD_POSN_SAL_SUP

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
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_PCT_TIME Percent Time (% of each day or week; not % of year)
POSN_ORIG_BGT Position Original Budget Amount
POSN_ORIG_EFT Position Original Budget Full Time Equivalent (1.00000 = full time)
POSN_TOTAL_BGT Position Amended Budget Amount
POSN_TOTAL_EFT Position Amended Budget Full Time Equivalent (1.00000 = full time)
LEAVE_WO_PAY_BGT Position Leave Without Pay Budget Amount
LEAVE_WO_PAY_EFT Position Leave Without Pay Budget Full Time Equivalent
SALARY_SUPPLEMENT Salary Supplement Amount
SAL_SUPP_CODE Salary Supplement Code (1 character:  A = Administrative, C = County, F = UGA Foundation, S = Special Chair)
SAL_SUP_DESC Salary Supplement Description (Administrative, County, UGA Foundation, Special Chair)
SAL_SUP_BEGIN_DATE Date on which the salary supplement effectively begins (MM/DD/YYYY format)
SAL_SUP_BEGIN_HOUR Hour at which the salary supplement effectively begins (0.0 = 8:00am; 8.0 = 5:00pm)
SAL_SUP_END_DATE Date on which the salary supplement effectively ends (MM/DD/YYYY format)
SAL_SUP_END_HOUR Hour at which the salary supplement effectively ends (0.0 = 8:00am; 8.0 = 5:00pm)
MAJOR_UNIT_CODE Position Major Organizational Unit Code (President, VP)
MAJOR_UNIT_DESC Position Major Organizational Unit Description (President, VP)
INTER_UNIT_CODE Position Intermediate Organizational Unit Code (College, School, Division)
INTER_UNIT_DESC Position 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