index back

ADS Data Set Definition

  • Related language record: PSADSDEFNLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTADSNAMECharacter(30)VARCHAR2(30) NOT NULLData Set Name
    PTKEYCOL1Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL2Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL3Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL4Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL5Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL6Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL7Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL8Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL9Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL10Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL11Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL12Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL13Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL14Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL15Character(18)VARCHAR2(18) NOT NULL
    PTKEYCOL16Character(18)VARCHAR2(18) NOT NULL
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    PTCOPYABLECharacter(1)VARCHAR2(1) NOT NULLIs Copyable
    N=Not Copyable

    Y/N Table Edit

    Default: N

    PTCOMPARABLECharacter(1)VARCHAR2(1) NOT NULLIs Comparable
    N=Not Comparable

    Y/N Table Edit

    Default: N

    PTDERVTYPECharacter(4)VARCHAR2(4) NOT NULLADS Data Set Dervation Type
    COMP=Loaded from Component
    MANU=Manually entered
    MSDM=Loaded from Messages

    Default: MANU

    PTDERVKEY1Character(30)VARCHAR2(30) NOT NULLADS Dervation Key 1

    Prompt Table: %EDITTABLE2

    PTDERVKEY2Character(30)VARCHAR2(30) NOT NULLADS Dervation Key 2

    Prompt Table: %EDITTABLE3

    PTVALIDATESTATICCharacter(1)VARCHAR2(1) NOT NULLPerform Static Validations

    Y/N Table Edit

    Default: N

    PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID

    Prompt Table: PSPACKAGROOT_VW

    QUALIFYPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID
    HASH_SIGNATURECharacter(28)VARCHAR2(28) NOT NULLHash Signature

    Default: 0

    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    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.
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19