TREE_NAMESETIDSETCNTRLVALUEEFFDTDefault: %date
TREE_BRANCHLANGUAGE_CDPSTREEDEFACCVWL |
| Platform | View Text |
|---|---|
| Default | SELECT a.TREE_NAME ,a.SETID ,a.SETCNTRLVALUE ,a.EFFDT ,' ' ,b.LANGUAGE_CD ,b.DESCR FROM PSTREEDEFN A , PSTREEDEFNLANG B WHERE A.SETID = B.SETID AND A.SETCNTRLVALUE = B.SETCNTRLVALUE AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT = B.EFFDT |
| PeopleSoft Field Name | Description |
|---|---|
| TREE_NAME | Tree Name |
| SETID | SetID |
| SETCNTRLVALUE | Tree Definition User Key Value |
| EFFDT | Effective Date Default: %date |
| TREE_BRANCH | Tree Branch |
| LANGUAGE_CD | Language Code translate values |
| DESCR | Description |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |