Organisations

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	Size	IsNullable	Comments
id	Organisation's UUID	88a5b302-f71f-11ea-adc1-0242ac120002	UUID		No	This ID is unique to each organisation
name	Name of the Organisation	Rowville Cricket Club	String	60	No	The Organisation Name, in conjunction with the Organisation Type, would effectively replace the current 2 column approach in the registrations file as described further in the cell below
type	Type of the Organisation	picklist: ADMINISTRATIVE_BODY ASSOCIATION CLUB	String (will be one of the three values specified)		No	“State”-level organisations will always have an Organisation Type = “Administrative Body” States are not identified in any way that differentiates them from other regional Administrative Bodies (or National, for that matter)
parentOrganisationId	Direct Parent of the Organisation	88a5b302-f71f-11ea-adc1-0242ac120002	UUID		Yes	Only the tenant org will not have a parent organisation Only organisations with an organisation type of “Administrative Body” can be Parent Organisations The Parent Organisation can be used to populate the “Region” field to replicate the data in the current registrations file by finding the direct parent of the organisation that the participant registered to If multiple layers sit between the State and Centre e.g. regions and sub-regions, these details can be pieced together with the info provided in this file
email	Contact email address listed on the Organisation	info@rowvillecc.org.au	String		No
url	URL listed for the Organisation	http://www.rowvillecc.org.au/	String		Yes
contactNumberCountryCode	Country prefix for the contact phone number listed on the Organisation	61	String (limited to 3 chars eg +61)		Yes	We seperate country code out At the moment, this will only ever be "61" for Australia
contactNumber	Contact Phone Number listed on the Organisation	422222222	String		Yes
taxStatus	Tax status of the Organisation	picklist: NO_TAX AUS_GST	String (limited to one of the options listed)		No
address	Address listed on the Organisation	123 Street	String		Yes
suburb	Suburb listed on the Organisation	Rowville	String		Yes
postcode	Postcode listed on the Organisation	3178	String		Yes
state	State listed on the Organisation	VIC, NSW, ACT, QLD, TAS, NT, SA, WA	String (limited to one of the options listed)		Yes
country	Country listed on the Organisation	Australia	String (Will always be Australia at the moment)		Yes
createdAt	Date/time the Organisation was created	2020-08-27T06:29:54.400000000Z	String		No	String is an ISO 8601 DateTime in UTC timezone
updatedAt	Date/time the Organisation 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 updated at field on the Org node, the created at field on the Org’s relationship to Address, and the created at field on the Org’s relationship to parent
orgDefaultTimeZone	Default time zone of the organisation	Australia/Melbourne	String (limited to one of the options listed)		No
orgDescription	Description listed for the org on the My Organisation > Overview page	Our organisation offers the following ways to play…	String		Yes
includeInFinder	Visible on discovery maps setting	true	Boolean		No
visible	Organisation visibility setting for PlayHQ	true	Boolean		No
latitude	Latitude of the Organisation	-37.87639	String		Yes
longitude	Longitude of the Organisation	-73.87639	String		Yes

Data Warehouse Integration Solution — Previous

Merchandise Orders

Next — Data Warehouse Integration Solution

Playing Surfaces