ar_disbursements_emp_off

where rpt_id = 267819

✎ 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
1172333 601 MARIE   ROBBINS PRESIDENT C 60713 0 0 0 60713 0 0 0 100 0 267819 267819  
1172334 601 WAYNE   PARKER VICE-PRESIDENT C 34709 0 0 0 34709 0 0 0 100 0 267819 267819  
1172335 601 BARRY   SHAPIRO TREASURER C 7190 0 0 0 7190 0 0 0 100 0 267819 267819  
1172336 601 JANELLE   SPARKS SECRETARY C 1300 0 0 0 1300 0 0 0 100 0 267819 267819  
1172337 601 KEVIN   YOUNG CLERK CRAFT DIRECTOR C 6459 0 0 0 6459 0 0 0 100 0 267819 267819  
1172338 601 ROY   WILSON MAINTENANCE CRAFT DIRECT C 1200 0 0 0 1200 0 0 0 100 0 267819 267819  
1172339 601 GARY   HAMRICK RESEARCH & EDUCATION C 3000 0 0 0 3000 0 0 0 100 0 267819 267819  
1172340 601 EILEEN   MEGINLEY HUMAN RELATIONS C 1452 0 0 0 1452 0 0 0 100 0 267819 267819  
1172341 601 GARY   LEONARD LEGISLATION DIRECTOR C 229 0 0 0 229 0 0 0 100 0 267819 267819  
1172342 601 LEON   GRIMES MVS/SPECIAL DELIVERY C 1200 0 0 0 1200 0 0 0 100 0 267819 267819  
1172343 602 MAUREEN   KELLNER SECRETARY N/A 39748 0 0 0 39748 0 0 0 100 0 267819 267819  
1172344 604           0 0 0 0 0 0 0 0 0 0 267819 267819   
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)
);