reportDate

ratio

endQuaterAffected

dayFrom

dayTo

Cusip

entryId	groupId	EQUITY	CHANGE	CUSIP	DESCRIPTION	ISSUE STATUS CODE	ISSUE TYPE CODE	ADD DATE	EXPIRATION DATE	PAYMENT FREQUENCY CODE	MARGIN FLAG	OPTION FLAG	CONVERTED CUSIP	NASDAQ MARKET CODE	INDEX ISSUER	CHANGE DATE	MERGENT CHANGE DATE	MATURE DATE	undefined1	undefined2	undefined3	undefined4	temp1	temp2	fileName	fileDate	processDate
829502	829502	EXCHANGE	CHANGE	478366602	01	2009-03-18	2012-04-03	JCI_PZ	0	4	2009-03-18	?													20120404.ifs	2012-04-04	2012-04-05
829503	829502	EXCHANGE	CHANGE	478366602	01	2009-03-18	2012-04-02	JCI_PZ	0	4	2009-03-18	2012-04-04													20120404.ifs	2012-04-04	2012-04-05
827913	827913	CORPACTION	ADD	478366602	01	V	2012-04-03	478366107	01	?															20120403.ifs	2012-04-03	2012-04-04
827914	827914	EQUITY	CHANGE	478366602	CORP UNIT	0	4	2009-03-12	?	0	no	no		no		2009-03-12	?	?							20120403.ifs	2012-04-03	2012-04-04
827915	827914	EQUITY	CHANGE	478366602	CORP UNIT	V	4	2009-03-12	2012-04-03	0	no	no	478366107	no		2009-03-12	2012-04-03	?							20120403.ifs	2012-04-03	2012-04-04
755707	755707	DIVIDEND	ADD	478366602		0	0	1	0	1.4375		00	2012-03-13	2012-03-15	2012-04-02	2012-01-12		0	2012-01-12	?	0	0004320669			20120112.ifs	2012-01-12	2012-01-13
676034	676034	DIVIDEND	ADD	478366602		0	0	1	0	1.4375		00	2011-12-13	2011-12-15	2011-12-30	2011-10-20		0	2011-10-20	?	0	0004258898			20111020.ifs	2011-10-20	2011-10-21
625381	625381	DIVIDEND	ADD	478366602		0	0	1	0	1.4375		00	2011-09-13	2011-09-15	2011-09-30	2011-08-24		0	2011-08-24	?	0	0004231896			20110824.ifs	2011-08-24	2011-08-25
531222	531222	DIVIDEND	ADD	478366602		0	0	1	0	1.4375		00	2011-06-13	2011-06-15	2011-06-30	2011-05-20		0	2011-05-20	?	0	0004189828			20110520.ifs	2011-05-20	2011-05-21
460051	460051	DIVIDEND	ADD	478366602		0	0	1	0	1.4375		00	2011-03-11	2011-03-15	2011-03-31	2011-03-01		0	2011-03-01	?	0	0004155972			20110301.ifs	2011-03-01	2011-03-02
293788	293788	DIVIDEND	ADD	478366602		0	0	1	0	1.4375		00	2010-09-13	2010-09-15	2010-09-30	2010-08-31		0	2010-08-31	?	0	0004052227			20100831.ifs	2010-08-31	2010-09-01
198904	198904	DIVIDEND	ADD	478366602		0	0	1	0	1.4375		00	2010-06-11	2010-06-15	2010-06-30	2010-05-25		0	2010-05-25	?	0	0004008804			20100525.ifs	2010-05-25	2010-05-26
116829	116829	DIVIDEND	ADD	478366602		0	0	1	0	1.4375		00	2010-03-11	2010-03-15	2010-03-31	2010-02-25		0	2010-02-25	?	0	0003968713			20100225.ifs	2010-02-25	2010-04-07
37131	37131	DIVIDEND	ADD	478366602		0	0	1	0	1.4375		00	2009-12-11	2009-12-15	2009-12-31	2009-12-01		0	2009-12-01	?	0	0003918035			20091202.ifs	2009-12-02	2010-04-07

Old Cusip

entryId

groupId

EQUITY

CHANGE

CUSIP

DESCRIPTION

ISSUE STATUS CODE

ISSUE TYPE CODE

ADD DATE

EXPIRATION DATE

PAYMENT FREQUENCY CODE

MARGIN FLAG

OPTION FLAG

CONVERTED CUSIP

NASDAQ MARKET CODE

INDEX ISSUER

CHANGE DATE

MERGENT CHANGE DATE

MATURE DATE

undefined1

undefined2

undefined3

undefined4

temp1

temp2

fileName

fileDate

processDate

BACK UP Institutions before committing
SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 154771
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC