ar_disbursements_emp_off

where rpt_id = 62165

✎ 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
526539 601 CARL   RADER PRESIDENT N 13217     0 13217           62165 62165 1
526540 601 BILL   HART VICE PRESIDENT N 10072     0 10072           62165 62165 2
526541 601 RONALD   PORTER SECRETARY/TREASURER C 11201     0 11201           62165 62165 3
526542 601 ARTIS   COOK SERGEANT-AT-ARMS C 1320     0 1320           62165 62165 4
526543 601 DARRELL   SIMS TRUSTEE N 1860     0 1860           62165 62165 5
526544 601 STEVE   STRAS TRUSTEE N 1860     0 1860           62165 62165 6
526545 601 JOHN   LUCAS TRUSTEE C 540     0 540           62165 62165 7 
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)
);