Skip to Page Content
section image picture

Access Services

Query Tables for Personnel

Table Name  (Owner.Name) Content
PAPS.VAHR90EM Current Employee Information
PAPS.VAHR90EB Active Employee Benefit Information
PAPS.VAHR90DC Payroll Deduction with Short Description
PAPS.VAHR90DD Payroll Deduction with Long Description
QUERY.HR_DEPT_UNITS Department Number and Name, Department Head Name, Budget Representative Name, Intermediate and Major Unit Codes and Names, Major Fund
QUERY.HR_EMPL_ADDRESS Employee Address information
QUERY.HR_EMPL_ASSIGN Employee Budget Position information for multiple fiscal years
QUERY.HR_EMPL_LVE Employee Leave information
QUERY.HR_EMPLOYEE Employee demographic information
QUERY.HR_JOB_CLASS Job Class, Title, Pay Range, Hourly/Monthly/Annual Minimum and Maximum, EEO Code, Leave Type, Job Family
QUERY.HR_JOB_CLASS_NEW Job Class, Title, Pay Range, Hourly/Monthly/Annual Minimum and Maximum, EEO Code, Leave Type, Job Family for the New Fiscal Year
QUERY.HR_JOB_CLASS_OLD Job Class, Title, Pay Range, Hourly/Monthly/Annual Minimum and Maximum, EEO Code, Leave Type, Job Family for the Old Fiscal Year
QUERY.HR_LOOKUP_PAYTYPE Payroll Type Code, Payroll Type Description