ar_disbursements_emp_off

where rpt_id = 463535

✎ 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
2729888 601 JERRY L STUART PRESIDENT C 0 0 0 0 0 0 0 0 100 0 463535 463535  
2729889 601 JOSEPH A SANSOSTI VICE PRESIDENT C 0 0 0 0 0 0 0 0 100 0 463535 463535  
2729890 601 LARRY   OWENBY FINANCIAL SECRETARY C 30 0 0 0 30 0 0 0 100 0 463535 463535  
2729891 601 ANGELA G ELLIOTT RECORDING SECRETARY C 7365 0 0 0 7365 0 0 0 100 0 463535 463535  
2729892 601 THOMAS J GOOD TREASURER C 6435 0 0 0 6435 0 0 0 100 0 463535 463535  
2729893 602 BENNY L MOONEY CUSTODIAN None 1955 0 0 0 1955 0 0 0 100 0 463535 463535  
2729894 602 GARY S WHITMIRE WORKER FOR UNION ATTORNEY None 330 0 0 0 330 0 0 0 100 0 463535 463535  
2729895 604           0 0 0 0 0 0 0 0 0 0 463535 463535   
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)
);