<% dim adoConn dim adoRS dim counter, totcount set adoConn = Server.CreateObject("ADODB.Connection") set adoRS = Server.CreateObject("ADODB.Recordset") adoConn.Open "DSN=calpers" strQuery = "Select Count(*) as numberofrecords from CalPERS_100K_Club" adoRS.Open strQuery, adoConn totcount = adoRS.Fields("numberofrecords").Value totvalue = FormatNumber(totcount, 0) %>

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

They're all listed here.

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.
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="calipers" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=True fp_sMenuChoice="EmployerName" fp_sMenuValue="EmployerName" fp_sColTypes="&EmployerName=129&" 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="calipers" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="FULL_NAME" fp_sMenuValue="FULL_NAME" fp_sColTypes="&FULL_NAME=129&Monthly=129&Annual=129&Agency=131&EmployerName=129&RECNO=19&" 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")%> <%=FP_FieldVal(fp_rs,"Monthly")%> <%=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 you DO NOT need to enter a name although you can if you so wish. Once you have selected/entered your desired information click on 'SEARCH'

Visit CaliforniaPensionReform.com to learn more about this issue.
Visit CaliforniaPropositions.org to join our network on this issue.
Visit PensionTsunami.com for daily news on public pensions.
HOME | CONTACT US | ADMIN © Copyright 2009 by the California Foundation for Fiscal Responsibility. All Right Reserved