TL_PRCS_QUEUE

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TL_PRCS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 TL_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Time and Labor Process Types
0=Submit Time
1=Time Validation

3 TL_PRCS_START_DTTM DateTime(26) TIMESTAMP Process Start Datetime

4 TL_PRCS_END_DTTM DateTime(26) TIMESTAMP Process End Datetime

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TL_PRCS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TL_PROCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Time and Labor Process Types 0=Submit Time 1=Time Validation
3	TL_PRCS_START_DTTM	DateTime(26)	TIMESTAMP	Process Start Datetime
4	TL_PRCS_END_DTTM	DateTime(26)	TIMESTAMP	Process End Datetime
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50