UFN_CONFIGURATIONDATA_EDUCATIONALINSTITUTION

                CREATE function dbo.UFN_CONFIGURATIONDATA_EDUCATIONALINSTITUTION
                ()
                returns @QUERIES table
                    (
                    ID uniqueidentifier NOT NULL,
                    NAME nvarchar(250) NULL,
                    FICECODE nvarchar(50) NULL,
                    CLASSIFICATIONCODE tinyint NULL,
                    TYPECODEID uniqueidentifier NULL,
                    LOCATIONCODEID uniqueidentifier NULL,
                    INFOSOURCECODEID uniqueidentifier NULL,
                    ISAFFILIATED bit NULL,
                    CITY nvarchar(150) NULL,
                    STATEID uniqueidentifier NULL,
                    COUNTRYID uniqueidentifier NULL,
                    WEBADDRESS nvarchar(2047) NULL                
                    )                    
                as                 
                begin
                    insert into @QUERIES (ID, NAME, FICECODE, CLASSIFICATIONCODE, TYPECODEID, LOCATIONCODEID, ISAFFILIATED, CITY, STATEID, COUNTRYID, WEBADDRESS) 
            SELECT    E.ID, E.NAME, E.FICECODE, E.CLASSIFICATIONCODE, E.TYPECODEID, E.LOCATIONCODEID, E.ISAFFILIATED, E.CITY, E.STATEID, E.COUNTRYID, C.WEBADDRESS
                    FROM dbo.EDUCATIONALINSTITUTION E LEFT OUTER JOIN CONSTITUENT C ON E.ID=C.ID
                    ORDER BY E.NAME  asc

                    return 
                end