Description

This view gives an overview of all completed and planned courses , and can be filtered down on person a personal level.

Selection

select
1 as Count,
sched.Code,
COURSE.NAME as 'Course Name',
sched.DateFrom as 'Course Start Date',
sched.DateTo as 'Course End Date',
Convert(varchar,sched.DateFrom,104)+'-'+Convert(varchar,sched.DateTo,104) as 'Course Date',
datediff(day,sched.Datefrom,sched.Dateto)+1 as 'Number of Days',
sched.Cost_Currency as 'Currency',
sched.Cost as 'Cost',
p01.PIN,
p01.Name,
rank.Name as Rank,
p01.Client numorgid,
p01.Employmentstartdate,
p01.Employmentenddate
from PWTRN_CRS_SCHEDULE_P01 schedp01
left join pw001p01 p01 on p01.pin=schedp01.pin
left join PWTRN_COURSE_SCHEDULES SCHED on schedp01.schedule_seq=sched.seqno
left join PWTRN_COURSES course on course.code=sched.code
left join PWTRN_CRSTYPES_C06 Coursec06 on coursec06.course=course.code
left join pw001c06 c06 on c06.code=coursec06.certificate
left join pw001c02 rank on rank.code=p01.rank

...