MX_IMP 1
MX_STA_MX PK-4
member state
ISO-Code of member state who provided data (for member state exchange)
276 for data provided by Germany, data provided by other member state - 3 digit ISO-Code of state
int
3
ILAND
MX_IMP
2
MX_EARTG PK-1
ear tag
ear tag number for identification of the animal in numerical format (for member state exchange)
dec
15
0
<NORM>
MX_IMP
3
MX_BNR15 PK-2
number of holding
registration number of holding, long format (for member state exchange)
dec
15
0
<BNR>
MX_IMP
4
MX_IMP_DAT PK-3
date of import
date of import (for member state exchange)
date
<NEIN>
MX_IMP
5
MX_STA_ORG OPT
state of origin
ISO-Code of state where the animal is coming from (for member state exchange)
int
3
ILAND
MX_IMP
6
MX_STA_BIR OPT
state of birth
ISO-Code of state where the animal was born (for member state exchange)
int
3
ILAND
MX_IMP
7
MX_BNR15_O OPT
number of holding of origin
holding of origin, i.e. where birth, first tagging or import happened (for member state exchange)
dec
15
0
<BNR>
MX_IMP
8
MX_EARTG_M OPT
ear tag mother
ear tag number of mother animal in numerical format (for member state exchange)
dec
15
0
<NORM>
MX_IMP
9
MX_EARTG_F OPT
ear tag father
ear tag number of father animal in numerical format (for member state exchange)
optional for member state exchange, not content of regular notification in Germany
dec
15
0
<NORM>
MX_IMP
10
MX_EARTG_A OPT
old ear tag, non-standard format
ear tag number in old alpha-numerical non standard format (for member state exchange)
char
20
<NEIN>
MX_IMP
11
MX_BIR_DAT OPT
date of birth
date of birth the animal (for member state exchange)
date
01.01.1890
31.12.2100
<NEIN>
MX_IMP
12
MX_BRE_ORG OPT
original breed or colour
breed or colour code of sending member state (for member state exchange)
int
4
<NORM>
MX_IMP
13
MX_BRE_UNI OPT
unified breed code
unified breed code of the animal within EC (for member state exchange)
automatically updated by system acording to state of origin and MX_BRE_ORG (not yet operational)
lng
9
<NORM>
MX_IMP
14
MX_SEX OPT
sex of animal
sex of animal (for member state exchange)
int
1
MX_SEX
MX_IMP
15
MX_PREM OPT
premium state
premium state livestock premium in member state or from state of origin (for member state exchange)
in Germany no livestock premium, only mother cow premium, or information from former EU-import
int
4
MX_PREM
MX_IMP
16
MX_VET_BAN OPT
veterinary ban within member state
according to common code set (for member state exchange)
not implemented yet in Germany
int
4
MX_VET_BAN
MX_IMP
17
MX_NTF_WAY SYS
way of notification, reporting channel
reporting channel (mail, voice response, online internet, batch...)
int
2
MX_NTF_WAY
MX_IMP
18
MX_NTF_DAT MAN
date of notification
date when notification was registered
date of notification in original database of the sending member state
date
01.01.1999
31.12.2100
<NEIN>
MX_IMP
19
MX_NTF_BNR SYS
annunciator, registration number
registration number of holding or organisation, responsible for data notification
registration-number of logged in user
dec
15
0
<BNR>
MX_IMP
20
MX_NTF_MBN SYS
annunciator, personal sub-number
sub-number of person within organisation, responsible for data notification/notification
sub-number of logged in user
int
5
0
32768
<NEIN>
MX_IMP
21
MX_SYS_VON SYS
begin timestamp
timestamp of when data was physically stored in data base
timestamp of physical storing
ts
<NEIN>
MX_IMP
22
MX_SYS_BIS SYS
end timestamp
timestamp until when data is valid
31.12.2100 marks valid record, otherwise timestamp when data was revoked
ts
<NEIN>
MX_IMP
23
MX_SYS_STA SYS
system state of data
system state of data according to code set
int
4
MX_SYS_STA
MX_IMP
24
MX_SYS_CLU SYS
internal cluster
for internal use
int
4
0
9999
<NEIN>
