GPCH_FM_ISCR_VW

(SQL View)
 Index Back

GPCH_FM_ISCR_VW

LAW 2006

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 GPCH_FM_ISCRIPT Character(96) VARCHAR2(96) NOT NULL IScript Field.