PSCUBDYN_VW

index back

Cube dynamic objects.


SELECT CUB_DIMENSIONID , CUB_SEQNUM , CUB_SRCTYPE , QRYNAME , SETID , SETCNTRLVALUE , TREE_NAME , EFFDT , HEADING , TREE_NODE_CHILD , CUB_TEMPLID FROM PSCUBDIMSTRUCT WHERE CUB_DYNAMIC = 'Y'

PeopleSoft Field Name Field Type Column Type Description
CUB_DIMENSIONID Character(30) VARCHAR2(30) NOT NULL Dimension Name (see PSCUBDIMENSION).
CUB_SEQNUM Number(10,0) DECIMAL(10) NOT NULL Sequence Number
CUB_SRCTYPE Character(1) VARCHAR2(1) NOT NULL Cube Source Type
Q=Query
T=Tree
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
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

HEADING Character(30) VARCHAR2(30) NOT NULL Field Heading
TREE_NODE_CHILD Character(20) VARCHAR2(20) NOT NULL Tree Node Child
CUB_TEMPLID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSCUBTEMPL).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19