TREE_LEVEL_BUVW

index back

Sample/Default Tree Level Tbl


SELECT SETID ,TREE_LEVEL ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,SETID FROM PS_TREE_LEVEL_TBL

PeopleSoft Field Name Field Type Column Type Description
SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number
EFFDT Date(10) DATE NOT NULL Effective Date

Default: %date

EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default: A

DESCR Character(30) VARCHAR2(30) NOT NULL Description
DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
SETID Character(5) VARCHAR2(5) NOT NULL SetID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19