GMS

GMS (Games Management System)

Discipline

colname	coltype	colvalues	detail
Id	bigint (auto increment)
DisciplineName	varchar(256)
DisciplineSubTypeCode	varchar(256)
DisciplineSubTypeName	varchar(256)
DisciplineSubSubTypeCode	varchar(256)
DisciplineSubSubTypeName	varchar(256)
CreatedDateTime	datetime
SourceName	varchar(256)

Role

colname	coltype	colvalues	detail
Id	bigint (auto increment)
Description	varchar(256)
PersonType	varchar(256)
PersonAffiliation	varchar(256)
PersonRole	varchar(256)
CreatedDateTime	datetime
SourceName	varchar(256)

Entries

colname	coltype	colvalues	detail
Id	bigint (auto increment)
GMSEntryId	varchar(256)
GMSPersonId	varchar(256)
FirstName	varchar(256)
MiddleName	varchar(256)
LastName	varchar(256)
BirthDate	date
Gender	varchar(256)
AddressPrimary	varchar(256)
AddressSecondary	varchar(256)
City	varchar(256)
State	varchar(256)
ZipCode	varchar(256)
Country	varchar(256)
PersonRole	varchar(256)
EventLocation	varchar(256)
DisciplineSubType	varchar(256)
DisciplineSubSubType	varchar(256)
EventName	varchar(256)
StartDate	date
EndDate	date
GamesName	varchar(256)
Delegation	varchar(256)
Team	varchar(256)
IsScratched	bit
Program	varchar(256)
Source	varchar(256)
CreatedDateTime	datetime
AssetId	varchar(256)		Pipeline run id that joins to SoFlow.Log.AssetId.

Certifications

colname	coltype	colvalues	detail
Id	bigint (auto increment)
PersonId	bigint
GMSPersonId	varchar(256)
GMSFormType	varchar(256)
GMSCertId	varchar(256)
EffectiveDate	date
hasAutism	varchar(256)
hasCerebralPalsy	varchar(256)
hasFragileXSyndrome	varchar(256)
hasDownSyndrome	varchar(256)
hasFetalAlcoholSyndrome	varchar(256)
hasLatexAllergy	varchar(256)
hasAllergies	varchar(256)
hasMedicationsAllergy	varchar(256)
hasBitesOrStingsAllergy	varchar(256)
hasFoodAllergy	varchar(256)
usesWheelchair	varchar(256)
usesCrutchesOrWalker	varchar(256)
hasSeizures	varchar(256)
Source	varchar(256)
CreatedDateTime	datetime
AssetId	varchar(256)		Pipeline run id that joins to SoFlow.Log.AssetId.