USP_DATALIST_OUTSIDEEDUCATION

Lists all of the outside education records on an individual.

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_OUTSIDEEDUCATION
                (
                    @STUDENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        EDUCATIONALHISTORY.[ID],
                        EDUCATIONALINSTITUTION.NAME as 'EDUCATIONALINSTITUTION',
                        EDUCATIONALHISTORY.[STARTDATE] as DATEFROM,
                        EDUCATIONALHISTORY.[DATELEFT] as DATETO,
                        EDUCATIONALHISTORY.CLASSOF as CLASSYEAR,
                        EDUCATIONALHISTORYSTATUS.DESCRIPTION as STATUS,
                        EDUCATIONALHISTORY.ISPRIMARYRECORD,
                        EDUCATIONALINSTITUTION.CLASSIFICATION,
                        EDUCATIONALINSTITUTION.CITY,
                        STATE.ABBREVIATION as STATE
                    from dbo.EDUCATIONALHISTORY
                inner join dbo.EDUCATIONALINSTITUTION
                    on EDUCATIONALINSTITUTION.ID = EDUCATIONALHISTORY.[EDUCATIONALINSTITUTIONID]
                        inner join dbo.EDUCATIONALHISTORYSTATUS 
                    on dbo.EDUCATIONALHISTORY.[EDUCATIONALHISTORYSTATUSID] = dbo.EDUCATIONALHISTORYSTATUS.[ID]
                left outer join dbo.STATE
                    on dbo.STATE.ID = dbo.EDUCATIONALINSTITUTION.STATEID
                    where (dbo.EDUCATIONALHISTORY.[CONSTITUENTID] = @STUDENTID) and
                            (EDUCATIONALINSTITUTION.ISAFFILIATED = 0)