ar_disbursements_emp_off

where rpt_id = 228896

✎ 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
935316 601 JAMES S ALGER PRESIDENT C 0 500 0 0 500 0 0 0 0 100 228896 228896  
935317 601 VITCHEL   HEMINGWAY VICE PRESIDENT C 0 280 0 0 280 0 0 0 0 100 228896 228896  
935318 601 DONALD G ANSLOW JR RECORDING SECRETARY C 0 500 0 0 500 0 0 0 0 100 228896 228896  
935319 601 JOHN R DONOGHUE JR SECRETARY / TREASURER C 43484 0 3656 381 47521 60 0 0 0 40 228896 228896  
935320 601 RAYMOND   JESSEY BUSINESS MANAGER C 55907 0 3656 254 59817 20 0 0 0 80 228896 228896  
935321 601 CLARENCE   HEMINGWAY SGT-AT-ARMS C 0 160 0 0 160 0 0 0 0 100 228896 228896  
935322 601 SHERWOOD E ROBARE AUDITOR P 0 0 0 0 0 0 0 0 0 100 228896 228896  
935323 601 DAVID   MURCHISON AUDITOR N 0 40 0 0 40 0 0 0 0 100 228896 228896  
935324 601 JAMES   SPOONER AUDITOR C 0 60 0 0 60 0 0 0 0 100 228896 228896  
935325 601 JUDY   GUDZ AUDITOR P 0 20 0 0 20 0 0 0 0 100 228896 228896  
935326 601 RONNIE   MORRISON AUDITOR N 0 0 0 0 0 0 0 0 0 100 228896 228896  
935327 601 STACY   SPOONER EXECUTIVE BOARD C 0 400 0 0 400 0 0 0 0 100 228896 228896  
935328 601 JEFFREY   ALEXANDER EXECUTIVE BOARD C 0 160 0 0 160 0 0 0 0 100 228896 228896  
935329 602 MABEL   LAMERE SECRETARY / BOOKKEEPER C 20840 0 0 0 20840 0 0 0 100 0 228896 228896  
935330 604           0 0 0 0 0 0 0 0 0 0 228896 228896   
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)
);