ar_disbursements_emp_off

where rpt_id = 248046

✎ 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
1075245 601 DOUG   TRASK FINANCIAL SECRETARY C 56146 0 38516 0 94662 40 20 2 8 30 248046 248046  
1075246 601 JOHN   EVANS PRESIDENT C 47254 0 5623 0 52877 50 10 0 20 20 248046 248046  
1075247 601 TIMOTHY   LITCHFIELD REC-SECR/VICE PRES C 0 0 0 0 0 5 40 25 5 25 248046 248046  
1075248 601 BRONSON   RICK VICE PRESIDENT P 0 0 0 0 0 5 40 25 5 25 248046 248046  
1075249 601 PROVOST   GORDON EBOARD P 0 0 0 0 0 5 40 25 5 25 248046 248046  
1075250 601 DENIS   LUCE EBOARD P 0 0 0 0 0 5 40 25 5 25 248046 248046  
1075251 601 JEFF   MITCHELL EBOARD P 0 0 0 0 0 5 40 25 5 25 248046 248046  
1075252 601 SCOTT   HOPKINS EBOARD N 0 0 0 0 0 5 40 25 5 25 248046 248046  
1075253 601 SCOTT   DAVIS E-BOARD N 0 0 0 0 0 5 40 25 5 25 248046 248046  
1075254 601 TOM   WAGNER E-BOARD N 0 0 0 0 0 5 40 25 5 25 248046 248046  
1075255 601 RON   FLENELLYN E-BOARD N 0 0 0 0 0 5 40 25 5 25 248046 248046  
1075256 601 MATT   KIRK E-BOARD N 0 0 0 0 0 5 40 25 5 25 248046 248046   
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)
);