Home

Filer ID: 1042246

Table: efs_filing_log

filing_date		2002-01-10 00:00:00		2002-01-10 00:00:00
filingstatus		2		2
vendor		vendor		vendor
filer_id		1042246		1042246
form_type		form		form
error_no		BADFORMAT 253		BADFORMAT 253

Table: filer_address

filer_id		1042246		1042246		1042246		1042246		1042246		1042246
adrid		1041002		1041003		2213466		2298260		2300911		2374364
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		2011-02-02 00:00:00		2013-08-01 00:00:00		2013-10-28 00:00:00		2015-09-28 00:00:00
add_type		7051		7051		7051		7051		7051		7051
session_id		1985		1985		2011		2013		2013		2015

Table: filer_filings

filer_id		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246
filing_id		680059		277619		277620		277621		277622		277623		277624		277625		277626		277627		277628		277629		277630		277631		277632		277633		277634		277635		277636		277637		277638		277639		277640		277641		277642		277643		277644		277645		277646		277647		277648		277649		277650		277651		277652		277653		426585		426586		426587		426588		592095		582800		582803		582299		679338		665479		682592		647630		682749		719172		690877		690990		691735		691745		724461		775156		791010		789018		773179		793748		805473		796635		799282		810061		812018		799892		806784		822464		825110		843135		847455		847456		847457		847458		847459		847460		847461		847463		856918		877249		682592		859335		878536		871843		888355		872537		883328		912836		916556		898885		966510		950993		948067		977052		973132		980195		981555		986844		971881		998920		998921		998920		998921		984254		996748		1000640		1000642		1000157		1032290		1034364		1055065		1049098		1052907		1045212		1046049		1055331		1082734		1092696		1120844		1119073		1087937		1126976		1134932		1126407		1131608		1181015		1151361		1158442		1157205		1148204		1174118		1204713		1196155		1191822		1207187		1217666		1211884		1243720		1238094		1266788		1302321		1302794		1302321		1305935		1284972		1287750		1307898		1294979		793748		1291654		1302794		1783680		1787238		1870782		1870784		1870785		1855063		1855064		1855067		1858405		1853900		1803655		1798322		1793063		1792170		1797043		1791236		1935685		1917458		1949731		1879183		1897535		1904288		1320267		1298451		1292802		1326523		1337080		1351067		1321163		1328126		1334976		1353609		1338499		1369225		1363099		1363793		1373527		1378562		1377083		1396936		1400671		1446507		1448899		1448968		1446109		1438409		1440654		1467088		1473772		1464224		1491593		1494454		1505908		1475660		1508852		1494454		1522661		1491593		1531327		1534003		1539683		1525560		1543335		1571836		1575131		1571836		1582748		1606545		1615801		1607687		1623400		1624159		1616527		1606545		1607687		1646398		1638975		1646734		1650484		1620539		1663511		1666250		1818172		1824955		1830647		1697819		1678064		1684032		1694814		1710969		1703603		1893266		1879205		1734205		1835439		1749664		1987950		1990129		1990524		1995055		1983011		1989511		1989569		2199479		1989569		2201629		2012227		2025687		2025688		1993342		2012254		2018808		2033574		2042284		2040540		2042284		2049315		2051924		2046786		2063621		2077684		2083052		2084503		2097957		2106609		2090044		2107508		2147923		2130154		2174534		2201135		2179768
period_id		None		107		107		105		105		108		107		108		107		108		108		115		119		119		119		120		146		145		147		149		152		152		150		152		154		156		156		155		151		153		153		155		157		158		159		160		148		150		154		148		None		None		None		None		None		None		163		None		164		164		164		None		None		None		None		None		None		167		165		None		168		None		168		169		None		None		None		169		None		None		None		None		None		None		None		None		None		None		169		172		163		None		None		171		None		None		172		172		None		157		175		None		173		None		176		176		None		None		None		177		177		177		177		177		177		None		None		None		177		None		180		180		None		179		None		None		180		165		None		181		None		None		None		183		183		None		None		None		185		184		185		187		None		186		None		None		188		None		188		None		192		None		192		193		189		None		None		191		None		191		None		213		None		218		218		218		218		218		218		None		217		None		None		None		215		215		None		220		None		None		None		None		220		193		None		None		193		None		194		None		None		194		None		194		196		195		None		None		None		196		196		None		None		None		199		199		197		None		None		201		200		201		None		202		None		None		None		203		201		204		None		204		None		None		204		None		204		None		None		207		205		None		208		None		None		205		None		208		209		None		207		209		None		216		None		217		None		210		None		211		None		212		219		None		212		None		None		None		None		None		224		221		223		223		231		232		None		224		None		None		223		224		None		225		226		None		226		226		None		226		226		None		227		228		227		None		228		None		None		228		229		None		None
form_id		F460		F410		F405		F420		F405		F420		F420		F420		F405		F405		F405		F420		F405		F405		F405		F405		F497		F405		F420		F420		F497		F497		F497		F405		F405		F420		F420		F405		F420		F420		F420		F420		F405		F405		F420		F497		F420		F497		F420		F420		F460		F420		F420		F497		F497		F405		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F410		F460		F405		F460		F460		F460		F460		F460		F460		F460		F497		F405		F405		F405		F405		F405		F405		F405		F405		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F460		F666		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F497		F497		F460		F460		F497		F497		F460		F460		F460		F497		F460		F497		F460		F460		F460		F460		F666		F460		F460		F460		F460		F460		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		F410		F460		F460		F460		F460		F460		F465		F465		F497		F496		F496		F460		F460		F410		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F497		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		F410		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		F465		F460		F460		F460		F460		F460		F410		F496		F460		F460		F410		F460		F410		F410		F460		F460		F465		F460		F465		F460		F460		F497		F460		F497		F497		F460		F460		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F460
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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		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		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		1		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		1		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
filing_date		2000-10-27 00:00:00		1986-07-29 00:00:00		1986-08-26 00:00:00		1986-07-31 00:00:00		1986-11-13 00:00:00		1987-02-02 00:00:00		1987-02-02 00:00:00		1987-02-02 00:00:00		1987-07-17 00:00:00		1987-07-17 00:00:00		1987-07-31 00:00:00		1989-01-27 00:00:00		1989-08-02 00:00:00		1989-08-18 00:00:00		1989-09-12 00:00:00		1989-10-10 00:00:00		1996-04-12 00:00:00		1996-10-10 00:00:00		1996-10-07 00:00:00		1997-07-31 00:00:00		1997-10-28 00:00:00		1997-10-31 00:00:00		1997-05-20 00:00:00		1997-11-24 00:00:00		1998-07-31 00:00:00		1999-01-21 00:00:00		1999-01-21 00:00:00		1998-07-31 00:00:00		1999-01-21 00:00:00		1999-01-21 00:00:00		1999-01-21 00:00:00		1999-01-21 00:00:00		1999-01-21 00:00:00		1999-04-19 00:00:00		1999-10-21 00:00:00		1999-10-28 00:00:00		1997-01-31 00:00:00		1997-05-29 00:00:00		1998-07-31 00:00:00		1996-10-25 00:00:00		2000-02-24 00:00:00		2000-01-10 00:00:00		2000-01-10 00:00:00		1999-12-09 00:00:00		2000-10-27 00:00:00		2000-09-11 00:00:00		2000-10-31 00:00:00		2000-07-31 00:00:00		2000-10-31 00:00:00		2001-01-31 00:00:00		2000-11-30 00:00:00		2000-10-31 00:00:00		2000-12-04 00:00:00		2000-12-04 00:00:00		2001-01-31 00:00:00		2001-07-31 00:00:00		2001-10-29 00:00:00		2001-10-24 00:00:00		2001-07-31 00:00:00		2001-10-29 00:00:00		2002-01-10 00:00:00		2001-10-29 00:00:00		2001-11-29 00:00:00		2002-01-24 00:00:00		2002-01-24 00:00:00		2001-12-03 00:00:00		2002-01-10 00:00:00		2002-02-21 00:00:00		2002-02-22 00:00:00		2002-03-02 00:00:00		2002-06-14 00:00:00		2002-06-14 00:00:00		2002-06-14 00:00:00		2002-06-14 00:00:00		2002-06-14 00:00:00		2002-06-14 00:00:00		2002-06-14 00:00:00		2002-06-14 00:00:00		2002-07-31 00:00:00		2002-10-23 00:00:00		2002-07-02 00:00:00		2002-07-31 00:00:00		2002-10-24 00:00:00		2002-10-07 00:00:00		2002-10-30 00:00:00		2002-10-04 00:00:00		2002-10-30 00:00:00		2003-01-31 00:00:00		2003-01-30 00:00:00		2003-01-02 00:00:00		2003-10-23 00:00:00		2003-07-30 00:00:00		2003-07-31 00:00:00		2003-12-01 00:00:00		2003-11-25 00:00:00		2004-01-12 00:00:00		2004-01-12 00:00:00		2004-01-22 00:00:00		2003-10-27 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-01-21 00:00:00		2004-02-19 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-19 00:00:00		2004-08-02 00:00:00		2004-08-02 00:00:00		2004-10-27 00:00:00		2004-10-19 00:00:00		2004-10-21 00:00:00		2004-10-05 00:00:00		2004-10-05 00:00:00		2004-10-21 00:00:00		2005-02-01 00:00:00		2005-02-28 00:00:00		2005-08-01 00:00:00		2005-08-01 00:00:00		2005-02-02 00:00:00		2005-09-29 00:00:00		2005-10-27 00:00:00		2005-09-29 00:00:00		2005-10-27 00:00:00		2006-05-25 00:00:00		2006-01-31 00:00:00		2006-03-22 00:00:00		2006-03-22 00:00:00		2006-01-31 00:00:00		2006-05-25 00:00:00		2006-10-05 00:00:00		2006-07-31 00:00:00		2006-07-31 00:00:00		2006-10-05 00:00:00		2006-10-25 00:00:00		2006-10-25 00:00:00		2007-01-31 00:00:00		2007-01-31 00:00:00		2006-10-28 00:00:00		2008-01-24 00:00:00		2008-01-28 00:00:00		2008-01-07 00:00:00		2008-01-24 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2008-01-24 00:00:00		2007-10-25 00:00:00		2007-09-28 00:00:00		2007-09-27 00:00:00		2008-01-09 00:00:00		2013-07-31 00:00:00		2013-07-30 00:00:00		2014-07-31 00:00:00		2014-07-31 00:00:00		2014-07-31 00:00:00		2014-05-23 00:00:00		2014-05-23 00:00:00		2014-05-23 00:00:00		2014-05-21 00:00:00		2014-05-22 00:00:00		2013-10-28 00:00:00		2013-10-28 00:00:00		2013-09-26 00:00:00		2013-09-26 00:00:00		2013-10-24 00:00:00		2013-08-01 00:00:00		2015-02-01 00:00:00		2014-10-23 00:00:00		2015-02-02 00:00:00		2014-07-31 00:00:00		2014-10-06 00:00:00		2014-10-23 00:00:00		2008-03-24 00:00:00		2007-10-29 00:00:00		2007-09-28 00:00:00		2008-04-23 00:00:00		2008-05-22 00:00:00		2008-07-31 00:00:00		2008-03-24 00:00:00		2008-04-24 00:00:00		2008-05-22 00:00:00		2008-07-31 00:00:00		2008-05-29 00:00:00		2008-10-23 00:00:00		2008-10-06 00:00:00		2008-10-06 00:00:00		2008-10-23 00:00:00		2008-10-30 00:00:00		2008-10-30 00:00:00		2009-02-01 00:00:00		2009-02-02 00:00:00		2009-09-28 00:00:00		2009-10-21 00:00:00		2009-10-22 00:00:00		2009-09-24 00:00:00		2009-07-31 00:00:00		2009-07-31 00:00:00		2010-02-01 00:00:00		2010-03-19 00:00:00		2010-01-31 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-07-29 00:00:00		2010-03-22 00:00:00		2010-07-23 00:00:00		2010-07-23 00:00:00		2010-10-05 00:00:00		2010-07-29 00:00:00		2010-10-21 00:00:00		2010-10-21 00:00:00		2010-10-30 00:00:00		2010-10-05 00:00:00		2010-10-30 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-02-02 00:00:00		2011-07-28 00:00:00		2011-09-29 00:00:00		2011-08-01 00:00:00		2011-10-31 00:00:00		2011-11-04 00:00:00		2011-10-03 00:00:00		2011-10-03 00:00:00		2011-09-28 00:00:00		2012-03-19 00:00:00		2012-02-02 00:00:00		2012-03-21 00:00:00		2012-03-22 00:00:00		2011-10-27 00:00:00		2012-05-24 00:00:00		2012-05-24 00:00:00		2014-01-31 00:00:00		2014-01-30 00:00:00		2014-03-19 00:00:00		2012-10-05 00:00:00		2012-07-31 00:00:00		2012-07-31 00:00:00		2012-10-05 00:00:00		2012-10-25 00:00:00		2012-10-25 00:00:00		2014-10-06 00:00:00		2014-07-31 00:00:00		2013-01-29 00:00:00		2014-03-19 00:00:00		2013-01-31 00:00:00		2015-07-30 00:00:00		2015-09-24 00:00:00		2015-09-28 00:00:00		2015-10-27 00:00:00		2015-07-31 00:00:00		2015-09-24 00:00:00		2015-09-25 00:00:00		2017-12-29 00:00:00		2017-12-29 00:00:00		2018-01-08 00:00:00		2016-02-01 00:00:00		2016-02-01 00:00:00		2016-02-01 00:00:00		2015-10-22 00:00:00		2016-02-01 00:00:00		2015-11-02 00:00:00		2016-04-27 00:00:00		2016-05-12 00:00:00		2016-04-27 00:00:00		2016-05-12 00:00:00		2016-06-03 00:00:00		2016-05-26 00:00:00		2016-05-26 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-09-29 00:00:00		2016-10-03 00:00:00		2016-10-27 00:00:00		2016-09-29 00:00:00		2016-10-17 00:00:00		2016-10-26 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-07-29 00:00:00		2018-01-08 00:00:00		2017-07-31 00:00:00
stmnt_type		10005		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		10005		10001		10005		10001		10005		10001		10001		10001		10005		10005		10005		10005		10005		10005		10001		10001		10002		10001		10005		10001		10001		10005		10005		10005		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10001		10002		10005		10005		10001		10005		10005		10001		10001		10005		10005		10001		10005		10001		10005		10001		10001		10005		10005		10005		10001		10001		10002		10002		10001		10001		10005		10005		10005		10001		10005		10001		10001		10005		10001		10005		10005		10001		10005		10005		10001		10005		10005		10005		10001		10001		10005		10005		10005		10001		10001		10001		10001		10005		10001		10005		10005		10001		10005		10001		10005		10002		10006		10001		10001		10001		10005		10005		10001		10006		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10006		10005		10005		10001		10001		10002		10001		10005		10005		10005		10005		10001		10001		10005		10005		10001		10005		10001		10005		10005		10001		10005		10001		10001		10001		10005		10005		10005		10001		10001		10005		10005		10005		10001		10001		10001		10005		10005		10001		10001		10001		10005		10001		10005		10005		10006		10001		10002		10001		10005		10001		10005		10005		10002		10005		10001		10006		10005		10001		10001		10005		10001		10005		10006		10002		10005		10001		10001		10005		10001		10001		10005		10001		10005		10001		10005		10001		10005		10001		10005		10001		10001		10005		10001		10005		10005		10005		10005		10006		10001		10001		10001		10001		10001		10003		10003		10001		10005		10005		10001		10001		10005		10001		10001		10005		10002		10001		10005		10001		10001		10005		10001		10001		10001		10005		10001		10005		10005		10001		10001		10003		10005
stmnt_status		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11003		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11001		11003		11003		11003		11003		11003		11001		11001		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		1999		1985		1985		1985		1985		1985		1985		1985		1985		1985		1985		1987		1989		1989		1989		1989		1995		1995		1995		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1999		1999		1999		1999		1995		1997		1997		1995		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		1999		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2001		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2007		2007		2007		2001		2007		2007		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		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		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2011		2011		2011		2011		2011		2013		2013		2011		2013		2011		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017
user_id		KCHAN		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		GKURIMOT		KCHAN		*		JLEHMAN		*		*		*		GKURIMOT		DHORRELL		DHORRELL		CFLAGG		SARRIAGA		CFLAGG		*		*		TTHAM		*		GPEREZ		*		*		SARRIAGA		CFLAGG		MHOANG		*		DBARRICK		RALLMOND		DBARRICK		DBARRICK		DBARRICK		DBARRICK		DBARRICK		DBARRICK		DBARRICK		DBARRICK		*		*		*		DBARRICK		DBARRICK		*		BSMITH		DBARRICK		*		COMPLETED		GGILMORE		PROBERTS		COMPLETED		KVOONG1		COMPLETED		KLARRY		COMPLETED		COMPLETED		MHOANG		EMCENTEE		GGILMORE		COMPLETED		COMPLETED		COMPLETED		COMPLETED		COMPLETED		COMPLETED		GPEREZ		GPEREZ		KLARRY		COMPLETED		KLARRY		COMPLETED		COMPLETED		LLEONG		COMPLETED		CFLAGG		CFLAGG		COMPLETED		PROBERTS		CFLAGG		*		CFLAGG		CFLAGG		KVANG		*		*		GPEREZ		CFLAGG		SARRIAGA		*		*		*		*		GPEREZ		*		GPEREZ		GPEREZ		*		GPEREZ		*		PBANFORD		*		RGEREMIA		*		*		*		SARRIAGA		SARRIAGA		*		EMCENTEE		*		SARRIAGA		CAFILER		MPACHECO		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		MDIGRAZIA		MDIGRAZIA		TRAMON		MPACHECO		MPACHECO		CAFILER		CAFILER		TRAMON		SARRIAGA		RGEREMIA		SARRIAGA		MPACHECO		JINGRAM		CAFILER		*		GPEREZ		GPEREZ		*		SARRIAGA		CPON		SARRIAGA		CFLAGG		*		CPON		*		*		TMILLER		TMILLER		RGEREMIA		RGEREMIA		DMCCASTL		*		JVAZQUEZ		SARRIAGA		SARRIAGA		MMORENO		*		*		SARRIAGA		MMORENO		MMORENO		MMORENO		MMORENO		MMORENO		MMORENO		MMORENO		MMORENO		GGILMORE		SMCCONNAN		*		SMCCONNAN		SMCCONNAN		CREYNOLDS		SMCCONNAN		MPACHECO		*		SARRIAGA		SARRIAGA		RGEREMIA		SMCCONNAN		MMORENO		SMCCONNAN		MMORENO		PBANFORD		MMORENO		MPACHECO		MMORENO		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MMORENO		MDIGRAZIA		MDIGRAZIA		CAFILER		GGILMORE		CAFILER		MPACHECO		CAFILER		MPACHECO		CAFILER		MPACHECO		CAFILER		CAFILER		MPACHECO		CAFILER		MDIGRAZIA		MPACHECO		MDIGRAZIA		SARRIAGA		TRAMON		GKURIMOT		MDIGRAZIA		SARRIAGA		TRAMON		LBARTHOL		TRAMON		TRAMON		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		SMCCONNAN		SARRIAGA		SARRIAGA		PDEO		SARRIAGA		PDEO		PDEO		SMCCONNAN		SMCCONNAN		SARRIAGA		SARRIAGA		SARRIAGA		GKURIMOT		GPEREZ		SARRIAGA		GKURIMOT		GPEREZ		LPALMER		LPALMER		LBARTHOL		LBARTHOL		LBARTHOL
special_audit		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		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		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		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		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		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		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003
rpt_start		2000-07-01 00:00:00		None		None		1986-01-01 00:00:00		1986-01-01 00:00:00		1986-10-19 00:00:00		1986-07-01 00:00:00		1986-10-01 00:00:00		1986-07-01 00:00:00		1986-10-19 00:00:00		1986-10-01 00:00:00		1988-07-01 00:00:00		None		None		None		None		None		1996-01-01 00:00:00		1996-07-01 00:00:00		1997-01-01 00:00:00		None		None		None		None		1998-05-17 00:00:00		1998-10-01 00:00:00		1998-10-18 00:00:00		None		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-03-18 00:00:00		1998-07-01 00:00:00		None		None		1999-07-01 00:00:00		None		1996-10-20 00:00:00		None		1998-05-17 00:00:00		1996-10-01 00:00:00		2000-01-01 00:00:00		1999-10-17 00:00:00		1999-10-17 00:00:00		None		None		2000-02-20 00:00:00		2000-07-01 00:00:00		2000-02-20 00:00:00		2000-10-31 00:00:00		2000-11-26 00:00:00		2000-10-22 00:00:00		2000-10-31 00:00:00		2000-10-22 00:00:00		2000-10-22 00:00:00		2000-11-26 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		None		2001-11-25 00:00:00		2001-01-01 00:00:00		2001-10-21 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2001-10-21 00:00:00		2001-11-25 00:00:00		2002-01-20 00:00:00		2002-01-20 00:00:00		None		1999-01-01 00:00:00		2000-07-01 00:00:00		2000-10-22 00:00:00		2000-11-26 00:00:00		2000-01-01 00:00:00		1999-10-17 00:00:00		1999-07-01 00:00:00		2002-02-20 00:00:00		2002-02-17 00:00:00		2002-10-01 00:00:00		2000-07-01 00:00:00		2002-02-17 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		None		2002-07-01 00:00:00		2002-10-30 00:00:00		2002-10-20 00:00:00		2002-10-20 00:00:00		1999-01-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-10-19 00:00:00		2003-10-19 00:00:00		2003-11-23 00:00:00		2003-11-23 00:00:00		2004-01-01 00:00:00		2003-07-01 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-01-01 00:00:00		2004-01-18 00:00:00		None		None		2004-01-18 00:00:00		2004-02-15 00:00:00		2004-02-15 00:00:00		2004-10-21 00:00:00		2004-10-01 00:00:00		None		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-17 00:00:00		2001-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2004-10-17 00:00:00		2005-07-01 00:00:00		2005-09-25 00:00:00		2005-07-01 00:00:00		2005-09-25 00:00:00		2006-03-18 00:00:00		2005-10-23 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2005-10-23 00:00:00		2006-03-18 00:00:00		2006-07-01 00:00:00		2006-05-21 00:00:00		2006-05-21 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		2006-10-22 00:00:00		2006-10-22 00:00:00		None		2007-10-21 00:00:00		2007-10-21 00:00:00		2007-10-21 00:00:00		2008-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2007-09-23 00:00:00		None		2007-07-01 00:00:00		2007-10-21 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2014-05-18 00:00:00		2014-05-18 00:00:00		2014-05-18 00:00:00		2014-05-23 00:00:00		2014-05-23 00:00:00		2014-05-23 00:00:00		2014-03-18 00:00:00		2014-03-18 00:00:00		None		2013-09-22 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2013-09-22 00:00:00		None		2014-10-19 00:00:00		2014-10-01 00:00:00		2014-10-19 00:00:00		2014-05-18 00:00:00		2014-07-01 00:00:00		2014-10-01 00:00:00		2008-01-20 00:00:00		2007-09-23 00:00:00		2007-07-01 00:00:00		2008-03-18 00:00:00		2008-04-20 00:00:00		2008-05-18 00:00:00		2008-01-20 00:00:00		2008-03-18 00:00:00		2008-04-20 00:00:00		2008-05-18 00:00:00		2008-05-29 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		None		2008-10-30 00:00:00		2008-10-19 00:00:00		2008-10-19 00:00:00		2009-07-01 00:00:00		2009-09-20 00:00:00		2009-09-20 00:00:00		2009-07-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-10-18 00:00:00		2010-01-01 00:00:00		2009-10-18 00:00:00		2010-03-18 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-05-23 00:00:00		2010-03-18 00:00:00		2010-07-01 00:00:00		2010-03-18 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2010-10-30 00:00:00		2010-07-01 00:00:00		None		2010-10-17 00:00:00		2010-10-17 00:00:00		2010-10-17 00:00:00		None		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-09-25 00:00:00		2011-11-04 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-10-23 00:00:00		2011-10-23 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2011-09-25 00:00:00		2012-03-18 00:00:00		2012-03-18 00:00:00		2013-10-20 00:00:00		2013-10-20 00:00:00		2014-01-01 00:00:00		2012-07-01 00:00:00		2012-05-20 00:00:00		2012-05-20 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		2014-07-01 00:00:00		2014-05-18 00:00:00		2012-10-21 00:00:00		2014-01-01 00:00:00		2012-10-21 00:00:00		2015-01-01 00:00:00		2015-07-01 00:00:00		None		2015-10-27 00:00:00		2015-01-01 00:00:00		2015-07-01 00:00:00		2015-09-25 00:00:00		2017-07-01 00:00:00		2017-12-29 00:00:00		None		2015-10-18 00:00:00		2015-10-18 00:00:00		2015-10-18 00:00:00		2015-09-20 00:00:00		2015-10-18 00:00:00		2015-09-20 00:00:00		2016-01-01 00:00:00		2016-05-12 00:00:00		2016-01-01 00:00:00		2016-05-12 00:00:00		2016-06-03 00:00:00		2016-04-24 00:00:00		2016-04-24 00:00:00		2016-05-22 00:00:00		2016-05-22 00:00:00		2016-07-01 00:00:00		2016-10-03 00:00:00		2016-09-25 00:00:00		2016-07-01 00:00:00		2016-10-17 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		2017-01-01 00:00:00		2017-07-01 00:00:00		2017-01-01 00:00:00
rpt_end		2000-10-21 00:00:00		None		None		1986-06-30 00:00:00		1986-06-30 00:00:00		1986-12-31 00:00:00		1986-09-30 00:00:00		1986-10-18 00:00:00		1986-09-30 00:00:00		1986-12-31 00:00:00		1986-10-18 00:00:00		1988-10-22 00:00:00		None		None		None		None		None		1996-06-30 00:00:00		1996-09-30 00:00:00		1997-06-30 00:00:00		None		None		None		None		1998-06-30 00:00:00		1998-10-17 00:00:00		1998-12-31 00:00:00		None		1997-12-31 00:00:00		1998-06-30 00:00:00		1998-05-16 00:00:00		1998-09-30 00:00:00		None		None		1999-10-16 00:00:00		None		1996-12-31 00:00:00		None		1998-06-30 00:00:00		1996-10-19 00:00:00		2000-02-19 00:00:00		1999-12-31 00:00:00		1999-12-31 00:00:00		None		None		2000-06-30 00:00:00		2000-10-21 00:00:00		2000-06-30 00:00:00		2000-10-31 00:00:00		2000-12-31 00:00:00		2000-11-25 00:00:00		2000-10-31 00:00:00		2000-11-25 00:00:00		2000-11-25 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-10-20 00:00:00		2001-10-20 00:00:00		2001-06-30 00:00:00		None		2001-12-31 00:00:00		2001-06-30 00:00:00		2001-11-24 00:00:00		2002-01-19 00:00:00		2002-01-19 00:00:00		2001-11-24 00:00:00		2001-12-31 00:00:00		2002-02-16 00:00:00		2002-02-16 00:00:00		None		1999-06-30 00:00:00		2000-10-21 00:00:00		2000-11-25 00:00:00		2000-12-31 00:00:00		2000-02-19 00:00:00		1999-12-31 00:00:00		1999-10-16 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-10-19 00:00:00		2000-09-30 00:00:00		2002-06-30 00:00:00		2002-10-19 00:00:00		2002-09-30 00:00:00		None		2002-09-30 00:00:00		2002-10-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2000-12-31 00:00:00		2003-10-18 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-11-22 00:00:00		2003-11-22 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-01-17 00:00:00		2003-10-18 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-01-17 00:00:00		2004-02-14 00:00:00		None		None		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-10-21 00:00:00		2004-10-16 00:00:00		None		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-10-16 00:00:00		2004-12-31 00:00:00		2002-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-09-24 00:00:00		2005-10-22 00:00:00		2005-09-24 00:00:00		2005-10-22 00:00:00		2006-05-20 00:00:00		2005-12-31 00:00:00		2006-03-17 00:00:00		2006-03-17 00:00:00		2005-12-31 00:00:00		2006-05-20 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-10-21 00:00:00		2006-10-21 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		None		2007-12-31 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-01-19 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2008-01-19 00:00:00		2007-10-20 00:00:00		None		2007-09-22 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2014-05-23 00:00:00		2014-05-23 00:00:00		2014-05-23 00:00:00		2014-05-17 00:00:00		2014-05-17 00:00:00		None		2013-10-19 00:00:00		2013-09-21 00:00:00		2013-09-21 00:00:00		2013-10-19 00:00:00		None		2014-12-31 00:00:00		2014-10-18 00:00:00		2014-12-31 00:00:00		2014-06-30 00:00:00		2014-09-30 00:00:00		2014-10-18 00:00:00		2008-03-17 00:00:00		2007-10-20 00:00:00		2007-09-22 00:00:00		2008-04-19 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		2008-03-17 00:00:00		2008-04-19 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		2008-05-29 00:00:00		2008-10-18 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		None		2008-10-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-09-19 00:00:00		2009-10-17 00:00:00		2009-10-17 00:00:00		2009-09-19 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-03-17 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-03-17 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-09-30 00:00:00		2010-05-22 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		2010-10-30 00:00:00		2010-09-30 00:00:00		None		2010-12-31 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		None		2011-06-30 00:00:00		2011-09-24 00:00:00		2011-06-30 00:00:00		2011-10-22 00:00:00		2011-11-04 00:00:00		2011-09-24 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2011-10-22 00:00:00		2012-05-19 00:00:00		2012-05-19 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2014-03-17 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2012-10-20 00:00:00		2012-10-20 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2014-03-17 00:00:00		2012-12-31 00:00:00		2015-06-30 00:00:00		2015-09-19 00:00:00		None		2015-10-27 00:00:00		2015-06-30 00:00:00		2015-09-19 00:00:00		2015-09-25 00:00:00		2017-12-13 00:00:00		2017-12-29 00:00:00		None		2015-12-31 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2015-10-17 00:00:00		2015-12-31 00:00:00		2015-10-17 00:00:00		2016-04-23 00:00:00		2016-05-12 00:00:00		2016-04-23 00:00:00		2016-05-12 00:00:00		2016-06-03 00:00:00		2016-05-21 00:00:00		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-09-24 00:00:00		2016-10-03 00:00:00		2016-10-22 00:00:00		2016-09-24 00:00:00		2016-10-17 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-12-13 00:00:00		2017-06-30 00:00:00
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		2000-10-27 00:00:00		None		2000-10-31 00:00:00		None		2000-10-31 00:00:00		2001-01-31 00:00:00		2000-11-30 00:00:00		None		None		None		None		None		None		2001-10-25 00:00:00		2001-07-31 00:00:00		None		2002-01-10 00:00:00		None		2001-11-29 00:00:00		2002-01-24 00:00:00		None		None		None		0200-02-21 00:00:00		None		None		None		None		None		None		None		None		None		None		2002-07-31 00:00:00		2002-10-23 00:00:00		2002-06-20 00:00:00		None		None		2002-10-07 00:00:00		None		None		2002-10-30 00:00:00		2003-01-31 00:00:00		None		None		2003-10-23 00:00:00		None		2003-07-31 00:00:00		None		2003-11-25 00:00:00		2004-01-12 00:00:00		None		None		None		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-01-21 00:00:00		2004-02-19 00:00:00		None		None		None		2004-08-02 00:00:00		None		2004-10-21 00:00:00		2004-10-19 00:00:00		None		2004-10-05 00:00:00		None		None		2005-02-01 00:00:00		None		None		2005-08-01 00:00:00		None		None		None		2005-09-29 00:00:00		2005-10-27 00:00:00		None		None		None		2006-03-22 00:00:00		2006-01-26 00:00:00		2006-05-25 00:00:00		2006-10-05 00:00:00		None		2006-07-31 00:00:00		None		None		2006-10-25 00:00:00		None		2007-01-31 00:00:00		None		2008-01-24 00:00:00		None		2008-01-07 00:00:00		2008-01-24 00:00:00		2007-07-31 00:00:00		None		None		2007-10-25 00:00:00		None		2007-09-27 00:00:00		None		2013-07-31 00:00:00		None		2014-07-31 00:00:00		2014-07-31 00:00:00		2014-07-31 00:00:00		2014-05-23 00:00:00		2014-05-23 00:00:00		2014-05-23 00:00:00		None		2014-05-22 00:00:00		None		None		None		2013-09-26 00:00:00		2013-10-24 00:00:00		None		2015-02-01 00:00:00		None		None		None		None		2014-10-23 00:00:00		2008-03-24 00:00:00		None		None		2008-04-23 00:00:00		None		2008-07-31 00:00:00		None		None		2008-05-22 00:00:00		None		2008-05-29 00:00:00		2008-10-23 00:00:00		2008-10-06 00:00:00		None		None		None		2008-10-30 00:00:00		2009-02-01 00:00:00		None		None		None		2009-10-22 00:00:00		2009-09-24 00:00:00		2009-07-31 00:00:00		None		None		2010-03-19 00:00:00		2010-02-01 00:00:00		2010-05-27 00:00:00		None		2010-07-29 00:00:00		None		None		None		2010-10-05 00:00:00		2010-07-28 00:00:00		2010-10-21 00:00:00		None		2010-10-30 00:00:00		None		None		2011-01-31 00:00:00		None		2011-01-31 00:00:00		None		None		2011-09-26 00:00:00		2011-08-01 00:00:00		None		2011-11-04 00:00:00		None		None		2011-09-26 00:00:00		None		2012-02-02 00:00:00		2012-03-21 00:00:00		None		2011-10-27 00:00:00		2012-05-24 00:00:00		None		2014-01-31 00:00:00		None		2014-03-19 00:00:00		None		2012-07-31 00:00:00		None		2012-10-05 00:00:00		None		2012-10-25 00:00:00		2014-10-06 00:00:00		None		2013-01-29 00:00:00		None		None		None		None		None		2015-10-27 00:00:00		2015-07-31 00:00:00		2015-09-24 00:00:00		None		2017-12-26 00:00:00		None		None		2016-01-28 00:00:00		None		None		2015-10-22 00:00:00		2016-01-28 00:00:00		None		2016-04-27 00:00:00		2016-05-12 00:00:00		None		2016-05-12 00:00:00		2016-06-03 00:00:00		None		2016-05-24 00:00:00		2016-08-01 00:00:00		None		2016-09-29 00:00:00		2016-10-03 00:00:00		2016-10-27 00:00:00		None		2016-10-17 00:00:00		None		None		2017-01-31 00:00:00		2017-07-29 00:00:00		None		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		22001		None		None		22001		None		22001		None		22001		22001		None		None		None		22001		22001		22001		22001		22001		22001		None		None		None		22001		None		22001		22001		None		22001		None		None		22001		None		None		22001		None		None		None		22001		22001		None		None		None		22001		22001		22001		22001		None		22001		None		None		22001		None		22001		None		22001		None		22001		22001		22001		None		None		22001		None		22001		None		22001		None		22001		22001		22001		22001		22001		22001		None		22001		None		None		None		22001		22001		None		22001		None		None		None		None		22001		22001		None		None		22001		None		22001		None		None		22001		None		22001		22001		22001		None		None		None		22001		22001		None		None		None		22001		22001		22001		None		None		22001		22001		22001		None		22001		None		None		None		22001		22001		22001		None		22001		None		None		22001		None		22001		None		None		22001		22001		None		22001		None		None		22001		None		22001		22001		None		22001		22001		None		22001		None		22001		None		22001		None		22001		None		22001		22001		None		22001		None		None		None		None		None		22001		22001		22001		22001		22001		22001		None		22001		None		None		22001		22001		None		22001		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		None		22001		None		None		22001		22001		None		None

