TL_MBLE_SCHR_VW (SQL View)	Index Back
Mobile - Schedule View This record will contain data concerning the employees elapsed work schedule.

TL_MBLE_SCHR_VW

(SQL View)

Mobile - Schedule View

This record will contain data concerning the employees elapsed work schedule.

SELECT X.EMPLID , X.EMPL_RCD , A.DUR , CASE WHEN A.SHIFT_ID = ' ' THEN %NumToChar(A.SHIFTNUM) ELSE A.SHIFT_ID END , A.EFFDT , A.OFFDAY_IND , '0' , A.SCHED_HRS , A.DESCR , A.SETID , A.SYNCID , A.LASTUPDDTTM FROM PS_SCH_ASSIGN X , PS_SCH_CLND_DTL_VW A , PS_TL_EMPL_DATA E , PS_JOB J WHERE J.EMPLID = X.EMPLID AND J.EMPL_RCD = X.EMPL_RCD AND J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD AND J1.EFFDT <= A.DUR) AND J.EFFSEQ = ( SELECT MAX(J1.EFFSEQ) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD AND J1.EFFDT = J1.EFFDT) AND E.EMPLID = J.EMPLID AND E.EMPL_RCD = J.EMPL_RCD AND E.EFFDT=( SELECT MAX(EFFDT) FROM PS_TL_EMPL_DATA E1 WHERE E1.EMPLID=E.EMPLID AND E1.EMPL_RCD=E.EMPL_RCD AND E1.EFFDT<=A.DUR) AND X.EMPLID = J.EMPLID AND X.EMPL_RCD = J.EMPL_RCD AND X.EFFDT <= A.DUR AND X.END_EFFDT >= A.DUR AND ((X.USE_DFLT_WS IN ('N', 'A') AND A.SETID = X.SETID AND A.SCHEDULE_ID = X.SCHEDULE_ID AND A.SCH_ADHOC_IND = X.SCH_ADHOC_IND AND A.ROTATION_ID = X.ROTATION_ID) OR (X.USE_DFLT_WS = 'Y' AND A.SCH_ADHOC_IND = '1' AND ((J.GP_PAYGROUP <> ' ' AND EXISTS ( SELECT 'X' FROM PS_GP_PYGRP_DTL P WHERE P.GP_PAYGROUP = J.GP_PAYGROUP AND %EffdtCheck(GP_PYGRP_DTL P1, P, A.DUR) AND P.SETID = A.SETID AND P.SCHEDULE_ID = A.SCHEDULE_ID AND P.ROTATION_ID = A.ROTATION_ID)) OR (J.GP_PAYGROUP = ' ' AND EXISTS ( SELECT 'X' FROM PS_TL_WRKGRP_TBL W WHERE W.WORKGROUP = E.WORKGROUP AND %EffdtCheck(TL_WRKGRP_TBL W1, W, A.DUR) AND W.SETID_SCHED = A.SETID AND W.SCHEDULE_ID = A.SCHEDULE_ID AND W.ROTATION_ID = A.ROTATION_ID))))) AND A.DUR BETWEEN A.EFFDT AND A.END_EFFDT AND A.SCH_TYPE = 'E' AND NOT EXISTS ( SELECT 'X' FROM PS_SCH_MNG_SCH_TBL B WHERE B.EMPLID=X.EMPLID AND B.EMPL_RCD=X.EMPL_RCD AND B.DUR=A.DUR AND B.SCH_PRIM_ALT_IND = 'P' AND B.CHNG_PRIMARY IN ('D', 'R'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.

4 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

5 EFFDT Date(10) DATE Effective Date
Default Value: %date

6 OFFDAY_IND Character(1) VARCHAR2(1) NOT NULL Off Day Indicator
N=Work Shift
Y=Off Shift

7 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer

8 STRT_STOP_DIFF Number(5,2) DECIMAL(4,2) NOT NULL Start Stop Time Duration

9 DESCR Character(30) VARCHAR2(30) NOT NULL Description

10 SETID Character(5) VARCHAR2(5) NOT NULL SetID

11 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
4	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift
7	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
8	STRT_STOP_DIFF	Number(5,2)	DECIMAL(4,2) NOT NULL	Start Stop Time Duration
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
11	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
12	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.