Home

Filer ID: 1420452

Table: cvr_lobby_disclosure

filing_id		2465829		2413751		2433830		2522625		2479050		2547280		2576028		2616348		2596410		2637923		2739554		2670088		2701693
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615
sender_id		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452
filer_id		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN
filer_namf		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2020-04-15 00:00:00		2019-10-18 00:00:00		2020-01-23 00:00:00		2020-10-26 00:00:00		2020-07-17 00:00:00		2021-01-26 00:00:00		2021-04-22 00:00:00		2021-10-18 00:00:00		2021-07-26 00:00:00		2022-01-26 00:00:00		2022-10-24 00:00:00		2022-04-25 00:00:00		2022-07-27 00:00:00
from_date		2020-01-01 00:00:00		2019-07-01 00:00:00		2019-10-01 00:00:00		2020-07-01 00:00:00		2020-04-01 00:00:00		2020-10-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00
thru_date		2020-03-31 00:00:00		2019-09-30 00:00:00		2019-12-31 00:00:00		2020-09-30 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-09-30 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00
cum_beg_dt		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_id		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452
firm_name		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC
firm_city		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK
firm_st		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY
firm_zip4		10281		10281		10281		10281		10281		10281		10281		10281		10281		10281		10281		10281		10281
firm_phon		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2020-04-15 00:00:00		2019-10-18 00:00:00		2020-01-23 00:00:00		2020-10-26 00:00:00		2020-07-17 00:00:00		2021-01-26 00:00:00		2021-04-22 00:00:00		2021-10-18 00:00:00		2021-07-26 00:00:00		2022-01-26 00:00:00		2022-10-24 00:00:00		2022-04-25 00:00:00		2022-07-27 00:00:00
sig_loc		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA
sig_naml		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan
sig_namf		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel
sig_namt		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_naml		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan		Heffernan
prn_namf		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel		Daniel
prn_namt		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_title		Senior Vice President		SVP		Senior Vice President		Senior Vice President		Senior Vice President		Senior Vice President		Senior Vice President		SVP		SVP		SVP		SVP		SVP		SVP
nopart1_cb		X		X		X		X		X		X		X		X		X		X		X		X		X
nopart2_cb		X		X		X		X		X		X		X		X		X		X		X		X		X
part1_1_cb		None		None		None		None		None		None		None		None		None		None		None		None		None
part1_2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_n_cb		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_y_cb		None		None		None		None		None		None		None		None		None		None		None		None		None
lby_actvty		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_n_cb		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_y_cb		None		None		None		None		None		None		None		None		None		None		None		None		None
major_naml		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namf		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namt		None		None		None		None		None		None		None		None		None		None		None		None		None
major_nams		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_nm		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: cvr_registration

filing_id		2407883		2407883		2537428
amend_id		1		0		0
rec_type		CVR		CVR		CVR
form_type		F604		F604		F604
sender_id		1334632		1334632		1334632
filer_id		1420452		1420452		1420452
entity_cd		LBY		LBY		LBY
filer_naml		HEFFERNAN		HEFFERNAN		HEFFERNAN
filer_namf		DANIEL		DANIEL		DANIEL
filer_namt		None		None		None
filer_nams		None		None		None
report_num		001		000		000
rpt_date		2019-11-22 00:00:00		2019-08-26 00:00:00		2020-12-18 00:00:00
ls_beg_yr		2019		2019		2021
ls_end_yr		2020		2020		2022
qual_date		2019-08-16 00:00:00		2019-08-16 00:00:00		None
eff_date		None		None		None
bus_city		NEW YORK		NEW YORK		NEW YORK
bus_st		NY		NY		NY
bus_zip4		10281		10281		10281
bus_phon		2133308122		2133308122		2133308122
bus_fax		None		None		None
bus_email		[email protected]		[email protected]		[email protected]
mail_city		None		None		None
mail_st		None		None		None
mail_zip4		None		None		None
mail_phon		None		None		None
sig_date		2019-11-16 00:00:00		2019-08-19 00:00:00		2020-12-11 00:00:00
sig_loc		None		None		None
sig_naml		HEFFERNAN		HEFFERNAN		HEFFERNAN
sig_namf		DANIEL		DANIEL		DANIEL
sig_namt		None		None		None
sig_nams		None		None		None
prn_naml		HEFFERNAN		HEFFERNAN		HEFFERNAN
prn_namf		DANIEL		DANIEL		DANIEL
prn_namt		None		None		None
prn_nams		None		None		None
sig_title		None		None		None
stmt_firm		None		None		None
ind_cb		None		None		None
bus_cb		None		None		None
trade_cb		None		None		None
oth_cb		None		None		None
a_b_name		None		None		None
a_b_city		None		None		None
a_b_st		None		None		None
a_b_zip4		None		None		None
descrip_1		None		None		None
descrip_2		None		None		None
c_less50		None		None		None
c_more50		None		None		None
ind_class		None		None		None
ind_descr		None		None		None
bus_class		None		None		None
bus_descr		None		None		None
auth_name		None		None		None
auth_city		None		None		None
auth_st		None		None		None
auth_zip4		None		None		None
lobby_int		None		None		None
influen_yn		None		None		None
firm_name		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC		Brookfield Private Advisors LLC
newcert_cb		None		X		None
rencert_cb		None		None		None
complet_dt		2019-11-14 00:00:00		None		2020-12-11 00:00:00
lby_reg_cb		X		X		X
lby_604_cb		None		None		None
st_leg_yn		N		N		N
st_agency		None		None		None
lobby_cb		None		None		None
l_firm_cb		None		None		None

Table: filer_address

filer_id		1420452		1420452		1420452
adrid		2544971		2507180		2483144
effect_dt		2023-01-01 00:00:00		2021-01-01 00:00:00		2019-08-16 00:00:00
add_type		7051		7051		7051
session_id		2023		2021		2019

Table: filer_ethics_class

filer_id		1420452		1420452
session_id		2019		2021
ethics_date		2019-11-14 00:00:00		2020-12-11 00:00:00

Table: filer_filings

filer_id		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452
filing_id		2407883		2522625		2407883		2422973		2409527		2413751		2547280		2433830		2465829		2479050		2701693		2616348		2637923		2596410		2537428		2670088		2557659		2576028		2739554
period_id		240		243		239		None		None		239		244		240		241		242		250		247		248		246		244		249		None		245		251
form_id		F604		F615		F604		F604		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F615		F615
filing_sequence		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2019-11-22 00:00:00		2020-10-26 00:00:00		2019-08-26 00:00:00		2019-11-22 00:00:00		2019-08-22 00:00:00		2019-10-18 00:00:00		2021-01-26 00:00:00		2020-01-23 00:00:00		2020-04-15 00:00:00		2020-07-17 00:00:00		2022-07-27 00:00:00		2021-10-18 00:00:00		2022-01-26 00:00:00		2021-07-26 00:00:00		2020-12-18 00:00:00		2022-04-25 00:00:00		2020-12-21 00:00:00		2021-04-22 00:00:00		2022-10-24 00:00:00
stmnt_type		10002		10001		10001		10002		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003
session_id		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		GPEREZ		MKIRKHAM		SARRIAGA		GPEREZ		SARRIAGA		GTAYLOR		GTAYLOR		GTAYLOR		VUKSTINA		VUKSTINA		CAFILER		MKIRKHAM		RATTIYEH		CHATRIDGE		CVANLIEW		CAFILER		CVANLIEW		GTAYLOR		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11001		11003
rpt_start		2019-11-22 00:00:00		2020-07-01 00:00:00		2019-08-26 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-07-01 00:00:00		2020-10-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2020-04-01 00:00:00		2022-04-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2021-04-01 00:00:00		2020-12-18 00:00:00		2022-01-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		2019-11-22 00:00:00		2020-09-30 00:00:00		2019-08-26 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-09-30 00:00:00		2020-12-31 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2020-06-30 00:00:00		2022-06-30 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2020-12-18 00:00:00		2022-03-31 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2022-09-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
filing_type		22006		22006		22006		None		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006

Table: filer_to_filer_type

filer_id		1420452		1420452		1420452
filer_type		4		4		4
active		Y		Y		N
race		None		0		None
session_id		2021		2019		2023
category		None		0		None
category_type		None		0		None
sub_category		None		0		None
effect_dt		2021-01-01 00:00:00		2019-08-16 00:00:00		2023-01-01 00:00:00
sub_category_type		None		0		None
election_type		None		0		None
sub_category_a		None		None		None
nyq_dt		None		None		None
party_cd		None		0		None
county_cd		None		0		None
district_cd		None		0		None

Table: filer_xref

filer_id		1420452
xref_id		1420452
effect_dt		2019-08-16 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452
filer_id		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452		1420452
filer_type		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN		HEFFERNAN
namf		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL		DANIEL
namt		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None
city		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK
st		NY		NY		NY		NY		NY		NY		NY		NY		NY
zip4		10281		10281		10281		10281		10281		10281		10281		10281		10281
phon		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122		2133308122
fax		None		None		None		None		None		None		None		None		None
email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1420452

Table: received_filings

filer_id		1420452		1420452		1420452
filing_file_name		2407883_0.cal		2407883_1.cal		2537428_0.cal
received_date		2019-08-26 00:00:00		2019-11-22 00:00:00		2020-12-18 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		2407883		2407883		2537428
form_id		F604		F604		F604
receive_comment		Filing accepted		Filing accepted		Filing accepted