EX_EE_AUT_WC_VW

(SQL View)
Index Back

Employee Authority

Used in emplid filter prompt for Expenses WorkCenter

SELECT A.EMPLID , B.NAME , A.AUTHORIZED_OPRID FROM PS_EX_EE_AUTH_TBL A , PS_PERSONAL_DATA B WHERE A.AUTHORIZED_OPRID = %OperatorId AND A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 AUTHORIZED_OPRID Character(30) VARCHAR2(30) NOT NULL Authorized User ID

Prompt Table: OPRID_VW2