TL_WV_EE_GROUP (SQL View)	Index Back
eTime Employee Search View intended for use by eTime Daily, Weekly and Monthly calendars. The view returns the employee names and job titles for each employee and job that the operator has access to. Access is determined by the TL Group Security defined for the Operator's Row Security Class. When the Operator's Row Security Class has no specific Group Security, HR Department Security is used to determine access.

TL_WV_EE_GROUP

(SQL View)

eTime Employee Search

View intended for use by eTime Daily, Weekly and Monthly calendars. The view returns the employee names and job titles for each employee and job that the operator has access to. Access is determined by the TL Group Security defined for the Operator's Row Security Class. When the Operator's Row Security Class has no specific Group Security, HR Department Security is used to determine access.

SELECT O.CLASSID , E.EMPLID , E.EMPL_RCD ,F.GROUP_ID , B.NAME , E.TIME_RPTG_STATUS , A.SETID_JOBCODE , A.JOBCODE , J.DESCR , E.WORKGROUP , E.TIME_RPTR_IND FROM %Table(JOB) A , %Table(TL_EMPL_DATA) E , PSCLASSDEFN O , %Table(TL_GRP_SECURITY) S , %Table(TL_GROUP_DTL) F , %Table(PERSON_NAME) B , %Table(JOBCODE_TBL) J WHERE E.EMPLID = F.EMPLID AND E.EMPLID = A.EMPLID AND B.EMPLID = A.EMPLID AND E.EMPL_RCD = F.EMPL_RCD AND E.EMPL_RCD = A.EMPL_RCD AND J.SETID= A.SETID_JOBCODE AND J.JOBCODE = A.JOBCODE AND J.EFF_STATUS = 'A' AND %EffdtCheck(JOBCODE_TBL, J, %CurrentDateIn) AND %EffdtCheck(TL_EMPL_DATA, E, %CurrentDateIn) AND O.CLASSID = S.ROWSECCLASS AND S.GROUP_ID = F.GROUP_ID AND A.EFFDT=( SELECT MAX(EFFDT) FROM PS_JOB JOB WHERE JOB.EMPLID=A.EMPLID AND JOB.EMPL_RCD=A.EMPL_RCD AND JOB.EFFDT<=%CurrentDateIn) AND A.EFFSEQ =( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = A.EMPLID AND J2.EMPL_RCD = A.EMPL_RCD AND J2.EFFDT = A.EFFDT )

Related Language Record: TL_WV_EEGRP_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

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

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

4 GROUP_ID Character(5) VARCHAR2(5) NOT NULL Group ID

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 TIME_RPTG_STATUS Character(1) VARCHAR2(1) NOT NULL Time Reporter Status
A=Active
I=Inactive

7 SETID Character(5) VARCHAR2(5) NOT NULL SetID

8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

9 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description

10 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup

11 TIME_RPTR_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether a Time Reporter is primarily reports Elapsed Time or Punch Time.
E=Elapsed Time Reporter
P=Punch Time Reporter

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GROUP_ID	Character(5)	VARCHAR2(5) NOT NULL	Group ID
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	TIME_RPTG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Time Reporter Status A=Active I=Inactive
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
9	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description
10	WORKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Workgroup
11	TIME_RPTR_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether a Time Reporter is primarily reports Elapsed Time or Punch Time. E=Elapsed Time Reporter P=Punch Time Reporter