Table: filer_to_filer_type

filer_id		1042246		1042246		1042246
filer_type		16		16		16
active		Y		Y		T
race		0		0		0
session_id		1985		2013		2017
category		0		0		0
category_type		40502		40502		40502
sub_category		40103		40103		40103
effect_dt		1990-12-01 00:00:00		2013-08-01 00:00:00		2017-12-13 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		S		S		S
nyq_dt		1986-07-29 00:00:00		1986-07-29 00:00:00		1986-07-29 00:00:00
party_cd		None		None		None
county_cd		18043		18043		18043
district_cd		None		None		None

Table: filer_xref

filer_id		1042246
xref_id		861576
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		861576		861576		861576		861576
filer_id		1042246		1042246		1042246		1042246
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED		TERMINATED		TERMINATED
effect_dt		2017-12-13 00:00:00		2017-12-13 00:00:00		2017-12-13 00:00:00		2017-12-13 00:00:00
naml		RESIDENTIAL BUILDERS ASSOCIATION OF SAN FRANCISCO POLITICAL ACTION COMMITTEE		RESIDENTIAL BUILDERS ASSOCIATION OF SAN FRANCISCO POLITICAL ACTION COMMITTEE		RESIDENTIAL BUILDERS ASSOCIATION OF SAN FRANCISCO POLITICAL ACTION COMMITTEE		RESIDENTIAL BUILDERS ASSOCIATION OF SAN FRANCISCO POLITICAL ACTION COMMITTEE
namf		None		None		None		None
namt		None		None		None		None
nams		None		None		None		None
adr1		None		None		None		None
adr2		None		None		None		None
city		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO
st		CA		CA		CA		CA
zip4		941030000		941030000		941030000		94103
phon		4152521900		4152521900		4152521900		4152521900
fax		None		None		None		None
email		None		None		[email protected]		[email protected]

