Ndr interface Dependency Agreement

12.5.Attributes of Groups

Entity
Group
Attribute	Sub Attribute	Description
Authority		The Owning Authority of the group.
State group id		The identifier of the group, as assigned by the Owning Authority.
Name		The name of the group.
Type		The type of group, e.g. partnership or syndicate.
Member
	Full name	The name of the member.
	Is manager	Indicates whether the person is the manager of the group.
	From date	The date the group was created.
	Person link	Link to the person.
Active		An active status of a Group is removed when: number of members in the group < 2 OR One or more members have an active penalty applied.

13.Appendix: Description of Types

The Logical Data Model (Section 4.1) specifies a type for each attribute. These types are listed in the tables below.

13.1.Basic Types

The following basic types are considered self-explanatory:

Boolean

Date

Time

String

Integer

Decimal

13.2.Types used across Entities

The following enumerated types are restricted to the Possible Values listed in the table:

Type	Possible Values
Authority Type	ACT, NSW, NT, NZ, QLD, SA, TAS, VIC, WA, GA
Entity Status	Active, Deleted

13.3.Types relating to Dogs and Litters

The following enumerated types are restricted to the Possible Values listed in the table:

Type	Possible Values
Gender	Dog, Bitch, Hermaphrodite

The following types are Strings of limited length:

Type	Based on	Restriction
Earbrand Type	String	Maximum 250 characters
Dog Name Type	String	Maximum 250 characters

Each of the following tables defines a single enumerated type, and provides a description, whether a trial is required and whether a Track-specific trial is required for each possible value:

Type	Possible Values	Description	Trial Required?	Track-specific trial required?
			(Information only)
Dog Penalty Code	F1	Marring (1st Offence)	Yes	Yes
	F2	Marring (2nd Offence)	Yes	Yes
	F3	Marring (3rd Offence)	Yes	Yes
	IL	Illness	-	-
	IN	Injury	-	-
	N1	Failing to pursue (1st Offence)	Yes	Yes
	N2	Failing to pursue (2nd Offence)	Yes	Yes
	N3	Failing to pursue (3rd Offence)	Yes	Yes
	NI	Failing to pursue - injured	Yes	Yes
	NP	Not Presented	-	-
	SE	Seasonal	-	-
	SI	Subject to inquiry	-	-
	TR	Transferred	-	-
	UP	Unsatisfactory Performance	Yes	Yes
	WV	Weight Variation	-	-
	TB	Turned in Boxes / Box manners	Yes	Yes
	WT	Whelping Trial	Yes	No
	NW	Nomination Withdrawal	-	-
	NR	No Registration Papers/Card	-	-
	SP	Stewards Permission (with stand-down)	-	-
	SS	Stud Service	-	-
	WS	Withdrawal by Stewards	-	-
	UB**	Unsatisfactory behaviour **	Yes	No
	VE	Veterinary endorsed condition	Yes	No
	CR	Cramping	Yes	No
	OT	Other	-	-
	VC	Vet certificate required	-	-

** Note: UB - Suggest to proceed with Yes & No for now.

RWWA will propose a rule amendment for 2014 to ensure the trial requirements for the UB penalty are specified in the rules. It appears the UB penalty may have been added via R71(A), without R72 being updated to include the exclusion of a venue-specific trial for this new penalty type.

R71(A) quotes a ‘conditional satisfactory trail’. If Stewards wish to make it venue-specific, they can always use a UP penalty instead, which is venue-specific.

Type	Possible Values	Description
Service Status Type	Active	Service has occurred.
	Missed	Expected whelping data has passed, but no pups have been born.
	No Live Pups	Pups were born, but none survived until notification of Whelping.
	Whelped	Whelping has occurred, and at least one pup survived until notification of Whelping.
	Invalid	The record contains invalid data, and should be ignored.

Type	Possible Values	Description
Service Type	Natural	Natural Service.
	FSI	Frozen Semen Service.
	Unknown	Type of Service is unknown. (Used to record the litters of international dogs).

Type	Possible Values	Description
Dog Grade Type	1	Grade 1
	2	Grade 2
	3	Grade 3
	4	Grade 4
	5	Grade 5
	6	Grade 6
	7	Grade 7
	M	Maiden
	G	Graduation
	J	Juvenile
	Q	Qualify
	N	Novice
	C5	Grade 1 for New Zealand
	C4	Grade 2 for New Zealand
	C3	Grade 3 for New Zealand
	C2	Grade 4 for New Zealand
	C1	Grade 5 for New Zealand
	C0	Maiden for New Zealand
	M1	Masters Grade 1 for NSW
	M2	Masters Grade 2 for NSW
	M3	Masters Grade 3 for NSW

