| id | Participant Registration’s UUID | 9f7f5a82-f7bb-11ea-adc1-0242ac120002 | UUID | | No | - This ID is unique to each registration in the file ie each row will have a unique participant registration UUID
|
| participantProfileId | Participant Profile UUID | 58d9e86a-f73c-11ea-adc1-0242ac120002 | UUID | | No | - This ID is unique to each participant in the file ie 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.
|
| sharedProgramRegisteredToId | UUID of the Shared Program 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 | - There are currently 2 columns in the registrations file that is currently prepared that would receive the Organisation Name… they are AssocName and ClubName
- The Organisation UUID would effectively replace the current 2 column approach.
- NEO4J query via (ParticipantProgramRegistration) - [OPENED] → (Organisation)
|
| programSeasonName | Season Registered To | 2020 | String | | No | |
| programSeasonStartDate | 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
|
| programSeasonEndDate | 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
|
| 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 only go from “Active” to “Cancelled” via an update
- 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 | |
| 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)
- 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 ParticipantProgramRegistration, 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 program participant has transferred between programs
- This can be used to look up the merchandise order items for the original registration
|
