Close
    logoPlayHQ Webhook Documentation

    Competitions Registrations

    Last update: 3 months ago by Sherryxq9Reading time: 2 min

    Data to be included in file

    Field Name in FileField DescriptionSample DataField TypeSizeIsNullableComments
    idParticipant Registration’s UUID9f7f5a82-f7bb-11ea-adc1-0242ac120002UUIDNo
    • This ID is unique to each registration in the file
      • i.e. each row will have a unique participant registration UUID
    participantProfileIdParticipant’s Profile UUID58d9e86a-f73c-11ea-adc1-0242ac120002UUIDNo
    • 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.
    competitionRegisteredToIdUUID of the Competition the Participant Registered To440685da-f7bc-11ea-adc1-0242ac120002UUIDNo
    organisationRegisteredToIdUUID of the Organisation the Participant Registered To26c3d626-f7bc-11ea-adc1-0242ac120002UUIDNo
    • 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.
    seasonRegisteredToIdUUID of the Competition Season the Participant registered to26c3d626-f7bc-11ea-adc1-0242ac133603UUIDNo
    competitionSeasonNameSeason Registered To2020StringNo
    competitionSeasonStartDateSeason Start Date set by the organisation the participant registered to01/05/2020StringNo
    • This is the season start date set by the organisation that the participant has registered to
    competitionSeasonEndDateSeason End Date set by the organisation the participant registered to30/09/2020StringNo
    • This is the season end date set by the organisation that the participant has registered to
    teamRegisteredToIdUUID of the Team the Participant registered to, if applicablec5fef4fa-9cce-46e3-aee8-7a53cc68f157UUIDYes
    • We are not sending team data through anywhere (i.e. DWH or Webhooks) - team name provided below, as a result
    teamNameName of the Team the Participant registered to, if applicableThe StrikersStringYes
    • See comment in cell above
    registrationDateDate registration was completed2020-08-27T06:29:54.400000000ZStringNo
    • String is an ISO 8601 DateTime in UTC timezone
    roleRole selected during registrationpicklist:
    • Player
    • Volunteer
    • Coach
    • Team Manager
    • Official
    String (limited to one of the values shown)No
    registrationStatusStatus of the participant’s registrationpicklist:
    • 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
    participantDateOfBirthDoB reported during registration27/04/2015StringNo
    • 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
    participantGenderGender reported during registrationFemaleStringNo
    • Gender reported at point of rego
    schoolIDACARA ID of the School reported during registration45674StringYes
    • 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
    schoolYearSchool Year reported during registrationpicklist:
    • Kindergarten
    • Prep
    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    • 8
    • 9
    • 10
    • 11
    • 12
    • Completed School
    • University/Tafe
    • Not Applicable
    StringYes
    • MANDATORY on our participant registration form if participant is under 18 (not available otherwise)
    optInMarketingThe 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 registrationTRUE or FALSEBooleanNo
    • This option will need to be mapped to opt-in options required for the fulfilment report
    createdAtDate/time the Registration was created2020-08-27T06:29:54.400000000ZStringNo
    • String is an ISO 8601 DateTime in UTC timezone
    updatedAtDate/time the Registration was last updated2020-08-27T06:29:54.400000000ZStringNo
    • 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)
    previousRegistrationIdPrevious Registration UUID (for transfers only)234fsd6a-543c-15a-a321-054dfg22002UUIDYes
    • 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
    Data Warehouse Competitions Extension Solution — Previous
    Competitions
    Next