ar_disbursements_emp_off

where rpt_id = 463458

✎ 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
2729590 601 ANGELO   MANGANO PRESIDENT C 82388 0 2500 5315 90203 60 0 0 0 40 463458 463458  
2729591 601 JOSEPH   DEROSSI EXECUTIVE VICE PRESIDENT C 84385 0 0 4984 89369 80 0 0 0 20 463458 463458  
2729592 601 ROBERT   MORRO SECRETARY TREASURER C 26037 0 0 0 26037 20 0 0 0 80 463458 463458  
2729593 602 EDWARD   SMITH CHIEF STEWARD NALC 18295 0 0 0 18295 100 0 0 0 0 463458 463458  
2729594 602 ROBERT   VITALE ASST. SECRETARY TREASURER C 19517 0 0 0 19517 100 0 0 0 0 463458 463458  
2729595 604           10530 0 0 0 10530 100 0 0 0 0 463458 463458   
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)
);