ar_disbursements_emp_off

where rpt_id = 247553

✎ 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
1064234 601 DICK   ANFANG EXEC SECRETARY C 84900 14831 1315 0 101046 43 18 4 3 32 247553 247553  
1064235 601 HARRY   MELANDER BUSINESS REP C 96145 6173 2736 0 105054 24 3 0 33 40 247553 247553  
1064236 601 DOUG   GALE PRESIDENT P 875 0 0 0 875 0 0 0 0 100 247553 247553  
1064237 601 GREG   MOORE PRESIDENT N 625 150 500 0 1275 0 0 0 0 100 247553 247553  
1064238 601 ROBERT   KASPER TREASURER C 900 0 0 0 900 0 0 0 0 100 247553 247553  
1064239 601 STEVE   TUFENK VICE PRES P 0 150 0 0 150 0 0 0 0 100 247553 247553  
1064240 601 GARY   LOTHANBAC SGT AT ARMS C 0 100 0 0 100 0 0 0 0 100 247553 247553  
1064241 601 ED   LINDEN TRUSTEE C 0 200 0 0 200 0 0 0 0 100 247553 247553  
1064242 601 FRANK   VENTO TRUSTEE C 0 200 0 0 200 0 0 0 0 100 247553 247553  
1064243 601 STEVE   OLSON TRUSTEE N 0 100 0 0 100 0 0 0 0 100 247553 247553  
1064244 601 GARY   ERLANDER VICE PRESIDENT N 0 50 0 0 50 0 0 0 0 100 247553 247553  
1064245 602 DEB   FEHRMAN CLERICAL NONE 49105 0 0 0 49105 34 3 1 26 36 247553 247553  
1064246 604           2028 0 0 0 2028 0 0 0 100 0 247553 247553   
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)
);