TREE_NAME_SETIDTREE_NAMEEFFDTDefault Value: %date
A=Active
I=Inactive
Y/N Table Edit
Default Value: Y
L=Loosely Enforced
N=Level Not Used
S=Strictly Enforced
Default Value: S
N=Draft Tree
Y=Valid Tree
Y/N Table Edit
Default Value: N
TREEDEFN_VW(SQL View) |
Index Back |
|---|---|
Tree Definition & AttributesTree Definition & Attributes |
| 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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NAME_SETID |
Character(5) | VARCHAR2(5) NOT NULL | TableSet |
| 2 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | TREE_STRCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Tree Structure Name (see PSTREESTRCT). |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | ALL_VALUES | Character(1) | VARCHAR2(1) NOT NULL |
Tree Level All Values flag
Y/N Table Edit Default Value: Y |
| 8 | USE_LEVELS | Character(1) | VARCHAR2(1) NOT NULL |
Tree Definition Level Use Type
L=Loosely Enforced N=Level Not Used S=Strictly Enforced Default Value: S |
| 9 | VALID_TREE | Character(1) | VARCHAR2(1) NOT NULL |
Valid Tree
N=Draft Tree Y=Valid Tree Y/N Table Edit Default Value: N |