ar_disbursements_emp_off

where rpt_id = 64906

✎ 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
810656 601 ROBERT   KASS PRESIDENT C 0     0 0           64906 64906 1
810657 601 CATHERI   JANOVJAK 1ST VICE PRESIDENT N 0     0 0           64906 64906 2
810658 601 JOYCE   CARRASCO 2ND VICE PRESIDENT C 0     0 0           64906 64906 3
810659 601 JACKIE   RAPP SECRETARY N 0     0 0           64906 64906 4
810660 601 ALAN   HASKELL TREASURER C 0     0 0           64906 64906 5
810661 601 DIANNE   LARKIN MEMBER AT LARGE C 0     0 0           64906 64906 6
810662 601 JASON   SHEETZ MEMBER AT LARGE N 0     0 0           64906 64906 7
810663 601 MARGARE   DOYLE MEMBER AT LARGE C 0     0 0           64906 64906 8
810664 601 DAVID   DERBES MEMBER AT LARGE N 0     0 0           64906 64906 9
810665 601 FRANCES   HAHN 1ST VICE PRESIDENT P 0     0 0           64906 64906 10
810666 601 MARJORI   HILLOCKS SECRETARY P 0     0 0           64906 64906 11
810667 601 CAROL   BRINDLEY MEMBER AT LARGE P 0     0 0           64906 64906 12
810668 601 ELUIRA   DONNER MEMBER AT LARGE P 0     0 0           64906 64906 13 
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)
);