TL_DU_TA_RPL_VW

(SQL View)
Index Back

Reported Time Lang


SELECT A.EMPLID , A.EMPL_RCD , A.DUR , A.PUNCH_TYPE , A.PUNCH_DTTM , A.TASKGROUP , A.TASK_PROFILE_ID , A.TRC , A.TL_QUANTITY , B.XLATLONGNAME FROM PS_TL_RPTD_TIME A , XLATTABLE_LNG B WHERE B.FIELDNAME='REPORTED_STATUS' AND B. FIELDVALUE = A.REPORTED_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
4 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
5 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.
6 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup
7 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
8 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
9 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description