Table: filers

filer_id		1042246

Table: received_filings

filer_id		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246		1042246
filing_file_name		682592_0.cal		28818.cal		682749_0.cal		17425.cal		1718.cal		690877_0.cal		26684.cal		27422.cal		719172_0.cal		773179_0.cal		17587.cal		789018_0.cal		799282_0.cal		805473_0.cal		810061_0.cal		822464_0.cal		448186.cal		448238.cal		469226.cal		682592_1.cal		469367.cal		469339.cal		469969.cal		470048.cal		470074.cal		470167.cal		277763.cal		282738.cal		856918_0.cal		206566.cal		871843_0.cal		204818.cal		271474.cal		280487.cal		877249_0.cal		883328_0.cal		912836_0.cal		948067_0.cal		973132_0.cal		966510_0.cal		980195_0.cal		998920_0.cal		334421.cal		998920_1.cal		1377083_0.cal		510916.cal		510652.cal		1678064_0.cal		1830647_0.cal		1792170_0.cal		1783680_0.cal		1539683_0.cal		1703603_0.cal		1694814_0.cal		1818172_0.cal		1607687_1.cal		366983.cal		1615801_0.cal		1624159_0.cal		1797043_0.cal		1638975_0.cal		1620539_0.cal		1646734_0.cal		1663511_0.cal		1853900_0.cal		1870782_0.cal		1855063_0.cal		1989511_0.cal		155848.cal		155879.cal		1989569_0.cal		167085.cal		168955.cal		30728.cal		2174534_0.cal		2130154_0.cal		2046786_0.cal		2049315_0.cal		1993342_0.cal		98910.cal		2012227_0.cal		2083052_0.cal		1893266_0.cal		2090044_0.cal		2097957_0.cal		1904288_0.cal		2084503_0.cal		2063621_0.cal		2042284_0.cal		238497.cal		238524.cal		2042284_1.cal		2033574_0.cal		1935685_0.cal		1983011_0.cal
received_date		2000-10-31 00:00:00		2000-10-31 00:00:00		2000-10-31 00:00:00		2000-10-31 00:00:00		2000-11-30 00:00:00		2000-11-30 00:00:00		2000-10-31 00:00:00		2000-10-31 00:00:00		2001-01-31 00:00:00		2001-07-31 00:00:00		2001-10-24 00:00:00		2001-10-24 00:00:00		2001-11-29 00:00:00		2002-01-10 00:00:00		2002-01-24 00:00:00		2002-02-21 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-07-02 00:00:00		2002-07-02 00:00:00		2002-07-02 00:00:00		2002-07-02 00:00:00		2002-07-02 00:00:00		2002-07-02 00:00:00		2002-07-02 00:00:00		2002-07-02 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2002-10-07 00:00:00		2002-10-07 00:00:00		2002-10-07 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2002-10-23 00:00:00		2002-10-30 00:00:00		2003-01-31 00:00:00		2003-07-31 00:00:00		2003-11-25 00:00:00		2003-10-23 00:00:00		2004-01-12 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2004-02-21 00:00:00		2008-10-30 00:00:00		2008-01-24 00:00:00		2008-01-24 00:00:00		2012-07-31 00:00:00		2014-03-19 00:00:00		2013-09-26 00:00:00		2013-07-31 00:00:00		2010-10-30 00:00:00		2012-10-25 00:00:00		2012-10-05 00:00:00		2014-01-31 00:00:00		2011-09-28 00:00:00		2011-09-28 00:00:00		2011-09-29 00:00:00		2011-11-04 00:00:00		2013-10-24 00:00:00		2012-02-02 00:00:00		2011-10-27 00:00:00		2012-03-21 00:00:00		2012-05-24 00:00:00		2014-05-22 00:00:00		2014-07-31 00:00:00		2014-05-23 00:00:00		2015-09-24 00:00:00		2015-09-24 00:00:00		2015-09-24 00:00:00		2015-09-25 00:00:00		2015-09-25 00:00:00		2015-09-25 00:00:00		2017-07-29 00:00:00		2017-07-29 00:00:00		2017-01-31 00:00:00		2016-05-26 00:00:00		2016-06-03 00:00:00		2015-10-22 00:00:00		2015-10-27 00:00:00		2016-02-01 00:00:00		2016-09-29 00:00:00		2014-10-06 00:00:00		2016-10-17 00:00:00		2016-10-27 00:00:00		2014-10-23 00:00:00		2016-10-03 00:00:00		2016-08-01 00:00:00		2016-05-12 00:00:00		2016-05-12 00:00:00		2016-05-12 00:00:00		2016-05-12 00:00:00		2016-04-27 00:00:00		2015-02-01 00:00:00		2015-07-31 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/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/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/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/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/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/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		682592		None		682749		None		None		690877		None		None		719172		773179		None		789018		799282		805473		810061		822464		None		None		None		682592		None		None		None		None		None		None		None		None		856918		None		871843		None		None		None		877249		883328		912836		948067		973132		966510		980195		998920		None		998920		1377083		None		None		1678064		1830647		1792170		1783680		1539683		1703603		1694814		1818172		1607687		None		1615801		1624159		1797043		1638975		1620539		1646734		1663511		1853900		1870782		1855063		1989511		None		None		1989569		None		None		None		2174534		2130154		2046786		2049315		1993342		None		2012227		2083052		1893266		2090044		2097957		1904288		2084503		2063621		2042284		None		None		2042284		2033574		1935685		1983011
form_id		F460		None		F497		None		None		F460		None		None		F460		F460		None		F460		F460		F460		F460		F460		None		None		None		F460		None		None		None		None		None		None		None		None		F460		None		F460		None		None		None		F460		F497		F460		F460		F460		F460		F460		F497		None		F497		F497		None		None		F460		F460		F460		F460		F497		F460		F460		F460		F460		None		F460		F497		F460		F460		F460		F460		F460		F460		F460		F497		F460		None		None		F410		None		None		None		F460		F460		F460		F497		F460		None		F460		F460		F460		F497		F460		F460		F497		F460		F497		None		None		F497		F460		F460		F460
receive_comment		Filing accepted, but with warnings		Filing pass validation, but failed DB constraints		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		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 passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted		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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		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 accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted