Home

Filer ID: 1029815

Table: filer_acronyms

acronym		OCBC
filer_id		1029815

Table: filer_address

filer_id		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815
adrid		1027941		1027942		2105928		2230752		2230753		2287162		2485529		2485528		2524600		2524601		2325677		2325676
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		2006-06-28 00:00:00		2012-05-16 00:00:00		2012-05-16 00:00:00		2013-02-01 00:00:00		2019-08-26 00:00:00		2019-08-26 00:00:00		2021-10-04 00:00:00		2021-10-04 00:00:00		2014-08-04 00:00:00		2014-08-04 00:00:00
add_type		7051		7051		7051		7082		7051		7082		7082		7051		7051		7082		7051		7082
session_id		1979		1979		2005		2011		2011		2013		2019		2019		2021		2021		2013		2013

Table: filer_filings

filer_id		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815
filing_id		680324		178557		178558		178559		178560		178561		178562		178563		178564		178565		178566		178567		178568		178570		219735		219736		219737		219738		219739		219740		219741		219742		219743		219744		219745		219746		178482		178483		178484		178485		178486		178487		178488		178489		178490		178491		178492		178493		178494		178495		178496		178497		178498		178499		178500		178501		178502		178503		178504		178505		178506		178507		178508		178509		178510		178511		178513		178514		178515		178516		178518		178519		178520		178521		178522		178523		178524		178525		178526		178527		178528		178529		178530		178531		178532		178533		178534		178535		178536		178537		178538		178539		178540		178541		178542		178544		178545		178546		178547		178548		178549		178550		178551		178552		178553		178554		178555		178556		586174		592206		178512		178517		178543		178569		673823		646073		724362		782524		816834		881662		850493		871794		917338		951859		1001331		991693		1045893		1030564		1053834		1119670		1134745		1088128		1147397		1183751		1186170		1187136		1198005		1230360		1224469		1281394		1277017		1277017		1777978		1854132		1858056		1858269		1401749		1935461		1948007		1401749		1893185		1898433		1898384		1897749		1904371		1281394		1304180		1304180		1343672		1342174		1363528		1363528		1373127		1367675		1401749		1409000		1397569		1416542		1430857		1430857		1428558		1459377		1452796		1428558		1459377		1457170		1457170		1492282		1497453		1493783		1493797		1492996		1493064		1492996		1514359		1497453		1401749		1492282		1492996		1497453		1582744		1608062		1401749		1611159		1612548		1646681		1648804		1636813		1640618		1661737		1646681		1401749		1663708		1648804		1663708		1825204		1828150		1815700		1665913		1695007		1698040		1665913		1674696		1681107		1401749		1917166		1915497		1710981		1711219		1703837		1708865		1888504		1889936		1869869		1888731		1890468		1874371		1885263		1734433		1840673		1757134		1749770		2498365		2434314		2525853		2508611		2359583		2408939		1401749		2452044		2135568		2402372		2495830		2508611		2365580		2398072		2495830		2402372		2398072		1401749		2524993		2441790		2505042		2441790		2253275		1401749		2429975		2485295		2361155		2452044		2446464		2485295		2624527		2650307		2434314		2505042		2520503		2446464		2673238		2686917		2630265		2562248		2553041		2673238		2520503		2553041		2562248		1401749		2643039		2689294		2614086		2717915		2602088		2624527		2690929		2654938		2689294		2710189		1401749		2681819		2602088		2706360		2742906		2743883		2735198		2725666		2731934		2727124
period_id		None		145		147		148		148		148		149		151		153		154		155		156		156		157		97		97		101		105		108		120		121		121		140		143		145		148		83		83		85		87		89		89		90		91		91		92		93		92		95		95		93		98		99		101		101		103		103		105		105		106		107		108		108		109		109		112		113		113		113		114		116		117		116		113		116		119		117		119		119		120		122		123		124		121		128		121		124		125		127		129		129		130		131		132		132		133		135		137		137		138		139		140		141		142		144		143		145		145		None		None		111		115		134		156		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		185		None		None		None		None		187		None		189		189		213		217		None		218		219		220		None		220		219		220		None		None		220		None		191		191		None		193		195		195		None		196		197		None		196		None		None		None		197		None		200		197		None		199		199		202		None		None		None		201		202		201		None		None		203		202		201		None		None		205		207		None		None		209		None		207		None		None		209		210		209		None		209		None		None		215		None		211		None		None		210		None		212		220		None		None		212		212		None		219		219		218		None		220		None		219		212		218		None		None		243		241		244		None		237		None		237		None		None		None		None		None		None		237		None		None		237		239		None		239		243		239		None		237		241		241		None		None		None		241		None		None		241		243		243		None		249		250		None		None		244		249		243		244		None		249		247		None		None		251		245		None		None		None		None		251		247		250		245		250		251		252		252		251		None		252
form_id		F460		F420		F420		F420		F497		F420		F420		F420		F420		F420		F420		F420		F497		F420		F405		F420		F420		F405		F405		F777		F420		F405		F420		F405		F420		F497		F410		F420		F420		F420		F420		F405		F420		F420		F420		F420		F405		F405		F420		F420		F420		F420		F420		F405		F405		F420		F420		F420		F420		F420		F420		F420		F420		F405		F420		F405		F420		F420		F405		F420		F420		F405		F420		F405		F405		F405		F420		F405		F420		F420		F420		F420		F420		F405		F420		F405		F420		F420		F420		F405		F420		F420		F420		F420		F420		F420		F420		F405		F420		F420		F420		F420		F420		F420		F405		F420		F405		F465		F460		F460		F420		F420		F405		F420		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F410		F460		F460		F410		F460		F497		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F497		F460		F497		F497		F460		F497		F460		F410		F460		F410		F497		F460		F460		F410		F460		F410		F460		F410		F460		F460		F460		F460		F410		F460		F410		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F410		F497		F460		F460		F496		F460		F410		F497		F497		F460		F460		F497		F410		F497		F460		F497		F410		F460		F497		F460		F497		F460		F497		F410		F410		F460		F410		F460		F460		F460		F410		F460		F460		F460		F460		F410		F460		F460		F460		F460		F410		F410		F497		F460		F410		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F410		F497		F460		F460		F460		F460		F460		F497		F410		F497		F460		F460		F460		F497		F497		F460		F460		F497
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		1		0		0		0		0		5		0		0		6		0		0		0		0		0		1		0		1		0		0		0		1		0		0		0		0		0		0		0		1		1		0		0		0		1		1		0		0		0		0		0		0		0		2		0		1		1		1		1		2		0		0		2		0		0		0		0		0		0		0		1		3		0		1		1		0		0		0		0		0		0		1		0		0		4		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		7		0		0		0		0		0		0		0		1		1		1		9		0		0		0		1		0		8		0		0		0		1		1		1		0		0		1		1		0		0		1		0		0		1		0		0		1		1		0		11		0		0		0		0		1		1		0		0		1		0		10		0		0		0		0		0		0		0		0		0
filing_date		2000-10-27 00:00:00		1996-07-31 00:00:00		1996-10-07 00:00:00		1996-10-25 00:00:00		1996-11-01 00:00:00		1997-01-31 00:00:00		1997-07-29 00:00:00		1998-01-30 00:00:00		1998-05-22 00:00:00		1998-07-27 00:00:00		1998-10-05 00:00:00		1998-10-21 00:00:00		1998-10-29 00:00:00		1999-08-02 00:00:00		1984-02-07 00:00:00		1984-05-23 00:00:00		1985-07-30 00:00:00		1986-01-17 00:00:00		1989-02-07 00:00:00		1989-11-01 00:00:00		1990-05-24 00:00:00		1990-11-19 00:00:00		1994-10-27 00:00:00		1995-09-27 00:00:00		1996-03-14 00:00:00		1996-10-24 00:00:00		1980-08-18 00:00:00		1981-01-29 00:00:00		1981-07-31 00:00:00		1982-02-01 00:00:00		1982-05-28 00:00:00		1982-06-01 00:00:00		1982-07-30 00:00:00		1982-09-22 00:00:00		1982-10-21 00:00:00		1983-01-31 00:00:00		1983-02-03 00:00:00		1983-04-22 00:00:00		1984-02-03 00:00:00		1984-02-03 00:00:00		1984-02-03 00:00:00		1984-07-30 00:00:00		1985-01-31 00:00:00		1985-03-05 00:00:00		1985-09-13 00:00:00		1985-09-27 00:00:00		1986-01-29 00:00:00		1986-03-21 00:00:00		1986-05-22 00:00:00		1986-07-28 00:00:00		1986-10-03 00:00:00		1986-10-23 00:00:00		1987-02-03 00:00:00		1987-02-03 00:00:00		1987-07-30 00:00:00		1987-12-22 00:00:00		1988-03-21 00:00:00		1988-05-25 00:00:00		1988-06-17 00:00:00		1988-07-29 00:00:00		1988-10-27 00:00:00		1989-01-13 00:00:00		1989-01-30 00:00:00		1989-02-07 00:00:00		1989-02-07 00:00:00		1989-07-05 00:00:00		1989-07-28 00:00:00		1989-11-08 00:00:00		1989-10-31 00:00:00		1990-01-30 00:00:00		1990-07-30 00:00:00		1990-10-15 00:00:00		1990-10-26 00:00:00		1990-10-15 00:00:00		1990-01-10 00:00:00		1990-01-14 00:00:00		1991-01-10 00:00:00		1991-07-25 00:00:00		1992-01-27 00:00:00		1992-01-27 00:00:00		1992-05-20 00:00:00		1992-07-27 00:00:00		1992-10-05 00:00:00		1992-10-22 00:00:00		1993-01-30 00:00:00		1993-07-30 00:00:00		1994-01-31 00:00:00		1994-02-23 00:00:00		1994-05-26 00:00:00		1994-08-01 00:00:00		1994-10-04 00:00:00		1995-01-25 00:00:00		1995-06-19 00:00:00		1995-07-31 00:00:00		1995-12-14 00:00:00		1996-01-22 00:00:00		1996-01-26 00:00:00		1996-03-16 00:00:00		2000-01-31 00:00:00		2000-02-24 00:00:00		1988-01-29 00:00:00		1988-10-05 00:00:00		1993-04-05 00:00:00		1999-02-01 00:00:00		2000-10-06 00:00:00		2000-07-31 00:00:00		2001-01-30 00:00:00		2001-07-31 00:00:00		2002-01-31 00:00:00		2002-10-23 00:00:00		2002-07-16 00:00:00		2002-10-07 00:00:00		2003-01-30 00:00:00		2003-07-28 00:00:00		2004-02-19 00:00:00		2004-02-02 00:00:00		2004-10-05 00:00:00		2004-07-30 00:00:00		2004-10-20 00:00:00		2005-07-29 00:00:00		2005-10-28 00:00:00		2005-01-31 00:00:00		2006-01-27 00:00:00		2006-07-12 00:00:00		2006-07-17 00:00:00		2006-06-28 00:00:00		2006-08-24 00:00:00		2006-12-28 00:00:00		2006-12-22 00:00:00		2007-07-18 00:00:00		2007-07-11 00:00:00		2007-07-12 00:00:00		2013-07-24 00:00:00		2014-05-22 00:00:00		2014-05-22 00:00:00		2014-06-03 00:00:00		2014-07-29 00:00:00		2015-01-31 00:00:00		2015-02-02 00:00:00		2014-10-06 00:00:00		2014-10-06 00:00:00		2014-10-15 00:00:00		2014-10-08 00:00:00		2014-10-06 00:00:00		2014-10-23 00:00:00		2008-02-05 00:00:00		2008-01-17 00:00:00		2008-01-18 00:00:00		2008-07-15 00:00:00		2008-07-07 00:00:00		2008-10-06 00:00:00		2008-10-07 00:00:00		2008-10-21 00:00:00		2008-10-20 00:00:00		2009-02-10 00:00:00		2009-02-02 00:00:00		2009-02-02 00:00:00		2008-10-14 00:00:00		2009-07-13 00:00:00		2009-07-13 00:00:00		2009-07-02 00:00:00		2010-01-15 00:00:00		2009-11-02 00:00:00		2009-07-01 00:00:00		2010-01-15 00:00:00		2010-01-11 00:00:00		2010-01-10 00:00:00		2010-05-28 00:00:00		2010-06-01 00:00:00		2010-05-28 00:00:00		2010-06-01 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-10-05 00:00:00		2010-08-02 00:00:00		2010-06-03 00:00:00		2010-07-30 00:00:00		2010-06-01 00:00:00		2010-06-01 00:00:00		2010-10-07 00:00:00		2011-02-02 00:00:00		2011-08-01 00:00:00		2011-08-01 00:00:00		2011-08-01 00:00:00		2011-08-03 00:00:00		2012-03-21 00:00:00		2012-03-22 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-05-16 00:00:00		2012-05-24 00:00:00		2012-05-14 00:00:00		2012-05-24 00:00:00		2012-05-29 00:00:00		2012-06-13 00:00:00		2014-01-30 00:00:00		2014-02-03 00:00:00		2014-01-29 00:00:00		2012-05-24 00:00:00		2012-10-05 00:00:00		2012-10-05 00:00:00		2012-06-18 00:00:00		2012-07-25 00:00:00		2012-07-30 00:00:00		2012-10-05 00:00:00		2014-12-05 00:00:00		2014-10-23 00:00:00		2012-10-25 00:00:00		2012-11-01 00:00:00		2012-10-25 00:00:00		2012-10-09 00:00:00		2014-09-25 00:00:00		2014-09-30 00:00:00		2014-07-30 00:00:00		2014-07-31 00:00:00		2014-10-01 00:00:00		2014-08-04 00:00:00		2014-09-15 00:00:00		2013-01-29 00:00:00		2014-04-23 00:00:00		2013-02-01 00:00:00		2013-01-31 00:00:00		2020-09-03 00:00:00		2020-01-23 00:00:00		2020-10-28 00:00:00		2020-10-23 00:00:00		2019-02-15 00:00:00		2019-08-26 00:00:00		2019-02-04 00:00:00		2020-01-23 00:00:00		2017-02-02 00:00:00		2019-07-31 00:00:00		2020-07-31 00:00:00		2020-09-25 00:00:00		2019-02-20 00:00:00		2019-07-31 00:00:00		2020-08-14 00:00:00		2019-08-19 00:00:00		2019-08-12 00:00:00		2019-08-21 00:00:00		2020-10-23 00:00:00		2020-01-31 00:00:00		2020-09-24 00:00:00		2020-02-21 00:00:00		2018-05-18 00:00:00		2019-02-15 00:00:00		2020-01-13 00:00:00		2020-07-31 00:00:00		2019-02-06 00:00:00		2020-02-26 00:00:00		2020-02-26 00:00:00		2020-08-14 00:00:00		2021-08-01 00:00:00		2022-02-14 00:00:00		2020-02-21 00:00:00		2020-10-22 00:00:00		2020-10-22 00:00:00		2020-01-31 00:00:00		2022-05-26 00:00:00		2022-05-26 00:00:00		2021-02-24 00:00:00		2021-02-24 00:00:00		2021-02-01 00:00:00		2022-04-28 00:00:00		2021-02-19 00:00:00		2021-02-19 00:00:00		2021-02-01 00:00:00		2022-02-11 00:00:00		2022-01-31 00:00:00		2022-04-29 00:00:00		2021-10-04 00:00:00		2022-09-07 00:00:00		2021-08-13 00:00:00		2021-08-16 00:00:00		2022-05-26 00:00:00		2022-01-31 00:00:00		2022-05-27 00:00:00		2022-08-11 00:00:00		2021-09-30 00:00:00		2022-05-12 00:00:00		2021-08-01 00:00:00		2022-08-01 00:00:00		2022-10-27 00:00:00		2022-10-27 00:00:00		2022-10-17 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-30 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		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		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10005		10006		10005		10005		10001		10005		10001		10002		10001		10001		10005		10001		10002		10001		10005		10002		10001		10001		10006		10005		10001		10006		10001		10002		10005		10001		10001		10002		10005		10001		10001		10005		10001		10005		10005		10006		10002		10005		10001		10001		10006		10002		10001		10001		10005		10005		10006		10001		10001		10002		10006		10006		10002		10002		10002		10006		10006		10001		10002		10005		10006		10001		10005		10001		10005		10006		10002		10002		10001		10006		10002		10005		10006		10001		10005		10001		10005		10006		10001		10005		10002		10001		10005		10005		10001		10001		10006		10001		10001		10001		10005		10001		10006		10001		10001		10001		10002		10005		10001		10001		10001		10006		10001		10006		10002		10005		10006		10005		10005		10005		10006		10001		10006		10006		10002		10002		10005		10001		10001		10002		10006		10002		10001		10001		10006		10006		10006		10002		10005		10006		10002		10002		10001		10005		10002		10001		10006		10006		10001		10001		10002		10002		10005		10002		10001		10005		10006		10001		10002		10006		10005		10005		10006		10001		10002		10001		10001		10001		10001		10001		10001		10001		10005		10001
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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003
session_id		1999		1995		1995		1995		1995		1995		1997		1997		1997		1997		1997		1997		1997		1999		1983		1983		1985		1985		1985		1989		1989		1989		1993		1995		1995		1995		1979		1979		1981		1981		1981		1981		1981		1981		1981		1981		1983		1981		1983		1983		1983		1983		1983		1985		1985		1985		1985		1985		1985		1985		1985		1985		1985		1987		1987		1987		1987		1987		1987		1987		1987		1989		1987		1987		1987		1989		1989		1989		1989		1989		1989		1989		1989		1989		1991		1989		1989		1991		1991		1991		1991		1991		1991		1991		1991		1993		1993		1993		1993		1993		1993		1993		1995		1995		1995		1995		1995		1995		1999		1999		1987		1987		1993		1997		1999		1999		1999		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		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		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2011		2011		2011		2011		2011		2011		2013		2013		2011		2011		2011		2011		2013		2013		2013		2013		2013		2013		2013		2011		2013		2013		2011		2019		2019		2019		2019		2019		2019		2019		2019		2017		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2017		2019		2019		2019		2019		2019		2019		2019		2021		2021		2019		2019		2019		2019		2021		2021		2019		2019		2019		2021		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		KCHAN		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		KCHAN		JLEHMAN		TWALLS		GPEREZ		SARRIAGA		DBARRICK		DHORRELL		DBARRICK		DBARRICK		KVOONG1		KLARRY		EMCENTEE		GKURIMOT		TTHAM		GKURIMOT		KVANG		KVANG		KVOONG1		GKURIMOT		*		GPEREZ		TTHAM		GGILMORE		GPEREZ		*		GPEREZ		*		*		CAFILER		CAFILER		MDIGRAZIA		WBROWN		TRAMON		CAFILER		GCLARA		TRAMON		CAFILER		WBROWN		TRAMON		MPACHECO		CAFILER		RGEREMIA		*		*		SARRIAGA		*		*		*		RGEREMIA		*		*		HMIX		*		JVAZQUEZ		SARRIAGA		JVAZQUEZ		*		SARRIAGA		DHORRELL		*		GGILMORE		*		*		PBANFORD		CPON		DHORRELL		DHORRELL		CPON		DHORRELL		*		RGEREMIA		TBOWMAN		*		DHORRELL		*		MPACHECO		RGEREMIA		CAFILER		TRAMON		MPACHECO		TRAMON		CPON		CPON		MDIGRAZIA		MDIGRAZIA		TRAMON		CAFILER		TRAMON		MDIGRAZIA		MPACHECO		CAFILER		GGILMORE		TRAMON		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MPACHECO		CAFILER		MPACHECO		TRAMON		WBROWN		JINGRAM		MDIGRAZIA		CAFILER		MDIGRAZIA		TRAMON		WBROWN		WBROWN		CPON		CPON		WBROWN		TRAMON		WBROWN		SARRIAGA		WBROWN		TRAMON		SARRIAGA		CAFILER		LFEDOROV		RGEREMIA		SUSHAKOV		CAFILER		TRAMON		TRAMON		LFEDOROV		TRAMON		SARRIAGA		IMEDINA		LFEDOROV		TRAMON		SARRIAGA		LFEDOROV		CSAGABAEN		CAFILER		TRAMON		IMEDINA		LFEDOROV		CAFILER		CAFILER		TRAMON		TRAMON		CAFILER		IMEDINA		TRAMON		SUSHAKOV		SUSHAKOV		CAFILER		KRUSSELL		IMEDINA		CAFILER		CAFILER		IMEDINA		LFEDOROV		CAFILER		CAFILER		SARRIAGA		SARRIAGA		SARRIAGA		KRUSSELL		SARRIAGA		SARRIAGA		SARRIAGA		IMEDINA		KRUSSELL		KRUSSELL		IMEDINA		CAFILER		CAFILER		JMAVES		JMAVES		KRUSSELL		JMAVES		CAFILER		IMEDINA		CAFILER		KRUSSELL		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		CAFILER
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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		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		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11001		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
rpt_start		2000-10-01 00:00:00		1996-03-10 00:00:00		1996-07-01 00:00:00		1996-10-01 00:00:00		None		1996-10-20 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-05-17 00:00:00		1998-07-01 00:00:00		1998-10-01 00:00:00		None		1999-01-01 00:00:00		None		1984-03-18 00:00:00		1985-01-31 00:00:00		None		1986-10-01 00:00:00		None		1990-01-01 00:00:00		1990-01-01 00:00:00		1994-10-01 00:00:00		None		1996-01-01 00:00:00		None		None		1980-08-08 00:00:00		1981-01-01 00:00:00		1981-07-01 00:00:00		1982-01-01 00:00:00		1982-01-01 00:00:00		1982-05-23 00:00:00		1982-07-01 00:00:00		1982-09-18 00:00:00		1982-10-17 00:00:00		None		1982-10-17 00:00:00		1983-07-01 00:00:00		1983-09-18 00:00:00		1983-01-01 00:00:00		1984-05-20 00:00:00		1984-07-01 00:00:00		None		1985-01-01 00:00:00		1985-07-01 00:00:00		1985-09-18 00:00:00		1986-01-01 00:00:00		1986-03-18 00:00:00		1986-05-18 00:00:00		1986-07-01 00:00:00		1986-10-01 00:00:00		1986-10-19 00:00:00		None		1987-01-01 00:00:00		None		1988-01-01 00:00:00		1988-03-18 00:00:00		1988-01-01 00:00:00		1988-05-22 00:00:00		1988-10-01 00:00:00		None		1988-10-23 00:00:00		1988-03-18 00:00:00		1988-10-01 00:00:00		None		1989-01-01 00:00:00		1989-07-01 00:00:00		1989-07-01 00:00:00		1989-10-22 00:00:00		1990-05-20 00:00:00		1990-07-01 00:00:00		1990-10-01 00:00:00		1990-01-01 00:00:00		1991-10-21 00:00:00		None		1990-10-21 00:00:00		1991-01-01 00:00:00		1991-07-01 00:00:00		None		1992-01-01 00:00:00		1992-05-17 00:00:00		1992-07-01 00:00:00		1992-10-01 00:00:00		1992-10-18 00:00:00		1993-01-01 00:00:00		1993-07-01 00:00:00		None		1994-01-01 00:00:00		1994-05-22 00:00:00		1994-07-01 00:00:00		1994-10-23 00:00:00		1995-01-01 00:00:00		1995-06-11 00:00:00		None		1995-07-01 00:00:00		None		1996-01-01 00:00:00		1999-07-01 00:00:00		2000-01-01 00:00:00		1987-07-01 00:00:00		1988-07-01 00:00:00		None		1998-10-18 00:00:00		2000-07-01 00:00:00		2000-02-20 00:00:00		2000-10-22 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2002-10-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-10-20 00:00:00		2003-01-01 00:00:00		2004-01-01 00:00:00		2003-07-01 00:00:00		2004-07-01 00:00:00		2004-02-15 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2004-10-17 00:00:00		2005-10-23 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		None		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-06-03 00:00:00		2014-07-25 00:00:00		2014-10-19 00:00:00		2014-10-19 00:00:00		2014-10-06 00:00:00		2014-07-01 00:00:00		2014-10-15 00:00:00		None		2014-07-01 00:00:00		2014-10-01 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-10-01 00:00:00		2009-02-10 00:00:00		2008-10-19 00:00:00		2008-10-19 00:00:00		2008-07-01 00:00:00		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-11-02 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2010-05-28 00:00:00		2010-01-01 00:00:00		None		None		2010-01-01 00:00:00		2010-05-28 00:00:00		2010-01-01 00:00:00		None		2010-01-01 00:00:00		2010-07-30 00:00:00		2010-06-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		None		2011-01-01 00:00:00		2011-07-22 00:00:00		2011-01-01 00:00:00		None		2012-01-01 00:00:00		2012-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		None		2012-01-01 00:00:00		2012-05-09 00:00:00		2012-03-18 00:00:00		2012-01-01 00:00:00		2012-03-18 00:00:00		2013-07-01 00:00:00		None		2013-07-01 00:00:00		2012-03-18 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-03-18 00:00:00		2012-05-20 00:00:00		2012-05-20 00:00:00		2012-10-05 00:00:00		2014-12-05 00:00:00		2014-10-01 00:00:00		2012-10-01 00:00:00		2012-11-01 00:00:00		2012-10-01 00:00:00		None		2014-09-25 00:00:00		2014-09-30 00:00:00		2014-05-18 00:00:00		2014-05-18 00:00:00		2014-10-01 00:00:00		None		2014-09-15 00:00:00		2012-10-21 00:00:00		2014-04-23 00:00:00		None		2012-10-21 00:00:00		2020-09-03 00:00:00		2020-01-01 00:00:00		2020-10-28 00:00:00		2020-07-01 00:00:00		2019-02-15 00:00:00		None		2019-02-04 00:00:00		2020-01-01 00:00:00		None		2019-01-01 00:00:00		2020-01-19 00:00:00		2020-07-01 00:00:00		None		2019-01-01 00:00:00		2020-01-19 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-08-21 00:00:00		2020-09-20 00:00:00		2019-07-01 00:00:00		2020-07-01 00:00:00		2019-07-01 00:00:00		None		2019-02-15 00:00:00		2020-01-13 00:00:00		2020-01-19 00:00:00		None		2020-01-01 00:00:00		2019-07-01 00:00:00		2020-01-19 00:00:00		2021-01-01 00:00:00		None		2020-01-01 00:00:00		2020-07-01 00:00:00		2020-09-20 00:00:00		2019-07-01 00:00:00		2022-01-01 00:00:00		2022-04-24 00:00:00		2020-09-20 00:00:00		2020-10-18 00:00:00		2020-10-18 00:00:00		2022-01-01 00:00:00		2020-09-20 00:00:00		2020-10-18 00:00:00		2020-10-18 00:00:00		2022-02-10 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		None		2022-09-06 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2022-04-24 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2022-08-11 00:00:00		2021-09-29 00:00:00		2022-05-12 00:00:00		2021-01-01 00:00:00		2022-05-22 00:00:00		2022-09-25 00:00:00		2022-10-27 00:00:00		2022-10-17 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00		2022-10-03 00:00:00
rpt_end		2000-10-21 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		1996-10-19 00:00:00		None		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-05-16 00:00:00		1998-06-30 00:00:00		1998-09-30 00:00:00		1998-10-17 00:00:00		None		1999-06-30 00:00:00		None		1984-05-19 00:00:00		1985-06-30 00:00:00		None		1986-10-18 00:00:00		None		1990-05-19 00:00:00		1990-05-19 00:00:00		1994-10-22 00:00:00		None		1996-03-09 00:00:00		None		None		1980-12-31 00:00:00		1981-06-30 00:00:00		1981-12-31 00:00:00		1982-05-22 00:00:00		1982-05-22 00:00:00		1982-06-30 00:00:00		1982-09-17 00:00:00		1982-10-16 00:00:00		1982-12-31 00:00:00		None		1982-12-31 00:00:00		1983-09-17 00:00:00		1983-12-31 00:00:00		1983-06-30 00:00:00		1984-06-30 00:00:00		1984-12-31 00:00:00		None		1985-06-30 00:00:00		1985-09-17 00:00:00		1985-12-31 00:00:00		1986-03-17 00:00:00		1986-05-18 00:00:00		1986-06-30 00:00:00		1986-09-30 00:00:00		1986-10-18 00:00:00		1986-12-31 00:00:00		None		1987-06-30 00:00:00		None		1988-03-17 00:00:00		1988-05-21 00:00:00		1988-03-17 00:00:00		1988-06-30 00:00:00		1988-10-22 00:00:00		None		1988-12-31 00:00:00		1988-05-21 00:00:00		1988-10-22 00:00:00		None		1989-06-30 00:00:00		1989-10-21 00:00:00		1989-10-21 00:00:00		1989-12-31 00:00:00		1990-06-30 00:00:00		1990-09-30 00:00:00		1990-10-20 00:00:00		1990-05-19 00:00:00		1990-12-31 00:00:00		None		1990-12-31 00:00:00		1991-06-30 00:00:00		1991-12-31 00:00:00		None		1992-05-16 00:00:00		1992-06-30 00:00:00		1992-09-30 00:00:00		1992-10-17 00:00:00		1992-12-31 00:00:00		1993-06-30 00:00:00		1993-12-31 00:00:00		None		1994-05-21 00:00:00		1994-06-30 00:00:00		1994-09-30 00:00:00		1994-12-31 00:00:00		1995-06-10 00:00:00		1995-06-30 00:00:00		None		1995-12-31 00:00:00		None		1996-03-09 00:00:00		1999-12-31 00:00:00		2000-02-19 00:00:00		1987-12-31 00:00:00		1988-09-30 00:00:00		None		1998-12-31 00:00:00		2000-09-30 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2002-10-19 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2004-02-14 00:00:00		2003-12-31 00:00:00		2004-09-30 00:00:00		2004-06-30 00:00:00		2004-10-16 00:00:00		2005-06-30 00:00:00		2005-10-22 00:00:00		2004-12-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		None		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2013-06-30 00:00:00		2014-05-17 00:00:00		2014-05-17 00:00:00		2014-06-03 00:00:00		2014-07-25 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-10-06 00:00:00		2014-09-30 00:00:00		2014-10-15 00:00:00		None		2014-09-30 00:00:00		2014-10-18 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-10-05 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2009-02-10 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2008-09-30 00:00:00		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-11-02 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-05-28 00:00:00		2010-05-22 00:00:00		None		None		2010-05-22 00:00:00		2010-05-28 00:00:00		2010-05-22 00:00:00		None		2010-05-22 00:00:00		2010-07-30 00:00:00		2010-06-01 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		None		2011-06-30 00:00:00		2011-07-22 00:00:00		2011-06-30 00:00:00		None		2012-03-17 00:00:00		2012-03-17 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		None		2012-03-17 00:00:00		2012-05-09 00:00:00		2012-05-19 00:00:00		2012-03-17 00:00:00		2012-05-19 00:00:00		2013-12-31 00:00:00		None		2013-12-31 00:00:00		2012-05-19 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-10-05 00:00:00		2014-12-05 00:00:00		2014-10-18 00:00:00		2012-10-20 00:00:00		2012-11-01 00:00:00		2012-10-20 00:00:00		None		2014-09-25 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2014-10-01 00:00:00		None		2014-09-15 00:00:00		2012-12-31 00:00:00		2014-04-23 00:00:00		None		2012-12-31 00:00:00		2020-09-03 00:00:00		2020-01-18 00:00:00		2020-10-28 00:00:00		2020-09-19 00:00:00		2019-02-15 00:00:00		None		2019-02-04 00:00:00		2020-01-18 00:00:00		None		2019-06-30 00:00:00		2020-06-30 00:00:00		2020-09-19 00:00:00		None		2019-06-30 00:00:00		2020-06-30 00:00:00		2019-06-30 00:00:00		2019-06-30 00:00:00		2019-08-21 00:00:00		2020-10-17 00:00:00		2019-12-31 00:00:00		2020-09-19 00:00:00		2019-12-31 00:00:00		None		2019-02-15 00:00:00		2020-01-13 00:00:00		2020-06-30 00:00:00		None		2020-01-18 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2021-06-30 00:00:00		None		2020-01-18 00:00:00		2020-09-19 00:00:00		2020-10-17 00:00:00		2019-12-31 00:00:00		2022-04-23 00:00:00		2022-05-21 00:00:00		2020-10-17 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2022-04-23 00:00:00		2020-10-17 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2022-02-10 00:00:00		2021-12-31 00:00:00		2022-04-23 00:00:00		None		2022-09-06 00:00:00		2021-06-30 00:00:00		2021-06-30 00:00:00		2022-05-21 00:00:00		2021-12-31 00:00:00		2022-04-23 00:00:00		2022-08-11 00:00:00		2021-09-29 00:00:00		2022-05-12 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2022-10-22 00:00:00		2022-10-27 00:00:00		2022-10-17 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00		2022-10-03 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2006-07-12 00:00:00		None		None		None		None		2006-12-22 00:00:00		None		2007-07-11 00:00:00		2007-07-12 00:00:00		2013-07-17 00:00:00		2014-05-20 00:00:00		None		2014-06-03 00:00:00		None		2015-02-02 00:00:00		None		None		2014-10-06 00:00:00		2014-10-15 00:00:00		None		None		2014-10-21 00:00:00		None		2008-01-17 00:00:00		2008-01-18 00:00:00		None		2008-07-07 00:00:00		2008-10-06 00:00:00		2008-10-07 00:00:00		None		2008-10-20 00:00:00		None		None		2009-02-02 00:00:00		None		None		None		2009-07-02 00:00:00		None		2009-11-02 00:00:00		2009-07-01 00:00:00		None		2010-01-11 00:00:00		2010-01-10 00:00:00		2010-05-28 00:00:00		None		None		None		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-10-05 00:00:00		None		None		None		2010-06-01 00:00:00		2010-06-01 00:00:00		None		None		2011-07-22 00:00:00		None		None		None		2012-03-20 00:00:00		None		2012-01-30 00:00:00		None		None		2012-05-23 00:00:00		None		2012-05-23 00:00:00		None		2012-06-08 00:00:00		None		None		2014-01-24 00:00:00		None		2012-10-05 00:00:00		None		None		2012-07-18 00:00:00		None		None		2014-12-05 00:00:00		None		None		2012-11-01 00:00:00		2012-10-25 00:00:00		None		2014-09-25 00:00:00		2014-09-30 00:00:00		2014-07-24 00:00:00		None		2014-10-01 00:00:00		None		2014-09-15 00:00:00		2013-01-26 00:00:00		2014-04-23 00:00:00		None		None		2020-09-03 00:00:00		2020-01-23 00:00:00		2020-10-28 00:00:00		None		2019-02-15 00:00:00		None		None		None		None		None		None		None		None		2019-07-31 00:00:00		None		None		2019-08-09 00:00:00		None		None		2020-01-31 00:00:00		2020-09-21 00:00:00		2020-02-18 00:00:00		None		None		2020-01-13 00:00:00		2020-07-31 00:00:00		None		None		None		2020-08-14 00:00:00		None		None		2020-02-18 00:00:00		2020-10-22 00:00:00		2020-10-22 00:00:00		None		2022-05-26 00:00:00		2022-05-26 00:00:00		None		None		2021-02-01 00:00:00		2022-04-28 00:00:00		2021-02-18 00:00:00		2021-02-18 00:00:00		None		None		2022-01-31 00:00:00		None		None		2022-09-06 00:00:00		2021-08-13 00:00:00		None		None		None		None		2022-08-11 00:00:00		None		2022-05-12 00:00:00		2021-08-02 00:00:00		2022-08-01 00:00:00		2022-10-27 00:00:00		2022-10-27 00:00:00		2022-10-17 00:00:00		2022-09-29 00:00:00		None		2022-10-03 00:00:00
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		22006		None		None		None		None		22006		None		22006		22006		22001		22001		None		22001		22001		22001		None		22001		22001		22001		None		None		22001		None		22006		22006		None		22006		22006		22006		None		22006		22006		None		22006		None		None		None		22006		None		22006		22006		None		22006		22006		22006		None		None		None		22006		22006		22006		None		None		22006		22006		22006		None		None		22001		22001		None		None		22001		None		22001		None		None		22001		22001		22001		None		22001		None		None		22001		None		22001		None		None		22001		None		22001		22001		None		None		22001		22001		None		22001		22001		22001		None		22001		None		22001		22001		22001		None		None		22001		22001		22001		None		22001		None		22001		None		None		None		None		None		None		22001		None		None		22001		22001		None		22001		22001		22001		None		22001		22001		22001		None		None		None		22001		None		None		22001		22001		22001		None		22001		22001		None		None		22001		22001		22001		22001		None		22001		22001		None		None		22001		22001		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001

Table: filer_to_filer_type

filer_id		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815
filer_type		16		16		16		16		16		16		16		16		16
active		Y		Y		Y		Y		Y		Y		Y		Y		Y
race		0		0		0		0		0		0		0		0		0
session_id		1979		2005		2013		2011		2011		2009		2009		2013		2019
category		0		0		0		0		0		0		0		0		0
category_type		40502		40502		40502		40503		40502		40503		40501		40503		40502
sub_category		40103		40103		40103		40103		40103		40103		40103		40103		40103
effect_dt		1990-12-01 00:00:00		1986-01-17 00:00:00		2014-02-03 00:00:00		2012-10-09 00:00:00		2011-08-03 00:00:00		2010-08-02 00:00:00		2010-08-24 00:00:00		2014-08-04 00:00:00		2019-02-06 00:00:00
sub_category_type		40202		0		0		0		0		0		0		0		0
election_type		0		0		0		0		0		0		0		0		0
sub_category_a		S		S		S		S		S		S		S		S		S
nyq_dt		1980-09-01 00:00:00		1980-09-01 00:00:00		1980-09-01 00:00:00		1980-09-01 00:00:00		1980-09-01 00:00:00		1980-09-01 00:00:00		1980-09-01 00:00:00		1980-09-01 00:00:00		1980-09-01 00:00:00
party_cd		None		None		None		None		None		None		None		None		None
county_cd		18030		18036		18036		18036		18036		18036		18036		18036		18036
district_cd		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1029815
xref_id		802010
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010		802010
filer_id		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00		2019-02-06 00:00:00
naml		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY CHAMBER POLITICAL ACTION COMMITTEE		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC		ORANGE COUNTY BUSINESS COUNCIL DBA BIZ PAC
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SAN MARINO		IRVINE		IRVINE		LOS ANGELES		IRVINE		LOS ANGELES		LOS ANGELES		IRVINE		IRVINE		LOS ANGELES		IRVINE		LOS ANGELES		SAN MARINO		IRVINE		IRVINE		LOS ANGELES		IRVINE		LOS ANGELES		LOS ANGELES		IRVINE		IRVINE		LOS ANGELES		IRVINE		LOS ANGELES		SAN MARINO		IRVINE		IRVINE		LOS ANGELES		IRVINE		LOS ANGELES		LOS ANGELES		IRVINE		IRVINE		LOS ANGELES		IRVINE		LOS ANGELES
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		911080000		927140000		927140000		90010		92614		90010		90071		92614		92614		90071		92614		90071		911080000		927140000		927140000		90010		92614		90010		90071		92614		92614		90071		92614		90071		911080000		927140000		927140000		90010		92614		90010		90071		92614		92614		90071		92614		90071
phon		8184414594		7144762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		8184414594		7144762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		8184414594		7144762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242		9494762242
fax		None		None		9494769240		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		None		None		9494769240		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		None		None		9494769240		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692		2136231692
email		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1029815

