DIMENSION

index back

Dimension


  • Related language record: DIMENSION_LANG
  • Parent record of DIM_ROLLUP
  • PeopleSoft Field Name Field Type Column Type Description
    DIMENSION_ID Character(30) VARCHAR2(30) NOT NULL Dimension/Measure/Attribute
    DIMENSION_TYPE Character(1) VARCHAR2(1) NOT NULL Dimension Type
    A=Account
    C=Country
    P=Currency Partition
    S=Standard
    T=Time
    Y=Type

    Default: S

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    BLANK_MEMBER Character(30) VARCHAR2(30) NOT NULL Blank Member
    LABEL_DECOR_TYPE Character(1) VARCHAR2(1) NOT NULL Label Prefix/Suffix
    N=None
    P=Prefix
    S=Suffix

    Default: P

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19