| filing_id | 2193727 | 2242675 | 2276341 | 2242675 | 2210775 | 2349146 | 2319179 | 2621671 | 2578934 | 2600637 | 2673667 | 2702275 | 2621671 | 2642977 | 2745129 | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | |||||||||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||
| form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||
| sender_id | F00799 | F00799 | F00799 | F00799 | F00799 | F00799 | F00799 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | |||||||||||||||
| filer_id | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | |||||||||||||||
| entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | |||||||||||||||
| filer_naml | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | PolicyLink | PolicyLink | PolicyLink | PolicyLink | PolicyLink | PolicyLink | PolicyLink | PolicyLink | |||||||||||||||
| filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| filer_namt | None | None | 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 | None | None | |||||||||||||||
| report_num | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | |||||||||||||||
| rpt_date | 2017-10-31 00:00:00 | 2018-04-10 00:00:00 | 2018-07-30 00:00:00 | 2018-04-10 00:00:00 | 2018-01-20 00:00:00 | 2019-01-29 00:00:00 | 2018-10-30 00:00:00 | 2021-10-20 00:00:00 | 2021-04-29 00:00:00 | 2021-07-26 00:00:00 | 2022-04-26 00:00:00 | 2022-07-20 00:00:00 | 2022-01-27 00:00:00 | 2022-01-25 00:00:00 | 2022-10-20 00:00:00 | |||||||||||||||
| from_date | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||
| thru_date | 2017-09-30 00:00:00 | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||
| cum_beg_dt | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||||||||
| firm_id | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | |||||||||||||||
| firm_name | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | PolicyLink | PolicyLink | PolicyLink | PolicyLink | PolicyLink | PolicyLink | PolicyLink | PolicyLink | |||||||||||||||
| firm_city | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | Oakland | Oakland | Oakland | Oakland | Oakland | Oakland | Oakland | Oakland | |||||||||||||||
| firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||
| firm_zip4 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | |||||||||||||||
| firm_phon | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | 510-663-4382 | |||||||||||||||
| mail_city | None | None | 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 | None | None | |||||||||||||||
| mail_zip4 | None | None | 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 | None | None | |||||||||||||||
| sig_date | 2017-10-30 00:00:00 | 2018-04-28 00:00:00 | 2018-07-30 00:00:00 | 2018-06-13 00:00:00 | 2018-01-30 00:00:00 | 2019-01-31 00:00:00 | 2018-10-31 00:00:00 | 2021-10-20 00:00:00 | 2021-04-29 00:00:00 | 2021-07-26 00:00:00 | 2022-04-26 00:00:00 | 2022-07-20 00:00:00 | 2022-01-27 00:00:00 | 2022-01-25 00:00:00 | 2022-10-20 00:00:00 | |||||||||||||||
| sig_loc | OAKLAND CA | OAKLAND CA | OAKLAND CA | OAKLAND CA | OAKLAND CA | OAKLAND CA | OAKLAND CA | Oakland CA | Oakland CA | Oakland CA | Oakland CA | Oakland CA | Oakland CA | Oakland CA | Oakland CA | |||||||||||||||
| sig_naml | PHILPART | PHILPART | PHILPART | PHILPART | PHILPART | PHILPART | PHILPART | Hassid | Hassid | Hassid | Hassid | Hassid | Hassid | Hassid | Hassid | |||||||||||||||
| sig_namf | MARC | MARC | MARC | MARC | MARC | MARC | MARC | Michael J. | Michael J. | Michael J. | Michael J. | Michael J. | Michael J. | Michael J. | Michael J. | |||||||||||||||
| sig_namt | None | None | 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 | None | None | |||||||||||||||
| prn_naml | PHILPART | PHILPART | PHILPART | PHILPART | PHILPART | PHILPART | PHILPART | Hassid | Hassid | Hassid | Hassid | Hassid | Hassid | Hassid | Hassid | |||||||||||||||
| prn_namf | MARC | MARC | MARC | MARC | MARC | MARC | MARC | Michael J. | Michael J. | Michael J. | Michael J. | Michael J. | Michael J. | Michael J. | Michael J. | |||||||||||||||
| prn_namt | None | None | 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 | None | None | |||||||||||||||
| sig_title | SENIOR DIRECTOR | SENIOR DIRECTOR | SENIOR DIRECTOR | SENIOR DIRECTOR | SENIOR DIRECTOR | SENIOR DIRECTOR | SENIOR DIRECTOR | Chief Financial Officer | Chief Financial Officer | Chief Financial Officer | Chief Financial Officer | Chief Financial Officer | Chief Financial Officer | Chief Financial Officer | Chief Financial Officer | |||||||||||||||
| nopart1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| nopart2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| part1_1_cb | None | None | 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 | None | None | |||||||||||||||
| ctrib_n_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||
| ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| lby_actvty | Legislature Governors Office. SB 607 | NONE | Governors Office and Legislature RE: SB 607 | NONE | Legislature Governors Office. SB 607 | NONE | Governors Office and Legislature RE: SB 607 | AB 16, 46, 118, 503, 610, 628, 937, 990; SB 2, 823, Legislature: Bail Reform, Audit of Law Enforcement Departments and Funding, Audit of California's Batterer Intervention Programs, State Budget. | AB901,1007, 1196, 1253, 2054, 1436, 2542, 3070, 3088, 3216, 610, 628, 46, 503, 493, 118, 937, 481, 490; SB2, 275, 555, 731, 776, 823, 1111, 1410, Legislature: state budget. | AB 16, AB 610, AB 628, AB 46, AB 503, AB 118, AB 937, AB 990, AB 3088, AB 15; SB 2, SB 823, Legislature: Bail Reform, Audit of Law Enforcement Departments and Funding, Audit of California's Batterer Intervention Programs, State Budget. | AB 118, 503, 937, 1206, 1816, 1837, 2022 ,2383, 2419, 2469, 2710, 2790; SB 2, 17, 222, 490, 948, 1049, 1176, 1273,1351, Legislature: State Budget. | AB 118, 503, 937, 1206, 1816, 1837, 2022, 2383, 2419, 2469, 2710, 2790; SB 2, 17, 222, 490, 948, 1049, 1176, 1273, 1351, Legislature: State Budget. | AB 16, 46, 118, 503, 610, 628, 937, 990; SB 2, 823, Legislature: Bail Reform, Audit of Law Enforcement Departments and Funding, Audit of California's Batterer Intervention Programs, State Budget. | AB 16, 46, 118, 503, 610, 628, 937, 990; SB 2, 823, Legislature: Bail Reform, Audit of Law Enforcement Departments and Funding, Audit of California's Batterer Intervention Programs, State Budget. | None. | |||||||||||||||
| lobby_n_cb | None | None | 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 | None | None | |||||||||||||||
| major_naml | None | None | 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 | None | None | |||||||||||||||
| major_namt | None | None | 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 | None | None | |||||||||||||||
| rcpcmte_nm | None | None | 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 | None | None |
| filer_id | 1398671 | 1398671 | 1398671 | 1398671 | ||||
|---|---|---|---|---|---|---|---|---|
| adrid | 2549713 | 2521716 | 2439196 | 2468775 | ||||
| effect_dt | 2023-01-01 00:00:00 | 2021-04-01 00:00:00 | 2017-08-23 00:00:00 | 2019-01-01 00:00:00 | ||||
| add_type | 7051 | 7051 | 7051 | 7051 | ||||
| session_id | 2023 | 2021 | 2017 | 2019 |
| filer_id | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2193727 | 2242675 | 2276341 | 2210775 | 2578934 | 2319179 | 2242675 | 2185720 | 2349146 | 2621671 | 2600637 | 2603051 | 2673667 | 2702275 | 2642977 | 2695318 | 2614896 | 2621671 | 2745129 | |||||||||||||||||||
| period_id | 231 | 233 | 234 | 232 | 245 | 235 | 233 | None | 236 | 247 | 246 | None | 249 | 250 | 248 | None | None | 247 | 251 | |||||||||||||||||||
| form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | |||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||||||||||||||||
| filing_date | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-07-31 00:00:00 | 2018-01-31 00:00:00 | 2021-04-29 00:00:00 | 2018-10-31 00:00:00 | 2018-06-13 00:00:00 | 2017-09-27 00:00:00 | 2019-01-31 00:00:00 | 2021-10-28 00:00:00 | 2021-07-30 00:00:00 | 2021-04-13 00:00:00 | 2022-04-28 00:00:00 | 2022-07-27 00:00:00 | 2022-01-31 00:00:00 | 2022-06-16 00:00:00 | 2021-08-31 00:00:00 | 2022-01-31 00:00:00 | 2022-10-28 00:00:00 | |||||||||||||||||||
| stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10002 | 10001 | |||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||
| session_id | 2017 | 2017 | 2017 | 2017 | 2021 | 2017 | 2017 | 2017 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||
| user_id | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | CAFILER | CHATRIDGE | MKIRKHAM | CAFILER | CAFILER | CHATRIDGE | SARRIAGA | MKIRKHAM | CAFILER | CAFILER | |||||||||||||||||||
| special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||
| fine_audit | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||
| rpt_start | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2021-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||
| rpt_end | 2017-09-30 00:00:00 | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2021-03-31 00:00:00 | 2018-09-30 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 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 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 |
| filer_id | 1398671 | 1398671 | 1398671 | 1398671 | ||||
|---|---|---|---|---|---|---|---|---|
| session_id | 2019 | 2017 | 2021 | 2023 | ||||
| interest_cd | 40312 | 40312 | 40312 | 40312 | ||||
| effect_date | 2019-01-01 00:00:00 | 2017-08-23 00:00:00 | 2021-04-01 00:00:00 | 2023-01-01 00:00:00 |
| filer_id | 1398671 | 1398671 | 1398671 | 1398671 | ||||
|---|---|---|---|---|---|---|---|---|
| filer_type | 1 | 1 | 1 | 1 | ||||
| active | N | Y | Y | N | ||||
| race | None | 0 | None | None | ||||
| session_id | 2019 | 2017 | 2021 | 2023 | ||||
| category | None | 0 | None | None | ||||
| category_type | None | 0 | None | None | ||||
| sub_category | None | 0 | None | None | ||||
| effect_dt | 2019-01-01 00:00:00 | 2017-08-23 00:00:00 | 2021-04-01 00:00:00 | 2023-01-01 00:00:00 | ||||
| sub_category_type | None | 0 | None | None | ||||
| election_type | None | 0 | None | None | ||||
| sub_category_a | None | None | None | None | ||||
| nyq_dt | None | None | None | None | ||||
| party_cd | None | 0 | None | None | ||||
| county_cd | None | 0 | None | None | ||||
| district_cd | None | 0 | None | None |
| filer_id | 1398671 | |
|---|---|---|
| xref_id | 1398671 | |
| effect_dt | 2017-09-05 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | 1398671 | ||||||||||||||||
| filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||
| status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | 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 | 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 | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | POLICYLINK | ||||||||||||||||
| namf | 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 | ||||||||||||||||
| nams | 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 | ||||||||||||||||
| adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
| city | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | ||||||||||||||||
| st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||
| zip4 | 94612 | 94612 | 946123228 | 946123228 | 94612 | 94612 | 946123228 | 946123228 | 94612 | 94612 | 946123228 | 946123228 | 94612 | 94612 | 946123228 | 946123228 | ||||||||||||||||
| phon | 5106634382 | 5106634382 | 5106634309 | 5106634309 | 5106634382 | 5106634382 | 5106634309 | 5106634309 | 5106634382 | 5106634382 | 5106634309 | 5106634309 | 5106634382 | 5106634382 | 5106634309 | 5106634309 | ||||||||||||||||
| fax | None | None | 5102161862 | 5102161862 | None | None | 5102161862 | 5102161862 | None | None | 5102161862 | 5102161862 | None | None | 5102161862 | 5102161862 | ||||||||||||||||
| None | None | [email protected] | [email protected] | None | None | [email protected] | [email protected] | None | None | [email protected] | [email protected] | None | None | [email protected] | [email protected] |
| filer_id | 1398671 |
|---|
| filer_id | 1398671 | 1398671 | ||
|---|---|---|---|---|
| change_no | 1 | 0 | ||
| session_id | 2017 | 2017 | ||
| log_dt | 2017-09-27 00:00:00 | 2017-09-27 00:00:00 | ||
| filer_type | 1 | 2 | ||
| correction_flg | None | Y | ||
| action | SET ACTIVE | ADDED | ||
| attribute_changed | FIRM | |||
| ethics_dt | None | None | ||
| interests | None | None | ||
| filer_full_name | POLICYLINK | POLICYLINK | ||
| filer_city | None | None | ||
| filer_st | None | None | ||
| filer_zip | None | None | ||
| filer_phone | None | None | ||
| entity_type | 1 | 3 | ||
| entity_name | None | SACRAMENTO ADVOCATES INC. | ||
| entity_city | None | None | ||
| entity_st | None | None | ||
| entity_zip | None | None | ||
| entity_phone | None | None | ||
| entity_id | 0 | 1147285 | ||
| responsible_officer | None | None | ||
| effect_dt | 2017-08-23 00:00:00 | 2017-08-23 00:00:00 |
| filer_id | 1398671 | |
|---|---|---|
| filing_file_name | 41878.cal | |
| received_date | 2021-04-29 00:00:00 | |
| filing_directory | /cafiler/disclose/ca99/temp | |
| filing_id | None | |
| form_id | None | |
| receive_comment | Filing passed validation, but failed DB constraints |