<% dim adoConn dim adoRS dim adoRS2 dim counter, totcount, yearly, yeartot set adoConn = Server.CreateObject("ADODB.Connection") set adoRS = Server.CreateObject("ADODB.Recordset") set adoRS2 = Server.CreateObject("ADODB.Recordset") adoConn.Open "DSN=calpers" strQuery = "Select Count(*) as numberofrecords from CalPERS_100K_Club" strQuery2 = "SELECT SUM(Annual) FROM calipers.CalPERS_100K_Club" adoRS.Open strQuery, adoConn adoRS2.Open strQuery2, adoConn totcount = adoRS.Fields("numberofrecords").Value totvalue = FormatNumber(totcount, 0) yearly = adoRS2.Fields("SUM(Annual)").Value yeartot = FormatCurrency(yearly) %>

<%=totvalue%>
retired California government workers
receive pensions
in excess of $100,000
from CalPERS.

The information below was obtained under the Freedom of Information Act
from the California Public Employees Retirement System (CalPERS).
This list may be be updated periodically with more pensioners as more data is obtained.
Our data sources will be listed at the bottom of this page.
 
E-mail us with your comments or questions.
 

Search the $100,000 Pension Club database ...

Search by First, Last or Full Name Search by Employer <% if 0 then %> <% end if %> <% fp_sQry="SELECT DISTINCT EmployerName FROM CalPERS_100K_Club ORDER BY EmployerName ASC" fp_sDefault="" fp_sNoRecords="No records returned." fp_sDataConn="calpers" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=True fp_sMenuChoice="EmployerName" fp_sMenuValue="EmployerName" fp_iDisplayCols=1 fp_fCustomQuery=True BOTID=1 fp_iRegion=BOTID %> SELECT ONE <%=FP_FieldHTML(fp_rs,"EmployerName")%>   THE TOP 10 LIST <% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM CalPERS_100K_Club ORDER BY Annual DESC LIMIT 1,10" fp_sDefault="" fp_sNoRecords="" fp_sDataConn="calpers" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="FULL_NAME" fp_sMenuValue="FULL_NAME" fp_iDisplayCols=4 fp_fCustomQuery=True BOTID=0 fp_iRegion=BOTID %> Name Monthly Annual Employer Name No records returned...   Please Enter a Name or Select an Employer and click on the 'SEARCH' button <%=FP_FieldVal(fp_rs,"FULL_NAME")%> <%=FormatCurrency(FP_FieldVal(fp_rs,"Monthly"))%> <%=FormatCurrency(FP_FieldVal(fp_rs,"Annual"))%> <%=FP_FieldVal(fp_rs,"EmployerName")%>   How to utilize this search engine. TO SEARCH BY NAME Enter one of the following in the NAME field provided above -- first, last, middle, suffix, first+last, or you can enter any letter (for example, a or z). Once you have entered your desired information, click on SEARCH. TO SEARCH BY EMPLOYER Select the employer from the drop-down box provided above. When you search by employer, you DO NOT need to also enter a name, although you can if you so wish. Once you have selected and/or entered your desired information, click on SEARCH.

Subscribe here to receive updates: Email:
Visit CaliforniaPensionReform.com to learn more about this issue.
Visit Facebook to join our network on this issue.
Visit PensionTsunami.com for daily news on public pensions.
HOME | CONTACT US | ADMIN   DATA SOURCES CalPERS LACERS © Copyright 2009 by the California Foundation for Fiscal Responsibility. All Rights Reserved