ar_disbursements_emp_off
where rpt_id = 248186
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076436 | 601 | JESSE GLEN | PANNELL JR | PRESIDENT | P | 0 | 600 | 0 | 0 | 600 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | ||
1076437 | 601 | DENNIS | R | HARRAH | PRESIDENT | N | 0 | 150 | 0 | 0 | 150 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | |
1076438 | 601 | DENNIS | R | HARRAH | VICE-PRESIDENT | P | 0 | 475 | 0 | 0 | 475 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | |
1076439 | 601 | TIMOTHY | MAXWELL | VICE-PRESIDENT | N | 0 | 135 | 0 | 0 | 135 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | ||
1076440 | 601 | CURTIS | MORGAN | FINANCIAL SECRETARY | C | 0 | 795 | 0 | 0 | 795 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | ||
1076441 | 601 | FRED | ESPINOZA | CONDUCTOR | C | 0 | 325 | 0 | 0 | 325 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | ||
1076442 | 601 | SHAWN | SMITH | RECORDING SECRETARY | C | 0 | 1395 | 0 | 0 | 1395 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | ||
1076443 | 601 | RAYMOND | SANDOVAL | TRUSTEE | C | 0 | 300 | 0 | 0 | 300 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | ||
1076444 | 601 | SANDY | MARQUEZ | TRUSTEE | C | 0 | 300 | 0 | 0 | 300 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | ||
1076445 | 601 | TERRY | SMIT | TRUSTEE | C | 0 | 400 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | ||
1076446 | 601 | TONY | CASTILLO | WARDEN | C | 0 | 875 | 0 | 0 | 875 | 0 | 0 | 0 | 0 | 100 | 248186 248186 | ||
1076447 | 602 | CHERYL | A | SOARES | OFFICE MANAGER/BOOKKEEPER | NON | 46116 | 0 | 0 | 737 | 46853 | 0 | 0 | 0 | 95 | 5 | 248186 248186 | |
1076448 | 604 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 248186 248186 |
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) );