ar_disbursements_emp_off

where rpt_id = 245699

✎ 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
1047589 601 RICK   BERCHTOLD PRESIDENT C 1304 0 109 0 1413 34 3 5 0 58 245699 245699  
1047590 601 DARRELL   MOODY FIN SEC/BM C 1368 0 64 0 1432 25 10 10 0 55 245699 245699  
1047591 601 DAN   BERCHTOLD REC SEC C 640 0 0 0 640 0 5 0 0 95 245699 245699  
1047592 601 DONALD   YOUNGLOVE CONDUCTOR C 608 0 132 0 740 0 0 0 0 100 245699 245699  
1047593 601 ROBERT N GERMAN TREASURER/BA C 1386 0 336 0 1722 28 12 6 0 54 245699 245699  
1047594 601 KEVIN   TISDALE TRUSTEE C 1268 0 0 0 1268 36 0 0 0 64 245699 245699  
1047595 601 RICK   WINN TRUSTEE C 832 0 0 0 832 24 0 0 0 76 245699 245699  
1047596 601 MARK   STEGMAIER TRUSTEE C 1336 0 0 0 1336 37 0 0 0 63 245699 245699  
1047597 601 COLLEEN   BAILEY VICE PRESIDENT C 768 0 45 0 813 17 0 4 0 79 245699 245699  
1047598 601 ALAN   SCHINDLER WARDEN C 960 0 182 0 1142 26 0 4 0 70 245699 245699  
1047599 602 SHARI K HILL SECRETARY/BOOKKEEPER NA 34568 0 12 0 34580 91 0 0 4 5 245699 245699  
1047600 604           11951 0 451 0 12402 94 0 0 6 0 245699 245699   
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)
);