TL_DU_TA_EX_VW (SQL View)	Index Back
Employee Payable time details

TL_DU_TA_EX_VW

(SQL View)

Employee Payable time details

SELECT A.EXCEPTION_ID , A.EMPLID , A.EMPL_RCD , A.DUR , A.EXCEPTION_SOURCE , A.MSG_DATA1 FROM PS_TL_EXCEPTION A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXCEPTION_ID Character(8) VARCHAR2(8) NOT NULL Exception ID

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

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

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

5 EXCEPTION_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the process which generated the Exception.
LD=Labor Distribution/Dilution
PI=Payroll Interface
TA=Time Administration
TVE=Time Validation Elapsed
TVP=Time Validation Punch

6 MSG_DATA1 Character(100) VARCHAR2(100) NOT NULL Message Data Text 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXCEPTION_ID	Character(8)	VARCHAR2(8) NOT NULL	Exception ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
5	EXCEPTION_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the process which generated the Exception. LD=Labor Distribution/Dilution PI=Payroll Interface TA=Time Administration TVE=Time Validation Elapsed TVP=Time Validation Punch
6	MSG_DATA1	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 1