PSCUBDIMENSION

index back

Cube Dimensions


  • Related language record: PSCUBDIMENLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    CUB_DIMENSIONIDCharacter(30)VARCHAR2(30) NOT NULLDimension Name
    CUB_DIMTYPECharacter(1)VARCHAR2(1) NOT NULLDimension Type
    A=Accounts
    C=Country
    D=Date-Time
    S=None
    T=Time
    X=Attribute

    Default: A

    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

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRLONGLong CharacterCLOBLong Description
    CUB_BLANK_MEMBERCharacter(30)VARCHAR2(30) NOT NULLBlank Member
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19