ar_disbursements_emp_off
where rpt_id = 228680
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
935259 | 601 | BRIAN | k | THOMPSON | BUSINESS MANAGER | C | 95509 | 0 | 6353 | 0 | 101862 | 85 | 5 | 0 | 0 | 10 | 228680 228680 | |
935260 | 601 | GARY | J | ALEKNAVIC | ASSISTANT BUSINESS MGR | C | 79117 | 0 | 2827 | 0 | 81944 | 85 | 5 | 0 | 5 | 5 | 228680 228680 | |
935261 | 601 | KENNETH | r | SIMS | ASSISTANT BUSINESS MGR | C | 79117 | 0 | 2226 | 0 | 81343 | 85 | 5 | 0 | 5 | 5 | 228680 228680 | |
935262 | 601 | CARL | L | BLACK | TREASURER | C | 15701 | 0 | 5810 | 0 | 21511 | 10 | 0 | 0 | 90 | 0 | 228680 228680 | |
935263 | 601 | WALTER | J | CROSSON | SECRETARY | P | 3997 | 0 | 1277 | 0 | 5274 | 0 | 0 | 0 | 0 | 100 | 228680 228680 | |
935264 | 601 | RICHARD | J | CURTIS | PRESIDENT | P | 2840 | 0 | 3678 | 0 | 6518 | 0 | 0 | 0 | 0 | 100 | 228680 228680 | |
935265 | 601 | LAWRENCE | c | SNYDER | VICE PRESIDENT | P | 175 | 0 | 940 | 0 | 1115 | 0 | 0 | 0 | 0 | 100 | 228680 228680 | |
935266 | 601 | DWIGHT | A | MATTOX | PRESIDENT | C | 125 | 0 | 0 | 0 | 125 | 0 | 0 | 0 | 0 | 100 | 228680 228680 | |
935267 | 601 | DONALD | W | ARROWOOD | VICE PRESIDENT | C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 228680 228680 | |
935268 | 601 | JOSEPH | m | BRENNAN | RECORDING SECRETARY | C | 720 | 0 | 940 | 0 | 1660 | 0 | 0 | 0 | 0 | 100 | 228680 228680 | |
935269 | 602 | CAROLE | V | MINCHEW | CLERK | NONE | 44696 | 0 | 334 | 0 | 45030 | 0 | 0 | 0 | 100 | 0 | 228680 228680 | |
935270 | 604 | 6949 | 0 | 59560 | 0 | 66509 | 0 | 0 | 0 | 0 | 100 | 228680 228680 |
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) );