EX_EE_AUTH_VW3 (SQL View)	Index Back
Expenses Authority View View for adding Expense Report or Travel Authorization under Employee Self Service.

EX_EE_AUTH_VW3

(SQL View)

Expenses Authority View

View for adding Expense Report or Travel Authorization under Employee Self Service.

SELECT B.AUTHORIZED_OPRID , A.EMPLID , A.NAME FROM PS_PERSONAL_DATA A , PS_EX_EE_AUTH_TBL B , PS_EX_AA_EE_ORG_VW C WHERE (C.EMPL_STATUS = 'A' OR (C.EMPL_STATUS IN ('I', 'L', 'P', 'U', 'V', 'T', 'W', 'Q','R','X') AND (C.TERMINATION_DT IS NULL OR %CurrentDateIn <= %DateAdd(C.TERMINATION_DT, C.EXP_RPT_LIMIT)))) AND C.EE_VAL_FLG = 'Y' AND C.EMPLID = A.EMPLID AND B.EMPLID = A.EMPLID AND B.EE_AUTH_LEVEL <> 'V'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name