PSACETREE

index back

PeopleSoft Field Name Field Type Column Type Description
PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
DIMENSION_ID Character(30) VARCHAR2(30) NOT NULL Dimension/Measure/Attribute
SETID Character(5) VARCHAR2(5) NOT NULL SetID
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 Effective Date

Default: %date

TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

Prompt Table: PTATTREENODE_VW

RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
DETAILSTARTLVL Number(3,0) SMALLINT NOT NULL ACE Details Start level number
TREEDISCARDLVL Number(3,0) SMALLINT NOT NULL Tree discard level number
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19