TL_SRCH_SCH_VW (SQL View)	Index Back
Schedule Staging Record Schedule Staging Record for Search Index and Insights

TL_SRCH_SCH_VW

(SQL View)

Schedule Staging Record

Schedule Staging Record for Search Index and Insights

SELECT EMPLID ,EMPL_RCD ,DUR ,TL_SCHED_HRS ,LASTUPDDTTM ,TL_DELETE FROM PS_TL_SRCH_SCH_TBL UNION SELECT EMPLID ,EMPL_RCD ,DUR ,TL_SCHED_HRS ,LASTUPDDTTM ,TL_DELETE FROM PS_TL_SCH_RTRG_TBL

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

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

4 TL_SCHED_HRS Number(5,2) DECIMAL(4,2) NOT NULL Scheduled Hours

5 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.
Default Value: %DATETIME

6 TL_DELETE Character(1) VARCHAR2(1) NOT NULL Delete

#	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 Record
3	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
4	TL_SCHED_HRS	Number(5,2)	DECIMAL(4,2) NOT NULL	Scheduled Hours
5	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. Default Value: %DATETIME
6	TL_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Delete