DIMENSION

index back

Dimension


  • Related language record: DIMENSION_LANG
  • Parent record of DIM_ROLLUP
  • PeopleSoft Field NameField TypeColumn TypeDescription
    DIMENSION_IDCharacter(30)VARCHAR2(30) NOT NULLDimension/Measure/Attribute
    DIMENSION_TYPECharacter(1)VARCHAR2(1) NOT NULLDimension Type
    A=Account
    C=Country
    P=Currency Partition
    S=Standard
    T=Time
    Y=Type

    Default: S

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    BLANK_MEMBERCharacter(30)VARCHAR2(30) NOT NULLBlank Member
    LABEL_DECOR_TYPECharacter(1)VARCHAR2(1) NOT NULLLabel Prefix/Suffix
    N=None
    P=Prefix
    S=Suffix

    Default: P

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