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 Name Field Type Column Type Description
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PTCS_PARAMETERNAME Character(128) VARCHAR2(128) NOT NULL Parameter Name
    PTCS_PNLFLDNAME Character(254) VARCHAR2(254) NOT NULL Data Column
    PTPG_DSCOLUMN Character(254) VARCHAR2(254) NOT NULL Data Source Columns
    PTPG_AGGREGATE Character(3) VARCHAR2(3) NOT NULL Aggregate Functions
    AVG=Average
    CDI=Count Distinct
    CNT=Count
    MAX=Maximum
    MIN=Minimum
    NON=None
    SUM=Sum
    PTPG_COLMNTYPE Character(4) VARCHAR2(4) NOT NULL Column Type
    DIM=Axis
    DISO=Display
    VAL=Value
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20