TREE_NAME_SETIDTREE_NAMEEFFDTDefault: %date
A=Active
I=Inactive
N=No
Y=Yes (default)
Y/N Table Edit
L=Loosely Enforced
N=Level Not Used
S=Strictly Enforced (default)
N=Saved As Draft (default)
Y=Saved As Valid Tree
Y/N Table Edit
PT_TREEDEFN_VW | |
View: PS_PT_TREEDEFN_VW |
| Platform | View Text |
|---|---|
| Default | SELECT %Substring(setid,1,5) , tree_name , effdt , eff_status , tree_strct_id , descr , all_values , use_levels , valid_tree FROM PSTREEDEFN |
| PeopleSoft Field Name | Description |
|---|---|
| TREE_NAME_SETID | TableSet |
| TREE_NAME | Tree Name |
| EFFDT | Effective Date Default: %date |
| EFF_STATUS | Effective Status A=Active I=Inactive |
| TREE_STRCT_ID | Tree Structure Name |
| DESCR | Description |
| ALL_VALUES | Tree Level All Values flag N=No Y=Yes (default) Y/N Table Edit |
| USE_LEVELS | Tree Definition Level Use Type L=Loosely Enforced N=Level Not Used S=Strictly Enforced (default) |
| VALID_TREE | Valid Tree N=Saved As Draft (default) Y=Saved As Valid Tree Y/N Table Edit |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |