Sunnyvale Moose 2049	Sunnyvale Moose Roles and Responsibilities DEVELOPMENT [ Production Site ] Event Calendar  |  Facebook  |  Feedback  |  Home  |  Login  |  Newsletters  |  Roles

Array
(
    [Action] => List Current
    [organization_id] => 200
    [role_id] => 16
)

Array
(
)

Help and explanations available at Overview.
List buttons show who is serving/has served in that role, Describe Role button will give responsibilities of role.

get_field_labels:Table: role, Cullme: role

Language: US_English

get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'role' AND message_type = 'Field Label' AND language = 'US_English'

Row Count: 5

From get_fields_label Output from Message

Array
(
    [role_id] => Role Id
    [role_scope] => Role Scope
    [role_name] => Role Name
    [role_alias] => Role Alias
    [role_description] => Role Description
)

get_field_labels:Table: roleterm, Cullme: roleterm

Language: US_English

get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'roleterm' AND message_type = 'Field Label' AND language = 'US_English'

Row Count: 9

From get_fields_label Output from Message

Array
(
    [roleterm_id] => Roleterm Id
    [people_id] => Holder
    [role_id] => Role
    [hostgroup_id] => Host Group
    [organization_id] => Organization
    [start_date] => Start Date
    [end_date] => End Date
    [candidate_info] => Candidate Info
    [term_type] => Type
)

SELECT DISTINCT t.*,r.role_name,p.full_name FROM role r, roleterm t, people p WHERE t.role_id = r.role_id AND t.people_id = p.people_id AND t.end_date >= '2025-12-30' AND t.start_date <= '2025-12-30' AND t.role_id='16' AND t.organization_id='200' AND r.role_id='16' ORDER BY r.role_name

Column entries that are links will "drill down" to refine your query. Name links to contact info. Purple icon links to details of role.
Query returned 1 entry.

Info	Role	Holder	Type	Organization	Start Date	End Date
	Auditor	John Paine	Primary	Lodge 2049	2025-01-01	2026-03-31

Entering spew_footer