<% dim adoConn, adoRS, adoRS2,counter, totcount, yearly, yeartot, myString1, myString2, myselect 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 CalSTRS_100K_Club" strQuery2 = "SELECT SUM(Annual) FROM calipers.CalSTRS_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 teachers and administrators
receive pensions
in excess of $100,000
from CalSTRS.

The information below was obtained under the Freedom of Information Act
from the California State Teachers Retirement System (CalSTRS).
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 School District <% if 0 then %> <% end if %> <% fp_sQry="SELECT DISTINCT EmployerName FROM CalSTRS_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")%> <% myString1=TRIM(FP_FieldHTML(fp_rs,"EmployerName")) IF Len(myString1) >= 14 Then myselect = FP_FieldHTML(fp_rs,"EmployerName") myString1 = Left(myString1, 14)&" ..." END IF %> <%=myString1%>   THE TOP 10 LIST <% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM CalSTRS_100K_Club ORDER BY Annual DESC LIMIT 2,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 District 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")%> <% myString2=TRIM(FP_FieldVal(fp_rs,"EmployerName")) IF Len(myString2) >= 16 Then myString2 = Left(myString2, 16)&" ..." END IF %> <%=myString2%>   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 DISTRICT Select the district from the drop-down box provided above. When you search by district, 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 CalSTRS   © Copyright 2009 by the California Foundation for Fiscal Responsibility. All Rights Reserved