select config_year_start, config_year_end from facsen_config select comm_name, comm_charge, comm_chair, comm_fsr, comm_listname from committee where comm_code = #url.comm# select contact.con_code, con_fname, con_lname, con_tel, con_email, title_name, dpt_name, dpt_msc, cme_year_start, cme_year_end, cte_type.type_code, type_name, cte_qualification.quali_code, cte_qualification.quali_name, cte_role.role_code, cte_role.role_name, c.ctq_quantity, c.ctq_voter, cme_flg_representative from cte_member, cte_type, contact, department, title, cte_qualification, cte_role, cte_comm_type_quali c where cte_member.comm_code = #url.comm# and cte_member.cme_flg_resignation = 'N' and cte_member.cme_year_start <= '#ls_year_conf_s#' and cte_member.cme_year_end > '#ls_year_conf_s#' and cte_member.type_code <> '04' and cte_member.type_code <> '02' and cte_member.type_code <> '13' and cte_member.type_code <> '07' and cte_member.role_code = cte_role.role_code and cte_member.type_code = cte_type.type_code and cte_member.quali_code = cte_qualification.quali_code and cte_member.con_code = contact.con_code and contact.dpt_code = department.dpt_code and contact.title_code = title.title_code and c.comm_code = cte_member.comm_code and c.type_code = cte_member.type_code and c.quali_code = cte_member.quali_code union select contact.con_code, con_fname, con_lname, con_tel, con_email, title_name, dpt_name, dpt_msc, '' as cme_year_start, '' as cme_year_end, cte_member.type_code, type_name, cte_qualification.quali_code, cte_qualification.quali_name, cte_role.role_code, cte_role.role_name, c.ctq_quantity, c.ctq_voter, cme_flg_representative from cte_member, cte_type, contact, department, title, cte_qualification, cte_role, cte_comm_type_quali c where cte_member.comm_code = #url.comm# and cte_member.cme_flg_resignation = 'N' and ( cte_member.type_code = '04' or cte_member.type_code = '02' or cte_member.type_code = '13' or cte_member.type_code = '07' ) and cte_member.role_code = cte_role.role_code and cte_member.type_code = cte_type.type_code and cte_member.quali_code = cte_qualification.quali_code and cte_member.con_code = contact.con_code and contact.dpt_code = department.dpt_code and contact.title_code = title.title_code and c.comm_code = cte_member.comm_code and c.type_code = cte_member.type_code and c.quali_code = cte_member.quali_code union select contact.con_code, con_fname, con_lname, con_tel, con_email, title_name, '' as dpt_name, '' as dpt_msc, '' as cme_year_start, '' as cme_year_end, cte_member.type_code, type_name, cte_qualification.quali_code, cte_qualification.quali_name, cte_role.role_code, cte_role.role_name, c.ctq_quantity, c.ctq_voter, cme_flg_representative from cte_member, cte_type, contact, title, cte_qualification, cte_role, cte_comm_type_quali c where cte_member.comm_code = #url.comm# and cte_member.cme_flg_resignation = 'N' and ( cte_member.type_code = '04' or cte_member.type_code = '02' or cte_member.type_code = '13' or cte_member.type_code = '07' ) and cte_member.role_code = cte_role.role_code and cte_member.type_code = cte_type.type_code and cte_member.quali_code = cte_qualification.quali_code and cte_member.con_code = contact.con_code and contact.dpt_code is NULL and contact.title_code = title.title_code and c.comm_code = cte_member.comm_code and c.type_code = cte_member.type_code and c.quali_code = cte_member.quali_code union select contact.con_code, con_fname, con_lname, con_tel, con_email, title_name, '' as dpt_name, '' as dpt_msc, cme_year_start, cme_year_end, cte_type.type_code, type_name, cte_qualification.quali_code, cte_qualification.quali_name, cte_role.role_code, cte_role.role_name, c.ctq_quantity, c.ctq_voter, cme_flg_representative from cte_member, cte_type, contact, title, cte_qualification, cte_role, cte_comm_type_quali c where cte_member.comm_code = #url.comm# and cte_member.cme_flg_resignation = 'N' and cte_member.cme_year_start <= '#ls_year_conf_s#' and cte_member.cme_year_end > '#ls_year_conf_s#' and cte_member.role_code = cte_role.role_code and cte_member.type_code = cte_type.type_code and cte_member.quali_code = cte_qualification.quali_code and cte_member.con_code = contact.con_code and contact.dpt_code is NULL and contact.title_code = title.title_code and c.comm_code = cte_member.comm_code and c.type_code = cte_member.type_code and c.quali_code = cte_member.quali_code union select 'VACANT' as con_code, '' as con_fname, 'VACANT' as con_lname, '' as con_tel, '' as con_email, '' as title_name, '' as dpt_name, '' as dpt_msc, '' as cme_year_start, '' as cme_year_end, t.type_code, type_name, q.quali_code, q.quali_name, '' as role_code, '' as role_name, c.ctq_quantity, c.ctq_voter, '' as cme_flg_representative from cte_comm_type_quali c, cte_type t, cte_qualification q where c.comm_code = #url.comm# and c.type_code = t.type_code and c.quali_code = q.quali_code and not exists (select cte.type_code, cte.quali_code from cte_member cte where cte.comm_code = #url.comm# and cte.cme_flg_resignation = 'N' and cte.cme_year_start <= '#ls_year_conf_s#' and cte.cme_year_end > '#ls_year_conf_s#' and cte.type_code <> '04' and cte.type_code <> '02' and cte.type_code <> '13' and cte.type_code <> '07' and cte.comm_code = c.comm_code and cte.type_code = c.type_code and cte.quali_code = c.quali_code union select cte.type_code, cte.quali_code from cte_member cte where cte.comm_code = #url.comm# and cte.cme_flg_resignation = 'N' and ( cte.type_code = '04' or cte.type_code = '02' or cte.type_code = '13' or cte.type_code = '07' ) and cte.comm_code = c.comm_code and cte.type_code = c.type_code and cte.quali_code = c.quali_code ) order by type_code, ctq_voter desc, quali_code, quali_name, con_lname asc select Concat(con_fname,' ',con_lname) as fullname from cte_member, contact where cte_member.comm_code = #url.comm# and cte_member.cme_flg_resignation = 'N' and cte_member.cme_year_start <= '#ls_year_conf_s#' and cte_member.cme_year_end > '#ls_year_conf_s#' and cte_member.role_code = '00' and cte_member.con_code = contact.con_code select Concat(con_fname,' ',con_lname) as fullname from cte_member, contact where cte_member.comm_code = #url.comm# and cte_member.cme_flg_resignation = 'N' and cte_member.cme_year_start <= '#ls_year_conf_s#' and cte_member.cme_year_end > '#ls_year_conf_s#' and cte_member.role_code = '01' and cte_member.con_code = contact.con_code

