PSCUBDIMENSION

index back

Cube Dimensions


  • Related language record: PSCUBDIMENLANG
  • PeopleSoft Field Name Field Type Column Type Description
    CUB_DIMENSIONID Character(30) VARCHAR2(30) NOT NULL Dimension Name
    CUB_DIMTYPE Character(1) VARCHAR2(1) NOT NULL Dimension Type
    A=Accounts
    C=Country
    D=Date-Time
    S=None
    T=Time
    X=Attribute

    Default: A

    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

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRLONG Long Character CLOB Long Description
    CUB_BLANK_MEMBER Character(30) VARCHAR2(30) NOT NULL Blank Member
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    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.
    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.
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19