TL_WC_ATTEND_VW

(SQL View)
Index Back

Attndnce Hist for TL WrkCenter

Fetches Attendance Hist for TL Fluid WrkCenter

SELECT DISTINCT A.OPRID , A.ROWSECCLASS , A.EMPLID , B.DUR , N.NAME_DISPLAY , N.LAST_NAME , N.FIRST_NAME , B.PUNCH_BEGIN , B.EXCEPTION_ID , B.ATTEND_POINTS , B.ATTEND_TOTAL , B.IN_PERIOD , E.DESCR FROM PS_TL_ADM_SRCH_VW A , PS_TL_ATTEND_HIST B , PS_NAMES N , PS_TL_EXCEPT_DEFN E WHERE A.EMPLID = B.EMPLID AND B.EXCEPTION_ID=E.EXCEPTION_ID AND %EffdtCheck(TL_EXCEPT_DEFN, E, %CurrentDateIn) AND A.EMPLID = N.EMPLID AND N.NAME_TYPE = 'PRI' AND N.EFFDT = ( SELECT MAX(SN.EFFDT) FROM PS_NAMES SN WHERE SN.EMPLID = N.EMPLID AND SN.NAME_TYPE=N.NAME_TYPE AND SN.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
8 PUNCH_BEGIN DateTime(26) TIMESTAMP Punch Time
9 EXCEPTION_ID Character(8) VARCHAR2(8) NOT NULL Exception ID
10 ATTEND_POINTS Number(6,2) DECIMAL(5,2) NOT NULL Points
11 ATTEND_TOTAL Number(6,2) DECIMAL(5,2) NOT NULL Points Accumulated
12 IN_PERIOD Character(1) VARCHAR2(1) NOT NULL In Current Attendance Period

Y/N Table Edit

13 DESCR Character(30) VARCHAR2(30) NOT NULL Description