ar_disbursements_emp_off

where rpt_id = 238611

✎ 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
971855 601 ADRAIN   ALLMAN TREASURER C 2401 2400 28 0 4829 25 0 0 0 75 238611 238611  
971856 601 JAMES   BROWN DIRECTOR C 2201 2100 0 0 4301 100 0 0 0 0 238611 238611  
971857 601 JUDY   GONZALES DIRECTOR C 1835 2100 112 0 4047 100 0 0 0 0 238611 238611  
971858 601 ROGER   GONZALES DIRECTOR C 371 2100 49 0 2520 0 0 0 0 100 238611 238611  
971859 601 MICHAEL   GRIFFITH DIRECTOR C 8472 2100 3666 0 14238 100 0 0 0 0 238611 238611  
971860 601 JEFFREY   KOPPELMAN DIRECTOR C 952 2100 11 0 3063 100 0 0 0 0 238611 238611  
971861 601 DORIS   ORR DIRECTOR C 3649 2100 478 0 6227 100 0 0 0 0 238611 238611  
971862 601 LINDA   WATSON-PIERLE DIRECTOR C 1652 1925 385 0 3962 100 0 0 0 0 238611 238611  
971863 601 EDWARD   WHITE DIRECTOR C 2112 2100 913 0 5125 100 0 0 0 0 238611 238611  
971864 601 KIMBERLY   SPRAGUE PRESIDENT C 55751 0 0 0 55751 25 0 0 25 50 238611 238611  
971865 602 SHARRONDA   WILLIAMS ADMIN. ASSISTANT None 24919 0 28 0 24947 0 0 0 0 100 238611 238611  
971866 604           18904 0 2615 0 21519 50 0 0 0 50 238611 238611   
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)
);