Relationship Linker Attributes - trillium_discovery - trillium_quality - 17.1

Trillium Input/Output Attributes Reference Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Input/Output Attributes Reference Guide
Topic type
Overview
Administration
Configuration
Installation
Reference
How Do I
First publish date
2008

The table given below lists the Relationship Linker attributes. The attributes are the same for all countries.

Table 1. Relationship Linker Attributes

Attribute Name

Length

Description

lev1_matched

10

Match key. Unique number appended to records matched (P) at level 1 (household).

lev1_matched_number_members

8

Number of members in matched level 1 group.

lev1_matched_pattern

3

Pattern which determined match (P) at level 1 (household).

lev1_matched_prime_flag*

1

Matched level 1 primary record flag:

1 = primary, 0 = non-primary

lev1_survivor_flag

1

Flags one record in each group of level 1 matches as being the survivor of the group.

lev1_suspect

10

Suspect key. Unique number appended to records suspected (S) at level 1 (household).

lev1_suspect_number_members

8

Number of members in suspect level 1 group.

lev1_suspect_pattern

3

Pattern which determined suspect (S) at level 1 (household).

lev1_suspect_prime_flag*

1

Suspect level 1 primary record flag:

1 = primary, 0 = non-primary.

lev2_matched_in_lev1_matched

10

Match key. Unique number appended to records matched (P) at level 2 (individual) within the matched level 1.

lev2_matched_in_lev1_matched_number_members

8

Number of members in matched level 2 group.

lev2_matched_in_lev1_matched_prime_flag*

1

Matched level 2 within the matched level 1 primary record flag:

1 = primary, 0 = non-primary

lev2_matched_in_lev1_suspect

10

Match key. Unique number appended to records matched (P) at level 2 (individual) within the suspected level 1.

lev2_matched_in_lev1_suspect_number_members

8

Number of level 2 matched members in suspect level 1 group.

lev2_matched_in_lev1_suspect_prime_flag*

1

Matched level 2 within the suspect level 1 primary record flag:

1 = primary, 0 = non-primary

lev2_matched_pattern

3

Pattern which determined match (P) at level 2 (individual).

lev2_survivor_flag

1

Flags one record in each group of level 2 matches as being the survivor of the group.

lev2_suspect_in_lev1_matched

10

Suspect key. Unique number appended to records suspected (S) at level 2 (individual) within the matched level 1.

lev2_suspect_in_lev1_matched_number_members

8

Number of level 2 suspect members in matched level 1 group.

lev2_suspect_in_lev1_matched_prime_flag*

1

Suspect level 2 within the matched level 1 primary record flag:

1 = primary, 0 = non-primary

lev2_suspect_in_lev1_suspect

10

Suspect key. Unique number appended to records suspected (S) at level 2 (individual) within the suspected level 1.

lev2_suspect_in_lev1_suspect_number_members

8

Number of level 2 suspect members in suspect level 1 group.

lev2_suspect_in_lev1_suspect_prime_flag*

1

Suspect level 2 within the suspect level 1 primary record flag:

1 = primary, 0 = non-primary

lev2_suspect_pattern

3

Pattern which determined suspect (S) at level 2 (individual).

record_number

10

Record number assigned by Relationship Linker during file read.

reference_level1_key

16

Reference match key. Unique number appended to records matched (P) at level 1 (household).

reference_level2_key

16

Reference match key. Unique number appended to records matched (P) at level 2 (individual).

reference_matched_lev1_pattern

3

Pattern which determined match (P) at level 1 (household).

reference_matched_lev2_pattern

3

Pattern which determined match (P) at level 2 (individual).

reference_suspect_lev1_pattern

3

Pattern which determined suspect (S) at level 1 (household).

reference_suspect_lev2_pattern

3

Pattern which determined suspect (S) at level 2 (individual).

window_number

10

Unique number appended to records with unique window key.

The first record in these matched or suspect groups is flagged with a “1” and other records in the groups are flagged with a “0”. These flags are used for creating a link file by the Relationship Linker. The Relationship Linker looks for the primary record (flagged with a “1”) for the attribute.