TL_ST_MINMAXDT2 (SQL View)	Index Back
Work table for Submit Time This table is used to store the Max Sequence for every day within a range of submitted time days for every EMPLID/EMPL_RCD/DUR

TL_ST_MINMAXDT2

(SQL View)

Work table for Submit Time

This table is used to store the Max Sequence for every day within a range of submitted time days for every EMPLID/EMPL_RCD/DUR

SELECT A.ST_INSTANCE , A.EMPLID , A.EMPL_RCD , MIN(A.MIN_DATE) , MAX(A.MAX_DATE) FROM PS_TL_ST_MINMAXDTS A GROUP BY A.ST_INSTANCE , A.EMPLID , A.EMPL_RCD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Session Number

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

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

4 MIN_DATE Date(10) DATE Minimum Date

5 MAX_DATE Date(10) DATE Maximum Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ST_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Session Number
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	MIN_DATE	Date(10)	DATE	Minimum Date
5	MAX_DATE	Date(10)	DATE	Maximum Date