DROP VIEW LD0VAA0EnrollmentPlan
;

CREATE VIEW LD0VAA0EnrollmentPlan
AS 
SELECT
 U30.PLANNR
,U30.VERSIONNR
,U30.INSKRIVNINGSNR
,U30.PLANTYP
,U30.FROMDAT
,U30.TOMDAT
,U30.UPPFDAT
,U30.ORGID
,U30.SLUTLIG
,U30.UPDDAT
,U30.UPDSIGN
,U30.ANSVARIGNR
,U30.ANSVARIGFOR
,U30.ANSVARIGORG
,U30.ANSVARIGHANDL
,Q.KLARTEXT AS PLANTYP_T
FROM LD0V0U30 AS U30 
LEFT OUTER JOIN LD0V0Q01 AS Q ON Q.KODTYP = 'LNPLANTYP' AND U30.PLANTYP = Q.KOD
;
