PTAI_RC_AVLBL(SQL View) |
Index Back |
|---|
| SELECT PTCS_SERVICEID ,PTCS_SERVICENAME ,DESCR254 , PORTAL_MENUNAME , PNLGRPNAME , MARKET , PNLNAME ,MSGNODENAME FROM PSPTCSSRVDEFN |
| # | 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 | PORTAL_MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name
Prompt Table: PTCSMENUDEFN_VW |
| 5 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PTCSMENUCOMP_VW |
| 6 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 7 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: PTCSPNLGROUP_VW |
| 8 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |