PSCUBTEMPL

index back

Cube templates.


  • Related language record: PSCUBTEMPL_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    CUB_TEMPLIDCharacter(30)VARCHAR2(30) NOT NULLTemplate ID
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRLONGLong CharacterCLOBLong Description
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    CUB_CONSOLPROPCharacter(2)VARCHAR2(2) NOT NULLConsolidation Property
    01=Add
    02=Minus
    03=Multiply
    04=Divide
    05=Percentage
    06=None

    Default: 01

    CUB_EXPREPORTCharacter(1)VARCHAR2(1) NOT NULLExpense Report

    Y/N Table Edit

    Default: N

    CUB_TIMEBALCharacter(1)VARCHAR2(1) NOT NULLTime Balance
    0=None
    1=First
    2=Last
    3=Average

    Default: 0

    CUB_SKIPOPTCharacter(1)VARCHAR2(1) NOT NULLSkip Option
    0=None
    1=Missing
    2=Zeros
    3=Missing and Zeros

    Default: 0

    CUB_LABELONLYCharacter(1)VARCHAR2(1) NOT NULLLabel Only

    Y/N Table Edit

    Default: N

    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

    CUB_NEVERSHARECharacter(1)VARCHAR2(1) NOT NULLNever Share

    Y/N Table Edit

    Default: N

    CUB_LABELOPTCharacter(1)VARCHAR2(1) NOT NULLLabel Options
    0=Use User Text
    1=Use Query Long Label
    2=Use Short Label

    Default: 0

    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.
    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.
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19