PSPGDTYPE

index back

Pivot Grid Datat Type Table


  • Related language record: PSPGDTYPELANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTPG_DSTYPECharacter(30)VARCHAR2(30) NOT NULLData Source Type
    PTPG_PGRIDTITLECharacter(30)VARCHAR2(30) NOT NULLPivot Grid Title
    DESCRLONGLong CharacterCLOBLong Description
    PTPG_USESQLTYPENumber(1,0)SMALLINT NOT NULLUse SQL Type

    Default: 1

    APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID
    PACKAGEIDCharacter(30)VARCHAR2(30) NOT NULLPackage Name (see PSDIAGREG).
    QUALIFYPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path
    ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive Flag
    A=Active
    I=Inactive

    Default: A

    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
    CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19