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 NameField TypeColumn TypeDescription
DEPTIDCharacter(10)VARCHAR2(10) NOT NULLDepartment

Prompt Table: NVS_DEPT_VW

DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
DESCRSHORTCharacter(10)VARCHAR2(10) NOT NULLShort Description
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
EMAILIDCharacter(70)VARCHAR2(70) NOT NULLA user's E-mail address
EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19