ar_disbursements_emp_off
where rpt_id = 82670
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
825325 | 601 | ANNA | KAUFFMAN | PRESIDENT | N | 0 | 0 | 0 | 82670 82670 | 1 | ||||||||
825326 | 601 | MICHAEL | MARKIELOWSKI | VICE PRESIDENT | N | 0 | 0 | 0 | 82670 82670 | 2 | ||||||||
825327 | 601 | WILLIAM | POFF | TREASURER | C | 3600 | 0 | 3600 | 82670 82670 | 3 | ||||||||
825328 | 601 | RICHARD | HAKOLA | TRUSTEE | C | 153 | 0 | 153 | 82670 82670 | 4 | ||||||||
825329 | 601 | RAY | BLOOM | TRUSTEE | C | 149 | 0 | 149 | 82670 82670 | 5 | ||||||||
825330 | 601 | LESLIE | HAYES | TRUSTEE | C | 136 | 0 | 136 | 82670 82670 | 6 |
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) );