Competitions Registrations

Last update: 18 minutes ago by Nazar32Reading time: 2 min

Data to be included in file

Field Name in File	Field Description	Sample Data	Field Type	IsNullable	Comments
id	Participant Registration’s UUID	9f7f5a82-f7bb-11ea-adc1-0242ac120002	UUID	No	This ID is unique to each registration in the file i.e. each row will have a unique participant registration UUID
participantProfileId	Participant’s Profile UUID	58d9e86a-f73c-11ea-adc1-0242ac120002	UUID	No	This ID is unique to each participant in the file i.e. a participant that registers multiple times will have multiple rows in this file, however, this UUID will be the same for each of those rows.
competitionRegisteredToId	UUID of the Competition the Participant Registered To	440685da-f7bc-11ea-adc1-0242ac120002	UUID	No
organisationRegisteredToId	UUID of the Organisation the Participant Registered To	26c3d626-f7bc-11ea-adc1-0242ac120002	UUID	No	This will be the Organisation UUID related to the Association or Club the participant is registering to. This ID can be referenced for Organisation related attributes in the Organisations webhook or DWH Organisation DIM file.
seasonRegisteredToId	UUID of the Competition Season the Participant registered to	26c3d626-f7bc-11ea-adc1-0242ac133603	UUID	No
competitionSeasonName	Season Registered To	2020	String	No
competitionSeasonStartDate	Season Start Date set by the organisation the participant registered to	01/05/2020	String	No	This is the season start date set by the organisation that the participant has registered to
competitionSeasonEndDate	Season End Date set by the organisation the participant registered to	30/09/2020	String	No	This is the season end date set by the organisation that the participant has registered to
teamRegisteredToId	UUID of the Team the Participant registered to, if applicable	c5fef4fa-9cce-46e3-aee8-7a53cc68f157	UUID	Yes	We are not sending team data through anywhere (i.e. DWH or Webhooks) - team name provided below, as a result
teamName	Name of the Team the Participant registered to, if applicable	The Strikers	String	Yes	See comment in cell above
registrationDate	Date registration was completed	2020-08-27T06:29:54.400000000Z	String	No	String is an ISO 8601 DateTime in UTC timezone
role	Role selected during registration	picklist: Player Volunteer Coach Team Manager Official	String (limited to one of the values shown)	No
registrationStatus	Status of the participant’s registration	picklist: Active Cancelled	String (limited to one of the values shown)	No	A registration can initiate in either “Pending_Activation” or “Registered”. If “Pending_Activation” the participant can be changed to “Registered” when activated by admin or “Cancelled”. If “Registered” the participant can only move to “Cancelled” the via an update by admin on the admin portal As detailed in the extraction rules at the top of the page, this update of a Registration Status is the only update that will trigger an existing registration to be included in the file
participantDateOfBirth	DoB reported during registration	27/04/2015	String	No	All of the fields mentioned to the left that are in the registrations file that is currently prepared can be derived from the DoB provided in this FACT file DoB reported at point of rego
participantGender	Gender reported during registration	Female	String	No	Gender reported at point of rego
schoolID	ACARA ID of the School reported during registration	45674	String	Yes	MANDATORY on our participant registration form if participant is under 18 (not available otherwise) the ID reported here will be the ACARA School ID this could be reported as “Not Applicable” if that option is selected by the user, we will be sending through an ID of “not-applicable”. this option is not available in the ACARA file by default - we have added it this could be reported as “Home School” if that option is selected by the user, we will be sending through an ID of “home-school”. this option is not available in the ACARA file by default - we have added it
schoolYear	School Year reported during registration	picklist: Kindergarten Prep 1 2 3 4 5 6 7 8 9 10 11 12 Completed School University/Tafe Not Applicable	String	Yes	MANDATORY on our participant registration form if participant is under 18 (not available otherwise)
optInMarketing	The marketing opt in value reported during registration - targeted at 3rd party comms, research, and any other type of marketing comms that are not covered through registration	TRUE or FALSE	Boolean	No	This option will need to be mapped to opt-in options required for the fulfilment report
createdAt	Date/time the Registration was created	2020-08-27T06:29:54.400000000Z	String	No	String is an ISO 8601 DateTime in UTC timezone
updatedAt	Date/time the Registration was last updated	2020-08-27T06:29:54.400000000Z	String	No	String is an ISO 8601 DateTime in UTC timezone populated with the most recent value after considering the created at date/time field on the role relationship between Participant and ParticipantCompetitionRegistration, and the created at date/time on the Cancellation relationship between the profile and participant nodes (if it exists)
previousRegistrationId	Previous Registration UUID (for transfers only)	234fsd6a-543c-15a-a321-054dfg22002	UUID	Yes	This will only be populated IF a Competition participant has transferred between Competitions This can be used to look up the merchandise order items for the original registration
source	Shows whether this participant is from a registration or from a season permit.	picklist: Registration Season Permit	String	No
permitFrom	Only populated if the participation record is a season permit-based participation record.	12/05/2021	Date	Yes
permitTo	Only populated if the participation record is a season permit-based participation record.	19/05/2021	Date	Yes

Data Warehouse Competitions Extension Solution — Previous

Competitions