TL_DU_TA_EX_VW

(SQL View)
Index Back

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 Record
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
ST=Submit Time
TA=Time Administration
TS=Timesheet
6 MSG_DATA1 Character(100) VARCHAR2(100) NOT NULL Message Data Text 1