Gym Details
Loading
Gym Details
| Division: | North |
| Short Name: | GW |
| Official Name: | Gymnastics World |
| Phone Primary: | 818-775-9922 |
| Phone Secondary: | |
| Fax: | |
| Address: | 20914 Nordhoff Street, STE 101 |
| City: | Chatsworth |
| State: | California |
| Zip: | 91311 |
| Email Primary: | ContactUs@GymnasticsWorld.com |
| Email Secondary: | Rohit@GymnasticsWorld.com |
| Status: | True |
| Notes: | |
| Website URL: | www.GymnasticsWorld.com |
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 | Freddy Behin | 416617 | 7/31/2013 | 10/31/2013 | 7/31/2014 | True |
| 2 | Rohit Yadav | 292068 | False | |||
| 3 | Steve Hug | False | ||||
| 4 | Bohdan Kosenko | 334577 | 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 | 223638 | Ben Zagorsky | L10 | True | True | |
| 2 | 138524 | Danny Shugar | L10 | True | True | |
| 3 | 587461 | Luca Nacimiento | L4 | True | True | |
| 4 | 587465 | Mathew Saad | L4 | True | True | |
| 5 | 587470 | Nathan Assor | L4 | True | True | |
| 6 | 587468 | Rami Saad | L4 | True | True | |
| 7 | 587472 | Wesley Ishida | L4 | True | True | |
| 8 | 474921 | Anthony Curtis | L5 | True | True | |
| 9 | 509458 | Dominic Cureton | L5 | True | True | |
| 10 | 505137 | Nicolai Vazquez | L5 | True | True | |
| 11 | 509460 | Quintin Cureton | L5 | True | True | |
| 12 | 509455 | Robert Castillero | L5 | True | True | |
| 13 | 462987 | Ryan Scandurra | L5 | True | True | |
| 14 | 505147 | Yoadd Zaguri | L5 | True | True | |
| 15 | 378895 | Leland Deming | L6 | True | True | |
| 16 | 462989 | Sean Lasher | L6 | True | True | |
| 17 | 428169 | Jadon Roberson | L7 | True | True | |
| 18 | 428162 | Jahvon Morse | L7 | True | True | |
| 19 | 378894 | Jeremy Guttman | L7 | True | True | |
| 20 | 242644 | Kevin Kichik | Level 10 - Junior Elite | 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 | 1/13/2013 | 1/13/2013 | 2013 SCMGA North 2nd Preliminary Meet Levels 4 - 10 | Active |
| 2 | 2/9/2013 | 2/10/2013 | 2013 GW - Invitational Levels 4 - 10 | Active |
