PSTREELOCK

index back

Prompt table for Tree Manager

This table contains an entry for all trees -- both branched trees and unbranched ones so that you can prompt for all trees and branches off of one table

PeopleSoft Field Name Field Type Column Type Description
SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_NOMETA_VW

SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
EFFDT Date(10) DATE NOT NULL Effective Date
TREE_BRANCH Character(20) VARCHAR2(20) NOT NULL Tree Branch Name
LOCK_USER_ID Character(30) VARCHAR2(30) NOT NULL Lock User Id
LAST_ACTIVITY_TIME DateTime(26) TIMESTAMP Last Activity Time
TREEDEFNCHANGED Character(1) VARCHAR2(1) NOT NULL Tree Definition Changed

Y/N Table Edit

Default: N

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19