ar_disbursements_emp_off

where rpt_id = 463438

✎ 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
2729506 601 DOUGLAS   WISEMAN PRESIDENT N 16424 0 4962 0 21386 64 0 0 0 36 463438 463438  
2729507 601 MARGARET   VENTIMIGL SECRETARY/TREASURER C 34461 0 1217 0 35678 0 0 0 0 100 463438 463438  
2729508 601 LARRY   BARRONS RECORDING SECRETARY N 660 0 833 0 1493 100 0 0 0 0 463438 463438  
2729509 601 ROBERT   FLETCHER VICE PRESIDENT N 463 0 893 0 1356 100 0 0 0 0 463438 463438  
2729510 601 FLORENCE   WASHINGTON VICE PRESIDENT N 849 0 1232 0 2081 100 0 0 0 0 463438 463438  
2729511 601 IRENE   ROSSI SEC/TREASURER EMERITUS P 0 0 75 0 75 100 0 0 0 0 463438 463438  
2729512 601 KEITH   FIELDER     598 0 561 0 1159 100 0 0 0 0 463438 463438  
2729513 601 RICHARD   LOCKWOOD 1541   1541 0 1109 0 2650 100 0 0 0 0 463438 463438  
2729514 604           3392 0 0 0 3392 100 0 0 0 0 463438 463438   
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)
);