NVS_DEPT_VW (SQL View)	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.

NVS_DEPT_VW

(SQL View)

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:' %Concat %Substring(A.OPRID,1,28) , 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 <= %CurrentDateIn) AND A.EMPLID = B.MANAGER_ID AND B.MANAGER_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: NVS_DEPT_VW

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

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: NVS_DEPT_VW
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID