PTCSPG_PGDS_VW

index back
Map fields table
SELECT '_PTCS_PTPG' , PTPG_PGRIDNAME , PTPG_DSUNIQUEFLD , PTPG_DSUNIQUEFLD , PTPG_DSCOLUMN , PTPG_AGGREGATE , PTPG_COLMNTYPE FROM PSPGMODEL WHERE PTPG_COLMNTYPE IN ('DIM','VAL')

  • Related language record: PTCSPG_PGDS_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PTCS_PARAMETERNAMECharacter(128)VARCHAR2(128) NOT NULLParameter Name
    PTCS_PNLFLDNAMECharacter(254)VARCHAR2(254) NOT NULLData Column
    PTPG_DSCOLUMNCharacter(254)VARCHAR2(254) NOT NULLData Source Columns
    PTPG_AGGREGATECharacter(3)VARCHAR2(3) NOT NULLAggregate Functions
    AVG=Average
    CNT=Count
    MAX=Maximum
    MIN=Minimum
    NON=None
    SUM=Sum
    PTPG_COLMNTYPECharacter(4)VARCHAR2(4) NOT NULLColumn Type
    DIM=Axis
    DISO=Display
    VAL=Value
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19