ar_disbursements_emp_off

where rpt_id = 61971

✎ 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
811062 601 ANDRE   MASON PRESIDENT C       1812 1812           61971 61971 1
811063 601 DEBORAH   SILER 1ST VICE PRESIDENT N       1515 1515           61971 61971 2
811064 601 GAYULA   JOHNSON 2ND VICE PRESIDENT C       0 0           61971 61971 3
811065 601 WILHELM   GRAHAM SECRETARY/TREASURER C       325 325           61971 61971 4
811066 601 JUDY   LITTLE CHIEF STEWARD C       160 160           61971 61971 5
811067 601 OLLIE   MONTGOMERY 1ST VICE PRESIDENT P       90 90           61971 61971 6
811068 601 JAMES   SHAVER PROFESIONAL STEWARD C       180 180           61971 61971 7
811069 601 VINCE   VASQUEZ STEWARD/REC/SEC C       90 90           61971 61971 8
811070 601 JULIE   WHITNEY STEWARD C       90 90           61971 61971 9
811071 601 KC   SMITH STEWARD C       90 90           61971 61971 10
811072 601 MARTIN   LOWERY STEWARD C       90 90           61971 61971 11
811073 601 TED   PEPESH STEWARD C       250 250           61971 61971 12
811074 601 PRESCIL   CRAIG TRUSTEE N       0 0           61971 61971 13 
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)
);