Type
Dog Marking Type
Possible Values	Description	Possible Values	Description
U	Unknown	LTF	Light Fawn
BD	Brindle	LTFW	Light Fawn & White
BDW	Brindle & White	RBD	Red Brindle
BDWT	Brindle & White Ticked	RBDW	Red Brindle & White
BE	Blue	RF	Red & Fawn
BEBD	Blue Brindle	RFW	Red Fawn & White
BEBDW	Blue Brindle & White	W	White
BEDUN	Blue Dun	WBD	White & Brindle
BEF	Blue Fawn	WBDT	White with Brindle Ticking
BEFW	Blue Fawn & White	WBE	White & Blue
BEW	Blue & White	WBEBD	White & Blue Brindle
BK	Black	WBEF	White & Blue Fawn
BKBD	Black Brindle	WBET	White with Blue Ticking
BKBDW	Black Brindle & White	WBK	White and Black
BKW	Black & White	WBKBD	White & Black Brindle
DKBD	Dark Brindle	WBKBE	White Black & Blue
DKBDW	Dark Brindle & White	WBKT	White with Black Ticking
DKF	Dark Fawn	WDKBD	White and Dark Brindle
DKFW	Dark Fawn & White	WDKF	White and Dark Fawn
DUN	Dun	WDUN	White and Dun
DUNB	Dun Brindle	WF	White and Fawn
DUNF	Dun Fawn	WFT	White with Fawn Ticking
DUNW	Dun & White	WLTBD	White and Light Brindle
F	Fawn	WLTF	White and Light Fawn
FBD	Fawn Brindle	WRBD	White and Red Brindle
FW	Fawn & White	WRF	White and Red Fawn
LTBD	Light Brindle	WDUNBD	White and Dun Brindle
LTBDW	Light Brindle & White	DUNBDW	Dun, Brindle and White

Dog Lifestate is a complex type, consisting of a status, sub status, and further information:

Type	Status	Sub Status	Further Information	Possible Values (for Further Information)
Dog Lifestate	Unnamed	(none)	(none)	(none)
	Racing	(none)	(none)	(none)
	Retired	Pet	Keeper	owner trainer third party
		Breeding	Keeper	owner leased
		GAP	(none)	(none)
		Surrendered to another agency	(none)	(none)
		Exported	(none)	(none)
		Other	(none)	(none)
	Deceased	Euthanised	Reason	injury unsuitable for rehousing lack of ability at track other
		Natural Causes	(none)	(none)
		Accident	(none)	(none)
		Other	(none)	(none)

The following table defines a single multi-field type:

Type	Field	Type	Description
FSI Details Type	Inseminator	String	The individual (typically a vet) who performed the insemination.
	Facility	String	The name of the facility where the insemination was performed.
	Breeding Unit Service Set	Sequence of Strings	The IDs of the Breeding Units.
	ServiceState	statetype	ACT NSW NT NZ QLD SA TAS VIC WA GA INTL

Trial Required Type

• 
  A Dog Penalty may or may not require a trial to be completed,
  

Type	Field	Type	Description
Trial Required Type	Track	Track Code Type	Optional. Code of the track where the penalty was imposed and where the trial is required to be performed.
	Track Expiration Date	Date	Optional. Date the dog penalty expires at the originating track.
	Distance	Integer	Optional. Not used by all states.-eg. Not used by Vic, but are required for SA and WA. Distance (in meters) the trial is required to be conducted over to to meet Penalty Clearnace requirements.

Dog Trial Type

Type	Field	Type	Description
Dog Trial Type	Authority	Authority Type	The authority which posted the trial to the NDR
	Track	Track Code Type	Mandatory. The code of the track where the trial was performed.
	Date of Trial	Date	Mandatory. The date the trial was performed.
	Distance	Integer	Mandatory. The distance of the trial.
	Field	Trial Field Type	Mandatory. The number of runners in the trial,.
	Box No	Integer	Mandatory. The number of the box where the dog started the trial.
	Weight	Decimal	Optional. The weight of the dog.
	Time	Decimal	Optional. The time achieved by the dog in the trial.
	Place	Either Finished Result Type or Other Result Type can be entered.	Optional. The place achieved by the dog in the trial.
	Margin	Margin Type	Optional. The margin of the dog with respect to the winner of the trial.
	Trial Reason	Trial Reason Type	Mandatory. The reason a trail was required.
	Trial Result	Trial Result Type	Mandatory. Whether the Trial was successful (pass) or not (fail).

Dog Penalty Clearance Type

Multiple Dog Penalty Clearance rows may be created for a single Dog Penalty.

For example, multiple Dog Penalty Clearance rows may be required when a Clearance Type is Cleared all tracks except originating track (CATEX). In this case a second row may be created to record the fact that a trial was run at the originating track and the Clearance Type is now Cleared All Tracks (CAT).

Type	Field	Type	Description
Dog Penalty Clearance Type	Track	Track Type	Mandatory. The track at which the Clearance Type is recorded. This will assist when looking for the completed clearance trial.
	Cleared date	Date	Mandatory. The date the dog is partially or completely cleared of the penalty.
	Clearance Code	Penalty Clearance Code Type	Mandatory. Whether the clearance covers all tracks or all except the originating track. For further clearance conditions, such as distance, each state can assess the trial results.