FM_ISCR_ESP_VW

(SQL View)
 Index Back

PDF Form Properties ESP

PDF Form Properties ESP - iScript

SELECT DISTINCT A.OPRID ,%Substring(%Sql(FUNCLIB_HR_STRING_RTRIM, B.MENUNAME) %Concat '.' %Concat %Sql(FUNCLIB_HR_STRING_RTRIM, B.BARNAME) %Concat '.' %Concat %Sql(FUNCLIB_HR_STRING_RTRIM, B.BARITEMNAME) %Concat '.' %Concat %Sql(FUNCLIB_HR_STRING_RTRIM, B.PNLITEMNAME),1,96) FROM PSAUTHITEM B , PS_USERCLASS_VW A WHERE B.MENUNAME LIKE 'WEBLIB_%' AND B.CLASSID = A.CLASSID

# 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 FM_ISCRIPT_ESP Character(96) VARCHAR2(96) NOT NULL Pdf Form associated iScript ESP