 Sunnyvale Moose 2049 |
Sunnyvale Moose Roles and Responsibilities |
Sunnyvale Moose 2049 |
Sunnyvale Moose Roles and Responsibilities |
Array
(
[Action] => List Current
[organization_id] => 201
[start_date] => 2025-01-01
)
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.
Enter any desired filters below and click one of the green action buttons below to see desired list.
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
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
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.organization_id='201' AND t.start_date='2025-01-01' 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 16 entries.
Entering spew_footer
| Event Calendar | Facebook | Feedback | Home | Login | Newsletters | Roles |
