CS_NODES_VW(SQL View) |
Index Back |
---|---|
Subscribing nodes10/24/2012 RMK Added related language record |
SELECT A.MSGNODENAME , A.DESCR FROM %Table(PSMSGNODEDEFN) A WHERE A.ACTIVE_NODE = '1' AND A.LOCALNODE = 0 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SUBNODE | Character(30) | VARCHAR2(30) NOT NULL | Subscribing Node |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |