OPRIDGPDE_FM_ISCRIPTGPDE_FM_ISCR_VW(SQL View) |
Index Back |
|---|---|
CT Iscript ViewGerman Certificate Iscirpt Work View |
| 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 | GPDE_FM_ISCRIPT |
Character(96) | VARCHAR2(96) NOT NULL | Function Container for Iscript |