Medical Data Import

Use

You can import the results of medical tests from laboratories or technical medical equipment to the SAP system as ASCII files.

This function is only available for the following three examination categories:

Audiogram
Laboratory examination
Pulmonary function test
Note
If you want to import data for your own examination categories, you need to use the existing function modules as copy templates and adjust only those subroutines that affect the actual data transfer itself and do not operate on the key fields (in other words, are not part of the include LEHS00MDATAUPLF01).

The function modules available in function group EHS00MDATAUPL are:
- EHS_AUD_UPL (Upload of Audiometer Data)
- EHS_PUL_UPL (Upload of Pulmonary Function Data)
- EHS_LAB_UPL (Upload of Laboratory Data)
- EHS_PROT_DEL (Deletion of Logs for Object EHS_OH_IM)
End of the note.

Integration

Medical data is imported in the medical service component.

Requirements

The data is available in electronic form as ASCII files. To ensure that the data can be assigned to the correct fields in the SAP system, each examination category must have the following structure:

Audiogram Examination Category

Field Name	Type	Length	Format
service_prov	Char	10		Key
person_reference	Char	20
exam_code	Char	6
person	Char	25		Data
short_name	Char	5
audio_baseline	Char	1
audio_machine	Char	20
audio_software	Char	20
exam_date	Char	8	yyyymmdd
exam_time	Char	6	hhmmss
db_left_125	Char	13
db_right_125	Char	13
db_left_250	Char	13
db_right_250	Char	13
db_left_500	Char	13
db_right_500	Char	13
db_left_1000	Char	13
db_right_1000	Char	13
db_left_2000	Char	13
db_right_2000	Char	13
db_left_3000	Char	13
db_right_3000	Char	13
db_left_4000	Char	13
db_right_4000	Char	13
db_left_6000	Char	13
db_right_6000	Char	13
db_left_8000	Char	13
db_right_8000	Char	13
uname	Char	12
aedtm	Char	8	yyyymmdd

Laboratory Examination Category

Field Name	Type	Length	Format
service_prov	Char	10		Key
person_reference	Char	20
exam_code	Char	6
test_no	Char	8		Data
laboratory_patient	Char	10
patient_name	Char	50
exam_date	Char	8	yyyymmdd
exam_time	Char	6	hhmmss
reference_ext	Char	20
type_test	Char	60
result_value	Char	60
result_uom	Char	20	SAP unit of measurement
result_reference_range	Char	60
result_normal_low	Char	7
result_normal_high	Char	7
result_abnormal_flag	Char	5
abnormality1	Char	1
abnormality2	Char	1
result_status	Char	1
uname	Char	12
aedtm	Char	8	yyyymmdd

Pulmonary Function Test Examination Category

Field Name	Type	Length	Format
service_prov	Char	10		Key
person_reference	Char	20
exam_code	Char	6
person	Char	25		Data
pulmo_machine	Char	20
pulmo_software	Char	20
exam_date	Char	8	yyyymmdd
exam_time	Char	6	hhmmss
fev1_observed	Char	13
fev1_predicted	Char	13
fvc_observed	Char	13
fvc_predicted	Char	13
fev1_fvc_percent_obs	Char	13
fev1_fvc_percent_pred	Char	13
peak_flow	Char	13
vc	Char	22
uname	Char	12
aedtm	Char	8	yyyymmdd

The field names are filled with characters of Char type in the specified length and in the predefined format and follow one another to form one single character string in the ASCII file.

Caution Caution

The entries must keep to the specified length because the characters cannot be identified otherwise. This means that you must enter a blank character for unused spaces.

End of the caution.

The characters for the first three fields, service_prov, person_reference, and exam_code, make up the key that is used to assign the data in the ASCII file to the corresponding object in the SAP system. For this purpose, the person_reference key field must be specified first: The entry in this field can be a medical service number, a personnel number, or a social insurance number. In Customizing for Occupational Health, you can specify, for each examination category, to which of the three objects data is to be assigned.

Features

The further you go into the medical service, the more restrictions you can impose on the number of data records that are imported.
You can display a log of successful and unsuccessful imports.

Activities

Importing Test Results