Back to OIM Explorer

dbo.QER_FTEntitlementSourceWhy

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 47.186 characters

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.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL1.706 lines
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
SQL · Raw1.430 lines
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