EM_USR_FLD_VW2

(SQL View)
 Index Back

eS user's field values

Used in invoice line level routing

SELECT DISTINCT OPRID , FIELDNAME FROM PS_EM_USR_FLD_VAL WHERE USE_ROUTE_FLAG = 'Y'

# 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 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: EM_USRLN_FLD_VW