ar_disbursements_emp_off

where rpt_id = 247962

✎ 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
1074710 601 ROBERT   ALLEN FINANCIAL SEC/TREASURER C 55192 0 17149 0 72341 62 0 0 3 35 247962 247962  
1074711 601 JERRY   WILLIAMSN RECORDING SECRETARY C 525 0 60 0 585 0 0 0 0 100 247962 247962  
1074712 601 WALTER   ALLEN VICE PRESIDENT C 801 0 0 0 801 0 0 0 0 100 247962 247962  
1074713 601 LARRY   BROWN PRESIDENT C 4328 0 559 0 4887 50 0 0 0 50 247962 247962  
1074714 602 BONNIE   LIPTAK SECRETARY N/A 42548 0 175 0 42723 0 0 0 100 0 247962 247962  
1074715 604           9769 0 0 0 9769 0 0 0 100 0 247962 247962   
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)
);