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

TL_MBLE_SCH_VW

(SQL View)

Mobile - Schedule View

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

SELECT EMPLID , EMPL_RCD , DUR , SHIFT_ID , EFFDT , OFFDAY_IND , PUNCH_TYPE , STRT_STOP_DIFF , DESCR , SETID , SYNCID , LASTUPDDTTM FROM PS_TL_MBLE_SCH_TMP

# 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.