EX_FLT_APPR_VW

(SQL View)
Index Back

SELECT APPROVAL_OPRID ,' ' ,SHEET_ID , EMPLID FROM PS_EX_ER_APPR_VW WHERE APPR_TRANS_TYPE = 'ER'

# 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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
3 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID