IB_OPERATIONNAMELANGUAGE_CDPTFP_GFEED_LVW(SQL View) |
Index Back |
|---|---|
Generic Feed Svc OperationsGeneric feed Service operations view. This is also the search record for PTFP_GENERIC_FEED component. |
| SELECT E.IB_OPERATIONNAME , E.LANGUAGE_CD , E.DESCR FROM PSOPERATION A , PSOPRVERDFNPARM B , PSOPRVERDFN D , PSOPERATIONLANG E WHERE A.IB_OPERATIONNAME= B.IB_OPERATIONNAME AND A.IB_OPERATIONNAME= D.IB_OPERATIONNAME AND A.IB_OPERATIONNAME= E.IB_OPERATIONNAME AND A.DEFAULTVER= B.VERSIONNAME AND A.DEFAULTVER= D.VERSIONNAME AND B.MSGNAME<>'PT_FEED_REQUEST' AND B.PARAMETERNAME='REQUEST' AND A.RTNGTYPE ='A' AND D.ACTIVE_FLAG='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_OPERATIONNAME |
Character(30) | VARCHAR2(30) NOT NULL | Service Operation (see PSOPERATION). |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |