PSCUBDIMENSION (SQL Table)	Index Back
Cube Dimensions

PSCUBDIMENSION

(SQL Table)

Cube Dimensions

Related Language Record: PSCUBDIMENLANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CUB_DIMENSIONID Character(30) VARCHAR2(30) NOT NULL Dimension Name

2 CUB_DIMTYPE Character(1) VARCHAR2(1) NOT NULL Dimension Type
A=Accounts
C=Country
D=Date-Time
S=None
T=Time
X=Attribute
Default Value: A

3 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

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRLONG Long Character CLOB Long Description

6 CUB_BLANK_MEMBER Character(30) VARCHAR2(30) NOT NULL Blank Member

7 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

8 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CUB_DIMENSIONID	Character(30)	VARCHAR2(30) NOT NULL	Dimension Name
2	CUB_DIMTYPE	Character(1)	VARCHAR2(1) NOT NULL	Dimension Type A=Accounts C=Country D=Date-Time S=None T=Time X=Attribute Default Value: A
3	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
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRLONG	Long Character	CLOB	Long Description
6	CUB_BLANK_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Blank Member
7	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
8	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
9	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.