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 NameField TypeColumn TypeDescription
CUB_DIMENSIONIDCharacter(30)VARCHAR2(30) NOT NULLDimension Name (see PSCUBDIMENSION).
CUB_SEQNUMNumber(10,0)DECIMAL(10) NOT NULLSequence Number
CUB_SRCTYPECharacter(1)VARCHAR2(1) NOT NULLCube Source Type
Q=Query
T=Tree
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID
SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
EFFDTDate(10)DATEEffective Date

Default: %date

HEADINGCharacter(30)VARCHAR2(30) NOT NULLField Heading
TREE_NODE_CHILDCharacter(20)VARCHAR2(20) NOT NULLTree Node Child
CUB_TEMPLIDCharacter(30)VARCHAR2(30) NOT NULLTemplate ID (see PSCUBTEMPL).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19