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