TL_REPSEQ1_WRK (SQL Table)	Index Back
Submit Sequence Numbers This is a work table used in the submit process to hold the maximum sequence number for the date under report in reported elapsed time.

TL_REPSEQ1_WRK

(SQL Table)

Submit Sequence Numbers

This is a work table used in the submit process to hold the maximum sequence number for the date under report in reported elapsed time.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TL_SUBMIT_ID Character(34) VARCHAR2(34) NOT NULL This is a unique identifier used to differentiate between batches of records in the submit time process.

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

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

5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TL_SUBMIT_ID	Character(34)	VARCHAR2(34) NOT NULL	This is a unique identifier used to differentiate between batches of records in the submit time process.
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date.
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number