NVS_DEPT_VW

index back

PS/nVision Demo

Record view based on Department table for demonstrating nVision Email Template and Security Template features using a Scope. The view is used as the value table in the Scope.
SELECT B.DEPTID , B.DESCR , B.DESCRSHORT , 'U:'||A.OPRID AS OPRID , A.EMAILID , A.EMPLID FROM PSOPRDEFN A , PS_DEPT_TBL B WHERE B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_DEPT_TBL B_ED WHERE B.DEPTID = B_ED.DEPTID AND B_ED.EFFDT <= SYSDATE) AND A.EMPLID = B.MANAGER_ID AND B.MANAGER_ID <> ''

PeopleSoft Field Name Field Type Column Type Description
DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: NVS_DEPT_VW

DESCR Character(30) VARCHAR2(30) NOT NULL Description
DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19