MORGAM Manual

MORGAM logo

Data Transfer Format: Baseline Data Addition 2

  • Form: 30
  • Version: 1
  • Date: 05.07.2002
Valid HTML 4.01!
© National Institute for Health and Welfare and the MORGAM Project investigators
Last updated: 31 October 2007
For more information, please contact Kari Kuulasmaa (firstname.lastname@thl.fi)

The purpose of this transfer format is to provide an exact and common format for the MORGAM Participating Centres (MPCs) to transfer baseline data on triglycerides and fibrinogen to the MORGAM Data Centre (MDC). Data in the format specified here should be submitted to the MDC for every member of each MORGAM cohort in which triglycerides and/or fibrinogen were measured. For cohorts where such measurement were not done at all, it is sufficient that the MPC informs the MDC about this. The members of the cohort are defined in section Definition and selection of cohorts. The data should be sent through e-mail, not on paper forms.

Contents


Format specification

ITEM NAME SPECIFICATION AND CODES CHARACTERS COLUMNS
1 FORM Form identification |_3|_0| 1 to 2
2 VERSN Form version |_1| 3
3 CENTRE MORGAM Participating Centre |__|__| 4 to 5
4 RUNIT MORGAM Reporting Unit |__|__| 6 to 7
5 COHORT Cohort identification within the RUNIT
01 = MONICA baseline survey
02 = MONICA middle survey
03 = MONICA final survey
21, 22... other cohorts		 |__|__| 8 to 9
6 SERIAL Serial number |__|__|__|__|__|__| 10 to 15
7 EVENT Irrelevant
(For data management purposes)		 |_8|_8| 16 to 17
8 MBIRTH Month and year of birth (month, year) |__|__||__|__|__|__| 18 to23
9 SEX Sex
1 = male
2 = female		 |__| 24

Items TRIGL...FASTING: Triglycerides
10 TRIGL Serum triglycerides (mmol/l and two decimals)
8888= serum triglycerides measured in units mg/dl
9999 = insufficient data		 |__|__|, |__|__| 25 to 28
11 TRIGLDL Serum triglycerides (mg/dl)
8888 = serum triglycerides measured in units mmol/l
9999 = insufficient data		 |__|__|__|__| 29 to 32
12 DTRIGL Date of the laboratory analysis of serum triglycerides (day, month, year) |__|__||__|__||__|__|__|__| 33 to 40
13 FASTING Fasting status
1 = fasting
2 = semi-fasting
3 = non-fasting
9 = insufficient data		 |__| 41
Items FIBR...DFIBR: Fibrinogen
14 FIBR Plasma fibrinogen (g/l and two decimals)
8888= plasma fibrinogen measured in units mg/dl
9999 = insufficient data		 |__|__|,|__|__| 42 to 45
15 FIBRDL Plasma fibrinogen (mg/dl)
8888 = plasma fibrinogen measured in units g/l
9999 = insufficient data		 |__|__|__|__| 46 to 49
16 DFIBR Date of the laboratory analysis of plasma fibrinogen  (day, month, year) |__|__||__|__||__|__|__|__| 50 to 57

To the top of the form

General Instructions

The record format is ASCII fixed length and record size is 54 characters. The position of each data item in the record is given in column "COLUMNS" of this data transfer format. There should be one record of data for every member of each MORGAM cohort.

This format corresponds with the layout of the information on the electronic data file which is transferred, and need not correspond with the format of locally used paper forms or electronic files. Instructions for transferring the data are given in section Data communication between the Participating Centres and the MDC. To avoid errors, special attention should be paid in extracting these data items from the local data set.

The ITEM NAME on the document is a computer variable name used for the item by the MDC.

Blank fields are not allowed in the record.

Instructions for making corrections to data that have already been sent to the MDC are given in section Data communication between the Participating Centres and the MDC.

Please contact the MDC for instructions if you cannot provide information as specified in this document or if you have any problems with the interpretation of the coding for any specific items.

To the top of the form

Specific instructions for each item

Follow these instructions carefully when creating a computer file for the data transfer from the MPC to the MDC.

1 FORM Form identification |_3|_0|

Number 30 indicates the "Data transfer format: baseline data addition 2".

To the top of the form

2 VERSN Form version |_1|

Enter the version number from the heading of the "Data transfer format: baseline data addition 2" which you are using. If the version number of the data transfer format which you are using is not "1", these instructions do not correspond to the format you are using. Check that you are using the valid version of the format.

To the top of the form

Items CENTRE...SERIAL

3 CENTRE MORGAM Participating Centre |__|__|
4 RUNIT MORGAM Reporting Unit |__|__|
5 COHORT Cohort identification within the RUNIT
01 = MONICA baseline survey
02 = MONICA middle survey
03 = MONICA final survey
21, 22... other cohorts		 |__|__|
6 SERIAL Serial number |__|__|__|__|__|__|

