Gym Details
Loading
Gym Details
| Division: | South |
| Short Name: | CGC |
| Official Name: | Champion Gymnastics & Cheer |
| Phone Primary: | 619-449-7717 |
| Phone Secondary: | |
| Fax: | 619-449-7727 |
| Address: | 10580 Prospect Ave., Suite 101 |
| City: | Santee |
| State: | California |
| Zip: | 92071 |
| Email Primary: | champsathletes@yahoo.com |
| Email Secondary: | cgcchamps@gmail.com |
| Status: | True |
| Notes: | |
| Website URL: | www.cgcchamps.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 | Robyn Ross | 498000 | 7/31/2013 | 8/31/2015 | 8/31/2013 | True |
| 2 | JJ Ross | 536581 | 7/31/2013 | 7/31/2016 | 3/31/2014 | True |
| 3 | Savannah Steele | 104689 | 7/31/2013 | 8/31/2015 | 8/31/2013 | 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 | 116540 | Kevin Klein | L10 | True | True | |
| 2 | 189432 | Micah Cliffe | L10 | True | True | |
| 3 | 558000 | Gunnar Borjeson | L4 | True | True | |
| 4 | 583598 | Lyu Porter | L4 | True | True | |
| 5 | 583601 | Myles Thompson | L4 | True | True | |
| 6 | 453540 | Austin Robertson | L5 | True | True | |
| 7 | 497620 | Benjamin Sichel | L5 | True | True | |
| 8 | 501798 | Braxton Schwarte-Boyd | L5 | True | True | |
| 9 | 558002 | Devin Hunt | L5 | True | True | |
| 10 | 497614 | Garrett Squibb | L5 | True | True | |
| 11 | 493568 | James Hohn | L5 | True | True | |
| 12 | 521340 | Weston Sitton | L5 | True | True | |
| 13 | 438370 | Logan Wade | L6 | True | True | |
| 14 | 455328 | Matthew Chertkow | L6 | True | True | |
| 15 | 260182 | Zachary Wallace | L8 | True | True | |
| 16 | 95082 | Steven Rodriguez Jr. | L9 | True | True | |
| 17 | 110200 | Caleb Fischle-Faulk | 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