generate-db-79.sql

USE [master]
GO
CREATE DATABASE [NlsyLinks79]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'NlsyLinks79', FILENAME = N'D:\database\nlsy-links\nlsy_links.mdf' , SIZE = 761216KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'NlsyLinks79_log', FILENAME = N'D:\database\nlsy-links\nlsy_links_log.ldf' , SIZE = 2876352KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [NlsyLinks79] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [NlsyLinks79].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [NlsyLinks79] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [NlsyLinks79] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [NlsyLinks79] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [NlsyLinks79] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [NlsyLinks79] SET ARITHABORT OFF 
GO
ALTER DATABASE [NlsyLinks79] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [NlsyLinks79] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [NlsyLinks79] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [NlsyLinks79] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [NlsyLinks79] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [NlsyLinks79] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [NlsyLinks79] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [NlsyLinks79] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [NlsyLinks79] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [NlsyLinks79] SET  DISABLE_BROKER 
GO
ALTER DATABASE [NlsyLinks79] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [NlsyLinks79] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [NlsyLinks79] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [NlsyLinks79] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [NlsyLinks79] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [NlsyLinks79] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [NlsyLinks79] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [NlsyLinks79] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [NlsyLinks79] SET  MULTI_USER 
GO
ALTER DATABASE [NlsyLinks79] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [NlsyLinks79] SET DB_CHAINING OFF 
GO
ALTER DATABASE [NlsyLinks79] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [NlsyLinks79] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [NlsyLinks79] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [NlsyLinks79] SET QUERY_STORE = OFF
GO
USE [NlsyLinks79]
GO
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
GO
ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;
GO
ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;
GO
USE [NlsyLinks79]
GO
CREATE USER [NlsyReadWrite] FOR LOGIN [NlsyReadWrite] WITH DEFAULT_SCHEMA=[dbo]
GO
ALTER ROLE [db_datareader] ADD MEMBER [NlsyReadWrite]
GO
ALTER ROLE [db_datawriter] ADD MEMBER [NlsyReadWrite]
GO
CREATE ASSEMBLY [SqlServerNlsLinks]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103005C5BB54E0000000000000000E00002210B0108000006000000060000000000009E2500000020000000400000000040000020000000020000040000000000000004000000000000000080000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000004425000057000000004000007803000000000000000000000000000000000000006000000C000000C42400001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000A4050000002000000006000000020000000000000000000000000000200000602E7273726300000078030000004000000004000000080000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000000C00000000000000000000000000004000004200000000000000000000000000000000802500000000000048000000020005005020000074040000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000042534A4201000100000000000C00000076322E302E35303732370000000005006C0000005C010000237E0000C80100000802000023537472696E677300000000D00300000800000023555300D8030000100000002347554944000000E80300008C00000023426C6F620000000000000002000001071400000900000000FA253300160000010000000E000000010000000D0000000B000000010000000100000000000A0001000000000006003B0029000600580029000600750029000600940029000600AD0029000600C60029000600E10029000600FC0029000600340115010600480129000600740161012F00880100000600B70197010600D70197010000000001000000000001000100090052000A00110052000A00190052000A00210052000A00290052000A00310052000A00390052000A00410052000A00490052000F00510052000A00590052001400690052001A00710052001F002E000B0023002E0013003A002E001B003A002E0023003A002E002B0023002E00330040002E003B003A002E004B003A002E005B0058002E00630061002E006B006A000480000001000000E6103E45000000000000F501000002000000000000000000000001002000000000000000003C4D6F64756C653E0053716C5365727665724E6C734C696E6B732E646C6C006D73636F726C69620053797374656D2E5265666C656374696F6E00417373656D626C795469746C65417474726962757465002E63746F7200417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053716C5365727665724E6C734C696E6B73000000032000000000007C15CF8065A4A74EA3CA5E72EC97CD060008B77A5C561934E089042001010E04200101020520010111310420010108032000011601001153716C5365727665724E6C734C696E6B73000005010000000017010012436F7079726967687420C2A920203230313100000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F777301000000000000005C5BB54E000000000200000064000000E0240000E006000052534453C42A10A4AFEFE94B815B787BCDC8195402000000463A5C50726F6A656374735C4E6C735C4C696E6B73323031315C53716C5365727665724E6C734C696E6B735C6F626A5C44656275675C53716C5365727665724E6C734C696E6B732E706462006C25000000000000000000008E250000002000000000000000000000000000000000000000000000802500000000000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000200300000000000000000000200334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001003E45E610000001003E45E6103F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00480020000010053007400720069006E006700460069006C00650049006E0066006F0000005C02000001003000300030003000300034006200300000004C0012000100460069006C0065004400650073006300720069007000740069006F006E0000000000530071006C005300650072007600650072004E006C0073004C0069006E006B007300000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0034003300320036002E0031003700370032003600000000004C001600010049006E007400650072006E0061006C004E0061006D0065000000530071006C005300650072007600650072004E006C0073004C0069006E006B0073002E0064006C006C0000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020002000320030003100310000005400160001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530071006C005300650072007600650072004E006C0073004C0069006E006B0073002E0064006C006C000000440012000100500072006F0064007500630074004E0061006D00650000000000530071006C005300650072007600650072004E006C0073004C0069006E006B007300000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0034003300320036002E00310037003700320036000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0034003300320036002E00310037003700320036000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000A03500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET = SAFE
GO
ALTER ASSEMBLY [SqlServerNlsLinks]
ADD FILE FROM 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000010000000F0000004C000000000000000D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008D8FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF30E7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA3101380000000010000000100000000000000900FFFF0400000003800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF1A092FF1000000000000000065000000000000001900000000000000100000002C000000000000000C00000003000000060000000900000007000000080000000A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF77093101020000000A00008A07006F760800010000000000040000000400000004000000000000000000000000000000190000000000EEC0000000002DBA2EF10000000000000000FEEFFEEF0100000001000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF040000000380000000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FEEFFEEF0100000001000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000800000000000000000FFFFFFFF1A092FF10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000942E31011C5BB54E02000000C42A10A4AFEFE94B815B787BCDC81954220000002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B000300000006000000010000001A0000000000000011000000060000000A0000000500000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B000000300000007200000038000000650000000000000019000000000000002C00000000000000FFFFFFFF100000000B0000000900000006000000050000000700000008000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007000000480000007200000038000000FFFFFFFF00000000190000000000000004000000030000000600000007000000002F7372632F686561646572626C6F636B000300000006000000010000001A0000000000000011000000060000000A0000000500000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B00000018000000720000003800000065000000000000001900000000000000100000002C00000000000000030000000B000000060000000900000007000000080000000A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000A000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
AS N'bin\Debug\SqlServerNlsLinks.pdb'
GO
ALTER ASSEMBLY [SqlServerNlsLinks]
ADD FILE FROM 0xEFBBBF7573696E672053797374656D2E5265666C656374696F6E3B0D0A7573696E672053797374656D2E52756E74696D652E436F6D70696C657253657276696365733B0D0A7573696E672053797374656D2E52756E74696D652E496E7465726F7053657276696365733B0D0A7573696E672053797374656D2E446174612E53716C3B0D0A0D0A2F2F2047656E6572616C20496E666F726D6174696F6E2061626F757420616E20617373656D626C7920697320636F6E74726F6C6C6564207468726F7567682074686520666F6C6C6F77696E670D0A2F2F20736574206F6620617474726962757465732E204368616E6765207468657365206174747269627574652076616C75657320746F206D6F646966792074686520696E666F726D6174696F6E0D0A2F2F206173736F636961746564207769746820616E20617373656D626C792E0D0A5B617373656D626C793A20417373656D626C795469746C65282253716C5365727665724E6C734C696E6B7322295D0D0A5B617373656D626C793A20417373656D626C794465736372697074696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6E66696775726174696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6D70616E79282222295D0D0A5B617373656D626C793A20417373656D626C7950726F64756374282253716C5365727665724E6C734C696E6B7322295D0D0A5B617373656D626C793A20417373656D626C79436F707972696768742822436F7079726967687420C2A920203230313122295D0D0A5B617373656D626C793A20417373656D626C7954726164656D61726B282222295D0D0A5B617373656D626C793A20417373656D626C7943756C74757265282222295D0D0A0D0A5B617373656D626C793A20436F6D56697369626C652866616C7365295D0D0A0D0A2F2F0D0A2F2F2056657273696F6E20696E666F726D6174696F6E20666F7220616E20617373656D626C7920636F6E7369737473206F662074686520666F6C6C6F77696E6720666F75722076616C7565733A0D0A2F2F0D0A2F2F2020202020204D616A6F722056657273696F6E0D0A2F2F2020202020204D696E6F722056657273696F6E0D0A2F2F2020202020204275696C64204E756D6265720D0A2F2F2020202020205265766973696F6E0D0A2F2F0D0A2F2F20596F752063616E207370656369667920616C6C207468652076616C756573206F7220796F752063616E2064656661756C7420746865205265766973696F6E20616E64204275696C64204E756D626572730D0A2F2F206279207573696E672074686520272A272061732073686F776E2062656C6F773A0D0A5B617373656D626C793A20417373656D626C7956657273696F6E2822312E302E2A22295D0D0A0D0A
AS N'Properties\AssemblyInfo.cs'
GO
CREATE SCHEMA [Archive]
GO
CREATE SCHEMA [Enum]
GO
CREATE SCHEMA [Extract]
GO
CREATE SCHEMA [Metadata]
GO
CREATE SCHEMA [Outcome]
GO
CREATE SCHEMA [Process]
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] [date] NULL,
	[LastSurveyYearCompleted] [smallint] NULL,
	[AgeAtLastSurvey] [float] NULL,
	[IsDead] [bit] NOT NULL,
	[DeathDate] [date] NULL,
	[IsBiodadDead] [bit] NULL,
	[BiodadDeathDate] [date] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vewOutcomesOLD]
AS
SELECT     Process.tblSubject.SubjectTag, Process.tblSubject.SubjectID, Process.tblSubject.ExtendedID, Process.tblSubject.Generation, Process.tblSubject.Gender, 
                      Process.tblSubjectDetails.Mob, Process.tblOutcomesOLD.HeightInchesLateTeens, Process.tblOutcomesOLD.WeightPoundsLateTeens, 
                      Process.tblOutcomesOLD.AfqtRescaled2006Bounded
FROM         Process.tblSubject INNER JOIN
                      Process.tblSubjectDetails ON Process.tblSubject.SubjectTag = Process.tblSubjectDetails.SubjectTag INNER JOIN
                      Process.tblOutcomesOLD ON Process.tblSubject.SubjectTag = Process.tblOutcomesOLD.SubjectTag
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,
	[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,
	[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
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vewRelatedValues]
AS
SELECT     Process.tblRelatedStructure.ExtendedID, Process.tblRelatedStructure.SubjectTag_S1, Process.tblRelatedStructure.SubjectTag_S2, 
                      Process.tblRelatedStructure.RelationshipPath, Process.tblRelatedStructure.EverSharedHouse, Process.tblRelatedValues.R, Process.tblRelatedValues.RFull, 
                      Process.tblRelatedValues.MultipleBirthIfSameSex, Process.tblRelatedValues.IsMz, Process.tblRelatedValues.LastSurvey_S1, 
                      Process.tblRelatedValues.LastSurvey_S2, Process.tblRelatedValues.RImplicitPass1, Process.tblRelatedValues.RImplicit, Process.tblRelatedValues.RImplicit2004, 
                      Process.tblRelatedValues.RImplicit - Process.tblRelatedValues.RImplicit2004 AS RImplicitDifference, Process.tblRelatedValues.RExplicit, 
                      Process.tblRelatedValues.RExplicitPass1, Process.tblRelatedValues.RPass1, Process.tblRelatedValues.RExplicitOlderSibVersion, 
                      Process.tblRelatedValues.RExplicitYoungerSibVersion, Process.tblRelatedValues.RImplicitSubject, Process.tblRelatedValues.RImplicitMother
FROM         Process.tblRelatedValues INNER JOIN
                      Process.tblRelatedStructure ON Process.tblRelatedValues.ID = Process.tblRelatedStructure.ID
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Process].[tblRosterGen1](
	[RelatedID] [int] NOT NULL,
	[RosterAssignmentID] [tinyint] NOT NULL,
	[ResponseLower] [smallint] NOT NULL,
	[ResponseUpper] [smallint] NOT NULL,
	[Resolved] [bit] NOT NULL,
	[R] [float] NULL,
	[RBoundLower] [float] NOT NULL,
	[RBoundUpper] [float] NOT NULL,
	[SameGeneration] [tinyint] NOT NULL,
	[ShareBiodad] [tinyint] NOT NULL,
	[ShareBiomom] [tinyint] NOT NULL,
	[ShareBiograndparent] [tinyint] NOT NULL,
	[Inconsistent] [bit] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vewRelatedValuesGen1Only]
AS
SELECT     Process.tblRelatedStructure.ExtendedID, Process.tblRelatedStructure.SubjectTag_S1, Process.tblRelatedStructure.SubjectTag_S2, 
                      Process.tblRelatedStructure.RelationshipPath, Process.tblRelatedValues.R, Process.tblRelatedValues.MultipleBirthIfSameSex, Process.tblRelatedValues.IsMz, 
                      Process.tblRelatedValues.LastSurvey_S1, Process.tblRelatedValues.LastSurvey_S2, Process.tblRelatedValues.RImplicitPass1, Process.tblRelatedValues.RImplicit, 
                      Process.tblRelatedValues.RImplicit2004, Process.tblRelatedValues.RImplicit - Process.tblRelatedValues.RImplicit2004 AS RImplicitDifference, 
                      Process.tblRelatedValues.RExplicit, Process.tblRelatedValues.RExplicitPass1, Process.tblRelatedValues.RPass1, 
                      Process.tblRelatedValues.RExplicitOlderSibVersion, Process.tblRelatedValues.RExplicitYoungerSibVersion, Process.tblRosterGen1.RosterAssignmentID, 
                      Process.tblRosterGen1.R AS RosterR, Process.tblRelatedValues.RFull, Process.tblRosterGen1.SameGeneration
FROM         Process.tblRelatedValues INNER JOIN
                      Process.tblRelatedStructure ON Process.tblRelatedValues.ID = Process.tblRelatedStructure.ID INNER JOIN
                      Process.tblRosterGen1 ON Process.tblRelatedStructure.ID = Process.tblRosterGen1.RelatedID
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vewSubjectDetails79Heavy]
AS
SELECT     Process.tblSubject.SubjectTag, Process.tblSubject.ExtendedID, Process.tblSubject.Generation, Process.tblSubject.Gender, Process.tblSubjectDetails.RaceCohort, 
                      Process.tblSubjectDetails.SiblingCountInNls, Process.tblSubjectDetails.BirthOrderInNls, Process.tblSubjectDetails.SimilarAgeCount, 
                      Process.tblSubjectDetails.HasMzPossibly, Process.tblSubjectDetails.KidCountBio, Process.tblSubjectDetails.KidCountInNls, Process.tblSubjectDetails.Mob, 
                      Process.tblSubjectDetails.LastSurveyYearCompleted, Process.tblSubjectDetails.AgeAtLastSurvey, Process.tblSubjectDetails.IsDead, 
                      Process.tblSubjectDetails.DeathDate
FROM         Process.tblSubject INNER JOIN
                      Process.tblSubjectDetails ON Process.tblSubject.SubjectTag = Process.tblSubjectDetails.SubjectTag
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [Process].[vewSubjectDetails]
AS
SELECT     Process.tblSubject.SubjectTag, Process.tblSubject.ExtendedID, Process.tblSubject.SubjectID, Process.tblSubject.Generation, Process.tblSubject.Gender, 
                      Process.tblSubjectDetails.Mob, Process.tblSubjectDetails.RaceCohort
FROM         Process.tblSubject INNER JOIN
                      Process.tblSubjectDetails ON Process.tblSubject.SubjectTag = Process.tblSubjectDetails.SubjectTag
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
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [Process].[vewSurveyTimeMostRecent]
AS
SELECT     TOP (100) PERCENT SubjectTag, MAX(SurveyYear) AS SurveyYearMostRecent
FROM         Process.tblSurveyTime
WHERE     (SurveySource > 0)
GROUP BY SubjectTag
ORDER BY SubjectTag
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Archive].[tblArchiveDescription](
	[AlgorithmVersion] [smallint] NOT NULL,
	[Description] [varchar](255) NOT NULL,
	[Date] [date] NULL,
 CONSTRAINT [PK_tblArchiveDescription] PRIMARY KEY CLUSTERED 
(
	[AlgorithmVersion] 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 [Archive].[tblRelatedValuesArchive](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[AlgorithmVersion] [smallint] NOT NULL,
	[SubjectTag_S1] [int] NOT NULL,
	[SubjectTag_S2] [int] NOT NULL,
	[MultipleBirthIfSameSex] [tinyint] NOT NULL,
	[IsMz] [tinyint] NOT NULL,
	[SameGeneration] [tinyint] NULL,
	[RosterAssignmentID] [tinyint] NULL,
	[RRoster] [float] NULL,
	[LastSurvey_S1] [smallint] NULL,
	[LastSurvey_S2] [smallint] NULL,
	[RImplicitPass1] [float] NULL,
	[RImplicit] [float] NULL,
	[RImplicitSubject] [float] NULL,
	[RImplicitMother] [float] NULL,
	[RImplicit2004] [float] NULL,
	[RExplicitOldestSibVersion] [float] NULL,
	[RExplicitYoungestSibVersion] [float] NULL,
	[RExplicitPass1] [float] NULL,
	[RExplicit] [float] NULL,
	[RPass1] [float] NULL,
	[R] [float] NULL,
	[RFull] [float] NULL,
	[RPeek] [float] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Enum].[tblLUBioparent-not-used](
	[ID] [tinyint] NOT NULL,
	[Label] [char](3) NOT NULL,
 CONSTRAINT [PK_tblLUBioparent] 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 [Enum].[tblLUExtractSource](
	[ID] [tinyint] NOT NULL,
	[Label] [char](25) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLUExtractSource] 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 [Enum].[tblLUGender](
	[ID] [tinyint] NOT NULL,
	[Label] [char](15) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLUGender] 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 [Enum].[tblLUMarkerEvidence](
	[ID] [tinyint] NOT NULL,
	[Label] [char](20) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLUMarkerEvidence] 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 [Enum].[tblLUMarkerType](
	[ID] [tinyint] NOT NULL,
	[Label] [char](40) NOT NULL,
	[Explicit] [bit] NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLUMarkerType] 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 [Enum].[tblLUMultipleBirth](
	[ID] [tinyint] NOT NULL,
	[Label] [char](10) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLUMultipleBirth] 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 [Enum].[tblLURaceCohort](
	[ID] [tinyint] NOT NULL,
	[Label] [varchar](15) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLURaceCohort] 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 [Enum].[tblLURelationshipPath](
	[ID] [tinyint] NOT NULL,
	[Label] [char](20) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLURelationshipPath] 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 [Enum].[tblLURosterGen1](
	[ID] [smallint] NOT NULL,
	[Label] [varchar](255) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLURosterGen1] 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 [Enum].[tblLUSurveySource](
	[ID] [tinyint] NOT NULL,
	[Label] [char](12) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLUSurvey] 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 [Enum].[tblLUTristate](
	[ID] [tinyint] NOT NULL,
	[Label] [char](10) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) 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 [Enum].[tblLUYesNo](
	[ID] [smallint] NOT NULL,
	[Label] [char](40) NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) 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 [Extract].[tbl97Roster](
	[R0000100] [int] NULL,
	[R0536300] [int] NULL,
	[R0536401] [int] NULL,
	[R0536402] [int] NULL,
	[R1097800] [int] NULL,
	[R1097900] [int] NULL,
	[R1098000] [int] NULL,
	[R1098100] [int] NULL,
	[R1098200] [int] NULL,
	[R1098300] [int] NULL,
	[R1098400] [int] NULL,
	[R1098500] [int] NULL,
	[R1098600] [int] NULL,
	[R1098700] [int] NULL,
	[R1098800] [int] NULL,
	[R1098900] [int] NULL,
	[R1099000] [int] NULL,
	[R1099100] [int] NULL,
	[R1099200] [int] NULL,
	[R1099300] [int] NULL,
	[R1101000] [int] NULL,
	[R1101100] [int] NULL,
	[R1101200] [int] NULL,
	[R1101300] [int] NULL,
	[R1101400] [int] NULL,
	[R1101500] [int] NULL,
	[R1101600] [int] NULL,
	[R1101700] [int] NULL,
	[R1101800] [int] NULL,
	[R1101900] [int] NULL,
	[R1102000] [int] NULL,
	[R1102100] [int] NULL,
	[R1102200] [int] NULL,
	[R1102300] [int] NULL,
	[R1102400] [int] NULL,
	[R1102500] [int] NULL,
	[R1102501] [int] NULL,
	[R1102600] [int] NULL,
	[R1102700] [int] NULL,
	[R1102800] [int] NULL,
	[R1102900] [int] NULL,
	[R1103000] [int] NULL,
	[R1103100] [int] NULL,
	[R1103200] [int] NULL,
	[R1103300] [int] NULL,
	[R1103400] [int] NULL,
	[R1103500] [int] NULL,
	[R1103600] [int] NULL,
	[R1103700] [int] NULL,
	[R1103800] [int] NULL,
	[R1103900] [int] NULL,
	[R1104000] [int] NULL,
	[R1104100] [int] NULL,
	[R1117000] [int] NULL,
	[R1117100] [int] NULL,
	[R1117200] [int] NULL,
	[R1117300] [int] NULL,
	[R1117400] [int] NULL,
	[R1117500] [int] NULL,
	[R1117600] [int] NULL,
	[R1117700] [int] NULL,
	[R1117800] [int] NULL,
	[R1117900] [int] NULL,
	[R1118000] [int] NULL,
	[R1118100] [int] NULL,
	[R1118200] [int] NULL,
	[R1118300] [int] NULL,
	[R1118400] [int] NULL,
	[R1118500] [int] NULL,
	[R1118600] [int] NULL,
	[R1118700] [int] NULL,
	[R1118800] [int] NULL,
	[R1118900] [int] NULL,
	[R1119000] [int] NULL,
	[R1119100] [int] NULL,
	[R1119200] [int] NULL,
	[R1119300] [int] NULL,
	[R1119400] [int] NULL,
	[R1119500] [int] NULL,
	[R1119600] [int] NULL,
	[R1119700] [int] NULL,
	[R1119800] [int] NULL,
	[R1119900] [int] NULL,
	[R1120000] [int] NULL,
	[R1120100] [int] NULL,
	[R1120200] [int] NULL,
	[R1120300] [int] NULL,
	[R1120400] [int] NULL,
	[R1120500] [int] NULL,
	[R1120600] [int] NULL,
	[R1120700] [int] NULL,
	[R1120800] [int] NULL,
	[R1120900] [int] NULL,
	[R1121000] [int] NULL,
	[R1121100] [int] NULL,
	[R1121200] [int] NULL,
	[R1121300] [int] NULL,
	[R1121400] [int] NULL,
	[R1121500] [int] NULL,
	[R1121600] [int] NULL,
	[R1121700] [int] NULL,
	[R1121800] [int] NULL,
	[R1121900] [int] NULL,
	[R1122000] [int] NULL,
	[R1122100] [int] NULL,
	[R1122200] [int] NULL,
	[R1122300] [int] NULL,
	[R1122400] [int] NULL,
	[R1122500] [int] NULL,
	[R1122600] [int] NULL,
	[R1122700] [int] NULL,
	[R1122800] [int] NULL,
	[R1122900] [int] NULL,
	[R1123000] [int] NULL,
	[R1123100] [int] NULL,
	[R1123200] [int] NULL,
	[R1123300] [int] NULL,
	[R1123400] [int] NULL,
	[R1123500] [int] NULL,
	[R1123600] [int] NULL,
	[R1123700] [int] NULL,
	[R1123800] [int] NULL,
	[R1123900] [int] NULL,
	[R1124000] [int] NULL,
	[R1124100] [int] NULL,
	[R1124200] [int] NULL,
	[R1124300] [int] NULL,
	[R1124400] [int] NULL,
	[R1124500] [int] NULL,
	[R1124600] [int] NULL,
	[R1124700] [int] NULL,
	[R1124800] [int] NULL,
	[R1124900] [int] NULL,
	[R1125000] [int] NULL,
	[R1125100] [int] NULL,
	[R1125200] [int] NULL,
	[R1125300] [int] NULL,
	[R1125400] [int] NULL,
	[R1125500] [int] NULL,
	[R1125600] [int] NULL,
	[R1125700] [int] NULL,
	[R1125800] [int] NULL,
	[R1125900] [int] NULL,
	[R1126000] [int] NULL,
	[R1126100] [int] NULL,
	[R1126200] [int] NULL,
	[R1126300] [int] NULL,
	[R1126400] [int] NULL,
	[R1126500] [int] NULL,
	[R1126600] [int] NULL,
	[R1126700] [int] NULL,
	[R1126800] [int] NULL,
	[R1126900] [int] NULL,
	[R1127000] [int] NULL,
	[R1127100] [int] NULL,
	[R1127200] [int] NULL,
	[R1127300] [int] NULL,
	[R1127400] [int] NULL,
	[R1127500] [int] NULL,
	[R1127600] [int] NULL,
	[R1127700] [int] NULL,
	[R1127800] [int] NULL,
	[R1127900] [int] NULL,
	[R1128000] [int] NULL,
	[R1128100] [int] NULL,
	[R1128200] [int] NULL,
	[R1128300] [int] NULL,
	[R1128400] [int] NULL,
	[R1128500] [int] NULL,
	[R1128600] [int] NULL,
	[R1128700] [int] NULL,
	[R1128800] [int] NULL,
	[R1128900] [int] NULL,
	[R1129000] [int] NULL,
	[R1129100] [int] NULL,
	[R1129200] [int] NULL,
	[R1129300] [int] NULL,
	[R1129400] [int] NULL,
	[R1129500] [int] NULL,
	[R1129600] [int] NULL,
	[R1129700] [int] NULL,
	[R1131900] [int] NULL,
	[R1132000] [int] NULL,
	[R1132100] [int] NULL,
	[R1132200] [int] NULL,
	[R1132300] [int] NULL,
	[R1132400] [int] NULL,
	[R1132500] [int] NULL,
	[R1132600] [int] NULL,
	[R1132700] [int] NULL,
	[R1132800] [int] NULL,
	[R1132900] [int] NULL,
	[R1133000] [int] NULL,
	[R1133100] [int] NULL,
	[R1133200] [int] NULL,
	[R1133300] [int] NULL,
	[R1133400] [int] NULL,
	[R1134200] [int] NULL,
	[R1134300] [int] NULL,
	[R1134400] [int] NULL,
	[R1134500] [int] NULL,
	[R1134600] [int] NULL,
	[R1134700] [int] NULL,
	[R1134800] [int] NULL,
	[R1134900] [int] NULL,
	[R1135000] [int] NULL,
	[R1135100] [int] NULL,
	[R1135200] [int] NULL,
	[R1135300] [int] NULL,
	[R1135400] [int] NULL,
	[R1135500] [int] NULL,
	[R1135600] [int] NULL,
	[R1135700] [int] NULL,
	[R1135800] [int] NULL,
	[R1135900] [int] NULL,
	[R1136000] [int] NULL,
	[R1136100] [int] NULL,
	[R1136200] [int] NULL,
	[R1136300] [int] NULL,
	[R1136400] [int] NULL,
	[R1136500] [int] NULL,
	[R1136600] [int] NULL,
	[R1136700] [int] NULL,
	[R1136800] [int] NULL,
	[R1136900] [int] NULL,
	[R1137000] [int] NULL,
	[R1137100] [int] NULL,
	[R1137200] [int] NULL,
	[R1137300] [int] NULL,
	[R1137400] [int] NULL,
	[R1137500] [int] NULL,
	[R1137600] [int] NULL,
	[R1137700] [int] NULL,
	[R1137800] [int] NULL,
	[R1137900] [int] NULL,
	[R1138000] [int] NULL,
	[R1138100] [int] NULL,
	[R1138200] [int] NULL,
	[R1138300] [int] NULL,
	[R1138400] [int] NULL,
	[R1138500] [int] NULL,
	[R1138600] [int] NULL,
	[R1138700] [int] NULL,
	[R1138800] [int] NULL,
	[R1138900] [int] NULL,
	[R1139000] [int] NULL,
	[R1139100] [int] NULL,
	[R1139200] [int] NULL,
	[R1139300] [int] NULL,
	[R1139400] [int] NULL,
	[R1139500] [int] NULL,
	[R1139600] [int] NULL,
	[R1139700] [int] NULL,
	[R1139800] [int] NULL,
	[R1139900] [int] NULL,
	[R1140000] [int] NULL,
	[R1140100] [int] NULL,
	[R1140200] [int] NULL,
	[R1140300] [int] NULL,
	[R1162100] [int] NULL,
	[R1162200] [int] NULL,
	[R1162300] [int] NULL,
	[R1162400] [int] NULL,
	[R1162500] [int] NULL,
	[R1162600] [int] NULL,
	[R1162700] [int] NULL,
	[R1162800] [int] NULL,
	[R1162900] [int] NULL,
	[R1163000] [int] NULL,
	[R1163100] [int] NULL,
	[R1163200] [int] NULL,
	[R1163300] [int] NULL,
	[R1163400] [int] NULL,
	[R1163500] [int] NULL,
	[R1163600] [int] NULL,
	[R1163601] [int] NULL,
	[R1163700] [int] NULL,
	[R1163800] [int] NULL,
	[R1163900] [int] NULL,
	[R1164000] [int] NULL,
	[R1164100] [int] NULL,
	[R1164200] [int] NULL,
	[R1164300] [int] NULL,
	[R1164400] [int] NULL,
	[R1164500] [int] NULL,
	[R1164600] [int] NULL,
	[R1164700] [int] NULL,
	[R1164800] [int] NULL,
	[R1164900] [int] NULL,
	[R1165000] [int] NULL,
	[R1165100] [int] NULL,
	[R1165200] [int] NULL,
	[R1165300] [int] NULL,
	[R1165400] [int] NULL,
	[R1165500] [int] NULL,
	[R1190700] [int] NULL,
	[R1190800] [int] NULL,
	[R1190900] [int] NULL,
	[R1191000] [int] NULL,
	[R1191100] [int] NULL,
	[R1191200] [int] NULL,
	[R1191400] [int] NULL,
	[R1191600] [int] NULL,
	[R1191700] [int] NULL,
	[R1191800] [int] NULL,
	[R1191900] [int] NULL,
	[R1192000] [int] NULL,
	[R1192100] [int] NULL,
	[R1192200] [int] NULL,
	[R1192300] [int] NULL,
	[R1192400] [int] NULL,
	[R1192500] [int] NULL,
	[R1192600] [int] NULL,
	[R1192700] [int] NULL,
	[R1192800] [int] NULL,
	[R1192900] [int] NULL,
	[R1192901] [int] NULL,
	[R1192902] [int] NULL,
	[R1235800] [int] NULL,
	[R1315800] [int] NULL,
	[R1315900] [int] NULL,
	[R1316000] [int] NULL,
	[R1316100] [int] NULL,
	[R1316200] [int] NULL,
	[R1316300] [int] NULL,
	[R1316400] [int] NULL,
	[R1316500] [int] NULL,
	[R1316600] [int] NULL,
	[R1316700] [int] NULL,
	[R1316800] [int] NULL,
	[R1316900] [int] NULL,
	[R1317000] [int] NULL,
	[R1317100] [int] NULL,
	[R1317200] [int] NULL,
	[R1317300] [int] NULL,
	[R1317400] [int] NULL,
	[R1482600] [int] NULL,
	[R2409300] [int] NULL,
	[R2409400] [int] NULL,
	[R2409500] [int] NULL,
	[R2409600] [int] NULL,
	[R2409700] [int] NULL,
	[R2409800] [int] NULL,
	[R2409900] [int] NULL,
	[R2410000] [int] NULL,
	[R2410100] [int] NULL,
	[R2410200] [int] NULL,
	[R2410300] [int] NULL,
	[R2410400] [int] NULL,
	[R2410500] [int] NULL,
	[R2410600] [int] NULL,
	[R2416300] [int] NULL,
	[R2416400] [int] NULL,
	[R2416500] [int] NULL,
	[R2416600] [int] NULL,
	[R2416700] [int] NULL,
	[R2416800] [int] NULL,
	[R2416900] [int] NULL,
	[R2417000] [int] NULL,
	[R2417100] [int] NULL,
	[R2417200] [int] NULL,
	[R2417300] [int] NULL,
	[R2417400] [int] NULL,
	[R2417500] [int] NULL,
	[R2417600] [int] NULL,
	[U1258700] [int] NULL,
	[U1258800] [int] NULL,
	[U1258900] [int] NULL,
	[U1259000] [int] NULL,
	[U1259100] [int] NULL,
	[U1259200] [int] NULL,
	[U1259300] [int] NULL,
	[U1259400] [int] NULL,
	[U1259500] [int] NULL,
	[U1259600] [int] NULL,
	[U1259700] [int] NULL,
	[U1259800] [int] NULL,
	[U1259900] [int] NULL,
	[U1260000] [int] NULL,
	[U1260100] [int] NULL,
	[U1260200] [int] NULL,
	[U1260300] [int] NULL,
	[U1261700] [int] NULL,
	[U1261800] [int] NULL,
	[U1261900] [int] NULL,
	[U1262000] [int] NULL,
	[U1262100] [int] NULL,
	[U1262200] [int] NULL,
	[U1262300] [int] NULL,
	[U1262400] [int] NULL,
	[U1262500] [int] NULL,
	[U1262600] [int] NULL,
	[U1262700] [int] NULL,
	[U1262800] [int] NULL,
	[U1262900] [int] NULL,
	[U1263000] [int] NULL,
	[U1263100] [int] NULL,
	[U1263200] [int] NULL,
	[U1263300] [int] NULL,
	[U1266000] [int] NULL,
	[U1266100] [int] NULL,
	[U1266200] [int] NULL,
	[U1266300] [int] NULL,
	[U1266400] [int] NULL,
	[U1266500] [int] NULL,
	[U1266600] [int] NULL,
	[U1266700] [int] NULL,
	[U1266800] [int] NULL,
	[U1266900] [int] NULL,
	[U1267000] [int] NULL,
	[U1267100] [int] NULL,
	[U1267200] [int] NULL,
	[U1267300] [int] NULL,
	[U1267400] [int] NULL,
	[U1267500] [int] NULL,
	[U1267600] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen1Explicit](
	[R0000100] [int] NOT NULL,
	[R0000149] [int] NULL,
	[R0000150] [int] NULL,
	[R0000151] [int] NULL,
	[R0000152] [int] NULL,
	[R0000153] [int] NULL,
	[R0000154] [int] NULL,
	[R0000155] [int] NULL,
	[R0000156] [int] NULL,
	[R0000157] [int] NULL,
	[R0000158] [int] NULL,
	[R0000159] [int] NULL,
	[R0000162] [int] NULL,
	[R0000163] [int] NULL,
	[R0000164] [int] NULL,
	[R0000165] [int] NULL,
	[R0000166] [int] NULL,
	[R0173600] [int] NULL,
	[R0214700] [int] NULL,
	[R0214800] [int] NULL,
	[R4125101] [int] NULL,
	[R4125801] [int] NULL,
	[R4126501] [int] NULL,
	[R4127201] [int] NULL,
	[R4127901] [int] NULL,
	[R4128601] [int] NULL,
	[R4129301] [int] NULL,
	[R4130001] [int] NULL,
	[R4130701] [int] NULL,
	[R4131401] [int] NULL,
	[R4132101] [int] NULL,
	[R4132801] [int] NULL,
	[R4133701] [int] NULL,
	[R4521500] [int] NULL,
	[R4521700] [int] NULL,
	[R4521800] [int] NULL,
	[R4521900] [int] NULL,
	[R4522000] [int] NULL,
	[R4522100] [int] NULL,
	[R4522200] [int] NULL,
	[R4522300] [int] NULL,
	[R4522400] [int] NULL,
	[R4522500] [int] NULL,
	[R4522600] [int] NULL,
	[R4522700] [int] NULL,
	[R4522800] [int] NULL,
	[T0002000] [int] NULL,
	[T0002100] [int] NULL,
	[T0002200] [int] NULL,
	[T0002300] [int] NULL,
	[T0002400] [int] NULL,
	[T0002500] [int] NULL,
	[T0002600] [int] NULL,
	[T0002700] [int] NULL,
	[T0002800] [int] NULL,
	[T0002900] [int] NULL,
	[T0003000] [int] NULL,
	[T0003100] [int] NULL,
	[T0003200] [int] NULL,
	[T0003300] [int] NULL,
	[T0003400] [int] NULL,
	[T0003500] [int] NULL,
	[T0003600] [int] NULL,
	[T0003700] [int] NULL,
	[T0003800] [int] NULL,
	[T0003900] [int] NULL,
	[T0004000] [int] NULL,
	[T0004100] [int] NULL,
	[T0004200] [int] NULL,
	[T0004300] [int] NULL,
	[T0004400] [int] NULL,
	[T0004500] [int] NULL,
	[T2261500] [int] NULL,
	[T2261600] [int] NULL,
	[T2261700] [int] NULL,
	[T2261800] [int] NULL,
	[T2261900] [int] NULL,
	[T2262000] [int] NULL,
	[T2262100] [int] NULL,
	[T2262200] [int] NULL,
	[T2262300] [int] NULL,
	[T2262400] [int] NULL,
	[T2262500] [int] NULL,
	[T2262600] [int] NULL,
	[T2262700] [int] NULL,
	[T2262800] [int] NULL,
	[T2262900] [int] NULL,
	[T2263000] [int] NULL,
	[T2263100] [int] NULL,
	[T2263200] [int] NULL,
	[T2263300] [int] NULL,
	[T2263400] [int] NULL,
	[T2263500] [int] NULL,
	[T2263600] [int] NULL,
	[T2263700] [int] NULL,
	[T2263800] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen1GeocodeSanitized](
	[SubjectTag_S1] [int] NOT NULL,
	[SubjectTag_S2] [int] NOT NULL,
	[DobDifferenceInDays1979V1979] [smallint] NULL,
	[DobDifferenceInDays1979V1981] [smallint] NULL,
	[DobDifferenceInDays1981V1979] [smallint] NULL,
	[DobDifferenceInDays1981V1981] [smallint] NULL,
	[DobDayIsMissing1979_1] [bit] NOT NULL,
	[DobDayIsMissing1979_2] [bit] NOT NULL,
	[BirthSubjectCountyMissing_1] [bit] NOT NULL,
	[BirthSubjectCountyMissing_2] [bit] NOT NULL,
	[BirthSubjectCountyEqual] [bit] NOT NULL,
	[BirthSubjectStateMissing_1] [bit] NOT NULL,
	[BirthSubjectStateMissing_2] [bit] NOT NULL,
	[BirthSubjectStateEqual] [bit] NOT NULL,
	[BirthSubjectCountryMissing_1] [bit] NOT NULL,
	[BirthSubjectCountryMissing_2] [bit] NOT NULL,
	[BirthSubjectCountryEqual] [bit] NOT NULL,
	[BirthMotherStateMissing_1] [bit] NOT NULL,
	[BirthMotherStateMissing_2] [bit] NOT NULL,
	[BirthMotherStateEqual] [bit] NOT NULL,
	[BirthMotherCountryMissing_1] [bit] NOT NULL,
	[BirthMotherCountryMissing_2] [bit] NOT NULL,
	[BirthMotherCountryEqual] [bit] NOT NULL,
	[BirthFatherStateMissing_1] [bit] NOT NULL,
	[BirthFatherStateMissing_2] [bit] NOT NULL,
	[BirthFatherStateEqual] [bit] NOT NULL,
	[BirthFatherCountryMissing_1] [bit] NOT NULL,
	[BirthFatherCountryMissing_2] [bit] NOT NULL,
	[BirthFatherCountryEqual] [bit] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen1Implicit](
	[H0001600] [int] NULL,
	[H0001700] [int] NULL,
	[H0001800] [int] NULL,
	[H0001900] [int] NULL,
	[H0002000] [int] NULL,
	[H0002100] [int] NULL,
	[H0002200] [int] NULL,
	[H0002300] [int] NULL,
	[H0002400] [int] NULL,
	[H0002500] [int] NULL,
	[H0002600] [int] NULL,
	[H0002700] [int] NULL,
	[H0002800] [int] NULL,
	[H0002900] [int] NULL,
	[H0003000] [int] NULL,
	[H0003100] [int] NULL,
	[H0013600] [int] NULL,
	[H0013700] [int] NULL,
	[H0013800] [int] NULL,
	[H0013900] [int] NULL,
	[H0014000] [int] NULL,
	[H0014100] [int] NULL,
	[H0014200] [int] NULL,
	[H0014300] [int] NULL,
	[H0014400] [int] NULL,
	[H0014500] [int] NULL,
	[H0014700] [int] NULL,
	[H0014800] [int] NULL,
	[H0014900] [int] NULL,
	[H0015000] [int] NULL,
	[H0015100] [int] NULL,
	[H0015200] [int] NULL,
	[H0015300] [int] NULL,
	[H0015400] [int] NULL,
	[H0015500] [int] NULL,
	[H0015600] [int] NULL,
	[H0015700] [int] NULL,
	[H0015800] [int] NULL,
	[H0015803] [int] NULL,
	[H0015804] [int] NULL,
	[R0000100] [int] NOT NULL,
	[R0006100] [int] NULL,
	[R0006500] [int] NULL,
	[R0007300] [int] NULL,
	[R0007700] [int] NULL,
	[R0007900] [int] NULL,
	[R0173600] [int] NULL,
	[R0214700] [int] NULL,
	[R0214800] [int] NULL,
	[R2302900] [int] NULL,
	[R2303100] [int] NULL,
	[R2303200] [int] NULL,
	[R2303300] [int] NULL,
	[R2303500] [int] NULL,
	[R2303600] [int] NULL,
	[R2505100] [int] NULL,
	[R2505300] [int] NULL,
	[R2505400] [int] NULL,
	[R2505500] [int] NULL,
	[R2505700] [int] NULL,
	[R2505800] [int] NULL,
	[R2737900] [int] NULL,
	[R2837200] [int] NULL,
	[R2837300] [int] NULL,
	[R2837400] [int] NULL,
	[R2837500] [int] NULL,
	[R2837600] [int] NULL,
	[R2837700] [int] NULL,
	[R2837800] [int] NULL,
	[R2837900] [int] NULL,
	[R2838000] [int] NULL,
	[R2838100] [int] NULL,
	[R2838200] [int] NULL,
	[R2838300] [int] NULL,
	[R2838400] [int] NULL,
	[R2838500] [int] NULL,
	[R2838600] [int] NULL,
	[R2838700] [int] NULL,
	[R2838800] [int] NULL,
	[R2838900] [int] NULL,
	[R2839000] [int] NULL,
	[R2839100] [int] NULL,
	[R2839200] [int] NULL,
	[R2839300] [int] NULL,
	[R2839400] [int] NULL,
	[R2839500] [int] NULL,
	[R2839600] [int] NULL,
	[R2839700] [int] NULL,
	[R2839800] [int] NULL,
	[R2839900] [int] NULL,
	[R2840000] [int] NULL,
	[R2840100] [int] NULL,
	[R2840200] [int] NULL,
	[R2840300] [int] NULL,
	[R2840400] [int] NULL,
	[R2840500] [int] NULL,
	[R2840600] [int] NULL,
	[R2840700] [int] NULL,
	[R2840800] [int] NULL,
	[R2840900] [int] NULL,
	[R2841000] [int] NULL,
	[R2841100] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen1Links](
	[R0000100] [int] NOT NULL,
	[R0000149] [int] NULL,
	[R0000300] [int] NULL,
	[R0000500] [int] NULL,
	[R0009100] [int] NULL,
	[R0009300] [int] NULL,
	[R0172500] [int] NULL,
	[R0172600] [int] NULL,
	[R0173600] [int] NULL,
	[R0214700] [int] NULL,
	[R0214800] [int] NULL,
	[R0216500] [int] NULL,
	[R0329200] [int] NULL,
	[R0329210] [int] NULL,
	[R0406510] [int] NULL,
	[R0410100] [int] NULL,
	[R0410300] [int] NULL,
	[R0530700] [int] NULL,
	[R0530800] [int] NULL,
	[R0619010] [int] NULL,
	[R0809900] [int] NULL,
	[R0810000] [int] NULL,
	[R0898310] [int] NULL,
	[R1045700] [int] NULL,
	[R1045800] [int] NULL,
	[R1145110] [int] NULL,
	[R1427500] [int] NULL,
	[R1427600] [int] NULL,
	[R1520310] [int] NULL,
	[R1774100] [int] NULL,
	[R1774200] [int] NULL,
	[R1794600] [int] NULL,
	[R1794700] [int] NULL,
	[R1891010] [int] NULL,
	[R2156200] [int] NULL,
	[R2156300] [int] NULL,
	[R2258110] [int] NULL,
	[R2365700] [int] NULL,
	[R2365800] [int] NULL,
	[R2445510] [int] NULL,
	[R2742500] [int] NULL,
	[R2742600] [int] NULL,
	[R2871300] [int] NULL,
	[R2986100] [int] NULL,
	[R2986200] [int] NULL,
	[R3075000] [int] NULL,
	[R3302500] [int] NULL,
	[R3302600] [int] NULL,
	[R3401700] [int] NULL,
	[R3573400] [int] NULL,
	[R3573500] [int] NULL,
	[R3657100] [int] NULL,
	[R3917600] [int] NULL,
	[R3917700] [int] NULL,
	[R4007600] [int] NULL,
	[R4100200] [int] NULL,
	[R4100201] [int] NULL,
	[R4100202] [int] NULL,
	[R4418700] [int] NULL,
	[R4500200] [int] NULL,
	[R4500201] [int] NULL,
	[R4500202] [int] NULL,
	[R5081700] [int] NULL,
	[R5167000] [int] NULL,
	[R5200200] [int] NULL,
	[R5200201] [int] NULL,
	[R5200202] [int] NULL,
	[R6435300] [int] NULL,
	[R6435301] [int] NULL,
	[R6435302] [int] NULL,
	[R6479800] [int] NULL,
	[R6963300] [int] NULL,
	[R6963301] [int] NULL,
	[R6963302] [int] NULL,
	[R7007500] [int] NULL,
	[R7656300] [int] NULL,
	[R7656301] [int] NULL,
	[R7656302] [int] NULL,
	[R7704800] [int] NULL,
	[R7800500] [int] NULL,
	[R7800501] [int] NULL,
	[R7800502] [int] NULL,
	[R8497200] [int] NULL,
	[R9908000] [int] NULL,
	[T0000900] [int] NULL,
	[T0000901] [int] NULL,
	[T0000902] [int] NULL,
	[T0989000] [int] NULL,
	[T1200700] [int] NULL,
	[T1200701] [int] NULL,
	[T1200702] [int] NULL,
	[T2210800] [int] NULL,
	[T2260600] [int] NULL,
	[T2260601] [int] NULL,
	[T2260602] [int] NULL,
	[T2763400] [int] NULL,
	[T2763500] [int] NULL,
	[T2763600] [int] NULL,
	[T2763700] [int] NULL,
	[T2763800] [int] NULL,
	[T2763900] [int] NULL,
	[T2764000] [int] NULL,
	[T3108700] [int] NULL,
	[T3195600] [int] NULL,
	[T3195601] [int] NULL,
	[T3195602] [int] NULL,
	[T3729600] [int] NULL,
	[T3729700] [int] NULL,
	[T3729800] [int] NULL,
	[T3729900] [int] NULL,
	[T3730000] [int] NULL,
	[T3730100] [int] NULL,
	[T4113200] [int] NULL,
	[T4181100] [int] NULL,
	[T4181101] [int] NULL,
	[T4181102] [int] NULL,
	[T5023600] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen1MzDzDistinction2010](
	[ExtendedFamilyID] [smallint] NOT NULL,
	[Subject1ID] [int] NOT NULL,
	[Subject2ID] [int] NOT NULL,
	[REstimatedFromImplicitAndExplicits] [real] NOT NULL,
	[MultipleBirth] [tinyint] NOT NULL,
	[IsMz] [tinyint] NOT NULL,
	[RelationshipPath] [tinyint] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen1Outcomes](
	[R0000100] [int] NOT NULL,
	[R0173600] [int] NULL,
	[R0214700] [int] NULL,
	[R0214800] [int] NULL,
	[R0481600] [int] NULL,
	[R0481700] [int] NULL,
	[R0618200] [int] NULL,
	[R0618300] [int] NULL,
	[R0618301] [int] NULL,
	[R0779800] [int] NULL,
	[R0779900] [int] NULL,
	[R1773900] [int] NULL,
	[R1774000] [int] NULL,
	[T0897300] [int] NULL,
	[T0897400] [int] NULL,
	[T0897500] [int] NULL,
	[T2053800] [int] NULL,
	[T2053900] [int] NULL,
	[T2054000] [int] NULL,
	[T3024700] [int] NULL,
	[T3024800] [int] NULL,
	[T3024900] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen2FatherFromGen1](
	[R0000100] [int] NOT NULL,
	[R0173600] [int] NULL,
	[R0214700] [int] NULL,
	[R0214800] [int] NULL,
	[R1373300] [int] NULL,
	[R1373500] [int] NULL,
	[R1374000] [int] NULL,
	[R1374200] [int] NULL,
	[R1374700] [int] NULL,
	[R1374900] [int] NULL,
	[R1375400] [int] NULL,
	[R1375600] [int] NULL,
	[R1376100] [int] NULL,
	[R1376300] [int] NULL,
	[R1376800] [int] NULL,
	[R1377000] [int] NULL,
	[R1377500] [int] NULL,
	[R1377700] [int] NULL,
	[R1753700] [int] NULL,
	[R1753900] [int] NULL,
	[R1754400] [int] NULL,
	[R1754600] [int] NULL,
	[R1755100] [int] NULL,
	[R1755300] [int] NULL,
	[R1755800] [int] NULL,
	[R1756000] [int] NULL,
	[R1756500] [int] NULL,
	[R1756700] [int] NULL,
	[R1757200] [int] NULL,
	[R1757400] [int] NULL,
	[R1757900] [int] NULL,
	[R1758100] [int] NULL,
	[R2095700] [int] NULL,
	[R2095900] [int] NULL,
	[R2096400] [int] NULL,
	[R2096600] [int] NULL,
	[R2097100] [int] NULL,
	[R2097300] [int] NULL,
	[R2097800] [int] NULL,
	[R2098000] [int] NULL,
	[R2098500] [int] NULL,
	[R2098700] [int] NULL,
	[R2099200] [int] NULL,
	[R2099400] [int] NULL,
	[R2099900] [int] NULL,
	[R2100100] [int] NULL,
	[R2345900] [int] NULL,
	[R2346200] [int] NULL,
	[R2346500] [int] NULL,
	[R2346800] [int] NULL,
	[R2347100] [int] NULL,
	[R2347400] [int] NULL,
	[R2347700] [int] NULL,
	[R2648000] [int] NULL,
	[R2648200] [int] NULL,
	[R2648700] [int] NULL,
	[R2648900] [int] NULL,
	[R2649400] [int] NULL,
	[R2649600] [int] NULL,
	[R2650100] [int] NULL,
	[R2650300] [int] NULL,
	[R2650800] [int] NULL,
	[R2651000] [int] NULL,
	[R2651500] [int] NULL,
	[R2651700] [int] NULL,
	[R2652200] [int] NULL,
	[R2652400] [int] NULL,
	[R2955900] [int] NULL,
	[R2956200] [int] NULL,
	[R2956500] [int] NULL,
	[R2956800] [int] NULL,
	[R2957100] [int] NULL,
	[R2957400] [int] NULL,
	[R2957700] [int] NULL,
	[R3255900] [int] NULL,
	[R3256100] [int] NULL,
	[R3257700] [int] NULL,
	[R3257900] [int] NULL,
	[R3259500] [int] NULL,
	[R3259700] [int] NULL,
	[R3261300] [int] NULL,
	[R3261500] [int] NULL,
	[R3263100] [int] NULL,
	[R3263300] [int] NULL,
	[R3264900] [int] NULL,
	[R3265100] [int] NULL,
	[R3266700] [int] NULL,
	[R3266900] [int] NULL,
	[R3268500] [int] NULL,
	[R3556400] [int] NULL,
	[R3557000] [int] NULL,
	[R3557600] [int] NULL,
	[R3771800] [int] NULL,
	[R3772000] [int] NULL,
	[R3772100] [int] NULL,
	[R3772400] [int] NULL,
	[R3773900] [int] NULL,
	[R3774100] [int] NULL,
	[R3774200] [int] NULL,
	[R3774500] [int] NULL,
	[R3776000] [int] NULL,
	[R3776200] [int] NULL,
	[R3776300] [int] NULL,
	[R3776600] [int] NULL,
	[R3778100] [int] NULL,
	[R3778300] [int] NULL,
	[R3778400] [int] NULL,
	[R3778700] [int] NULL,
	[R3780200] [int] NULL,
	[R3780400] [int] NULL,
	[R3780500] [int] NULL,
	[R3780800] [int] NULL,
	[R3782300] [int] NULL,
	[R3782500] [int] NULL,
	[R3782600] [int] NULL,
	[R3782900] [int] NULL,
	[R3784400] [int] NULL,
	[R3784600] [int] NULL,
	[R3784700] [int] NULL,
	[R3785000] [int] NULL,
	[R3786500] [int] NULL,
	[R3788004] [int] NULL,
	[R4276800] [int] NULL,
	[R4277000] [int] NULL,
	[R4277100] [int] NULL,
	[R4277101] [int] NULL,
	[R4277700] [int] NULL,
	[R4277900] [int] NULL,
	[R4278000] [int] NULL,
	[R4278001] [int] NULL,
	[R4278600] [int] NULL,
	[R4278800] [int] NULL,
	[R4278900] [int] NULL,
	[R4278901] [int] NULL,
	[R4279500] [int] NULL,
	[R4279700] [int] NULL,
	[R4279800] [int] NULL,
	[R4279801] [int] NULL,
	[R4280400] [int] NULL,
	[R4280600] [int] NULL,
	[R4280700] [int] NULL,
	[R4280701] [int] NULL,
	[R4281300] [int] NULL,
	[R4281500] [int] NULL,
	[R4281600] [int] NULL,
	[R4281601] [int] NULL,
	[R4282100] [int] NULL,
	[R4282300] [int] NULL,
	[R4282400] [int] NULL,
	[R4282401] [int] NULL,
	[R4282900] [int] NULL,
	[R4283000] [int] NULL,
	[R4283100] [int] NULL,
	[R4283600] [int] NULL,
	[R4827600] [int] NULL,
	[R4827800] [int] NULL,
	[R4827900] [int] NULL,
	[R4827901] [int] NULL,
	[R4828100] [int] NULL,
	[R4830600] [int] NULL,
	[R4830800] [int] NULL,
	[R4830900] [int] NULL,
	[R4830901] [int] NULL,
	[R4831100] [int] NULL,
	[R4833600] [int] NULL,
	[R4833800] [int] NULL,
	[R4833900] [int] NULL,
	[R4833901] [int] NULL,
	[R4834100] [int] NULL,
	[R4836600] [int] NULL,
	[R4836800] [int] NULL,
	[R4836900] [int] NULL,
	[R4836901] [int] NULL,
	[R4837100] [int] NULL,
	[R4839600] [int] NULL,
	[R4839800] [int] NULL,
	[R4839900] [int] NULL,
	[R4839901] [int] NULL,
	[R4840100] [int] NULL,
	[R4842500] [int] NULL,
	[R4842700] [int] NULL,
	[R4842800] [int] NULL,
	[R4842801] [int] NULL,
	[R4842900] [int] NULL,
	[R4844800] [int] NULL,
	[R4845000] [int] NULL,
	[R4845100] [int] NULL,
	[R4845101] [int] NULL,
	[R4845200] [int] NULL,
	[R4847100] [int] NULL,
	[R4847300] [int] NULL,
	[R4847400] [int] NULL,
	[R5498000] [int] NULL,
	[R5498200] [int] NULL,
	[R5498300] [int] NULL,
	[R5498301] [int] NULL,
	[R5498500] [int] NULL,
	[R5501000] [int] NULL,
	[R5501200] [int] NULL,
	[R5501300] [int] NULL,
	[R5501301] [int] NULL,
	[R5501500] [int] NULL,
	[R5504000] [int] NULL,
	[R5504200] [int] NULL,
	[R5504300] [int] NULL,
	[R5504301] [int] NULL,
	[R5504500] [int] NULL,
	[R5507000] [int] NULL,
	[R5507200] [int] NULL,
	[R5507300] [int] NULL,
	[R5507301] [int] NULL,
	[R5507500] [int] NULL,
	[R5510000] [int] NULL,
	[R5510200] [int] NULL,
	[R5510300] [int] NULL,
	[R5510301] [int] NULL,
	[R5510500] [int] NULL,
	[R5513000] [int] NULL,
	[R5513200] [int] NULL,
	[R5513300] [int] NULL,
	[R5513301] [int] NULL,
	[R5513400] [int] NULL,
	[R5515300] [int] NULL,
	[R5515500] [int] NULL,
	[R5515600] [int] NULL,
	[R5515601] [int] NULL,
	[R5515700] [int] NULL,
	[R5517600] [int] NULL,
	[R5517800] [int] NULL,
	[R5517900] [int] NULL,
	[R5519800] [int] NULL,
	[R5520000] [int] NULL,
	[R5520100] [int] NULL,
	[R5520101] [int] NULL,
	[R5520200] [int] NULL,
	[R6218400] [int] NULL,
	[R6218500] [int] NULL,
	[R6218600] [int] NULL,
	[R6218700] [int] NULL,
	[R6218800] [int] NULL,
	[R6218900] [int] NULL,
	[R6219000] [int] NULL,
	[R6219100] [int] NULL,
	[R6219200] [int] NULL,
	[R6219300] [int] NULL,
	[R6220600] [int] NULL,
	[R6220700] [int] NULL,
	[R6220800] [int] NULL,
	[R6220900] [int] NULL,
	[R6221000] [int] NULL,
	[R6221100] [int] NULL,
	[R6221200] [int] NULL,
	[R6221300] [int] NULL,
	[R6221400] [int] NULL,
	[R6221500] [int] NULL,
	[R6221700] [int] NULL,
	[R6221701] [int] NULL,
	[R6221800] [int] NULL,
	[R6221801] [int] NULL,
	[R6221900] [int] NULL,
	[R6221901] [int] NULL,
	[R6222000] [int] NULL,
	[R6222001] [int] NULL,
	[R6222100] [int] NULL,
	[R6222101] [int] NULL,
	[R6222200] [int] NULL,
	[R6222201] [int] NULL,
	[R6222300] [int] NULL,
	[R6222301] [int] NULL,
	[R6222400] [int] NULL,
	[R6222401] [int] NULL,
	[R6222500] [int] NULL,
	[R6222501] [int] NULL,
	[R6222600] [int] NULL,
	[R6222601] [int] NULL,
	[R6223400] [int] NULL,
	[R6223500] [int] NULL,
	[R6223600] [int] NULL,
	[R6223700] [int] NULL,
	[R6223800] [int] NULL,
	[R6223900] [int] NULL,
	[R6224000] [int] NULL,
	[R6224100] [int] NULL,
	[R6224200] [int] NULL,
	[R6224300] [int] NULL,
	[R6770600] [int] NULL,
	[R6771600] [int] NULL,
	[R6771700] [int] NULL,
	[R6771800] [int] NULL,
	[R6771900] [int] NULL,
	[R6772000] [int] NULL,
	[R6772100] [int] NULL,
	[R6772200] [int] NULL,
	[R6772300] [int] NULL,
	[R6772400] [int] NULL,
	[R6772500] [int] NULL,
	[R6772600] [int] NULL,
	[R6772700] [int] NULL,
	[R6772800] [int] NULL,
	[R6772900] [int] NULL,
	[R6773000] [int] NULL,
	[R6773100] [int] NULL,
	[R6773200] [int] NULL,
	[R6773300] [int] NULL,
	[R6773400] [int] NULL,
	[R6774500] [int] NULL,
	[R6774600] [int] NULL,
	[R6774700] [int] NULL,
	[R6774800] [int] NULL,
	[R6774900] [int] NULL,
	[R6775000] [int] NULL,
	[R6775100] [int] NULL,
	[R6775200] [int] NULL,
	[R6775300] [int] NULL,
	[R6775400] [int] NULL,
	[R6775500] [int] NULL,
	[R6775501] [int] NULL,
	[R6775600] [int] NULL,
	[R6775601] [int] NULL,
	[R6775700] [int] NULL,
	[R6775701] [int] NULL,
	[R6775800] [int] NULL,
	[R6775801] [int] NULL,
	[R6775900] [int] NULL,
	[R6775901] [int] NULL,
	[R6776000] [int] NULL,
	[R6776001] [int] NULL,
	[R6776100] [int] NULL,
	[R6776101] [int] NULL,
	[R6776200] [int] NULL,
	[R6776201] [int] NULL,
	[R6776900] [int] NULL,
	[R6777000] [int] NULL,
	[R6777100] [int] NULL,
	[R6777200] [int] NULL,
	[R6777300] [int] NULL,
	[R6777400] [int] NULL,
	[R6777500] [int] NULL,
	[R6777600] [int] NULL,
	[R6777700] [int] NULL,
	[R6777800] [int] NULL,
	[R7415900] [int] NULL,
	[R7416000] [int] NULL,
	[R7416100] [int] NULL,
	[R7416200] [int] NULL,
	[R7416300] [int] NULL,
	[R7416400] [int] NULL,
	[R7416500] [int] NULL,
	[R7416600] [int] NULL,
	[R7416700] [int] NULL,
	[R7416800] [int] NULL,
	[R7416900] [int] NULL,
	[R7417000] [int] NULL,
	[R7417100] [int] NULL,
	[R7417200] [int] NULL,
	[R7417300] [int] NULL,
	[R7417400] [int] NULL,
	[R7417500] [int] NULL,
	[R7417600] [int] NULL,
	[R7417700] [int] NULL,
	[R7417800] [int] NULL,
	[R7418900] [int] NULL,
	[R7419000] [int] NULL,
	[R7419100] [int] NULL,
	[R7419200] [int] NULL,
	[R7419300] [int] NULL,
	[R7419400] [int] NULL,
	[R7419500] [int] NULL,
	[R7419600] [int] NULL,
	[R7419700] [int] NULL,
	[R7419800] [int] NULL,
	[R7419900] [int] NULL,
	[R7419901] [int] NULL,
	[R7420000] [int] NULL,
	[R7420001] [int] NULL,
	[R7420100] [int] NULL,
	[R7420101] [int] NULL,
	[R7420200] [int] NULL,
	[R7420201] [int] NULL,
	[R7420300] [int] NULL,
	[R7420301] [int] NULL,
	[R7420400] [int] NULL,
	[R7420401] [int] NULL,
	[R7420500] [int] NULL,
	[R7420501] [int] NULL,
	[R7420600] [int] NULL,
	[R7420601] [int] NULL,
	[R7421400] [int] NULL,
	[R7421500] [int] NULL,
	[R7421600] [int] NULL,
	[R7421700] [int] NULL,
	[R7421800] [int] NULL,
	[R7421900] [int] NULL,
	[R7422000] [int] NULL,
	[R7422100] [int] NULL,
	[R7422200] [int] NULL,
	[R7422300] [int] NULL,
	[R8114000] [int] NULL,
	[R8114100] [int] NULL,
	[R8114200] [int] NULL,
	[R8114300] [int] NULL,
	[R8114400] [int] NULL,
	[R8114500] [int] NULL,
	[R8114600] [int] NULL,
	[R8114700] [int] NULL,
	[R8114800] [int] NULL,
	[R8114900] [int] NULL,
	[R8115000] [int] NULL,
	[R8115100] [int] NULL,
	[R8115200] [int] NULL,
	[R8115300] [int] NULL,
	[R8115400] [int] NULL,
	[R8115500] [int] NULL,
	[R8115600] [int] NULL,
	[R8115700] [int] NULL,
	[R8115800] [int] NULL,
	[R8115900] [int] NULL,
	[R8117000] [int] NULL,
	[R8117100] [int] NULL,
	[R8117200] [int] NULL,
	[R8117300] [int] NULL,
	[R8117400] [int] NULL,
	[R8117500] [int] NULL,
	[R8117600] [int] NULL,
	[R8117700] [int] NULL,
	[R8117800] [int] NULL,
	[R8117900] [int] NULL,
	[R8118000] [int] NULL,
	[R8118001] [int] NULL,
	[R8118100] [int] NULL,
	[R8118101] [int] NULL,
	[R8118200] [int] NULL,
	[R8118201] [int] NULL,
	[R8118300] [int] NULL,
	[R8118301] [int] NULL,
	[R8118400] [int] NULL,
	[R8118401] [int] NULL,
	[R8118500] [int] NULL,
	[R8118501] [int] NULL,
	[R8118600] [int] NULL,
	[R8118601] [int] NULL,
	[R8118700] [int] NULL,
	[R8118701] [int] NULL,
	[R8118800] [int] NULL,
	[R8118801] [int] NULL,
	[R8118900] [int] NULL,
	[R8118901] [int] NULL,
	[R8119600] [int] NULL,
	[R8119700] [int] NULL,
	[R8119800] [int] NULL,
	[R8119900] [int] NULL,
	[R8120000] [int] NULL,
	[R8120100] [int] NULL,
	[R8120200] [int] NULL,
	[R8120300] [int] NULL,
	[R8120400] [int] NULL,
	[R8120500] [int] NULL,
	[R8135300] [int] NULL,
	[R8135400] [int] NULL,
	[R8135500] [int] NULL,
	[R8135600] [int] NULL,
	[R8135700] [int] NULL,
	[R8135800] [int] NULL,
	[R8135900] [int] NULL,
	[R9900600] [int] NULL,
	[R9900601] [int] NULL,
	[R9901400] [int] NULL,
	[R9901401] [int] NULL,
	[R9902200] [int] NULL,
	[R9902201] [int] NULL,
	[R9903000] [int] NULL,
	[R9903001] [int] NULL,
	[R9903800] [int] NULL,
	[R9903801] [int] NULL,
	[R9904600] [int] NULL,
	[R9904601] [int] NULL,
	[R9905400] [int] NULL,
	[R9905401] [int] NULL,
	[R9911200] [int] NULL,
	[R9911201] [int] NULL,
	[T0345800] [int] NULL,
	[T0345900] [int] NULL,
	[T0346000] [int] NULL,
	[T0346100] [int] NULL,
	[T0346200] [int] NULL,
	[T0346300] [int] NULL,
	[T0346400] [int] NULL,
	[T0346500] [int] NULL,
	[T0346600] [int] NULL,
	[T0346700] [int] NULL,
	[T0346800] [int] NULL,
	[T0346900] [int] NULL,
	[T0347000] [int] NULL,
	[T0347100] [int] NULL,
	[T0347200] [int] NULL,
	[T0347300] [int] NULL,
	[T0347400] [int] NULL,
	[T0347500] [int] NULL,
	[T0347600] [int] NULL,
	[T0347700] [int] NULL,
	[T0347800] [int] NULL,
	[T0349000] [int] NULL,
	[T0349100] [int] NULL,
	[T0349200] [int] NULL,
	[T0349300] [int] NULL,
	[T0349400] [int] NULL,
	[T0349500] [int] NULL,
	[T0349600] [int] NULL,
	[T0349700] [int] NULL,
	[T0349800] [int] NULL,
	[T0349900] [int] NULL,
	[T0350000] [int] NULL,
	[T0350100] [int] NULL,
	[T0350101] [int] NULL,
	[T0350200] [int] NULL,
	[T0350201] [int] NULL,
	[T0350300] [int] NULL,
	[T0350301] [int] NULL,
	[T0350400] [int] NULL,
	[T0350401] [int] NULL,
	[T0350500] [int] NULL,
	[T0350501] [int] NULL,
	[T0350600] [int] NULL,
	[T0350601] [int] NULL,
	[T0350700] [int] NULL,
	[T0350701] [int] NULL,
	[T0350800] [int] NULL,
	[T0350801] [int] NULL,
	[T0350900] [int] NULL,
	[T0350901] [int] NULL,
	[T0351000] [int] NULL,
	[T0351001] [int] NULL,
	[T0351900] [int] NULL,
	[T0352000] [int] NULL,
	[T0352100] [int] NULL,
	[T0352200] [int] NULL,
	[T0352300] [int] NULL,
	[T0352400] [int] NULL,
	[T0352500] [int] NULL,
	[T0352600] [int] NULL,
	[T0352700] [int] NULL,
	[T0352800] [int] NULL,
	[T0352900] [int] NULL,
	[T0597800] [int] NULL,
	[T0597900] [int] NULL,
	[T0598000] [int] NULL,
	[T0598100] [int] NULL,
	[T0598200] [int] NULL,
	[T0598300] [int] NULL,
	[T0598400] [int] NULL,
	[T1495200] [int] NULL,
	[T1495300] [int] NULL,
	[T1495400] [int] NULL,
	[T1495500] [int] NULL,
	[T1495600] [int] NULL,
	[T1495700] [int] NULL,
	[T1495800] [int] NULL,
	[T1495900] [int] NULL,
	[T1496000] [int] NULL,
	[T1496100] [int] NULL,
	[T1496200] [int] NULL,
	[T1496300] [int] NULL,
	[T1496400] [int] NULL,
	[T1496500] [int] NULL,
	[T1496600] [int] NULL,
	[T1496700] [int] NULL,
	[T1496800] [int] NULL,
	[T1496900] [int] NULL,
	[T1497000] [int] NULL,
	[T1497100] [int] NULL,
	[T1497200] [int] NULL,
	[T1498400] [int] NULL,
	[T1498500] [int] NULL,
	[T1498600] [int] NULL,
	[T1498700] [int] NULL,
	[T1498800] [int] NULL,
	[T1498900] [int] NULL,
	[T1499000] [int] NULL,
	[T1499100] [int] NULL,
	[T1499200] [int] NULL,
	[T1499300] [int] NULL,
	[T1499400] [int] NULL,
	[T1499500] [int] NULL,
	[T1499501] [int] NULL,
	[T1499600] [int] NULL,
	[T1499601] [int] NULL,
	[T1499700] [int] NULL,
	[T1499701] [int] NULL,
	[T1499800] [int] NULL,
	[T1499801] [int] NULL,
	[T1499900] [int] NULL,
	[T1499901] [int] NULL,
	[T1500000] [int] NULL,
	[T1500001] [int] NULL,
	[T1500100] [int] NULL,
	[T1500101] [int] NULL,
	[T1500200] [int] NULL,
	[T1500201] [int] NULL,
	[T1500300] [int] NULL,
	[T1500301] [int] NULL,
	[T1500400] [int] NULL,
	[T1500401] [int] NULL,
	[T1501100] [int] NULL,
	[T1501200] [int] NULL,
	[T1501300] [int] NULL,
	[T1501400] [int] NULL,
	[T1501500] [int] NULL,
	[T1501600] [int] NULL,
	[T1501700] [int] NULL,
	[T1501800] [int] NULL,
	[T1501900] [int] NULL,
	[T1502000] [int] NULL,
	[T1502100] [int] NULL,
	[T1765100] [int] NULL,
	[T1765200] [int] NULL,
	[T1765300] [int] NULL,
	[T1765400] [int] NULL,
	[T1765500] [int] NULL,
	[T1765600] [int] NULL,
	[T1765700] [int] NULL,
	[T2541200] [int] NULL,
	[T2541300] [int] NULL,
	[T2541400] [int] NULL,
	[T2541500] [int] NULL,
	[T2541600] [int] NULL,
	[T2541700] [int] NULL,
	[T2541800] [int] NULL,
	[T2541900] [int] NULL,
	[T2542000] [int] NULL,
	[T2542100] [int] NULL,
	[T2542200] [int] NULL,
	[T2542300] [int] NULL,
	[T2542400] [int] NULL,
	[T2542500] [int] NULL,
	[T2542600] [int] NULL,
	[T2542700] [int] NULL,
	[T2542800] [int] NULL,
	[T2542900] [int] NULL,
	[T2543000] [int] NULL,
	[T2543100] [int] NULL,
	[T2544200] [int] NULL,
	[T2544300] [int] NULL,
	[T2544400] [int] NULL,
	[T2544500] [int] NULL,
	[T2544600] [int] NULL,
	[T2544700] [int] NULL,
	[T2544800] [int] NULL,
	[T2544900] [int] NULL,
	[T2545000] [int] NULL,
	[T2545100] [int] NULL,
	[T2545200] [int] NULL,
	[T2545201] [int] NULL,
	[T2545300] [int] NULL,
	[T2545301] [int] NULL,
	[T2545400] [int] NULL,
	[T2545401] [int] NULL,
	[T2545500] [int] NULL,
	[T2545501] [int] NULL,
	[T2545600] [int] NULL,
	[T2545601] [int] NULL,
	[T2545700] [int] NULL,
	[T2545701] [int] NULL,
	[T2545800] [int] NULL,
	[T2545801] [int] NULL,
	[T2545900] [int] NULL,
	[T2545901] [int] NULL,
	[T2546000] [int] NULL,
	[T2546001] [int] NULL,
	[T2546800] [int] NULL,
	[T2546900] [int] NULL,
	[T2547000] [int] NULL,
	[T2547100] [int] NULL,
	[T2547200] [int] NULL,
	[T2547300] [int] NULL,
	[T2547400] [int] NULL,
	[T2547500] [int] NULL,
	[T2547600] [int] NULL,
	[T2547700] [int] NULL,
	[T2763400] [int] NULL,
	[T2763500] [int] NULL,
	[T2763600] [int] NULL,
	[T2763700] [int] NULL,
	[T2763800] [int] NULL,
	[T2763900] [int] NULL,
	[T2764000] [int] NULL,
	[T3527500] [int] NULL,
	[T3527600] [int] NULL,
	[T3527700] [int] NULL,
	[T3527800] [int] NULL,
	[T3527900] [int] NULL,
	[T3528000] [int] NULL,
	[T3528100] [int] NULL,
	[T3528200] [int] NULL,
	[T3528300] [int] NULL,
	[T3528400] [int] NULL,
	[T3530500] [int] NULL,
	[T3530600] [int] NULL,
	[T3530700] [int] NULL,
	[T3530800] [int] NULL,
	[T3530900] [int] NULL,
	[T3531000] [int] NULL,
	[T3531100] [int] NULL,
	[T3531200] [int] NULL,
	[T3531300] [int] NULL,
	[T3531400] [int] NULL,
	[T3531500] [int] NULL,
	[T3531501] [int] NULL,
	[T3531600] [int] NULL,
	[T3531601] [int] NULL,
	[T3531700] [int] NULL,
	[T3531701] [int] NULL,
	[T3531800] [int] NULL,
	[T3531801] [int] NULL,
	[T3531900] [int] NULL,
	[T3531901] [int] NULL,
	[T3532000] [int] NULL,
	[T3532001] [int] NULL,
	[T3532100] [int] NULL,
	[T3532101] [int] NULL,
	[T3532200] [int] NULL,
	[T3532201] [int] NULL,
	[T3532300] [int] NULL,
	[T3532301] [int] NULL,
	[T3532400] [int] NULL,
	[T3532401] [int] NULL,
	[T3533200] [int] NULL,
	[T3533300] [int] NULL,
	[T3533400] [int] NULL,
	[T3533500] [int] NULL,
	[T3533600] [int] NULL,
	[T3533700] [int] NULL,
	[T3533800] [int] NULL,
	[T3533900] [int] NULL,
	[T3534000] [int] NULL,
	[T3534100] [int] NULL,
	[T3729600] [int] NULL,
	[T3729700] [int] NULL,
	[T3729800] [int] NULL,
	[T3729900] [int] NULL,
	[T3730000] [int] NULL,
	[T3730100] [int] NULL,
	[T4496200] [int] NULL,
	[T4496300] [int] NULL,
	[T4496400] [int] NULL,
	[T4496500] [int] NULL,
	[T4496600] [int] NULL,
	[T4496700] [int] NULL,
	[T4496800] [int] NULL,
	[T4496900] [int] NULL,
	[T4497000] [int] NULL,
	[T4497100] [int] NULL,
	[T4500700] [int] NULL,
	[T4500800] [int] NULL,
	[T4500900] [int] NULL,
	[T4501000] [int] NULL,
	[T4501100] [int] NULL,
	[T4501200] [int] NULL,
	[T4501300] [int] NULL,
	[T4501400] [int] NULL,
	[T4501500] [int] NULL,
	[T4501600] [int] NULL,
	[T4501700] [int] NULL,
	[T4501701] [int] NULL,
	[T4501800] [int] NULL,
	[T4501801] [int] NULL,
	[T4501900] [int] NULL,
	[T4501901] [int] NULL,
	[T4502000] [int] NULL,
	[T4502001] [int] NULL,
	[T4502100] [int] NULL,
	[T4502101] [int] NULL,
	[T4502200] [int] NULL,
	[T4502201] [int] NULL,
	[T4502300] [int] NULL,
	[T4502301] [int] NULL,
	[T4502400] [int] NULL,
	[T4502401] [int] NULL,
	[T4502500] [int] NULL,
	[T4502501] [int] NULL,
	[T4502600] [int] NULL,
	[T4502601] [int] NULL,
	[T4504900] [int] NULL,
	[T4505000] [int] NULL,
	[T4505100] [int] NULL,
	[T4505200] [int] NULL,
	[T4505300] [int] NULL,
	[T4505400] [int] NULL,
	[T4505500] [int] NULL,
	[T4505600] [int] NULL,
	[T4505700] [int] NULL,
	[T4505800] [int] NULL,
	[T4703500] [int] NULL,
	[T4703600] [int] NULL,
	[T4703700] [int] NULL,
	[T4703800] [int] NULL,
	[T4703900] [int] NULL,
	[T4704000] [int] NULL,
 CONSTRAINT [PK_tblGen2FatherFromGen1] PRIMARY KEY CLUSTERED 
(
	[R0000100] 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 [Extract].[tblGen2FatherFromGen1Death](
	[R0000100] [int] NOT NULL,
	[R0214700] [int] NULL,
	[R1373400] [int] NULL,
	[R1374100] [int] NULL,
	[R1374800] [int] NULL,
	[R1375500] [int] NULL,
	[R1376200] [int] NULL,
	[R1376900] [int] NULL,
	[R1377600] [int] NULL,
	[R1753800] [int] NULL,
	[R1754500] [int] NULL,
	[R1755200] [int] NULL,
	[R1755900] [int] NULL,
	[R1756600] [int] NULL,
	[R1757300] [int] NULL,
	[R1758000] [int] NULL,
	[R2095800] [int] NULL,
	[R2096500] [int] NULL,
	[R2097200] [int] NULL,
	[R2097900] [int] NULL,
	[R2098600] [int] NULL,
	[R2099300] [int] NULL,
	[R2100000] [int] NULL,
	[R2648100] [int] NULL,
	[R2648800] [int] NULL,
	[R2649500] [int] NULL,
	[R2650200] [int] NULL,
	[R2650900] [int] NULL,
	[R2651600] [int] NULL,
	[R2652300] [int] NULL,
	[R3256000] [int] NULL,
	[R3257800] [int] NULL,
	[R3259600] [int] NULL,
	[R3261400] [int] NULL,
	[R3263200] [int] NULL,
	[R3265000] [int] NULL,
	[R3266800] [int] NULL,
	[R3771900] [int] NULL,
	[R3772200] [int] NULL,
	[R3772300] [int] NULL,
	[R3774000] [int] NULL,
	[R3774300] [int] NULL,
	[R3774400] [int] NULL,
	[R3776100] [int] NULL,
	[R3776400] [int] NULL,
	[R3776500] [int] NULL,
	[R3778200] [int] NULL,
	[R3778500] [int] NULL,
	[R3778600] [int] NULL,
	[R3780300] [int] NULL,
	[R3780600] [int] NULL,
	[R3780700] [int] NULL,
	[R3782400] [int] NULL,
	[R3784500] [int] NULL,
	[R4276900] [int] NULL,
	[R4277200] [int] NULL,
	[R4277201] [int] NULL,
	[R4277800] [int] NULL,
	[R4278100] [int] NULL,
	[R4278101] [int] NULL,
	[R4278700] [int] NULL,
	[R4279000] [int] NULL,
	[R4279001] [int] NULL,
	[R4279600] [int] NULL,
	[R4279900] [int] NULL,
	[R4279901] [int] NULL,
	[R4280500] [int] NULL,
	[R4280800] [int] NULL,
	[R4280801] [int] NULL,
	[R4281400] [int] NULL,
	[R4282200] [int] NULL,
	[R4827700] [int] NULL,
	[R4828000] [int] NULL,
	[R4828001] [int] NULL,
	[R4830700] [int] NULL,
	[R4831000] [int] NULL,
	[R4831001] [int] NULL,
	[R4833700] [int] NULL,
	[R4834000] [int] NULL,
	[R4834001] [int] NULL,
	[R4836700] [int] NULL,
	[R4837000] [int] NULL,
	[R4837001] [int] NULL,
	[R4839700] [int] NULL,
	[R4840000] [int] NULL,
	[R4840001] [int] NULL,
	[R4842600] [int] NULL,
	[R4844900] [int] NULL,
	[R4847200] [int] NULL,
	[R5498100] [int] NULL,
	[R5498400] [int] NULL,
	[R5498401] [int] NULL,
	[R5501100] [int] NULL,
	[R5501400] [int] NULL,
	[R5501401] [int] NULL,
	[R5504100] [int] NULL,
	[R5504400] [int] NULL,
	[R5504401] [int] NULL,
	[R5507100] [int] NULL,
	[R5507400] [int] NULL,
	[R5507401] [int] NULL,
	[R5510100] [int] NULL,
	[R5510400] [int] NULL,
	[R5510401] [int] NULL,
	[R5513100] [int] NULL,
	[R5515400] [int] NULL,
	[R5517700] [int] NULL,
	[R5519900] [int] NULL,
	[R6219500] [int] NULL,
	[R6219600] [int] NULL,
	[R6219700] [int] NULL,
	[R6219800] [int] NULL,
	[R6219900] [int] NULL,
	[R6220000] [int] NULL,
	[R6220100] [int] NULL,
	[R6220200] [int] NULL,
	[R6220300] [int] NULL,
	[R6220400] [int] NULL,
	[R6222800] [int] NULL,
	[R6222801] [int] NULL,
	[R6222900] [int] NULL,
	[R6222901] [int] NULL,
	[R6223000] [int] NULL,
	[R6223001] [int] NULL,
	[R6223100] [int] NULL,
	[R6223101] [int] NULL,
	[R6223200] [int] NULL,
	[R6223201] [int] NULL,
	[R6223300] [int] NULL,
	[R6223301] [int] NULL,
	[R6773500] [int] NULL,
	[R6773600] [int] NULL,
	[R6773700] [int] NULL,
	[R6773800] [int] NULL,
	[R6773900] [int] NULL,
	[R6774000] [int] NULL,
	[R6774100] [int] NULL,
	[R6774200] [int] NULL,
	[R6774300] [int] NULL,
	[R6774400] [int] NULL,
	[R6776300] [int] NULL,
	[R6776301] [int] NULL,
	[R6776400] [int] NULL,
	[R6776401] [int] NULL,
	[R6776500] [int] NULL,
	[R6776501] [int] NULL,
	[R6776600] [int] NULL,
	[R6776601] [int] NULL,
	[R6776700] [int] NULL,
	[R6776701] [int] NULL,
	[R6776800] [int] NULL,
	[R6776801] [int] NULL,
	[R7417900] [int] NULL,
	[R7418000] [int] NULL,
	[R7418100] [int] NULL,
	[R7418200] [int] NULL,
	[R7418300] [int] NULL,
	[R7418400] [int] NULL,
	[R7418500] [int] NULL,
	[R7418600] [int] NULL,
	[R7418700] [int] NULL,
	[R7418800] [int] NULL,
	[R7420700] [int] NULL,
	[R7420701] [int] NULL,
	[R7420800] [int] NULL,
	[R7420801] [int] NULL,
	[R7420900] [int] NULL,
	[R7420901] [int] NULL,
	[R7421000] [int] NULL,
	[R7421001] [int] NULL,
	[R7421100] [int] NULL,
	[R7421101] [int] NULL,
	[R7421200] [int] NULL,
	[R7421201] [int] NULL,
	[R7421300] [int] NULL,
	[R7421301] [int] NULL,
	[R8116000] [int] NULL,
	[R8116100] [int] NULL,
	[R8116200] [int] NULL,
	[R8116300] [int] NULL,
	[R8116400] [int] NULL,
	[R8116500] [int] NULL,
	[R8116600] [int] NULL,
	[R8116700] [int] NULL,
	[R8116800] [int] NULL,
	[R8116900] [int] NULL,
	[R8119000] [int] NULL,
	[R8119001] [int] NULL,
	[R8119100] [int] NULL,
	[R8119101] [int] NULL,
	[R8119200] [int] NULL,
	[R8119201] [int] NULL,
	[R8119300] [int] NULL,
	[R8119301] [int] NULL,
	[R8119400] [int] NULL,
	[R8119401] [int] NULL,
	[R8119500] [int] NULL,
	[R8119501] [int] NULL,
	[T0347900] [int] NULL,
	[T0348000] [int] NULL,
	[T0348100] [int] NULL,
	[T0348200] [int] NULL,
	[T0348300] [int] NULL,
	[T0348400] [int] NULL,
	[T0348500] [int] NULL,
	[T0348600] [int] NULL,
	[T0348700] [int] NULL,
	[T0348800] [int] NULL,
	[T0348900] [int] NULL,
	[T0351100] [int] NULL,
	[T0351101] [int] NULL,
	[T0351200] [int] NULL,
	[T0351201] [int] NULL,
	[T0351300] [int] NULL,
	[T0351301] [int] NULL,
	[T0351400] [int] NULL,
	[T0351401] [int] NULL,
	[T0351500] [int] NULL,
	[T0351501] [int] NULL,
	[T0351600] [int] NULL,
	[T0351601] [int] NULL,
	[T0351700] [int] NULL,
	[T0351701] [int] NULL,
	[T0351800] [int] NULL,
	[T0351801] [int] NULL,
	[T1497300] [int] NULL,
	[T1497400] [int] NULL,
	[T1497500] [int] NULL,
	[T1497600] [int] NULL,
	[T1497700] [int] NULL,
	[T1497800] [int] NULL,
	[T1497900] [int] NULL,
	[T1498000] [int] NULL,
	[T1498100] [int] NULL,
	[T1498200] [int] NULL,
	[T1498300] [int] NULL,
	[T1500500] [int] NULL,
	[T1500501] [int] NULL,
	[T1500600] [int] NULL,
	[T1500601] [int] NULL,
	[T1500700] [int] NULL,
	[T1500701] [int] NULL,
	[T1500800] [int] NULL,
	[T1500801] [int] NULL,
	[T1500900] [int] NULL,
	[T1500901] [int] NULL,
	[T1501000] [int] NULL,
	[T1501001] [int] NULL,
	[T2543200] [int] NULL,
	[T2543300] [int] NULL,
	[T2543400] [int] NULL,
	[T2543500] [int] NULL,
	[T2543600] [int] NULL,
	[T2543700] [int] NULL,
	[T2543800] [int] NULL,
	[T2543900] [int] NULL,
	[T2544000] [int] NULL,
	[T2544100] [int] NULL,
	[T2546100] [int] NULL,
	[T2546101] [int] NULL,
	[T2546200] [int] NULL,
	[T2546201] [int] NULL,
	[T2546300] [int] NULL,
	[T2546301] [int] NULL,
	[T2546400] [int] NULL,
	[T2546401] [int] NULL,
	[T2546500] [int] NULL,
	[T2546501] [int] NULL,
	[T2546600] [int] NULL,
	[T2546601] [int] NULL,
	[T2546700] [int] NULL,
	[T2546701] [int] NULL,
	[T3529500] [int] NULL,
	[T3529600] [int] NULL,
	[T3529700] [int] NULL,
	[T3529800] [int] NULL,
	[T3529900] [int] NULL,
	[T3530000] [int] NULL,
	[T3530100] [int] NULL,
	[T3530200] [int] NULL,
	[T3530300] [int] NULL,
	[T3530400] [int] NULL,
	[T3532500] [int] NULL,
	[T3532501] [int] NULL,
	[T3532600] [int] NULL,
	[T3532601] [int] NULL,
	[T3532700] [int] NULL,
	[T3532701] [int] NULL,
	[T3532800] [int] NULL,
	[T3532801] [int] NULL,
	[T3532900] [int] NULL,
	[T3532901] [int] NULL,
	[T3533000] [int] NULL,
	[T3533001] [int] NULL,
	[T3533100] [int] NULL,
	[T3533101] [int] NULL,
	[T4498100] [int] NULL,
	[T4498200] [int] NULL,
	[T4498300] [int] NULL,
	[T4498400] [int] NULL,
	[T4498500] [int] NULL,
	[T4498600] [int] NULL,
	[T4498700] [int] NULL,
	[T4498800] [int] NULL,
	[T4498900] [int] NULL,
	[T4499000] [int] NULL,
	[T4503700] [int] NULL,
	[T4503701] [int] NULL,
	[T4503800] [int] NULL,
	[T4503801] [int] NULL,
	[T4503900] [int] NULL,
	[T4503901] [int] NULL,
	[T4504000] [int] NULL,
	[T4504001] [int] NULL,
	[T4504100] [int] NULL,
	[T4504101] [int] NULL,
	[T4504200] [int] NULL,
	[T4504201] [int] NULL,
 CONSTRAINT [PK_tblGen2FatherFromGen1Death] PRIMARY KEY CLUSTERED 
(
	[R0000100] 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 [Extract].[tblGen2ImplicitFather](
	[C0000100] [int] NOT NULL,
	[C0000200] [int] NULL,
	[C0005300] [int] NULL,
	[C0005400] [int] NULL,
	[C0005700] [int] NULL,
	[C0008100] [int] NULL,
	[C0008200] [int] NULL,
	[C0008300] [int] NULL,
	[C0008600] [int] NULL,
	[C0008700] [int] NULL,
	[C0008800] [int] NULL,
	[C0009100] [int] NULL,
	[C0009200] [int] NULL,
	[C0009300] [int] NULL,
	[C0009600] [int] NULL,
	[C0009700] [int] NULL,
	[C0009800] [int] NULL,
	[C0009900] [int] NULL,
	[C0010110] [int] NULL,
	[C0010200] [int] NULL,
	[C0010300] [int] NULL,
	[C0010400] [int] NULL,
	[C0010700] [int] NULL,
	[C0010800] [int] NULL,
	[C0010900] [int] NULL,
	[C0011110] [int] NULL,
	[C0011111] [int] NULL,
	[C0011112] [int] NULL,
	[C0011113] [int] NULL,
	[C0011114] [int] NULL,
	[C0011117] [int] NULL,
	[C0011118] [int] NULL,
	[C0011119] [int] NULL,
	[C0011122] [int] NULL,
	[C0011123] [int] NULL,
	[C0011124] [int] NULL,
	[C0011127] [int] NULL,
	[C0011128] [int] NULL,
	[C0011129] [int] NULL,
	[C0011132] [int] NULL,
	[C0011133] [int] NULL,
	[C0011134] [int] NULL,
	[C0011137] [int] NULL,
	[C0011138] [int] NULL,
	[C0011139] [int] NULL,
	[C0011142] [int] NULL,
	[C0011143] [int] NULL,
	[C0011144] [int] NULL,
	[C3070500] [int] NULL,
	[C3423600] [int] NULL,
	[C3601100] [int] NULL,
	[C3601700] [int] NULL,
	[C3601800] [int] NULL,
	[C3601900] [int] NULL,
	[C3605900] [int] NULL,
	[C3981100] [int] NULL,
	[C3981700] [int] NULL,
	[C3981800] [int] NULL,
	[C3981900] [int] NULL,
	[C5156100] [int] NULL,
	[C5525500] [int] NULL,
	[C5525600] [int] NULL,
	[C5525700] [int] NULL,
	[C5733200] [int] NULL,
	[C5801800] [int] NULL,
	[C5801900] [int] NULL,
	[C5802000] [int] NULL,
	[C6006200] [int] NULL,
	[Y0003200] [int] NULL,
	[Y0007300] [int] NULL,
	[Y0007400] [int] NULL,
	[Y0007600] [int] NULL,
	[Y0007601] [int] NULL,
	[Y0008000] [int] NULL,
	[Y0008500] [int] NULL,
	[Y0008600] [int] NULL,
	[Y0009400] [int] NULL,
	[Y0394100] [int] NULL,
	[Y0394300] [int] NULL,
	[Y0394500] [int] NULL,
	[Y0394501] [int] NULL,
	[Y0394900] [int] NULL,
	[Y0651000] [int] NULL,
	[Y0682500] [int] NULL,
	[Y0683800] [int] NULL,
	[Y0683900] [int] NULL,
	[Y0684100] [int] NULL,
	[Y0684101] [int] NULL,
	[Y0684500] [int] NULL,
	[Y0947100] [int] NULL,
	[Y0986200] [int] NULL,
	[Y0986700] [int] NULL,
	[Y0988800] [int] NULL,
	[Y0988900] [int] NULL,
	[Y0989400] [int] NULL,
	[Y0989401] [int] NULL,
	[Y0989900] [int] NULL,
	[Y1229100] [int] NULL,
	[Y1229200] [int] NULL,
	[Y1229700] [int] NULL,
	[Y1229701] [int] NULL,
	[Y1264300] [int] NULL,
	[Y1265300] [int] NULL,
	[Y1458900] [int] NULL,
	[Y1459400] [int] NULL,
	[Y1459401] [int] NULL,
	[Y1629500] [int] NULL,
	[Y1704000] [int] NULL,
	[Y1704500] [int] NULL,
	[Y1704501] [int] NULL,
	[Y1707300] [int] NULL,
	[Y1883300] [int] NULL,
	[Y1989500] [int] NULL,
	[Y1990000] [int] NULL,
	[Y1990001] [int] NULL,
	[Y1992900] [int] NULL,
	[Y2197500] [int] NULL,
	[Y2308300] [int] NULL,
	[Y2308800] [int] NULL,
	[Y2308801] [int] NULL,
	[Y2311700] [int] NULL,
	[Y2531800] [int] NULL,
	[Y2641000] [int] NULL,
	[Y2641500] [int] NULL,
	[Y2641501] [int] NULL,
	[Y2644400] [int] NULL,
	[Y2880000] [int] NULL,
	[Y2998200] [int] NULL,
	[Y2998700] [int] NULL,
	[Y2998701] [int] NULL,
	[Y3001600] [int] NULL,
	[Y3249900] [int] NULL,
 CONSTRAINT [PK_tblGen2ImplicitFather] PRIMARY KEY CLUSTERED 
(
	[C0000100] 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 [Extract].[tblGen2Links](
	[C0000100] [int] NOT NULL,
	[C0000200] [int] NULL,
	[C0005300] [int] NULL,
	[C0005400] [int] NULL,
	[C0005500] [int] NULL,
	[C0005700] [int] NULL,
	[C0005800] [int] NULL,
	[C0006500] [int] NULL,
	[C0006800] [int] NULL,
	[C0007010] [int] NULL,
	[C0007030] [int] NULL,
	[C0007041] [int] NULL,
	[C0007043] [int] NULL,
	[C0007045] [int] NULL,
	[C0007047] [int] NULL,
	[C0007049] [int] NULL,
	[C0007052] [int] NULL,
	[C0007055] [int] NULL,
	[C0402400] [int] NULL,
	[C0402500] [int] NULL,
	[C0402600] [int] NULL,
	[C0404100] [int] NULL,
	[C0404200] [int] NULL,
	[C0737000] [int] NULL,
	[C0737100] [int] NULL,
	[C0737200] [int] NULL,
	[C0948700] [int] NULL,
	[C0948800] [int] NULL,
	[C0948900] [int] NULL,
	[C1146600] [int] NULL,
	[C1146700] [int] NULL,
	[C1146800] [int] NULL,
	[C1230100] [int] NULL,
	[C1230200] [int] NULL,
	[C1230300] [int] NULL,
	[C1548100] [int] NULL,
	[C1548101] [int] NULL,
	[C1548102] [int] NULL,
	[C1989400] [int] NULL,
	[C1989401] [int] NULL,
	[C1989402] [int] NULL,
	[C2305100] [int] NULL,
	[C2305101] [int] NULL,
	[C2305102] [int] NULL,
	[C2544700] [int] NULL,
	[C2544701] [int] NULL,
	[C2544702] [int] NULL,
	[C2814500] [int] NULL,
	[C2814501] [int] NULL,
	[C2814502] [int] NULL,
	[C3123500] [int] NULL,
	[C3123501] [int] NULL,
	[C3123502] [int] NULL,
	[C3601100] [int] NULL,
	[C3627700] [int] NULL,
	[C3627701] [int] NULL,
	[C3627702] [int] NULL,
	[C3981100] [int] NULL,
	[C4006300] [int] NULL,
	[C4006301] [int] NULL,
	[C4006302] [int] NULL,
	[C5524800] [int] NULL,
	[C5550100] [int] NULL,
	[C5550101] [int] NULL,
	[C5550102] [int] NULL,
	[C5801100] [int] NULL,
	[Y0000200] [int] NULL,
	[Y0000201] [int] NULL,
	[Y0000202] [int] NULL,
	[Y0002100] [int] NULL,
	[Y0390100] [int] NULL,
	[Y0390101] [int] NULL,
	[Y0390102] [int] NULL,
	[Y0677600] [int] NULL,
	[Y0933700] [int] NULL,
	[Y0933701] [int] NULL,
	[Y0933702] [int] NULL,
	[Y0974800] [int] NULL,
	[Y1180500] [int] NULL,
	[Y1180501] [int] NULL,
	[Y1180502] [int] NULL,
	[Y1192400] [int] NULL,
	[Y1421100] [int] NULL,
	[Y1421101] [int] NULL,
	[Y1421102] [int] NULL,
	[Y1434300] [int] NULL,
	[Y1450200] [int] NULL,
	[Y1450201] [int] NULL,
	[Y1450202] [int] NULL,
	[Y1672700] [int] NULL,
	[Y1695600] [int] NULL,
	[Y1695601] [int] NULL,
	[Y1695602] [int] NULL,
	[Y1707300] [int] NULL,
	[Y1707400] [int] NULL,
	[Y1707500] [int] NULL,
	[Y1707600] [int] NULL,
	[Y1707700] [int] NULL,
	[Y1707800] [int] NULL,
	[Y1707900] [int] NULL,
	[Y1708000] [int] NULL,
	[Y1708100] [int] NULL,
	[Y1708200] [int] NULL,
	[Y1708300] [int] NULL,
	[Y1708400] [int] NULL,
	[Y1708500] [int] NULL,
	[Y1708600] [int] NULL,
	[Y1708700] [int] NULL,
	[Y1708800] [int] NULL,
	[Y1708900] [int] NULL,
	[Y1709000] [int] NULL,
	[Y1709100] [int] NULL,
	[Y1709200] [int] NULL,
	[Y1709300] [int] NULL,
	[Y1948500] [int] NULL,
	[Y1981600] [int] NULL,
	[Y1981601] [int] NULL,
	[Y1981602] [int] NULL,
	[Y1992900] [int] NULL,
	[Y1993000] [int] NULL,
	[Y1993100] [int] NULL,
	[Y1993200] [int] NULL,
	[Y1993300] [int] NULL,
	[Y1993400] [int] NULL,
	[Y1993500] [int] NULL,
	[Y1993600] [int] NULL,
	[Y1993700] [int] NULL,
	[Y1993800] [int] NULL,
	[Y1993900] [int] NULL,
	[Y1994000] [int] NULL,
	[Y1994100] [int] NULL,
	[Y1994200] [int] NULL,
	[Y1994300] [int] NULL,
	[Y1994400] [int] NULL,
	[Y1994500] [int] NULL,
	[Y1994600] [int] NULL,
	[Y1994700] [int] NULL,
	[Y1994800] [int] NULL,
	[Y1994900] [int] NULL,
	[Y2148600] [int] NULL,
	[Y2267100] [int] NULL,
	[Y2300400] [int] NULL,
	[Y2300401] [int] NULL,
	[Y2300402] [int] NULL,
	[Y2311700] [int] NULL,
	[Y2311800] [int] NULL,
	[Y2311900] [int] NULL,
	[Y2312000] [int] NULL,
	[Y2312100] [int] NULL,
	[Y2312200] [int] NULL,
	[Y2312300] [int] NULL,
	[Y2312400] [int] NULL,
	[Y2312500] [int] NULL,
	[Y2312600] [int] NULL,
	[Y2312700] [int] NULL,
	[Y2312800] [int] NULL,
	[Y2312900] [int] NULL,
	[Y2313000] [int] NULL,
	[Y2313100] [int] NULL,
	[Y2313200] [int] NULL,
	[Y2313300] [int] NULL,
	[Y2313400] [int] NULL,
	[Y2313500] [int] NULL,
	[Y2313600] [int] NULL,
	[Y2313700] [int] NULL,
	[Y2567000] [int] NULL,
	[Y2567100] [int] NULL,
	[Y2567200] [int] NULL,
	[Y2616000] [int] NULL,
	[Y2633100] [int] NULL,
	[Y2633101] [int] NULL,
	[Y2633102] [int] NULL,
	[Y2644500] [int] NULL,
	[Y2644600] [int] NULL,
	[Y2644700] [int] NULL,
	[Y2644800] [int] NULL,
	[Y2644900] [int] NULL,
	[Y2645000] [int] NULL,
	[Y2645100] [int] NULL,
	[Y2645200] [int] NULL,
	[Y2645300] [int] NULL,
	[Y2645400] [int] NULL,
	[Y2645500] [int] NULL,
	[Y2645600] [int] NULL,
	[Y2645700] [int] NULL,
	[Y2645800] [int] NULL,
	[Y2645900] [int] NULL,
	[Y2646000] [int] NULL,
	[Y2646100] [int] NULL,
	[Y2646200] [int] NULL,
	[Y2646300] [int] NULL,
	[Y2646400] [int] NULL,
	[Y2966400] [int] NULL,
	[Y2990500] [int] NULL,
	[Y2990501] [int] NULL,
	[Y2990502] [int] NULL,
	[Y3002700] [int] NULL,
	[Y3002800] [int] NULL,
	[Y3002900] [int] NULL,
	[Y3003000] [int] NULL,
	[Y3003100] [int] NULL,
	[Y3003200] [int] NULL,
	[Y3003300] [int] NULL,
	[Y3003400] [int] NULL,
	[Y3003500] [int] NULL,
	[Y3003600] [int] NULL,
	[Y3331900] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen2LinksFromGen1](
	[R0000100] [int] NOT NULL,
	[R0214700] [int] NULL,
	[R0214800] [int] NULL,
	[R4825700] [int] NULL,
	[R4826000] [int] NULL,
	[R4826100] [int] NULL,
	[R4826300] [int] NULL,
	[R4826500] [int] NULL,
	[R4826800] [int] NULL,
	[R5495900] [int] NULL,
	[R5496200] [int] NULL,
	[R5496300] [int] NULL,
	[R5496500] [int] NULL,
	[R5496700] [int] NULL,
	[R5497000] [int] NULL,
	[R5497200] [int] NULL,
	[R6210700] [int] NULL,
	[R6210800] [int] NULL,
	[R6210900] [int] NULL,
	[R6211500] [int] NULL,
	[R6211600] [int] NULL,
	[R6211700] [int] NULL,
	[R6211800] [int] NULL,
	[R6211900] [int] NULL,
	[R6212200] [int] NULL,
	[R6212300] [int] NULL,
	[R6764000] [int] NULL,
	[R6764100] [int] NULL,
	[R6764200] [int] NULL,
	[R6764900] [int] NULL,
	[R6765000] [int] NULL,
	[R6765100] [int] NULL,
	[R6765200] [int] NULL,
	[R6765600] [int] NULL,
	[R6765700] [int] NULL,
	[R6765800] [int] NULL,
	[R6839600] [int] NULL,
	[R7408300] [int] NULL,
	[R7408400] [int] NULL,
	[R7408500] [int] NULL,
	[R7409200] [int] NULL,
	[R7409300] [int] NULL,
	[R7409400] [int] NULL,
	[R7409500] [int] NULL,
	[R7409900] [int] NULL,
	[R7410000] [int] NULL,
	[R7410100] [int] NULL,
	[R7548600] [int] NULL,
	[R8106400] [int] NULL,
	[R8106500] [int] NULL,
	[R8106600] [int] NULL,
	[R8106700] [int] NULL,
	[R8106800] [int] NULL,
	[R8106900] [int] NULL,
	[R8107000] [int] NULL,
	[R8107100] [int] NULL,
	[R8107200] [int] NULL,
	[R8255400] [int] NULL,
	[R9900400] [int] NULL,
	[R9900600] [int] NULL,
	[R9900601] [int] NULL,
	[R9901200] [int] NULL,
	[R9901400] [int] NULL,
	[R9901401] [int] NULL,
	[R9902000] [int] NULL,
	[R9902200] [int] NULL,
	[R9902201] [int] NULL,
	[R9902800] [int] NULL,
	[R9903000] [int] NULL,
	[R9903001] [int] NULL,
	[R9903600] [int] NULL,
	[R9903800] [int] NULL,
	[R9903801] [int] NULL,
	[R9904400] [int] NULL,
	[R9904600] [int] NULL,
	[R9904601] [int] NULL,
	[R9905200] [int] NULL,
	[R9905400] [int] NULL,
	[R9905401] [int] NULL,
	[R9906000] [int] NULL,
	[R9906600] [int] NULL,
	[R9907200] [int] NULL,
	[R9907800] [int] NULL,
	[R9908000] [int] NULL,
	[R9911200] [int] NULL,
	[R9911201] [int] NULL,
	[T0337300] [int] NULL,
	[T0337400] [int] NULL,
	[T0337500] [int] NULL,
	[T0337600] [int] NULL,
	[T0337700] [int] NULL,
	[T0337800] [int] NULL,
	[T0337900] [int] NULL,
	[T0338000] [int] NULL,
	[T0338100] [int] NULL,
	[T0338200] [int] NULL,
	[T0338300] [int] NULL,
	[T0338400] [int] NULL,
	[T0338500] [int] NULL,
	[T0338600] [int] NULL,
	[T1486900] [int] NULL,
	[T1487000] [int] NULL,
	[T1487100] [int] NULL,
	[T1487200] [int] NULL,
	[T1487300] [int] NULL,
	[T1487400] [int] NULL,
	[T1487500] [int] NULL,
	[T1487600] [int] NULL,
	[T1487700] [int] NULL,
	[T1487800] [int] NULL,
	[T2217700] [int] NULL,
	[T2533500] [int] NULL,
	[T2533600] [int] NULL,
	[T2533700] [int] NULL,
	[T2533800] [int] NULL,
	[T2533900] [int] NULL,
	[T2534000] [int] NULL,
	[T2534100] [int] NULL,
	[T2534200] [int] NULL,
	[T2534300] [int] NULL,
	[T2534400] [int] NULL,
	[T2534500] [int] NULL,
	[T3519800] [int] NULL,
	[T3519900] [int] NULL,
	[T3520000] [int] NULL,
	[T3520100] [int] NULL,
	[T3520200] [int] NULL,
	[T3520300] [int] NULL,
	[T3520400] [int] NULL,
	[T3520500] [int] NULL,
	[T3520600] [int] NULL,
	[T4483300] [int] NULL,
	[T4483400] [int] NULL,
	[T4483500] [int] NULL,
	[T4483600] [int] NULL,
	[T4483700] [int] NULL,
	[T4483800] [int] NULL,
 CONSTRAINT [PK_tblGen2LinksFromGen1] PRIMARY KEY CLUSTERED 
(
	[R0000100] 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 [Extract].[tblGen2OutcomesHeight](
	[C0000100] [int] NOT NULL,
	[C0000200] [int] NULL,
	[C0005300] [int] NULL,
	[C0005400] [int] NULL,
	[C0005700] [int] NULL,
	[C0577600] [int] NULL,
	[C0606300] [int] NULL,
	[C0606400] [int] NULL,
	[C0826400] [int] NULL,
	[C0826500] [int] NULL,
	[C1016700] [int] NULL,
	[C1016800] [int] NULL,
	[C1220200] [int] NULL,
	[C1220300] [int] NULL,
	[C1532700] [int] NULL,
	[C1532800] [int] NULL,
	[C1779300] [int] NULL,
	[C1779400] [int] NULL,
	[C2288500] [int] NULL,
	[C2288600] [int] NULL,
	[C2552300] [int] NULL,
	[C2820900] [int] NULL,
	[C3130400] [int] NULL,
	[C3553400] [int] NULL,
	[C3634500] [int] NULL,
	[C3898000] [int] NULL,
	[C4013000] [int] NULL,
	[C5147900] [int] NULL,
	[Y0308300] [int] NULL,
	[Y0308400] [int] NULL,
	[Y0609600] [int] NULL,
	[Y0609700] [int] NULL,
	[Y0903900] [int] NULL,
	[Y0904000] [int] NULL,
	[Y1150800] [int] NULL,
	[Y1150900] [int] NULL,
	[Y1385800] [int] NULL,
	[Y1385900] [int] NULL,
	[Y1637500] [int] NULL,
	[Y1637600] [int] NULL,
	[Y1891100] [int] NULL,
	[Y1891200] [int] NULL,
	[Y2207000] [int] NULL,
	[Y2207100] [int] NULL,
	[Y2544700] [int] NULL,
	[Y2544800] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen2OutcomesMath](
	[C0000100] [int] NOT NULL,
	[C0000200] [int] NULL,
	[C0005300] [int] NULL,
	[C0005400] [int] NULL,
	[C0005700] [int] NULL,
	[C0579900] [int] NULL,
	[C0580000] [int] NULL,
	[C0580100] [int] NULL,
	[C0799400] [int] NULL,
	[C0799500] [int] NULL,
	[C0799600] [int] NULL,
	[C0998600] [int] NULL,
	[C0998700] [int] NULL,
	[C0998800] [int] NULL,
	[C1198600] [int] NULL,
	[C1198700] [int] NULL,
	[C1198800] [int] NULL,
	[C1507600] [int] NULL,
	[C1507700] [int] NULL,
	[C1507800] [int] NULL,
	[C1564500] [int] NULL,
	[C1564600] [int] NULL,
	[C1564700] [int] NULL,
	[C1799900] [int] NULL,
	[C1800000] [int] NULL,
	[C1800100] [int] NULL,
	[C2503500] [int] NULL,
	[C2503600] [int] NULL,
	[C2503700] [int] NULL,
	[C2532000] [int] NULL,
	[C2532100] [int] NULL,
	[C2532200] [int] NULL,
	[C2802800] [int] NULL,
	[C2802900] [int] NULL,
	[C2803000] [int] NULL,
	[C3111300] [int] NULL,
	[C3111400] [int] NULL,
	[C3111500] [int] NULL,
	[C3615000] [int] NULL,
	[C3615100] [int] NULL,
	[C3615200] [int] NULL,
	[C3993600] [int] NULL,
	[C3993700] [int] NULL,
	[C3993800] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblGen2OutcomesWeight](
	[C0000100] [int] NULL,
	[C0000200] [int] NULL,
	[C0005300] [int] NULL,
	[C0005400] [int] NULL,
	[C0005700] [int] NULL,
	[Y0308500] [int] NULL,
	[Y0904100] [int] NULL,
	[Y1151000] [int] NULL,
	[Y1386000] [int] NULL,
	[Y1637700] [int] NULL,
	[Y1891300] [int] NULL,
	[Y2207200] [int] NULL,
	[Y2544900] [int] NULL,
	[Y2623301] [int] NULL,
	[Y2623302] [int] NULL,
	[Y2623401] [int] NULL,
	[Y2623402] [int] NULL,
	[Y2623501] [int] NULL,
	[Y2623502] [int] NULL,
	[Y2623601] [int] NULL,
	[Y2623602] [int] NULL,
	[Y2623701] [int] NULL,
	[Y2623702] [int] NULL,
	[Y2623801] [int] NULL,
	[Y2623802] [int] NULL,
	[Y2623901] [int] NULL,
	[Y2623902] [int] NULL,
	[Y2624001] [int] NULL,
	[Y2624002] [int] NULL,
	[Y2624101] [int] NULL,
	[Y2624102] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblLinks2004Gen1](
	[PairID] [smallint] NOT NULL,
	[ExtendedFamilyID] [smallint] NOT NULL,
	[ID1] [smallint] NOT NULL,
	[ID2] [smallint] NOT NULL,
	[Sex1] [tinyint] NULL,
	[Sex2] [tinyint] NULL,
	[RecommendedRelatedness] [real] NULL,
	[SubjectTag_S1] [int] NOT NULL,
	[SubjectTag_S2] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Extract].[tblLinks2004Gen2](
	[ID1] [int] NOT NULL,
	[ID2] [int] NOT NULL,
	[Sex1] [tinyint] NULL,
	[Sex2] [tinyint] NULL,
	[RecommendedRelatedness] [real] NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Metadata].[tblItem](
	[ID] [smallint] NOT NULL,
	[Label] [varchar](50) NOT NULL,
	[MinValue] [int] NOT NULL,
	[MinNonnegative] [int] NULL,
	[MaxValue] [int] NOT NULL,
	[Active] [varchar](5) NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblLUItem] 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 [Metadata].[tblMzManual](
	[ID] [int] NOT NULL,
	[SubjectTag_S1] [int] NOT NULL,
	[SubjectTag_S2] [int] NOT NULL,
	[Generation] [tinyint] NOT NULL,
	[MultipleBirthIfSameSex] [tinyint] NOT NULL,
	[IsMz] [tinyint] NOT NULL,
	[Undecided] [bit] NOT NULL,
	[Related] [bit] NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblMzManual] 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 [Metadata].[tblRosterGen1Assignment](
	[ID] [tinyint] NOT NULL,
	[ResponseLower] [smallint] NOT NULL,
	[ResponseUpper] [smallint] NOT NULL,
	[Freq] [smallint] NOT NULL,
	[Resolved] [bit] NOT NULL,
	[R] [float] NULL,
	[RBoundLower] [float] NOT NULL,
	[RBoundUpper] [float] NOT NULL,
	[SameGeneration] [tinyint] NOT NULL,
	[ShareBiodad] [tinyint] NOT NULL,
	[ShareBiomom] [tinyint] NOT NULL,
	[ShareBiograndparent] [tinyint] NOT NULL,
	[Inconsistent] [bit] NOT NULL,
	[Notes] [varchar](255) NULL,
	[ResponseLowerLabel] [varchar](50) NULL,
	[ResponseUpperLabel] [varchar](50) NULL,
 CONSTRAINT [PK_tblroster_assignment_gen1] 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 [Metadata].[tblVariable](
	[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,
	[Active] [bit] NOT NULL,
	[Notes] [varchar](255) NULL,
 CONSTRAINT [PK_tblVariable_79] PRIMARY KEY CLUSTERED 
(
	[VariableCode] 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].[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] [date] NULL,
	[BiodadDeathDate] [date] NULL,
	[BiodadDistanceFromHH] [smallint] NULL,
	[BiodadAsthma] [smallint] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Process].[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
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Process].[tblIRDemo1](
	[ID] [int] NOT NULL,
	[Item] [smallint] NOT NULL,
	[Count] [smallint] NOT NULL,
	[Variance] [float] NOT NULL,
	[DateTimeCreated] [date] NOT NULL
) 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 [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 [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
) 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
) 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
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Process].[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
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblRelatedValuesArchive_Unique] ON [Archive].[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
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblGen1GeocodeSanitized_1] ON [Extract].[tblGen1GeocodeSanitized]
(
	[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
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblGen1MzDzDistinction2010] ON [Extract].[tblGen1MzDzDistinction2010]
(
	[Subject1ID] ASC,
	[Subject2ID] 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_tblLinks2004Gen1] ON [Extract].[tblLinks2004Gen1]
(
	[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
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblLinks2004Gen2] ON [Extract].[tblLinks2004Gen2]
(
	[ID1] ASC,
	[ID2] 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_tblMzManual_Unique] ON [Metadata].[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
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblBabyDaddy] ON [Process].[tblBabyDaddy]
(
	[SubjectTag] ASC,
	[ChildLoopIndex] 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
CREATE NONCLUSTERED INDEX [IX_tblOutcome_Unique] ON [Process].[tblOutcome]
(
	[Item] ASC,
	[SubjectTag] ASC,
	[SurveyYear] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblParentsOfGen1Current_UniqueSubjectTag] ON [Process].[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
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblParentsOfGen1Retro_UniqueAge] ON [Process].[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 [Process].[tblParentsOfGen1Retro]
(
	[SubjectTag] ASC,
	[Year] ASC,
	[Bioparent] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblRelatedStructure_Unique] ON [Process].[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
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblRelatedValues] ON [Process].[tblRelatedValues]
(
	[ID] 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_tblRosterGen1] ON [Process].[tblRosterGen1]
(
	[RelatedID] 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_tblSubject_Unique] ON [Process].[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
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblSubjectDetails] ON [Process].[tblSubjectDetails]
(
	[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
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblSurveyTime_Unique] ON [Process].[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
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblRelatedValuesArchive] ON [Archive].[tblRelatedValuesArchive] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tbl97Roster] ON [Extract].[tbl97Roster] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen1Explicit] ON [Extract].[tblGen1Explicit] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen1GeocodeSanitized] ON [Extract].[tblGen1GeocodeSanitized] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen1Implicit] ON [Extract].[tblGen1Implicit] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen1Links] ON [Extract].[tblGen1Links] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen1MzDzDistinction2010_1] ON [Extract].[tblGen1MzDzDistinction2010] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen1Outcomes] ON [Extract].[tblGen1Outcomes] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen2Links] ON [Extract].[tblGen2Links] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen2OutcomesHeight] ON [Extract].[tblGen2OutcomesHeight] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen2OutcomesMath] ON [Extract].[tblGen2OutcomesMath] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblGen2OutcomesWeight] ON [Extract].[tblGen2OutcomesWeight] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblLinks2004Gen1_1] ON [Extract].[tblLinks2004Gen1] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblLinks2004Gen2_1] ON [Extract].[tblLinks2004Gen2] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblBabyDaddy] ON [Process].[tblBabyDaddy] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblFatherOfGen2] ON [Process].[tblFatherOfGen2] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblIRDemo1] ON [Process].[tblIRDemo1] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblMarkerGen1] ON [Process].[tblMarkerGen1] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblMarkerGen2] ON [Process].[tblMarkerGen2] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblOutcome] ON [Process].[tblOutcome] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblParentsOfGen1Current] ON [Process].[tblParentsOfGen1Current] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblParentsOfGen1Retro] ON [Process].[tblParentsOfGen1Retro] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblRelatedValues] ON [Process].[tblRelatedValues] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblResponse] ON [Process].[tblResponse] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblRosterGen1] ON [Process].[tblRosterGen1] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblSubjectDetails] ON [Process].[tblSubjectDetails] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
CREATE CLUSTERED COLUMNSTORE INDEX [ICC_tblSurveyTime] ON [Process].[tblSurveyTime] WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
ALTER TABLE [Archive].[tblRelatedValuesArchive]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValuesArchive_tblLURosterGen1Assignment] FOREIGN KEY([RosterAssignmentID])
REFERENCES [Metadata].[tblRosterGen1Assignment] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Archive].[tblRelatedValuesArchive] CHECK CONSTRAINT [FK_tblRelatedValuesArchive_tblLURosterGen1Assignment]
GO
ALTER TABLE [Archive].[tblRelatedValuesArchive]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValuesArchive_tblLUTristate] FOREIGN KEY([SameGeneration])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Archive].[tblRelatedValuesArchive] CHECK CONSTRAINT [FK_tblRelatedValuesArchive_tblLUTristate]
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLURosterGen1] FOREIGN KEY([ResponseLower])
REFERENCES [Enum].[tblLURosterGen1] ([ID])
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLURosterGen1]
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLURosterGen11] FOREIGN KEY([ResponseUpper])
REFERENCES [Enum].[tblLURosterGen1] ([ID])
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLURosterGen11]
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate] FOREIGN KEY([SameGeneration])
REFERENCES [Enum].[tblLUTristate] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate]
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate1] FOREIGN KEY([ShareBiodad])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate1]
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate2] FOREIGN KEY([ShareBiomom])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate2]
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate3] FOREIGN KEY([ShareBiograndparent])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate3]
GO
ALTER TABLE [Metadata].[tblVariable]  WITH CHECK ADD  CONSTRAINT [FK_tblVariable_79_tblItem_79] FOREIGN KEY([Item])
REFERENCES [Metadata].[tblItem] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Metadata].[tblVariable] CHECK CONSTRAINT [FK_tblVariable_79_tblItem_79]
GO
ALTER TABLE [Metadata].[tblVariable]  WITH CHECK ADD  CONSTRAINT [FK_tblVariable_79_tblLUExtractSource] FOREIGN KEY([ExtractSource])
REFERENCES [Enum].[tblLUExtractSource] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Metadata].[tblVariable] CHECK CONSTRAINT [FK_tblVariable_79_tblLUExtractSource]
GO
ALTER TABLE [Process].[tblBabyDaddy]  WITH CHECK ADD  CONSTRAINT [FK_tblBabyDaddy_tblLUYesNoGen_BiodadInHH] FOREIGN KEY([BiodadInHH])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblBabyDaddy] CHECK CONSTRAINT [FK_tblBabyDaddy_tblLUYesNoGen_BiodadInHH]
GO
ALTER TABLE [Process].[tblBabyDaddy]  WITH CHECK ADD  CONSTRAINT [FK_tblBabyDaddy_tblLUYesNoGen1_BiodadAlive] FOREIGN KEY([BiodadAlive])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblBabyDaddy] CHECK CONSTRAINT [FK_tblBabyDaddy_tblLUYesNoGen1_BiodadAlive]
GO
ALTER TABLE [Process].[tblBabyDaddy]  WITH CHECK ADD  CONSTRAINT [FK_tblBabyDaddy_tblLUYesNoGen1_BiodadAsthma] FOREIGN KEY([BiodadAsthma])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblBabyDaddy] CHECK CONSTRAINT [FK_tblBabyDaddy_tblLUYesNoGen1_BiodadAsthma]
GO
ALTER TABLE [Process].[tblBabyDaddy]  WITH CHECK ADD  CONSTRAINT [FK_tblBabyDaddy_tblSubject] FOREIGN KEY([SubjectTag])
REFERENCES [Process].[tblSubject] ([SubjectTag])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblBabyDaddy] CHECK CONSTRAINT [FK_tblBabyDaddy_tblSubject]
GO
ALTER TABLE [Process].[tblFatherOfGen2]  WITH CHECK ADD  CONSTRAINT [FK_tblFatherOfGen2_tblLUYesNo_BiodadAlive] FOREIGN KEY([BiodadAlive])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblFatherOfGen2] CHECK CONSTRAINT [FK_tblFatherOfGen2_tblLUYesNo_BiodadAlive]
GO
ALTER TABLE [Process].[tblFatherOfGen2]  WITH CHECK ADD  CONSTRAINT [FK_tblFatherOfGen2_tblLUYesNo_BiodadAsthma] FOREIGN KEY([BiodadAsthma])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblFatherOfGen2] CHECK CONSTRAINT [FK_tblFatherOfGen2_tblLUYesNo_BiodadAsthma]
GO
ALTER TABLE [Process].[tblFatherOfGen2]  WITH CHECK ADD  CONSTRAINT [FK_tblFatherOfGen2_tblLUYesNo_BiodadInHH] FOREIGN KEY([BiodadInHH])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblFatherOfGen2] CHECK CONSTRAINT [FK_tblFatherOfGen2_tblLUYesNo_BiodadInHH]
GO
ALTER TABLE [Process].[tblFatherOfGen2]  WITH CHECK ADD  CONSTRAINT [FK_tblFatherOfGen2_tblSubject] FOREIGN KEY([SubjectTag])
REFERENCES [Process].[tblSubject] ([SubjectTag])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblFatherOfGen2] CHECK CONSTRAINT [FK_tblFatherOfGen2_tblSubject]
GO
ALTER TABLE [Process].[tblMarkerGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence] FOREIGN KEY([ShareBioGrandparentEvidence])
REFERENCES [Enum].[tblLUMarkerEvidence] ([ID])
GO
ALTER TABLE [Process].[tblMarkerGen1] CHECK CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence]
GO
ALTER TABLE [Process].[tblMarkerGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_Biodad] FOREIGN KEY([ShareBiodadEvidence])
REFERENCES [Enum].[tblLUMarkerEvidence] ([ID])
GO
ALTER TABLE [Process].[tblMarkerGen1] CHECK CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_Biodad]
GO
ALTER TABLE [Process].[tblMarkerGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_Biomom] FOREIGN KEY([ShareBiomomEvidence])
REFERENCES [Enum].[tblLUMarkerEvidence] ([ID])
GO
ALTER TABLE [Process].[tblMarkerGen1] CHECK CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_Biomom]
GO
ALTER TABLE [Process].[tblMarkerGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_Mz] FOREIGN KEY([MzEvidence])
REFERENCES [Enum].[tblLUMarkerEvidence] ([ID])
GO
ALTER TABLE [Process].[tblMarkerGen1] CHECK CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_Mz]
GO
ALTER TABLE [Process].[tblMarkerGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_ShareBiodad] FOREIGN KEY([ShareBiodadEvidence])
REFERENCES [Enum].[tblLUMarkerEvidence] ([ID])
GO
ALTER TABLE [Process].[tblMarkerGen1] CHECK CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_ShareBiodad]
GO
ALTER TABLE [Process].[tblMarkerGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_ShareBiomom] FOREIGN KEY([ShareBiomomEvidence])
REFERENCES [Enum].[tblLUMarkerEvidence] ([ID])
GO
ALTER TABLE [Process].[tblMarkerGen1] CHECK CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerEvidence_ShareBiomom]
GO
ALTER TABLE [Process].[tblMarkerGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerType] FOREIGN KEY([MarkerType])
REFERENCES [Enum].[tblLUMarkerType] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblMarkerGen1] CHECK CONSTRAINT [FK_tblMarkerGen1_tblLUMarkerType]
GO
ALTER TABLE [Process].[tblMarkerGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen1_tblRelatedStructure] FOREIGN KEY([RelatedID])
REFERENCES [Process].[tblRelatedStructure] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblMarkerGen1] CHECK CONSTRAINT [FK_tblMarkerGen1_tblRelatedStructure]
GO
ALTER TABLE [Process].[tblMarkerGen2]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen2_tblLUMarkerEvidence_Biodad] FOREIGN KEY([ShareBiodadEvidence])
REFERENCES [Enum].[tblLUMarkerEvidence] ([ID])
GO
ALTER TABLE [Process].[tblMarkerGen2] CHECK CONSTRAINT [FK_tblMarkerGen2_tblLUMarkerEvidence_Biodad]
GO
ALTER TABLE [Process].[tblMarkerGen2]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen2_tblLUMarkerEvidence_Mz] FOREIGN KEY([MzEvidence])
REFERENCES [Enum].[tblLUMarkerEvidence] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblMarkerGen2] CHECK CONSTRAINT [FK_tblMarkerGen2_tblLUMarkerEvidence_Mz]
GO
ALTER TABLE [Process].[tblMarkerGen2]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen2_tblLUMarkerType] FOREIGN KEY([MarkerType])
REFERENCES [Enum].[tblLUMarkerType] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblMarkerGen2] CHECK CONSTRAINT [FK_tblMarkerGen2_tblLUMarkerType]
GO
ALTER TABLE [Process].[tblMarkerGen2]  WITH CHECK ADD  CONSTRAINT [FK_tblMarkerGen2_tblRelatedStructure] FOREIGN KEY([RelatedID])
REFERENCES [Process].[tblRelatedStructure] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblMarkerGen2] CHECK CONSTRAINT [FK_tblMarkerGen2_tblRelatedStructure]
GO
ALTER TABLE [Process].[tblOutcome]  WITH CHECK ADD  CONSTRAINT [FK_tblOutcome_tblItem] FOREIGN KEY([Item])
REFERENCES [Metadata].[tblItem] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblOutcome] CHECK CONSTRAINT [FK_tblOutcome_tblItem]
GO
ALTER TABLE [Process].[tblOutcome]  WITH CHECK ADD  CONSTRAINT [FK_tblOutcome_tblSubject] FOREIGN KEY([SubjectTag])
REFERENCES [Process].[tblSubject] ([SubjectTag])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblOutcome] CHECK CONSTRAINT [FK_tblOutcome_tblSubject]
GO
ALTER TABLE [Process].[tblParentsOfGen1Current]  WITH CHECK ADD  CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo] FOREIGN KEY([AlwaysLivedWithBothBioparents])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblParentsOfGen1Current] CHECK CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo]
GO
ALTER TABLE [Process].[tblParentsOfGen1Current]  WITH CHECK ADD  CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiodadAlive] FOREIGN KEY([BiodadAlive])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblParentsOfGen1Current] CHECK CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiodadAlive]
GO
ALTER TABLE [Process].[tblParentsOfGen1Current]  WITH CHECK ADD  CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiodadUSBorn] FOREIGN KEY([BiodadUSBorn])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblParentsOfGen1Current] CHECK CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiodadUSBorn]
GO
ALTER TABLE [Process].[tblParentsOfGen1Current]  WITH CHECK ADD  CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiograndfatherUSBorn] FOREIGN KEY([BiograndfatherUSBorn])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblParentsOfGen1Current] CHECK CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiograndfatherUSBorn]
GO
ALTER TABLE [Process].[tblParentsOfGen1Current]  WITH CHECK ADD  CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiomomAlive] FOREIGN KEY([BiomomAlive])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblParentsOfGen1Current] CHECK CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiomomAlive]
GO
ALTER TABLE [Process].[tblParentsOfGen1Current]  WITH CHECK ADD  CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiomomUSBorn] FOREIGN KEY([BiomomUSBorn])
REFERENCES [Enum].[tblLUYesNo] ([ID])
GO
ALTER TABLE [Process].[tblParentsOfGen1Current] CHECK CONSTRAINT [FK_tblParentsOfGen1Current_tblLUYesNo_BiomomUSBorn]
GO
ALTER TABLE [Process].[tblParentsOfGen1Current]  WITH CHECK ADD  CONSTRAINT [FK_tblParentsOfGen1Current_tblSubject] FOREIGN KEY([SubjectTag])
REFERENCES [Process].[tblSubject] ([SubjectTag])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblParentsOfGen1Current] CHECK CONSTRAINT [FK_tblParentsOfGen1Current_tblSubject]
GO
ALTER TABLE [Process].[tblParentsOfGen1Retro]  WITH CHECK ADD  CONSTRAINT [FK_tblParentsOfGen1Retro_tblSubject] FOREIGN KEY([SubjectTag])
REFERENCES [Process].[tblSubject] ([SubjectTag])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblParentsOfGen1Retro] CHECK CONSTRAINT [FK_tblParentsOfGen1Retro_tblSubject]
GO
ALTER TABLE [Process].[tblRelatedStructure]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedStructure_tblLURelationshipPath] FOREIGN KEY([RelationshipPath])
REFERENCES [Enum].[tblLURelationshipPath] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblRelatedStructure] CHECK CONSTRAINT [FK_tblRelatedStructure_tblLURelationshipPath]
GO
ALTER TABLE [Process].[tblRelatedStructure]  WITH NOCHECK ADD  CONSTRAINT [FK_tblRelatedStructure_tblSubject_Subject1] FOREIGN KEY([SubjectTag_S1])
REFERENCES [Process].[tblSubject] ([SubjectTag])
GO
ALTER TABLE [Process].[tblRelatedStructure] NOCHECK CONSTRAINT [FK_tblRelatedStructure_tblSubject_Subject1]
GO
ALTER TABLE [Process].[tblRelatedStructure]  WITH NOCHECK ADD  CONSTRAINT [FK_tblRelatedStructure_tblSubject_Subject2] FOREIGN KEY([SubjectTag_S2])
REFERENCES [Process].[tblSubject] ([SubjectTag])
GO
ALTER TABLE [Process].[tblRelatedStructure] NOCHECK CONSTRAINT [FK_tblRelatedStructure_tblSubject_Subject2]
GO
ALTER TABLE [Process].[tblRelatedValues]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValues_tblLUMultipleBirth] FOREIGN KEY([MultipleBirthIfSameSex])
REFERENCES [Enum].[tblLUMultipleBirth] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblRelatedValues] CHECK CONSTRAINT [FK_tblRelatedValues_tblLUMultipleBirth]
GO
ALTER TABLE [Process].[tblRelatedValues]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValues_tblLUTristate] FOREIGN KEY([IsMz])
REFERENCES [Enum].[tblLUTristate] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblRelatedValues] CHECK CONSTRAINT [FK_tblRelatedValues_tblLUTristate]
GO
ALTER TABLE [Process].[tblRelatedValues]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValues_tblLUTristate_ExplicitShareBiodadPass1] FOREIGN KEY([ExplicitShareBiodadPass1])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Process].[tblRelatedValues] CHECK CONSTRAINT [FK_tblRelatedValues_tblLUTristate_ExplicitShareBiodadPass1]
GO
ALTER TABLE [Process].[tblRelatedValues]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValues_tblLUTristate_ExplicitShareBiomomPass1] FOREIGN KEY([ExplicitShareBiomomPass1])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Process].[tblRelatedValues] CHECK CONSTRAINT [FK_tblRelatedValues_tblLUTristate_ExplicitShareBiomomPass1]
GO
ALTER TABLE [Process].[tblRelatedValues]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValues_tblLUTristate_ImplicitShareBiodadPass1] FOREIGN KEY([ImplicitShareBiodadPass1])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Process].[tblRelatedValues] CHECK CONSTRAINT [FK_tblRelatedValues_tblLUTristate_ImplicitShareBiodadPass1]
GO
ALTER TABLE [Process].[tblRelatedValues]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValues_tblLUTristate_ImplicitShareBiomomPass1] FOREIGN KEY([ImplicitShareBiomomPass1])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Process].[tblRelatedValues] CHECK CONSTRAINT [FK_tblRelatedValues_tblLUTristate_ImplicitShareBiomomPass1]
GO
ALTER TABLE [Process].[tblRelatedValues]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValues_tblRelatedStructure] FOREIGN KEY([ID])
REFERENCES [Process].[tblRelatedStructure] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblRelatedValues] CHECK CONSTRAINT [FK_tblRelatedValues_tblRelatedStructure]
GO
ALTER TABLE [Process].[tblResponse]  WITH CHECK ADD  CONSTRAINT [FK_tblResponse_tblItem_79] FOREIGN KEY([Item])
REFERENCES [Metadata].[tblItem] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblResponse] CHECK CONSTRAINT [FK_tblResponse_tblItem_79]
GO
ALTER TABLE [Process].[tblResponse]  WITH CHECK ADD  CONSTRAINT [FK_tblResponse_tblLUSurveySource] FOREIGN KEY([SurveySource])
REFERENCES [Enum].[tblLUSurveySource] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblResponse] CHECK CONSTRAINT [FK_tblResponse_tblLUSurveySource]
GO
ALTER TABLE [Process].[tblResponse]  WITH CHECK ADD  CONSTRAINT [FK_tblResponse_tblSubject] FOREIGN KEY([SubjectTag])
REFERENCES [Process].[tblSubject] ([SubjectTag])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblResponse] CHECK CONSTRAINT [FK_tblResponse_tblSubject]
GO
ALTER TABLE [Process].[tblRosterGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblRosterGen1_tblLURosterGen1Assignment] FOREIGN KEY([RosterAssignmentID])
REFERENCES [Metadata].[tblRosterGen1Assignment] ([ID])
GO
ALTER TABLE [Process].[tblRosterGen1] CHECK CONSTRAINT [FK_tblRosterGen1_tblLURosterGen1Assignment]
GO
ALTER TABLE [Process].[tblRosterGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblRosterGen1_tblLUTristate] FOREIGN KEY([SameGeneration])
REFERENCES [Enum].[tblLUTristate] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblRosterGen1] CHECK CONSTRAINT [FK_tblRosterGen1_tblLUTristate]
GO
ALTER TABLE [Process].[tblRosterGen1]  WITH CHECK ADD  CONSTRAINT [FK_tblRosterGen1_tblRelatedStructure] FOREIGN KEY([RelatedID])
REFERENCES [Process].[tblRelatedStructure] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblRosterGen1] CHECK CONSTRAINT [FK_tblRosterGen1_tblRelatedStructure]
GO
ALTER TABLE [Process].[tblSubject]  WITH NOCHECK ADD  CONSTRAINT [FK_tblSubject_tblLUGender] FOREIGN KEY([Gender])
REFERENCES [Enum].[tblLUGender] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [Process].[tblSubject] CHECK CONSTRAINT [FK_tblSubject_tblLUGender]
GO
ALTER TABLE [Process].[tblSubjectDetails]  WITH CHECK ADD  CONSTRAINT [FK_tblSubjectDetails_tblLURaceCohort] FOREIGN KEY([RaceCohort])
REFERENCES [Enum].[tblLURaceCohort] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblSubjectDetails] CHECK CONSTRAINT [FK_tblSubjectDetails_tblLURaceCohort]
GO
ALTER TABLE [Process].[tblSurveyTime]  WITH CHECK ADD  CONSTRAINT [FK_tblSurveyTime_tblLUSurveySource] FOREIGN KEY([SurveySource])
REFERENCES [Enum].[tblLUSurveySource] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblSurveyTime] CHECK CONSTRAINT [FK_tblSurveyTime_tblLUSurveySource]
GO
ALTER TABLE [Process].[tblSurveyTime]  WITH CHECK ADD  CONSTRAINT [FK_tblSurveyTime_tblSubject] FOREIGN KEY([SubjectTag])
REFERENCES [Process].[tblSubject] ([SubjectTag])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Process].[tblSurveyTime] CHECK CONSTRAINT [FK_tblSurveyTime_tblSubject]
GO
ALTER TABLE [Metadata].[tblMzManual]  WITH CHECK ADD  CONSTRAINT [CK_tblMzManual_Ordered] CHECK  (([SubjectTag_S1]<[SubjectTag_S2]))
GO
ALTER TABLE [Metadata].[tblMzManual] CHECK CONSTRAINT [CK_tblMzManual_Ordered]
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment]  WITH CHECK ADD  CONSTRAINT [CK_tblLURosterGen1Assignment_R] CHECK  (([R] IS NULL OR (0)<=[R] AND [R]<=(1)))
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment] CHECK CONSTRAINT [CK_tblLURosterGen1Assignment_R]
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment]  WITH CHECK ADD  CONSTRAINT [CK_tblLURosterGen1Assignment_RBoundLower] CHECK  (((0)<=[RBoundLower] AND [RBoundLower]<=(0.5)))
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment] CHECK CONSTRAINT [CK_tblLURosterGen1Assignment_RBoundLower]
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment]  WITH CHECK ADD  CONSTRAINT [CK_tblLURosterGen1Assignment_RBoundUpper] CHECK  (((0)<=[RBoundUpper] AND [RBoundUpper]<=(1)))
GO
ALTER TABLE [Metadata].[tblRosterGen1Assignment] CHECK CONSTRAINT [CK_tblLURosterGen1Assignment_RBoundUpper]
GO
ALTER TABLE [Metadata].[tblVariable]  WITH CHECK ADD  CONSTRAINT [CK_tblVariable_79_Generation] CHECK  (([Generation]=(2) OR [Generation]=(1)))
GO
ALTER TABLE [Metadata].[tblVariable] CHECK CONSTRAINT [CK_tblVariable_79_Generation]
GO
ALTER TABLE [Metadata].[tblVariable]  WITH CHECK ADD  CONSTRAINT [CK_tblVariable_79_SurveyYear] CHECK  (((0)<=[SurveyYear] AND [SurveyYear]<=(2030)))
GO
ALTER TABLE [Metadata].[tblVariable] CHECK CONSTRAINT [CK_tblVariable_79_SurveyYear]
GO
ALTER TABLE [Metadata].[tblVariable]  WITH CHECK ADD  CONSTRAINT [CK_tblVariable_79_VariableCodeLength] CHECK  ((len([VariableCode])=(8)))
GO
ALTER TABLE [Metadata].[tblVariable] CHECK CONSTRAINT [CK_tblVariable_79_VariableCodeLength]
GO
ALTER TABLE [Process].[tblParentsOfGen1Current]  WITH CHECK ADD  CONSTRAINT [CK_tblParentsOfGen1Current_BiodadHighestGrade] CHECK  (((0)<=[BiodadHighestGrade] AND [BiodadHighestGrade]<=(20)))
GO
ALTER TABLE [Process].[tblParentsOfGen1Current] CHECK CONSTRAINT [CK_tblParentsOfGen1Current_BiodadHighestGrade]
GO
ALTER TABLE [Process].[tblParentsOfGen1Current]  WITH CHECK ADD  CONSTRAINT [CK_tblParentsOfGen1Current_BiomomHighestGrade] CHECK  (((0)<=[BiomomHighestGrade] AND [BiomomHighestGrade]<=(20)))
GO
ALTER TABLE [Process].[tblParentsOfGen1Current] CHECK CONSTRAINT [CK_tblParentsOfGen1Current_BiomomHighestGrade]
GO
ALTER TABLE [Process].[tblResponse]  WITH CHECK ADD  CONSTRAINT [CK_tblResponse_SurveyYear] CHECK  (((0)<=[SurveyYear] AND [SurveyYear]<=(2016)))
GO
ALTER TABLE [Process].[tblResponse] CHECK CONSTRAINT [CK_tblResponse_SurveyYear]
GO
ALTER TABLE [Process].[tblRosterGen1]  WITH CHECK ADD  CONSTRAINT [CK_tblRosterGen1_R] CHECK  (((0)<=[R] AND [R]<=(1) OR [R] IS NULL))
GO
ALTER TABLE [Process].[tblRosterGen1] CHECK CONSTRAINT [CK_tblRosterGen1_R]
GO
ALTER TABLE [Process].[tblRosterGen1]  WITH CHECK ADD  CONSTRAINT [CK_tblRosterGen1_RBoundLower] CHECK  (((0)<=[RBoundLower] AND [RBoundLower]<=(1)))
GO
ALTER TABLE [Process].[tblRosterGen1] CHECK CONSTRAINT [CK_tblRosterGen1_RBoundLower]
GO
ALTER TABLE [Process].[tblRosterGen1]  WITH CHECK ADD  CONSTRAINT [CK_tblRosterGen1_RBoundUpper] CHECK  (((0)<=[RBoundUpper] AND [RBoundUpper]<=(1)))
GO
ALTER TABLE [Process].[tblRosterGen1] CHECK CONSTRAINT [CK_tblRosterGen1_RBoundUpper]
GO
ALTER TABLE [Process].[tblSubjectDetails]  WITH CHECK ADD  CONSTRAINT [CK_tblSubjectDetails_AgeAtLastSurvey] CHECK  (([AgeAtLastSurvey]>=(0)))
GO
ALTER TABLE [Process].[tblSubjectDetails] CHECK CONSTRAINT [CK_tblSubjectDetails_AgeAtLastSurvey]
GO
ALTER TABLE [Process].[tblSubjectDetails]  WITH CHECK ADD  CONSTRAINT [CK_tblSubjectDetails_BirthOrderInNls] CHECK  (((1)<=[BirthOrderInNls] AND [BirthOrderInNls]<=(14)))
GO
ALTER TABLE [Process].[tblSubjectDetails] CHECK CONSTRAINT [CK_tblSubjectDetails_BirthOrderInNls]
GO
ALTER TABLE [Process].[tblSubjectDetails]  WITH CHECK ADD  CONSTRAINT [CK_tblSubjectDetails_KidCountBio] CHECK  (((0)<=[KidCountBio] AND [KidCountBio]<=(11)))
GO
ALTER TABLE [Process].[tblSubjectDetails] CHECK CONSTRAINT [CK_tblSubjectDetails_KidCountBio]
GO
ALTER TABLE [Process].[tblSubjectDetails]  WITH CHECK ADD  CONSTRAINT [CK_tblSubjectDetails_LastSurveyYear] CHECK  (((1979)<=[LastSurveyYearCompleted] AND [LastSurveyYearCompleted]<=(2016)))
GO
ALTER TABLE [Process].[tblSubjectDetails] CHECK CONSTRAINT [CK_tblSubjectDetails_LastSurveyYear]
GO
ALTER TABLE [Process].[tblSubjectDetails]  WITH CHECK ADD  CONSTRAINT [CK_tblSubjectDetails_Mob] CHECK  (('1/1/1955'<=[Mob]))
GO
ALTER TABLE [Process].[tblSubjectDetails] CHECK CONSTRAINT [CK_tblSubjectDetails_Mob]
GO
ALTER TABLE [Process].[tblSubjectDetails]  WITH CHECK ADD  CONSTRAINT [CK_tblSubjectDetails_SiblingCountInNls] CHECK  (((0)<=[SiblingCountInNls] AND [SiblingCountInNls]<=(13)))
GO
ALTER TABLE [Process].[tblSubjectDetails] CHECK CONSTRAINT [CK_tblSubjectDetails_SiblingCountInNls]
GO
ALTER TABLE [Process].[tblSurveyTime]  WITH CHECK ADD  CONSTRAINT [CK_tblSurveyTime_AgeCalculateYears] CHECK  (((0)<=[AgeCalculateYears] AND [AgeCalculateYears]<=(70)))
GO
ALTER TABLE [Process].[tblSurveyTime] CHECK CONSTRAINT [CK_tblSurveyTime_AgeCalculateYears]
GO
ALTER TABLE [Process].[tblSurveyTime]  WITH CHECK ADD  CONSTRAINT [CK_tblSurveyTime_AgeSelfReportYears] CHECK  (((0)<=[AgeSelfReportYears] AND [AgeSelfReportYears]<=(70)))
GO
ALTER TABLE [Process].[tblSurveyTime] CHECK CONSTRAINT [CK_tblSurveyTime_AgeSelfReportYears]
GO
ALTER TABLE [Process].[tblSurveyTime]  WITH CHECK ADD  CONSTRAINT [CK_tblSurveyTime_SurveyYear] CHECK  (((0)<=[SurveyYear] AND [SurveyYear]<=(2016)))
GO
ALTER TABLE [Process].[tblSurveyTime] CHECK CONSTRAINT [CK_tblSurveyTime_SurveyYear]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Name
-- Create date: 
-- Description:	
-- =============================================
CREATE PROCEDURE [Process].[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 Archive.[tblRelatedValuesArchive]

END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [Process].[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 (                                                                                             --Outcomes
	200,201,203,                                                                                           --Gen1HeightInches, Gen1WeightPounds, Gen1AfqtScaled3Decimals
	500,501,502,503,                                                                                       --Gen2HeightInchesTotal, Gen2HeightFeetOnly, Gen2HeightInchesRemainder, Gen2HeightInchesTotalMotherSupplement
	504,512,513,                                                                                           --Gen2WeightPoundsYA, Gen2PiatMathPercentile, Gen2PiatMathStandard
	122                                                                                                    --Gen2CFatherAlive
  )                

END
GO
USE [master]
GO
ALTER DATABASE [NlsyLinks79] SET  READ_WRITE 
GO