Table: received_filings

filer_id		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815		1029815
filing_file_name		1840673_0.cal		27097.cal		1858269_0.cal		1890468_0.cal		1885263_0.cal		325945.cal		1898433_0.cal		1889936_0.cal		1888504_0.cal		1917166_0.cal		2359583_0.cal		2429975_0.cal		7999.cal		320236.cal		2498365_0.cal		7932.cal		2525853_0.cal		2743883_0.cal		2727124_0.cal		2735198_0.cal		2717915_0.cal		2681819_0.cal		2710189_0.cal
received_date		2014-04-23 00:00:00		2011-08-01 00:00:00		2014-06-03 00:00:00		2014-10-01 00:00:00		2014-09-15 00:00:00		2014-09-15 00:00:00		2014-10-15 00:00:00		2014-09-30 00:00:00		2014-09-25 00:00:00		2014-12-05 00:00:00		2019-02-15 00:00:00		2020-01-13 00:00:00		2019-02-04 00:00:00		2019-08-21 00:00:00		2020-09-03 00:00:00		2019-02-04 00:00:00		2020-10-28 00:00:00		2022-10-27 00:00:00		2022-09-30 00:00:00		2022-10-17 00:00:00		2022-09-07 00:00:00		2022-05-12 00:00:00		2022-08-11 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/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/temp		/cafiler/disclose/ca99/temp		/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
filing_id		1840673		None		1858269		1890468		1885263		None		1898433		1889936		1888504		1917166		2359583		2429975		None		None		2498365		None		2525853		2743883		2727124		2735198		2717915		2681819		2710189
form_id		F497		None		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		None		None		F497		None		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		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 accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted