Home

Filer ID: 1030830

Table: filer_acronyms

acronym		CSIMS-PAC
filer_id		1030830

Table: filer_address

filer_id		1030830		1030830		1030830		1030830
adrid		1029003		2156589		2156590		2443180
effect_dt		1990-12-01 00:00:00		1986-10-27 00:00:00		1986-10-27 00:00:00		2017-12-19 00:00:00
add_type		7051		7051		7082		7051
session_id		1979		1985		1985		2017

Table: filer_filings

filer_id		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830
filing_id		186493		186494		186495		186496		186497		186498		186499		186500		186501		186502		186503		186504		186505		186506		186507		186508		186509		186510		186511		186512		186513		186514		186515		186517		186587		186588		186589		186590		186591		186592		186593		186594		186595		186596		186597		186598		186599		186600		186601		186602		186603		186604		186605		186606		186607		186608		186609		186610		186611		186612		186613		186614		186615		186616		186617		186518		186519		186520		186521		186522		186523		186524		186525		186526		186527		186528		186529		186530		186531		186532		186618		186619		186620		186533		186534		186535		186536		186537		186538		186539		186540		186541		186542		186544		186545		186546		186547		186548		186549		186550		186551		186552		186553		186554		186555		186556		186557		186558		186559		186560		186561		186562		186563		186564		186565		186566		186567		186568		186569		186570		186571		186572		186573		186574		186575		186576		186577		186578		186579		186580		186581		186582		186583		186584		186585		186586		220879		220880		220881		220882		220883		220884		220885		220886		220887		220888		220889		220890		220891		220892		220893		220894		220895		220896		220897		583726		592774		589594		186516		186543		638764		671984		676830		671984		710994		767647		728188		786009		775445		784955		803470		804211		821608		825021		869976		849616		850357		877077		878988		870744		900296		902910		962805		951002		960803		946148		981840		978057		996758		994970		998199		995923		1023478		1044784		1022121		1043810		1076277		1080128		1110900		1043810		1076277		1115345		1141141		1044784		1156536		1140118		1080128		1177842		1158553		1172752		1182432		1183971		1172171		1205409		1210121		1203344		1211042		1226610		1212312		1220395		1230626		1276930		1273751		1269872		1276465		1302444		1273580		1302864		1788847		1780520		1974142		1974895		1942509		1854739		1861959		1786772		1810809		1942509		1925857		1319178		1318613		1333625		1344041		1343540		1335073		1391205		1385042		1385042		1393046		1388198		1432025		1431194		1432025		1459648		1431194		1459036		1490279		1490926		1500191		1500800		1523720		1521856		1532310		1531086		1523720		1560015		1562195		1521856		1599238		1629547		1631495		1598791		1646139		1646471		1665678		1663154		1671610		1672406		1810074		1694558		1693499		1925857		1385042		1863328		1738948		1385042		1728903		1729275		1729749		1848735		1852540		1755048		1991734		1991060		2004386		2003527		1991060		2199195		2007564		2026472		1991734		2036461		2033421		2058537		2069377		2095581		2121616		2129014		2170088		2168202		1385042		2184761		2198607		2198763
period_id		127		84		86		89		93		95		96		94		95		97		95		98		101		100		101		85		89		89		91		91		85		85		87		85		133		135		135		137		137		139		140		140		141		142		143		145		145		145		145		145		147		148		148		149		151		153		154		153		154		153		155		156		156		156		155		102		93		93		101		97		94		97		102		101		103		103		103		104		103		103		156		156		159		105		105		105		106		107		108		108		108		109		110		111		113		113		114		114		114		115		116		116		116		117		117		121		119		121		122		121		122		122		123		124		124		124		121		125		127		127		127		127		129		129		130		130		130		130		130		130		131		132		132		132		132		132		97		99		101		90		103		105		107		108		121		122		124		124		117		135		138		140		155		156		157		None		None		None		87		110		None		None		None		None		None		165		None		None		None		167		168		None		169		None		171		169		None		172		None		None		172		None		None		None		175		173		None		176		177		177		None		None		None		None		177		179		180		None		181		179		180		None		None		None		185		183		None		186		None		None		186		None		185		None		188		187		None		188		188		188		None		None		None		None		189		191		None		None		215		213		221		None		None		None		218		None		None		None		219		None		193		193		None		194		None		195		121		196		None		None		None		197		None		None		197		199		201		None		202		None		None		203		None		204		None		204		None		203		None		207		None		205		209		None		None		209		210		None		215		None		211		219		212		None		None		213		None		213		212		218		217		None		None		223		224		225		223		None		None		226		None		None		225		226		None		228		227		None		None		229		232		231		231		None
form_id		F777		F410		F405		F405		F410		F405		F405		F405		F420		F405		F405		F420		F405		F420		F420		F405		F420		F420		F420		F420		F405		F420		F420		F405		F420		F420		F420		F420		F420		F420		F420		F497		F420		F420		F420		F420		F420		F497		F405		F420		F420		F420		F420		F420		F420		F420		F497		F420		F420		F405		F420		F497		F497		F497		F405		F420		F420		F420		F405		F420		F420		F420		F420		F405		F420		F405		F420		F888		F420		F405		F405		F420		F420		F420		F420		F405		F420		F420		F777		F777		F420		F420		F777		F420		F420		F420		F777		F420		F405		F420		F420		F420		F405		F405		F420		F777		F420		F405		F777		F420		F777		F420		F420		F777		F405		F420		F405		F420		F777		F495		F420		F420		F420		F420		F497		F497		F497		F497		F497		F420		F420		F497		F420		F497		F497		F420		F405		F420		F420		F420		F420		F405		F405		F420		F420		F777		F420		F405		F666		F495		F420		F420		F405		F405		F420		F420		F460		F460		F405		F420		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F497		F497		F460		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F410		F410		F497		F460		F497		F460		F410		F460		F460		F460		F497		F460		F460		F460		F497		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F410		F497		F460		F410
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		1		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		1		0		0		1		1		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		0		0		3		0		0		0		0		0		0		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		4		0		0		0
filing_date		1991-07-16 00:00:00		1980-10-27 00:00:00		1981-05-27 00:00:00		1982-03-22 00:00:00		1983-01-03 00:00:00		1983-12-02 00:00:00		1983-12-06 00:00:00		1983-12-02 00:00:00		1984-01-31 00:00:00		1984-06-25 00:00:00		1984-06-25 00:00:00		1984-07-26 00:00:00		1985-01-11 00:00:00		1985-01-28 00:00:00		1985-03-22 00:00:00		1982-01-05 00:00:00		1982-05-27 00:00:00		1982-03-22 00:00:00		1983-01-17 00:00:00		1982-09-22 00:00:00		1982-01-11 00:00:00		1981-07-31 00:00:00		1982-01-22 00:00:00		1982-01-22 00:00:00		1993-07-01 00:00:00		1993-07-15 00:00:00		1994-01-07 00:00:00		1994-03-18 00:00:00		1994-05-23 00:00:00		1994-10-03 00:00:00		1994-10-24 00:00:00		1994-11-03 00:00:00		1995-04-10 00:00:00		1995-07-12 00:00:00		1996-01-12 00:00:00		1996-02-14 00:00:00		1996-03-13 00:00:00		1996-03-15 00:00:00		1996-03-25 00:00:00		1996-07-10 00:00:00		1996-10-03 00:00:00		1996-10-24 00:00:00		1997-01-15 00:00:00		1997-07-01 00:00:00		1998-01-23 00:00:00		1998-03-20 00:00:00		1998-05-18 00:00:00		1998-05-20 00:00:00		1998-07-06 00:00:00		1998-07-06 00:00:00		1998-10-05 00:00:00		1998-10-20 00:00:00		1998-10-29 00:00:00		1998-10-27 00:00:00		1999-01-22 00:00:00		1985-07-18 00:00:00		1983-05-24 00:00:00		1983-03-22 00:00:00		1985-07-26 00:00:00		1984-05-24 00:00:00		1983-07-06 00:00:00		1984-03-21 00:00:00		1985-07-26 00:00:00		1985-07-26 00:00:00		1985-09-18 00:00:00		1985-09-06 00:00:00		1985-09-20 00:00:00		1985-11-04 00:00:00		1986-01-16 00:00:00		1986-02-18 00:00:00		1999-01-22 00:00:00		1999-01-22 00:00:00		1999-10-04 00:00:00		1986-03-20 00:00:00		1986-05-20 00:00:00		1986-05-23 00:00:00		1986-07-18 00:00:00		1986-10-02 00:00:00		1986-10-20 00:00:00		1986-10-29 00:00:00		1987-01-21 00:00:00		1987-04-30 00:00:00		1987-05-04 00:00:00		1988-01-27 00:00:00		1988-03-21 00:00:00		1988-05-26 00:00:00		1988-06-01 00:00:00		1988-07-06 00:00:00		1988-08-12 00:00:00		1988-10-04 00:00:00		1988-10-26 00:00:00		1989-01-06 00:00:00		1989-02-21 00:00:00		1989-02-28 00:00:00		1989-07-26 00:00:00		1990-01-24 00:00:00		1990-01-11 00:00:00		1990-03-22 00:00:00		1990-04-06 00:00:00		1990-05-22 00:00:00		1990-05-29 00:00:00		1990-07-06 00:00:00		1990-10-01 00:00:00		1990-11-01 00:00:00		1991-01-15 00:00:00		1991-01-15 00:00:00		1991-04-17 00:00:00		1991-07-25 00:00:00		1991-07-17 00:00:00		1991-09-05 00:00:00		1991-09-05 00:00:00		1992-01-10 00:00:00		1992-03-17 00:00:00		1992-05-18 00:00:00		1992-05-20 00:00:00		1992-05-22 00:00:00		1992-05-26 00:00:00		1992-05-27 00:00:00		1992-05-29 00:00:00		1992-07-10 00:00:00		1992-10-02 00:00:00		1992-10-20 00:00:00		1992-10-19 00:00:00		1992-10-23 00:00:00		1992-11-02 00:00:00		1993-01-15 00:00:00		1984-06-25 00:00:00		1984-10-25 00:00:00		1985-05-23 00:00:00		1982-07-14 00:00:00		1985-10-24 00:00:00		1986-02-07 00:00:00		1986-07-01 00:00:00		1986-10-23 00:00:00		1990-03-20 00:00:00		1990-05-24 00:00:00		1990-10-25 00:00:00		1991-02-26 00:00:00		1992-12-01 00:00:00		1993-07-15 00:00:00		1994-07-11 00:00:00		1995-01-09 00:00:00		1998-10-13 00:00:00		1998-12-17 00:00:00		1999-07-09 00:00:00		2000-01-03 00:00:00		2000-02-22 00:00:00		2000-01-26 00:00:00		1982-03-11 00:00:00		1987-07-07 00:00:00		2000-07-05 00:00:00		2000-10-23 00:00:00		2000-10-23 00:00:00		2000-10-02 00:00:00		2001-01-11 00:00:00		2001-07-12 00:00:00		2001-02-01 00:00:00		2001-10-09 00:00:00		2001-07-13 00:00:00		2001-10-04 00:00:00		2002-01-05 00:00:00		2002-01-08 00:00:00		2002-02-20 00:00:00		2002-02-21 00:00:00		2002-10-01 00:00:00		2002-07-15 00:00:00		2002-07-18 00:00:00		2002-10-23 00:00:00		2002-10-24 00:00:00		2002-10-01 00:00:00		2003-01-09 00:00:00		2003-01-10 00:00:00		2003-10-01 00:00:00		2003-07-30 00:00:00		2003-10-01 00:00:00		2003-07-30 00:00:00		2004-01-07 00:00:00		2004-01-05 00:00:00		2004-02-19 00:00:00		2004-02-16 00:00:00		2004-02-19 00:00:00		2004-02-17 00:00:00		2004-07-14 00:00:00		2004-10-01 00:00:00		2004-07-12 00:00:00		2004-10-01 00:00:00		2005-01-27 00:00:00		2005-01-27 00:00:00		2005-07-05 00:00:00		2005-05-03 00:00:00		2005-05-03 00:00:00		2005-07-07 00:00:00		2006-01-04 00:00:00		2005-05-04 00:00:00		2006-03-20 00:00:00		2006-01-03 00:00:00		2005-05-04 00:00:00		2006-06-01 00:00:00		2006-03-21 00:00:00		2006-05-22 00:00:00		2006-07-05 00:00:00		2006-07-10 00:00:00		2006-05-21 00:00:00		2006-10-03 00:00:00		2006-10-23 00:00:00		2006-10-02 00:00:00		2006-10-23 00:00:00		2007-01-05 00:00:00		2006-10-26 00:00:00		2006-11-06 00:00:00		2007-01-08 00:00:00		2007-07-09 00:00:00		2006-06-01 00:00:00		2006-10-26 00:00:00		2007-07-09 00:00:00		2008-01-08 00:00:00		2006-11-06 00:00:00		2008-01-08 00:00:00		2013-08-22 00:00:00		2013-07-30 00:00:00		2015-07-14 00:00:00		2015-07-14 00:00:00		2015-02-24 00:00:00		2014-05-22 00:00:00		2014-07-09 00:00:00		2013-07-31 00:00:00		2014-01-15 00:00:00		2015-01-15 00:00:00		2015-02-24 00:00:00		2008-03-18 00:00:00		2008-03-18 00:00:00		2008-05-20 00:00:00		2008-07-17 00:00:00		2008-07-16 00:00:00		2008-05-21 00:00:00		2009-01-22 00:00:00		2008-12-23 00:00:00		2008-12-30 00:00:00		2009-01-27 00:00:00		2008-12-30 00:00:00		2009-08-24 00:00:00		2009-08-24 00:00:00		2009-07-16 00:00:00		2010-01-21 00:00:00		2009-07-16 00:00:00		2010-01-21 00:00:00		2010-05-26 00:00:00		2010-05-26 00:00:00		2010-07-13 00:00:00		2010-07-13 00:00:00		2010-10-05 00:00:00		2010-10-21 00:00:00		2010-10-21 00:00:00		2010-10-21 00:00:00		2010-10-21 00:00:00		2011-01-14 00:00:00		2011-01-18 00:00:00		2010-10-04 00:00:00		2011-07-07 00:00:00		2012-01-19 00:00:00		2012-01-23 00:00:00		2011-07-06 00:00:00		2012-03-20 00:00:00		2012-03-20 00:00:00		2012-05-24 00:00:00		2012-05-24 00:00:00		2012-07-16 00:00:00		2012-07-17 00:00:00		2014-01-14 00:00:00		2012-10-04 00:00:00		2012-10-03 00:00:00		2015-01-15 00:00:00		2012-12-14 00:00:00		2014-07-10 00:00:00		2013-01-24 00:00:00		2013-01-18 00:00:00		2012-12-18 00:00:00		2013-01-18 00:00:00		2013-01-22 00:00:00		2014-05-09 00:00:00		2014-05-21 00:00:00		2013-01-22 00:00:00		2015-10-09 00:00:00		2016-01-18 00:00:00		2016-01-18 00:00:00		2016-01-12 00:00:00		2015-10-07 00:00:00		2017-12-19 00:00:00		2016-01-21 00:00:00		2016-04-06 00:00:00		2016-01-21 00:00:00		2016-04-27 00:00:00		2016-04-27 00:00:00		2016-07-26 00:00:00		2016-07-27 00:00:00		2016-10-25 00:00:00		2017-01-20 00:00:00		2017-01-23 00:00:00		2017-07-18 00:00:00		2017-07-18 00:00:00		2017-12-18 00:00:00		2017-09-20 00:00:00		2017-12-18 00:00:00		2017-12-19 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10001		10005		10006		10005		10005		10005		10001		10005		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10001		10005		10005		10001		10005		10005		10005		10001		10001		10005		10001		10001		10001		10005		10005		10005		10005		10001		10001		10001		10005		10001		10002		10002		10005		10005		10006		10001		10001		10006		10001		10005		10005		10001		10005		10001		10005		10001		10001		10005		10001		10001		10001		10005		10005		10005		10005		10001		10001		10005		10005		10001		10001		10001		10005		10006		10005		10001		10005		10005		10005		10002		10005		10001		10001		10005		10001		10005		10001		10001		10002		10005		10006		10006		10002		10005		10005		10001		10001		10001		10005		10001		10005		10005		10002		10005		10001		10006		10001		10005		10001		10005		10001		10005		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10002		10005		10005		10002		10006		10001		10001		10001		10001		10006		10005		10002		10001		10001		10001		10003		10005		10001		10006		10005		10001		10001		10005		10001		10001		10005		10005		10001		10003		10001		10001		10003
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11002		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		1991		1979		1981		1981		1983		1983		1983		1983		1983		1983		1983		1983		1985		1983		1985		1981		1981		1981		1981		1981		1981		1981		1981		1981		1993		1993		1993		1993		1993		1993		1993		1993		1995		1995		1995		1995		1995		1995		1995		1995		1995		1995		1995		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1985		1983		1983		1985		1983		1983		1983		1985		1985		1985		1985		1985		1985		1985		1985		1997		1997		1999		1985		1985		1985		1985		1985		1985		1985		1985		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1989		1989		1989		1989		1989		1989		1989		1989		1989		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1983		1983		1985		1981		1985		1985		1985		1985		1989		1989		1989		1989		1989		1993		1993		1993		1997		1997		1999		1999		1999		1999		1981		1987		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2005		2005		2003		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2005		2007		2007		2005		2007		2013		2013		2015		2015		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		1989		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2011		2011		2013		2011		2013		2011		2013		2011		2013		2011		2013		2013		2013		2015		2015		2015		2015		2015		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		GPEREZ		*		*		TTHAM		KCHAN		KCHAN		KCHAN		TWALLS		*		GKURIMOT		CFLAGG		GPEREZ		*		*		CFLAGG		*		DBARRICK		*		*		DBARRICK		*		DBARRICK		DBARRICK		COMPLETED		DBARRICK		KVANG		GGILMORE		COMPLETED		COMPLETED		GGILMORE		COMPLETED		COMPLETED		COMPLETED		LLEONG		KLARRY		EMCENTEE		CFLAGG		COMPLETED		COMPLETED		COMPLETED		GPEREZ		*		*		*		CFLAGG		GPEREZ		JWHITE		*		*		JWHITE		DHORRELL		GPEREZ		CFLAGG		*		CFLAGG		*		GPEREZ		*		*		CFLAGG		*		DHORRELL		DHORRELL		SARRIAGA		GPEREZ		DHORRELL		DHORRELL		*		*		DHORRELL		SARRIAGA		WBROWN		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MPACHECO		MDIGRAZIA		CAFILER		MDIGRAZIA		SARRIAGA		DODONOGHUE		MDIGRAZIA		SARRIAGA		*		*		SARRIAGA		*		HTSUBOI		*		*		*		JVAZQUEZ		RGEREMIA		JVAZQUEZ		*		MMORENO		MMORENO		MMORENO		MMORENO		*		JVAZQUEZ		*		SARRIAGA		MPACHECO		*		SMCCONNAN		SMCCONNAN		MPACHECO		CPON		CPON		*		MMORENO		SMCCONNAN		SMCCONNAN		MMORENO		CPON		CPON		MDIGRAZIA		MDIGRAZIA		CPON		CPON		SARRIAGA		MPACHECO		CAFILER		CAFILER		TRAMON		MPACHECO		MPACHECO		TRAMON		TRAMON		WBROWN		CAFILER		CAFILER		MDIGRAZIA		TRAMON		SARRIAGA		CAFILER		MDIGRAZIA		PDEO		SARRIAGA		LBARTHOL		MDIGRAZIA		KBANH		MPACHECO		MDIGRAZIA		MDIGRAZIA		SMCCONNAN		SMCCONNAN		PDEO		SARRIAGA		SARRIAGA		LBARTHOL		LBARTHOL		TRAMON		GKURIMOT		LBARTHOL		TRAMON
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003
rpt_start		None		None		None		None		None		1983-07-01 00:00:00		None		1983-05-22 00:00:00		1983-09-18 00:00:00		1984-03-18 00:00:00		1983-09-18 00:00:00		1984-05-20 00:00:00		None		1984-10-21 00:00:00		1985-01-01 00:00:00		1981-01-01 00:00:00		1982-03-18 00:00:00		1982-01-01 00:00:00		1982-09-18 00:00:00		1982-07-01 00:00:00		1981-01-01 00:00:00		1981-01-01 00:00:00		1981-07-01 00:00:00		1981-01-01 00:00:00		1993-01-01 00:00:00		1993-07-01 00:00:00		1993-07-11 00:00:00		1994-01-01 00:00:00		1994-03-18 00:00:00		1994-07-01 00:00:00		1994-10-01 00:00:00		None		1995-01-01 00:00:00		1995-04-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1996-02-11 00:00:00		None		1996-02-11 00:00:00		1996-03-10 00:00:00		1996-07-01 00:00:00		1996-10-01 00:00:00		1996-10-20 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		None		1998-03-18 00:00:00		1998-05-17 00:00:00		1998-03-18 00:00:00		1998-07-01 00:00:00		None		None		None		1998-07-01 00:00:00		1985-05-19 00:00:00		1983-03-18 00:00:00		1983-01-01 00:00:00		1985-01-01 00:00:00		1984-03-18 00:00:00		1983-05-22 00:00:00		1984-01-01 00:00:00		1985-05-19 00:00:00		1985-03-18 00:00:00		1985-07-01 00:00:00		None		1985-07-01 00:00:00		None		1985-09-18 00:00:00		1985-09-18 00:00:00		1998-10-01 00:00:00		1998-10-18 00:00:00		1999-07-01 00:00:00		1986-01-01 00:00:00		1986-03-18 00:00:00		1986-01-01 00:00:00		1986-05-18 00:00:00		1986-07-01 00:00:00		None		None		1986-10-19 00:00:00		1987-01-01 00:00:00		None		1987-07-01 00:00:00		1988-01-01 00:00:00		1988-03-18 00:00:00		None		1988-05-22 00:00:00		1988-05-22 00:00:00		1988-07-01 00:00:00		1988-10-01 00:00:00		1988-10-23 00:00:00		1988-10-23 00:00:00		None		1989-01-01 00:00:00		None		1989-07-01 00:00:00		None		None		1990-03-18 00:00:00		None		1990-05-20 00:00:00		1990-07-01 00:00:00		None		1990-10-01 00:00:00		1990-10-21 00:00:00		1990-01-01 00:00:00		1991-01-01 00:00:00		None		None		1991-07-01 00:00:00		1991-09-01 00:00:00		1992-01-01 00:00:00		1992-03-18 00:00:00		None		None		None		None		None		1992-05-17 00:00:00		1992-07-01 00:00:00		None		1992-10-01 00:00:00		None		None		1992-10-18 00:00:00		1984-01-01 00:00:00		1984-07-01 00:00:00		1985-03-18 00:00:00		1982-05-23 00:00:00		1985-09-18 00:00:00		None		None		1986-10-01 00:00:00		1990-01-01 00:00:00		None		1990-10-01 00:00:00		1990-10-21 00:00:00		1989-01-01 00:00:00		None		1994-05-22 00:00:00		1994-10-23 00:00:00		1998-07-01 00:00:00		1998-10-01 00:00:00		1999-01-01 00:00:00		1999-10-01 00:00:00		2000-01-23 00:00:00		2000-01-01 00:00:00		1981-07-01 00:00:00		1987-04-26 00:00:00		2000-02-20 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-07-01 00:00:00		2000-10-22 00:00:00		2001-01-01 00:00:00		2001-02-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-02-17 00:00:00		2002-02-17 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		2002-10-20 00:00:00		2002-10-20 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-02-19 00:00:00		2004-01-01 00:00:00		None		2004-01-01 00:00:00		2004-02-15 00:00:00		2004-07-01 00:00:00		2004-02-15 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2004-07-01 00:00:00		2006-01-01 00:00:00		2005-07-01 00:00:00		2004-10-01 00:00:00		2006-06-01 00:00:00		2006-01-01 00:00:00		2006-03-18 00:00:00		2006-05-21 00:00:00		2006-05-21 00:00:00		2006-03-18 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2006-10-22 00:00:00		2006-10-26 00:00:00		2006-11-06 00:00:00		2006-10-22 00:00:00		2007-01-01 00:00:00		None		None		2007-01-01 00:00:00		2007-07-01 00:00:00		None		2007-07-01 00:00:00		2013-08-22 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2014-05-18 00:00:00		2013-01-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-03-18 00:00:00		2008-05-18 00:00:00		2008-05-18 00:00:00		2008-03-18 00:00:00		2008-07-01 00:00:00		1990-03-22 00:00:00		2008-12-23 00:00:00		2008-07-01 00:00:00		None		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-05-23 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2010-07-01 00:00:00		2010-10-17 00:00:00		2010-10-17 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-03-18 00:00:00		2012-03-18 00:00:00		2012-05-20 00:00:00		2012-05-20 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2014-07-01 00:00:00		2012-12-13 00:00:00		2014-05-18 00:00:00		2012-10-01 00:00:00		2013-01-18 00:00:00		None		2013-01-18 00:00:00		2012-10-01 00:00:00		2014-05-09 00:00:00		2014-01-01 00:00:00		None		2015-07-01 00:00:00		2015-07-01 00:00:00		2015-10-01 00:00:00		2016-01-12 00:00:00		2015-07-01 00:00:00		2017-07-01 00:00:00		2015-10-01 00:00:00		2016-04-06 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-04-24 00:00:00		2016-04-24 00:00:00		2016-10-25 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-12-15 00:00:00		2017-09-20 00:00:00		2017-07-01 00:00:00		None
rpt_end		None		None		None		None		None		1983-09-17 00:00:00		None		1983-06-30 00:00:00		1983-12-31 00:00:00		1984-05-19 00:00:00		1983-12-31 00:00:00		1984-06-30 00:00:00		None		1984-12-31 00:00:00		1985-03-17 00:00:00		1981-06-30 00:00:00		1982-05-22 00:00:00		1982-03-17 00:00:00		1982-12-31 00:00:00		1982-09-17 00:00:00		1981-06-30 00:00:00		1981-06-30 00:00:00		1981-12-31 00:00:00		1981-06-30 00:00:00		1993-06-30 00:00:00		1993-07-10 00:00:00		1993-12-31 00:00:00		1994-03-17 00:00:00		1994-05-21 00:00:00		1994-09-30 00:00:00		1994-10-22 00:00:00		None		1995-03-31 00:00:00		1995-06-30 00:00:00		1995-12-31 00:00:00		1996-02-10 00:00:00		1996-03-09 00:00:00		None		1996-03-09 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		1996-10-19 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-03-17 00:00:00		None		1998-05-16 00:00:00		1998-06-30 00:00:00		1998-05-16 00:00:00		1998-09-30 00:00:00		None		None		None		1998-09-30 00:00:00		1985-06-30 00:00:00		1983-05-21 00:00:00		1983-03-17 00:00:00		1985-03-17 00:00:00		1984-05-19 00:00:00		1983-06-30 00:00:00		1984-03-17 00:00:00		1985-06-30 00:00:00		1985-05-18 00:00:00		1985-09-17 00:00:00		None		1985-09-17 00:00:00		None		1985-12-31 00:00:00		1985-12-31 00:00:00		1998-10-17 00:00:00		1998-12-31 00:00:00		1999-09-30 00:00:00		1986-03-17 00:00:00		1986-05-17 00:00:00		1986-03-17 00:00:00		1986-06-30 00:00:00		1986-09-30 00:00:00		None		None		1986-12-31 00:00:00		1987-04-25 00:00:00		None		1987-12-31 00:00:00		1988-03-17 00:00:00		1988-05-21 00:00:00		None		1988-06-30 00:00:00		1988-06-30 00:00:00		1988-09-30 00:00:00		1988-10-22 00:00:00		1988-12-31 00:00:00		1988-12-31 00:00:00		None		1989-06-30 00:00:00		None		1989-12-31 00:00:00		None		None		1990-05-19 00:00:00		None		1990-06-30 00:00:00		1990-09-30 00:00:00		None		1990-10-20 00:00:00		1990-12-31 00:00:00		1990-03-17 00:00:00		1991-06-30 00:00:00		None		None		1991-08-31 00:00:00		1991-12-31 00:00:00		1992-03-17 00:00:00		1992-05-16 00:00:00		None		None		None		None		None		1992-06-30 00:00:00		1992-09-30 00:00:00		None		1992-10-17 00:00:00		None		None		1992-12-31 00:00:00		1984-03-17 00:00:00		1984-10-20 00:00:00		1985-05-18 00:00:00		1982-06-30 00:00:00		1985-10-19 00:00:00		None		None		1986-10-18 00:00:00		1990-03-17 00:00:00		None		1990-10-20 00:00:00		1990-12-31 00:00:00		1990-12-31 00:00:00		None		1994-06-30 00:00:00		1994-12-31 00:00:00		1998-09-30 00:00:00		1998-10-17 00:00:00		1999-06-30 00:00:00		1999-12-31 00:00:00		2000-02-19 00:00:00		2000-01-22 00:00:00		1981-12-31 00:00:00		1987-06-30 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-10-21 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-02-01 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-02-16 00:00:00		2002-02-16 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-10-19 00:00:00		2002-10-19 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-02-19 00:00:00		2004-02-14 00:00:00		None		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2004-09-30 00:00:00		2006-03-17 00:00:00		2005-12-31 00:00:00		2004-12-31 00:00:00		2006-06-01 00:00:00		2006-03-17 00:00:00		2006-05-20 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-05-20 00:00:00		2006-09-30 00:00:00		2006-10-21 00:00:00		2006-09-30 00:00:00		2006-10-21 00:00:00		2006-12-31 00:00:00		2006-10-26 00:00:00		2006-11-06 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		None		None		2007-06-30 00:00:00		2007-12-31 00:00:00		None		2007-12-31 00:00:00		2013-08-22 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2014-12-31 00:00:00		2014-05-17 00:00:00		2014-06-30 00:00:00		2013-06-30 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2008-03-17 00:00:00		2008-03-17 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-05-17 00:00:00		2008-12-31 00:00:00		1990-03-22 00:00:00		2008-12-23 00:00:00		2008-12-31 00:00:00		None		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2010-09-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2012-05-19 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2014-12-31 00:00:00		2012-12-13 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2013-01-18 00:00:00		None		2013-01-18 00:00:00		2012-12-31 00:00:00		2014-05-09 00:00:00		2014-05-17 00:00:00		None		2015-09-30 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2016-01-12 00:00:00		2015-09-30 00:00:00		2017-12-15 00:00:00		2015-12-31 00:00:00		2016-04-06 00:00:00		2015-09-30 00:00:00		2016-04-23 00:00:00		2016-04-23 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-10-25 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2017-12-15 00:00:00		2017-09-20 00:00:00		2017-12-15 00:00:00		None
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2001-07-31 00:00:00		None		None		None		2001-10-01 00:00:00		2002-01-04 00:00:00		None		2002-02-20 00:00:00		None		2002-09-24 00:00:00		2002-06-20 00:00:00		None		2002-10-20 00:00:00		None		None		2003-01-07 00:00:00		None		None		None		2003-09-26 00:00:00		2003-07-25 00:00:00		None		2003-12-29 00:00:00		2004-02-19 00:00:00		2004-02-16 00:00:00		None		None		None		None		2004-06-24 00:00:00		2004-09-22 00:00:00		2005-01-13 00:00:00		None		2005-06-16 00:00:00		2005-05-03 00:00:00		2005-05-03 00:00:00		None		None		None		2006-03-18 00:00:00		2005-12-27 00:00:00		None		2006-06-01 00:00:00		None		None		2006-07-05 00:00:00		None		2006-05-22 00:00:00		None		2006-10-23 00:00:00		2006-10-01 00:00:00		None		2007-01-03 00:00:00		2006-10-26 00:00:00		2006-11-06 00:00:00		None		None		None		None		2007-07-01 00:00:00		2008-01-02 00:00:00		None		None		2013-08-22 00:00:00		2013-07-12 00:00:00		2015-07-01 00:00:00		None		None		None		2014-07-07 00:00:00		None		None		None		2015-02-19 00:00:00		None		2008-03-18 00:00:00		2008-05-19 00:00:00		None		2008-07-01 00:00:00		None		2009-01-14 00:00:00		None		None		None		None		None		2009-08-19 00:00:00		None		None		2009-07-01 00:00:00		2010-01-04 00:00:00		2010-05-23 00:00:00		None		2010-07-01 00:00:00		None		None		2010-10-20 00:00:00		None		2010-10-20 00:00:00		None		2011-01-06 00:00:00		None		2010-10-01 00:00:00		None		2012-01-09 00:00:00		None		2011-07-05 00:00:00		2012-03-19 00:00:00		None		None		2012-05-20 00:00:00		2012-07-06 00:00:00		None		2014-01-13 00:00:00		None		2012-10-01 00:00:00		2015-01-14 00:00:00		None		None		None		None		None		2013-01-18 00:00:00		2013-01-09 00:00:00		2014-05-09 00:00:00		2014-05-18 00:00:00		None		None		2016-01-06 00:00:00		2015-01-06 00:00:00		2016-01-12 00:00:00		2015-10-01 00:00:00		None		None		2016-04-06 00:00:00		None		None		2016-04-25 00:00:00		2016-07-01 00:00:00		None		2016-10-25 00:00:00		2017-01-06 00:00:00		None		None		2017-07-05 00:00:00		None		2017-09-20 00:00:00		2017-12-18 00:00:00		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		None		22001		22001		None		22001		22001		22001		None		None		None		None		22001		22001		22001		None		22001		22001		22001		None		None		None		22001		22001		None		22001		None		None		22001		None		22001		None		22001		22001		None		22001		22001		22001		None		None		None		None		22001		22001		None		None		22001		22001		22001		None		None		None		22001		None		None		None		22001		None		22001		22001		None		22001		None		22001		22001		22001		None		None		None		22001		None		None		22001		22001		22001		None		22001		None		None		22001		None		22001		None		22001		None		22001		None		22001		None		22001		22001		None		None		22001		22001		None		22001		None		22001		22001		22001		None		None		22001		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		None		22001		None		None		22001		22001		None		22001		22001		None		None		22001		22001		22001		22001		None

