ar_disbursements_emp_off

where rpt_id = 247835

✎ 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
1074479 601 PETER   DRISCOLL PRESIDENT C 2314 0 0 0 2314 0 0 0 82 18 247835 247835  
1074480 601 FLOYD   CASPER VICE PRESIDENT C 1629 0 0 0 1629 0 0 0 83 17 247835 247835  
1074481 601 WILLIAM   HIRSCHI TREASURER C 2638 0 0 0 2638 0 0 0 84 16 247835 247835  
1074482 601 JERRY   ERICKSON FINANCIAL SECRETARY C 2449 0 0 0 2449 0 0 0 83 17 247835 247835  
1074483 601 KENNETH   MAYNE RECORDING SECRETARY C 1629 0 0 0 1629 0 0 0 83 17 247835 247835  
1074484 601 KEITH   BROWN CONDUCTOR C 1505 0 0 0 1505 0 0 0 86 14 247835 247835  
1074485 601 RODGER   GUKEISEN WARDEN C 2091 0 0 0 2091 0 0 0 87 13 247835 247835  
1074486 601 BRUCE   BACKMAN TRSTE C 1629 0 0 0 1629 0 0 0 83 17 247835 247835  
1074487 601 PAUL   SMITH TRUSTEE N 1483 0 0 0 1483 0 0 0 91 9 247835 247835  
1074488 601 ROBERT   RASMUSSEN TRUSTEE C 1483 0 0 0 1483 0 0 0 91 9 247835 247835  
1074489 601 KEVIN   BROWN TRUSTEE P 146 0 0 0 146 0 0 0 100 0 247835 247835  
1074490 604           4919 0 0 0 4919 0 0 0 100 0 247835 247835   
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)
);