Page Comparison

select name, ps.employee_alt_id, campus_key as campus, eac_division_desc as division, 
eac_branch_desc as branch, eac_section_desc as section, job_title, 
grade, tenure_year, empl_status as status, sex as gender, 
decode(eeo_uh,'HS','Hispanic','AA','Black or African American','AI','American Indian or Alaskan','CA','White','CH','Chinese','FI','Filipino','GC','Guamanian or Chamorro','HW','Native Hawaiian or Part Hawaiian','IN','South Asian and Asian Indian','JP','Japanese','KO','Korean','LA','Laotian','MC','Micronesian','OA','Other Asian','OP','Other Pacific Islander','SA','Samoan','TH','Thai','TO','Tongan','VI','Vietnamese') as ethnicity
from edadba.psempl ps, edadba.psethnicity eth
where ps.employee_alt_id=eth.employee_alt_id and empl_status != 'T' and 
ps.employee_type_code='F' and tenure_code='FTN' order by name;