MSGNODENAMEPROPNAMEPrompt Table: PSNODPROPNAMEVW
PV_NODE_METHOD(SQL View) |
Index Back |
|---|---|
Direct Connect Node View |
| SELECT A.MSGNODENAME , A.VERSION , B.PV_NV_NAME , B.PV_NV_VALUE , A.IMAGE_NAME , A.DESCR , A.DESCRLONG FROM PSMSGNODEDEFN A , PS_PV_MS_SUPP_NV B , PS_PV_MS_SUPPLIER C WHERE A.MSGNODENAME=C.PV_DC_NODE AND B.SETID=C.SETID AND B.PV_MS_SUP_TYPE=C.PV_MS_SUP_TYPE AND B.VENDOR_ID=C.VENDOR_ID AND B.VNDR_LOC=C.VNDR_LOC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MSGNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 2 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 3 | PROPNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Property Name
Prompt Table: PSNODPROPNAMEVW |
| 4 | PROPVALUE | Character(254) | VARCHAR2(254) NOT NULL | Value |
| 5 | IMAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL | The name of images used in Personalizations explanations. |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |