filing_id | 2096043 | 2171620 | 2153621 | 2123074 | 2191518 | 2240253 | 2270931 | 2206623 | 2378131 | 2394398 | 2347083 | 2315309 | 2440023 | 2415924 | 2470382 | 2550489 | 2485025 | 2526684 | 2600659 | 2580343 | 2622135 | 2674727 | 2705547 | 2641862 | 2748849 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 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 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||
sender_id | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | |||||||||||||||||||||||||
filer_id | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | |||||||||||||||||||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | |||||||||||||||||||||||||
filer_naml | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | |||||||||||||||||||||||||
filer_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 | |||||||||||||||||||||||||
filer_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 | |||||||||||||||||||||||||
filer_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 | |||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||
rpt_date | 2016-10-26 00:00:00 | 2017-07-26 00:00:00 | 2017-04-26 00:00:00 | 2017-01-25 00:00:00 | 2017-10-29 00:00:00 | 2018-04-29 00:00:00 | 2018-07-24 00:00:00 | 2018-01-27 00:00:00 | 2019-04-28 00:00:00 | 2019-07-28 00:00:00 | 2019-01-31 00:00:00 | 2018-10-29 00:00:00 | 2020-01-30 00:00:00 | 2019-10-27 00:00:00 | 2020-04-30 00:00:00 | 2021-01-29 00:00:00 | 2020-07-31 00:00:00 | 2020-10-29 00:00:00 | 2021-07-30 00:00:00 | 2021-04-30 00:00:00 | 2021-10-29 00:00:00 | 2022-04-29 00:00:00 | 2022-07-20 00:00:00 | 2022-01-29 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||
from_date | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||
thru_date | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||
cum_beg_dt | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-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 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | |||||||||||||||||||||||||
firm_name | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | |||||||||||||||||||||||||
firm_city | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | |||||||||||||||||||||||||
firm_st | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | |||||||||||||||||||||||||
firm_zip4 | 85254 | 85254 | 85254 | 85254 | 85254 | 85254 | 85254 | 85254 | 85254 | 85260 | 85254 | 85254 | 85260 | 85260 | 85260 | 85260 | 85260 | 85260 | 85260 | 85260 | 85260 | 85260 | 85260 | 85260 | 85260 | |||||||||||||||||||||||||
firm_phon | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | 800-468-2274 | |||||||||||||||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
sig_date | 2016-10-26 00:00:00 | 2017-07-26 00:00:00 | 2017-04-26 00:00:00 | 2017-01-25 00:00:00 | 2017-10-29 00:00:00 | 2018-04-29 00:00:00 | 2018-07-27 00:00:00 | 2018-01-27 00:00:00 | 2019-04-28 00:00:00 | 2019-07-28 00:00:00 | 2019-01-31 00:00:00 | 2018-10-29 00:00:00 | 2020-01-30 00:00:00 | 2019-10-27 00:00:00 | 2020-04-30 00:00:00 | 2021-01-29 00:00:00 | 2020-07-31 00:00:00 | 2020-10-29 00:00:00 | 2021-07-30 00:00:00 | 2021-04-30 00:00:00 | 2021-10-29 00:00:00 | 2022-04-29 00:00:00 | 2022-07-31 00:00:00 | 2022-01-29 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||
sig_loc | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | Scottsdale Arizona | |||||||||||||||||||||||||
sig_naml | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | |||||||||||||||||||||||||
sig_namf | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra Irizarry | Myra | Myra | Myra | Myra | Myra | |||||||||||||||||||||||||
sig_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 | |||||||||||||||||||||||||
sig_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 | |||||||||||||||||||||||||
prn_naml | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | Irizarry Reddy | |||||||||||||||||||||||||
prn_namf | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra | Myra Irizarry | Myra | Myra | Myra | Myra | Myra | |||||||||||||||||||||||||
prn_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 | |||||||||||||||||||||||||
prn_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 | |||||||||||||||||||||||||
sig_title | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Director of Government Affairs | Government Affairs Director | Director of Government Affairs | Director of Government Affairs | Director of Government Affairs | Director of Government Affairs | Director of Government Affairs | Director of Government Affairs | Director of Government Affairs | Director of Government Affairs | Director of Government Affairs | Director of Government Affairs | Director of Government Affairs | |||||||||||||||||||||||||
nopart1_cb | None | None | None | None | None | None | None | None | None | None | 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 | 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 | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
lby_actvty | Legislature: AB 1513; Wages and Hourly Issues; Employee Classification. Department of Industrial Relations: Employee Classification. | Legislature: AB 1575; SB 490; SB 640. | Legislature: SB 490 and SB 640. | Legislature: Wages and Hourly Issues. | Legislature: AB 1575; SB 490; SB 640. | Legislature: AB 1575; SB 640. | Legislature: AB 1575; SB 999. | Legislature: AB 1575; SB 490; SB 640. | Legislature: AB 5. | Legislature: AB 5. | Legislature: AB 1575; SB 999. | Legislature: AB 1575; SB 999. | Legislature: AB 5. | Legislature: AB 5. | Legislature: AB 5; AB 1850; AB 2465; SB 607; SB 873; SB 900; SB 1465. | Legislature: AB 1850; AB 2257; AB 2465; SB 607; SB 873; SB 900; SB 1465. | Legislature: AB 1850; AB 2465; SB 607; SB 873; SB 900; SB 1465. | Legislature: AB 1850; AB 2257; AB 2465; SB 607; SB 873; SB 900; SB 1465. | Legislature: SB 803. Governors Office: COVID-19 issues. | Governors Office: COVID-19 issues. | Legislature: SB 803. Governors Office: COVID-19 issues. | Governors Office: COVID-19 issues. | Legislature: AB 2196. Governors Office: COVID-19 issues. | Legislature: SB 803. Governors Office: COVID-19 issues. | Legislature: AB 2196. Governors Office: COVID-19 issues. | |||||||||||||||||||||||||
lobby_n_cb | None | None | None | None | None | None | None | None | None | None | 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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None |
filing_id | 2065365 | 2114867 | 2330624 | 2539139 | ||||
---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | ||||
rec_type | CVR | CVR | CVR | CVR | ||||
form_type | F602 | F602 | F602 | F602 | ||||
sender_id | F00729 | F00729 | F00729 | F00729 | ||||
filer_id | 1387089 | 1387089 | 1387089 | 1387089 | ||||
entity_cd | LEM | LEM | LEM | LEM | ||||
filer_naml | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | ||||
filer_namf | None | None | None | None | ||||
filer_namt | None | None | None | None | ||||
filer_nams | None | None | None | None | ||||
report_num | 000 | 000 | 000 | 000 | ||||
rpt_date | 2016-06-30 00:00:00 | 2016-11-17 00:00:00 | 2018-11-27 00:00:00 | 2020-11-19 00:00:00 | ||||
ls_beg_yr | 2015 | 2017 | 2019 | 2021 | ||||
ls_end_yr | 2016 | 2018 | 2020 | 2022 | ||||
qual_date | None | None | None | None | ||||
eff_date | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||
bus_city | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | ||||
bus_st | AZ | AZ | AZ | AZ | ||||
bus_zip4 | 85254 | 85254 | 85254 | 85254 | ||||
bus_phon | (800) 468-2274 | (800) 468-2274 | (800) 468-2274 | (800) 468-2274 | ||||
bus_fax | None | None | None | None | ||||
bus_email | None | None | None | None | ||||
mail_city | None | None | None | None | ||||
mail_st | None | None | None | None | ||||
mail_zip4 | None | None | None | None | ||||
mail_phon | None | None | None | None | ||||
sig_date | 2016-06-30 00:00:00 | 2016-11-17 00:00:00 | 2018-11-27 00:00:00 | 2020-11-19 00:00:00 | ||||
sig_loc | SCOTTSDALE, AZ | SCOTTSDALE, AZ | SCOTTSDALE, AZ | SCOTTSDALE, AZ | ||||
sig_naml | IRIZARRY REDDY | IRIZARRY REDDY | IRIZARRY REDDY | IRIZARRY REDDY | ||||
sig_namf | MYRA | MYRA | MYRA | MYRA | ||||
sig_namt | None | None | None | None | ||||
sig_nams | None | None | None | None | ||||
prn_naml | IRIZARRY REDDY | IRIZARRY REDDY | IRIZARRY REDDY | IRIZARRY REDDY | ||||
prn_namf | MYRA | MYRA | MYRA | MYRA | ||||
prn_namt | None | None | None | None | ||||
prn_nams | None | None | None | None | ||||
sig_title | GOVERNMENT AFFAIRS DIRECTOR | GOVERNMENT AFFAIRS DIRECTOR | GOVERNMENT AFFAIRS DIRECTOR | GOVERNMENT AFFAIRS DIRECTOR | ||||
stmt_firm | None | None | None | None | ||||
ind_cb | None | None | None | None | ||||
bus_cb | X | X | None | None | ||||
trade_cb | None | None | X | X | ||||
oth_cb | None | None | None | None | ||||
a_b_name | None | None | None | None | ||||
a_b_city | None | None | None | None | ||||
a_b_st | None | None | None | None | ||||
a_b_zip4 | None | None | None | None | ||||
descrip_1 | PROFESSIONAL BEAUTY INDUSTRY | PROFESSIONAL BEAUTY INDUSTRY | PROFESSIONAL BEAUTY INDUSTRY | PROFESSIONAL BEAUTY INDUSTRY | ||||
descrip_2 | None | None | None | None | ||||
c_less50 | None | None | None | None | ||||
c_more50 | None | None | X | X | ||||
ind_class | None | None | None | None | ||||
ind_descr | None | None | None | None | ||||
bus_class | OTH | OTH | OTH | OTH | ||||
bus_descr | PROFESSIONAL BEAUTY INDUSTRY | PROFESSIONAL BEAUTY INDUSTRY | PROFESSIONAL BEAUTY INDUSTRY | PROFESSIONAL BEAUTY INDUSTRY | ||||
auth_name | CALIFORNIA ADVOCATES , INC. | CALIFORNIA ADVOCATES , INC. | CALIFORNIA ADVOCATES , INC. | CALIFORNIA ADVOCATES , INC. | ||||
auth_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||
auth_st | CA | CA | CA | CA | ||||
auth_zip4 | 95814 | 95814 | 95814 | 95814 | ||||
lobby_int | None | None | None | None | ||||
influen_yn | None | None | None | None | ||||
firm_name | None | None | None | None | ||||
newcert_cb | None | None | None | None | ||||
rencert_cb | None | None | None | None | ||||
complet_dt | None | None | None | None | ||||
lby_reg_cb | None | None | None | None | ||||
lby_604_cb | None | None | None | None | ||||
st_leg_yn | None | None | None | None | ||||
st_agency | None | None | None | None | ||||
lobby_cb | None | None | None | None | ||||
l_firm_cb | None | None | None | None |
filer_id | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | |||||
---|---|---|---|---|---|---|---|---|---|---|
adrid | 2401117 | 2416975 | 2552061 | 2508495 | 2468799 | |||||
effect_dt | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | |||||
session_id | 2015 | 2017 | 2023 | 2021 | 2019 |
filer_id | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2330624 | 2206623 | 2394398 | 2378131 | 2240253 | 2347083 | 2191518 | 2054722 | 2065365 | 2054726 | 2096043 | 2123074 | 2114867 | 2153621 | 2143676 | 2171620 | 2315309 | 2415924 | 2485025 | 2470382 | 2550489 | 2440023 | 2526684 | 2270931 | 2539139 | 2363379 | 2674727 | 2580343 | 2622135 | 2573339 | 2600659 | 2705547 | 2641862 | 2748849 | ||||||||||||||||||||||||||||||||||
period_id | 236 | 232 | 238 | 237 | 233 | 236 | 231 | None | 226 | None | 227 | 228 | 228 | 229 | None | 230 | 235 | 239 | 242 | 241 | 244 | 240 | 243 | 234 | 244 | None | 249 | 245 | 247 | None | 246 | 250 | 248 | 251 | ||||||||||||||||||||||||||||||||||
form_id | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F999 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
filing_date | 2018-12-28 00:00:00 | 2018-01-27 00:00:00 | 2019-07-28 00:00:00 | 2019-04-28 00:00:00 | 2018-04-29 00:00:00 | 2019-01-31 00:00:00 | 2017-10-29 00:00:00 | 2016-07-12 00:00:00 | 2016-08-03 00:00:00 | 2016-07-12 00:00:00 | 2016-10-26 00:00:00 | 2017-01-25 00:00:00 | 2016-12-29 00:00:00 | 2017-04-26 00:00:00 | 2016-12-29 00:00:00 | 2017-07-26 00:00:00 | 2018-10-29 00:00:00 | 2019-10-27 00:00:00 | 2020-07-31 00:00:00 | 2020-04-30 00:00:00 | 2021-01-29 00:00:00 | 2020-01-30 00:00:00 | 2020-10-29 00:00:00 | 2018-07-27 00:00:00 | 2020-12-29 00:00:00 | 2018-12-28 00:00:00 | 2022-04-29 00:00:00 | 2021-04-30 00:00:00 | 2021-10-29 00:00:00 | 2020-12-30 00:00:00 | 2021-07-30 00:00:00 | 2022-07-31 00:00:00 | 2022-01-29 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||
session_id | 2019 | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||
user_id | YRODRIGU | AGLADNEY | SUSHAKOV | SUSHAKOV | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | CAFILER | GPEREZ | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | SUSHAKOV | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | AGLADNEY | AROJAS | YRODRIGU | CAFILER | GTAYLOR | GTAYLOR | AROJAS | MKIRKHAM | CAFILER | RATTIYEH | CAFILER | ||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||
rpt_start | 2018-11-27 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-10-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 2016-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-17 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-07-01 00:00:00 | 2018-04-01 00:00:00 | 2020-11-19 00:00:00 | 1900-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||
rpt_end | 2018-11-27 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2018-03-31 00:00:00 | 2018-12-31 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2016-11-17 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-09-30 00:00:00 | 2018-06-30 00:00:00 | 2020-11-19 00:00:00 | 1900-01-01 00:00:00 | 2022-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2021-12-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 | 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 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 |
filer_id | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | |||||
---|---|---|---|---|---|---|---|---|---|---|
session_id | 2019 | 2017 | 2021 | 2015 | 2023 | |||||
interest_cd | 40312 | 40312 | 40312 | 40312 | 40312 | |||||
effect_date | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2016-07-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | |||||
---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | |||||
active | Y | Y | Y | Y | N | |||||
race | None | None | None | 0 | None | |||||
session_id | 2017 | 2019 | 2021 | 2015 | 2023 | |||||
category | None | None | None | 0 | None | |||||
category_type | None | None | None | 0 | None | |||||
sub_category | None | None | None | 0 | None | |||||
effect_dt | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2016-07-01 00:00:00 | 2023-01-01 00:00:00 | |||||
sub_category_type | None | None | None | 0 | None | |||||
election_type | None | None | None | 0 | None | |||||
sub_category_a | None | None | None | None | None | |||||
nyq_dt | None | None | None | None | None | |||||
party_cd | None | None | None | 0 | None | |||||
county_cd | None | None | None | 0 | None | |||||
district_cd | None | None | None | 0 | None |
filer_id | 1387089 | |
---|---|---|
xref_id | 1387089 | |
effect_dt | 2016-07-13 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | |||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | 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 | 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 | 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 | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | PROFESSIONAL BEAUTY ASSOCIATION | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
city | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | SCOTTSDALE | |||||||||||||||||||||||||
st | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | AZ | |||||||||||||||||||||||||
zip4 | 85254 | 85254 | 85254 | 85260 | 85260 | 85254 | 85254 | 85254 | 85260 | 85260 | 85254 | 85254 | 85254 | 85260 | 85260 | 85254 | 85254 | 85254 | 85260 | 85260 | 85254 | 85254 | 85254 | 85260 | 85260 | |||||||||||||||||||||||||
phon | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | 8004682274 | |||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1387089 |
---|
filer_id | 1387089 | |
---|---|---|
change_no | 0 | |
session_id | 2015 | |
log_dt | 2016-07-12 00:00:00 | |
filer_type | 1 | |
correction_flg | None | |
action | ADDED | |
attribute_changed | FIRM | |
ethics_dt | None | |
interests | None | |
filer_full_name | PROFESSIONAL BEAUTY ASSOCIATION | |
filer_city | None | |
filer_st | None | |
filer_zip | None | |
filer_phone | None | |
entity_type | 3 | |
entity_name | CALIFORNIA ADVOCATES, INC. | |
entity_city | None | |
entity_st | None | |
entity_zip | None | |
entity_phone | None | |
entity_id | 1147277 | |
responsible_officer | None | |
effect_dt | 2016-07-01 00:00:00 |
filer_id | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | 1387089 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 178208.cal | 117385.cal | 146132.cal | 117178.cal | 182260.cal | 167207.cal | 187762.cal | 178467.cal | 185313.cal | |||||||||
received_date | 2022-10-31 00:00:00 | 2022-10-30 00:00:00 | 2022-10-31 00:00:00 | 2022-10-30 00:00:00 | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | |||||||||
filing_directory | /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/temp | |||||||||
filing_id | None | None | None | None | None | None | None | None | None | |||||||||
form_id | None | None | None | None | None | None | None | None | None | |||||||||
receive_comment | 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 passed validation, but failed DB constraints |