PPK_APPROVER_VW

(SQL View)

SELECT A.OPRID , A.EMPLID , B.NAME FROM %Table(PSOPRDEFN) A , %Table(PERSONAL_DATA) B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BC_APPROVER_ID Character(30) VARCHAR2(30) NOT NULL Operator ID for the approver

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

3 BC_APPROVER Character(50) VARCHAR2(50) NOT NULL Approver of Project Request.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BC_APPROVER_ID	Character(30)	VARCHAR2(30) NOT NULL	Operator ID for the approver
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	BC_APPROVER	Character(50)	VARCHAR2(50) NOT NULL	Approver of Project Request.