DIM_ROLLUP

index back

Dimension Rollup


  • Parent record: DIMENSION
  • PeopleSoft Field Name Field Type Column Type Description
    DIMENSION_ID Character(30) VARCHAR2(30) NOT NULL Dimension/Measure/Attribute
    SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

    Default: 1

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    MEMBER_SOURCE Character(1) VARCHAR2(1) NOT NULL Rollup Type
    B=Tree + Queries
    Q=Queries
    T=Tree
    U=Undefined

    Default: U

    DECOR_TYPE Character(1) VARCHAR2(1) NOT NULL Decoration Type
    N=None
    P=Prefix
    S=Suffix

    Default: N

    DECOR_STYLE Character(1) VARCHAR2(1) NOT NULL Decoration Style
    C=Custom
    D=Dimension Name
    L=Level Name
    DECORATION Character(30) VARCHAR2(30) NOT NULL Custom Text
    DECOR_TYPE_DTL Character(1) VARCHAR2(1) NOT NULL Detail Decoration Type
    N=None
    P=Prefix
    S=Suffix

    Default: N

    DECOR_STYLE_DTL Character(1) VARCHAR2(1) NOT NULL Detail Decoration Style
    C=Custom
    D=Dimension Name
    L=Level Name
    DECORATION_DTL Character(30) VARCHAR2(30) NOT NULL Detail Custom Text
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19