PSCUBDIMSTRCOUT

(SQL Table)
Index Back

Cube dimension structure.

Expanded dimensional structures used to send information to Essbase.

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

Default Value: 01

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

Y/N Table Edit

Default Value: N

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

Default Value: 0

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

Default Value: 0

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

13 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 Value: 0

14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
15 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
16 SETID Character(5) VARCHAR2(5) NOT NULL SetID
17 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
18 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
19 EFFDT Date(10) DATE Effective Date

Default Value: %date

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

Y/N Table Edit

22 HEADING Character(30) VARCHAR2(30) NOT NULL Field Heading
23 CUB_TEMPLID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSCUBTEMPL).
24 TREE_NODE_CHILD Character(20) VARCHAR2(20) NOT NULL Tree Node Child
25 CUB_ISLEAF Character(1) VARCHAR2(1) NOT NULL Leaf Member
26 CUB_PARSEQNUM Number(10,0) DECIMAL(10) NOT NULL Sequence Number
27 CUB_FORMULA Long Character CLOB Formula