Relationship Linker Attributes - trillium_discovery - trillium_quality

Relationship Linker Attributes - trillium_discovery - trillium_quality - 17.2

Trillium Control Center

Product type

Software

Portfolio

Verify

Product family

Trillium

Product

Trillium > Trillium Discovery

Trillium > Trillium Quality

Version

17.2

Language

English

Product name

Trillium Quality and Discovery

Title

Trillium Control Center

First publish date

2008

Last updated

2024-07-01

Published on

2024-07-01T08:56:48.630530

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

Attribute	Length	Description
lev1_matched	10	Match key. Unique number appended to records matched (P) at level 1 (household).
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_suspect_in_lev1_matched	10	Suspect key. Unique number appended to records suspected (S) at level 2 (individual) within the matched level 1.
lev1_suspect	10	Suspect key. Unique number appended to records suspected (S) at level 1 (household).
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_suspect_in_lev1_suspect	10	Suspect key. Unique number appended to records suspected (S) at level 2 (individual) within the suspected level 1.
record_number	10	Record number assigned by Relationship Linker during file read.
lev1_matched_pattern	3	Match pattern which determined match (P) at level 1 (household).
lev1_suspect_pattern	3	Suspect pattern which determined suspect (S) at level 1 (household).
lev2_matched_pattern	3	Match pattern which determined match (P) at level 2 (individual).
lev2_suspect_pattern	3	Suspect pattern which determined suspect (S) at level 2 (individual).
lev1_matched_number_members	8	Number of members in matched level 1 group.
lev1_matched_prime_flag*	1	Matched level 1 primary record flag: 1 = primary, 0 = non-primary
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_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
lev1_suspect_number_members	8	Number of members in suspect level 1 group.
lev1_suspect_prime_flag*	1	Suspect level 1 primary record flag: 1 = primary, 0 = non-primary
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_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
lev1_survivor_flag	1	Flags one record in each group of level 1 matches as being the survivor of the group.
lev2_survivor_flag	1	Flags one record in each group of level 2 matches as being the survivor of the group.
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	Reference match pattern. Pattern which determined match (P) at level 1 (household).
reference_suspect_lev1_pattern	3	Reference suspect pattern. Pattern which determined suspect (S) at level 1 (household).
reference_matched_lev2_pattern	3	Reference match pattern. Pattern which determined match (P) at level 2 (individual).
reference_suspect_lev2_pattern	3	Reference suspect pattern. 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 the matched or suspect group is flagged with a "1" and other records in the group 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 specified by the LINK_SOURCE_ID argument.

Attributes for Link File

The following table lists the four link file output attribute names. See Specifying Linking Settings.

Attribute	Length	Description
FROM_LINK	Minimum length is that of the attribute you specified in the Linking settings.	Based on the attribute you specified in the Linking settings.
TO_LINK	Minimum length is that of the attribute you specified in the Linking settings.	Based on the attribute you specified in the Linking settings.
MATCH_TYPE	Default attribute length is 1.	Output is a single character - 'P' for pass link, 'S' for suspect link.
PATTERN_ID	Maximum length is 9.	Based on patterns as listed in the various Pattern files.