PTCSPG_PGDS_LNG

index back
Map fields table
SELECT '_PTCS_PTPG' , A.PTPG_PGRIDNAME , A.PTPG_DSUNIQUEFLD , A.LANGUAGE_CD , A.PTPG_DSCOLUMN , B.PTPG_COLMNTYPE FROM PSPGMODELLANG A , PSPGMODEL B WHERE B.PTPG_COLMNTYPE IN ('DIM','VAL') AND A.PTPG_PGRIDNAME=B.PTPG_PGRIDNAME AND A.PTPG_DSUNIQUEFLD=B.PTPG_DSUNIQUEFLD

  • Related language record for PTCSPG_PGDS_VW
  • 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
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    PTPG_DSCOLUMNCharacter(254)VARCHAR2(254) NOT NULLData Source Columns
    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