PSTREESELCTL

(SQL Table)
Index Back

Tree Selection Control

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
4 EFFDT Date(10) DATE NOT NULL Effective Date
5 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
6 SELECTOR_NUM Number(10,0) DECIMAL(10) NOT NULL Selector Number
7 SELECTOR_DT Date(10) DATE NOT NULL Selector Date
8 TREE_ACC_SEL_OPT Character(1) VARCHAR2(1) NOT NULL Tree Defintion Tree Access Selector Option for nVision
B=Range of Values (BETWEEN)
R=Range of Values (>=...<=)
S=Single Values

Default Value: R

9 LENGTH Number(5,0) INTEGER NOT NULL Length