ar_disbursements_emp_off

where rpt_id = 248420

✎ 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
1077502 601 VINCENT   GUERTIN BUSINESS MANAGER C 98337 0 20453 0 118790 78 4 0 4 14 248420 248420  
1077503 601 JOSEPH   ROTHER TREASURER C 9779 0 50 0 9829 0 0 0 0 100 248420 248420  
1077504 601 DAVID   ERICKSON PRESIDENT C 2142 0 4960 0 7102 0 0 0 0 100 248420 248420  
1077505 601 SCOTT   DARSIE VICE PRESIDENT C 0 0 2425 0 2425 0 0 0 0 100 248420 248420  
1077506 601 PHIL   OTTENS RECORDING SECY C 0 0 8100 0 8100 0 0 0 0 100 248420 248420  
1077507 601 JANET   ZIMMER EXEC BOARD C 0 0 2443 0 2443 0 0 0 0 100 248420 248420  
1077508 601 MARK   FISCHER EXEC BOARD C 0 0 2798 0 2798 0 0 0 0 100 248420 248420  
1077509 601 DAVE   OBRIEN EXEC BOARD C 0 0 2418 0 2418 0 0 0 0 100 248420 248420  
1077510 601 JOSEPH   PAGE EXEC BOARD C 0 0 1405 0 1405 0 0 0 0 100 248420 248420  
1077511 601 SCOTT   CLOTHIER EXEC BOARD N 0 0 1106 0 1106 0 0 0 0 100 248420 248420  
1077512 602 RICHARD   OAKES BUSINESS REP N/A 83673 0 10892 0 94565 84 0 0 4 12 248420 248420  
1077513 602 RAYMOND   TURNER BUSINESS REP N/A 83673 0 14840 0 98513 80 0 0 5 15 248420 248420  
1077514 602 MARK   KAUFMAN BUSINESS REP N/A 83673 0 6615 0 90288 83 0 0 4 13 248420 248420  
1077515 602 SHARON   BREKKE OFFICE N/A 39978 0 1085 0 41063 15 0 0 0 85 248420 248420  
1077516 602 BEVERLY   SABRE OFFICE N/A 37500 0 205 0 37705 80 0 0 5 15 248420 248420  
1077517 602 ELAIN   TIEDT OFFICE N/A 42910 0 698 0 43608 78 4 0 4 14 248420 248420  
1077518 602 STEVEN L MURPHY BUSINESS REP N/A 18424 0 3671 0 22095 0 0 0 5 95 248420 248420  
1077519 602 GARY   THOMFORDE BUSINESS REP N/A 78540 0 8992 0 87532 73 2 0 5 20 248420 248420  
1077520 604           0 0 0 0 0 0 0 0 0 0 248420 248420   
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)
);