PSCUBDIMSTRUCT

index back

Cube dimension structure.


PeopleSoft Field NameField TypeColumn TypeDescription
CUB_DIMENSIONIDCharacter(30)VARCHAR2(30) NOT NULLDimension Name (see PSCUBDIMENSION).
CUB_SEQNUMNumber(10,0)DECIMAL(10) NOT NULLSequence Number
TREE_LEVEL_NUMNumber(3,0)SMALLINT NOT NULLParent tree level if this is a part of the PSTREEBRANCH record
CUB_MEMBERCharacter(30)VARCHAR2(30) NOT NULLMember Name
CUB_CONSOLPROPCharacter(2)VARCHAR2(2) NOT NULLConsolidation Property
01=Add
02=Minus
03=Multiply
04=Divide
05=Percentage
06=None

Default: 01

CUB_EXPREPORTCharacter(1)VARCHAR2(1) NOT NULLExpense Report

Y/N Table Edit

Default: N

CUB_TIMEBALCharacter(1)VARCHAR2(1) NOT NULLTime Balance
0=None
1=First
2=Last
3=Average

Default: 0

CUB_SKIPOPTCharacter(1)VARCHAR2(1) NOT NULLSkip Option
0=None
1=Missing
2=Zeros
3=Missing and Zeros

Default: 0

CUB_LABELONLYCharacter(1)VARCHAR2(1) NOT NULLLabel Only

Y/N Table Edit

Default: N

CUB_ALIASCharacter(30)VARCHAR2(30) NOT NULLAlias Name
CUB_MEMBERSHARECharacter(1)VARCHAR2(1) NOT NULLShared Member
CUB_NEVERSHARECharacter(1)VARCHAR2(1) NOT NULLNever Share

Y/N Table Edit

Default: N

CUB_STORAGEOPTCharacter(1)VARCHAR2(1) NOT NULLData Storage
0=Default
1=Dynamic Calc
2=Dynamic Calc and Store
3=Never Share
4=Label Only

Default: 0

OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
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

CUB_SRCTYPECharacter(1)VARCHAR2(1) NOT NULLCube Source Type
Q=Query
T=Tree
CUB_DYNAMICCharacter(1)VARCHAR2(1) NOT NULLDynamic Link

Y/N Table Edit

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