NIPO ODIN Version 5.17

Previous Topic

Next Topic

Automatic Syntax Change When Referencing Positions in T-files

When using positions instead of Sample table fields in an S-file, a single run on the NIPO Fieldwork System changes the position references into field references. This happens because the system interprets a T-file as a Sample table internally - all positions within a T-file fall within a corresponding database field.

Example of a stratification file referencing positions in a T-file

286: 1 (6) Males
286: 2 (6) Females

Position 286 and beyond correspond with the field TTExtraData in the sample table. The references are changed accordingly.

Result after a start in the NIPO Fieldwork System

TTExtraData:1 ( 6) Males
TTExtraData:2 ( 6) Females

Note that stratification criteria may not overlap database fields; data may cross two fields if positions are referenced on the border of two fields.

Example of stratification that overlaps Sample table fields

5: 11 (6) region 1 - Males
285: 12 (6) region 1 - Females

Position 285 is the last position of DisplayField4 and position 286 is the first position of ExtraData. As a result, criteria are only checked against the first character of the stratum.

Example 2 of stratification file referencing positions in a T-file

246: 1 (6) Males
246: 2 (6) Females
247 : 1 (2) 16 - 24
247 : 2 (2) 25 - 34
247 : 3 (2) 35 - 44
247 : 4 (2) 45 - 54
247 : 5 (2) 55 - 64
247 : 6 (2) 65+
246 : 11 (1) Male - 16 - 24
246 : 12 (1) Male - 25 - 34
246 : 13 (1) Male - 35 - 44
246 : 14 (1) Male - 45 - 54
246 : 15 (1) Male - 55 - 64
246 : 16 (1) Male - 65+
246 : 21 (1) Female - 16 - 24
246 : 22 (1) Female - 25 - 34
246 : 23 (1) Female - 35 - 44
246 : 24 (1) Female - 45 - 54
246 : 25 (1) Female - 55 - 64
246 : 26 (1) Female - 65+
250 : 1 (12) Total

Result after a start in the NIPO Fieldwork System

TTDisplayField3+30:1 ( 6) Males
TTDisplayField3+30:2 ( 6) Females
TTDisplayField3+31:1 ( 2) 16 - 24
TTDisplayField3+31:2 ( 2) 25 – 34
TTDisplayField3+31:3 ( 2) 35 - 44
TTDisplayField3+31:4 ( 2) 45 - 54
TTDisplayField3+31:5 ( 2) 55 - 64
TTDisplayField3+31:6 ( 2) 65+
TTDisplayField3+30:11 ( 1) Male - 16 - 24
TTDisplayField3+30:12 ( 1) Male - 25 - 34
TTDisplayField3+30:13 ( 1) Male - 35 - 44
TTDisplayField3+30:14 ( 1) Male - 45 - 54
TTDisplayField3+30:15 ( 1) Male - 55 - 64
TTDisplayField3+30:16 ( 1) Male - 65+
TTDisplayField3+30:21 ( 1) Female - 16 - 24
TTDisplayField3+30:22 ( 1) Female - 25 - 34
TTDisplayField3+30:23 ( 1) Female - 35 - 44
TTDisplayField3+30:24 ( 1) Female - 45 - 54
TTDisplayField3+30:25 ( 1) Female - 55 - 64
TTDisplayField3+30:26 ( 1) Female - 65+
TTDisplayField3+34:1 ( 12) Total

See Also