EX_SPRV_KIB_VW (SQL View)	Index Back
Expenses Supervisor Name View Expense Supervisor Name View for Insights

EX_SPRV_KIB_VW

(SQL View)

Expenses Supervisor Name View

Expense Supervisor Name View for Insights

SELECT A.SHEET_ID, A.APPROVAL_OPRID , A.NAME FROM PS_EX_APRV_KIB_VW A WHERE A.APPROVAL_OPRID IN ( SELECT B.OPRID FROM PS_EX_EE_JOB_DT_VW C , PSOPRDEFN B WHERE C.SUPERVISOR_ID = B.EMPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID

2 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
2	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name