These are key items used for merging the different records of the same individual. Please make sure that the codes are identical with those used for the same person in the "Data transfer format: MONICA survey data".

To the top of the form

7 EVENT Irrelevant
(For data management purposes)		 |_8|_8|

Code 88 (irrelevant). The purpose of this item is to reserve fixed columns for the key items in all data transfer formats. This is a key item in the event data formats, but irrelevant for the other data transfer formats.

To the top of the form

8 MBIRTH Month and year of birth (month, year) |__|__||__|__|__|__|

The first two columns are for the month; code 01 - 12, or code 99 if the month is not known. Enter the year of birth, in full four characters, in the last four columns. If the year of birth is not known, which should be very rare, derive the year of birth from an estimate of the age.

This item is the same as item MBIRTH of the MONICA Survey Data record, and it will be used for double checking the key items. If you compile the data for this record from various sources, please extract the data for this item from a different source than for the "Data transfer format: MONICA survey data"

To the top of the form

9 SEX Sex
1 = male
2 = female		 |__|

This item is the same as item SEX of the "Data transfer format: MONICA survey data", and it will be used for double checking the key items. If you compile the data for this record from various sources, please extract the data for this item from a different source than for the MONICA survey record.

To the top of the form

Items TRIGL...FASTING:

10 TRIGL Serum triglycerides (mmol/l and two decimals)
8888= serum triglycerides measured in units mg/dl
9999 = insufficient data		 |__|__|, |__|__|

 

Record here serum triglycerides to two decimal places in mmol/l.

Code 8888 if laboratory values are given in mg/dl. This code should be used either for all or for none in the cohort.
Code 9999 if triglycerides were not measured or the result is not available.

To the top of the form

11 TRIGLDL Serum triglycerides (mg/dl)
8888 = serum triglycerides measured in units mmol/l
9999 = insufficient data		 |__|__|__|__|

If serum triglyceride values in the laboratory are given in units mg/dl record these values here.

Code 8888 if laboratory values are given in mmol/l. This code should be used either for all or for none in the cohort.
Code 9999 if triglycerides were not measured or the result is not available.

To the top of the form

12 DTRIGL Date of the laboratory analysis of serum triglycerides (day, month, year) |__|__||__|__||__|__|__|__|

Enter here the exact date of the serum triglycerides determination in the laboratory.

The first two columns are for the day of the determination. Use an initial "0" for numbers 1-9 (i.e. 01-09). Code 99 if the exact day is unknown.
The next two columns are for the month of the determination. Code 99 if the month remains unknown.
Enter the year of termination, in full four characters, in the last four columns. Code 9999 if the year remains unknown; this should occur very rarely.
Code 99999999 if triglycerides were not measured or the result is not available.

To the top of the form

13 FASTING Fasting status
1 = fasting
2 = semi-fasting
3 = non-fasting
9 = insufficient data		 |__|

The subject's fasting period immediately preceding the blood sampling for measurement of triglycerides.

Code 1 if there was overnight fasting or fasting known to have lasted at least 8 hours before blood sampling.
Code 2 if fasting before blood sampling lasted at least 4 hours but less than overnight or 8 hours.
Code 3 if the subject has eaten within 4 hours before blood sampling.

Items FIBR...DFIBR: Fibrinogen

14 FIBR Plasma fibrinogen (g/l and two decimals)
8888= plasma fibrinogen measured in units mg/dl
9999 = insufficient data		 |__|__|,|__|__|

Record here plasma fibrinogen to two decimal places in g/l.

Code 8888 if laboratory values are given in mg/dl. This code should be used either for all or for none in the cohort.
Code 9999 if fibrinogen were not measured or the result is not available.

To the top of the form

15 FIBRDL Plasma fibrinogen (mg/dl)
8888 = plasma fibrinogen measured in units g/l
9999 = insufficient data		 |__|__|__|__|

If plasma fibrinogen values in the laboratory are given in units mg/dl record these values here.

Code 8888 if laboratory values are given in g/l.  This code should be used either for all or for none in the cohort.
Code 9999 if fibrinogen were not measured or the result is not available.

To the top of the form

16 DFIBR Date of the laboratory analysis of plasma fibrinogen  (day, month, year) |__|__||__|__||__|__|__|__|

Enter here the exact date of the plasma fibrinogen determination in the laboratory.

The first two columns are for the day of the determination. Use an initial "0" for numbers 1-9 (i.e. 01-09). Code 99 if the exact day is unknown.
The next two columns are for the month of the determination. Code 99 if the month remains unknown.
Enter the year of termination, in full four characters, in the last four columns. Code 9999 if the year remains unknown; this should occur very rarely.
Code 99999999 if fibrinogen were not measured or the result is not available.

To the top of the form

Updates

Date Update
2007-10-31 The general instructions were reorganized, and the filename was changed from form304.htm to form30.htm.