dbo.QER_FTEntitlementSourceWhy
Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB
Interpretation
- Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.
Relations
- No extracted relations.
Typed Edges
- No typed edges extracted for this source.
Complete Source
1CREATE FUNCTION dbo.QER_FTEntitlementSourceWhy(2 @UID_Person varchar(38),3 @ObjectKeyToInspect varchar(138)4) RETURNS @erg TABLE(ObjectKeyReason1 varchar(138) collate database_default,5ObjectKeyReason2 varchar(138) collate database_default6)7AS8BEGIN9 IF @ObjectKeyToInspect LIKE '<Key><T>ADSAccount</T>%'10 BEGIN11 INSERT INTO @erg(ObjectKeyReason1,12 ObjectKeyReason2)13 SELECT14 DISTINCT xx.ObjectKeyReason1,15 xx.ObjectKeyReason216 FROM dbo.GEN_FTEY04ACC922CE0D679BFBDF68(@uid_person,17 @ObjectKeyToInspect) AS xx18 GOTO EndLabel19 END20 -- ADSAccount21 IF @ObjectKeyToInspect LIKE '<Key><T>ADSAccountInADSGroup</T>%'22 BEGIN23 INSERT INTO @erg(ObjectKeyReason1,24 ObjectKeyReason2)25 SELECT26 DISTINCT xx.ObjectKeyReason1,27 xx.ObjectKeyReason228 FROM dbo.GEN_FTEYBC1B1E1153DA0887D6F11C(@uid_person,29 @ObjectKeyToInspect) AS xx30 GOTO EndLabel31 END32 -- ADSAccountInADSGroup33 IF @ObjectKeyToInspect LIKE '<Key><T>ADSContact</T>%'34 BEGIN35 INSERT INTO @erg(ObjectKeyReason1,36 ObjectKeyReason2)37 SELECT38 DISTINCT xx.ObjectKeyReason1,39 xx.ObjectKeyReason240 FROM dbo.GEN_FTEYAFC2B1B0AA231EB7202E0A(@uid_person,41 @ObjectKeyToInspect) AS xx42 GOTO EndLabel43 END44 -- ADSContact45 IF @ObjectKeyToInspect LIKE '<Key><T>ADSContactInADSGroup</T>%'46 BEGIN47 INSERT INTO @erg(ObjectKeyReason1,48 ObjectKeyReason2)49 SELECT50 DISTINCT xx.ObjectKeyReason1,51 xx.ObjectKeyReason252 FROM dbo.GEN_FTEY6CF75B30295FEFA8CD3709(@uid_person,53 @ObjectKeyToInspect) AS xx54 GOTO EndLabel55 END56 -- ADSContactInADSGroup57 IF @ObjectKeyToInspect LIKE '<Key><T>ADSContainer</T>%'58 BEGIN59 INSERT INTO @erg(ObjectKeyReason1,60 ObjectKeyReason2)61 SELECT62 DISTINCT xx.ObjectKeyReason1,63 xx.ObjectKeyReason264 FROM dbo.GEN_FTEYD067DDDE01113A49AB7F4F(@uid_person,65 @ObjectKeyToInspect) AS xx66 GOTO EndLabel67 END68 -- ADSContainer69 IF @ObjectKeyToInspect LIKE '<Key><T>ADSDomain</T>%'70 BEGIN71 INSERT INTO @erg(ObjectKeyReason1,72 ObjectKeyReason2)73 SELECT74 DISTINCT xx.ObjectKeyReason1,75 xx.ObjectKeyReason276 FROM dbo.GEN_FTEYD1FF94E385FADA2276090E(@uid_person,77 @ObjectKeyToInspect) AS xx78 GOTO EndLabel79 END80 -- ADSDomain81 IF @ObjectKeyToInspect LIKE '<Key><T>ADSGroup</T>%'82 BEGIN83 INSERT INTO @erg(ObjectKeyReason1,84 ObjectKeyReason2)85 SELECT86 DISTINCT xx.ObjectKeyReason1,87 xx.ObjectKeyReason288 FROM dbo.GEN_FTEYEB1C7B5195AE3821552788(@uid_person,89 @ObjectKeyToInspect) AS xx90 GOTO EndLabel91 END92 -- ADSGroup93 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasADSGroup</T>%'94 BEGIN95 INSERT INTO @erg(ObjectKeyReason1,96 ObjectKeyReason2)97 SELECT98 DISTINCT xx.ObjectKeyReason1,99 xx.ObjectKeyReason2100 FROM dbo.GEN_FTEYF1D845A502E28AB8F8B8FA(@uid_person,101 @ObjectKeyToInspect) AS xx102 GOTO EndLabel103 END104 -- DepartmentHasADSGroup105 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasADSGroup</T>%'106 BEGIN107 INSERT INTO @erg(ObjectKeyReason1,108 ObjectKeyReason2)109 SELECT110 DISTINCT xx.ObjectKeyReason1,111 xx.ObjectKeyReason2112 FROM dbo.GEN_FTEY625B5F1743A4CD81DB1A7A(@uid_person,113 @ObjectKeyToInspect) AS xx114 GOTO EndLabel115 END116 -- ITShopOrgHasADSGroup117 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasADSGroup</T>%'118 BEGIN119 INSERT INTO @erg(ObjectKeyReason1,120 ObjectKeyReason2)121 SELECT122 DISTINCT xx.ObjectKeyReason1,123 xx.ObjectKeyReason2124 FROM dbo.GEN_FTEYBE4C4D5B55E47B4A37030F(@uid_person,125 @ObjectKeyToInspect) AS xx126 GOTO EndLabel127 END128 -- ITShopSrcHasADSGroup129 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasADSGroup</T>%'130 BEGIN131 INSERT INTO @erg(ObjectKeyReason1,132 ObjectKeyReason2)133 SELECT134 DISTINCT xx.ObjectKeyReason1,135 xx.ObjectKeyReason2136 FROM dbo.GEN_FTEY3503043CCF5F62E3FC1EC7(@uid_person,137 @ObjectKeyToInspect) AS xx138 GOTO EndLabel139 END140 -- LocalityHasADSGroup141 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasADSGroup</T>%'142 BEGIN143 INSERT INTO @erg(ObjectKeyReason1,144 ObjectKeyReason2)145 SELECT146 DISTINCT xx.ObjectKeyReason1,147 xx.ObjectKeyReason2148 FROM dbo.GEN_FTEY11C75B4ECD9BB22D2D748B(@uid_person,149 @ObjectKeyToInspect) AS xx150 GOTO EndLabel151 END152 -- OrgHasADSGroup153 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasADSGroup</T>%'154 BEGIN155 INSERT INTO @erg(ObjectKeyReason1,156 ObjectKeyReason2)157 SELECT158 DISTINCT xx.ObjectKeyReason1,159 xx.ObjectKeyReason2160 FROM dbo.GEN_FTEYE80DDBCEAAA13F1979E711(@uid_person,161 @ObjectKeyToInspect) AS xx162 GOTO EndLabel163 END164 -- ProfitCenterHasADSGroup165 IF @ObjectKeyToInspect LIKE '<Key><T>PersonInNonCompliance</T>%'166 BEGIN167 INSERT INTO @erg(ObjectKeyReason1,168 ObjectKeyReason2)169 SELECT170 DISTINCT xx.ObjectKeyReason1,171 xx.ObjectKeyReason2172 FROM dbo.GEN_FTEYDEBA0F85E016415BA14437(@uid_person,173 @ObjectKeyToInspect) AS xx174 GOTO EndLabel175 END176 -- PersonInNonCompliance177 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasLDAPGroup</T>%'178 BEGIN179 INSERT INTO @erg(ObjectKeyReason1,180 ObjectKeyReason2)181 SELECT182 DISTINCT xx.ObjectKeyReason1,183 xx.ObjectKeyReason2184 FROM dbo.GEN_FTEY780D32B60508B96FB55733(@uid_person,185 @ObjectKeyToInspect) AS xx186 GOTO EndLabel187 END188 -- DepartmentHasLDAPGroup189 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasLDAPGroup</T>%'190 BEGIN191 INSERT INTO @erg(ObjectKeyReason1,192 ObjectKeyReason2)193 SELECT194 DISTINCT xx.ObjectKeyReason1,195 xx.ObjectKeyReason2196 FROM dbo.GEN_FTEY714650F04D0D2C9ADFD428(@uid_person,197 @ObjectKeyToInspect) AS xx198 GOTO EndLabel199 END200 -- ITShopOrgHasLDAPGroup201 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasLDAPGroup</T>%'202 BEGIN203 INSERT INTO @erg(ObjectKeyReason1,204 ObjectKeyReason2)205 SELECT206 DISTINCT xx.ObjectKeyReason1,207 xx.ObjectKeyReason2208 FROM dbo.GEN_FTEYFED8D3214C9C1DAFEE2EB0(@uid_person,209 @ObjectKeyToInspect) AS xx210 GOTO EndLabel211 END212 -- ITShopSrcHasLDAPGroup213 IF @ObjectKeyToInspect LIKE '<Key><T>LDAPAccount</T>%'214 BEGIN215 INSERT INTO @erg(ObjectKeyReason1,216 ObjectKeyReason2)217 SELECT218 DISTINCT xx.ObjectKeyReason1,219 xx.ObjectKeyReason2220 FROM dbo.GEN_FTEY3660BE5A72C51D09E109D2(@uid_person,221 @ObjectKeyToInspect) AS xx222 GOTO EndLabel223 END224 -- LDAPAccount225 IF @ObjectKeyToInspect LIKE '<Key><T>LDAPAccountInLDAPGroup</T>%'226 BEGIN227 INSERT INTO @erg(ObjectKeyReason1,228 ObjectKeyReason2)229 SELECT230 DISTINCT xx.ObjectKeyReason1,231 xx.ObjectKeyReason2232 FROM dbo.GEN_FTEY510EB2AF297B8F844C83DA(@uid_person,233 @ObjectKeyToInspect) AS xx234 GOTO EndLabel235 END236 -- LDAPAccountInLDAPGroup237 IF @ObjectKeyToInspect LIKE '<Key><T>LDAPContainer</T>%'238 BEGIN239 INSERT INTO @erg(ObjectKeyReason1,240 ObjectKeyReason2)241 SELECT242 DISTINCT xx.ObjectKeyReason1,243 xx.ObjectKeyReason2244 FROM dbo.GEN_FTEYF9B5B0718078CC8E220CB4(@uid_person,245 @ObjectKeyToInspect) AS xx246 GOTO EndLabel247 END248 -- LDAPContainer249 IF @ObjectKeyToInspect LIKE '<Key><T>LDAPGroup</T>%'250 BEGIN251 INSERT INTO @erg(ObjectKeyReason1,252 ObjectKeyReason2)253 SELECT254 DISTINCT xx.ObjectKeyReason1,255 xx.ObjectKeyReason2256 FROM dbo.GEN_FTEYA5065182EC53F911A8AB59(@uid_person,257 @ObjectKeyToInspect) AS xx258 GOTO EndLabel259 END260 -- LDAPGroup261 IF @ObjectKeyToInspect LIKE '<Key><T>LDPDomain</T>%'262 BEGIN263 INSERT INTO @erg(ObjectKeyReason1,264 ObjectKeyReason2)265 SELECT266 DISTINCT xx.ObjectKeyReason1,267 xx.ObjectKeyReason2268 FROM dbo.GEN_FTEY95BE8166C29BD1FD6991CC(@uid_person,269 @ObjectKeyToInspect) AS xx270 GOTO EndLabel271 END272 -- LDPDomain273 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasLDAPGroup</T>%'274 BEGIN275 INSERT INTO @erg(ObjectKeyReason1,276 ObjectKeyReason2)277 SELECT278 DISTINCT xx.ObjectKeyReason1,279 xx.ObjectKeyReason2280 FROM dbo.GEN_FTEYAC13F21E0D4DB4DD55310E(@uid_person,281 @ObjectKeyToInspect) AS xx282 GOTO EndLabel283 END284 -- LocalityHasLDAPGroup285 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasLDAPGroup</T>%'286 BEGIN287 INSERT INTO @erg(ObjectKeyReason1,288 ObjectKeyReason2)289 SELECT290 DISTINCT xx.ObjectKeyReason1,291 xx.ObjectKeyReason2292 FROM dbo.GEN_FTEY6CBBED4521EDE5C5B61A02(@uid_person,293 @ObjectKeyToInspect) AS xx294 GOTO EndLabel295 END296 -- OrgHasLDAPGroup297 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasLDAPGroup</T>%'298 BEGIN299 INSERT INTO @erg(ObjectKeyReason1,300 ObjectKeyReason2)301 SELECT302 DISTINCT xx.ObjectKeyReason1,303 xx.ObjectKeyReason2304 FROM dbo.GEN_FTEYA60CCE102C52A5B0014C2D(@uid_person,305 @ObjectKeyToInspect) AS xx306 GOTO EndLabel307 END308 -- ProfitCenterHasLDAPGroup309 IF @ObjectKeyToInspect LIKE '<Key><T>AccProduct</T>%'310 BEGIN311 INSERT INTO @erg(ObjectKeyReason1,312 ObjectKeyReason2)313 SELECT314 DISTINCT xx.ObjectKeyReason1,315 xx.ObjectKeyReason2316 FROM dbo.GEN_FTEY06423E1553D20332D88F9A(@uid_person,317 @ObjectKeyToInspect) AS xx318 GOTO EndLabel319 END320 -- AccProduct321 IF @ObjectKeyToInspect LIKE '<Key><T>AERole</T>%'322 BEGIN323 INSERT INTO @erg(ObjectKeyReason1,324 ObjectKeyReason2)325 SELECT326 DISTINCT xx.ObjectKeyReason1,327 xx.ObjectKeyReason2328 FROM dbo.GEN_FTEY703F1F5EE8D64B7DB79B18(@uid_person,329 @ObjectKeyToInspect) AS xx330 GOTO EndLabel331 END332 -- AERole333 IF @ObjectKeyToInspect LIKE '<Key><T>AERoleHasQERResource</T>%'334 BEGIN335 INSERT INTO @erg(ObjectKeyReason1,336 ObjectKeyReason2)337 SELECT338 DISTINCT xx.ObjectKeyReason1,339 xx.ObjectKeyReason2340 FROM dbo.GEN_FTEY81C940D082F32291EFCE78(@uid_person,341 @ObjectKeyToInspect) AS xx342 GOTO EndLabel343 END344 -- AERoleHasQERResource345 IF @ObjectKeyToInspect LIKE '<Key><T>ComplianceRule</T>%'346 BEGIN347 INSERT INTO @erg(ObjectKeyReason1,348 ObjectKeyReason2)349 SELECT350 DISTINCT xx.ObjectKeyReason1,351 xx.ObjectKeyReason2352 FROM dbo.GEN_FTEYF61C4144CE8FABBC866272(@uid_person,353 @ObjectKeyToInspect) AS xx354 GOTO EndLabel355 END356 -- ComplianceRule357 IF @ObjectKeyToInspect LIKE '<Key><T>Department</T>%'358 BEGIN359 INSERT INTO @erg(ObjectKeyReason1,360 ObjectKeyReason2)361 SELECT362 DISTINCT xx.ObjectKeyReason1,363 xx.ObjectKeyReason2364 FROM dbo.GEN_FTEYC50E4CC8188C7D5B7DCD71(@uid_person,365 @ObjectKeyToInspect) AS xx366 GOTO EndLabel367 END368 -- Department369 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasQERAssign</T>%'370 BEGIN371 INSERT INTO @erg(ObjectKeyReason1,372 ObjectKeyReason2)373 SELECT374 DISTINCT xx.ObjectKeyReason1,375 xx.ObjectKeyReason2376 FROM dbo.GEN_FTEYD5D72E6FA335696FA50D11(@uid_person,377 @ObjectKeyToInspect) AS xx378 GOTO EndLabel379 END380 -- DepartmentHasQERAssign381 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasQERResource</T>%'382 BEGIN383 INSERT INTO @erg(ObjectKeyReason1,384 ObjectKeyReason2)385 SELECT386 DISTINCT xx.ObjectKeyReason1,387 xx.ObjectKeyReason2388 FROM dbo.GEN_FTEY0F8CCEAC5542AB58BC6783(@uid_person,389 @ObjectKeyToInspect) AS xx390 GOTO EndLabel391 END392 -- DepartmentHasQERResource393 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasQERReuse</T>%'394 BEGIN395 INSERT INTO @erg(ObjectKeyReason1,396 ObjectKeyReason2)397 SELECT398 DISTINCT xx.ObjectKeyReason1,399 xx.ObjectKeyReason2400 FROM dbo.GEN_FTEYFF99B6B069C342288C6BA9(@uid_person,401 @ObjectKeyToInspect) AS xx402 GOTO EndLabel403 END404 -- DepartmentHasQERReuse405 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasQERReuseUS</T>%'406 BEGIN407 INSERT INTO @erg(ObjectKeyReason1,408 ObjectKeyReason2)409 SELECT410 DISTINCT xx.ObjectKeyReason1,411 xx.ObjectKeyReason2412 FROM dbo.GEN_FTEYF9571F25A9F1882987B829(@uid_person,413 @ObjectKeyToInspect) AS xx414 GOTO EndLabel415 END416 -- DepartmentHasQERReuseUS417 IF @ObjectKeyToInspect LIKE '<Key><T>ESet</T>%'418 BEGIN419 INSERT INTO @erg(ObjectKeyReason1,420 ObjectKeyReason2)421 SELECT422 DISTINCT xx.ObjectKeyReason1,423 xx.ObjectKeyReason2424 FROM dbo.GEN_FTEY3252DCA9E44227685CE446(@uid_person,425 @ObjectKeyToInspect) AS xx426 GOTO EndLabel427 END428 -- ESet429 IF @ObjectKeyToInspect LIKE '<Key><T>ESetHasEntitlement</T>%'430 BEGIN431 INSERT INTO @erg(ObjectKeyReason1,432 ObjectKeyReason2)433 SELECT434 DISTINCT xx.ObjectKeyReason1,435 xx.ObjectKeyReason2436 FROM dbo.GEN_FTEY63E94516858277C9BB4F5A(@uid_person,437 @ObjectKeyToInspect) AS xx438 GOTO EndLabel439 END440 -- ESetHasEntitlement441 IF @ObjectKeyToInspect LIKE '<Key><T>HelperHeadOrg</T>%'442 BEGIN443 INSERT INTO @erg(ObjectKeyReason1,444 ObjectKeyReason2)445 SELECT446 DISTINCT xx.ObjectKeyReason1,447 xx.ObjectKeyReason2448 FROM dbo.GEN_FTEYCACD53376979AEB4951686(@uid_person,449 @ObjectKeyToInspect) AS xx450 GOTO EndLabel451 END452 -- HelperHeadOrg453 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrg</T>%'454 BEGIN455 INSERT INTO @erg(ObjectKeyReason1,456 ObjectKeyReason2)457 SELECT458 DISTINCT xx.ObjectKeyReason1,459 xx.ObjectKeyReason2460 FROM dbo.GEN_FTEY8FEF93B7440FEF03F2412C(@uid_person,461 @ObjectKeyToInspect) AS xx462 GOTO EndLabel463 END464 -- ITShopOrg465 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasPWODecisionMethod</T>%'466 BEGIN467 INSERT INTO @erg(ObjectKeyReason1,468 ObjectKeyReason2)469 SELECT470 DISTINCT xx.ObjectKeyReason1,471 xx.ObjectKeyReason2472 FROM dbo.GEN_FTEY3652C1025CCBFA75922279(@uid_person,473 @ObjectKeyToInspect) AS xx474 GOTO EndLabel475 END476 -- ITShopOrgHasPWODecisionMethod477 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasQERAssign</T>%'478 BEGIN479 INSERT INTO @erg(ObjectKeyReason1,480 ObjectKeyReason2)481 SELECT482 DISTINCT xx.ObjectKeyReason1,483 xx.ObjectKeyReason2484 FROM dbo.GEN_FTEY959435F6DBCCA9EB3EB28D(@uid_person,485 @ObjectKeyToInspect) AS xx486 GOTO EndLabel487 END488 -- ITShopOrgHasQERAssign489 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasQERResource</T>%'490 BEGIN491 INSERT INTO @erg(ObjectKeyReason1,492 ObjectKeyReason2)493 SELECT494 DISTINCT xx.ObjectKeyReason1,495 xx.ObjectKeyReason2496 FROM dbo.GEN_FTEY57D0C486EFB83A7F90C10D(@uid_person,497 @ObjectKeyToInspect) AS xx498 GOTO EndLabel499 END500 -- ITShopOrgHasQERResource501 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasQERReuse</T>%'502 BEGIN503 INSERT INTO @erg(ObjectKeyReason1,504 ObjectKeyReason2)505 SELECT506 DISTINCT xx.ObjectKeyReason1,507 xx.ObjectKeyReason2508 FROM dbo.GEN_FTEY4855C755CA9487EA21B72A(@uid_person,509 @ObjectKeyToInspect) AS xx510 GOTO EndLabel511 END512 -- ITShopOrgHasQERReuse513 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasQERReuseUS</T>%'514 BEGIN515 INSERT INTO @erg(ObjectKeyReason1,516 ObjectKeyReason2)517 SELECT518 DISTINCT xx.ObjectKeyReason1,519 xx.ObjectKeyReason2520 FROM dbo.GEN_FTEYD1C52DE6CB749CD02A401C(@uid_person,521 @ObjectKeyToInspect) AS xx522 GOTO EndLabel523 END524 -- ITShopOrgHasQERReuseUS525 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasPWODecisionMethod</T>%'526 BEGIN527 INSERT INTO @erg(ObjectKeyReason1,528 ObjectKeyReason2)529 SELECT530 DISTINCT xx.ObjectKeyReason1,531 xx.ObjectKeyReason2532 FROM dbo.GEN_FTEY802A83C3E07BD2831C4DF1(@uid_person,533 @ObjectKeyToInspect) AS xx534 GOTO EndLabel535 END536 -- ITShopSrcHasPWODecisionMethod537 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasQERAssign</T>%'538 BEGIN539 INSERT INTO @erg(ObjectKeyReason1,540 ObjectKeyReason2)541 SELECT542 DISTINCT xx.ObjectKeyReason1,543 xx.ObjectKeyReason2544 FROM dbo.GEN_FTEY16F46EAC98E87C927E087B(@uid_person,545 @ObjectKeyToInspect) AS xx546 GOTO EndLabel547 END548 -- ITShopSrcHasQERAssign549 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasQERResource</T>%'550 BEGIN551 INSERT INTO @erg(ObjectKeyReason1,552 ObjectKeyReason2)553 SELECT554 DISTINCT xx.ObjectKeyReason1,555 xx.ObjectKeyReason2556 FROM dbo.GEN_FTEYECAD876E5948B1A0FEF889(@uid_person,557 @ObjectKeyToInspect) AS xx558 GOTO EndLabel559 END560 -- ITShopSrcHasQERResource561 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasQERReuse</T>%'562 BEGIN563 INSERT INTO @erg(ObjectKeyReason1,564 ObjectKeyReason2)565 SELECT566 DISTINCT xx.ObjectKeyReason1,567 xx.ObjectKeyReason2568 FROM dbo.GEN_FTEYFAEF8CACEA5085E028D489(@uid_person,569 @ObjectKeyToInspect) AS xx570 GOTO EndLabel571 END572 -- ITShopSrcHasQERReuse573 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasQERReuseUS</T>%'574 BEGIN575 INSERT INTO @erg(ObjectKeyReason1,576 ObjectKeyReason2)577 SELECT578 DISTINCT xx.ObjectKeyReason1,579 xx.ObjectKeyReason2580 FROM dbo.GEN_FTEY46244768898D6B348324B5(@uid_person,581 @ObjectKeyToInspect) AS xx582 GOTO EndLabel583 END584 -- ITShopSrcHasQERReuseUS585 IF @ObjectKeyToInspect LIKE '<Key><T>Locality</T>%'586 BEGIN587 INSERT INTO @erg(ObjectKeyReason1,588 ObjectKeyReason2)589 SELECT590 DISTINCT xx.ObjectKeyReason1,591 xx.ObjectKeyReason2592 FROM dbo.GEN_FTEYF021722B8C41E69A21F5BA(@uid_person,593 @ObjectKeyToInspect) AS xx594 GOTO EndLabel595 END596 -- Locality597 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasQERAssign</T>%'598 BEGIN599 INSERT INTO @erg(ObjectKeyReason1,600 ObjectKeyReason2)601 SELECT602 DISTINCT xx.ObjectKeyReason1,603 xx.ObjectKeyReason2604 FROM dbo.GEN_FTEY8BF540F72028620D497ABE(@uid_person,605 @ObjectKeyToInspect) AS xx606 GOTO EndLabel607 END608 -- LocalityHasQERAssign609 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasQERResource</T>%'610 BEGIN611 INSERT INTO @erg(ObjectKeyReason1,612 ObjectKeyReason2)613 SELECT614 DISTINCT xx.ObjectKeyReason1,615 xx.ObjectKeyReason2616 FROM dbo.GEN_FTEY63EBFB5F389C2C71565877(@uid_person,617 @ObjectKeyToInspect) AS xx618 GOTO EndLabel619 END620 -- LocalityHasQERResource621 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasQERReuse</T>%'622 BEGIN623 INSERT INTO @erg(ObjectKeyReason1,624 ObjectKeyReason2)625 SELECT626 DISTINCT xx.ObjectKeyReason1,627 xx.ObjectKeyReason2628 FROM dbo.GEN_FTEY41843567E57D1397868D56(@uid_person,629 @ObjectKeyToInspect) AS xx630 GOTO EndLabel631 END632 -- LocalityHasQERReuse633 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasQERReuseUS</T>%'634 BEGIN635 INSERT INTO @erg(ObjectKeyReason1,636 ObjectKeyReason2)637 SELECT638 DISTINCT xx.ObjectKeyReason1,639 xx.ObjectKeyReason2640 FROM dbo.GEN_FTEY8D93A3D46765A5490FA4FC(@uid_person,641 @ObjectKeyToInspect) AS xx642 GOTO EndLabel643 END644 -- LocalityHasQERReuseUS645 IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasESet</T>%'646 BEGIN647 INSERT INTO @erg(ObjectKeyReason1,648 ObjectKeyReason2)649 SELECT650 DISTINCT xx.ObjectKeyReason1,651 xx.ObjectKeyReason2652 FROM dbo.GEN_FTEY9C5A940806B98C76B45A28(@uid_person,653 @ObjectKeyToInspect) AS xx654 GOTO EndLabel655 END656 -- PersonHasESet657 IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasQERAssign</T>%'658 BEGIN659 INSERT INTO @erg(ObjectKeyReason1,660 ObjectKeyReason2)661 SELECT662 DISTINCT xx.ObjectKeyReason1,663 xx.ObjectKeyReason2664 FROM dbo.GEN_FTEY6A4C3C6E502E007685003B(@uid_person,665 @ObjectKeyToInspect) AS xx666 GOTO EndLabel667 END668 -- PersonHasQERAssign669 IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasQERResource</T>%'670 BEGIN671 INSERT INTO @erg(ObjectKeyReason1,672 ObjectKeyReason2)673 SELECT674 DISTINCT xx.ObjectKeyReason1,675 xx.ObjectKeyReason2676 FROM dbo.GEN_FTEYE3300D332EFDFCD61A0A1F(@uid_person,677 @ObjectKeyToInspect) AS xx678 GOTO EndLabel679 END680 -- PersonHasQERResource681 IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasQERReuse</T>%'682 BEGIN683 INSERT INTO @erg(ObjectKeyReason1,684 ObjectKeyReason2)685 SELECT686 DISTINCT xx.ObjectKeyReason1,687 xx.ObjectKeyReason2688 FROM dbo.GEN_FTEY603E46E7D17851CEECD074(@uid_person,689 @ObjectKeyToInspect) AS xx690 GOTO EndLabel691 END692 -- PersonHasQERReuse693 IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasQERReuseUS</T>%'694 BEGIN695 INSERT INTO @erg(ObjectKeyReason1,696 ObjectKeyReason2)697 SELECT698 DISTINCT xx.ObjectKeyReason1,699 xx.ObjectKeyReason2700 FROM dbo.GEN_FTEY32246AB0D1EBEA0EF689F3(@uid_person,701 @ObjectKeyToInspect) AS xx702 GOTO EndLabel703 END704 -- PersonHasQERReuseUS705 IF @ObjectKeyToInspect LIKE '<Key><T>PersonInAERole</T>%'706 BEGIN707 INSERT INTO @erg(ObjectKeyReason1,708 ObjectKeyReason2)709 SELECT710 DISTINCT xx.ObjectKeyReason1,711 xx.ObjectKeyReason2712 FROM dbo.GEN_FTEYC455A197F1F99E91DE3119(@uid_person,713 @ObjectKeyToInspect) AS xx714 GOTO EndLabel715 END716 -- PersonInAERole717 IF @ObjectKeyToInspect LIKE '<Key><T>PersonInDepartment</T>%'718 BEGIN719 INSERT INTO @erg(ObjectKeyReason1,720 ObjectKeyReason2)721 SELECT722 DISTINCT xx.ObjectKeyReason1,723 xx.ObjectKeyReason2724 FROM dbo.GEN_FTEY4926D9B896C39764C9EF8F(@uid_person,725 @ObjectKeyToInspect) AS xx726 GOTO EndLabel727 END728 -- PersonInDepartment729 IF @ObjectKeyToInspect LIKE '<Key><T>PersonInITShopOrg</T>%'730 BEGIN731 INSERT INTO @erg(ObjectKeyReason1,732 ObjectKeyReason2)733 SELECT734 DISTINCT xx.ObjectKeyReason1,735 xx.ObjectKeyReason2736 FROM dbo.GEN_FTEYF919254F951A7A5DF6B821(@uid_person,737 @ObjectKeyToInspect) AS xx738 GOTO EndLabel739 END740 -- PersonInITShopOrg741 IF @ObjectKeyToInspect LIKE '<Key><T>PersonInLocality</T>%'742 BEGIN743 INSERT INTO @erg(ObjectKeyReason1,744 ObjectKeyReason2)745 SELECT746 DISTINCT xx.ObjectKeyReason1,747 xx.ObjectKeyReason2748 FROM dbo.GEN_FTEY44E94D0D92A82BFECD72B7(@uid_person,749 @ObjectKeyToInspect) AS xx750 GOTO EndLabel751 END752 -- PersonInLocality753 IF @ObjectKeyToInspect LIKE '<Key><T>PersonInProfitCenter</T>%'754 BEGIN755 INSERT INTO @erg(ObjectKeyReason1,756 ObjectKeyReason2)757 SELECT758 DISTINCT xx.ObjectKeyReason1,759 xx.ObjectKeyReason2760 FROM dbo.GEN_FTEY95A0CB3F5C230BAF81B16E(@uid_person,761 @ObjectKeyToInspect) AS xx762 GOTO EndLabel763 END764 -- PersonInProfitCenter765 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenter</T>%'766 BEGIN767 INSERT INTO @erg(ObjectKeyReason1,768 ObjectKeyReason2)769 SELECT770 DISTINCT xx.ObjectKeyReason1,771 xx.ObjectKeyReason2772 FROM dbo.GEN_FTEY7FBACBED2AE88C3A9756AD(@uid_person,773 @ObjectKeyToInspect) AS xx774 GOTO EndLabel775 END776 -- ProfitCenter777 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasQERAssign</T>%'778 BEGIN779 INSERT INTO @erg(ObjectKeyReason1,780 ObjectKeyReason2)781 SELECT782 DISTINCT xx.ObjectKeyReason1,783 xx.ObjectKeyReason2784 FROM dbo.GEN_FTEYB84C3B21509F1AA07885F7(@uid_person,785 @ObjectKeyToInspect) AS xx786 GOTO EndLabel787 END788 -- ProfitCenterHasQERAssign789 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasQERResource</T>%'790 BEGIN791 INSERT INTO @erg(ObjectKeyReason1,792 ObjectKeyReason2)793 SELECT794 DISTINCT xx.ObjectKeyReason1,795 xx.ObjectKeyReason2796 FROM dbo.GEN_FTEYD1337EF6C6FC4CB197D0D2(@uid_person,797 @ObjectKeyToInspect) AS xx798 GOTO EndLabel799 END800 -- ProfitCenterHasQERResource801 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasQERReuse</T>%'802 BEGIN803 INSERT INTO @erg(ObjectKeyReason1,804 ObjectKeyReason2)805 SELECT806 DISTINCT xx.ObjectKeyReason1,807 xx.ObjectKeyReason2808 FROM dbo.GEN_FTEY362F968B4687C8212EF4EF(@uid_person,809 @ObjectKeyToInspect) AS xx810 GOTO EndLabel811 END812 -- ProfitCenterHasQERReuse813 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasQERReuseUS</T>%'814 BEGIN815 INSERT INTO @erg(ObjectKeyReason1,816 ObjectKeyReason2)817 SELECT818 DISTINCT xx.ObjectKeyReason1,819 xx.ObjectKeyReason2820 FROM dbo.GEN_FTEYF710376B9619AA2464A2B2(@uid_person,821 @ObjectKeyToInspect) AS xx822 GOTO EndLabel823 END824 -- ProfitCenterHasQERReuseUS825 IF @ObjectKeyToInspect LIKE '<Key><T>QERAssign</T>%'826 BEGIN827 INSERT INTO @erg(ObjectKeyReason1,828 ObjectKeyReason2)829 SELECT830 DISTINCT xx.ObjectKeyReason1,831 xx.ObjectKeyReason2832 FROM dbo.GEN_FTEY7C0A8CD265F459125E08F4(@uid_person,833 @ObjectKeyToInspect) AS xx834 GOTO EndLabel835 END836 -- QERAssign837 IF @ObjectKeyToInspect LIKE '<Key><T>QERResource</T>%'838 BEGIN839 INSERT INTO @erg(ObjectKeyReason1,840 ObjectKeyReason2)841 SELECT842 DISTINCT xx.ObjectKeyReason1,843 xx.ObjectKeyReason2844 FROM dbo.GEN_FTEY57C35E74C42BCE83936653(@uid_person,845 @ObjectKeyToInspect) AS xx846 GOTO EndLabel847 END848 -- QERResource849 IF @ObjectKeyToInspect LIKE '<Key><T>QERReuse</T>%'850 BEGIN851 INSERT INTO @erg(ObjectKeyReason1,852 ObjectKeyReason2)853 SELECT854 DISTINCT xx.ObjectKeyReason1,855 xx.ObjectKeyReason2856 FROM dbo.GEN_FTEYB8BBCF8E8E26BBED8671F5(@uid_person,857 @ObjectKeyToInspect) AS xx858 GOTO EndLabel859 END860 -- QERReuse861 IF @ObjectKeyToInspect LIKE '<Key><T>QERReuseUS</T>%'862 BEGIN863 INSERT INTO @erg(ObjectKeyReason1,864 ObjectKeyReason2)865 SELECT866 DISTINCT xx.ObjectKeyReason1,867 xx.ObjectKeyReason2868 FROM dbo.GEN_FTEY0D204A0FA588A619EB3F7B(@uid_person,869 @ObjectKeyToInspect) AS xx870 GOTO EndLabel871 END872 -- QERReuseUS873 IF @ObjectKeyToInspect LIKE '<Key><T>Org</T>%'874 BEGIN875 INSERT INTO @erg(ObjectKeyReason1,876 ObjectKeyReason2)877 SELECT878 DISTINCT xx.ObjectKeyReason1,879 xx.ObjectKeyReason2880 FROM dbo.GEN_FTEYFECC3EA95617D69C0478E1(@uid_person,881 @ObjectKeyToInspect) AS xx882 GOTO EndLabel883 END884 -- Org885 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasQERAssign</T>%'886 BEGIN887 INSERT INTO @erg(ObjectKeyReason1,888 ObjectKeyReason2)889 SELECT890 DISTINCT xx.ObjectKeyReason1,891 xx.ObjectKeyReason2892 FROM dbo.GEN_FTEYED8E405E523D8D627BD65F(@uid_person,893 @ObjectKeyToInspect) AS xx894 GOTO EndLabel895 END896 -- OrgHasQERAssign897 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasQERResource</T>%'898 BEGIN899 INSERT INTO @erg(ObjectKeyReason1,900 ObjectKeyReason2)901 SELECT902 DISTINCT xx.ObjectKeyReason1,903 xx.ObjectKeyReason2904 FROM dbo.GEN_FTEY5F7DBF32525FD5E76002A3(@uid_person,905 @ObjectKeyToInspect) AS xx906 GOTO EndLabel907 END908 -- OrgHasQERResource909 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasQERReuse</T>%'910 BEGIN911 INSERT INTO @erg(ObjectKeyReason1,912 ObjectKeyReason2)913 SELECT914 DISTINCT xx.ObjectKeyReason1,915 xx.ObjectKeyReason2916 FROM dbo.GEN_FTEY3119E9B9D28BDAB8DBBB2F(@uid_person,917 @ObjectKeyToInspect) AS xx918 GOTO EndLabel919 END920 -- OrgHasQERReuse921 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasQERReuseUS</T>%'922 BEGIN923 INSERT INTO @erg(ObjectKeyReason1,924 ObjectKeyReason2)925 SELECT926 DISTINCT xx.ObjectKeyReason1,927 xx.ObjectKeyReason2928 FROM dbo.GEN_FTEYF7783E5B8726C9CAE353D8(@uid_person,929 @ObjectKeyToInspect) AS xx930 GOTO EndLabel931 END932 -- OrgHasQERReuseUS933 IF @ObjectKeyToInspect LIKE '<Key><T>PersonInOrg</T>%'934 BEGIN935 INSERT INTO @erg(ObjectKeyReason1,936 ObjectKeyReason2)937 SELECT938 DISTINCT xx.ObjectKeyReason1,939 xx.ObjectKeyReason2940 FROM dbo.GEN_FTEY365A3E48EE0118A0F8B4E2(@uid_person,941 @ObjectKeyToInspect) AS xx942 GOTO EndLabel943 END944 -- PersonInOrg945 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasESet</T>%'946 BEGIN947 INSERT INTO @erg(ObjectKeyReason1,948 ObjectKeyReason2)949 SELECT950 DISTINCT xx.ObjectKeyReason1,951 xx.ObjectKeyReason2952 FROM dbo.GEN_FTEY9E3743EF4FD0926C4FD5DE(@uid_person,953 @ObjectKeyToInspect) AS xx954 GOTO EndLabel955 END956 -- DepartmentHasESet957 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasESet</T>%'958 BEGIN959 INSERT INTO @erg(ObjectKeyReason1,960 ObjectKeyReason2)961 SELECT962 DISTINCT xx.ObjectKeyReason1,963 xx.ObjectKeyReason2964 FROM dbo.GEN_FTEY0BCBB74461782A260ACBBA(@uid_person,965 @ObjectKeyToInspect) AS xx966 GOTO EndLabel967 END968 -- ITShopOrgHasESet969 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasESet</T>%'970 BEGIN971 INSERT INTO @erg(ObjectKeyReason1,972 ObjectKeyReason2)973 SELECT974 DISTINCT xx.ObjectKeyReason1,975 xx.ObjectKeyReason2976 FROM dbo.GEN_FTEY08F52C68A60DA875F2F6BB(@uid_person,977 @ObjectKeyToInspect) AS xx978 GOTO EndLabel979 END980 -- ITShopSrcHasESet981 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasESet</T>%'982 BEGIN983 INSERT INTO @erg(ObjectKeyReason1,984 ObjectKeyReason2)985 SELECT986 DISTINCT xx.ObjectKeyReason1,987 xx.ObjectKeyReason2988 FROM dbo.GEN_FTEY54D7FCA2E89FC59ACF04B8(@uid_person,989 @ObjectKeyToInspect) AS xx990 GOTO EndLabel991 END992 -- LocalityHasESet993 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasESet</T>%'994 BEGIN995 INSERT INTO @erg(ObjectKeyReason1,996 ObjectKeyReason2)997 SELECT998 DISTINCT xx.ObjectKeyReason1,999 xx.ObjectKeyReason21000 FROM dbo.GEN_FTEY654CCD699AC827FB59CD22(@uid_person,1001 @ObjectKeyToInspect) AS xx1002 GOTO EndLabel1003 END1004 -- OrgHasESet1005 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasESet</T>%'1006 BEGIN1007 INSERT INTO @erg(ObjectKeyReason1,1008 ObjectKeyReason2)1009 SELECT1010 DISTINCT xx.ObjectKeyReason1,1011 xx.ObjectKeyReason21012 FROM dbo.GEN_FTEYFA544B1011E4A042348A0E(@uid_person,1013 @ObjectKeyToInspect) AS xx1014 GOTO EndLabel1015 END1016 -- ProfitCenterHasESet1017 IF @ObjectKeyToInspect LIKE '<Key><T>AERoleHasRPSReport</T>%'1018 BEGIN1019 INSERT INTO @erg(ObjectKeyReason1,1020 ObjectKeyReason2)1021 SELECT1022 DISTINCT xx.ObjectKeyReason1,1023 xx.ObjectKeyReason21024 FROM dbo.GEN_FTEY01FB8D175B472AFAC4FBBD(@uid_person,1025 @ObjectKeyToInspect) AS xx1026 GOTO EndLabel1027 END1028 -- AERoleHasRPSReport1029 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasRPSReport</T>%'1030 BEGIN1031 INSERT INTO @erg(ObjectKeyReason1,1032 ObjectKeyReason2)1033 SELECT1034 DISTINCT xx.ObjectKeyReason1,1035 xx.ObjectKeyReason21036 FROM dbo.GEN_FTEY5A3D5445A31314E3C80820(@uid_person,1037 @ObjectKeyToInspect) AS xx1038 GOTO EndLabel1039 END1040 -- DepartmentHasRPSReport1041 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasRPSReport</T>%'1042 BEGIN1043 INSERT INTO @erg(ObjectKeyReason1,1044 ObjectKeyReason2)1045 SELECT1046 DISTINCT xx.ObjectKeyReason1,1047 xx.ObjectKeyReason21048 FROM dbo.GEN_FTEYA98DB5E80EFE54297AA0A8(@uid_person,1049 @ObjectKeyToInspect) AS xx1050 GOTO EndLabel1051 END1052 -- ITShopOrgHasRPSReport1053 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasRPSReport</T>%'1054 BEGIN1055 INSERT INTO @erg(ObjectKeyReason1,1056 ObjectKeyReason2)1057 SELECT1058 DISTINCT xx.ObjectKeyReason1,1059 xx.ObjectKeyReason21060 FROM dbo.GEN_FTEY896E146F4F840E422CCBA3(@uid_person,1061 @ObjectKeyToInspect) AS xx1062 GOTO EndLabel1063 END1064 -- ITShopSrcHasRPSReport1065 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasRPSReport</T>%'1066 BEGIN1067 INSERT INTO @erg(ObjectKeyReason1,1068 ObjectKeyReason2)1069 SELECT1070 DISTINCT xx.ObjectKeyReason1,1071 xx.ObjectKeyReason21072 FROM dbo.GEN_FTEY680B289738F51B38B41A7B(@uid_person,1073 @ObjectKeyToInspect) AS xx1074 GOTO EndLabel1075 END1076 -- LocalityHasRPSReport1077 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasRPSReport</T>%'1078 BEGIN1079 INSERT INTO @erg(ObjectKeyReason1,1080 ObjectKeyReason2)1081 SELECT1082 DISTINCT xx.ObjectKeyReason1,1083 xx.ObjectKeyReason21084 FROM dbo.GEN_FTEY5082C636ECA32E1D797C16(@uid_person,1085 @ObjectKeyToInspect) AS xx1086 GOTO EndLabel1087 END1088 -- OrgHasRPSReport1089 IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasRPSReport</T>%'1090 BEGIN1091 INSERT INTO @erg(ObjectKeyReason1,1092 ObjectKeyReason2)1093 SELECT1094 DISTINCT xx.ObjectKeyReason1,1095 xx.ObjectKeyReason21096 FROM dbo.GEN_FTEY94A1455D19630D9B5E3446(@uid_person,1097 @ObjectKeyToInspect) AS xx1098 GOTO EndLabel1099 END1100 -- PersonHasRPSReport1101 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasRPSReport</T>%'1102 BEGIN1103 INSERT INTO @erg(ObjectKeyReason1,1104 ObjectKeyReason2)1105 SELECT1106 DISTINCT xx.ObjectKeyReason1,1107 xx.ObjectKeyReason21108 FROM dbo.GEN_FTEY334AF4B7AAF5D1C1085331(@uid_person,1109 @ObjectKeyToInspect) AS xx1110 GOTO EndLabel1111 END1112 -- ProfitCenterHasRPSReport1113 IF @ObjectKeyToInspect LIKE '<Key><T>RPSReport</T>%'1114 BEGIN1115 INSERT INTO @erg(ObjectKeyReason1,1116 ObjectKeyReason2)1117 SELECT1118 DISTINCT xx.ObjectKeyReason1,1119 xx.ObjectKeyReason21120 FROM dbo.GEN_FTEYD9F80E09EE41CB3418962A(@uid_person,1121 @ObjectKeyToInspect) AS xx1122 GOTO EndLabel1123 END1124 -- RPSReport1125 IF @ObjectKeyToInspect LIKE '<Key><T>AERoleHasTSBAccountDef</T>%'1126 BEGIN1127 INSERT INTO @erg(ObjectKeyReason1,1128 ObjectKeyReason2)1129 SELECT1130 DISTINCT xx.ObjectKeyReason1,1131 xx.ObjectKeyReason21132 FROM dbo.GEN_FTEY197EC6A22EFCA0F37E16F8(@uid_person,1133 @ObjectKeyToInspect) AS xx1134 GOTO EndLabel1135 END1136 -- AERoleHasTSBAccountDef1137 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasTSBAccountDef</T>%'1138 BEGIN1139 INSERT INTO @erg(ObjectKeyReason1,1140 ObjectKeyReason2)1141 SELECT1142 DISTINCT xx.ObjectKeyReason1,1143 xx.ObjectKeyReason21144 FROM dbo.GEN_FTEYAD3637368C48BBEA6B8D71(@uid_person,1145 @ObjectKeyToInspect) AS xx1146 GOTO EndLabel1147 END1148 -- DepartmentHasTSBAccountDef1149 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasUNSGroupB</T>%'1150 BEGIN1151 INSERT INTO @erg(ObjectKeyReason1,1152 ObjectKeyReason2)1153 SELECT1154 DISTINCT xx.ObjectKeyReason1,1155 xx.ObjectKeyReason21156 FROM dbo.GEN_FTEY8B9BB6E0E5756FA8FC6CBF(@uid_person,1157 @ObjectKeyToInspect) AS xx1158 GOTO EndLabel1159 END1160 -- DepartmentHasUNSGroupB1161 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasUNSGroupB1</T>%'1162 BEGIN1163 INSERT INTO @erg(ObjectKeyReason1,1164 ObjectKeyReason2)1165 SELECT1166 DISTINCT xx.ObjectKeyReason1,1167 xx.ObjectKeyReason21168 FROM dbo.GEN_FTEY93C83068790E482B9BC48A(@uid_person,1169 @ObjectKeyToInspect) AS xx1170 GOTO EndLabel1171 END1172 -- DepartmentHasUNSGroupB11173 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasUNSGroupB2</T>%'1174 BEGIN1175 INSERT INTO @erg(ObjectKeyReason1,1176 ObjectKeyReason2)1177 SELECT1178 DISTINCT xx.ObjectKeyReason1,1179 xx.ObjectKeyReason21180 FROM dbo.GEN_FTEYF56DD909CB94BEEC756652(@uid_person,1181 @ObjectKeyToInspect) AS xx1182 GOTO EndLabel1183 END1184 -- DepartmentHasUNSGroupB21185 IF @ObjectKeyToInspect LIKE '<Key><T>DepartmentHasUNSGroupB3</T>%'1186 BEGIN1187 INSERT INTO @erg(ObjectKeyReason1,1188 ObjectKeyReason2)1189 SELECT1190 DISTINCT xx.ObjectKeyReason1,1191 xx.ObjectKeyReason21192 FROM dbo.GEN_FTEY6A01F15B07CC9CBEDA919D(@uid_person,1193 @ObjectKeyToInspect) AS xx1194 GOTO EndLabel1195 END1196 -- DepartmentHasUNSGroupB31197 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasTSBAccountDef</T>%'1198 BEGIN1199 INSERT INTO @erg(ObjectKeyReason1,1200 ObjectKeyReason2)1201 SELECT1202 DISTINCT xx.ObjectKeyReason1,1203 xx.ObjectKeyReason21204 FROM dbo.GEN_FTEY7E63AC104BE0F8468C3926(@uid_person,1205 @ObjectKeyToInspect) AS xx1206 GOTO EndLabel1207 END1208 -- ITShopOrgHasTSBAccountDef1209 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasUNSGroupB</T>%'1210 BEGIN1211 INSERT INTO @erg(ObjectKeyReason1,1212 ObjectKeyReason2)1213 SELECT1214 DISTINCT xx.ObjectKeyReason1,1215 xx.ObjectKeyReason21216 FROM dbo.GEN_FTEYFCC9AEDF028F5733EA1762(@uid_person,1217 @ObjectKeyToInspect) AS xx1218 GOTO EndLabel1219 END1220 -- ITShopOrgHasUNSGroupB1221 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasUNSGroupB1</T>%'1222 BEGIN1223 INSERT INTO @erg(ObjectKeyReason1,1224 ObjectKeyReason2)1225 SELECT1226 DISTINCT xx.ObjectKeyReason1,1227 xx.ObjectKeyReason21228 FROM dbo.GEN_FTEYE5C106C07A55319D2D1F4C(@uid_person,1229 @ObjectKeyToInspect) AS xx1230 GOTO EndLabel1231 END1232 -- ITShopOrgHasUNSGroupB11233 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasUNSGroupB2</T>%'1234 BEGIN1235 INSERT INTO @erg(ObjectKeyReason1,1236 ObjectKeyReason2)1237 SELECT1238 DISTINCT xx.ObjectKeyReason1,1239 xx.ObjectKeyReason21240 FROM dbo.GEN_FTEYA0EB22774E297DA91E86F4(@uid_person,1241 @ObjectKeyToInspect) AS xx1242 GOTO EndLabel1243 END1244 -- ITShopOrgHasUNSGroupB21245 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopOrgHasUNSGroupB3</T>%'1246 BEGIN1247 INSERT INTO @erg(ObjectKeyReason1,1248 ObjectKeyReason2)1249 SELECT1250 DISTINCT xx.ObjectKeyReason1,1251 xx.ObjectKeyReason21252 FROM dbo.GEN_FTEYD9E45B5BA3CF3011E79360(@uid_person,1253 @ObjectKeyToInspect) AS xx1254 GOTO EndLabel1255 END1256 -- ITShopOrgHasUNSGroupB31257 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasTSBAccountDef</T>%'1258 BEGIN1259 INSERT INTO @erg(ObjectKeyReason1,1260 ObjectKeyReason2)1261 SELECT1262 DISTINCT xx.ObjectKeyReason1,1263 xx.ObjectKeyReason21264 FROM dbo.GEN_FTEYAF3582CAD04010AC5744C9(@uid_person,1265 @ObjectKeyToInspect) AS xx1266 GOTO EndLabel1267 END1268 -- ITShopSrcHasTSBAccountDef1269 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasUNSGroupB</T>%'1270 BEGIN1271 INSERT INTO @erg(ObjectKeyReason1,1272 ObjectKeyReason2)1273 SELECT1274 DISTINCT xx.ObjectKeyReason1,1275 xx.ObjectKeyReason21276 FROM dbo.GEN_FTEY921BCCEECC644676A5E2D4(@uid_person,1277 @ObjectKeyToInspect) AS xx1278 GOTO EndLabel1279 END1280 -- ITShopSrcHasUNSGroupB1281 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasUNSGroupB1</T>%'1282 BEGIN1283 INSERT INTO @erg(ObjectKeyReason1,1284 ObjectKeyReason2)1285 SELECT1286 DISTINCT xx.ObjectKeyReason1,1287 xx.ObjectKeyReason21288 FROM dbo.GEN_FTEYDE839AC5FDDF3A157A16AF(@uid_person,1289 @ObjectKeyToInspect) AS xx1290 GOTO EndLabel1291 END1292 -- ITShopSrcHasUNSGroupB11293 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasUNSGroupB2</T>%'1294 BEGIN1295 INSERT INTO @erg(ObjectKeyReason1,1296 ObjectKeyReason2)1297 SELECT1298 DISTINCT xx.ObjectKeyReason1,1299 xx.ObjectKeyReason21300 FROM dbo.GEN_FTEY0BA325EDC97A6511B77954(@uid_person,1301 @ObjectKeyToInspect) AS xx1302 GOTO EndLabel1303 END1304 -- ITShopSrcHasUNSGroupB21305 IF @ObjectKeyToInspect LIKE '<Key><T>ITShopSrcHasUNSGroupB3</T>%'1306 BEGIN1307 INSERT INTO @erg(ObjectKeyReason1,1308 ObjectKeyReason2)1309 SELECT1310 DISTINCT xx.ObjectKeyReason1,1311 xx.ObjectKeyReason21312 FROM dbo.GEN_FTEY1259C3D6106F88D3FE81C1(@uid_person,1313 @ObjectKeyToInspect) AS xx1314 GOTO EndLabel1315 END1316 -- ITShopSrcHasUNSGroupB31317 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasTSBAccountDef</T>%'1318 BEGIN1319 INSERT INTO @erg(ObjectKeyReason1,1320 ObjectKeyReason2)1321 SELECT1322 DISTINCT xx.ObjectKeyReason1,1323 xx.ObjectKeyReason21324 FROM dbo.GEN_FTEY1C7461F2680F62B272D390(@uid_person,1325 @ObjectKeyToInspect) AS xx1326 GOTO EndLabel1327 END1328 -- LocalityHasTSBAccountDef1329 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasUNSGroupB</T>%'1330 BEGIN1331 INSERT INTO @erg(ObjectKeyReason1,1332 ObjectKeyReason2)1333 SELECT1334 DISTINCT xx.ObjectKeyReason1,1335 xx.ObjectKeyReason21336 FROM dbo.GEN_FTEYACAC5700ABF0D42F65529A(@uid_person,1337 @ObjectKeyToInspect) AS xx1338 GOTO EndLabel1339 END1340 -- LocalityHasUNSGroupB1341 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasUNSGroupB1</T>%'1342 BEGIN1343 INSERT INTO @erg(ObjectKeyReason1,1344 ObjectKeyReason2)1345 SELECT1346 DISTINCT xx.ObjectKeyReason1,1347 xx.ObjectKeyReason21348 FROM dbo.GEN_FTEYF634ACF893A3AC13026A99(@uid_person,1349 @ObjectKeyToInspect) AS xx1350 GOTO EndLabel1351 END1352 -- LocalityHasUNSGroupB11353 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasUNSGroupB2</T>%'1354 BEGIN1355 INSERT INTO @erg(ObjectKeyReason1,1356 ObjectKeyReason2)1357 SELECT1358 DISTINCT xx.ObjectKeyReason1,1359 xx.ObjectKeyReason21360 FROM dbo.GEN_FTEY15CB642D7F87E41BF86FE8(@uid_person,1361 @ObjectKeyToInspect) AS xx1362 GOTO EndLabel1363 END1364 -- LocalityHasUNSGroupB21365 IF @ObjectKeyToInspect LIKE '<Key><T>LocalityHasUNSGroupB3</T>%'1366 BEGIN1367 INSERT INTO @erg(ObjectKeyReason1,1368 ObjectKeyReason2)1369 SELECT1370 DISTINCT xx.ObjectKeyReason1,1371 xx.ObjectKeyReason21372 FROM dbo.GEN_FTEYAD6AB0B9B040433F113D36(@uid_person,1373 @ObjectKeyToInspect) AS xx1374 GOTO EndLabel1375 END1376 -- LocalityHasUNSGroupB31377 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasTSBAccountDef</T>%'1378 BEGIN1379 INSERT INTO @erg(ObjectKeyReason1,1380 ObjectKeyReason2)1381 SELECT1382 DISTINCT xx.ObjectKeyReason1,1383 xx.ObjectKeyReason21384 FROM dbo.GEN_FTEY6899BC09F309C000CB6007(@uid_person,1385 @ObjectKeyToInspect) AS xx1386 GOTO EndLabel1387 END1388 -- OrgHasTSBAccountDef1389 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasUNSGroupB</T>%'1390 BEGIN1391 INSERT INTO @erg(ObjectKeyReason1,1392 ObjectKeyReason2)1393 SELECT1394 DISTINCT xx.ObjectKeyReason1,1395 xx.ObjectKeyReason21396 FROM dbo.GEN_FTEY0BAF2057553029E6B0BFCD(@uid_person,1397 @ObjectKeyToInspect) AS xx1398 GOTO EndLabel1399 END1400 -- OrgHasUNSGroupB1401 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasUNSGroupB1</T>%'1402 BEGIN1403 INSERT INTO @erg(ObjectKeyReason1,1404 ObjectKeyReason2)1405 SELECT1406 DISTINCT xx.ObjectKeyReason1,1407 xx.ObjectKeyReason21408 FROM dbo.GEN_FTEY9AA9267513A52C463DBAB1(@uid_person,1409 @ObjectKeyToInspect) AS xx1410 GOTO EndLabel1411 END1412 -- OrgHasUNSGroupB11413 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasUNSGroupB2</T>%'1414 BEGIN1415 INSERT INTO @erg(ObjectKeyReason1,1416 ObjectKeyReason2)1417 SELECT1418 DISTINCT xx.ObjectKeyReason1,1419 xx.ObjectKeyReason21420 FROM dbo.GEN_FTEYB5C2BEFDF41A038B6E4E8F(@uid_person,1421 @ObjectKeyToInspect) AS xx1422 GOTO EndLabel1423 END1424 -- OrgHasUNSGroupB21425 IF @ObjectKeyToInspect LIKE '<Key><T>OrgHasUNSGroupB3</T>%'1426 BEGIN1427 INSERT INTO @erg(ObjectKeyReason1,1428 ObjectKeyReason2)1429 SELECT1430 DISTINCT xx.ObjectKeyReason1,1431 xx.ObjectKeyReason21432 FROM dbo.GEN_FTEY53D8D792B6515142C31909(@uid_person,1433 @ObjectKeyToInspect) AS xx1434 GOTO EndLabel1435 END1436 -- OrgHasUNSGroupB31437 IF @ObjectKeyToInspect LIKE '<Key><T>PersonHasTSBAccountDef</T>%'1438 BEGIN1439 INSERT INTO @erg(ObjectKeyReason1,1440 ObjectKeyReason2)1441 SELECT1442 DISTINCT xx.ObjectKeyReason1,1443 xx.ObjectKeyReason21444 FROM dbo.GEN_FTEYD1570666C15F0F46905354(@uid_person,1445 @ObjectKeyToInspect) AS xx1446 GOTO EndLabel1447 END1448 -- PersonHasTSBAccountDef1449 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasTSBAccountDef</T>%'1450 BEGIN1451 INSERT INTO @erg(ObjectKeyReason1,1452 ObjectKeyReason2)1453 SELECT1454 DISTINCT xx.ObjectKeyReason1,1455 xx.ObjectKeyReason21456 FROM dbo.GEN_FTEY75C7B00B32C74FA8C734A8(@uid_person,1457 @ObjectKeyToInspect) AS xx1458 GOTO EndLabel1459 END1460 -- ProfitCenterHasTSBAccountDef1461 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasUNSGroupB</T>%'1462 BEGIN1463 INSERT INTO @erg(ObjectKeyReason1,1464 ObjectKeyReason2)1465 SELECT1466 DISTINCT xx.ObjectKeyReason1,1467 xx.ObjectKeyReason21468 FROM dbo.GEN_FTEY73F83A16FCB3159A7F6DF1(@uid_person,1469 @ObjectKeyToInspect) AS xx1470 GOTO EndLabel1471 END1472 -- ProfitCenterHasUNSGroupB1473 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasUNSGroupB1</T>%'1474 BEGIN1475 INSERT INTO @erg(ObjectKeyReason1,1476 ObjectKeyReason2)1477 SELECT1478 DISTINCT xx.ObjectKeyReason1,1479 xx.ObjectKeyReason21480 FROM dbo.GEN_FTEYA17794B9D95EE8DD144E94(@uid_person,1481 @ObjectKeyToInspect) AS xx1482 GOTO EndLabel1483 END1484 -- ProfitCenterHasUNSGroupB11485 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasUNSGroupB2</T>%'1486 BEGIN1487 INSERT INTO @erg(ObjectKeyReason1,1488 ObjectKeyReason2)1489 SELECT1490 DISTINCT xx.ObjectKeyReason1,1491 xx.ObjectKeyReason21492 FROM dbo.GEN_FTEY68B364EED5084A7D5D23F3(@uid_person,1493 @ObjectKeyToInspect) AS xx1494 GOTO EndLabel1495 END1496 -- ProfitCenterHasUNSGroupB21497 IF @ObjectKeyToInspect LIKE '<Key><T>ProfitCenterHasUNSGroupB3</T>%'1498 BEGIN1499 INSERT INTO @erg(ObjectKeyReason1,1500 ObjectKeyReason2)1501 SELECT1502 DISTINCT xx.ObjectKeyReason1,1503 xx.ObjectKeyReason21504 FROM dbo.GEN_FTEYB7D9F2A88D2BEE2704FF81(@uid_person,1505 @ObjectKeyToInspect) AS xx1506 GOTO EndLabel1507 END1508 -- ProfitCenterHasUNSGroupB31509 IF @ObjectKeyToInspect LIKE '<Key><T>TSBAccountDef</T>%'1510 BEGIN1511 INSERT INTO @erg(ObjectKeyReason1,1512 ObjectKeyReason2)1513 SELECT1514 DISTINCT xx.ObjectKeyReason1,1515 xx.ObjectKeyReason21516 FROM dbo.GEN_FTEY7166BBF7E8B4003DCA4B3D(@uid_person,1517 @ObjectKeyToInspect) AS xx1518 GOTO EndLabel1519 END1520 -- TSBAccountDef1521 IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountB</T>%'1522 BEGIN1523 INSERT INTO @erg(ObjectKeyReason1,1524 ObjectKeyReason2)1525 SELECT1526 DISTINCT xx.ObjectKeyReason1,1527 xx.ObjectKeyReason21528 FROM dbo.GEN_FTEY60473E8B8DB38BF7C1CCE3(@uid_person,1529 @ObjectKeyToInspect) AS xx1530 GOTO EndLabel1531 END1532 -- UNSAccountB1533 IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBHasUNSGroupB</T>%'1534 BEGIN1535 INSERT INTO @erg(ObjectKeyReason1,1536 ObjectKeyReason2)1537 SELECT1538 DISTINCT xx.ObjectKeyReason1,1539 xx.ObjectKeyReason21540 FROM dbo.GEN_FTEY1651DF0943C389DD296ADE(@uid_person,1541 @ObjectKeyToInspect) AS xx1542 GOTO EndLabel1543 END1544 -- UNSAccountBHasUNSGroupB1545 IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBHasUNSGroupB1</T>%'1546 BEGIN1547 INSERT INTO @erg(ObjectKeyReason1,1548 ObjectKeyReason2)1549 SELECT1550 DISTINCT xx.ObjectKeyReason1,1551 xx.ObjectKeyReason21552 FROM dbo.GEN_FTEY8E0532B844467344E61179(@uid_person,1553 @ObjectKeyToInspect) AS xx1554 GOTO EndLabel1555 END1556 -- UNSAccountBHasUNSGroupB11557 IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBHasUNSGroupB2</T>%'1558 BEGIN1559 INSERT INTO @erg(ObjectKeyReason1,1560 ObjectKeyReason2)1561 SELECT1562 DISTINCT xx.ObjectKeyReason1,1563 xx.ObjectKeyReason21564 FROM dbo.GEN_FTEYCB57F36D8B554BDAEF804B(@uid_person,1565 @ObjectKeyToInspect) AS xx1566 GOTO EndLabel1567 END1568 -- UNSAccountBHasUNSGroupB21569 IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBHasUNSGroupB3</T>%'1570 BEGIN1571 INSERT INTO @erg(ObjectKeyReason1,1572 ObjectKeyReason2)1573 SELECT1574 DISTINCT xx.ObjectKeyReason1,1575 xx.ObjectKeyReason21576 FROM dbo.GEN_FTEYF4FA37E77329315C33C8D5(@uid_person,1577 @ObjectKeyToInspect) AS xx1578 GOTO EndLabel1579 END1580 -- UNSAccountBHasUNSGroupB31581 IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBInUNSGroupB</T>%'1582 BEGIN1583 INSERT INTO @erg(ObjectKeyReason1,1584 ObjectKeyReason2)1585 SELECT1586 DISTINCT xx.ObjectKeyReason1,1587 xx.ObjectKeyReason21588 FROM dbo.GEN_FTEY0122181C230044398280FE(@uid_person,1589 @ObjectKeyToInspect) AS xx1590 GOTO EndLabel1591 END1592 -- UNSAccountBInUNSGroupB1593 IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBInUNSGroupB1</T>%'1594 BEGIN1595 INSERT INTO @erg(ObjectKeyReason1,1596 ObjectKeyReason2)1597 SELECT1598 DISTINCT xx.ObjectKeyReason1,1599 xx.ObjectKeyReason21600 FROM dbo.GEN_FTEY7705EAA3F767C86779D0BD(@uid_person,1601 @ObjectKeyToInspect) AS xx1602 GOTO EndLabel1603 END1604 -- UNSAccountBInUNSGroupB11605 IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBInUNSGroupB2</T>%'1606 BEGIN1607 INSERT INTO @erg(ObjectKeyReason1,1608 ObjectKeyReason2)1609 SELECT1610 DISTINCT xx.ObjectKeyReason1,1611 xx.ObjectKeyReason21612 FROM dbo.GEN_FTEY87AE45C88F8A7904BD9510(@uid_person,1613 @ObjectKeyToInspect) AS xx1614 GOTO EndLabel1615 END1616 -- UNSAccountBInUNSGroupB21617 IF @ObjectKeyToInspect LIKE '<Key><T>UNSAccountBInUNSGroupB3</T>%'1618 BEGIN1619 INSERT INTO @erg(ObjectKeyReason1,1620 ObjectKeyReason2)1621 SELECT1622 DISTINCT xx.ObjectKeyReason1,1623 xx.ObjectKeyReason21624 FROM dbo.GEN_FTEYDAF6E4727A8EAE717E59D7(@uid_person,1625 @ObjectKeyToInspect) AS xx1626 GOTO EndLabel1627 END1628 -- UNSAccountBInUNSGroupB31629 IF @ObjectKeyToInspect LIKE '<Key><T>UNSContainerB</T>%'1630 BEGIN1631 INSERT INTO @erg(ObjectKeyReason1,1632 ObjectKeyReason2)1633 SELECT1634 DISTINCT xx.ObjectKeyReason1,1635 xx.ObjectKeyReason21636 FROM dbo.GEN_FTEYCECC6DB926BCF9648F456B(@uid_person,1637 @ObjectKeyToInspect) AS xx1638 GOTO EndLabel1639 END1640 -- UNSContainerB1641 IF @ObjectKeyToInspect LIKE '<Key><T>UNSGroupB</T>%'1642 BEGIN1643 INSERT INTO @erg(ObjectKeyReason1,1644 ObjectKeyReason2)1645 SELECT1646 DISTINCT xx.ObjectKeyReason1,1647 xx.ObjectKeyReason21648 FROM dbo.GEN_FTEY19AE465A1AEDCAF37D47AC(@uid_person,1649 @ObjectKeyToInspect) AS xx1650 GOTO EndLabel1651 END1652 -- UNSGroupB1653 IF @ObjectKeyToInspect LIKE '<Key><T>UNSGroupB1</T>%'1654 BEGIN1655 INSERT INTO @erg(ObjectKeyReason1,1656 ObjectKeyReason2)1657 SELECT1658 DISTINCT xx.ObjectKeyReason1,1659 xx.ObjectKeyReason21660 FROM dbo.GEN_FTEYB5B79D3FB317B463216F71(@uid_person,1661 @ObjectKeyToInspect) AS xx1662 GOTO EndLabel1663 END1664 -- UNSGroupB11665 IF @ObjectKeyToInspect LIKE '<Key><T>UNSGroupB2</T>%'1666 BEGIN1667 INSERT INTO @erg(ObjectKeyReason1,1668 ObjectKeyReason2)1669 SELECT1670 DISTINCT xx.ObjectKeyReason1,1671 xx.ObjectKeyReason21672 FROM dbo.GEN_FTEY8C8C8E4B72714983D306FB(@uid_person,1673 @ObjectKeyToInspect) AS xx1674 GOTO EndLabel1675 END1676 -- UNSGroupB21677 IF @ObjectKeyToInspect LIKE '<Key><T>UNSGroupB3</T>%'1678 BEGIN1679 INSERT INTO @erg(ObjectKeyReason1,1680 ObjectKeyReason2)1681 SELECT1682 DISTINCT xx.ObjectKeyReason1,1683 xx.ObjectKeyReason21684 FROM dbo.GEN_FTEY9D970CBAA569CA4712CE1A(@uid_person,1685 @ObjectKeyToInspect) AS xx1686 GOTO EndLabel1687 END1688 -- UNSGroupB31689 IF @ObjectKeyToInspect LIKE '<Key><T>UNSRootB</T>%'1690 BEGIN1691 INSERT INTO @erg(ObjectKeyReason1,1692 ObjectKeyReason2)1693 SELECT1694 DISTINCT xx.ObjectKeyReason1,1695 xx.ObjectKeyReason21696 FROM dbo.GEN_FTEY9C537565E770C30AA1EC81(@uid_person,1697 @ObjectKeyToInspect) AS xx1698 GOTO EndLabel1699 END1700 -- UNSRootB1701 --insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1702 --select distinct ObjectKeyReason1, ObjectKeyReason21703 -- from @work1704 EndLabel:1705 RETURN1706END
Open raw exported source
1create function dbo.QER_FTEntitlementSourceWhy(2 @UID_Person varchar(38) 3 , @ObjectKeyToInspect varchar(138)4 )5 returns @erg table (6 ObjectKeyReason1 varchar(138) collate database_default7 , ObjectKeyReason2 varchar(138) collate database_default8 )9 as10begin1112 if @ObjectKeyToInspect like '<Key><T>ADSAccount</T>%'13 begin14 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)15 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason216 from dbo.GEN_FTEY04ACC922CE0D679BFBDF68 (@uid_person, @ObjectKeyToInspect) as xx1718 goto EndLabel1920 end -- ADSAccount2122 if @ObjectKeyToInspect like '<Key><T>ADSAccountInADSGroup</T>%'23 begin24 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)25 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason226 from dbo.GEN_FTEYBC1B1E1153DA0887D6F11C (@uid_person, @ObjectKeyToInspect) as xx2728 goto EndLabel2930 end -- ADSAccountInADSGroup3132 if @ObjectKeyToInspect like '<Key><T>ADSContact</T>%'33 begin34 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)35 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason236 from dbo.GEN_FTEYAFC2B1B0AA231EB7202E0A (@uid_person, @ObjectKeyToInspect) as xx3738 goto EndLabel3940 end -- ADSContact4142 if @ObjectKeyToInspect like '<Key><T>ADSContactInADSGroup</T>%'43 begin44 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)45 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason246 from dbo.GEN_FTEY6CF75B30295FEFA8CD3709 (@uid_person, @ObjectKeyToInspect) as xx4748 goto EndLabel4950 end -- ADSContactInADSGroup5152 if @ObjectKeyToInspect like '<Key><T>ADSContainer</T>%'53 begin54 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)55 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason256 from dbo.GEN_FTEYD067DDDE01113A49AB7F4F (@uid_person, @ObjectKeyToInspect) as xx5758 goto EndLabel5960 end -- ADSContainer6162 if @ObjectKeyToInspect like '<Key><T>ADSDomain</T>%'63 begin64 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)65 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason266 from dbo.GEN_FTEYD1FF94E385FADA2276090E (@uid_person, @ObjectKeyToInspect) as xx6768 goto EndLabel6970 end -- ADSDomain7172 if @ObjectKeyToInspect like '<Key><T>ADSGroup</T>%'73 begin74 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)75 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason276 from dbo.GEN_FTEYEB1C7B5195AE3821552788 (@uid_person, @ObjectKeyToInspect) as xx7778 goto EndLabel7980 end -- ADSGroup8182 if @ObjectKeyToInspect like '<Key><T>DepartmentHasADSGroup</T>%'83 begin84 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)85 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason286 from dbo.GEN_FTEYF1D845A502E28AB8F8B8FA (@uid_person, @ObjectKeyToInspect) as xx8788 goto EndLabel8990 end -- DepartmentHasADSGroup9192 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasADSGroup</T>%'93 begin94 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)95 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason296 from dbo.GEN_FTEY625B5F1743A4CD81DB1A7A (@uid_person, @ObjectKeyToInspect) as xx9798 goto EndLabel99100 end -- ITShopOrgHasADSGroup101102 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasADSGroup</T>%'103 begin104 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)105 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2106 from dbo.GEN_FTEYBE4C4D5B55E47B4A37030F (@uid_person, @ObjectKeyToInspect) as xx107108 goto EndLabel109110 end -- ITShopSrcHasADSGroup111112 if @ObjectKeyToInspect like '<Key><T>LocalityHasADSGroup</T>%'113 begin114 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)115 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2116 from dbo.GEN_FTEY3503043CCF5F62E3FC1EC7 (@uid_person, @ObjectKeyToInspect) as xx117118 goto EndLabel119120 end -- LocalityHasADSGroup121122 if @ObjectKeyToInspect like '<Key><T>OrgHasADSGroup</T>%'123 begin124 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)125 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2126 from dbo.GEN_FTEY11C75B4ECD9BB22D2D748B (@uid_person, @ObjectKeyToInspect) as xx127128 goto EndLabel129130 end -- OrgHasADSGroup131132 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasADSGroup</T>%'133 begin134 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)135 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2136 from dbo.GEN_FTEYE80DDBCEAAA13F1979E711 (@uid_person, @ObjectKeyToInspect) as xx137138 goto EndLabel139140 end -- ProfitCenterHasADSGroup141142 if @ObjectKeyToInspect like '<Key><T>PersonInNonCompliance</T>%'143 begin144 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)145 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2146 from dbo.GEN_FTEYDEBA0F85E016415BA14437 (@uid_person, @ObjectKeyToInspect) as xx147148 goto EndLabel149150 end -- PersonInNonCompliance151152 if @ObjectKeyToInspect like '<Key><T>DepartmentHasLDAPGroup</T>%'153 begin154 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)155 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2156 from dbo.GEN_FTEY780D32B60508B96FB55733 (@uid_person, @ObjectKeyToInspect) as xx157158 goto EndLabel159160 end -- DepartmentHasLDAPGroup161162 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasLDAPGroup</T>%'163 begin164 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)165 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2166 from dbo.GEN_FTEY714650F04D0D2C9ADFD428 (@uid_person, @ObjectKeyToInspect) as xx167168 goto EndLabel169170 end -- ITShopOrgHasLDAPGroup171172 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasLDAPGroup</T>%'173 begin174 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)175 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2176 from dbo.GEN_FTEYFED8D3214C9C1DAFEE2EB0 (@uid_person, @ObjectKeyToInspect) as xx177178 goto EndLabel179180 end -- ITShopSrcHasLDAPGroup181182 if @ObjectKeyToInspect like '<Key><T>LDAPAccount</T>%'183 begin184 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)185 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2186 from dbo.GEN_FTEY3660BE5A72C51D09E109D2 (@uid_person, @ObjectKeyToInspect) as xx187188 goto EndLabel189190 end -- LDAPAccount191192 if @ObjectKeyToInspect like '<Key><T>LDAPAccountInLDAPGroup</T>%'193 begin194 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)195 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2196 from dbo.GEN_FTEY510EB2AF297B8F844C83DA (@uid_person, @ObjectKeyToInspect) as xx197198 goto EndLabel199200 end -- LDAPAccountInLDAPGroup201202 if @ObjectKeyToInspect like '<Key><T>LDAPContainer</T>%'203 begin204 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)205 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2206 from dbo.GEN_FTEYF9B5B0718078CC8E220CB4 (@uid_person, @ObjectKeyToInspect) as xx207208 goto EndLabel209210 end -- LDAPContainer211212 if @ObjectKeyToInspect like '<Key><T>LDAPGroup</T>%'213 begin214 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)215 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2216 from dbo.GEN_FTEYA5065182EC53F911A8AB59 (@uid_person, @ObjectKeyToInspect) as xx217218 goto EndLabel219220 end -- LDAPGroup221222 if @ObjectKeyToInspect like '<Key><T>LDPDomain</T>%'223 begin224 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)225 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2226 from dbo.GEN_FTEY95BE8166C29BD1FD6991CC (@uid_person, @ObjectKeyToInspect) as xx227228 goto EndLabel229230 end -- LDPDomain231232 if @ObjectKeyToInspect like '<Key><T>LocalityHasLDAPGroup</T>%'233 begin234 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)235 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2236 from dbo.GEN_FTEYAC13F21E0D4DB4DD55310E (@uid_person, @ObjectKeyToInspect) as xx237238 goto EndLabel239240 end -- LocalityHasLDAPGroup241242 if @ObjectKeyToInspect like '<Key><T>OrgHasLDAPGroup</T>%'243 begin244 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)245 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2246 from dbo.GEN_FTEY6CBBED4521EDE5C5B61A02 (@uid_person, @ObjectKeyToInspect) as xx247248 goto EndLabel249250 end -- OrgHasLDAPGroup251252 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasLDAPGroup</T>%'253 begin254 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)255 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2256 from dbo.GEN_FTEYA60CCE102C52A5B0014C2D (@uid_person, @ObjectKeyToInspect) as xx257258 goto EndLabel259260 end -- ProfitCenterHasLDAPGroup261262 if @ObjectKeyToInspect like '<Key><T>AccProduct</T>%'263 begin264 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)265 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2266 from dbo.GEN_FTEY06423E1553D20332D88F9A (@uid_person, @ObjectKeyToInspect) as xx267268 goto EndLabel269270 end -- AccProduct271272 if @ObjectKeyToInspect like '<Key><T>AERole</T>%'273 begin274 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)275 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2276 from dbo.GEN_FTEY703F1F5EE8D64B7DB79B18 (@uid_person, @ObjectKeyToInspect) as xx277278 goto EndLabel279280 end -- AERole281282 if @ObjectKeyToInspect like '<Key><T>AERoleHasQERResource</T>%'283 begin284 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)285 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2286 from dbo.GEN_FTEY81C940D082F32291EFCE78 (@uid_person, @ObjectKeyToInspect) as xx287288 goto EndLabel289290 end -- AERoleHasQERResource291292 if @ObjectKeyToInspect like '<Key><T>ComplianceRule</T>%'293 begin294 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)295 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2296 from dbo.GEN_FTEYF61C4144CE8FABBC866272 (@uid_person, @ObjectKeyToInspect) as xx297298 goto EndLabel299300 end -- ComplianceRule301302 if @ObjectKeyToInspect like '<Key><T>Department</T>%'303 begin304 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)305 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2306 from dbo.GEN_FTEYC50E4CC8188C7D5B7DCD71 (@uid_person, @ObjectKeyToInspect) as xx307308 goto EndLabel309310 end -- Department311312 if @ObjectKeyToInspect like '<Key><T>DepartmentHasQERAssign</T>%'313 begin314 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)315 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2316 from dbo.GEN_FTEYD5D72E6FA335696FA50D11 (@uid_person, @ObjectKeyToInspect) as xx317318 goto EndLabel319320 end -- DepartmentHasQERAssign321322 if @ObjectKeyToInspect like '<Key><T>DepartmentHasQERResource</T>%'323 begin324 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)325 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2326 from dbo.GEN_FTEY0F8CCEAC5542AB58BC6783 (@uid_person, @ObjectKeyToInspect) as xx327328 goto EndLabel329330 end -- DepartmentHasQERResource331332 if @ObjectKeyToInspect like '<Key><T>DepartmentHasQERReuse</T>%'333 begin334 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)335 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2336 from dbo.GEN_FTEYFF99B6B069C342288C6BA9 (@uid_person, @ObjectKeyToInspect) as xx337338 goto EndLabel339340 end -- DepartmentHasQERReuse341342 if @ObjectKeyToInspect like '<Key><T>DepartmentHasQERReuseUS</T>%'343 begin344 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)345 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2346 from dbo.GEN_FTEYF9571F25A9F1882987B829 (@uid_person, @ObjectKeyToInspect) as xx347348 goto EndLabel349350 end -- DepartmentHasQERReuseUS351352 if @ObjectKeyToInspect like '<Key><T>ESet</T>%'353 begin354 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)355 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2356 from dbo.GEN_FTEY3252DCA9E44227685CE446 (@uid_person, @ObjectKeyToInspect) as xx357358 goto EndLabel359360 end -- ESet361362 if @ObjectKeyToInspect like '<Key><T>ESetHasEntitlement</T>%'363 begin364 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)365 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2366 from dbo.GEN_FTEY63E94516858277C9BB4F5A (@uid_person, @ObjectKeyToInspect) as xx367368 goto EndLabel369370 end -- ESetHasEntitlement371372 if @ObjectKeyToInspect like '<Key><T>HelperHeadOrg</T>%'373 begin374 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)375 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2376 from dbo.GEN_FTEYCACD53376979AEB4951686 (@uid_person, @ObjectKeyToInspect) as xx377378 goto EndLabel379380 end -- HelperHeadOrg381382 if @ObjectKeyToInspect like '<Key><T>ITShopOrg</T>%'383 begin384 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)385 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2386 from dbo.GEN_FTEY8FEF93B7440FEF03F2412C (@uid_person, @ObjectKeyToInspect) as xx387388 goto EndLabel389390 end -- ITShopOrg391392 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasPWODecisionMethod</T>%'393 begin394 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)395 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2396 from dbo.GEN_FTEY3652C1025CCBFA75922279 (@uid_person, @ObjectKeyToInspect) as xx397398 goto EndLabel399400 end -- ITShopOrgHasPWODecisionMethod401402 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasQERAssign</T>%'403 begin404 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)405 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2406 from dbo.GEN_FTEY959435F6DBCCA9EB3EB28D (@uid_person, @ObjectKeyToInspect) as xx407408 goto EndLabel409410 end -- ITShopOrgHasQERAssign411412 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasQERResource</T>%'413 begin414 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)415 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2416 from dbo.GEN_FTEY57D0C486EFB83A7F90C10D (@uid_person, @ObjectKeyToInspect) as xx417418 goto EndLabel419420 end -- ITShopOrgHasQERResource421422 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasQERReuse</T>%'423 begin424 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)425 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2426 from dbo.GEN_FTEY4855C755CA9487EA21B72A (@uid_person, @ObjectKeyToInspect) as xx427428 goto EndLabel429430 end -- ITShopOrgHasQERReuse431432 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasQERReuseUS</T>%'433 begin434 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)435 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2436 from dbo.GEN_FTEYD1C52DE6CB749CD02A401C (@uid_person, @ObjectKeyToInspect) as xx437438 goto EndLabel439440 end -- ITShopOrgHasQERReuseUS441442 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasPWODecisionMethod</T>%'443 begin444 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)445 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2446 from dbo.GEN_FTEY802A83C3E07BD2831C4DF1 (@uid_person, @ObjectKeyToInspect) as xx447448 goto EndLabel449450 end -- ITShopSrcHasPWODecisionMethod451452 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasQERAssign</T>%'453 begin454 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)455 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2456 from dbo.GEN_FTEY16F46EAC98E87C927E087B (@uid_person, @ObjectKeyToInspect) as xx457458 goto EndLabel459460 end -- ITShopSrcHasQERAssign461462 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasQERResource</T>%'463 begin464 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)465 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2466 from dbo.GEN_FTEYECAD876E5948B1A0FEF889 (@uid_person, @ObjectKeyToInspect) as xx467468 goto EndLabel469470 end -- ITShopSrcHasQERResource471472 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasQERReuse</T>%'473 begin474 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)475 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2476 from dbo.GEN_FTEYFAEF8CACEA5085E028D489 (@uid_person, @ObjectKeyToInspect) as xx477478 goto EndLabel479480 end -- ITShopSrcHasQERReuse481482 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasQERReuseUS</T>%'483 begin484 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)485 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2486 from dbo.GEN_FTEY46244768898D6B348324B5 (@uid_person, @ObjectKeyToInspect) as xx487488 goto EndLabel489490 end -- ITShopSrcHasQERReuseUS491492 if @ObjectKeyToInspect like '<Key><T>Locality</T>%'493 begin494 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)495 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2496 from dbo.GEN_FTEYF021722B8C41E69A21F5BA (@uid_person, @ObjectKeyToInspect) as xx497498 goto EndLabel499500 end -- Locality501502 if @ObjectKeyToInspect like '<Key><T>LocalityHasQERAssign</T>%'503 begin504 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)505 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2506 from dbo.GEN_FTEY8BF540F72028620D497ABE (@uid_person, @ObjectKeyToInspect) as xx507508 goto EndLabel509510 end -- LocalityHasQERAssign511512 if @ObjectKeyToInspect like '<Key><T>LocalityHasQERResource</T>%'513 begin514 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)515 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2516 from dbo.GEN_FTEY63EBFB5F389C2C71565877 (@uid_person, @ObjectKeyToInspect) as xx517518 goto EndLabel519520 end -- LocalityHasQERResource521522 if @ObjectKeyToInspect like '<Key><T>LocalityHasQERReuse</T>%'523 begin524 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)525 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2526 from dbo.GEN_FTEY41843567E57D1397868D56 (@uid_person, @ObjectKeyToInspect) as xx527528 goto EndLabel529530 end -- LocalityHasQERReuse531532 if @ObjectKeyToInspect like '<Key><T>LocalityHasQERReuseUS</T>%'533 begin534 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)535 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2536 from dbo.GEN_FTEY8D93A3D46765A5490FA4FC (@uid_person, @ObjectKeyToInspect) as xx537538 goto EndLabel539540 end -- LocalityHasQERReuseUS541542 if @ObjectKeyToInspect like '<Key><T>PersonHasESet</T>%'543 begin544 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)545 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2546 from dbo.GEN_FTEY9C5A940806B98C76B45A28 (@uid_person, @ObjectKeyToInspect) as xx547548 goto EndLabel549550 end -- PersonHasESet551552 if @ObjectKeyToInspect like '<Key><T>PersonHasQERAssign</T>%'553 begin554 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)555 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2556 from dbo.GEN_FTEY6A4C3C6E502E007685003B (@uid_person, @ObjectKeyToInspect) as xx557558 goto EndLabel559560 end -- PersonHasQERAssign561562 if @ObjectKeyToInspect like '<Key><T>PersonHasQERResource</T>%'563 begin564 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)565 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2566 from dbo.GEN_FTEYE3300D332EFDFCD61A0A1F (@uid_person, @ObjectKeyToInspect) as xx567568 goto EndLabel569570 end -- PersonHasQERResource571572 if @ObjectKeyToInspect like '<Key><T>PersonHasQERReuse</T>%'573 begin574 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)575 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2576 from dbo.GEN_FTEY603E46E7D17851CEECD074 (@uid_person, @ObjectKeyToInspect) as xx577578 goto EndLabel579580 end -- PersonHasQERReuse581582 if @ObjectKeyToInspect like '<Key><T>PersonHasQERReuseUS</T>%'583 begin584 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)585 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2586 from dbo.GEN_FTEY32246AB0D1EBEA0EF689F3 (@uid_person, @ObjectKeyToInspect) as xx587588 goto EndLabel589590 end -- PersonHasQERReuseUS591592 if @ObjectKeyToInspect like '<Key><T>PersonInAERole</T>%'593 begin594 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)595 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2596 from dbo.GEN_FTEYC455A197F1F99E91DE3119 (@uid_person, @ObjectKeyToInspect) as xx597598 goto EndLabel599600 end -- PersonInAERole601602 if @ObjectKeyToInspect like '<Key><T>PersonInDepartment</T>%'603 begin604 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)605 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2606 from dbo.GEN_FTEY4926D9B896C39764C9EF8F (@uid_person, @ObjectKeyToInspect) as xx607608 goto EndLabel609610 end -- PersonInDepartment611612 if @ObjectKeyToInspect like '<Key><T>PersonInITShopOrg</T>%'613 begin614 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)615 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2616 from dbo.GEN_FTEYF919254F951A7A5DF6B821 (@uid_person, @ObjectKeyToInspect) as xx617618 goto EndLabel619620 end -- PersonInITShopOrg621622 if @ObjectKeyToInspect like '<Key><T>PersonInLocality</T>%'623 begin624 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)625 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2626 from dbo.GEN_FTEY44E94D0D92A82BFECD72B7 (@uid_person, @ObjectKeyToInspect) as xx627628 goto EndLabel629630 end -- PersonInLocality631632 if @ObjectKeyToInspect like '<Key><T>PersonInProfitCenter</T>%'633 begin634 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)635 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2636 from dbo.GEN_FTEY95A0CB3F5C230BAF81B16E (@uid_person, @ObjectKeyToInspect) as xx637638 goto EndLabel639640 end -- PersonInProfitCenter641642 if @ObjectKeyToInspect like '<Key><T>ProfitCenter</T>%'643 begin644 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)645 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2646 from dbo.GEN_FTEY7FBACBED2AE88C3A9756AD (@uid_person, @ObjectKeyToInspect) as xx647648 goto EndLabel649650 end -- ProfitCenter651652 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasQERAssign</T>%'653 begin654 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)655 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2656 from dbo.GEN_FTEYB84C3B21509F1AA07885F7 (@uid_person, @ObjectKeyToInspect) as xx657658 goto EndLabel659660 end -- ProfitCenterHasQERAssign661662 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasQERResource</T>%'663 begin664 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)665 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2666 from dbo.GEN_FTEYD1337EF6C6FC4CB197D0D2 (@uid_person, @ObjectKeyToInspect) as xx667668 goto EndLabel669670 end -- ProfitCenterHasQERResource671672 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasQERReuse</T>%'673 begin674 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)675 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2676 from dbo.GEN_FTEY362F968B4687C8212EF4EF (@uid_person, @ObjectKeyToInspect) as xx677678 goto EndLabel679680 end -- ProfitCenterHasQERReuse681682 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasQERReuseUS</T>%'683 begin684 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)685 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2686 from dbo.GEN_FTEYF710376B9619AA2464A2B2 (@uid_person, @ObjectKeyToInspect) as xx687688 goto EndLabel689690 end -- ProfitCenterHasQERReuseUS691692 if @ObjectKeyToInspect like '<Key><T>QERAssign</T>%'693 begin694 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)695 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2696 from dbo.GEN_FTEY7C0A8CD265F459125E08F4 (@uid_person, @ObjectKeyToInspect) as xx697698 goto EndLabel699700 end -- QERAssign701702 if @ObjectKeyToInspect like '<Key><T>QERResource</T>%'703 begin704 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)705 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2706 from dbo.GEN_FTEY57C35E74C42BCE83936653 (@uid_person, @ObjectKeyToInspect) as xx707708 goto EndLabel709710 end -- QERResource711712 if @ObjectKeyToInspect like '<Key><T>QERReuse</T>%'713 begin714 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)715 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2716 from dbo.GEN_FTEYB8BBCF8E8E26BBED8671F5 (@uid_person, @ObjectKeyToInspect) as xx717718 goto EndLabel719720 end -- QERReuse721722 if @ObjectKeyToInspect like '<Key><T>QERReuseUS</T>%'723 begin724 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)725 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2726 from dbo.GEN_FTEY0D204A0FA588A619EB3F7B (@uid_person, @ObjectKeyToInspect) as xx727728 goto EndLabel729730 end -- QERReuseUS731732 if @ObjectKeyToInspect like '<Key><T>Org</T>%'733 begin734 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)735 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2736 from dbo.GEN_FTEYFECC3EA95617D69C0478E1 (@uid_person, @ObjectKeyToInspect) as xx737738 goto EndLabel739740 end -- Org741742 if @ObjectKeyToInspect like '<Key><T>OrgHasQERAssign</T>%'743 begin744 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)745 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2746 from dbo.GEN_FTEYED8E405E523D8D627BD65F (@uid_person, @ObjectKeyToInspect) as xx747748 goto EndLabel749750 end -- OrgHasQERAssign751752 if @ObjectKeyToInspect like '<Key><T>OrgHasQERResource</T>%'753 begin754 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)755 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2756 from dbo.GEN_FTEY5F7DBF32525FD5E76002A3 (@uid_person, @ObjectKeyToInspect) as xx757758 goto EndLabel759760 end -- OrgHasQERResource761762 if @ObjectKeyToInspect like '<Key><T>OrgHasQERReuse</T>%'763 begin764 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)765 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2766 from dbo.GEN_FTEY3119E9B9D28BDAB8DBBB2F (@uid_person, @ObjectKeyToInspect) as xx767768 goto EndLabel769770 end -- OrgHasQERReuse771772 if @ObjectKeyToInspect like '<Key><T>OrgHasQERReuseUS</T>%'773 begin774 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)775 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2776 from dbo.GEN_FTEYF7783E5B8726C9CAE353D8 (@uid_person, @ObjectKeyToInspect) as xx777778 goto EndLabel779780 end -- OrgHasQERReuseUS781782 if @ObjectKeyToInspect like '<Key><T>PersonInOrg</T>%'783 begin784 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)785 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2786 from dbo.GEN_FTEY365A3E48EE0118A0F8B4E2 (@uid_person, @ObjectKeyToInspect) as xx787788 goto EndLabel789790 end -- PersonInOrg791792 if @ObjectKeyToInspect like '<Key><T>DepartmentHasESet</T>%'793 begin794 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)795 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2796 from dbo.GEN_FTEY9E3743EF4FD0926C4FD5DE (@uid_person, @ObjectKeyToInspect) as xx797798 goto EndLabel799800 end -- DepartmentHasESet801802 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasESet</T>%'803 begin804 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)805 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2806 from dbo.GEN_FTEY0BCBB74461782A260ACBBA (@uid_person, @ObjectKeyToInspect) as xx807808 goto EndLabel809810 end -- ITShopOrgHasESet811812 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasESet</T>%'813 begin814 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)815 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2816 from dbo.GEN_FTEY08F52C68A60DA875F2F6BB (@uid_person, @ObjectKeyToInspect) as xx817818 goto EndLabel819820 end -- ITShopSrcHasESet821822 if @ObjectKeyToInspect like '<Key><T>LocalityHasESet</T>%'823 begin824 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)825 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2826 from dbo.GEN_FTEY54D7FCA2E89FC59ACF04B8 (@uid_person, @ObjectKeyToInspect) as xx827828 goto EndLabel829830 end -- LocalityHasESet831832 if @ObjectKeyToInspect like '<Key><T>OrgHasESet</T>%'833 begin834 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)835 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2836 from dbo.GEN_FTEY654CCD699AC827FB59CD22 (@uid_person, @ObjectKeyToInspect) as xx837838 goto EndLabel839840 end -- OrgHasESet841842 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasESet</T>%'843 begin844 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)845 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2846 from dbo.GEN_FTEYFA544B1011E4A042348A0E (@uid_person, @ObjectKeyToInspect) as xx847848 goto EndLabel849850 end -- ProfitCenterHasESet851852 if @ObjectKeyToInspect like '<Key><T>AERoleHasRPSReport</T>%'853 begin854 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)855 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2856 from dbo.GEN_FTEY01FB8D175B472AFAC4FBBD (@uid_person, @ObjectKeyToInspect) as xx857858 goto EndLabel859860 end -- AERoleHasRPSReport861862 if @ObjectKeyToInspect like '<Key><T>DepartmentHasRPSReport</T>%'863 begin864 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)865 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2866 from dbo.GEN_FTEY5A3D5445A31314E3C80820 (@uid_person, @ObjectKeyToInspect) as xx867868 goto EndLabel869870 end -- DepartmentHasRPSReport871872 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasRPSReport</T>%'873 begin874 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)875 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2876 from dbo.GEN_FTEYA98DB5E80EFE54297AA0A8 (@uid_person, @ObjectKeyToInspect) as xx877878 goto EndLabel879880 end -- ITShopOrgHasRPSReport881882 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasRPSReport</T>%'883 begin884 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)885 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2886 from dbo.GEN_FTEY896E146F4F840E422CCBA3 (@uid_person, @ObjectKeyToInspect) as xx887888 goto EndLabel889890 end -- ITShopSrcHasRPSReport891892 if @ObjectKeyToInspect like '<Key><T>LocalityHasRPSReport</T>%'893 begin894 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)895 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2896 from dbo.GEN_FTEY680B289738F51B38B41A7B (@uid_person, @ObjectKeyToInspect) as xx897898 goto EndLabel899900 end -- LocalityHasRPSReport901902 if @ObjectKeyToInspect like '<Key><T>OrgHasRPSReport</T>%'903 begin904 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)905 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2906 from dbo.GEN_FTEY5082C636ECA32E1D797C16 (@uid_person, @ObjectKeyToInspect) as xx907908 goto EndLabel909910 end -- OrgHasRPSReport911912 if @ObjectKeyToInspect like '<Key><T>PersonHasRPSReport</T>%'913 begin914 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)915 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2916 from dbo.GEN_FTEY94A1455D19630D9B5E3446 (@uid_person, @ObjectKeyToInspect) as xx917918 goto EndLabel919920 end -- PersonHasRPSReport921922 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasRPSReport</T>%'923 begin924 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)925 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2926 from dbo.GEN_FTEY334AF4B7AAF5D1C1085331 (@uid_person, @ObjectKeyToInspect) as xx927928 goto EndLabel929930 end -- ProfitCenterHasRPSReport931932 if @ObjectKeyToInspect like '<Key><T>RPSReport</T>%'933 begin934 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)935 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2936 from dbo.GEN_FTEYD9F80E09EE41CB3418962A (@uid_person, @ObjectKeyToInspect) as xx937938 goto EndLabel939940 end -- RPSReport941942 if @ObjectKeyToInspect like '<Key><T>AERoleHasTSBAccountDef</T>%'943 begin944 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)945 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2946 from dbo.GEN_FTEY197EC6A22EFCA0F37E16F8 (@uid_person, @ObjectKeyToInspect) as xx947948 goto EndLabel949950 end -- AERoleHasTSBAccountDef951952 if @ObjectKeyToInspect like '<Key><T>DepartmentHasTSBAccountDef</T>%'953 begin954 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)955 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2956 from dbo.GEN_FTEYAD3637368C48BBEA6B8D71 (@uid_person, @ObjectKeyToInspect) as xx957958 goto EndLabel959960 end -- DepartmentHasTSBAccountDef961962 if @ObjectKeyToInspect like '<Key><T>DepartmentHasUNSGroupB</T>%'963 begin964 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)965 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2966 from dbo.GEN_FTEY8B9BB6E0E5756FA8FC6CBF (@uid_person, @ObjectKeyToInspect) as xx967968 goto EndLabel969970 end -- DepartmentHasUNSGroupB971972 if @ObjectKeyToInspect like '<Key><T>DepartmentHasUNSGroupB1</T>%'973 begin974 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)975 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2976 from dbo.GEN_FTEY93C83068790E482B9BC48A (@uid_person, @ObjectKeyToInspect) as xx977978 goto EndLabel979980 end -- DepartmentHasUNSGroupB1981982 if @ObjectKeyToInspect like '<Key><T>DepartmentHasUNSGroupB2</T>%'983 begin984 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)985 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2986 from dbo.GEN_FTEYF56DD909CB94BEEC756652 (@uid_person, @ObjectKeyToInspect) as xx987988 goto EndLabel989990 end -- DepartmentHasUNSGroupB2991992 if @ObjectKeyToInspect like '<Key><T>DepartmentHasUNSGroupB3</T>%'993 begin994 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)995 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2996 from dbo.GEN_FTEY6A01F15B07CC9CBEDA919D (@uid_person, @ObjectKeyToInspect) as xx997998 goto EndLabel9991000 end -- DepartmentHasUNSGroupB310011002 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasTSBAccountDef</T>%'1003 begin1004 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1005 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21006 from dbo.GEN_FTEY7E63AC104BE0F8468C3926 (@uid_person, @ObjectKeyToInspect) as xx10071008 goto EndLabel10091010 end -- ITShopOrgHasTSBAccountDef10111012 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasUNSGroupB</T>%'1013 begin1014 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1015 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21016 from dbo.GEN_FTEYFCC9AEDF028F5733EA1762 (@uid_person, @ObjectKeyToInspect) as xx10171018 goto EndLabel10191020 end -- ITShopOrgHasUNSGroupB10211022 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasUNSGroupB1</T>%'1023 begin1024 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1025 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21026 from dbo.GEN_FTEYE5C106C07A55319D2D1F4C (@uid_person, @ObjectKeyToInspect) as xx10271028 goto EndLabel10291030 end -- ITShopOrgHasUNSGroupB110311032 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasUNSGroupB2</T>%'1033 begin1034 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1035 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21036 from dbo.GEN_FTEYA0EB22774E297DA91E86F4 (@uid_person, @ObjectKeyToInspect) as xx10371038 goto EndLabel10391040 end -- ITShopOrgHasUNSGroupB210411042 if @ObjectKeyToInspect like '<Key><T>ITShopOrgHasUNSGroupB3</T>%'1043 begin1044 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1045 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21046 from dbo.GEN_FTEYD9E45B5BA3CF3011E79360 (@uid_person, @ObjectKeyToInspect) as xx10471048 goto EndLabel10491050 end -- ITShopOrgHasUNSGroupB310511052 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasTSBAccountDef</T>%'1053 begin1054 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1055 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21056 from dbo.GEN_FTEYAF3582CAD04010AC5744C9 (@uid_person, @ObjectKeyToInspect) as xx10571058 goto EndLabel10591060 end -- ITShopSrcHasTSBAccountDef10611062 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasUNSGroupB</T>%'1063 begin1064 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1065 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21066 from dbo.GEN_FTEY921BCCEECC644676A5E2D4 (@uid_person, @ObjectKeyToInspect) as xx10671068 goto EndLabel10691070 end -- ITShopSrcHasUNSGroupB10711072 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasUNSGroupB1</T>%'1073 begin1074 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1075 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21076 from dbo.GEN_FTEYDE839AC5FDDF3A157A16AF (@uid_person, @ObjectKeyToInspect) as xx10771078 goto EndLabel10791080 end -- ITShopSrcHasUNSGroupB110811082 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasUNSGroupB2</T>%'1083 begin1084 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1085 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21086 from dbo.GEN_FTEY0BA325EDC97A6511B77954 (@uid_person, @ObjectKeyToInspect) as xx10871088 goto EndLabel10891090 end -- ITShopSrcHasUNSGroupB210911092 if @ObjectKeyToInspect like '<Key><T>ITShopSrcHasUNSGroupB3</T>%'1093 begin1094 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1095 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21096 from dbo.GEN_FTEY1259C3D6106F88D3FE81C1 (@uid_person, @ObjectKeyToInspect) as xx10971098 goto EndLabel10991100 end -- ITShopSrcHasUNSGroupB311011102 if @ObjectKeyToInspect like '<Key><T>LocalityHasTSBAccountDef</T>%'1103 begin1104 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1105 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21106 from dbo.GEN_FTEY1C7461F2680F62B272D390 (@uid_person, @ObjectKeyToInspect) as xx11071108 goto EndLabel11091110 end -- LocalityHasTSBAccountDef11111112 if @ObjectKeyToInspect like '<Key><T>LocalityHasUNSGroupB</T>%'1113 begin1114 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1115 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21116 from dbo.GEN_FTEYACAC5700ABF0D42F65529A (@uid_person, @ObjectKeyToInspect) as xx11171118 goto EndLabel11191120 end -- LocalityHasUNSGroupB11211122 if @ObjectKeyToInspect like '<Key><T>LocalityHasUNSGroupB1</T>%'1123 begin1124 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1125 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21126 from dbo.GEN_FTEYF634ACF893A3AC13026A99 (@uid_person, @ObjectKeyToInspect) as xx11271128 goto EndLabel11291130 end -- LocalityHasUNSGroupB111311132 if @ObjectKeyToInspect like '<Key><T>LocalityHasUNSGroupB2</T>%'1133 begin1134 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1135 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21136 from dbo.GEN_FTEY15CB642D7F87E41BF86FE8 (@uid_person, @ObjectKeyToInspect) as xx11371138 goto EndLabel11391140 end -- LocalityHasUNSGroupB211411142 if @ObjectKeyToInspect like '<Key><T>LocalityHasUNSGroupB3</T>%'1143 begin1144 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1145 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21146 from dbo.GEN_FTEYAD6AB0B9B040433F113D36 (@uid_person, @ObjectKeyToInspect) as xx11471148 goto EndLabel11491150 end -- LocalityHasUNSGroupB311511152 if @ObjectKeyToInspect like '<Key><T>OrgHasTSBAccountDef</T>%'1153 begin1154 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1155 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21156 from dbo.GEN_FTEY6899BC09F309C000CB6007 (@uid_person, @ObjectKeyToInspect) as xx11571158 goto EndLabel11591160 end -- OrgHasTSBAccountDef11611162 if @ObjectKeyToInspect like '<Key><T>OrgHasUNSGroupB</T>%'1163 begin1164 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1165 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21166 from dbo.GEN_FTEY0BAF2057553029E6B0BFCD (@uid_person, @ObjectKeyToInspect) as xx11671168 goto EndLabel11691170 end -- OrgHasUNSGroupB11711172 if @ObjectKeyToInspect like '<Key><T>OrgHasUNSGroupB1</T>%'1173 begin1174 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1175 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21176 from dbo.GEN_FTEY9AA9267513A52C463DBAB1 (@uid_person, @ObjectKeyToInspect) as xx11771178 goto EndLabel11791180 end -- OrgHasUNSGroupB111811182 if @ObjectKeyToInspect like '<Key><T>OrgHasUNSGroupB2</T>%'1183 begin1184 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1185 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21186 from dbo.GEN_FTEYB5C2BEFDF41A038B6E4E8F (@uid_person, @ObjectKeyToInspect) as xx11871188 goto EndLabel11891190 end -- OrgHasUNSGroupB211911192 if @ObjectKeyToInspect like '<Key><T>OrgHasUNSGroupB3</T>%'1193 begin1194 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1195 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21196 from dbo.GEN_FTEY53D8D792B6515142C31909 (@uid_person, @ObjectKeyToInspect) as xx11971198 goto EndLabel11991200 end -- OrgHasUNSGroupB312011202 if @ObjectKeyToInspect like '<Key><T>PersonHasTSBAccountDef</T>%'1203 begin1204 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1205 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21206 from dbo.GEN_FTEYD1570666C15F0F46905354 (@uid_person, @ObjectKeyToInspect) as xx12071208 goto EndLabel12091210 end -- PersonHasTSBAccountDef12111212 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasTSBAccountDef</T>%'1213 begin1214 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1215 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21216 from dbo.GEN_FTEY75C7B00B32C74FA8C734A8 (@uid_person, @ObjectKeyToInspect) as xx12171218 goto EndLabel12191220 end -- ProfitCenterHasTSBAccountDef12211222 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasUNSGroupB</T>%'1223 begin1224 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1225 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21226 from dbo.GEN_FTEY73F83A16FCB3159A7F6DF1 (@uid_person, @ObjectKeyToInspect) as xx12271228 goto EndLabel12291230 end -- ProfitCenterHasUNSGroupB12311232 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasUNSGroupB1</T>%'1233 begin1234 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1235 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21236 from dbo.GEN_FTEYA17794B9D95EE8DD144E94 (@uid_person, @ObjectKeyToInspect) as xx12371238 goto EndLabel12391240 end -- ProfitCenterHasUNSGroupB112411242 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasUNSGroupB2</T>%'1243 begin1244 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1245 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21246 from dbo.GEN_FTEY68B364EED5084A7D5D23F3 (@uid_person, @ObjectKeyToInspect) as xx12471248 goto EndLabel12491250 end -- ProfitCenterHasUNSGroupB212511252 if @ObjectKeyToInspect like '<Key><T>ProfitCenterHasUNSGroupB3</T>%'1253 begin1254 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1255 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21256 from dbo.GEN_FTEYB7D9F2A88D2BEE2704FF81 (@uid_person, @ObjectKeyToInspect) as xx12571258 goto EndLabel12591260 end -- ProfitCenterHasUNSGroupB312611262 if @ObjectKeyToInspect like '<Key><T>TSBAccountDef</T>%'1263 begin1264 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1265 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21266 from dbo.GEN_FTEY7166BBF7E8B4003DCA4B3D (@uid_person, @ObjectKeyToInspect) as xx12671268 goto EndLabel12691270 end -- TSBAccountDef12711272 if @ObjectKeyToInspect like '<Key><T>UNSAccountB</T>%'1273 begin1274 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1275 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21276 from dbo.GEN_FTEY60473E8B8DB38BF7C1CCE3 (@uid_person, @ObjectKeyToInspect) as xx12771278 goto EndLabel12791280 end -- UNSAccountB12811282 if @ObjectKeyToInspect like '<Key><T>UNSAccountBHasUNSGroupB</T>%'1283 begin1284 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1285 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21286 from dbo.GEN_FTEY1651DF0943C389DD296ADE (@uid_person, @ObjectKeyToInspect) as xx12871288 goto EndLabel12891290 end -- UNSAccountBHasUNSGroupB12911292 if @ObjectKeyToInspect like '<Key><T>UNSAccountBHasUNSGroupB1</T>%'1293 begin1294 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1295 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21296 from dbo.GEN_FTEY8E0532B844467344E61179 (@uid_person, @ObjectKeyToInspect) as xx12971298 goto EndLabel12991300 end -- UNSAccountBHasUNSGroupB113011302 if @ObjectKeyToInspect like '<Key><T>UNSAccountBHasUNSGroupB2</T>%'1303 begin1304 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1305 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21306 from dbo.GEN_FTEYCB57F36D8B554BDAEF804B (@uid_person, @ObjectKeyToInspect) as xx13071308 goto EndLabel13091310 end -- UNSAccountBHasUNSGroupB213111312 if @ObjectKeyToInspect like '<Key><T>UNSAccountBHasUNSGroupB3</T>%'1313 begin1314 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1315 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21316 from dbo.GEN_FTEYF4FA37E77329315C33C8D5 (@uid_person, @ObjectKeyToInspect) as xx13171318 goto EndLabel13191320 end -- UNSAccountBHasUNSGroupB313211322 if @ObjectKeyToInspect like '<Key><T>UNSAccountBInUNSGroupB</T>%'1323 begin1324 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1325 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21326 from dbo.GEN_FTEY0122181C230044398280FE (@uid_person, @ObjectKeyToInspect) as xx13271328 goto EndLabel13291330 end -- UNSAccountBInUNSGroupB13311332 if @ObjectKeyToInspect like '<Key><T>UNSAccountBInUNSGroupB1</T>%'1333 begin1334 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1335 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21336 from dbo.GEN_FTEY7705EAA3F767C86779D0BD (@uid_person, @ObjectKeyToInspect) as xx13371338 goto EndLabel13391340 end -- UNSAccountBInUNSGroupB113411342 if @ObjectKeyToInspect like '<Key><T>UNSAccountBInUNSGroupB2</T>%'1343 begin1344 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1345 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21346 from dbo.GEN_FTEY87AE45C88F8A7904BD9510 (@uid_person, @ObjectKeyToInspect) as xx13471348 goto EndLabel13491350 end -- UNSAccountBInUNSGroupB213511352 if @ObjectKeyToInspect like '<Key><T>UNSAccountBInUNSGroupB3</T>%'1353 begin1354 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1355 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21356 from dbo.GEN_FTEYDAF6E4727A8EAE717E59D7 (@uid_person, @ObjectKeyToInspect) as xx13571358 goto EndLabel13591360 end -- UNSAccountBInUNSGroupB313611362 if @ObjectKeyToInspect like '<Key><T>UNSContainerB</T>%'1363 begin1364 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1365 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21366 from dbo.GEN_FTEYCECC6DB926BCF9648F456B (@uid_person, @ObjectKeyToInspect) as xx13671368 goto EndLabel13691370 end -- UNSContainerB13711372 if @ObjectKeyToInspect like '<Key><T>UNSGroupB</T>%'1373 begin1374 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1375 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21376 from dbo.GEN_FTEY19AE465A1AEDCAF37D47AC (@uid_person, @ObjectKeyToInspect) as xx13771378 goto EndLabel13791380 end -- UNSGroupB13811382 if @ObjectKeyToInspect like '<Key><T>UNSGroupB1</T>%'1383 begin1384 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1385 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21386 from dbo.GEN_FTEYB5B79D3FB317B463216F71 (@uid_person, @ObjectKeyToInspect) as xx13871388 goto EndLabel13891390 end -- UNSGroupB113911392 if @ObjectKeyToInspect like '<Key><T>UNSGroupB2</T>%'1393 begin1394 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1395 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21396 from dbo.GEN_FTEY8C8C8E4B72714983D306FB (@uid_person, @ObjectKeyToInspect) as xx13971398 goto EndLabel13991400 end -- UNSGroupB214011402 if @ObjectKeyToInspect like '<Key><T>UNSGroupB3</T>%'1403 begin1404 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1405 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21406 from dbo.GEN_FTEY9D970CBAA569CA4712CE1A (@uid_person, @ObjectKeyToInspect) as xx14071408 goto EndLabel14091410 end -- UNSGroupB314111412 if @ObjectKeyToInspect like '<Key><T>UNSRootB</T>%'1413 begin1414 insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1415 select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason21416 from dbo.GEN_FTEY9C537565E770C30AA1EC81 (@uid_person, @ObjectKeyToInspect) as xx14171418 goto EndLabel14191420 end -- UNSRootB14211422 --insert into @erg(ObjectKeyReason1, ObjectKeyReason2)1423 --select distinct ObjectKeyReason1, ObjectKeyReason21424 -- from @work14251426 EndLabel:14271428 return1429end1430