ar_disbursements_emp_off

where rpt_id = 228680

✎ 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
935259 601 BRIAN k THOMPSON BUSINESS MANAGER C 95509 0 6353 0 101862 85 5 0 0 10 228680 228680  
935260 601 GARY J ALEKNAVIC ASSISTANT BUSINESS MGR C 79117 0 2827 0 81944 85 5 0 5 5 228680 228680  
935261 601 KENNETH r SIMS ASSISTANT BUSINESS MGR C 79117 0 2226 0 81343 85 5 0 5 5 228680 228680  
935262 601 CARL L BLACK TREASURER C 15701 0 5810 0 21511 10 0 0 90 0 228680 228680  
935263 601 WALTER J CROSSON SECRETARY P 3997 0 1277 0 5274 0 0 0 0 100 228680 228680  
935264 601 RICHARD J CURTIS PRESIDENT P 2840 0 3678 0 6518 0 0 0 0 100 228680 228680  
935265 601 LAWRENCE c SNYDER VICE PRESIDENT P 175 0 940 0 1115 0 0 0 0 100 228680 228680  
935266 601 DWIGHT A MATTOX PRESIDENT C 125 0 0 0 125 0 0 0 0 100 228680 228680  
935267 601 DONALD W ARROWOOD VICE PRESIDENT C 0 0 0 0 0 0 0 0 0 100 228680 228680  
935268 601 JOSEPH m BRENNAN RECORDING SECRETARY C 720 0 940 0 1660 0 0 0 0 100 228680 228680  
935269 602 CAROLE V MINCHEW CLERK NONE 44696 0 334 0 45030 0 0 0 100 0 228680 228680  
935270 604           6949 0 59560 0 66509 0 0 0 0 100 228680 228680   
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)
);