TL_SUMMPCH_VW

(SQL View)

SELECT C.OPRID ,A.EMPLID ,A.EMPL_RCD ,A.PUNCH_DTTM FROM PS_TL_RPTD_TIME A ,PS_TL_OPR_CLASS_VW C WHERE A.EMPLID=C.EMPLID AND A.PUNCH_TYPE <> '0' OR EXISTS ( SELECT 'X' FROM PS_TL_GRP_SECURITY D ,PS_TL_GROUP_DTL E WHERE D.GROUP_ID=E.GROUP_ID AND E.EMPLID=A.EMPLID AND E.EMPL_RCD=A.EMPL_RCD)

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

4 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.