ar_disbursements_emp_off

where rpt_id = 240415

✎ 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
978396 601 BLAINE   DAVIDSON PRESIDENT C 111110 0 0 0 111110 65 3 2 10 20 240415 240415  
978397 601 THOMAS G TAYLOR VICE PRESIDENT C 80103 0 0 0 80103 95 0 0 0 5 240415 240415  
978398 601 MARILYN   BRYAN RECORDING CORR. SECRETARY C 72589 0 1800 0 74389 25 0 0 5 70 240415 240415  
978399 601 TERRY A WEAVER TREASURER C 0 0 0 0 0 0 0 0 0 100 240415 240415  
978400 601 JACK   PANCAKE TRUSTEE C 0 0 1158 0 1158 0 0 0 0 100 240415 240415  
978401 601 GREG   BURGESS AUDITOR C 0 0 1158 0 1158 0 0 0 0 100 240415 240415  
978402 601 DAVID W JOHNSON AUDITOR N 0 0 1158 0 1158 0 0 0 0 100 240415 240415  
978403 601 MARC E DOWNS AUDITOR N 73760 0 0 0 73760 100 0 0 0 0 240415 240415  
978404 601 DONALD   WIRTH TRUSTEE C 0 0 1158 0 1158 0 0 0 0 100 240415 240415  
978405 601 THOMAS   RIDGE CONDUCTOR C 76839 0 0 0 76839 95 2 0 0 3 240415 240415  
978406 601 ROBERT   MURPHY GUARD C 75070 0 0 0 75070 95 0 0 0 5 240415 240415  
978407 601 VANCE   SNEDEKER TRUSTEE C 73749 0 0 0 73749 100 0 0 0 0 240415 240415  
978408 601 GEORGE   REFFETT CONDUCTOR P 6599 0 0 0 6599 100 0 0 0 0 240415 240415  
978409 601 MARLIN   CHAMBERS FINANCIAL SECRETARY C 87304 0 0 0 87304 75 0 0 0 25 240415 240415  
978410 602 VARINE N GILHAM BUSINESS AGENT None 73959 0 0 0 73959 100 0 0 0 0 240415 240415  
978411 602 JOHN P PIERSON ORGANIZER None 980 0 0 0 980 100 0 0 0 0 240415 240415  
978412 602 CORINNE N THIEDE SECRETARY None 39108 0 0 0 39108 80 0 0 0 20 240415 240415  
978413 602 JOAN E CORK SECRETARY None 39108 0 0 0 39108 20 5 0 25 50 240415 240415  
978414 602 JERRY W CHARLEY BUSINESS AGENT None 73874 0 0 0 73874 100 0 0 0 0 240415 240415  
978415 602 JERRY L GOODMAN JANITOR None 1650 0 2750 0 4400 0 0 0 100 0 240415 240415  
978416 602 RAYMOND L JENKINS JANITOR None 48244 0 2040 0 50284 0 0 0 95 5 240415 240415  
978417 602 CATHY   BALLOCK SECRETARY None 39108 0 0 0 39108 20 0 5 30 45 240415 240415  
978418 602 JOHN D MOORE BUSINESS AGENT None 73774 0 0 0 73774 100 0 0 0 0 240415 240415  
978419 602 KRISTY   WAMSLEY SECRETARY None 39108 0 0 0 39108 15 0 0 0 85 240415 240415  
978420 604           0 0 0 0 0 0 0 0 0 0 240415 240415   
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)
);