ar_disbursements_emp_off
where rpt_id = 238611
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
971855 | 601 | ADRAIN | ALLMAN | TREASURER | C | 2401 | 2400 | 28 | 0 | 4829 | 25 | 0 | 0 | 0 | 75 | 238611 238611 | ||
971856 | 601 | JAMES | BROWN | DIRECTOR | C | 2201 | 2100 | 0 | 0 | 4301 | 100 | 0 | 0 | 0 | 0 | 238611 238611 | ||
971857 | 601 | JUDY | GONZALES | DIRECTOR | C | 1835 | 2100 | 112 | 0 | 4047 | 100 | 0 | 0 | 0 | 0 | 238611 238611 | ||
971858 | 601 | ROGER | GONZALES | DIRECTOR | C | 371 | 2100 | 49 | 0 | 2520 | 0 | 0 | 0 | 0 | 100 | 238611 238611 | ||
971859 | 601 | MICHAEL | GRIFFITH | DIRECTOR | C | 8472 | 2100 | 3666 | 0 | 14238 | 100 | 0 | 0 | 0 | 0 | 238611 238611 | ||
971860 | 601 | JEFFREY | KOPPELMAN | DIRECTOR | C | 952 | 2100 | 11 | 0 | 3063 | 100 | 0 | 0 | 0 | 0 | 238611 238611 | ||
971861 | 601 | DORIS | ORR | DIRECTOR | C | 3649 | 2100 | 478 | 0 | 6227 | 100 | 0 | 0 | 0 | 0 | 238611 238611 | ||
971862 | 601 | LINDA | WATSON-PIERLE | DIRECTOR | C | 1652 | 1925 | 385 | 0 | 3962 | 100 | 0 | 0 | 0 | 0 | 238611 238611 | ||
971863 | 601 | EDWARD | WHITE | DIRECTOR | C | 2112 | 2100 | 913 | 0 | 5125 | 100 | 0 | 0 | 0 | 0 | 238611 238611 | ||
971864 | 601 | KIMBERLY | SPRAGUE | PRESIDENT | C | 55751 | 0 | 0 | 0 | 55751 | 25 | 0 | 0 | 25 | 50 | 238611 238611 | ||
971865 | 602 | SHARRONDA | WILLIAMS | ADMIN. ASSISTANT | None | 24919 | 0 | 28 | 0 | 24947 | 0 | 0 | 0 | 0 | 100 | 238611 238611 | ||
971866 | 604 | 18904 | 0 | 2615 | 0 | 21519 | 50 | 0 | 0 | 0 | 50 | 238611 238611 |
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) );