EX_EE_VALID2_VW (SQL View)	Index Back
Expenses Authority View For adding new Time Reports through Travel and Expense Menu

EX_EE_VALID2_VW

(SQL View)

Expenses Authority View

For adding new Time Reports through Travel and Expense Menu

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

# 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

#	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