PTCS_SERVICEIDPrompt Table: PSPACKAGROOT_VW
Prompt Table: PSPACKAGPATH_VW
Prompt Table: PSPACKAGCLAS_VW
PTCS_EV_SRVC_VW(SQL View) |
Index Back |
|---|---|
Event Mapping Service DefnView to storeService Definitions that can be used for Event mapping |
| SELECT ptcs_serviceid ,PTCS_SERVICENAME ,descr254 ,packageroot ,qualifypath ,appclassid FROM PSPTCSSRVDEFN WHERE ptcs_serviceurltyp ='UAPC' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTCS_SERVICEID |
Character(30) | VARCHAR2(30) NOT NULL | Services ID (see PSPTCSSRVDEFN). |
| 2 | PTCS_SERVICENAME | Character(18) | VARCHAR2(18) NOT NULL | Service Name |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
| 5 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 6 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |