PNLNAMEPNLFLDIDEOEC_EMB_HELPVW(SQL View) |
Index Back |
|---|---|
Emb Help ViewUse on the manage embedded help page -- internal page used by info dev to manage content within embedded help. |
| SELECT A.pnlname , A.pnlfldid , A.message_set_nbr , A.message_nbr , B.OBJECTOWNERID FROM PSPNLFIELDEXT A , PSPNLDEFN B WHERE A.message_set_nbr <> 0 AND NOT EXISTS ( SELECT 'x' FROM PS_EOEC_EMB_HELP H WHERE H.PNLNAME = A.PNLNAME AND H.PNLFLDID = A.PNLFLDID AND H.MESSAGE_SET_NBR = A.MESSAGE_SET_NBR AND H.MESSAGE_NBR = A.MESSAGE_NBR ) AND A.PNLNAME = B.PNLNAME AND B.OBJECTOWNERID NOT IN ('PPT', 'CCF', 'CCU', 'CEO','CEI', 'CEW', 'CLT', 'CPP', 'CTP', 'TTS') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 2 | PNLFLDID |
Number(4,0) | SMALLINT NOT NULL | Page Field ID |
| 3 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 4 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 5 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |