TL_ST_MINMAXDTS (SQL Table)	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_MINMAXDTS

(SQL Table)

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

# 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 RTIME_TYPE Character(1) VARCHAR2(1) NOT NULL Reported Time Type
E=Elapsed Time
P=Punch Time

5 MIN_DATE Date(10) DATE Minimum Date

6 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	RTIME_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Reported Time Type E=Elapsed Time P=Punch Time
5	MIN_DATE	Date(10)	DATE	Minimum Date
6	MAX_DATE	Date(10)	DATE	Maximum Date