Profiles

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	Profile UUID	58d9e86a-f73c-11ea-adc1-0242ac120002	UUID	No	This ID is unique to each profile in the file
wwcNumber	Working with children number for the profile	ABCD1234	String	Yes	this will only be captured for the Volunteer role type
wwcExpiryDate	Working with children expiration date for the profile	20/05/2020	String	Yes	this will only be captured for the Volunteer role type
wwcStateOfIssue	Working with children state of issue for the profile	picklist: Australian Capital Territory New South Wales Northern Territory Queensland South Australia Tasmania Victoria Western Australia	String	Yes	this will only be captured for the Volunteer role type
accountHolder	Indicated whether or not the profile belongs to the account holder or a dependant of an account holder.	TRUE or FALSE	Boolean	No	PlayHQ account holders have their own profiles Dependant profiles can also be created for a PHQ account This field indicates whether or not the profile belongs to the account holder or a dependant If the accountHolderEmailAddress and the participantEmailAddress are the same value, this field will be TRUE (tech note: if there is no parentID will be TRUE) If the accountHolderEmailAddress and the participantEmailAddress are different (including a blank value), this field will be FALSE (tech note: if there is a parentID will be FALSE)
accountHolderProfileId	UUID of the profile that is associated with the PHQ account holder	58d9e86a-f73c-11ea-adc1-0242ac120002	UUID	No	This is the UUID of the profile of the PlayHQ account holder. If participant is the account holder, this will be the same as the id column value for the row in this file if the participant is not the account holder, this will be the Profile ID of the person identified as the “Parent/Guardian 1” in the same row in the file
accountHolderEmailAddress	Email address for the PlayHQ account that is associated with the profile	test@email.com	String	No
accountHolderMobile	Mobile phone number for the PlayHQ account that is associated with the profile	04222222222	String	No
participantFirstName	First Name on participant profile	Jane	String	No
participantLastName	Last Name on participant profile	Doe	String	No
profileVisible	Indicates whether or not profile details are visible on public game centres, etc…	TRUE or FALSE	Boolean	No
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
participantGender	Gender reported during registration	Female	String	No
participantAddress	Address on participant profile	123 St.	String	No
participantSuburb	Suburb on participant profile	Hillarys	String	No
participantPostcode	Postcode on participant profile	6025	String	No
participantState	State on participant profile	WA	String	No
participantCountry	Country on participant profile	Australia	String	No
participantEmailAddress	PlayHQ Account Email Address related to participant profile	test@email.com	String	Yes	Will only be populated if participant is the PHQ account holder (as per current participation report logic)
participantMobilePhone	PlayHQ Account Mobile Phone related to participant profile	422220222	String	Yes	Will only be populated if participant is the PHQ account holder (as per current participation report logic)
parentGuardiansBornOverseas	Registrant’s answer to whether or not any parent/guardian was born overseas	picklist: Yes No Do not wish to disclose	String (limited to one of the values shown)	No	All registrants must answer this - it will always contain a value
parentGuardian1CountryOfBirth	Registrant’s answer to the parent/guardian 1 country of birth	picklist: All countries in alphabetical order	String (limited to one of the values shown)	Yes	This will only be populated if “Yes” is selected in the “parentGuardianBornOverseas” field
parentGuardian2CountryOfBirth	Registrant’s answer to the parent/guardian 2 country of birth	picklist: All countries in alphabetical order	String (limited to one of the values shown)	Yes	This will only be populated if “Yes” is selected in the “parentGuardianBornOverseas” field
hasDisability	Registrant’s answer to whether or not they live with a disability	picklist: Yes No Do not wish to disclose	String (limited to one of the values shown)	No	all registrants must answer this - it will always contain a value
disabilities	Disabilities selected by the registrant	tickboxes: Attention Deficit Hyperactivity Disorder (ADHD) Autism Spectrum Disorder Blind and/or vision impaired Cerebral Palsy Deaf and/or hearing impaired Development Coordination Disorder Intellectually impaired Physical - Ambulant impaired Physical - Wheelchair impaired Other	String	Yes	all registrant who have selected “Yes” for the hasDisability field must answer this these will be presented in a single field in the file
otherDisabilityDescription	Text describing disability when “Other” is selected	Disability entails the following…	String	Yes	all registrants who have selected “Other” as part of the disabilities field must answer this
additionalDisabilitySupportInformation	An optional free-text field to capture additional information about how the participant’s disability can be best supported by the organisation	My disability can best be supported by…	String	Yes	Optional on our participant registration form - and only available if registrant has selected “Yes” for the hasDisability field
atsi	Aboriginal / TSI origin value on participant profile	picklist: No Yes, Aboriginal Yes, Torres Strait Islander Yes, both Aboriginal and Torres Strait Islander I prefer not to say	String	No	Not in the registrations file that is currently prepared
parentGuardian1FirstName	First name of the 1st parent/guardian listed for the participant	John	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian1LastName	Last name of the 1st parent/guardian listed for the participant	Doe	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian1MobileNumber	Mobile number of the 1st parent/guardian listed for the participant	0433333333	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian1EmailAddress	Email of the 1st parent/guardian listed for the participant	test@email.com	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian1Address	Address of the 1st parent/guardian listed for the participant	123 St.	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian1Suburb	Suburb of the 1st parent/guardian listed for the participant	Hillarys	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian1Postcode	Postcode of the 1st parent/guardian listed for the participant	6025	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian1State	State of the 1st parent/guardian listed for the participant	WA	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian1Country	Country of the 1st parent/guardian listed for the participant	Australia	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian2FirstName	First name of the 2nd parent/guardian listed for the participant	Jane	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian2LastName	Last name of the 2nd parent/guardian listed for the participant	Doe	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian2MobileNumber	Mobile number of the 2nd parent/guardian listed for the participant	0433444433	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian2EmailAddress	Email of the 2nd parent/guardian listed for the participant	anothertest@email.com	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian2Address	Address of the 2nd parent/guardian listed for the participant	123 St.	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian2Suburb	Suburb of the 2nd parent/guardian listed for the participant	Hillarys	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian2Postcode	Postcode of the 2nd parent/guardian listed for the participant	6025	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian2State	State of the 2nd parent/guardian listed for the participant	WA	String	Yes	this information will always be populated if a dependant is being registered
parentGuardian2Country	Country of the 2nd parent/guardian listed for the participant	Australia	String	Yes	this information will always be populated if a dependant is being registered
emergencyContactFirstName	First name of the emergency contact listed for the participant	Jane	String	Yes	this information will always be populated if a dependant is being registered
emergencyContactLastName	Last name of the emergency contact listed for the participant	Doe	String	Yes	this information will always be populated if a dependant is being registered
emergencyContactMobile	Mobile number of the emergency contact listed for the participant	0433444433	String	Yes	this information will always be populated if a dependant is being registered
emergencyContactEmailAddress	Email of the emergency contact listed for the participant	anothertest@email.com	String	Yes	this information will always be populated if a dependant is being registered
emergencyContactRelationship	Relationship description of the emergency contact listed for the participant	Mother	String	Yes	this information will always be populated if a dependant is being registered
createdAt	Date/time the profile was created	2020-08-27T06:29:54.400000000Z	String	Yes	String is an ISO 8601 DateTime in UTC timezone
updatedAt	Date/time the profile was last updated	2020-08-27T06:29:54.400000000Z	String	Yes	String is an ISO 8601 DateTime in UTC timezone
accountHolderExternalAccountId	External account id of the account holder of the participant registering		String	Yes

Product Variants

Next — Data Warehouse Integration Solution

Program Seasons