DimProgramRetentionCohortLoad
 Lookup AgeRangeAtTerm using AgeAtTerm (Component)
Home  Diagrams  Documents  Images  DimProgramRetentionCohortLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  DimProgramRetentionCohortLoad   DFT Load Temp Program Retention Cohort Tables for Verification   Lookup AgeRangeAtTerm using AgeAtTerm
  Properties
Property Value
Name Lookup AgeRangeAtTerm using AgeAtTerm
Description Looks up values in a reference dataset by using exact matching.
Up Stream Components
Down Stream Components
ID 1838
Component Class ID {27648839-180F-45E6-838D-AFF53DF682D2}
Contact Info Lookup;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;5
Identification String component "Lookup AgeRangeAtTerm using AgeAtTerm" (1838)
Is Default Locale False
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 5
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
CacheType
0
ConnectionType
0
DefaultCodePage
1252
MaxMemoryUsage
25
MaxMemoryUsage64
25
NoMatchBehavior
1
NoMatchCachePercentage
0
ParameterMap
#1901;
ReferenceMetadataXml
<referenceMetadata><referenceColumns><referenceColumn name="AgeAtTerm" dataType="DT_I2" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="AgeRangeAtTerm" dataType="DT_STR" length="7" precision="0" scale="0" codePage="1252"/></referenceColumns></referenceMetadata>
SqlCommand
SELECT        CAST(0 AS smallint) AS AgeAtTerm, 'N/A' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(1 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(2 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(3 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(4 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(5 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(6 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(7 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(8 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(9 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(10 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(11 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(12 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(13 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(14 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(15 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(16 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(17 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(18 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(19 AS smallint) AS AgeAtTerm, '19 - 21' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(20 AS smallint) AS AgeAtTerm, '19 - 21' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(21 AS smallint) AS AgeAtTerm, '19 - 21' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(22 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(23 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(24 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(25 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(26 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(27 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(28 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(29 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(30 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(31 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(32 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(33 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(34 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(35 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(36 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(37 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(38 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(39 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(40 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(41 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(42 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(43 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(44 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(45 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(46 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(47 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(48 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(49 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(50 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(51 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(52 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(53 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(54 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(55 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(56 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(57 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(58 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(59 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(60 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(61 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(62 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(63 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(64 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(65 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(66 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(67 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(68 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(69 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(70 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(71 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(72 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(73 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(74 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(75 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(76 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(77 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(78 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(79 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(80 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(81 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(82 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(83 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(84 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(85 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(86 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(87 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(88 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(89 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(90 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(91 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(92 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(93 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(94 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(95 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(96 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(97 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(98 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(99 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(100 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(101 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(102 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(103 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(104 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(105 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(106 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(107 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(108 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(109 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(110 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(111 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(112 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(113 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(114 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(115 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(116 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(117 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(118 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(119 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
UNION ALL
SELECT        CAST(120 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm
SqlCommandParam
select * from (SELECT CAST(0 AS smallint) AS AgeAtTerm, 'N/A' AS AgeRangeAtTerm UNION ALL SELECT CAST(1 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(2 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(3 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(4 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(5 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(6 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(7 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(8 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(9 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(10 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(11 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(12 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(13 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(14 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(15 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(16 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(17 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(18 AS smallint) AS AgeAtTerm, '< 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(19 AS smallint) AS AgeAtTerm, '19 - 21' AS AgeRangeAtTerm UNION ALL SELECT CAST(20 AS smallint) AS AgeAtTerm, '19 - 21' AS AgeRangeAtTerm UNION ALL SELECT CAST(21 AS smallint) AS AgeAtTerm, '19 - 21' AS AgeRangeAtTerm UNION ALL SELECT CAST(22 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(23 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(24 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(25 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(26 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(27 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(28 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(29 AS smallint) AS AgeAtTerm, '22 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(30 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(31 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(32 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(33 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(34 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(35 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(36 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(37 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(38 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(39 AS smallint) AS AgeAtTerm, '30 - 39' AS AgeRangeAtTerm UNION ALL SELECT CAST(40 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(41 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(42 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(43 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(44 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(45 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(46 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(47 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(48 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(49 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(50 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(51 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(52 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(53 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(54 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(55 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(56 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(57 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(58 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(59 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(60 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(61 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(62 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(63 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(64 AS smallint) AS AgeAtTerm, '40 - 64' AS AgeRangeAtTerm UNION ALL SELECT CAST(65 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(66 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(67 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(68 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(69 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(70 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(71 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(72 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(73 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(74 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(75 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(76 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(77 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(78 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(79 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(80 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(81 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(82 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(83 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(84 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(85 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(86 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(87 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(88 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(89 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(90 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(91 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(92 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(93 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(94 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(95 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(96 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(97 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(98 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(99 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(100 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(101 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(102 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(103 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(104 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(105 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(106 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(107 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(108 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(109 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(110 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(111 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(112 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(113 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(114 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(115 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(116 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(117 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(118 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(119 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm UNION ALL SELECT CAST(120 AS smallint) AS AgeAtTerm, 'Other' AS AgeRangeAtTerm) [refTable] where [refTable].[AgeAtTerm] = ?
  Input Columns
Name ID LineageID
AgeAtProgramRetentionCohort
1930
1901
AgeRangeAtTerm
1935
1904
  Output Columns
Name ID LineageID
ErrorCode
1861
1861
ErrorColumn
1862
1862
Powered by BI Documenter