ar_disbursements_emp_off

where rpt_id = 83712

✎ 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
828976 601 JOHN   DUNN PRESIDENT C 2205     0 2205           83712 83712 1
828977 601 FRED   SIMMONS VICE PRESIDENT C 1514     0 1514           83712 83712 2
828978 601 LARRY   FRY FINANCIAL SECRETARY C 1344     0 1344           83712 83712 3
828979 601 JAMES   RAHR RECORDING SECRETARY C 789     0 789           83712 83712 4
828980 601 RONALD   DEFRANK TRUSTEE C 518     0 518           83712 83712 5
828981 601 NATE   FREEMAN TRUSTEE C 518     0 518           83712 83712 6
828982 601 GARY   WILLIAMS TRUSTEE N 518     0 518           83712 83712 7
828983 601 FERRIS   POOLE GRIEVANCE C 1253     0 1253           83712 83712 8
828984 601 CURT   HUNT GRIEVANCE C 518     0 518           83712 83712 9
828985 601 GEORGE   COX GRIEVANCE C 670     0 670           83712 83712 10
828986 601 JAY   CROFFORD SAFETY C 526     0 526           83712 83712 11
828987 601 RONALD   MCGEE SAFETY N 518     0 518           83712 83712 12
828988 601 DOUGLAS   WESTLING STEWARD C 518     0 518           83712 83712 13
828989 601 ANTHONY   D'ANDREA STEWARD C 518     0 518           83712 83712 14
828990 601 JESSE   JAMES STEWARD C 518     0 518           83712 83712 15
828991 601 CHARLES   CROSS STEWARD C 518     0 518           83712 83712 16 
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)
);