Relationship Linker Attributes - trillium_discovery - trillium_quality - 17.2

Trillium Input/Output Attributes Reference Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Input/Output Attributes Reference Guide
Topic type
Administration
Overview
Installation
Reference
How Do I
Configuration
First publish date
2008
ft:lastEdition
2024-07-01
ft:lastPublication
2024-07-01T08:58:15.701921

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.