Ndr interface Dependency Agreement



Yüklə 0,71 Mb.
səhifə33/36
tarix02.01.2022
ölçüsü0,71 Mb.
#26773
1   ...   28   29   30   31   32   33   34   35   36

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:

  1. number of members in the group < 2

OR

  1. 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.


Yüklə 0,71 Mb.

Dostları ilə paylaş:
1   ...   28   29   30   31   32   33   34   35   36




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin