API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 6th, 2015
163
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.98 KB | None | 0 0
raw download clone embed print report
  1. SELECT DISTINCT FW.FORMS.EPISODE_ID,
  2. DM_A_PERSONS.PERSON_ID AS ClientReference,
  3. dt_assDate.DATE_ANSWER,
  4. faceib.TEXT_ANSWER AS FaceIB,
  5. "DT_4.1".TEXT_ANSWER AS ib1,
  6. "DT_4.2".TEXT_ANSWER AS ib2,
  7. "DT_4.3".TEXT_ANSWER AS ib3,
  8. "DT_4.4".TEXT_ANSWER AS ib4,
  9. "DT_4.5".TEXT_ANSWER AS ib5,
  10. "DT_4.6".TEXT_ANSWER AS ib6,
  11. "DT_4.7".TEXT_ANSWER AS ib7,
  12. dt_5.TEXT_ANSWER AS "Agreed_ Personal_ Budget",
  13. dt_6.TEXT_ANSWER AS Primary_Reason_for_Variation,
  14. dt_7.TEXT_ANSWER AS Age_Band,
  15. dt_8.LOOKUP_CODE AS Health_Condition_1,
  16. dt_9.LOOKUP_CODE AS Health_Condition_2,
  17. dt_10.LOOKUP_CODE AS Eating_And_Drinking,
  18. dt_11.LOOKUP_CODE AS Dressing,
  19. dt_12.LOOKUP_CODE AS Undressing,
  20. Dt_13.Lookup_Code As Personal_Appearance,
  21. Dt_14.Lookup_Code As Washing_Whole_Body,
  22. Dt_15.Text_Answer As Washing_Whole_Body_How_Often,
  23. Dt_16.Lookup_Code As Toilet,
  24. Dt_17.Text_Answer As Toilet_How_Often,
  25. Dt_18.Lookup_Code As Transfers,
  26. Dt_19.Lookup_Code As Medication,
  27. Dt_20.Text_Answer As Medication_How_Often,
  28. Dt_21.Lookup_Code As Meals_Snacks,
  29. Dt_22.Text_Answer As Meals_Snacks_How_Often,
  30. Dt_23.Lookup_Code As Housework,
  31. Dt_24.Lookup_Code As Household_Shopping,
  32. Dt_25.Text_Answer As Dependants,
  33. Dt_26.Lookup_Code As Paperwork,
  34. Dt_27.Lookup_Code As Social,
  35. Dt_28.Lookup_Code As Social_Support_Needed,
  36. Dt_29.Lookup_Code As Anticipated_Living_Situation,
  37. Dt_30.Lookup_Code As Support_Living_Number,
  38. Dt_30.Lookup_Code,
  39. dt_31.Lookup_Code,
  40. dt_32.Lookup_Code,
  41. dt_33.Lookup_Code,
  42. dt_34.Lookup_Code,
  43. dt_35.Lookup_Code,
  44. dt_36.Lookup_Code,
  45. dt_37.Lookup_Code,
  46. dt_38.Lookup_Code,
  47. dt_39.Lookup_Code,
  48. dt_40.Lookup_Code,
  49. dt_41.Lookup_Code,
  50. dt_42.Lookup_Code,
  51. dt_43.Lookup_Code,
  52. dt_44.Lookup_Code,
  53. dt_45.Lookup_Code,
  54. dt_46.Lookup_Code,
  55. dt_47.Lookup_Code,
  56. dt_48.Lookup_Code,
  57. dt_49.Lookup_Code,
  58. dt_50.Lookup_Code,
  59. dt_51.Lookup_Code,
  60. dt_52.Lookup_Code,
  61. dt_53.Lookup_Code,
  62. dt_54.Lookup_Code,
  63. dt_55.Lookup_Code,
  64. dt_56.Lookup_Code,
  65. dt_57.Lookup_Code,
  66. dt_58.Lookup_Code,
  67. dt_59.Lookup_Code,
  68. dt_60.Lookup_Code
  69.  
  70. FROM DM_A_PERSONS
  71. INNER JOIN FW.FORMS
  72. ON DM_A_PERSONS.PERSON_ID = FW.FORMS.PERSON_ID
  73. INNER JOIN FW.DM_A_EPISODES
  74. ON FW.FORMS.PERSON_ID = FW.DM_A_EPISODES.PERSON_ID
  75. LEFT JOIN
  76. (SELECT FW.REPORT_FORM_ANSWERS.TEXT_ANSWER,
  77. FW.REPORT_FORM_ANSWERS.FORM_ID,
  78. FW.REPORT_FORM_ANSWERS.FORM_TYPE_ID_CODE
  79. FROM FW.REPORT_FORM_ANSWERS
  80. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'faceib'
  81. ) faceib
  82. ON faceib.FORM_ID = FW.FORMS.ID
  83. LEFT JOIN
  84. (SELECT FW.REPORT_FORM_ANSWERS.DATE_ANSWER,
  85. FW.REPORT_FORM_ANSWERS.LOOKUP_CODE,
  86. FW.REPORT_FORM_ANSWERS.FORM_ID
  87. FROM FW.REPORT_FORM_ANSWERS
  88. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'supa100'
  89. ) dt_assDate
  90. ON FW.FORMS.ID = dt_assDate.FORM_ID
  91. LEFT JOIN
  92. (SELECT FW.REPORT_FORM_ANSWERS.FORM_ID,
  93. FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  94. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  95. FROM FW.REPORT_FORM_ANSWERS
  96. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'ib1'
  97. ) "DT_4.1"
  98. ON FW.FORMS.ID = "DT_4.1".FORM_ID
  99. LEFT JOIN
  100. (SELECT FW.REPORT_FORM_ANSWERS.FORM_ID,
  101. FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  102. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  103. FROM FW.REPORT_FORM_ANSWERS
  104. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'ib2'
  105. ) "DT_4.2"
  106. ON FW.FORMS.ID = "DT_4.2".FORM_ID
  107. LEFT JOIN
  108. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  109. FW.REPORT_FORM_ANSWERS.FORM_ID,
  110. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  111. FROM FW.REPORT_FORM_ANSWERS
  112. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'ib3'
  113. ) "DT_4.3"
  114. ON FW.FORMS.ID = "DT_4.3".FORM_ID
  115. LEFT JOIN
  116. (SELECT FW.REPORT_FORM_ANSWERS.FORM_ID,
  117. FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  118. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  119. FROM FW.REPORT_FORM_ANSWERS
  120. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'ib4'
  121. ) "DT_4.4"
  122. ON FW.FORMS.ID = "DT_4.4".FORM_ID
  123. LEFT JOIN
  124. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  125. FW.REPORT_FORM_ANSWERS.FORM_ID,
  126. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  127. FROM FW.REPORT_FORM_ANSWERS
  128. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'ib5'
  129. ) "DT_4.5"
  130. ON "DT_4.5".FORM_ID = FW.FORMS.ID
  131. LEFT JOIN
  132. (SELECT FW.REPORT_FORM_ANSWERS.FORM_ID,
  133. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER,
  134. FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID
  135. FROM FW.REPORT_FORM_ANSWERS
  136. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'ib7'
  137. ) "DT_4.7"
  138. ON FW.FORMS.ID = "DT_4.7".FORM_ID
  139. LEFT JOIN
  140. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  141. FW.REPORT_FORM_ANSWERS.FORM_ID,
  142. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  143. FROM FW.REPORT_FORM_ANSWERS
  144. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'ib6'
  145. ) "DT_4.6"
  146. ON "DT_4.6".FORM_ID = FW.FORMS.ID
  147. LEFT JOIN
  148. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  149. FW.REPORT_FORM_ANSWERS.FORM_ID,
  150. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  151. FROM FW.REPORT_FORM_ANSWERS
  152. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'supa25'
  153. ) dt_5
  154. ON dt_5.FORM_ID = FW.FORMS.ID
  155. LEFT JOIN
  156. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  157. FW.REPORT_FORM_ANSWERS.FORM_ID,
  158. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  159. FROM FW.REPORT_FORM_ANSWERS
  160. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'ib9'
  161. ) dt_6
  162. ON FW.FORMS.ID = dt_6.FORM_ID
  163. LEFT JOIN
  164. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  165. FW.REPORT_FORM_ANSWERS.FORM_ID,
  166. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  167. FROM FW.REPORT_FORM_ANSWERS
  168. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'SA.070'
  169. ) dt_7
  170. ON FW.FORMS.ID = dt_7.FORM_ID
  171. LEFT JOIN
  172. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  173. FW.REPORT_FORM_ANSWERS.LOOKUP_CODE,
  174. FW.REPORT_FORM_ANSWERS.FORM_ID
  175. FROM FW.REPORT_FORM_ANSWERS
  176. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'SA.007'
  177. ) dt_8
  178. ON FW.FORMS.ID = dt_8.FORM_ID
  179. LEFT JOIN
  180. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  181. FW.REPORT_FORM_ANSWERS.FORM_ID,
  182. FW.REPORT_FORM_ANSWERS.LOOKUP_CODE
  183. FROM FW.REPORT_FORM_ANSWERS
  184. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'sa.008'
  185. ) dt_9
  186. ON FW.FORMS.ID = dt_9.FORM_ID
  187. LEFT JOIN
  188. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  189. FW.REPORT_FORM_ANSWERS.FORM_ID,
  190. FW.REPORT_FORM_ANSWERS.LOOKUP_CODE
  191. FROM FW.REPORT_FORM_ANSWERS
  192. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'SA.009'
  193. ) dt_10
  194. ON FW.FORMS.ID = dt_10.FORM_ID
  195. LEFT JOIN
  196. (SELECT FW.REPORT_FORM_ANSWERS.FORM_ID,
  197. FW.REPORT_FORM_ANSWERS.LOOKUP_CODE,
  198. FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID
  199. FROM FW.REPORT_FORM_ANSWERS
  200. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'SA.010'
  201. ) dt_11
  202. ON FW.FORMS.ID = dt_11.FORM_ID
  203. LEFT JOIN
  204. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  205. FW.REPORT_FORM_ANSWERS.FORM_ID,
  206. FW.REPORT_FORM_ANSWERS.LOOKUP_CODE
  207. FROM FW.REPORT_FORM_ANSWERS
  208. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'SA.063'
  209. ) dt_12
  210. ON FW.FORMS.ID = dt_12.FORM_ID
  211. LEFT JOIN
  212. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  213. FW.REPORT_FORM_ANSWERS.FORM_ID,
  214. FW.REPORT_FORM_ANSWERS.LOOKUP_CODE
  215. FROM FW.REPORT_FORM_ANSWERS
  216. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'SA.063'
  217. ) dt_13
  218. ON FW.FORMS.ID = dt_13.FORM_ID
  219. LEFT JOIN
  220. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  221. FW.REPORT_FORM_ANSWERS.FORM_ID,
  222. FW.REPORT_FORM_ANSWERS.LOOKUP_CODE
  223. FROM FW.REPORT_FORM_ANSWERS
  224. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'SA.013'
  225. ) dt_14
  226. ON FW.FORMS.ID = dt_14.FORM_ID
  227. LEFT JOIN
  228. (SELECT FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID,
  229. FW.REPORT_FORM_ANSWERS.FORM_ID,
  230. FW.REPORT_FORM_ANSWERS.TEXT_ANSWER
  231. FROM FW.REPORT_FORM_ANSWERS
  232. WHERE FW.REPORT_FORM_ANSWERS.SECTION_ITEM_TAG_ID = 'SA.029'
  233. ) dt_15
  234. ON FW.FORMS.ID = dt_15.FORM_ID
  235. LEFT JOIN
  236. (SELECT Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID,
  237. Fw.Report_Form_Answers.FORM_ID,
  238. Fw.Report_Form_Answers.LOOKUP_CODE
  239. FROM Fw.Report_Form_Answers
  240. WHERE Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID = 'SA.014'
  241. ) dt_16
  242. ON FW.FORMS.ID = dt_16.FORM_ID
  243. LEFT JOIN
  244. (SELECT Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID,
  245. Fw.Report_Form_Answers.FORM_ID,
  246. Fw.Report_Form_Answers.TEXT_ANSWER
  247. FROM Fw.Report_Form_Answers
  248. WHERE Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID = 'SA.030'
  249. ) dt_17
  250. ON FW.FORMS.ID = dt_17.FORM_ID
  251. LEFT JOIN
  252. (SELECT Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID,
  253. Fw.Report_Form_Answers.FORM_ID,
  254. Fw.Report_Form_Answers.LOOKUP_CODE
  255. FROM Fw.Report_Form_Answers
  256. WHERE Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID = 'SA.024'
  257. ) dt_18
  258. ON FW.FORMS.ID = dt_18.FORM_ID
  259. LEFT JOIN
  260. (SELECT Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID,
  261. Fw.Report_Form_Answers.FORM_ID,
  262. Fw.Report_Form_Answers.LOOKUP_CODE
  263. From Fw.Report_Form_Answers
  264. WHERE Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID = 'SA.016'
  265. ) dt_19
  266. ON FW.FORMS.ID = dt_19.FORM_ID
  267. LEFT JOIN
  268. (SELECT Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID,
  269. Fw.Report_Form_Answers.FORM_ID,
  270. Fw.Report_Form_Answers.TEXT_ANSWER
  271. FROM Fw.Report_Form_Answers
  272. WHERE Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID = 'SA.032'
  273. ) dt_20
  274. ON FW.FORMS.ID = dt_20.FORM_ID
  275. LEFT JOIN
  276. (SELECT Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID,
  277. Fw.Report_Form_Answers.FORM_ID,
  278. Fw.Report_Form_Answers.LOOKUP_CODE
  279. FROM Fw.Report_Form_Answers
  280. WHERE Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID = 'SA.017'
  281. ) dt_21
  282. ON FW.FORMS.ID = dt_21.FORM_ID
  283. LEFT JOIN
  284. (SELECT Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID,
  285. Fw.Report_Form_Answers.FORM_ID,
  286. Fw.Report_Form_Answers.TEXT_ANSWER
  287. FROM Fw.Report_Form_Answers
  288. WHERE Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID = 'SA.018'
  289. ) dt_22
  290. ON FW.FORMS.ID = dt_22.FORM_ID
  291. LEFT JOIN
  292. (SELECT Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID,
  293. Fw.Report_Form_Answers.FORM_ID,
  294. Fw.Report_Form_Answers.LOOKUP_CODE
  295. FROM Fw.Report_Form_Answers
  296. WHERE Fw.Report_Form_Answers.SECTION_ITEM_TAG_ID = 'SA.019'
  297. ) dt_23
  298. ON FW.FORMS.ID = dt_23.FORM_ID
  299. LEFT JOIN
  300. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  301. Fw.Report_Form_Answers.FORM_ID,
  302. Fw.Report_Form_Answers.LOOKUP_CODE
  303. From Fw.Report_Form_Answers
  304. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.021'
  305. ) dt_24
  306. ON FW.FORMS.ID = dt_24.FORM_ID
  307.  
  308. LEFT JOIN
  309. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  310. Fw.Report_Form_Answers.FORM_ID,
  311. Fw.Report_Form_Answers.Lookup_Code,
  312. Fw.Report_Form_Answers.TEXT_ANSWER
  313. From Fw.Report_Form_Answers
  314. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.064'
  315. ) dt_25
  316. ON FW.FORMS.ID = dt_25.FORM_ID
  317.  
  318. LEFT JOIN
  319. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  320. Fw.Report_Form_Answers.FORM_ID,
  321. Fw.Report_Form_Answers.Lookup_Code,
  322. Fw.Report_Form_Answers.TEXT_ANSWER
  323. From Fw.Report_Form_Answers
  324. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.022'
  325. ) dt_26
  326. ON FW.FORMS.ID = dt_26.FORM_ID
  327.  
  328. LEFT JOIN
  329. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  330. Fw.Report_Form_Answers.FORM_ID,
  331. Fw.Report_Form_Answers.Lookup_Code,
  332. Fw.Report_Form_Answers.TEXT_ANSWER
  333. From Fw.Report_Form_Answers
  334. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.041'
  335. ) dt_27
  336. ON FW.FORMS.ID = dt_27.FORM_ID
  337.  
  338. LEFT JOIN
  339. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  340. Fw.Report_Form_Answers.FORM_ID,
  341. Fw.Report_Form_Answers.Lookup_Code,
  342. Fw.Report_Form_Answers.TEXT_ANSWER
  343. From Fw.Report_Form_Answers
  344. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.042'
  345. ) dt_28
  346. ON FW.FORMS.ID = dt_28.FORM_ID
  347.  
  348.  
  349. LEFT JOIN
  350. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  351. Fw.Report_Form_Answers.FORM_ID,
  352. Fw.Report_Form_Answers.Lookup_Code,
  353. Fw.Report_Form_Answers.TEXT_ANSWER
  354. From Fw.Report_Form_Answers
  355. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.061'
  356. ) dt_29
  357. ON FW.FORMS.ID = dt_29.FORM_ID
  358.  
  359.  
  360. Left Join
  361. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  362. Fw.Report_Form_Answers.FORM_ID,
  363. Fw.Report_Form_Answers.Lookup_Code,
  364. Fw.Report_Form_Answers.TEXT_ANSWER
  365. From Fw.Report_Form_Answers
  366. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.081'
  367. ) dt_30
  368. ON FW.FORMS.ID = dt_30.FORM_ID
  369.  
  370. Left Join
  371. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  372. Fw.Report_Form_Answers.FORM_ID,
  373. Fw.Report_Form_Answers.Lookup_Code,
  374. Fw.Report_Form_Answers.Text_Answer
  375. From Fw.Report_Form_Answers
  376. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.065'
  377. ) Dt_31
  378. ON FW.FORMS.ID = dt_31.FORM_ID
  379.  
  380.  
  381. Left Join
  382. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  383. Fw.Report_Form_Answers.FORM_ID,
  384. Fw.Report_Form_Answers.Lookup_Code,
  385. Fw.Report_Form_Answers.Text_Answer
  386. From Fw.Report_Form_Answers
  387. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.066'
  388. ) Dt_32
  389. ON FW.FORMS.ID = dt_32.FORM_ID
  390.  
  391.  
  392. Left Join
  393. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  394. Fw.Report_Form_Answers.FORM_ID,
  395. Fw.Report_Form_Answers.Lookup_Code,
  396. Fw.Report_Form_Answers.Text_Answer
  397. From Fw.Report_Form_Answers
  398. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.067'
  399. ) Dt_33
  400. ON FW.FORMS.ID = dt_33.FORM_ID
  401.  
  402.  
  403. Left Join
  404. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  405. Fw.Report_Form_Answers.FORM_ID,
  406. Fw.Report_Form_Answers.Lookup_Code,
  407. Fw.Report_Form_Answers.Text_Answer
  408. From Fw.Report_Form_Answers
  409. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.068'
  410. ) Dt_34
  411. ON FW.FORMS.ID = dt_34.FORM_ID
  412.  
  413.  
  414. Left Join
  415. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  416. Fw.Report_Form_Answers.FORM_ID,
  417. Fw.Report_Form_Answers.Lookup_Code,
  418. Fw.Report_Form_Answers.Text_Answer
  419. From Fw.Report_Form_Answers
  420. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.048'
  421. ) Dt_35
  422. ON FW.FORMS.ID = dt_35.FORM_ID
  423.  
  424.  
  425. Left Join
  426. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  427. Fw.Report_Form_Answers.FORM_ID,
  428. Fw.Report_Form_Answers.Lookup_Code,
  429. Fw.Report_Form_Answers.Text_Answer
  430. From Fw.Report_Form_Answers
  431. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.049'
  432. ) Dt_36
  433. ON FW.FORMS.ID = dt_36.FORM_ID
  434.  
  435.  
  436. Left Join
  437. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  438. Fw.Report_Form_Answers.FORM_ID,
  439. Fw.Report_Form_Answers.Lookup_Code,
  440. Fw.Report_Form_Answers.Text_Answer
  441. From Fw.Report_Form_Answers
  442. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.004'
  443. ) Dt_37
  444. ON FW.FORMS.ID = dt_37.FORM_ID
  445.  
  446. Left Join
  447. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  448. Fw.Report_Form_Answers.FORM_ID,
  449. Fw.Report_Form_Answers.Lookup_Code,
  450. Fw.Report_Form_Answers.Text_Answer
  451. From Fw.Report_Form_Answers
  452. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.071'
  453. ) Dt_38
  454. ON FW.FORMS.ID = dt_38.FORM_ID
  455.  
  456.  
  457. Left Join
  458. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  459. Fw.Report_Form_Answers.FORM_ID,
  460. Fw.Report_Form_Answers.Lookup_Code,
  461. Fw.Report_Form_Answers.Text_Answer
  462. From Fw.Report_Form_Answers
  463. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.051'
  464. ) Dt_39
  465. On Fw.Forms.Id = Dt_39.Form_Id
  466.  
  467. Left Join
  468. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  469. Fw.Report_Form_Answers.FORM_ID,
  470. Fw.Report_Form_Answers.Lookup_Code,
  471. Fw.Report_Form_Answers.Text_Answer
  472. From Fw.Report_Form_Answers
  473. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.052'
  474. ) Dt_40
  475. On Fw.Forms.Id = Dt_40.Form_Id
  476.  
  477. Left Join
  478. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  479. Fw.Report_Form_Answers.FORM_ID,
  480. Fw.Report_Form_Answers.Lookup_Code,
  481. Fw.Report_Form_Answers.Text_Answer
  482. From Fw.Report_Form_Answers
  483. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.053'
  484. ) Dt_41
  485. On Fw.Forms.Id = Dt_41.Form_Id
  486.  
  487. Left Join
  488. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  489. Fw.Report_Form_Answers.FORM_ID,
  490. Fw.Report_Form_Answers.Lookup_Code,
  491. Fw.Report_Form_Answers.Text_Answer
  492. From Fw.Report_Form_Answers
  493. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.054'
  494. ) Dt_42
  495. On Fw.Forms.Id = Dt_42.Form_Id
  496.  
  497. Left Join
  498. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  499. Fw.Report_Form_Answers.FORM_ID,
  500. Fw.Report_Form_Answers.Lookup_Code,
  501. Fw.Report_Form_Answers.Text_Answer
  502. From Fw.Report_Form_Answers
  503. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.072'
  504. ) Dt_43
  505. On Fw.Forms.Id = Dt_43.Form_Id
  506.  
  507.  
  508. Left Join
  509. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  510. Fw.Report_Form_Answers.FORM_ID,
  511. Fw.Report_Form_Answers.Lookup_Code,
  512. Fw.Report_Form_Answers.Text_Answer
  513. From Fw.Report_Form_Answers
  514. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.073'
  515. ) Dt_44
  516. On Fw.Forms.Id = Dt_44.Form_Id
  517.  
  518. Left Join
  519. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  520. Fw.Report_Form_Answers.FORM_ID,
  521. Fw.Report_Form_Answers.Lookup_Code,
  522. Fw.Report_Form_Answers.Text_Answer
  523. From Fw.Report_Form_Answers
  524. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.057'
  525. ) Dt_45
  526. On Fw.Forms.Id = Dt_45.Form_Id
  527.  
  528. Left Join
  529. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  530. Fw.Report_Form_Answers.FORM_ID,
  531. Fw.Report_Form_Answers.Lookup_Code,
  532. Fw.Report_Form_Answers.Text_Answer
  533. From Fw.Report_Form_Answers
  534. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.074'
  535. ) Dt_46
  536. On Fw.Forms.Id = Dt_46.Form_Id
  537.  
  538. Left Join
  539. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  540. Fw.Report_Form_Answers.FORM_ID,
  541. Fw.Report_Form_Answers.Lookup_Code,
  542. Fw.Report_Form_Answers.Text_Answer
  543. From Fw.Report_Form_Answers
  544. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.075'
  545. ) Dt_47
  546. On Fw.Forms.Id = Dt_47.Form_Id
  547.  
  548. Left Join
  549. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  550. Fw.Report_Form_Answers.FORM_ID,
  551. Fw.Report_Form_Answers.Lookup_Code,
  552. Fw.Report_Form_Answers.Text_Answer
  553. From Fw.Report_Form_Answers
  554. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.076'
  555. ) Dt_48
  556. On Fw.Forms.Id = Dt_48.Form_Id
  557.  
  558. Left Join
  559. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  560. Fw.Report_Form_Answers.FORM_ID,
  561. Fw.Report_Form_Answers.Lookup_Code,
  562. Fw.Report_Form_Answers.Text_Answer
  563. From Fw.Report_Form_Answers
  564. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.077'
  565. ) Dt_49
  566. On Fw.Forms.Id = Dt_49.Form_Id
  567.  
  568. Left Join
  569. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  570. Fw.Report_Form_Answers.FORM_ID,
  571. Fw.Report_Form_Answers.Lookup_Code,
  572. Fw.Report_Form_Answers.Text_Answer
  573. From Fw.Report_Form_Answers
  574. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.059'
  575. ) Dt_50
  576. On Fw.Forms.Id = Dt_50.Form_Id
  577.  
  578. Left Join
  579. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  580. Fw.Report_Form_Answers.FORM_ID,
  581. Fw.Report_Form_Answers.Lookup_Code,
  582. Fw.Report_Form_Answers.Text_Answer
  583. From Fw.Report_Form_Answers
  584. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.058'
  585. ) Dt_51
  586. On Fw.Forms.Id = Dt_51.Form_Id
  587.  
  588. Left Join
  589. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  590. Fw.Report_Form_Answers.FORM_ID,
  591. Fw.Report_Form_Answers.Lookup_Code,
  592. Fw.Report_Form_Answers.Text_Answer
  593. From Fw.Report_Form_Answers
  594. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.055'
  595. ) Dt_52
  596. On Fw.Forms.Id = Dt_52.Form_Id
  597.  
  598. Left Join
  599. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  600. Fw.Report_Form_Answers.FORM_ID,
  601. Fw.Report_Form_Answers.Lookup_Code,
  602. Fw.Report_Form_Answers.Text_Answer
  603. From Fw.Report_Form_Answers
  604. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.079'
  605. ) Dt_53
  606. On Fw.Forms.Id = Dt_53.Form_Id
  607.  
  608. Left Join
  609. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  610. Fw.Report_Form_Answers.FORM_ID,
  611. Fw.Report_Form_Answers.Lookup_Code,
  612. Fw.Report_Form_Answers.Text_Answer
  613. From Fw.Report_Form_Answers
  614. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.080'
  615. ) Dt_54
  616. On Fw.Forms.Id = Dt_54.Form_Id
  617.  
  618. Left Join
  619. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  620. Fw.Report_Form_Answers.FORM_ID,
  621. Fw.Report_Form_Answers.Lookup_Code,
  622. Fw.Report_Form_Answers.Text_Answer
  623. From Fw.Report_Form_Answers
  624. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.056'
  625. ) Dt_55
  626. On Fw.Forms.Id = Dt_55.Form_Id
  627.  
  628. Left Join
  629. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  630. Fw.Report_Form_Answers.FORM_ID,
  631. Fw.Report_Form_Answers.Lookup_Code,
  632. Fw.Report_Form_Answers.Text_Answer
  633. From Fw.Report_Form_Answers
  634. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.060'
  635. ) Dt_56
  636. On Fw.Forms.Id = Dt_56.Form_Id
  637.  
  638. Left Join
  639. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  640. Fw.Report_Form_Answers.FORM_ID,
  641. Fw.Report_Form_Answers.Lookup_Code,
  642. Fw.Report_Form_Answers.Text_Answer
  643. From Fw.Report_Form_Answers
  644. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.069'
  645. ) Dt_57
  646. On Fw.Forms.Id = Dt_57.Form_Id
  647.  
  648. Left Join
  649. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  650. Fw.Report_Form_Answers.FORM_ID,
  651. Fw.Report_Form_Answers.Lookup_Code,
  652. Fw.Report_Form_Answers.Text_Answer
  653. From Fw.Report_Form_Answers
  654. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.082'
  655. ) Dt_58
  656. On Fw.Forms.Id = Dt_58.Form_Id
  657.  
  658. Left Join
  659. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  660. Fw.Report_Form_Answers.FORM_ID,
  661. Fw.Report_Form_Answers.Lookup_Code,
  662. Fw.Report_Form_Answers.Text_Answer
  663. From Fw.Report_Form_Answers
  664. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.083'
  665. ) Dt_59
  666. On Fw.Forms.Id = Dt_59.Form_Id
  667.  
  668. Left Join
  669. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  670. Fw.Report_Form_Answers.FORM_ID,
  671. Fw.Report_Form_Answers.Lookup_Code,
  672. Fw.Report_Form_Answers.Text_Answer
  673. From Fw.Report_Form_Answers
  674. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.084'
  675. ) Dt_60
  676. On Fw.Forms.Id = Dt_60.Form_Id
  677.  
  678.  
  679.  
  680.  
  681. Left Join
  682. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  683. Fw.Report_Form_Answers.FORM_ID,
  684. Fw.Report_Form_Answers.Lookup_Code,
  685. Fw.Report_Form_Answers.Text_Answer
  686. From Fw.Report_Form_Answers
  687. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.085'
  688. ) Dt_61
  689. On Fw.Forms.Id = Dt_61.Form_Id
  690.  
  691. Left Join
  692. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  693. Fw.Report_Form_Answers.FORM_ID,
  694. Fw.Report_Form_Answers.Lookup_Code,
  695. Fw.Report_Form_Answers.Text_Answer
  696. From Fw.Report_Form_Answers
  697. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.086'
  698. ) Dt_62
  699. On Fw.Forms.Id = Dt_62.Form_Id
  700.  
  701. Left Join
  702. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  703. Fw.Report_Form_Answers.FORM_ID,
  704. Fw.Report_Form_Answers.Lookup_Code,
  705. Fw.Report_Form_Answers.Text_Answer
  706. From Fw.Report_Form_Answers
  707. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.087'
  708. ) Dt_63
  709. On Fw.Forms.Id = Dt_63.Form_Id
  710.  
  711. Left Join
  712. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  713. Fw.Report_Form_Answers.FORM_ID,
  714. Fw.Report_Form_Answers.Lookup_Code,
  715. Fw.Report_Form_Answers.Text_Answer
  716. From Fw.Report_Form_Answers
  717. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.097'
  718. ) Dt_64
  719. On Fw.Forms.Id = Dt_64.Form_Id
  720.  
  721. Left Join
  722. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  723. Fw.Report_Form_Answers.FORM_ID,
  724. Fw.Report_Form_Answers.Lookup_Code,
  725. Fw.Report_Form_Answers.Text_Answer
  726. From Fw.Report_Form_Answers
  727. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.098'
  728. ) Dt_65
  729. On Fw.Forms.Id = Dt_65.Form_Id
  730.  
  731. Left Join
  732. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  733. Fw.Report_Form_Answers.FORM_ID,
  734. Fw.Report_Form_Answers.Lookup_Code,
  735. Fw.Report_Form_Answers.Text_Answer
  736. From Fw.Report_Form_Answers
  737. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.099'
  738. ) Dt_66
  739. On Fw.Forms.Id = Dt_66.Form_Id
  740.  
  741. Left Join
  742. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  743. Fw.Report_Form_Answers.FORM_ID,
  744. Fw.Report_Form_Answers.Lookup_Code,
  745. Fw.Report_Form_Answers.Text_Answer
  746. From Fw.Report_Form_Answers
  747. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.088'
  748. ) Dt_67
  749. On Fw.Forms.Id = Dt_67.Form_Id
  750.  
  751. Left Join
  752. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  753. Fw.Report_Form_Answers.FORM_ID,
  754. Fw.Report_Form_Answers.Lookup_Code,
  755. Fw.Report_Form_Answers.Text_Answer
  756. From Fw.Report_Form_Answers
  757. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.089'
  758. ) Dt_68
  759. On Fw.Forms.Id = Dt_68.Form_Id
  760.  
  761. Left Join
  762. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  763. Fw.Report_Form_Answers.FORM_ID,
  764. Fw.Report_Form_Answers.Lookup_Code,
  765. Fw.Report_Form_Answers.Text_Answer
  766. From Fw.Report_Form_Answers
  767. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.100'
  768. ) Dt_69
  769. On Fw.Forms.Id = Dt_69.Form_Id
  770.  
  771. Left Join
  772. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  773. Fw.Report_Form_Answers.FORM_ID,
  774. Fw.Report_Form_Answers.Lookup_Code,
  775. Fw.Report_Form_Answers.Text_Answer
  776. From Fw.Report_Form_Answers
  777. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.101'
  778. ) Dt_70
  779. On Fw.Forms.Id = Dt_70.Form_Id
  780.  
  781. Left Join
  782. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  783. Fw.Report_Form_Answers.FORM_ID,
  784. Fw.Report_Form_Answers.Lookup_Code,
  785. Fw.Report_Form_Answers.Text_Answer
  786. From Fw.Report_Form_Answers
  787. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.090'
  788. ) Dt_71
  789. On Fw.Forms.Id = Dt_71.Form_Id
  790.  
  791. Left Join
  792. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  793. Fw.Report_Form_Answers.FORM_ID,
  794. Fw.Report_Form_Answers.Lookup_Code,
  795. Fw.Report_Form_Answers.Text_Answer
  796. From Fw.Report_Form_Answers
  797. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.091'
  798. ) Dt_72
  799. On Fw.Forms.Id = Dt_72.Form_Id
  800.  
  801. Left Join
  802. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  803. Fw.Report_Form_Answers.FORM_ID,
  804. Fw.Report_Form_Answers.Lookup_Code,
  805. Fw.Report_Form_Answers.Text_Answer
  806. From Fw.Report_Form_Answers
  807. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.092'
  808. ) Dt_73
  809. On Fw.Forms.Id = Dt_73.Form_Id
  810.  
  811. Left Join
  812. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  813. Fw.Report_Form_Answers.FORM_ID,
  814. Fw.Report_Form_Answers.Lookup_Code,
  815. Fw.Report_Form_Answers.Text_Answer
  816. From Fw.Report_Form_Answers
  817. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.093'
  818. ) Dt_74
  819. On Fw.Forms.Id = Dt_74.Form_Id
  820.  
  821. Left Join
  822. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  823. Fw.Report_Form_Answers.FORM_ID,
  824. Fw.Report_Form_Answers.Lookup_Code,
  825. Fw.Report_Form_Answers.Text_Answer
  826. From Fw.Report_Form_Answers
  827. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.094'
  828. ) Dt_75
  829. On Fw.Forms.Id = Dt_75.Form_Id
  830.  
  831.  
  832. Left Join
  833. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  834. Fw.Report_Form_Answers.FORM_ID,
  835. Fw.Report_Form_Answers.Lookup_Code,
  836. Fw.Report_Form_Answers.Text_Answer
  837. From Fw.Report_Form_Answers
  838. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.095'
  839. ) Dt_76
  840. On Fw.Forms.Id = Dt_76.Form_Id
  841.  
  842.  
  843. Left Join
  844. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  845. Fw.Report_Form_Answers.FORM_ID,
  846. Fw.Report_Form_Answers.Lookup_Code,
  847. Fw.Report_Form_Answers.Text_Answer
  848. From Fw.Report_Form_Answers
  849. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.096'
  850. ) Dt_77
  851. On Fw.Forms.Id = Dt_77.Form_Id
  852.  
  853.  
  854. Left Join
  855. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  856. Fw.Report_Form_Answers.FORM_ID,
  857. Fw.Report_Form_Answers.Lookup_Code,
  858. Fw.Report_Form_Answers.Text_Answer
  859. From Fw.Report_Form_Answers
  860. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.102'
  861. ) Dt_78
  862. On Fw.Forms.Id = Dt_78.Form_Id
  863.  
  864.  
  865. Left Join
  866. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  867. Fw.Report_Form_Answers.FORM_ID,
  868. Fw.Report_Form_Answers.Lookup_Code,
  869. Fw.Report_Form_Answers.Text_Answer
  870. From Fw.Report_Form_Answers
  871. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.103'
  872. ) Dt_79
  873. On Fw.Forms.Id = Dt_79.Form_Id
  874.  
  875.  
  876. Left Join
  877. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  878. Fw.Report_Form_Answers.FORM_ID,
  879. Fw.Report_Form_Answers.Lookup_Code,
  880. Fw.Report_Form_Answers.Text_Answer
  881. From Fw.Report_Form_Answers
  882. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.104'
  883. ) Dt_80
  884. On Fw.Forms.Id = Dt_80.Form_Id
  885.  
  886.  
  887. Left Join
  888. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  889. Fw.Report_Form_Answers.FORM_ID,
  890. Fw.Report_Form_Answers.Lookup_Code,
  891. Fw.Report_Form_Answers.Text_Answer
  892. From Fw.Report_Form_Answers
  893. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.105'
  894. ) Dt_81
  895. On Fw.Forms.Id = Dt_81.Form_Id
  896.  
  897.  
  898. Left Join
  899. (Select Fw.Report_Form_Answers.Section_Item_Tag_Id,
  900. Fw.Report_Form_Answers.FORM_ID,
  901. Fw.Report_Form_Answers.Lookup_Code,
  902. Fw.Report_Form_Answers.Text_Answer
  903. From Fw.Report_Form_Answers
  904. Where Fw.Report_Form_Answers.Section_Item_Tag_Id = 'SA.106'
  905. ) Dt_82
  906. On Fw.Forms.Id = Dt_82.Form_Id
  907.  
  908.  
  909.  
  910.  
  911.  
  912. Where (Dt_Assdate.Date_Answer >= To_Date('01/01/2015', 'dd/mm/yyyy')
  913. AND dt_assDate.DATE_ANSWER <= To_Date('01/06/2015', 'dd/mm/yyyy'))
  914. AND FW.DM_A_EPISODES.EPISODE_TYPE = 'EA_REVIEW'
  915. AND FW.FORMS.ID_CODE = 'FORM1290072866338ANR'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!