| ATTRIBUTE NAME | DATA TYPE | M/O | KEY | DESCRIPTION |
|---|---|---|---|---|
| KEPT_ANIMAL_ID | xs:string(200) | M | PK | Dummy identifier OR official identifier (according to the MS visibility policy) of the individual kept animal (for the relevant species). The standards may change according to the relevant legislation. [Commission Implementing Regulation (EU) 2017/949, art. 2] |
| KEPT_ANIMAL_UPDATEY | xs:int(4) | M | Year – Date at which the information was generated (last update) | |
| KEPT_ANIMAL_UPDATEM | xs:int(4) | M | Month – Date at which the information was generated (last update) | |
| KEPT_ANIMAL_UPDATED | xs:int(4) | M | Day – Date at which the information was generated (last update) | |
| ESTABLISHMENT_ID | xs:string(200) | M | FK | Dummy identifier OR official identifier (according to the MS visibility policy) of the Establishment to which the animal belongs |
| SUB_UNIT_ID | xs:string(200) | M | FK | Dummy identifier OR official identifier (according to the MS visibility policy) of the sub‐unit to which the animal belongs |
| SPECIES | SpeciesEnum (only mammals) | M | The common name, the genus, the species and the breed of the sub‐unit of concern. This is particularly relevant in the cases in which the single animals do not have an animal id | |
| PRODUCTION_TYPE | ProductionTypeEnum (only related to mammals) | M | Type of final product of the Establishment OR aim for which the animals are kept and/or bred | |
| SEX | GenderEnum | M | Sex of the kept animal | |
| BIRTH_Y | xs:int(4) | O | Year – Date of birth of the kept animal | |
| BIRTH_M | xs:int(2) | O | Month – Date of birth of the kept animal | |
| BIRTH_D | xs:int(2) | O | Day – Date of birth of the kept animal | |
| BIRTH_ESTABLISHMENT_ID | xs:string(200) | O | Dummy identifier OR official identifier (according to the MS visibility policy) of the Establishment where the kept animal was born. The standards may change according to the relevant legislation | |
| BIRTH_SUB_UNIT_ID | xs:string(200) | O | Dummy identifier OR official identifier (according to the MS visibility policy) of the Sub_unit where the kept animal was born. The standards may change according to the relevant legislation | |
| BIRTH_COUNTRY | xs:string(2) | O | ISO code of the country where the kept animal was born | |
| MOTHER_ANIMAL_ID | xs:string(200) | O | Dummy identifier OR official identifier (according to the MS visibility policy) of the mother of the individual kept animal (for the relevant species). The standards may change according to the relevant legislation. This attribute is logically a link referring the same KEPT_ANIMAL table. As such is should be captured as FK, but since data of the referred animal might not be contained in the same table (i.e. animal died or moved in a different country prior to any data submission) the constraint is not strictly implemented |
MS: Member State; PK: Primary Key; FK: Foreign Key.