PSCUBTEMPL

index back

Cube templates.


  • Related language record: PSCUBTEMPL_LNG
  • PeopleSoft Field Name Field Type Column Type Description
    CUB_TEMPLID Character(30) VARCHAR2(30) NOT NULL Template ID
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRLONG Long Character CLOB Long Description
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    CUB_CONSOLPROP Character(2) VARCHAR2(2) NOT NULL Consolidation Property
    01=Add
    02=Minus
    03=Multiply
    04=Divide
    05=Percentage
    06=None

    Default: 01

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

    Y/N Table Edit

    Default: N

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

    Default: 0

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

    Default: 0

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

    Y/N Table Edit

    Default: N

    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

    CUB_NEVERSHARE Character(1) VARCHAR2(1) NOT NULL Never Share

    Y/N Table Edit

    Default: N

    CUB_LABELOPT Character(1) VARCHAR2(1) NOT NULL Label Options
    0=Use User Text
    1=Use Query Long Label
    2=Use Short Label

    Default: 0

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