Steps to Create the Schedule Report

****************************************************************************

CREATE OR REPLACE VIEW VP_SCHEDULE_CUST ( SHIFTDATE,

SHIFTSTARTTIME, SHIFTENDTIME, PERSONID ) AS SELECT

trunc(SH.STARTDTM) AS SHIFTDATE,

SS.STARTDTM AS SHIFTSTARTTIME ,

SS.ENDDTM AS SHIFTENDTIME ,

WE.PERSONID

FROM

WTKEMPLOYEE WE,

SHIFTASSIGNMNT SA,

SHIFT SH,

SHIFTSEGMENT SS

WHERE

SA.SHIFTID = SH.SHIFTID

AND SS.SHIFTCODEID = SH.SHIFTCODEID

AND SH.SHIFTTYPEID = 1

AND SA.DELETEDSW =0

AND SA.EMPLOYEEID = WE.EMPLOYEEID

****************************************************************************

CREATE OR REPLACE VIEW VP_DATES_STAGE ( ROWNUMBER,

DAY ) AS select rownum as rownumber, trunc((sysdate-90)+rownum)

as day from all_objects

where rownum <= 120

****************************************************************************

CREATE OR REPLACE VIEW VP_DATES_CUST ( DAY,

PERSONID ) AS select a.day, b.personid from

vp_dates_stage a, wtkemployee b

****************************************************************************

grant select on vp_schedule_cust to KRONOSRUSER;

****************************************************************************

grant select on vp_schedule_cust to KRONOSUSER;

****************************************************************************

grant select on vp_dates_cust to KRONOSRUSER;

****************************************************************************

grant select on vp_dates_cust to KRONOSUSER;

****************************************************************************