ar_disbursements_emp_off

where rpt_id = 247499

✎ 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
1064034 601 MATTHEW P CARROLL PRESIDENT C 4372 0 159 0 4531 11 0 0 0 89 247499 247499  
1064035 601 RAYMOND A EGELHOFF BUSINESS MANAGER C 96230 0 4103 780 101113 56 4 0 23 17 247499 247499  
1064036 601 RICHARD   MURRAY EXECUTIVE BOARD C 1557 0 0 0 1557 51 0 0 0 49 247499 247499  
1064037 601 STEPHEN   NORMAND EXECUTIVE BOARD P 25 0 14 0 39 0 0 0 0 100 247499 247499  
1064038 601 WILLIAM   POWER EXECUTIVE BOARD P 1022 0 0 0 1022 0 0 0 0 100 247499 247499  
1064039 601 DOUGLAS D WITT VICE PRESIDENT C 2331 0 0 0 2331 0 0 0 9 91 247499 247499  
1064040 601 CHESTER L DENNIS EXECUTIVE BOARD C 25 0 45 0 70 0 0 0 0 100 247499 247499  
1064041 601 WILLIAM E YEAZEL EXECUTIVE BOARD C 50 0 0 0 50 0 0 0 0 100 247499 247499  
1064042 601 SHELLEY R HINES RECORDING SECRETARY C 2470 0 0 0 2470 70 0 0 0 30 247499 247499  
1064043 601 CONNIE J BUELER TREASURER C 900 0 0 0 900 0 0 0 0 100 247499 247499  
1064044 601 DALE   PIATZ EXECUTIVE BOARD N 75 0 115 0 190 0 0 0 0 100 247499 247499  
1064045 602 MONICA L AGOSTINELLI OFFICE None 15769 0 0 0 15769 11 0 0 79 10 247499 247499  
1064046 602 GARY L BUCK BUSINESS REPRESENTATIVE None 18148 0 45 0 18193 100 0 0 0 0 247499 247499  
1064047 602 FRED M DENHAM BUSINESS REPRESENTATIVE None 24233 0 0 0 24233 62 0 0 37 1 247499 247499  
1064048 602 KIM M DUNCAN OFFICE None 24033 0 0 0 24033 27 0 0 66 7 247499 247499  
1064049 602 THERESA A DUNCAN OFFICE None 25246 0 0 0 25246 23 0 0 45 32 247499 247499  
1064050 602 JOHN W ELLIOTT BUSINESS REPRESENTATIVE None 82486 0 0 780 83266 55 0 0 16 29 247499 247499  
1064051 602 PATRICIA A JONES BOOKKEEPER None 43299 0 0 0 43299 14 0 0 74 12 247499 247499  
1064052 604           12473 0 983 0 13456 72 20 0 0 8 247499 247499   
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)
);