ar_disbursements_emp_off

where rpt_id = 248438

✎ 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
1077532 601 JOHN   HUFF BUSINESS MANAGER C 5082 0 734 0 5816 0 0 0 0 100 248438 248438  
1077533 601 WARREN   CONDE PRESIDENT C 3629 0 0 0 3629 0 0 0 0 100 248438 248438  
1077534 601 CHARLES   BLOODWORTH VICE PRESIDENT C 5022 0 0 0 5022 0 0 0 0 100 248438 248438  
1077535 601 RICK   WHITTEY WARDEN C 4356 0 0 0 4356 0 0 0 0 100 248438 248438  
1077536 601 DONNY   FAULCONER RECORDING SECRETARY C 3750 0 0 0 3750 0 0 0 0 100 248438 248438  
1077537 601 ANTHONY   PERRI TRUSTEE C 3568 0 0 0 3568 0 0 0 0 100 248438 248438  
1077538 601 JOHN   JUAREZ TRUSTEE C 5022 0 0 0 5022 0 0 0 0 100 248438 248438  
1077539 601 GONZALO   LUNA TRUSTEE C 3509 0 0 0 3509 0 0 0 0 100 248438 248438  
1077540 601 MARK   HARDING DELEGATE C 2361 0 0 0 2361 0 0 0 0 100 248438 248438  
1077541 601 MICHELE   RODRIGUEZ MENTORING C 665 0 0 0 665 0 0 0 0 100 248438 248438  
1077542 601 TIMOTHY   REPLOGLE CONDUCTOR C 3689 175 0 0 3864 0 0 0 0 100 248438 248438  
1077543 601 TOMMY   DUNFORD ALTERNATE C 1211 0 0 0 1211 0 0 0 0 100 248438 248438  
1077544 601 CESAR   VALENZUELA MENTORING N 61 0 0 0 61 0 0 0 0 100 248438 248438  
1077545 601 KEVIN   REISLER STEWARD C 120 25 0 0 145 0 0 0 0 100 248438 248438  
1077546 602 LORRIE K HUFF SECRETARY NONE 54066 250 0 0 54316 0 0 0 100 0 248438 248438  
1077547 602 SANDRA L PARELLI SECRETARY NONE 53777 250 0 0 54027 0 0 0 100 0 248438 248438  
1077548 604           0 0 0 0 0 0 0 0 0 0 248438 248438   
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)
);