NATO UNCLASSIFIED
A4 LMXjk

NATO UNCLASSIFIED

The PMR with Excel

The PMR with Excel

in AeroMedical Evacuation

in AeroMedical Evacuation

LT COL JUERGEN K. KNUEPPEL, GE AF

Ramstein

NATO UNCLASSIFIED
A4 LMXjk

NATO UNCLASSIFIED

-Large

numbers

of patients

-Many details

for validation

-

Easy

to use, easy to modify

-Availability

worldwide

-Also

civilian use

possible

Aero Med PMR, Details

Aero Med PMR, Details

NATO UNCLASSIFIED
A4 LMXjk

NATO UNCLASSIFIED

•

DATA Acquisition for AE

DATA Acquisition for AE

(Validation,Record-Keeping, Processing,

(Validation,Record-Keeping, Processing,

Storing)

Storing)

1.

1.

Personnel Data

Personnel Data

2.

2.

Unit Data

Unit Data

3.

3.

Diagnostic Data

Diagnostic Data

4.

4.

Evacuation Needs

Evacuation Needs

5.

5.

Location Data

Location Data

6.

6.

AC and Flight Data

AC and Flight Data

7.

7.

Equipment

Equipment

8.

8.

Transmission Issues / Secure

Transmission Issues / Secure

DATA

DATA

9.

9.

Other

Other

Communication Aspects

Communication Aspects

More than 100 Items

More than 100 Items

To file a professional request!

NATO UNCLASSIFIED
A4 LMXjk

NATO UNCLASSIFIED

#

Ser Date RequCCStatName InitNat Sx Serv Diagnosis

ClasDpndPrty Equipment

TpMov

T&S

OMF

DEST

FltNo

Date

Actyp

ETD

13 198 D+5

LCC

E3 Richard S NL

m Army burn hand

IV

4

R bandage

tac

*

ManankaraMananjary medevac01 14-Nov-01 C130 14 Nov,1320

14 199 D+5

LCC

E2 Novem M EST m Army pancreatitis

IIA

2

U IV pump

tac

*

Marosangi Mananjary

by car

15 203 D+5

LCC

E2 Delta

G UK m Army 2 eyes injury penet

IIB

3

P Alt Rest SL tac

*

Antananarivo

Toamasinamedevac01 14-Nov-01 C130 14 Nov,0935

16 204 D+5

LCC

E2 Charly

I UK m Army hand trauma

IV

4

R

tac

*

Antananarivo

Toamasinamedevac01 14-Nov-01 C130 14 Nov,0935

32 209 D+5

LCC

E2 Zulu

B FIN m Army distortion left footIIIA

4

R

strat

ToamasinaRamstein stratevac01 14-Nov-01 A310 14 Nov,1900

33 210 D+5

LCC

E5 Zephir

V AU m Army 1 eye injury

IV

4

R

strat

ToamasinaRamstein stratevac01 14-Nov-01 A310 14 Nov,1900

34 211 D+6

LCC

E4 Quest

Q PL

m Army hernia, inguinal IV

4

R

strat

*

Mananjari Ramstein stratevac01 14-Nov-01 A310 14 Nov,1900

35 212 D+6

LCC

E3 Uniform N US m Army burn hand

IV

4

R Bandage

strat

*

Mananjari Ramstein stratevac01 14-Nov-01 A310 14 Nov,1900

36 213 D+6

LCC

O1 Opel

D UK m Army 1 eye injury

IV

4

R

strat

*

Mananjari Ramstein stratevac01 14-Nov-01 A310 14 Nov,1900

37 214 D+6

LCC

E5 Bertha A PL

f Army neurosis

IC

4

R Sitting

strat

*

ToamasinaRamstein stratevac01 14-Nov-01 A310 14 Nov,1900

38 370 D+5 MCC

E9 Victory E LT

m Navy pneumonia

IIB

3

R Oxygen

tac

*

ManankaraMananjary medevac01 14-Nov-01 C130 14 Nov,1320

39 372 D+5 MCC

E2 Hotel

J BE m Navy Hand Trauma

IIIB 3

R Bandage

tac

*

MahajangaMananjary medevac03 14-Nov-01 C130 14 Nov,0900

44 372 D+6 MCC

E2 Hotel

J BE m Navy Hand Trauma

IIIB 3

R Bandage

strat

*

Mananjari Brussels stratevac01 14-Nov-01 A310 14 Nov,1900

45 373 D+5 MCC

E2 J uliett

I LT

m Navy 1EyeInjur

IIIB 3

P

strat

ToamasinoBrussels stratevac01 14-Nov-01 A310 14 Nov,1900

46 374 D+6 MCC O1 Sierra

H PL

m Navy Distorsion

IIIB 4

R

strat

*

ToamasinoBrussels stratevac01 14-Nov-01 A310 14 Nov,1900

47 375 D+5 MCC O2 Michel X CZ m Navy LegMines

IIB

2

P Propaq, IV

strat

Mananjari Brussels stratevac01 14-Nov-01 A310 14 Nov,1900

48 376 D+5 MCC

E1 Mike

G NO m Navy Burn.Hand

IV

4

R Bandage

strat

Mananjari Brussels stratevac01 14-Nov-01 A310 14 Nov,1900

49 377 D+6 MCC RC Water

D EST m Navy HeadTrau

IIB

3

R

strat

*

Mananjari Brussels stratevac01 14-Nov-01 A310 14 Nov,1900

50 332 D+5 RACC E3 Sierra

X Mol m RACC Head Trauma

IIA

3

U Propaq Hdrst tac

*

Antananarivo

Toamasinomedevac01 14-Nov-01 C130 14 Nov,0935

51 334 D+5 RACC E7 Richard C US m RACC Head Trauma

IIIB

3

R Headrest O2 tac

*

Antananarivo

Toamasinomedevac01 14-Nov-01 C130 14 Nov,0935

52 338 D+5 RACC E5 Xray

U GE m RACC Trauma EA

IIIA

3

R

tac

*

MahajangaMananjary medevac03 14-Nov-01 C130 14 Nov,0900

53 331 D+5 RACC E2 Pipa

P AU m RACC Burned Leg

IV

3

R Bandage

strat

Mananjari Brussels stratevac01 14-Nov-01 A310 14 Nov,1900

54 332 D+6 RACC E3 Sierra

X Mol m RACC Head Trauma

IIA

3

U Propaq Hdrststrat

*

ToamasinoBrussels stratevac01 14-Nov-01 A310 14 Nov,1900

55 333 D+5 RACC O1 Albert

N Sw m RACC Acute PsychosisIA

2

P Restraint

strat

ToamasinoBrussels stratevac01 14-Nov-01 A310 14 Nov,1900

56 334 D+6 RACC E7 Richard C US m RACC Head Trauma

IIIB

3

R Headrest O2 strat

*

ToamasinoBrussels stratevac01 14-Nov-01 A310 14 Nov,1900

57 335 D+5 RACC E4 Bertha E BU m RACC Burn Injury

IIB

3

R IV Pump

strat

ToamasinoBrussels stratevac01 14-Nov-01 A310 14 Nov,1900

58 336 D+5 RACC E9 Hotel

N Cz

m RACC Post Laparot.

IIB

3

R IV, Medic

strat

ToamasinoBrussels stratevac01 14-Nov-01 A310 14 Nov,1900

59 337 D+5 RACC E7 Hotel

D Slk m RACC Distorsion

IIIB

4

R

strat

ToamasinoBrussels stratevac01 14-Nov-01 A310 14 Nov,1900

60 338 D+6 RACC E5 Xray

U GE m RACC Trauma EA

IIIA

3

R

strat

*

Mananjari Brussels stratevac01 14-Nov-01 A310 14 Nov,1900

61 202 D+5

ACC

E3 WhiskeyN AU m AF Hand trauma

IV

4

R

tac

*

Besalampi Toamasinomedevac03 14-Nov-01 C130 14 Nov,1045

AOC /AECC: AC and Times, sent back to

AOC /AECC: AC and Times, sent back to

PECC

PECC

NATO UNCLASSIFIED
A4 LMXjk

NATO UNCLASSIFIED

#

Ser Date RequCCStatName InitNat Sx Serv Diagnosis

ClasDpndPrty Equipment

TpMov

T&S

OMF

DEST

FltNo

Date

Actyp

ETD

14 199 D+5

LCC

E2 Novem M EST m Army pancreatitis

IIA

2

U IV pump

tac

*

Marosangi Mananjary

by car

50 332 D+5 RACC E3 Sierra

X Mol m RACC Head Trauma

IIA

3

U Propaq Hdrst tac

*

Antananarivo

Toamasinomedevac01 14-Nov-01 C130 14 Nov,0935

54 332 D+6 RACC E3 Sierra

X Mol m RACC Head Trauma

IIA

3

U Propaq Hdrststrat

*

ToamasinoBrussels

stratevac01 14-Nov-01 A310 14 Nov,1900

Find Special Patients by

SORT – Funktion

FILTER - Funktion

All

All

2A

-Patients

-Patients

NATO UNCLASSIFIED
A4 LMXjk

NATO UNCLASSIFIED

WAY AHEAD

WAY AHEAD

•

Database Elements (

Database Elements (

MS-APPLICATION

MS-APPLICATION

!)

!)

•

Patient Movement Request (PMR)

Patient Movement Request (PMR)

Concepts

Concepts

•

Security

Security

Programs for MED

Programs for MED

NATO UNCLASSIFIED
A4 LMXjk

NATO UNCLASSIFIED

P

P

atient

atient

M

M

ovement

ovement

R

R

equest Form:

equest Form:

- Spreadsheets (like

- Spreadsheets (like EXCEL), easy to use

System

System

- NATO

- NATO Standards ( Medical DATA Set)

exist

exist

-All

-All military and civilian

Med Units

Med Units can

use it

use it

- Spreadsheets (like

- Spreadsheets (like

EXCEL), easy to use

System

System

- NATO

- NATO

Standards ( Medical DATA Set)

exist

exist

-All

-All

military and civilian

Med Units

Med Units

can

use it

use it

NATO UNCLASSIFIED
A4 LMXjk

NATO UNCLASSIFIED

Comments, Questions . . . ?