PSCUBDYN_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 CUB_DIMENSIONID Character(30) VARCHAR2(30) NOT NULL Dimension Name (see PSCUBDIMENSION).
2 CUB_SEQNUM Number(10,0) DECIMAL(10) NOT NULL Sequence Number
3 CUB_SRCTYPE Character(1) VARCHAR2(1) NOT NULL Cube Source Type
Q=Query
T=Tree
4 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
5 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
6 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
7 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
8 EFFDT Date(10) DATE Effective Date

Default Value: %date

9 HEADING Character(30) VARCHAR2(30) NOT NULL Field Heading
10 TREE_NODE_CHILD Character(20) VARCHAR2(20) NOT NULL Tree Node Child
11 CUB_TEMPLID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSCUBTEMPL).