TL_TR_PROCLIST

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUBMIT_ID Character(34) VARCHAR2(34) NOT NULL Submit ID is used as a high level key to allow concurrent online and batch processes to use the same work data store without conflict. Generally, the Submit ID is composed of the concatenation of OPRID and current date/time stamp, but any unique id will do.

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

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

4 FROM_DT Date(10) DATE From Date

5 TO_DT Date(10) DATE To Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUBMIT_ID	Character(34)	VARCHAR2(34) NOT NULL	Submit ID is used as a high level key to allow concurrent online and batch processes to use the same work data store without conflict. Generally, the Submit ID is composed of the concatenation of OPRID and current date/time stamp, but any unique id will do.
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	FROM_DT	Date(10)	DATE	From Date
5	TO_DT	Date(10)	DATE	To Date