Gym Details
Loading
Gym Details
| Division: | South |
| Short Name: | MVYMCA |
| Official Name: | Mission Valley YMCA |
| Phone Primary: | 858-496-9622 x4011 |
| Phone Secondary: | 619-200-5255 |
| Fax: | 858-496-8950 |
| Address: | 5105 Overland Ave |
| City: | San Diego |
| State: | California |
| Zip: | 92123 |
| Email Primary: | jcharter@ymca.org |
| Email Secondary: | wjaramillo@ymca.org |
| Status: | True |
| Notes: | |
| Website URL: |
Created On:
3/15/2011 9:14 PM
Created By:
Nick SCMGA
Description:
Base:
Gyms
2563
Folder [Gyms]
Nick
SCMGA
#{Report.Name}
#{Report.Description}
Dynamic Report [Gym Details]
#{Account_Media____MediaDisplay}
Gym Logo
(Hidden)
Output:
Media >> ___MediaDisplay
Aggregate:
None
(Filters applied to aggregate)
Division
(Hidden)
Output:
Gym Registrations >> Association Divisions >> Division
Aggregate:
None
(Filters applied to aggregate)
Short Name
(Hidden)
Output:
ShortName
Aggregate:
None
(Filters applied to aggregate)
Official Name
(Hidden)
Output:
OfficialName
Aggregate:
None
(Filters applied to aggregate)
Phone Primary
(Hidden)
Output:
Phone_Primary
Aggregate:
None
(Filters applied to aggregate)
Phone Secondary
(Hidden)
Output:
Phone_Secondary
Aggregate:
None
(Filters applied to aggregate)
Fax
(Hidden)
Output:
Fax
Aggregate:
None
(Filters applied to aggregate)
Address
(Hidden)
Output:
Address
Aggregate:
None
(Filters applied to aggregate)
City
(Hidden)
Output:
City
Aggregate:
None
(Filters applied to aggregate)
State
(Hidden)
Output:
States >> Name
Aggregate:
None
(Filters applied to aggregate)
Zip
(Hidden)
Output:
Zip
Aggregate:
None
(Filters applied to aggregate)
Email Primary
(Hidden)
Output:
Email_Primary
Aggregate:
None
(Filters applied to aggregate)
Email Secondary
(Hidden)
Output:
Email_Secondary
Aggregate:
None
(Filters applied to aggregate)
Status
(Hidden)
Output:
Active
Aggregate:
None
(Filters applied to aggregate)
Notes
(Hidden)
Output:
Notes
Aggregate:
None
(Filters applied to aggregate)
Website URL
(Hidden)
Output:
Formula: me
Aggregate:
None
(Filters applied to aggregate)
| Row # | Gym Logo |
| 1 | |
| 2 | |
| 3 |
Coaches
Loading
Gym Coaches
Created On:
11/19/2010 4:58 PM
Created By:
Nick SCMGA
Description:
Base:
Gyms
2358
Folder [Gyms]
Nick
SCMGA
#{Report.Name}
#{Report.Description}
Dynamic Report [Gym Coaches]
#{SGA_Users_Inherited__DefaultDisplay}
#{SGA_Users_Inherited_USAG_Number}
#{SGA_Users_Inherited_USAG_Expiration}
#{SGA_Users_Inherited_Safety_Expiration}
#{SGA_Users_Inherited_Background_Expiration}
#{SGA_Users_Inherited_IsActive}
Name
(Hidden)
Output:
Users >> _DefaultDisplay
Aggregate:
None
(Filters applied to aggregate)
USAG Number
(Hidden)
Output:
Users >> USAG_Number
Aggregate:
None
(Filters applied to aggregate)
USAG Expiration
(Hidden)
Output:
Users >> USAG_Expiration
Aggregate:
None
(Filters applied to aggregate)
Safety Expiration
(Hidden)
Output:
Users >> Safety_Expiration
Aggregate:
None
(Filters applied to aggregate)
BG Expiration
(Hidden)
Output:
Users >> Background_Expiration
Aggregate:
None
(Filters applied to aggregate)
Active
(Hidden)
Output:
Users >> IsActive
Aggregate:
None
(Filters applied to aggregate)
| Row # | Name | USAG Number | USAG Expiration | Safety Expiration | BG Expiration | Active |
| 1 | Jonathan Charter | 305853 | 7/31/2013 | 1/31/2016 | False | |
| 2 | David Agajanain | 158382 | 7/31/2013 | 2/28/2013 | 1/31/2014 | True |
| 3 | Walter Jaramillo | 305195 | 7/31/2013 | 1/31/2014 | 12/31/2013 | True |
| 4 | Cody Purcell | 325574 | 7/31/2013 | 11/30/2015 | 12/31/2013 | True |
| 5 | Ari Lieberman | 318110 | False |
Athletes
Loading
Gym Athletes
Created On:
3/15/2011 10:30 AM
Created By:
Freddy Behin
Description:
Base:
Users Athletes
2560
Folder [Gyms]
Freddy
Behin
#{Report.Name}
#{Report.Description}
Dynamic Report [Gym Athletes]
#{SGA_Users_Inherited_USAG_Number}
#{SGA_Users_Inherited__DefaultDisplay}
#{SGA_Levels_Description}
#{SGA_Levels__DefaultDisplay}
#{SGA_Users_Inherited_IsActive}
#{SGA_Users_Athletes_AthleteCompeting}
USAG
(Hidden)
Output:
Users >> USAG_Number
Aggregate:
None
(Filters applied to aggregate)
Name
(Hidden)
Output:
Users >> _DefaultDisplay
Aggregate:
None
(Filters applied to aggregate)
Level
(Hidden)
Output:
Levels >> Description
Aggregate:
None
(Filters applied to aggregate)
Future Star
(Hidden)
Output:
Levels >> _DefaultDisplay
Aggregate:
None
(Filters applied to aggregate)
Status
(Hidden)
Output:
Users >> IsActive
Aggregate:
None
(Filters applied to aggregate)
Athlete Competing
(Hidden)
Output:
AthleteCompeting
Aggregate:
None
(Filters applied to aggregate)
Filter:
Include Exact 1
| Row # | USAG | Name | Level | Future Star | Status | Athlete Competing |
| 1 | 525909 | Angel Solis | L4 | True | True | |
| 2 | 581336 | Anthony Schall | L4 | True | True | |
| 3 | 525922 | Austin Gates | L4 | True | True | |
| 4 | 565078 | Christian Martin | L4 | True | True | |
| 5 | 565089 | David Knowlton | L4 | True | True | |
| 6 | 581334 | Ekin Matanza | L4 | True | True | |
| 7 | 581338 | Faress Zwain | L4 | True | True | |
| 8 | 565083 | Ian Myers | L4 | True | True | |
| 9 | 565090 | Jonathan Marrewa | L4 | True | True | |
| 10 | 525915 | Joshua Lauritsen | L4 | True | True | |
| 11 | 525916 | Koda Constantino | L4 | True | True | |
| 12 | 565082 | Noah Williams | L4 | True | True | |
| 13 | 565088 | Sam Wade | L4 | True | True | |
| 14 | 425485 | David Beltran | L5 | True | True | |
| 15 | 425484 | Emmanuel Beltran | L5 | True | True | |
| 16 | 462127 | Grant Pauker | L5 | True | True | |
| 17 | 474504 | Jacob Rice | L5 | True | True | |
| 18 | 565121 | Jared Garcia | L5 | True | True | |
| 19 | 565119 | Leonardo Aguilar | L5 | True | True | |
| 20 | 565091 | Sebastian Poli | L5 | True | True | |
| 21 | 426394 | Fritz Broido | L6 | True | True | |
| 22 | 474503 | Joseph Rice | L6 | True | True | |
| 23 | 471170 | Tomohiro Kawada | L6 | True | True | |
| 24 | 462134 | Will Quinn | L6 | FS 3B | True | True |
| 25 | 377950 | Brice Laurent | L7 | FS 3A | True | True |
| 26 | 396290 | Christopher Hill | L8 | True | True | |
| 27 | 421400 | Damian Cochrane | L8 | True | True | |
| 28 | 911372 | Jonathan Bryant | L8 | True | True | |
| 29 | 301322 | Kai Movellan | L8 | True | True | |
| 30 | 912988 | Nicholas Williams | L8 | True | True | |
| 31 | 246012 | Noel Csomay-Shanklin | L8 | True | True | |
| 32 | 262125 | Ryan Harvey | L8 | True | True | |
| 33 | 190468 | Deryk Goerke | L9 | True | True | |
| 34 | 155537 | Gabriel Wilson | L9 | True | True |
Meets Participating
Loading
Gym Meets Participating
Created On:
3/15/2011 9:41 AM
Created By:
Nick SCMGA
Description:
Base:
Meets
2559
Folder [Gyms]
Nick
SCMGA
#{Report.Name}
#{Report.Description}
Dynamic Report [Gym Meets Participating]
#{SGA_Meets_SanctionNumber}
#{Formula}
#{SGA_Meets_MeetDateStart}
#{SGA_Meets_MeetDateEnd}
#{SGA_Meets_LocationCity}
#{Formulax}
#{SGA_Users_Inherited__DefaultDisplay}
Sanction#
(Hidden)
Output:
SanctionNumber
Aggregate:
Grouped
(Filters applied to aggregate)
Meet Details
(Hidden)
Output:
Formula: me
Aggregate:
Grouped
(Filters applied to aggregate)
Date Start
(Hidden)
Output:
MeetDateStart
Aggregate:
Grouped
(Filters applied to aggregate)
Date End
(Hidden)
Output:
MeetDateEnd
Aggregate:
Grouped
(Filters applied to aggregate)
Location City
(Hidden)
Output:
LocationCity
Aggregate:
Grouped
(Filters applied to aggregate)
Host Gym
(Hidden)
Output:
Formula: me
Aggregate:
Grouped
(Filters applied to aggregate)
Athletes
(Hidden)
Output:
Meet Atheletes Competing >> Meet Season Athletes >> Users Athletes >> Users >> _DefaultDisplay
Aggregate:
Count
(Filters applied to aggregate)
Meets Hosting
Loading
Gym Meets Hosting
Created On:
11/19/2010 11:26 AM
Created By:
Nick SCMGA
Description:
Base:
Meets
2351
Folder [Gyms]
Nick
SCMGA
#{Report.Name}
#{Report.Description}
Dynamic Report [Gym Meets Hosting]
#{SGA_Meets_MeetDateStart}
#{SGA_Meets_MeetDateEnd}
#{Formula}
#{SGA_MeetStatus_StatusName}
Meet Date Start
(Hidden)
Output:
MeetDateStart
Aggregate:
None
(Filters applied to aggregate)
Meet Date End
(Hidden)
Output:
MeetDateEnd
Aggregate:
None
(Filters applied to aggregate)
Meet Details
(Hidden)
Output:
Formula: me
Aggregate:
None
(Filters applied to aggregate)
Status Name
(Hidden)
Output:
Meet Statuses >> StatusName
Aggregate:
None
(Filters applied to aggregate)
Filter:
Include Exact Active
| Row # | Meet Date Start | Meet Date End | Meet Details | Status Name |
| 1 | 3/24/2013 | 3/24/2013 | 2013 SCMGA Level 4 Team State Championships Level 4 | Active |