PSADSDEFN

index back

ADS Data Set Definition


  • Related language record: PSADSDEFNLANG
  • PeopleSoft Field Name Field Type Column Type Description
    PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name
    PTKEYCOL1 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL2 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL3 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL4 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL5 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL6 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL7 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL8 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL9 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL10 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL11 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL12 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL13 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL14 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL15 Character(18) VARCHAR2(18) NOT NULL
    PTKEYCOL16 Character(18) VARCHAR2(18) NOT NULL
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    PTCOPYABLE Character(1) VARCHAR2(1) NOT NULL Is Copyable
    N=Not Copyable
    Y=Copyable

    Y/N Table Edit

    Default: N

    PTCOMPARABLE Character(1) VARCHAR2(1) NOT NULL Is Comparable
    N=Not Comparable
    Y=Comparable

    Y/N Table Edit

    Default: N

    PTDERVTYPE Character(4) VARCHAR2(4) NOT NULL ADS Data Set Dervation Type
    COMP=Loaded from Component
    MANU=Manually entered
    MSDM=Loaded from Messages

    Default: MANU

    PTDERVKEY1 Character(30) VARCHAR2(30) NOT NULL ADS Dervation Key 1

    Prompt Table: %EDITTABLE2

    PTDERVKEY2 Character(30) VARCHAR2(30) NOT NULL ADS Dervation Key 2

    Prompt Table: %EDITTABLE3

    PTVALIDATESTATIC Character(1) VARCHAR2(1) NOT NULL Perform Static Validations

    Y/N Table Edit

    Default: N

    PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: PSPACKAGROOT_VW

    QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    HASH_SIGNATURE Character(28) VARCHAR2(28) NOT NULL Hash Signature

    Default: 0

    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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.
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19