DIM_ROLLUP

(SQL Table)
 Index Back

Dimension Rollup

  • Parent record: DIMENSION

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DIMENSION_ID Character(30) VARCHAR2(30) NOT NULL Dimension/Measure/Attribute
    2 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

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

    Default Value: U

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

    Default Value: N

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

    Default Value: N

    9 DECOR_STYLE_DTL Character(1) VARCHAR2(1) NOT NULL Detail Decoration Style
    C=Custom
    D=Dimension Name
    L=Level Name
    10 DECORATION_DTL Character(30) VARCHAR2(30) NOT NULL Detail Custom Text