| 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: | 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
|
