ar_disbursements_emp_off

where rpt_id = 463591

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ emp_off_type first_name middle_name last_name title status_other_payer gross_salary allowances official_business other_not_rptd total rep_pct pol_pct cont_pct gen_ovrhd_pct admin_pct rpt_id item_num
2730095 601 ARLEEN   RIVERA PRESIDENT C 0 0 2555 0 2555 100 0 0 0 0 463591 463591  
2730096 601 DOROTHY   WILIAMS VICE-PRESIDENT C 0 0 230 0 230 100 0 0 0 0 463591 463591  
2730097 601 MANUEL   TREJO TREASURER C 0 0 30 0 30 100 0 0 0 0 463591 463591  
2730098 601 BLANCA   TREJO PARLIAMENTARIAN C 500 0 153 0 653 100 0 0 0 0 463591 463591  
2730099 601 LARA   ROSA GRIEVANCE REP. P 60 0 215 0 275 100 0 0 0 0 463591 463591  
2730100 601 SHARON   BRUCE SECRETARY N 410 0 114 0 524 100 0 0 0 0 463591 463591  
2730101 601 IRENE   GONZALEZ CHAPTER CHAIR C 500 0 0 0 500 100 0 0 0 0 463591 463591  
2730102 601 LESLIE   REYES CHAPTER CHAIR C 220 0 0 0 220 100 0 0 0 0 463591 463591  
2730103 601 KAREN   HEAPE CHAPTER CHAIR C 220 0 0 0 220 100 0 0 0 0 463591 463591  
2730104 601 MARIA   NEIRA CHAPTER CHAIR N 500 0 0 0 500 100 0 0 0 0 463591 463591  
2730105 602 PEARL   LOZANO EXECUTIVE DIRECTOR C 33900 4800 549 0 39249 75 0 0 0 25 463591 463591  
2730106 602 JO   NAVARRO BOOKKEEPER C 11400 0 243 0 11643 50 0 0 25 25 463591 463591  
2730107 604           0 0 0 0 0 0 0 0 0 0 463591 463591   
CREATE TABLE ar_disbursements_emp_off (
oid INTEGER NOT NULL PRIMARY KEY, emp_off_type INTEGER NOT NULL, first_name TEXT NULL, middle_name TEXT NULL, last_name TEXT NULL, title TEXT NULL, status_other_payer TEXT NULL, gross_salary INTEGER NULL, allowances INTEGER NULL, official_business INTEGER NULL, other_not_rptd INTEGER NULL, total INTEGER NULL, rep_pct INTEGER NULL, pol_pct INTEGER NULL, cont_pct INTEGER NULL, gen_ovrhd_pct INTEGER NULL, admin_pct INTEGER NULL, rpt_id INTEGER NULL, item_num INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id)
);