Table: filer_to_filer_type

filer_id		1030830		1030830
filer_type		16		16
active		Y		T
race		0		0
session_id		1979		2017
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		1990-12-01 00:00:00		2017-12-15 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		S		S
nyq_dt		1980-10-27 00:00:00		1980-10-27 00:00:00
party_cd		None		None
county_cd		18004		18004
district_cd		None		None

Table: filer_xref

filer_id		1030830
xref_id		810568
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		810568		810568		810568
filer_id		1030830		1030830		1030830
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED		TERMINATED
effect_dt		2017-12-15 00:00:00		2017-12-15 00:00:00		2017-12-15 00:00:00
naml		CALIFORNIA SOCIETY OF INDUSTRIAL MEDICINE AND SURGERY POLITICAL ACTION COMMITTEE		CALIFORNIA SOCIETY OF INDUSTRIAL MEDICINE AND SURGERY POLITICAL ACTION COMMITTEE		CALIFORNIA SOCIETY OF INDUSTRIAL MEDICINE AND SURGERY POLITICAL ACTION COMMITTEE
namf		None		None		None
namt		None		None		None
nams		None		None		None
adr1		None		None		None
adr2		None		None		None
city		Sacramento		None		SACRAMENTO
st		CA		None		CA
zip4		95814		None		95814
phon		9164422280		(916) 442-2280		9164422280
fax				303900
email		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1030830