#comm_search.comm_name# Committee Members

#ls_year_conf_s#-#ls_year_conf_e#

Charge of Committee TBA Charge of Committee   |   Meeting Schedules and Minutes


Policy

 Chair = #ls_chair#

Faculty Senate Representative = #ls_fsr#

List of Past Honorary Degree Recipients

Committee mailing list (posting restricted to members):
#comm_search.comm_listname#@unm.edu

 (Please see bottom of page for eligibility.)

 bgcolor="##E2E3E3" trvalue='1' trvalue='2' > bgcolor="##E2E3E3" trvalue='1' trvalue='2' > bgcolor='##E2E3E3' trvalue='1' trvalue='2' > bgcolor='##E2E3E3' trvalue='1' trvalue='2' > bgcolor="##E2E3E3" trvalue='1' trvalue='2' >
Member Term/
Member Type
VACANT
#ls_quali_name#		  
#comm_mem.type_name# Non-Voting
VACANT
#ls_quali_name#		  
VACANT
#comm_mem.quali_name#		  
#comm_mem.con_fname# #comm_mem.con_lname#
#comm_mem.title_name#
#comm_mem.dpt_name#
#comm_mem.dpt_msc#
#comm_mem.con_tel#
ewenzel@unm.edu
#comm_mem.con_email#
 #comm_mem.quali_name# (Designated Member) 		  #comm_mem.cme_year_start#
#comm_mem.role_name# #comm_mem.cme_year_start# - #comm_mem.cme_year_end#
#comm_mem.role_name#
Non-Voting
VACANT
#ls_quali_name#		  
Faculty Ineligible for Membership:
  • Members of the Faculty Senate
    •
  • Non-voting faculty
  • Faculty without tenure
    •
  • Deans, department chairpersons, and other ex-officio members of the faculty