ar_disbursements_emp_off

where rpt_id = 76104

✎ 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
812190 601 WILLIAM   RATHGABER PRESIDENT C 2797     4134 6931           76104 76104 1
812191 601 RANDALL   THOMPSON VICE PRESIDENT C 4264     4511 8775           76104 76104 2
812192 601 DANIEL   CHESTER TREASURER C 0     721 721           76104 76104 3
812193 601 TIM   WARE SECRETARY N 0     639 639           76104 76104 4
812194 601 MIKE   REED VICE PRESIDENT P 482     1998 2480           76104 76104 5 
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)
);