  CONSTRAINT [PK_tblLURosterGen1Assignment_1] PRIMARY KEY CLUSTERED 
 (
 	[ID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 GO
-SET ANSI_PADDING OFF
-GO
-/****** Object:  Table [Process].[tblMzManual]    Script Date: 06/28/2015 20:27:11 ******/
-SET ANSI_NULLS ON
-GO
-SET QUOTED_IDENTIFIER ON
-GO
-CREATE TABLE [tblMzManual](
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblLUTristate](
+	[ID] [tinyint] NOT NULL,
+	[Label] [char](10) NOT NULL,
+ CONSTRAINT [PK_tblLUIsMZ] PRIMARY KEY CLUSTERED 
+(
+	[ID] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblLUYesNo](
+	[ID] [smallint] NOT NULL,
+	[Label] [char](40) NOT NULL,
+ CONSTRAINT [PK_[tblLUYesNoGen1] PRIMARY KEY CLUSTERED 
+(
+	[ID] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblMarkerGen1](
+	[ID] [bigint] IDENTITY(1,1) NOT NULL,
+	[ExtendedID] [smallint] NOT NULL,
+	[RelatedID] [int] NOT NULL,
+	[MarkerType] [tinyint] NOT NULL,
+	[SurveyYear] [smallint] NOT NULL,
+	[MzEvidence] [tinyint] NOT NULL,
+	[SameGeneration] [tinyint] NOT NULL,
+	[ShareBiomomEvidence] [tinyint] NOT NULL,
+	[ShareBiodadEvidence] [tinyint] NOT NULL,
+	[ShareBioGrandparentEvidence] [tinyint] NOT NULL,
+ CONSTRAINT [PK_tblMarkerGen1] PRIMARY KEY CLUSTERED 
+(
+	[ID] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+ CONSTRAINT [IX_tblMarkerGen1_Unique] UNIQUE NONCLUSTERED 
+(
+	[RelatedID] ASC,
+	[MarkerType] ASC,
+	[SurveyYear] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblMarkerGen2](
+	[ID] [bigint] IDENTITY(1,1) NOT NULL,
+	[ExtendedID] [smallint] NOT NULL,
+	[RelatedID] [int] NOT NULL,
+	[MarkerType] [tinyint] NOT NULL,
+	[SurveyYear] [smallint] NULL,
+	[MzEvidence] [tinyint] NOT NULL,
+	[ShareBiodadEvidence] [tinyint] NOT NULL,
+	[FromMother] [bit] NOT NULL,
+ CONSTRAINT [PK_tblMarkerGen2] PRIMARY KEY CLUSTERED 
+(
+	[ID] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+ CONSTRAINT [IX_tblMarkerGen2_Unique] UNIQUE NONCLUSTERED 
+(
+	[RelatedID] ASC,
+	[MarkerType] ASC,
+	[SurveyYear] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblOutcome](
 	[ID] [int] IDENTITY(1,1) NOT NULL,
+	[SubjectTag] [int] NOT NULL,
+	[Item] [smallint] NOT NULL,
+	[SurveyYear] [smallint] NOT NULL,
+	[Value] [int] NOT NULL,
+ CONSTRAINT [PK_tblOutcome] PRIMARY KEY CLUSTERED 
+(
+	[ID] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblOutcomesOLD](
+	[SubjectTag] [int] NOT NULL,
+	[HeightInchesLateTeens] [tinyint] NULL,
+	[WeightPoundsLateTeens] [smallint] NULL,
+	[AfqtRescaled2006Bounded] [float] NULL,
+ CONSTRAINT [PK_tblOutcomesOLD] PRIMARY KEY CLUSTERED 
+(
+	[SubjectTag] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblParentsOfGen1Current](
+	[SubjectTag] [int] NOT NULL,
+	[BiodadBirthYearReported] [smallint] NULL,
+	[BiodadBirthYearEstimated] [smallint] NULL,
+	[BiodadYearLastAsked] [smallint] NULL,
+	[BiodadAlive] [smallint] NOT NULL,
+	[BiodadDeathCause] [smallint] NOT NULL,
+	[BiodadDeathAge] [tinyint] NULL,
+	[BiodadUSBorn] [smallint] NOT NULL,
+	[BiodadHighestGrade] [tinyint] NULL,
+	[BiograndfatherUSBorn] [smallint] NOT NULL,
+	[BiomomBirthYearReported] [smallint] NULL,
+	[BiomomBirthYearEstimated] [smallint] NULL,
+	[BiomomYearLastAsked] [smallint] NULL,
+	[BiomomAlive] [smallint] NOT NULL,
+	[BiomomDeathCause] [smallint] NOT NULL,
+	[BiomomDeathAge] [tinyint] NULL,
+	[BiomomUSBorn] [smallint] NOT NULL,
+	[BiomomHighestGrade] [tinyint] NULL,
+	[AlwaysLivedWithBothBioparents] [smallint] NOT NULL,
+ CONSTRAINT [PK_tblParentsOfGen1Current] PRIMARY KEY CLUSTERED 
+(
+	[SubjectTag] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblParentsOfGen1Retro](
+	[ID] [bigint] IDENTITY(1,1) NOT NULL,
+	[SubjectTag] [int] NOT NULL,
+	[ExtendedID] [smallint] NOT NULL,
+	[Bioparent] [smallint] NOT NULL,
+	[InHH] [bit] NULL,
+	[Age] [tinyint] NOT NULL,
+	[Year] [smallint] NOT NULL,
+ CONSTRAINT [PK_tblParentsOfGen1Retro] PRIMARY KEY CLUSTERED 
+(
+	[ID] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblRelatedStructure](
+	[ID] [int] IDENTITY(1,1) NOT NULL,
+	[ExtendedID] [smallint] NOT NULL,
 	[SubjectTag_S1] [int] NOT NULL,
 	[SubjectTag_S2] [int] NOT NULL,
-	[Generation] [tinyint] NOT NULL,
+	[RelationshipPath] [tinyint] NOT NULL,
+	[EverSharedHouse] [bit] NOT NULL,
+ CONSTRAINT [PK_tblRelatednessStructure] PRIMARY KEY CLUSTERED 
+(
+	[ID] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblRelatedValues](
+	[ID] [int] NOT NULL,
 	[MultipleBirthIfSameSex] [tinyint] NOT NULL,
 	[IsMz] [tinyint] NOT NULL,
-	[Undecided] [bit] NOT NULL,
-	[Related] [bit] NULL,
-	[Notes] [text] NULL,
- CONSTRAINT [PK_tbluMzManual] PRIMARY KEY CLUSTERED 
+	[LastSurvey_S1] [smallint] NULL,
+	[LastSurvey_S2] [smallint] NULL,
+	[ImplicitShareBiomomPass1] [tinyint] NULL,
+	[ImplicitShareBiodadPass1] [tinyint] NULL,
+	[ExplicitShareBiomomPass1] [tinyint] NULL,
+	[ExplicitShareBiodadPass1] [tinyint] NULL,
+	[ShareBiomomPass1] [tinyint] NULL,
+	[ShareBiodadPass1] [tinyint] NULL,
+	[RImplicitPass1] [float] NULL,
+	[RImplicit] [float] NULL,
+	[RImplicitSubject] [float] NULL,
+	[RImplicitMother] [float] NULL,
+	[RImplicit2004] [float] NULL,
+	[RExplicitOlderSibVersion] [float] NULL,
+	[RExplicitYoungerSibVersion] [float] NULL,
+	[RExplicitPass1] [float] NULL,
+	[RExplicit] [float] NULL,
+	[RPass1] [float] NULL,
+	[R] [float] NULL,
+	[RFull] [float] NULL,
+	[RPeek] [float] NULL,
+ CONSTRAINT [PK_tblRelatedValues] PRIMARY KEY CLUSTERED 
 (
 	[ID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-CREATE UNIQUE NONCLUSTERED INDEX [IX_tblMzManual_Unique] ON [tblMzManual] 
-(
-	[SubjectTag_S1] ASC,
-	[SubjectTag_S2] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-GO
-/****** Object:  Table [Process].[tblSubject]    Script Date: 06/28/2015 20:27:11 ******/
-SET ANSI_NULLS ON
-GO
-SET QUOTED_IDENTIFIER ON
-GO
-CREATE TABLE [tblSubject](
-	[SubjectTag] [int] NOT NULL,
-	[ExtendedID] [smallint] NOT NULL,
-	[SubjectID] [int] NOT NULL,
-	[Generation] [tinyint] NOT NULL,
-	[Gender] [tinyint] NOT NULL,
- CONSTRAINT [PK_Process.tblSubject] PRIMARY KEY CLUSTERED 
-(
-	[SubjectTag] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
-GO
-CREATE UNIQUE NONCLUSTERED INDEX [IX_tblSubject_Unique] ON [tblSubject] 
-(
-	[SubjectID] ASC,
-	[Generation] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-GO
-/****** Object:  Table [Process].[tblVariable]    Script Date: 06/28/2015 20:27:11 ******/
-SET ANSI_NULLS ON
-GO
-SET QUOTED_IDENTIFIER ON
-GO
-SET ANSI_PADDING ON
-GO
-CREATE TABLE [tblVariable](
-	[ID] [int] IDENTITY(1,1) NOT NULL,
-	[VariableCode] [char](8) NOT NULL,
-	[Item] [smallint] NOT NULL,
-	[Generation] [tinyint] NOT NULL,
-	[ExtractSource] [tinyint] NOT NULL,
-	[SurveySource] [tinyint] NOT NULL,
-	[SurveyYear] [smallint] NOT NULL,
-	[LoopIndex] [tinyint] NOT NULL,
-	[Translate] [bit] NOT NULL,
-	[Notes] [text] NULL,
- CONSTRAINT [PK_tblVariable] PRIMARY KEY CLUSTERED 
-(
-	[ID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-SET ANSI_PADDING OFF
-GO
-CREATE UNIQUE NONCLUSTERED INDEX [IX_tblVariable_CodeUnique] ON [tblVariable] 
-(
-	[VariableCode] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-GO
-CREATE UNIQUE NONCLUSTERED INDEX [IX_tblVariable_UniqueValues] ON [tblVariable] 
-(
-	[Item] ASC,
-	[SurveySource] ASC,
-	[SurveyYear] ASC,
-	[LoopIndex] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-GO
-/****** Object:  View [dbo].[vewVariable]    Script Date: 06/28/2015 20:27:12 ******/
-SET ANSI_NULLS ON
-GO
-SET QUOTED_IDENTIFIER ON
-GO
-CREATE VIEW [vewVariable]
-AS
-SELECT     Process.tblVariable.VariableCode, Process.tblVariable.Item, Process.tblVariable.Generation, Process.tblVariable.SurveyYear, Process.tblItem.Label AS ItemLabel, 
-                      Process.tblVariable.Translate, Process.tblVariable.LoopIndex, Process.tblVariable.ExtractSource, Process.tblVariable.SurveySource, Process.tblVariable.ID
-FROM         Process.tblItem INNER JOIN
-                      Process.tblVariable ON Process.tblItem.ID = Process.tblVariable.Item
-GO
-/****** Object:  Table [Process].[tblSurveyTime]    Script Date: 06/28/2015 20:27:12 ******/
-SET ANSI_NULLS ON
-GO
-SET QUOTED_IDENTIFIER ON
-GO
-CREATE TABLE [tblSurveyTime](
-	[ID] [int] IDENTITY(1,1) NOT NULL,
-	[SubjectTag] [int] NOT NULL,
-	[SurveySource] [tinyint] NOT NULL,
-	[SurveyYear] [smallint] NOT NULL,
-	[SurveyDate] [date] NULL,
-	[AgeSelfReportYears] [float] NULL,
-	[AgeCalculateYears] [float] NULL,
- CONSTRAINT [PK_tblSurveyTime] PRIMARY KEY CLUSTERED 
-(
-	[ID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
-GO
-CREATE UNIQUE NONCLUSTERED INDEX [IX_tblSurveyTime_Unique] ON [tblSurveyTime] 
-(
-	[SubjectTag] ASC,
-	[SurveyYear] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-GO
-/****** Object:  Table [Process].[tblSubjectDetails]    Script Date: 06/28/2015 20:27:12 ******/
-SET ANSI_NULLS ON
-GO
-SET QUOTED_IDENTIFIER ON
-GO
-CREATE TABLE [tblSubjectDetails](
-	[SubjectTag] [int] NOT NULL,
-	[RaceCohort] [tinyint] NOT NULL,
-	[SiblingCountInNls] [tinyint] NOT NULL,
-	[BirthOrderInNls] [tinyint] NOT NULL,
-	[SimilarAgeCount] [tinyint] NOT NULL,
-	[HasMzPossibly] [bit] NOT NULL,
-	[KidCountBio] [tinyint] NULL,
-	[KidCountInNls] [tinyint] NULL,
-	[Mob] [smalldatetime] NULL,
-	[LastSurveyYearCompleted] [smallint] NULL,
-	[AgeAtLastSurvey] [float] NULL,
-	[IsDead] [bit] NOT NULL,
-	[DeathDate] [smalldatetime] NULL,
-	[IsBiodadDead] [bit] NULL,
-	[BiodadDeathDate] [smalldatetime] NULL,
- CONSTRAINT [PK_tblSubject] PRIMARY KEY CLUSTERED 
-(
-	[SubjectTag] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
-GO
-/****** Object:  Table [Process].[tblResponse]    Script Date: 06/28/2015 20:27:12 ******/
-SET ANSI_NULLS ON
-GO
-SET QUOTED_IDENTIFIER ON
-GO
-CREATE TABLE [tblResponse](
-	[ID] [int] IDENTITY(1,1) NOT NULL,
-	[SubjectTag] [int] NOT NULL,
-	[ExtendedID] [smallint] NOT NULL,
-	[Generation] [tinyint] NOT NULL,
-	[SurveySource] [tinyint] NOT NULL,
-	[SurveyYear] [smallint] NOT NULL,
-	[Item] [smallint] NOT NULL,
-	[Value] [int] NOT NULL,
-	[LoopIndex] [tinyint] NOT NULL,
- CONSTRAINT [PK_tblResponse] PRIMARY KEY CLUSTERED 
-(
-	[ID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
-GO
-/****** Object:  Table [Process].[tblRelatedValuesArchive]    Script Date: 06/28/2015 20:27:12 ******/
-SET ANSI_NULLS ON
-GO
-SET QUOTED_IDENTIFIER ON
-GO
-CREATE TABLE [tblRelatedValuesArchive](
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [Process].[tblRelatedValuesArchive](
 	[ID] [int] IDENTITY(1,1) NOT NULL,
 	[AlgorithmVersion] [smallint] NOT NULL,
 	[SubjectTag_S1] [int] NOT NULL,

 CONSTRAINT [PK_Process.tblRelatedValuesArchive] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Process.tblRelatedValuesArchive_Unique] ON [tblRelatedValuesArchive] 
(
	[AlgorithmVersion] ASC,
	[SubjectTag_S1] ASC,
	[SubjectTag_S2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblFatherOfGen2]    Script Date: 06/28/2015 20:27:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblFatherOfGen2](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[SubjectTag] [int] NOT NULL,
	[SurveyYear] [smallint] NOT NULL,
	[BiodadInHH] [smallint] NOT NULL,
	[BiodadAlive] [smallint] NOT NULL,
	[BiodadDistanceFromHH] [smallint] NULL,
	[BiodadAsthma] [smallint] NOT NULL,
 CONSTRAINT [PK_tblFatherOfGen2_1] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblBabyDaddy]    Script Date: 06/28/2015 20:27:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblBabyDaddy](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[SubjectTag] [int] NOT NULL,
	[ChildLoopIndex] [tinyint] NOT NULL,
	[SurveyYear] [smallint] NOT NULL,
	[BiodadInHH] [smallint] NOT NULL,
	[BiodadAlive] [smallint] NOT NULL,
	[BiodadEverLiveInHH] [smallint] NOT NULL,
	[BiodadLeftHHDate] [smalldatetime] NULL,
	[BiodadDeathDate] [smalldatetime] NULL,
	[BiodadDistanceFromHH] [smallint] NULL,
	[BiodadAsthma] [smallint] NOT NULL,
 CONSTRAINT [PK_tblFatherOfGen2] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblRelatedStructure]    Script Date: 06/28/2015 20:27:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblRelatedStructure](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ExtendedID] [smallint] NOT NULL,
	[SubjectTag_S1] [int] NOT NULL,
	[SubjectTag_S2] [int] NOT NULL,
	[RelationshipPath] [tinyint] NOT NULL,
	[EverSharedHouse] [bit] NOT NULL,
 CONSTRAINT [PK_tblRelatednessStructure] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblRelatedStructure_Tags] ON [tblRelatedStructure] 
(
	[SubjectTag_S1] ASC,
	[SubjectTag_S2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblParentsOfGen1Retro]    Script Date: 06/28/2015 20:27:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblParentsOfGen1Retro](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[SubjectTag] [int] NOT NULL,
	[ExtendedID] [smallint] NOT NULL,
	[Bioparent] [smallint] NOT NULL,
	[InHH] [bit] NULL,
	[Age] [tinyint] NOT NULL,
	[Year] [smallint] NOT NULL,
 CONSTRAINT [PK_tblParentsOfGen1Retro] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblParentsOfGen1Retro_UniqueAge] ON [tblParentsOfGen1Retro] 
(
	[SubjectTag] ASC,
	[Age] ASC,
	[Bioparent] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_tblParentsOfGen1Retro_UniqueYear] ON [tblParentsOfGen1Retro] 
(
	[SubjectTag] ASC,
	[Year] ASC,
	[Bioparent] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblParentsOfGen1Current]    Script Date: 06/28/2015 20:27:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblParentsOfGen1Current](
	[SubjectTag] [int] NOT NULL,
	[BiodadBirthYearReported] [smallint] NULL,
	[BiodadBirthYearEstimated] [smallint] NULL,
	[BiodadYearLastAsked] [smallint] NULL,
	[BiodadAlive] [smallint] NOT NULL,
	[BiodadDeathCause] [smallint] NOT NULL,
	[BiodadDeathAge] [tinyint] NULL,
	[BiodadUSBorn] [smallint] NOT NULL,
	[BiodadHighestGrade] [tinyint] NULL,
	[BiograndfatherUSBorn] [smallint] NOT NULL,
	[BiomomBirthYearReported] [smallint] NULL,
	[BiomomBirthYearEstimated] [smallint] NULL,
	[BiomomYearLastAsked] [smallint] NULL,
	[BiomomAlive] [smallint] NOT NULL,
	[BiomomDeathCause] [smallint] NOT NULL,
	[BiomomDeathAge] [tinyint] NULL,
	[BiomomUSBorn] [smallint] NOT NULL,
	[BiomomHighestGrade] [tinyint] NULL,
	[AlwaysLivedWithBothBioparents] [smallint] NOT NULL,
 CONSTRAINT [PK_tblParentsOfGen1Current] PRIMARY KEY CLUSTERED 
(
	[SubjectTag] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblParentsOfGen1Current_UniqueSubjectTag] ON [tblParentsOfGen1Current] 
(
	[SubjectTag] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblOutcomesOLD]    Script Date: 06/28/2015 20:27:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblOutcomesOLD](
	[SubjectTag] [int] NOT NULL,
	[HeightInchesLateTeens] [tinyint] NULL,
	[WeightPoundsLateTeens] [smallint] NULL,
	[AfqtRescaled2006Bounded] [float] NULL,
 CONSTRAINT [PK_tblOutcomesOLD] PRIMARY KEY CLUSTERED 
(
	[SubjectTag] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblOutcome]    Script Date: 06/28/2015 20:27:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblOutcome](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[SubjectTag] [int] NOT NULL,
	[Item] [smallint] NOT NULL,
	[SurveyYear] [smallint] NOT NULL,
	[Value] [int] NOT NULL,
 CONSTRAINT [PK_tblOutcome] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_tblOutcome_Unique] ON [tblOutcome] 
(
	[Item] ASC,
	[SubjectTag] ASC,
	[SurveyYear] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblMarkerGen2]    Script Date: 06/28/2015 20:27:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblMarkerGen2](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ExtendedID] [smallint] NOT NULL,
	[RelatedID] [int] NOT NULL,
	[MarkerType] [tinyint] NOT NULL,
	[SurveyYear] [smallint] NULL,
	[MzEvidence] [tinyint] NOT NULL,
	[ShareBiodadEvidence] [tinyint] NOT NULL,
	[FromMother] [bit] NOT NULL,
 CONSTRAINT [PK_tblMarkerGen2] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [IX_tblMarkerGen2_Unique] UNIQUE NONCLUSTERED 
(
	[RelatedID] ASC,
	[MarkerType] ASC,
	[SurveyYear] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblMarkerGen1]    Script Date: 06/28/2015 20:27:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblMarkerGen1](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ExtendedID] [smallint] NOT NULL,
	[RelatedID] [int] NOT NULL,
	[MarkerType] [tinyint] NOT NULL,
	[SurveyYear] [smallint] NOT NULL,
	[MzEvidence] [tinyint] NOT NULL,
	[SameGeneration] [tinyint] NOT NULL,
	[ShareBiomomEvidence] [tinyint] NOT NULL,
	[ShareBiodadEvidence] [tinyint] NOT NULL,
	[ShareBioGrandparentEvidence] [tinyint] NOT NULL,
 CONSTRAINT [PK_tblMarkerGen1] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [IX_tblMarkerGen1_Unique] UNIQUE NONCLUSTERED 
(
	[RelatedID] ASC,
	[MarkerType] ASC,
	[SurveyYear] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  StoredProcedure [Process].[prcResponseRetrieveSubset]    Script Date: 06/28/2015 20:27:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [prcResponseRetrieveSubset] 
AS
BEGIN
	SET NOCOUNT ON;-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.
SELECT     ID, SubjectTag, ExtendedID, Generation, SurveySource, SurveyYear, Item, Value, LoopIndex
FROM         Process.tblResponse
WHERE Item in (0) --For RelatedValues

OR Item in (13,14,15,16,17,20, 21,22,100)                                                                  --For SurveyTime: Birthday Values, SelfReported Age at Interview, and the SubjectID
--OR Item in (1,2)                                                                                         --For RosterGen1
--OR Item in (13, 14, 306, 326, 340)                                                                       --For ParentsOfGen1Retro
--OR Item in (300, 301, 302, 305, 307, 308,  310, 311, 320, 321, 322, 325, 327, 330, 331, 340)             --For ParentsOfGen1Current 309, 329,
--OR Item in ( 49, 81,82,83,84,85,86,87,88,89,90, 91, 92 )                                                 --For BabyDaddy
--OR Item in (121, 122, 123, 124, 125)                                                                     --For Gen2CFather
--OR Item in (11, 13,14,15, 48, 49, 60, 64, 82, 86, 87, 88, 103)                                           --For SubjectDetails
--OR Item in (1,2,4,5,6)                                                                                   --For MarkerGen1
--OR Item in (9,10)                                                                                        --For MarkerGen2
--OR Item in (200,201,203)                                                                                 --For Gen1Outcomes
--OR Item in (500,501,502,503)                                                                             --For Gen2OutcomesHeight

END
GO
/****** Object:  StoredProcedure [Process].[prcArchiveMaxVersion]    Script Date: 06/28/2015 20:27:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Name
-- Create date: 
-- Description:	
-- =============================================
CREATE PROCEDURE [prcArchiveMaxVersion] 
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
SELECT Max([AlgorithmVersion]) as MaxVersion
  FROM [NlsLinks].[Process].[tblRelatedValuesArchive]

END
GO
/****** Object:  Table [Process].[tblRelatedValues]    Script Date: 06/28/2015 20:27:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblRelatedValues](
	[ID] [int] NOT NULL,
	[MultipleBirthIfSameSex] [tinyint] NOT NULL,
	[IsMz] [tinyint] NOT NULL,
	[LastSurvey_S1] [smallint] NULL,
	[LastSurvey_S2] [smallint] NULL,
	[ImplicitShareBiomomPass1] [tinyint] NULL,
	[ImplicitShareBiodadPass1] [tinyint] NULL,
	[ExplicitShareBiomomPass1] [tinyint] NULL,
	[ExplicitShareBiodadPass1] [tinyint] NULL,
	[ShareBiomomPass1] [tinyint] NULL,
	[ShareBiodadPass1] [tinyint] NULL,
	[RImplicitPass1] [float] NULL,
	[RImplicit] [float] NULL,
	[RImplicitSubject] [float] NULL,
	[RImplicitMother] [float] NULL,
	[RImplicit2004] [float] NULL,
	[RExplicitOlderSibVersion] [float] NULL,
	[RExplicitYoungerSibVersion] [float] NULL,
	[RExplicitPass1] [float] NULL,
	[RExplicit] [float] NULL,
	[RPass1] [float] NULL,
	[R] [float] NULL,
	[RFull] [float] NULL,
	[RPeek] [float] NULL,
 CONSTRAINT [PK_tblRelatedValues] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [Process].[tblRosterGen1]    Script Date: 06/28/2015 20:27:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [tblRosterGen1](
	[RelatedID] [int] NOT NULL,
	[RosterAssignmentID] [tinyint] NOT NULL,
	[ResponseLower] [smallint] NOT NULL,

 CONSTRAINT [PK_tblRosterGen1_1] PRIMARY KEY CLUSTERED 
(
	[RelatedID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Process].[tblSubject](
	[SubjectTag] [int] NOT NULL,
	[ExtendedID] [smallint] NOT NULL,
	[SubjectID] [int] NOT NULL,
	[Generation] [tinyint] NOT NULL,
	[Gender] [tinyint] NOT NULL,
 CONSTRAINT [PK_Process.tblSubject] PRIMARY KEY CLUSTERED 
(
	[SubjectTag] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Process].[tblSubjectDetails](
	[SubjectTag] [int] NOT NULL,
	[RaceCohort] [tinyint] NOT NULL,
	[SiblingCountInNls] [tinyint] NOT NULL,
	[BirthOrderInNls] [tinyint] NOT NULL,
	[SimilarAgeCount] [tinyint] NOT NULL,
	[HasMzPossibly] [bit] NOT NULL,
	[KidCountBio] [tinyint] NULL,
	[KidCountInNls] [tinyint] NULL,
	[Mob] [smalldatetime] NULL,
	[LastSurveyYearCompleted] [smallint] NULL,
	[AgeAtLastSurvey] [float] NULL,
	[IsDead] [bit] NOT NULL,
	[DeathDate] [smalldatetime] NULL,
	[IsBiodadDead] [bit] NULL,
	[BiodadDeathDate] [smalldatetime] NULL,
 CONSTRAINT [PK_tblSubject] PRIMARY KEY CLUSTERED 
(
	[SubjectTag] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Process].[tblSurveyTime](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[SubjectTag] [int] NOT NULL,
	[SurveySource] [tinyint] NOT NULL,
	[SurveyYear] [smallint] NOT NULL,
	[SurveyDate] [date] NULL,
	[AgeSelfReportYears] [float] NULL,
	[AgeCalculateYears] [float] NULL,
 CONSTRAINT [PK_tblSurveyTime] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vewGen1Crosstabs]
AS
SELECT     TOP (100) PERCENT COUNT(dbo.vewRelatedValues.ExtendedID) AS Count, Process.tblLUMultipleBirth.Label AS MultipleBirth, dbo.vewRelatedValues.RExplicit, 
                      dbo.vewRelatedValues.R, dbo.vewRelatedValues.RImplicit2004
FROM         dbo.vewRelatedValues INNER JOIN
                      Process.tblLUMultipleBirth ON dbo.vewRelatedValues.MultipleBirth = Process.tblLUMultipleBirth.ID
GROUP BY dbo.vewRelatedValues.RExplicit, dbo.vewRelatedValues.R, Process.tblLUMultipleBirth.Label, dbo.vewRelatedValues.RImplicit2004
ORDER BY dbo.vewRelatedValues.R DESC
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vewMarkerGen2]
AS
SELECT     TOP (100) PERCENT Process.tblRelatedStructure.ExtendedID, Process.tblMarkerGen2.RelatedID, Process.tblMarkerGen2.ID AS MarkerID, 
                      Process.tblMarkerGen2.MarkerType AS MarkerTypeID, Process.tblLUMarkerType.Label AS MarkerType, Process.tblLUMarkerType.Explicit, 
