PSCUBDIMSTRUCT

index back

Cube dimension structure.


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
TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
CUB_MEMBER Character(30) VARCHAR2(30) NOT NULL Member Name
CUB_CONSOLPROP Character(2) VARCHAR2(2) NOT NULL Consolidation Property
01=Add
02=Minus
03=Multiply
04=Divide
05=Percentage
06=None

Default: 01

CUB_EXPREPORT Character(1) VARCHAR2(1) NOT NULL Expense Report

Y/N Table Edit

Default: N

CUB_TIMEBAL Character(1) VARCHAR2(1) NOT NULL Time Balance
0=None
1=First
2=Last
3=Average

Default: 0

CUB_SKIPOPT Character(1) VARCHAR2(1) NOT NULL Skip Option
0=None
1=Missing
2=Zeros
3=Missing and Zeros

Default: 0

CUB_LABELONLY Character(1) VARCHAR2(1) NOT NULL Label Only

Y/N Table Edit

Default: N

CUB_ALIAS Character(30) VARCHAR2(30) NOT NULL Alias Name
CUB_MEMBERSHARE Character(1) VARCHAR2(1) NOT NULL Shared Member
CUB_NEVERSHARE Character(1) VARCHAR2(1) NOT NULL Never Share

Y/N Table Edit

Default: N

CUB_STORAGEOPT Character(1) VARCHAR2(1) NOT NULL Data Storage
0=Default
1=Dynamic Calc
2=Dynamic Calc and Store
3=Never Share
4=Label Only

Default: 0

OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
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

CUB_SRCTYPE Character(1) VARCHAR2(1) NOT NULL Cube Source Type
Q=Query
T=Tree
CUB_DYNAMIC Character(1) VARCHAR2(1) NOT NULL Dynamic Link

Y/N Table Edit

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