Back to OIM Explorer

dbo.ATT_FTAttCasesForManager

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 506 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGISessionContext source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL21 lines
1CREATE FUNCTION dbo.ATT_FTAttCasesForManager(2  @UID_PersonHead varchar(38)3) RETURNS @erg TABLE(UID_AttestationCase varchar(38) collate database_default4)5AS6BEGIN7  IF dbo.QBM_FGISessionContext('ATTCaseAccessAsManagerReduced') = ''8  BEGIN9    INSERT INTO @erg(UID_AttestationCase)10    SELECT ac.UID_AttestationCase11    FROM BaseTree bt12    JOIN HelperHeadOrg hho13      ON bt.UID_Org = hho.UID_Org14    JOIN AttestationCase ac15      ON bt.XObjectKey = ac.ObjectKeyBase16    WHERE17      hho.UID_PersonHead = @UID_PersonHead18  END19  endLabel:20  RETURN21END
Open raw exported source
SQL ยท Raw5 lines
1create function dbo.ATT_FTAttCasesForManager(@UID_PersonHead varchar(38)) returns @erg table (UID_AttestationCase varchar(38) collate database_default)2 as begin if dbo.QBM_FGISessionContext('ATTCaseAccessAsManagerReduced') = '' begin insert into @erg(UID_AttestationCase) select ac.UID_AttestationCase 3from BaseTree bt join HelperHeadOrg hho on bt.UID_Org = hho.UID_Org join AttestationCase ac on bt.XObjectKey = ac.ObjectKeyBase where hho.UID_PersonHead4 = @UID_PersonHead end endLabel: return end 5