ar_disbursements_emp_off

where rpt_id = 248398

✎ 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
1077397 601 DAVID L INGRAM PRESIDENT C 0 1640 0 0 1640 0 0 5 5 90 248398 248398  
1077398 601 WILLIAM G REEVES VICE-PRESIDENT C 0 1490 0 0 1490 0 0 5 5 90 248398 248398  
1077399 601 GEORGE L OCHOA FINANCIAL SECRETARY C 1628 2285 0 688 4601 0 0 5 0 95 248398 248398  
1077400 601 DENNIS G LANCASTER TREASURER N 0 750 0 0 750 0 0 5 5 90 248398 248398  
1077401 601 JASON   PHILLIPS TREASURER N 0 50 0 0 50 0 0 0 0 100 248398 248398  
1077402 601 ARTHUR C VALLEZ RECORDING SECRETARY C 0 1705 0 0 1705 0 0 5 5 90 248398 248398  
1077403 601 GEORGE M GUNDERSON RECORDING SECRETARY C 0 445 0 0 445 0 0 0 0 100 248398 248398  
1077404 601 JAMES M ERNST CONDUCTOR N 0 575 0 0 575 0 0 5 5 90 248398 248398  
1077405 601 BILL J JONES CONDUCTOR N 0 33 0 0 33 0 0 0 5 95 248398 248398  
1077406 601 PAULA   RESA TRUSTEE C 0 637 0 0 637 0 0 5 5 90 248398 248398  
1077407 601 DOUGLAS L WHIPPLE TRUSTEE C 0 970 0 0 970 0 0 0 0 100 248398 248398  
1077408 601 THOMAS C ESTES TRUSTEE C 0 850 0 0 850 0 0 5 5 90 248398 248398  
1077409 602 CINDY   GUNDERSON OFFICE MANAGER NONE 57952 0 0 0 57952 0 0 1 93 6 248398 248398  
1077410 602 RUTH   SANCHEZ ADVANCED SECRETARY NONE 51975 0 0 0 51975 3 0 1 90 6 248398 248398  
1077411 604           16280 0 0 0 16280 87 0 0 0 13 248398 248398   
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)
);