NODE_FIELDNAMEPSTREESTRCTNFVW(SQL View) |
Index Back |
|---|---|
Tree Struct Node Field Name |
| SELECT A.NODE_FIELDNAME , LABL.LONGNAME ,LABL.SHORTNAME FROM PSTREESTRCT A , PSDBFLDLABL_VW LABL WHERE A.NODE_FIELDNAME = LABL.FIELDNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NODE_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Structure Node Field name |
| 2 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 3 | SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |