Advertisement
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| 06/13/2008 at 08:07AM PDT, ID: 23482986 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: |
select TFF.FACTFIND_ID , SUBMISSIONS.SUBMISSION_NUMBER , parties.cust1 , parties.cust2 , TFF.AGENT_ID , null , TFF.LEAD_ID , TFF.FACTFIND_DATE , TFF.STATUS_DATE , DECODE(SUBMISSIONS.SUBMISSION_NUMBER, 1,'Y','N') rft_flag , needs.ip , needs.ci , needs.lcc , needs.lci , needs.savings , needs.investment , needs.pension , needs.annuities , sales.ip , sales.ci , sales.lcc , sales.lci , sales.savings , sales.investment , sales.pension , sales.annuities , EXPENDITURE.DECLINED_FLAG disclosed_expenditure , ASSETS.DECLINED_FLAG disclosed_assets , LIABILITIES.DECLINED_FLAG disclosed_liabilities , OCCBEN.DECLINED_FLAG disclosed_occbens , protection.DECLINED_FLAG disclosed_protection , savings.DECLINED_FLAG disclosed_savings , pensions.DECLINED_FLAG disclosed_pensions , investments.DECLINED_FLAG disclosed_investments , TFF.BUILDINGS_RENEWAL_DATE , TFF.BUILDINGS_PROVIDER_TEXT , TFF.CONTENTS_RENEWAL_DATE , TFF.CONTENTS_PROVIDER_TEXT , b_and_c_premium.premium , atr.cust1_protection_level , atr.cust1_savings_level , atr.cust1_investment_level , atr.cust1_pension_level , cust_ni.cust1_ip_ni , cust_ni.cust1_ci_ni , cust_ni.cust1_lcc_ni , cust_ni.cust1_lci_ni , cust_ni.cust1_savings_ni , cust_ni.cust1_investments_ni , cust_na.cust1_ip_na , cust_na.cust1_ci_na , cust_na.cust1_lcc_na , cust_na.cust1_lci_na , cust_na.cust1_savings_na , cust_na.cust1_investments_na , atr.cust2_protection_level , atr.cust2_savings_level , atr.cust2_investment_level , atr.cust2_pension_level , cust_ni.cust2_ip_ni , cust_ni.cust2_ci_ni , cust_ni.cust2_lcc_ni , cust_ni.cust2_lci_ni , cust_ni.cust2_savings_ni , cust_ni.cust2_investments_ni , cust_na.cust2_ip_na , cust_na.cust2_ci_na , cust_na.cust2_lcc_na , cust_na.cust2_lci_na , cust_na.cust2_savings_na , cust_na.cust2_investments_na , TFF.STATUS_DATE from salex.t_ff_factfind@util.world tff ,( select TNLD.FACTFIND_ID , MAX(TNLD.SUBMISSION_NUMBER) submission_number from salex.t_nbmu_log_detail@util.world tnld group by TNLD.FACTFIND_ID ) submissions ,( select TFR.FACTFIND_ID , MAX(DECODE(TFR.ROLE_TYPE_CODE_ID,1008513,TFR.PARTY_ID )) cust1 , MAX(DECODE(TFR.ROLE_TYPE_CODE_ID,1008514,TFR.PARTY_ID )) cust2 from salex.t_ff_role@util.world tfr group by TFR.FACTFIND_ID ) parties ,( select tna.factfind_id , NVL(SUM(DECODE(TNND.NEED_ID,341,1)),0) ip , NVL(SUM(DECODE(TNND.NEED_ID,342,1)),0) ci , NVL(SUM(DECODE(TNND.NEED_ID,343,1,8,1)),0) lcc , NVL(SUM(DECODE(TNND.NEED_ID,340,1)),0) lci , NVL(SUM(DECODE(TNND.NEED_ID,346,1)),0) annuities , NVL(SUM(DECODE(TNND.NEED_ID,347,1,348,1)),0) savings , NVL(SUM(DECODE(TNND.NEED_ID,349,1,350,1)),0) investment , NVL(SUM(DECODE(TNND.NEED_ID,344,1,345,1)),0) pension from salex.t_na_needs@util.world tna , salex.t_na_needs_detail@util.world tnnd where TNA.NA_NEED_ID = TNND.NA_NEED_ID group by tna.factfind_id ) needs ,( select tr.factfind_id , NVL(SUM(DECODE(tr.NEED_ID,341,1)),0) ip , NVL(SUM(DECODE(tr.NEED_ID,342,1)),0) ci , NVL(SUM(DECODE(tr.NEED_ID,343,1,8,1)),0) lcc , NVL(SUM(DECODE(tr.NEED_ID,340,1)),0) lci , NVL(SUM(DECODE(tr.NEED_ID,346,1)),0) annuities , NVL(SUM(DECODE(tr.NEED_ID,347,1,348,1)),0) savings , NVL(SUM(DECODE(tr.NEED_ID,349,1,350,1)),0) investment , NVL(SUM(DECODE(tr.NEED_ID,344,1,345,1)),0) pension from salex.t_recommendations@util.world tr where TR.FACTFIND_ID is not null and TR.ACCEPTED_CODE_ID = 590 group by tr.factfind_id ) sales ,( select distinct TFIE.FACTFIND_ID , TFIE.DECLINED_FLAG from salex.t_ff_income_expenditure@util.world tfie ) expenditure ,( select distinct TFA.FACTFIND_ID , TFA.DECLINED_FLAG from salex.t_ff_assets@util.world tfa ) assets ,( select distinct TFL.FACTFIND_ID , TFL.DECLINED_FLAG from salex.t_ff_liabilities@util.world tfl ) liabilities ,( select distinct TFOB.FACTFIND_ID , TFOB.DECLINED_FLAG from salex.t_ff_occupational_benefits@util.world tfob ) occben ,( select distinct TFEB.FACTFIND_ID , MAX(TFEB.DECLINED_FLAG) DECLINED_FLAG from salex.t_ff_existing_business@util.world tfeb where TFEB.NEED_AREA_CODE_ID = 1008499 group by tfeb.factfind_id ) protection ,( select distinct TFEB1.FACTFIND_ID , MAX(TFEB1.DECLINED_FLAG) DECLINED_FLAG from salex.t_ff_existing_business@util.world tfeb1 where TFEB1.NEED_AREA_CODE_ID = 1008500 group by tfeb1.factfind_id ) savings ,( select distinct TFEB2.FACTFIND_ID , MAX(TFEB2.DECLINED_FLAG) DECLINED_FLAG from salex.t_ff_existing_business@util.world tfeb2 where TFEB2.NEED_AREA_CODE_ID = 1008501 group by tfeb2.factfind_id ) pensions ,( select distinct TFEB3.FACTFIND_ID , MAX(TFEB3.DECLINED_FLAG) DECLINED_FLAG from salex.t_ff_existing_business@util.world tfeb3 where TFEB3.NEED_AREA_CODE_ID = 1008502 group by tfeb3.factfind_id ) investments ,( select TFIE1.FACTFIND_ID , SUM(TFIED1.IE_AMT) premium from salex.t_ff_income_expenditure@util.world tfie1 , salex.t_ff_income_exp_detail@util.world tfied1 where TFIE1.IE_ID = TFIED1.IE_ID and TFIE1.DECLINED_FLAG = 'N' and TFIED1.IE_CODE_ID = 1008556 group by TFIE1.FACTFIND_ID ) b_and_c_premium ,( select factfind_id , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513IP','Y')) cust1_ip_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513CI','Y')) cust1_ci_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513LCC','Y')) cust1_lcc_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513LCI','Y')) cust1_lci_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513Savings','Y')) cust1_savings_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513Investments','Y')) cust1_investments_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514IP','Y')) cust2_ip_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514CI','Y')) cust2_ci_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514LCC','Y')) cust2_lcc_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514LCI','Y')) cust2_lci_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514Savings','Y')) cust2_savings_ni , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514Investments','Y')) cust2_investments_ni from ( select 'IP' ni_type , tnipp.FACTFIND_ID , tfr1.ROLE_TYPE_CODE_ID from salex.t_na_ipp@util.world tnipp , salex.t_ff_role@util.world tfr1 where tnipp.not_important_flag = 'Y' and TNIPP.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID union select 'CI' , tnci.FACTFIND_ID , tfr1.ROLE_TYPE_CODE_ID from salex.t_na_cic@util.world tnci , salex.t_ff_role@util.world tfr1 where tnci.not_important_flag = 'Y' and tnci.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID union select 'LCC' , tnc.FACTFIND_ID , tfr1.ROLE_TYPE_CODE_ID from salex.t_na_capital@util.world tnc , salex.t_ff_role@util.world tfr1 where tnc.not_important_flag = 'Y' and tnc.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID union select 'LCI' , tnlc.FACTFIND_ID , tfr1.ROLE_TYPE_CODE_ID from salex.t_na_life_cover@util.world tnlc , salex.t_ff_role@util.world tfr1 where tnlc.not_important_flag = 'Y' and tnlc.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID union select 'Savings' , tns.FACTFIND_ID , tfr1.ROLE_TYPE_CODE_ID from salex.t_na_savings@util.world tns , salex.t_ff_role@util.world tfr1 where tns.not_important_flag = 'Y' and tns.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID union select 'Investments' , tni.FACTFIND_ID , tfr1.ROLE_TYPE_CODE_ID from salex.t_na_investments@util.world tni , salex.t_ff_role@util.world tfr1 where tni.not_important_flag = 'Y' and tni.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID ) group by factfind_id ) cust_ni ,( select factfind_id , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513IP','Y')) cust1_ip_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513CI','Y')) cust1_ci_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513LCC','Y')) cust1_lcc_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513LCI','Y')) cust1_lci_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513Savings','Y')) cust1_savings_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513Investments','Y')) cust1_investments_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514IP','Y')) cust2_ip_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514CI','Y')) cust2_ci_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514LCC','Y')) cust2_lcc_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514LCI','Y')) cust2_lci_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514Savings','Y')) cust2_savings_na , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514Investments','Y')) cust2_investments_na from ( select 'IP' na_type , tnipp1.FACTFIND_ID , tfr2.ROLE_TYPE_CODE_ID from salex.t_na_ipp@util.world tnipp1 , salex.t_ff_role@util.world tfr2 where tnipp1.NOT_APPLICABLE_FLAG = 'Y' and tnipp1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID union select 'CI' , tnci1.FACTFIND_ID , tfr2.ROLE_TYPE_CODE_ID from salex.t_na_cic@util.world tnci1 , salex.t_ff_role@util.world tfr2 where tnci1.NOT_APPLICABLE_FLAG = 'Y' and tnci1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID union select 'LCC' , tnc1.FACTFIND_ID , tfr2.ROLE_TYPE_CODE_ID from salex.t_na_capital@util.world tnc1 , salex.t_ff_role@util.world tfr2 where tnc1.NOT_APPLICABLE_FLAG = 'Y' and tnc1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID union select 'LCI' , tnlc1.FACTFIND_ID , tfr2.ROLE_TYPE_CODE_ID from salex.t_na_life_cover@util.world tnlc1 , salex.t_ff_role@util.world tfr2 where tnlc1.NOT_APPLICABLE_FLAG = 'Y' and tnlc1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID union select 'Savings' , tns1.FACTFIND_ID , tfr2.ROLE_TYPE_CODE_ID from salex.t_na_savings@util.world tns1 , salex.t_ff_role@util.world tfr2 where tns1.NOT_APPLICABLE_FLAG = 'Y' and tns1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID union select 'Investments' , tni1.FACTFIND_ID , tfr2.ROLE_TYPE_CODE_ID from salex.t_na_investments@util.world tni1 , salex.t_ff_role@util.world tfr2 where tni1.NOT_APPLICABLE_FLAG = 'Y' and tni1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID ) group by factfind_id ) cust_na ,( select TNA2.FACTFIND_ID , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085131008768, TNA2.ATR_LEVEL)) cust1_protection_level , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085131008769, TNA2.ATR_LEVEL)) cust1_savings_level , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085131008770, TNA2.ATR_LEVEL)) cust1_investment_level , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085131008771, TNA2.ATR_LEVEL)) cust1_pension_level , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085141008768, TNA2.ATR_LEVEL)) cust2_protection_level , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085141008769, TNA2.ATR_LEVEL)) cust2_savings_level , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085141008770, TNA2.ATR_LEVEL)) cust2_investment_level , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085141008771, TNA2.ATR_LEVEL)) cust2_pension_level from salex.t_na_atr@util.world tna2 , salex.t_ff_role@util.world tfr2 where TFR2.FACTFIND_INDIVIDUAL_ID = TNA2.FACTFIND_INDIVIDUAL_ID group by TNA2.FACTFIND_ID ) atr where TFF.STATUS_CODE_ID = 1008521 and TFF.FACTFIND_ID = submissions.FACTFIND_ID and TFF.FACTFIND_ID = parties.FACTFIND_ID and TFF.FACTFIND_ID = expenditure.FACTFIND_ID and TFF.FACTFIND_ID = assets.FACTFIND_ID and TFF.FACTFIND_ID = liabilities.FACTFIND_ID and TFF.FACTFIND_ID = occben.FACTFIND_ID and TFF.FACTFIND_ID = protection.FACTFIND_ID(+) and TFF.FACTFIND_ID = savings.FACTFIND_ID(+) and TFF.FACTFIND_ID = pensions.FACTFIND_ID(+) and TFF.FACTFIND_ID = investments.FACTFIND_ID(+) and TFF.FACTFIND_ID = atr.FACTFIND_ID(+) and TFF.FACTFIND_ID = cust_ni.FACTFIND_ID(+) and TFF.FACTFIND_ID = cust_na.FACTFIND_ID(+) and TFF.FACTFIND_ID = b_and_c_premium.FACTFIND_ID(+) and TFF.FACTFIND_ID = needs.FACTFIND_ID(+) and TFF.FACTFIND_ID = sales.FACTFIND_ID(+); |