MX_EXP
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_EXP
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_EXP
3
MX_BNR15
PK-2
number of holding
registration number of holding, long format (for member state exchange)
dec
15
0
<BNR>
MX_EXP
4
MX_EXP_DAT
PK-3
date of export
date
<NEIN>
MX_EXP
5
MX_STA_DES
MAN
state of destination
ISO-Code of state where the animal is exported to (for member state exchange)
int
3
ILAND
MX_EXP
6
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_EXP
7
MX_STA_BIR
OPT
state of birth
ISO-Code of state where the animal was born (for member state exchange)
int
3
ILAND
MX_EXP
8
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_EXP
9
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_EXP
10
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_EXP
11
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_EXP
12
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_EXP
13
MX_BRE_ORG
OPT
original breed or colour
breed or colour code of sending member state (for member state exchange)
int
4
<NORM>
MX_EXP
14
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_EXP
15
MX_SEX
OPT
sex of animal
sex of animal (for member state exchange)
int
1
MX_SEX
MX_EXP
16
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_EXP
17
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_EXP
18
MX_NTF_WAY
SYS
way of notification, reporting channel
reporting channel (mail, voice response, online internet, batch...)
int
2
MX_NTF_WAY
MX_EXP
19
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_EXP
20
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_EXP
21
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_EXP
22
MX_SYS_VON
SYS
begin timestamp
timestamp of when data was physically stored in data base
timestamp of physical storing
ts
<NEIN>
MX_EXP
23
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_EXP
24
MX_SYS_STA
SYS
system state of data
system state of data according to code set
int
4
MX_SYS_STA
MX_EXP
25
MX_SYS_CLU
SYS
internal cluster
for internal use
int
4
0
9999
<NEIN>
MX_EXP
26
MX_CALF_ST
OPT
calving status
is calving state of animal known (for member state exchange)
int
1
MX_CALF_ST