Table: received_filings

filer_id		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830		1030830
filing_file_name		767647_0.cal		784955_0.cal		803470_0.cal		821608_0.cal		849616_0.cal		869976_0.cal		877077_0.cal		900296_0.cal		946148_0.cal		960803_0.cal		978057_0.cal		996758_0.cal		1177842_0.cal		1212312_0.cal		1220395_0.cal		1848735_0.cal		1729275_0.cal		1788847_0.cal		2003527_0.cal		24824.cal		2026472_0.cal		302651.cal		302692.cal		2095581_0.cal		2184761_0.cal
received_date		2001-07-12 00:00:00		2001-10-04 00:00:00		2002-01-05 00:00:00		2002-02-20 00:00:00		2002-07-15 00:00:00		2002-10-01 00:00:00		2002-10-23 00:00:00		2003-01-09 00:00:00		2003-07-30 00:00:00		2003-10-01 00:00:00		2004-01-05 00:00:00		2004-02-19 00:00:00		2006-06-01 00:00:00		2006-10-26 00:00:00		2006-11-06 00:00:00		2014-05-09 00:00:00		2013-01-18 00:00:00		2013-08-22 00:00:00		2016-01-12 00:00:00		2016-01-12 00:00:00		2016-04-06 00:00:00		2016-04-06 00:00:00		2016-04-06 00:00:00		2016-10-25 00:00:00		2017-09-20 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		767647		784955		803470		821608		849616		869976		877077		900296		946148		960803		978057		996758		1177842		1212312		1220395		1848735		1729275		1788847		2003527		None		2026472		None		None		2095581		2184761
form_id		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		None		None		F497		F497
receive_comment		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted