ar_disbursements_emp_off

where rpt_id = 248186

✎ 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
1076436 601 JESSE GLEN   PANNELL JR PRESIDENT P 0 600 0 0 600 0 0 0 0 100 248186 248186  
1076437 601 DENNIS R HARRAH PRESIDENT N 0 150 0 0 150 0 0 0 0 100 248186 248186  
1076438 601 DENNIS R HARRAH VICE-PRESIDENT P 0 475 0 0 475 0 0 0 0 100 248186 248186  
1076439 601 TIMOTHY   MAXWELL VICE-PRESIDENT N 0 135 0 0 135 0 0 0 0 100 248186 248186  
1076440 601 CURTIS   MORGAN FINANCIAL SECRETARY C 0 795 0 0 795 0 0 0 0 100 248186 248186  
1076441 601 FRED   ESPINOZA CONDUCTOR C 0 325 0 0 325 0 0 0 0 100 248186 248186  
1076442 601 SHAWN   SMITH RECORDING SECRETARY C 0 1395 0 0 1395 0 0 0 0 100 248186 248186  
1076443 601 RAYMOND   SANDOVAL TRUSTEE C 0 300 0 0 300 0 0 0 0 100 248186 248186  
1076444 601 SANDY   MARQUEZ TRUSTEE C 0 300 0 0 300 0 0 0 0 100 248186 248186  
1076445 601 TERRY   SMIT TRUSTEE C 0 400 0 0 400 0 0 0 0 100 248186 248186  
1076446 601 TONY   CASTILLO WARDEN C 0 875 0 0 875 0 0 0 0 100 248186 248186  
1076447 602 CHERYL A SOARES OFFICE MANAGER/BOOKKEEPER NON 46116 0 0 737 46853 0 0 0 95 5 248186 248186  
1076448 604           0 0 0 0 0 0 0 0 0 0 248186 248186   
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)
);