USP_DATALIST_STUDENTENROLLMENT

Returns all enrollments for the student..

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_STUDENTENROLLMENT(@STUDENTID uniqueidentifier)
            as
                set nocount on;

                select 
                    dbo.EDUCATIONALHISTORY.[ID],
                    CONVERT(varchar(10),dbo.UFN_DATE_FROMFUZZYDATE(dbo.EDUCATIONALHISTORY.[STARTDATE]),101) + CASE dbo.EDUCATIONALHISTORY.[DATELEFT] WHEN '00000000' THEN ' - Present' ELSE +' - ' + CONVERT(varchar(10),dbo.UFN_DATE_FROMFUZZYDATE(dbo.EDUCATIONALHISTORY.[DATELEFT]),101) END 'DATESATTENDED',
                    dbo.EDUCATIONALHISTORYSTATUS.[DESCRIPTION] 'STATUS',
                    CONSTIT_SCHOOL.[KEYNAME] 'SCHOOLNAME',
                    dbo.UFN_STUDENTENROLLMENT_RECORDCOUNT(@STUDENTID) AS RECORDCOUNT
                from dbo.EDUCATIONALHISTORY
                inner join dbo.SCHOOL on dbo.EDUCATIONALHISTORY.[EDUCATIONALINSTITUTIONID] = dbo.SCHOOL.[ID]
                inner join dbo.CONSTITUENT as CONSTIT_SCHOOL on dbo.SCHOOL.[ID] = CONSTIT_SCHOOL.[ID]
                inner join dbo.EDUCATIONALHISTORYSTATUSHISTORY on dbo.EDUCATIONALHISTORYSTATUSHISTORY.[ID] = dbo.UFN_EDUCATIONALHISTORY_GETCURRENTSTATUSHISTORYID(dbo.EDUCATIONALHISTORY.[ID])
                inner join dbo.EDUCATIONALHISTORYSTATUS on dbo.EDUCATIONALHISTORYSTATUSHISTORY.[EDUCATIONALHISTORYSTATUSID] = dbo.EDUCATIONALHISTORYSTATUS.[ID]
                where dbo.EDUCATIONALHISTORY.[CONSTITUENTID] = @STUDENTID