ar_disbursements_emp_off

where rpt_id = 247892

✎ 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
1074629 601 KYLE G BROWN BUSINESS MANAGER C 110209 0 10969 0 121178 70 5 5 5 15 247892 247892  
1074630 601 PHIL   DISERIO PRESIDENT / ORGANIZER N 81984 0 6680 0 88664 85 10 0 0 5 247892 247892  
1074631 601 LARRY   CLINE VICE PRESIDENT C 0 0 50 0 50 100 0 0 0 0 247892 247892  
1074632 601 DANIEL   KELLY TREASURER N 300 0 30 0 330 100 0 0 0 0 247892 247892  
1074633 601 JASON   JENKINS SECRETARY N 639 0 0 0 639 100 0 0 0 0 247892 247892  
1074634 602 REBECCA   BIONDILLO OFFICE SECRETARY N/A 25045 0 0 0 25045 0 0 0 0 100 247892 247892  
1074635 602 JUDY   PRICE OFFICE SECRETARY N/A 19360 0 0 0 19360 0 0 0 0 100 247892 247892  
1074636 604           2778 0 4010 0 6788 0 0 0 0 100 247892 247892   
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)
);