An Example of Generation ID's Calculation and Mapping Table-1v Input File: Variable Names and Labels Name Label PID2 "1968 INTERVIEW NUMBER OF INDIVIDUAL " PID3 "PERSON NUMBER OF INDIVIDUAL " PID4 "1968 INTERVIEW NUMBER OF BIRTH MOTHER " PID5 "PERSON NUMBER OF BIRTH MOTHER " PID6 "1968 IW NUMBER OF 1ST ADOPTIVE MOTHER " PID7 "PERSON NUMBER OF 1ST ADOPTIVE MOTHER " PID23 "1968 INTERVIEW NUMBER OF BIRTH FATHER " PID24 "PERSON NUMBER OF BIRTH FATHER " PID25 "1968 IW NUMBER OF 1ST ADOPTIVE FATHER " PID26 "PERSON NUMBER OF 1ST ADOPTIVE FATHER " Table-1d Input File: Data Values # PID2 PID3 PID4 PID5 PID6 PID7 PID23 PID24 PID25 PID26 1 2069 001 2069 913 . . 2069 912 . . 2 2069 002 2069 176 . . 2069 907 . . 3 2069 003 2069 002 . . 2069 001 . . 4 2069 004 . . . . . . . . 5 2069 005 2069 004 . . . . 2069 177 6 2069 030 2069 002 . . 2069 171 . . 7 2069 031 2069 003 . . 2069 175 . . 8 2069 170 2069 915 . . 2069 914 . . 9 2069 171 2069 906 . . 2069 905 . . 10 2069 172 2069 170 . . . . . . 11 2069 173 2069 170 . . . . . . 12 2069 174 . . . . 2069 171 . . 13 2069 175 2069 911 . . 2069 910 . . 14 2069 176 . . . . . . . . 15 2069 177 . . . . . . . . 16 2069 178 . . . . . . . . 17 2069 179 . . . . . . . . 18 2069 901 2069 170 . . . . . . 19 2069 903 2069 170 . . . . . . 20 2069 904 2069 170 . . . . . . Table-2d Input Data Values: Adjusted for User Selection PN Range: 1 - 231, Parents Type: Biological and Adoptive # PID2 PID3 PID4 PID5 PID6 PID7 PID23 PID24 PID25 PID26 1 2069 001 . . . . . . . . 2 2069 002 2069 176 . . . . . . 3 2069 003 2069 002 . . 2069 001 . . 4 2069 004 . . . . . . . . 5 2069 005 2069 004 . . . . 2069 177 6 2069 030 2069 002 . . 2069 171 . . 7 2069 031 2069 003 . . 2069 175 . . 8 2069 170 . . . . . . . . 9 2069 171 . . . . . . . . 10 2069 172 2069 170 . . . . . . 11 2069 173 2069 170 . . . . . . 12 2069 174 . . . . 2069 171 . . 13 2069 175 . . . . . . . . 14 2069 176 . . . . . . . . 15 2069 177 . . . . . . . . 16 2069 178 . . . . . . . . 17 2069 179 . . . . . . . . Table-3 Individual, GID and Genearation Linkage and Parent Type # ID68.PN GID Ancestor to Individaul Link Path 1 2069.001 1 2069.001 - (I) 2 2069.002 2 2069.176, 2069.002 - (M, I) 3 2069.003 3 2069.176, 2069.002, 2069.003 - (M, M, I) 2 2069.001, 2069.003 - (F, I) 2069.002, 2069.003 - (M, I) 4 2069.004 1 2069.004 - (I) 5 2069.005 2 2069.004, 2069.005 - (M, I) 2069.177, 2069.005 - (AF, I) 6 2069.030 3 2069.176, 2069.002, 2069.030 - (M, M, I) 2 2069.002, 2069.030 - (M, I) 2069.171, 2069.030 - (F, I) 7 2069.031 4 2069.176, 2069.002, 2069.003, 2069.031 - (M, M, M, I) 3 2069.001, 2069.003, 2069.031 - (F, M, I) 2069.002, 2069.003, 2069.031 - (M, M, I) 2 2069.003, 2069.031 - (M, I) 2069.175, 2069.031 - (F, I) 8 2069.170 1 2069.170 - (I) 9 2069.171 1 2069.171 - (I) 10 2069.172 2 2069.170, 2069.172 - (M, I) 11 2069.173 2 2069.170, 2069.173 - (M, I) 12 2069.174 2 2069.171, 2069.174 - (F, I) 13 2069.175 1 2069.175 - (I) 14 2069.176 1 2069.176 - (I) 15 2069.177 1 2069.177 - (I) 16 2069.178 1 2069.178 - (I) 17 2069.179 1 2069.179 - (I) Table-4v:- Generation ID Custom Map File: Variable Descriptin Name Label Type Width ID68 "1968 INTERVIEW # OF INDIVIDUAL " num 4.0 PN "PERSON # OF INDIVIDUAL " num 3.0 GID "GENERATION # OF INDIVIDUAL " num 1.0 ID68P "1968 INTERVIEW # OF PARENT " num 4.0 PNP "PERSON # OF PARENT " num 3.0 PTYPE "PARENT TYPE " char 2 ID68GP "1968 INTERVIEW # OF GRAND-PARENT " num 4.0 PNGP "PERSON # OF GRAND-PARENT " num 3.0 GPTYPE "GRAND-PARENT TYPE " char 2 VARIABLE CODES PTYPE, GPTYPE, GGPTYPE M = MOTHER AM = ADOPTIVE-MOTHER F = FATHER AF = ADOPTIVE-FATHER Table-4d:- Generation ID Custom Map File: Data Values Map Type: Individual to Grandparent # ID68 PN GID ID68P PNP PTYPE ID68GP PNGP GPTYPE 1 2069 031 3 2069 003 M 2069 001 F 2 2069 031 4 2069 003 M 2069 002 M 3 2069 003 3 2069 002 M 2069 176 M 4 2069 030 3 2069 002 M 2069 176 M Table-5v:- Prospective Generation ID Custom Map File: Variable Descriptin Name Label Type Width G1ID68 "1968 INTERVIEW NUMBER OF G1 " Num 4.0 G1PN "PERSON NUMBER OF G1 " Num 3.0 G1TYPE "PARENTAL TYPE OF G1 " Char 2 G1POS "GENERATION POSITION OF G1 " Num 1.0 G2ID68 "1968 INTERVIEW NUMBER OF G2 " Num 4.0 G2PN "PERSON NUMBER OF G2 " Num 3.0 G2TYPE "PARENTAL TYPE OF G2 " Char 2 G2POS "GENERATION POSITION OF G2 " Num 1.0 G3ID68 "1968 INTERVIEW NUMBER OF G3 " Num 4.0 G3PN "PERSON NUMBER OF G3 " Num 3.0 G3TYPE "PARENTAL TYPE OF G3 " Char 2 G3POS "GENERATION POSITION OF G3 " Num 1.0 VARIABLE CODES G1TYPE, G2TYPE, G3TYPE M = MOTHER AM = ADOPTIVE-MOTHER F = FATHER AF = ADOPTIVE-FATHER I = INDIVIDUAL WITHOUT CHILDREN Table-5d:- Prospective Generation ID Custom Map File: Data Values Map Type: Grandparent to Child # G1ID68 G1PN G1TYPE G1POS G2ID68 G2PN G2TYPE G2POS G3ID68 G3PN G3TYPE G3POS 1 2069 001 F 1 2069 003 M 2 2069 031 I 3 2 2069 002 M 1 2069 003 M 2 2069 031 I 3